APPS.OE_ORDER_PURGE_PVT dependencies on OE_PRICE_ADJ_ASSOCS

Line 2720: FROM OE_PRICE_ADJ_ASSOCS OPAA

2716: WHERE price_adjustment_id = p_price_adjustment_id;
2717:
2718: CURSOR c_price_adj_assocs(p_price_adjustment_id NUMBER) IS
2719: SELECT price_adj_assoc_id
2720: FROM OE_PRICE_ADJ_ASSOCS OPAA
2721: WHERE opaa.rltd_price_adj_id IN (SELECT TO_NUMBER (p_price_adjustment_id)
2722: FROM DUAL
2723: UNION ALL
2724: SELECT opaa1.rltd_price_adj_id

Line 2725: FROM oe_price_adj_assocs opaa1

2721: WHERE opaa.rltd_price_adj_id IN (SELECT TO_NUMBER (p_price_adjustment_id)
2722: FROM DUAL
2723: UNION ALL
2724: SELECT opaa1.rltd_price_adj_id
2725: FROM oe_price_adj_assocs opaa1
2726: WHERE opaa1.price_adjustment_id = p_price_adjustment_id);
2727: /*
2728: WHERE (OPAA.price_adjustment_id = p_price_adjustment_id or
2729: OPAA.rltd_price_adj_id = p_price_adjustment_id) or

Line 2731: oe_price_adj_assocs opaa1 where

2727: /*
2728: WHERE (OPAA.price_adjustment_id = p_price_adjustment_id or
2729: OPAA.rltd_price_adj_id = p_price_adjustment_id) or
2730: OPAA.rltd_price_adj_id in( select opaa1.rltd_price_adj_id from
2731: oe_price_adj_assocs opaa1 where
2732: opaa1.price_adjustment_id = p_price_adjustment_id);
2733: ========= Commented for the bug 3053445 =========
2734: */
2735: l_price_adjustment_id NUMBER;

Line 2794: FROM oe_price_adj_assocs

2790: oe_debug_pub.add('price adjust ment 4 : '||to_char(l_price_adjustment_id));
2791:
2792: SELECT price_adj_assoc_id
2793: INTO l_lock_price_adj_assoc_id
2794: FROM oe_price_adj_assocs
2795: WHERE price_adj_assoc_id = l_price_adj_assoc_id
2796: FOR UPDATE NOWAIT;
2797:
2798: DELETE FROM oe_price_adj_assocs

Line 2798: DELETE FROM oe_price_adj_assocs

2794: FROM oe_price_adj_assocs
2795: WHERE price_adj_assoc_id = l_price_adj_assoc_id
2796: FOR UPDATE NOWAIT;
2797:
2798: DELETE FROM oe_price_adj_assocs
2799: WHERE price_adj_assoc_id = l_lock_price_adj_assoc_id;
2800:
2801: END LOOP;
2802:

Line 2858: FROM OE_PRICE_ADJ_ASSOCS OPAA

2854:
2855: -- Modified for the SQLREP changes for SQL_ID = 14882948
2856: CURSOR c_price_adj_assocs(p_price_adjustment_id NUMBER) IS
2857: SELECT price_adj_assoc_id
2858: FROM OE_PRICE_ADJ_ASSOCS OPAA
2859: WHERE opaa.rltd_price_adj_id IN (
2860: SELECT p_price_adjustment_id
2861: FROM DUAL
2862: UNION ALL

Line 2864: FROM oe_price_adj_assocs opaa1

2860: SELECT p_price_adjustment_id
2861: FROM DUAL
2862: UNION ALL
2863: SELECT opaa1.rltd_price_adj_id
2864: FROM oe_price_adj_assocs opaa1
2865: WHERE opaa1.price_adjustment_id = p_price_adjustment_id);
2866:
2867:
2868: l_price_adjustment_id NUMBER;

Line 2941: FROM oe_price_adj_assocs

2937: OR c_price_adj_assocs%NOTFOUND IS NULL; -- empty cursor
2938:
2939: SELECT price_adj_assoc_id
2940: INTO l_lock_price_adj_assoc_id
2941: FROM oe_price_adj_assocs
2942: WHERE price_adj_assoc_id = l_price_adj_assoc_id
2943: FOR UPDATE NOWAIT;
2944:
2945: DELETE FROM oe_price_adj_assocs

Line 2945: DELETE FROM oe_price_adj_assocs

2941: FROM oe_price_adj_assocs
2942: WHERE price_adj_assoc_id = l_price_adj_assoc_id
2943: FOR UPDATE NOWAIT;
2944:
2945: DELETE FROM oe_price_adj_assocs
2946: WHERE price_adj_assoc_id = l_lock_price_adj_assoc_id;
2947:
2948: END LOOP;
2949: