Insert into Deal Calculation Queue (ditinsrt)
|
Module Name |
ditinsrt.pc |
|
Description |
Insert into Deal Calculation Queue |
|
Functional Area |
Deals |
|
Module Type |
Business Processing |
|
Module Technology |
ProC |
|
Catalog ID |
RMS217 |
|
Wrapper Script |
N/A |
Design Overview
This batch program will populate the DEAL_CALC_QUEUE table with orders that may be affected by non vendor-funded, non PO-specific deals that are on the DEAL_QUEUE table (for future processing by orddscnt.pc).
Orders that had been applied to deals that no longer apply will also be inserted into the DEAL_CALC_QUEUE table. Processed records will then be deleted from the DEAL_QUEUE table
Restart/Recovery
A commit occurs when all details of a deal are processed.
Inherent restart/recovery is achieved through deleting deals from the DEAL_QUEUE table when they are processed. Because DEAL_QUEUE is part of the driving cursor, processed deals will not be fetched again when the program restarts.