DBA Data[Home] [Help]

APPS.PO_SYNC_DRAFT_FROM_ARCHIVE_PVT dependencies on PO_PRICE_ADJ_ATTRIBS_DRAFT

Line 186: DELETE FROM po_price_adj_attribs_draft

182: --Deleting po_price_adjustments_draft
183: DELETE FROM po_price_adjustments_draft
184: WHERE draft_id = p_draft_id;
185:
186: DELETE FROM po_price_adj_attribs_draft
187: WHERE draft_id = p_draft_id;
188:
189: --Deleting from po_notification_ctrl_draft
190: DELETE FROM po_notification_ctrl_draft

Line 3629: -- PO_PRICE_ADJ_ATTRIBS_DRAFT

3625: --Name: sync_price_adj_attribs
3626: --Pre-reqs:
3627: -- None.
3628: --Modifies:
3629: -- PO_PRICE_ADJ_ATTRIBS_DRAFT
3630: --Locks:
3631: -- None.
3632: --Function:
3633: -- Sync Price Adjustment Attributes

Line 3666: INSERT INTO PO_PRICE_ADJ_ATTRIBS_DRAFT

3662: IF (PO_LOG.d_stmt) THEN
3663: PO_LOG.stmt(d_module, d_position, 'transfer records from archive to dft');
3664: END IF;
3665:
3666: INSERT INTO PO_PRICE_ADJ_ATTRIBS_DRAFT
3667: (DRAFT_ID
3668: , PRICE_ADJUSTMENT_ID
3669: , PRICING_CONTEXT
3670: , PRICING_ATTRIBUTE