APPS.PO_SYNC_DRAFT_FROM_ARCHIVE_PVT dependencies on PO_PRICE_DIFF_DRAFT

Line 177: --Deleting from po_price_diff_draft

173:
174: DELETE FROM po_attribute_values_tlp_draft
175: WHERE draft_id = p_draft_id;
176:
177: --Deleting from po_price_diff_draft
178: DELETE FROM po_price_diff_draft
179: WHERE entity_type in ('PO LINE','BLANKET LINE','PRICE BREAK')
180: AND draft_id = p_draft_id;
181:

Line 178: DELETE FROM po_price_diff_draft

174: DELETE FROM po_attribute_values_tlp_draft
175: WHERE draft_id = p_draft_id;
176:
177: --Deleting from po_price_diff_draft
178: DELETE FROM po_price_diff_draft
179: WHERE entity_type in ('PO LINE','BLANKET LINE','PRICE BREAK')
180: AND draft_id = p_draft_id;
181:
182: --Deleting po_price_adjustments_draft

Line 2123: INSERT INTO po_price_diff_draft

2119: IF (PO_LOG.d_stmt) THEN
2120: PO_LOG.stmt(d_module, d_position, 'transfer records from archive to dft');
2121: END IF;
2122:
2123: INSERT INTO po_price_diff_draft
2124: (
2125: draft_id,
2126: delete_flag,
2127: change_accepted_flag,