[Home] [Help]
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
183: DELETE FROM po_price_adjustments_draft
184: WHERE draft_id = p_draft_id;
185:
186: DELETE FROM po_price_adj_attribs_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
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;
3353: --Name: sync_price_adjustments
3354: --Pre-reqs:
3355: -- None.
3356: --Modifies:
3357: -- PO_PRICE_ADJUSTMENTS_DRAFT
3358: --Locks:
3359: -- None.
3360: --Function:
3361: -- Sync Price Adjustments
3390: IF (PO_LOG.d_stmt) THEN
3391: PO_LOG.stmt(d_module, d_position, 'transfer records from archive to dft');
3392: END IF;
3393:
3394: INSERT INTO PO_PRICE_ADJUSTMENTS_DRAFT
3395: (DRAFT_ID
3396: , DELETE_FLAG
3397: , CHANGE_ACCEPTED_FLAG
3398: , CHANGE_STATUS
3593: , ADJ.ac_attribute15
3594: , ADJ.operand_per_pqty
3595: , ADJ.adjusted_amount_per_pqty
3596: , 1
3597: FROM PO_PRICE_ADJUSTMENTS_ARCHIVE ADJ,
3598: PO_LINES_ALL POL
3599: WHERE ADJ.po_line_id = POL.po_line_id
3600: AND POL.po_header_id = p_document_id
3601: AND ADJ.revision_num = p_revision_num;
3704: , ATTR.flex_title
3705: , ATTR.price_adj_attrib_id
3706: , 1
3707: FROM PO_PRICE_ADJ_ATTRIBS_ARCHIVE ATTR,
3708: PO_PRICE_ADJUSTMENTS ADJ,
3709: PO_LINES_ALL POL
3710: WHERE ATTR.price_adjustment_id = ADJ.price_adjustment_id
3711: AND ADJ.po_line_id = POL.po_line_id
3712: AND POL.po_header_id = p_document_id