APPS.OE_ORDER_PURGE_PVT dependencies on OE_PRICE_ADJ_ASSOCS

Line 2774: FROM OE_PRICE_ADJ_ASSOCS OPAA

2770: WHERE price_adjustment_id = p_price_adjustment_id;
2771:
2772: CURSOR c_price_adj_assocs(p_price_adjustment_id NUMBER) IS
2773: SELECT price_adj_assoc_id
2774: FROM OE_PRICE_ADJ_ASSOCS OPAA
2775: WHERE opaa.rltd_price_adj_id IN (SELECT TO_NUMBER (p_price_adjustment_id)
2776: FROM DUAL
2777: UNION ALL
2778: SELECT opaa1.rltd_price_adj_id

Line 2779: FROM oe_price_adj_assocs opaa1

2775: WHERE opaa.rltd_price_adj_id IN (SELECT TO_NUMBER (p_price_adjustment_id)
2776: FROM DUAL
2777: UNION ALL
2778: SELECT opaa1.rltd_price_adj_id
2779: FROM oe_price_adj_assocs opaa1
2780: WHERE opaa1.price_adjustment_id = p_price_adjustment_id);
2781: /*
2782: WHERE (OPAA.price_adjustment_id = p_price_adjustment_id or
2783: OPAA.rltd_price_adj_id = p_price_adjustment_id) or

Line 2785: oe_price_adj_assocs opaa1 where

2781: /*
2782: WHERE (OPAA.price_adjustment_id = p_price_adjustment_id or
2783: OPAA.rltd_price_adj_id = p_price_adjustment_id) or
2784: OPAA.rltd_price_adj_id in( select opaa1.rltd_price_adj_id from
2785: oe_price_adj_assocs opaa1 where
2786: opaa1.price_adjustment_id = p_price_adjustment_id);
2787: ========= Commented for the bug 3053445 =========
2788: */
2789: l_price_adjustment_id NUMBER;

Line 2848: FROM oe_price_adj_assocs

2844: oe_debug_pub.add('price adjust ment 4 : '||to_char(l_price_adjustment_id));
2845:
2846: SELECT price_adj_assoc_id
2847: INTO l_lock_price_adj_assoc_id
2848: FROM oe_price_adj_assocs
2849: WHERE price_adj_assoc_id = l_price_adj_assoc_id
2850: FOR UPDATE NOWAIT;
2851:
2852: DELETE FROM oe_price_adj_assocs

Line 2852: DELETE FROM oe_price_adj_assocs

2848: FROM oe_price_adj_assocs
2849: WHERE price_adj_assoc_id = l_price_adj_assoc_id
2850: FOR UPDATE NOWAIT;
2851:
2852: DELETE FROM oe_price_adj_assocs
2853: WHERE price_adj_assoc_id = l_lock_price_adj_assoc_id;
2854:
2855: END LOOP;
2856:

Line 2912: FROM OE_PRICE_ADJ_ASSOCS OPAA

2908:
2909: -- Modified for the SQLREP changes for SQL_ID = 14882948
2910: CURSOR c_price_adj_assocs(p_price_adjustment_id NUMBER) IS
2911: SELECT price_adj_assoc_id
2912: FROM OE_PRICE_ADJ_ASSOCS OPAA
2913: WHERE opaa.rltd_price_adj_id IN (
2914: SELECT p_price_adjustment_id
2915: FROM DUAL
2916: UNION ALL

Line 2918: FROM oe_price_adj_assocs opaa1

2914: SELECT p_price_adjustment_id
2915: FROM DUAL
2916: UNION ALL
2917: SELECT opaa1.rltd_price_adj_id
2918: FROM oe_price_adj_assocs opaa1
2919: WHERE opaa1.price_adjustment_id = p_price_adjustment_id);
2920:
2921:
2922: l_price_adjustment_id NUMBER;

Line 2995: FROM oe_price_adj_assocs

2991: OR c_price_adj_assocs%NOTFOUND IS NULL; -- empty cursor
2992:
2993: SELECT price_adj_assoc_id
2994: INTO l_lock_price_adj_assoc_id
2995: FROM oe_price_adj_assocs
2996: WHERE price_adj_assoc_id = l_price_adj_assoc_id
2997: FOR UPDATE NOWAIT;
2998:
2999: DELETE FROM oe_price_adj_assocs

Line 2999: DELETE FROM oe_price_adj_assocs

2995: FROM oe_price_adj_assocs
2996: WHERE price_adj_assoc_id = l_price_adj_assoc_id
2997: FOR UPDATE NOWAIT;
2998:
2999: DELETE FROM oe_price_adj_assocs
3000: WHERE price_adj_assoc_id = l_lock_price_adj_assoc_id;
3001:
3002: END LOOP;
3003: