APPS.OE_ORDER_PURGE_PVT dependencies on OE_PRICE_ADJ_ATTRIBS

Line 2715: FROM oe_price_adj_attribs

2711: WHERE HEADER_ID = p_header_id;
2712:
2713: CURSOR c_price_adj(p_price_adjustment_id NUMBER) IS
2714: SELECT price_adj_attrib_id
2715: FROM oe_price_adj_attribs
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

Line 2772: FROM oe_price_adj_attribs

2768: OR c_price_adj%NOTFOUND IS NULL; -- empty cursor
2769:
2770: SELECT price_adj_attrib_id
2771: INTO l_lock_price_adj_attrib_id
2772: FROM oe_price_adj_attribs
2773: WHERE price_adj_attrib_id = l_price_adj_attrib_id
2774: FOR UPDATE NOWAIT;
2775:
2776: DELETE FROM oe_price_adj_attribs

Line 2776: DELETE FROM oe_price_adj_attribs

2772: FROM oe_price_adj_attribs
2773: WHERE price_adj_attrib_id = l_price_adj_attrib_id
2774: FOR UPDATE NOWAIT;
2775:
2776: DELETE FROM oe_price_adj_attribs
2777: WHERE price_adj_attrib_id = l_price_adj_attrib_id;
2778:
2779: END LOOP;
2780:

Line 2852: FROM oe_price_adj_attribs

2848: -- Added cursor c_price_adj for bug # 4701261
2849:
2850: CURSOR c_price_adj(p_price_adjustment_id NUMBER) IS
2851: SELECT price_adj_attrib_id
2852: FROM oe_price_adj_attribs
2853: WHERE price_adjustment_id = p_price_adjustment_id;
2854:
2855: -- Modified for the SQLREP changes for SQL_ID = 14882948
2856: CURSOR c_price_adj_assocs(p_price_adjustment_id NUMBER) IS

Line 2906: FROM oe_price_adj_attribs

2902: OR c_price_adj%NOTFOUND IS NULL;
2903:
2904: SELECT price_adj_attrib_id
2905: INTO l_lock_price_adj_attrib_id
2906: FROM oe_price_adj_attribs
2907: WHERE price_adj_attrib_id = l_price_adj_attrib_id
2908: FOR UPDATE NOWAIT;
2909:
2910: DELETE FROM oe_price_adj_attribs

Line 2910: DELETE FROM oe_price_adj_attribs

2906: FROM oe_price_adj_attribs
2907: WHERE price_adj_attrib_id = l_price_adj_attrib_id
2908: FOR UPDATE NOWAIT;
2909:
2910: DELETE FROM oe_price_adj_attribs
2911: WHERE price_adj_attrib_id = l_price_adj_attrib_id;
2912:
2913: END LOOP;
2914:

Line 2924: FROM oe_price_adj_attribs

2920: /*
2921: -- Delete from price_adj_attribs.
2922: SELECT price_adjustment_id
2923: INTO l_lock_adjustment_id
2924: FROM oe_price_adj_attribs
2925: WHERE price_adjustment_id = l_price_adjustment_id
2926: FOR UPDATE NOWAIT;
2927:
2928: DELETE FROM oe_price_adj_attribs

Line 2928: DELETE FROM oe_price_adj_attribs

2924: FROM oe_price_adj_attribs
2925: WHERE price_adjustment_id = l_price_adjustment_id
2926: FOR UPDATE NOWAIT;
2927:
2928: DELETE FROM oe_price_adj_attribs
2929: WHERE price_adjustment_id = l_price_adjustment_id;
2930: */
2931:
2932: -- Delete from price_adj_assocs.