APPS.OE_ORDER_PURGE_PVT dependencies on OE_PRICE_ADJ_ATTRIBS

Line 2769: FROM oe_price_adj_attribs

2765: WHERE HEADER_ID = p_header_id;
2766:
2767: CURSOR c_price_adj(p_price_adjustment_id NUMBER) IS
2768: SELECT price_adj_attrib_id
2769: FROM oe_price_adj_attribs
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

Line 2826: FROM oe_price_adj_attribs

2822: OR c_price_adj%NOTFOUND IS NULL; -- empty cursor
2823:
2824: SELECT price_adj_attrib_id
2825: INTO l_lock_price_adj_attrib_id
2826: FROM oe_price_adj_attribs
2827: WHERE price_adj_attrib_id = l_price_adj_attrib_id
2828: FOR UPDATE NOWAIT;
2829:
2830: DELETE FROM oe_price_adj_attribs

Line 2830: DELETE FROM oe_price_adj_attribs

2826: FROM oe_price_adj_attribs
2827: WHERE price_adj_attrib_id = l_price_adj_attrib_id
2828: FOR UPDATE NOWAIT;
2829:
2830: DELETE FROM oe_price_adj_attribs
2831: WHERE price_adj_attrib_id = l_price_adj_attrib_id;
2832:
2833: END LOOP;
2834:

Line 2906: FROM oe_price_adj_attribs

2902: -- Added cursor c_price_adj for bug # 4701261
2903:
2904: CURSOR c_price_adj(p_price_adjustment_id NUMBER) IS
2905: SELECT price_adj_attrib_id
2906: FROM oe_price_adj_attribs
2907: WHERE price_adjustment_id = p_price_adjustment_id;
2908:
2909: -- Modified for the SQLREP changes for SQL_ID = 14882948
2910: CURSOR c_price_adj_assocs(p_price_adjustment_id NUMBER) IS

Line 2960: FROM oe_price_adj_attribs

2956: OR c_price_adj%NOTFOUND IS NULL;
2957:
2958: SELECT price_adj_attrib_id
2959: INTO l_lock_price_adj_attrib_id
2960: FROM oe_price_adj_attribs
2961: WHERE price_adj_attrib_id = l_price_adj_attrib_id
2962: FOR UPDATE NOWAIT;
2963:
2964: DELETE FROM oe_price_adj_attribs

Line 2964: DELETE FROM oe_price_adj_attribs

2960: FROM oe_price_adj_attribs
2961: WHERE price_adj_attrib_id = l_price_adj_attrib_id
2962: FOR UPDATE NOWAIT;
2963:
2964: DELETE FROM oe_price_adj_attribs
2965: WHERE price_adj_attrib_id = l_price_adj_attrib_id;
2966:
2967: END LOOP;
2968:

Line 2978: FROM oe_price_adj_attribs

2974: /*
2975: -- Delete from price_adj_attribs.
2976: SELECT price_adjustment_id
2977: INTO l_lock_adjustment_id
2978: FROM oe_price_adj_attribs
2979: WHERE price_adjustment_id = l_price_adjustment_id
2980: FOR UPDATE NOWAIT;
2981:
2982: DELETE FROM oe_price_adj_attribs

Line 2982: DELETE FROM oe_price_adj_attribs

2978: FROM oe_price_adj_attribs
2979: WHERE price_adjustment_id = l_price_adjustment_id
2980: FOR UPDATE NOWAIT;
2981:
2982: DELETE FROM oe_price_adj_attribs
2983: WHERE price_adjustment_id = l_price_adjustment_id;
2984: */
2985:
2986: -- Delete from price_adj_assocs.