This procedure accepts no parameters. This procedure is intended to be used as part of the Asynchronous Promotion Processing workflow. This procedure should be scheduled to run as often as your organization requires and processes any rows present in the local table LT_M2_PROMOTION_UPDATE. This procedure does the following actions:
- Retrieves any stored promotion actions from LT_M2_PROMOTION_UPDATE that need to be updated in Tessitura's native T_PROMOTION table.
- Updates the promotions as required.
- Truncates LT_M2_PROMOTION_UPDATE and logs any promotions processed as part of this process in LT_M2_PROMOTION_LOG
- Deletes any rows in the LT_M2_PROMOTION_LOG table that are older than 3 months.