[Home] [Help]
152: ,a.PRICE_ADJ_ASSOC_ID
153: ,a.LINE_ID
154: ,a.RLTD_PRICE_ADJ_ID
155: ,a.LOCK_CONTROL
156: from oe_price_adj_Assocs a, oe_price_adjustments b
157: where a.price_adjustment_id = p_price_adjustment_id
158: and a.rltd_price_adj_id = b.price_adjustment_id
159: and b.list_line_type_code in ('SUR','DIS');
160: I PLS_INTEGER;
3508: --bug3528335 moving the following DELETE statement before deletion of the parent and checking for PBH.
3509: --bug3405372 deleting the child lines of PBH modifiers as well
3510: DELETE FROM OE_PRICE_ADJUSTMENTS
3511: WHERE PRICE_ADJUSTMENT_ID IN (SELECT RLTD_PRICE_ADJ_ID
3512: FROM OE_PRICE_ADJ_ASSOCS ASSOCS,
3513: OE_PRICE_ADJUSTMENTS PARENT
3514: WHERE ASSOCS.PRICE_ADJUSTMENT_ID=PARENT.PRICE_ADJUSTMENT_ID
3515: AND PARENT.PRICE_ADJUSTMENT_ID=p_price_adjustment_id
3516: AND PARENT.LIST_LINE_TYPE_CODE='PBH');
5691: -- Get all PRG lines
5692: Cursor prg_lines is
5693: select adj1.line_id, assoc.rltd_price_adj_id
5694: from oe_price_adjustments adj1,
5695: oe_price_adj_assocs assoc,
5696: oe_price_adjustments adj2,
5697: oe_order_lines_all line
5698: where adj1.price_adjustment_id = assoc.rltd_price_adj_id AND
5699: assoc.price_adjustment_id = adj2.price_adjustment_id AND
5787: oe_debug_pub.add( 'PRICE ADJ ID = ' || I.PRICE_ADJUSTMENT_ID ) ;
5788: END IF;
5789: OE_LINE_ADJ_UTIL.DELETE_ROW(p_price_adjustment_id => i.price_adjustment_id);
5790:
5791: DELETE FROM OE_PRICE_ADJ_ASSOCS WHERE PRICE_ADJUSTMENT_ID = i.price_adjustment_id;
5792: END LOOP;
5793: BEGIN
5794: l_delete_prg := 'N';
5795: SELECT price_adj_assoc_id INTO l_dummy from oe_price_adj_assocs
5791: DELETE FROM OE_PRICE_ADJ_ASSOCS WHERE PRICE_ADJUSTMENT_ID = i.price_adjustment_id;
5792: END LOOP;
5793: BEGIN
5794: l_delete_prg := 'N';
5795: SELECT price_adj_assoc_id INTO l_dummy from oe_price_adj_assocs
5796: WHERE rltd_price_adj_id = l_rltd_price_adj_id and rownum < 2;
5797: exception
5798: WHEN NO_DATA_FOUND THEN
5799: l_delete_prg := 'Y';
6598: Procedure Set_PRG_Cache(p_header_id IN NUMBER) AS
6599: Cursor prg_cur is
6600: select adj1.line_id line_id
6601: from oe_price_adjustments adj1,
6602: oe_price_adj_assocs assoc,
6603: oe_price_adjustments adj2
6604: where adj1.price_adjustment_id = assoc.rltd_price_adj_id AND
6605: assoc.price_adjustment_id = adj2.price_adjustment_id AND
6606: adj2.list_line_type_code = 'PRG' AND