PRO_ERPMERGEBASESISDELIVER (procedure)
- Type: PROCEDURE
- Deterministic: NO
- SQL data access: CONTAINS SQL
Parameters
| # | Mode | Name | Type |
|---|---|---|---|
| 1 | IN | sSisDeliverId |
varchar(100) |
Body
Body is not pre-cached. To inspect: mysql --defaults-file=~/.my.cnf -e 'SHOW CREATE PROCEDUREPROERPMERGEBASESISDELIVER'._
Narrative
Business context: Base data — 送货方式 / 物流 (Deliver method). When a row in SISDELIVER (the shipping-method dictionary referenced by sales orders and work orders) is renamed, this proc rewrites the denormalized sDeliverName on every historical row that references the dictionary entry.
What it does: reads sName from SISDELIVER for the given id, then UPDATEs sDeliverName on ERPMERGEWORKORDER and ERPMERGESALSALESORDER rows whose sDeliverId = sSisDeliverId. (Production-report does not carry a deliver-id column.)
Invocation: member of the PRO_ERPMERGEBASE* denorm-merge family. Called by ProDao.proErpMergeBaseSisDeliver(map) via MyBatis CALLABLE mapper ProMapper.xml, driven from ChangeSisDeliverServiceImpl.changeTableData() after the JMS CHANGE_GDS_MODULE consumer detects a SISDELIVER row mutation. See Cache invalidation on metadata change.