APPS.PO_PRICE_ADJ_DRAFT_PKG dependencies on PO_PRICE_ADJUSTMENTS_DRAFT

Line 52: DELETE FROM po_price_adjustments_draft

48: DELETE FROM po_price_adj_attribs_draft
49: WHERE draft_id = p_draft_id
50: AND price_adjustment_id = NVL(p_price_adjustment_id, price_adjustment_id);
51:
52: DELETE FROM po_price_adjustments_draft
53: WHERE draft_id = p_draft_id
54: AND price_adjustment_id = NVL(p_price_adjustment_id, price_adjustment_id);
55:
56: d_position := 10;

Line 146: INSERT INTO PO_PRICE_ADJUSTMENTS_DRAFT

142: PO_LOG.stmt(d_module, d_position, 'transfer records from txn to dft');
143: END IF;
144:
145: FORALL i IN 1..p_price_adjustment_id_tbl.COUNT
146: INSERT INTO PO_PRICE_ADJUSTMENTS_DRAFT
147: (DRAFT_ID
148: , DELETE_FLAG
149: , CHANGE_ACCEPTED_FLAG
150: , PRICE_ADJUSTMENT_ID

Line 357: UPDATE po_price_adjustments_draft

353: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);
354: END IF;
355:
356: FORALL i IN 1..p_price_adjustment_id_tbl.COUNT
357: UPDATE po_price_adjustments_draft
358: SET delete_flag = p_delete_flag_tbl(i)
359: WHERE (price_adjustment_id = p_price_adjustment_id_tbl(i)
360: OR parent_adjustment_id = p_price_adjustment_id_tbl(i))
361: AND draft_id = p_draft_id_tbl(i)

Line 641: FROM po_price_adjustments_draft ADJD

637: -- Delete only records that have not been rejected
638: DELETE FROM po_price_adjustments ADJ
639: WHERE ADJ.price_adjustment_id IN
640: ( SELECT ADJD.price_adjustment_id
641: FROM po_price_adjustments_draft ADJD
642: WHERE ADJD.draft_id = p_draft_id
643: AND ADJD.delete_flag = 'Y'
644: AND NVL(ADJD.change_accepted_flag, 'Y') = 'Y')
645: RETURNING ADJ.price_adjustment_id BULK COLLECT INTO l_price_adjustment_id_tbl;

Line 649: UPDATE po_price_adjustments_draft ADJD

645: RETURNING ADJ.price_adjustment_id BULK COLLECT INTO l_price_adjustment_id_tbl;
646:
647: /*
648: --Set the Delete Flag to Y for the child price break lines if the price break header is marked for deletion
649: UPDATE po_price_adjustments_draft ADJD
650: SET delete_flag = 'Y'
651: WHERE EXISTS (SELECT 1
652: FROM po_price_adjustments_draft DADJD
653: WHERE DADJD.price_adjustment_id = ADJD.parent_adjustment_id

Line 652: FROM po_price_adjustments_draft DADJD

648: --Set the Delete Flag to Y for the child price break lines if the price break header is marked for deletion
649: UPDATE po_price_adjustments_draft ADJD
650: SET delete_flag = 'Y'
651: WHERE EXISTS (SELECT 1
652: FROM po_price_adjustments_draft DADJD
653: WHERE DADJD.price_adjustment_id = ADJD.parent_adjustment_id
654: AND DADJD.delete_flag = 'Y');
655: */
656: --Delete Child adjustment lines

Line 665: FROM po_price_adjustments_draft ADJD

661: --Delete the attributes corresponding to the lines that are marked for deletion
662: DELETE FROM po_price_adj_attribs ATTR
663: WHERE ATTR.price_adjustment_id IN
664: (SELECT ADJD.price_adjustment_id
665: FROM po_price_adjustments_draft ADJD
666: WHERE ADJD.draft_id = p_draft_id
667: --AND ADJD.delete_flag = 'Y' --delete all attributes irrespective of the flag
668: AND NVL(ADJD.change_accepted_flag, 'Y') = 'Y');
669:

Line 770: FROM po_price_adjustments_draft DFT

766: , DFT.ac_attribute14
767: , DFT.ac_attribute15
768: , DFT.operand_per_pqty
769: , DFT.adjusted_amount_per_pqty
770: FROM po_price_adjustments_draft DFT
771: WHERE DFT.draft_id = p_draft_id
772: AND NVL(DFT.change_accepted_flag, 'Y') = 'Y') ADJD
773: ON (ADJ.price_adjustment_id = ADJD.price_adjustment_id)
774: WHEN MATCHED THEN

Line 1107: ,po_price_adjustments_draft ADJD

1103: , ATTR.flex_title
1104: , ATTR.price_adj_attrib_id
1105: , 1
1106: FROM po_price_adj_attribs_draft ATTR
1107: ,po_price_adjustments_draft ADJD
1108: WHERE ADJD.draft_id = p_draft_id
1109: AND ADJD.draft_id = ATTR.draft_id
1110: AND ADJD.price_adjustment_id = ATTR.price_adjustment_id
1111: AND NVL(ADJD.delete_flag, 'N') <> 'Y'

Line 1162: FROM po_price_adjustments_draft

1158: END IF;
1159:
1160: SELECT 1
1161: INTO l_dummy
1162: FROM po_price_adjustments_draft
1163: WHERE price_adjustment_id = p_price_adjustment_id
1164: AND draft_id = p_draft_id
1165: FOR UPDATE NOWAIT;
1166: