APPS.OE_ORDER_PURGE_PVT dependencies on OE_PRICE_ADJUSTMENTS

Line 2710: FROM OE_PRICE_ADJUSTMENTS

2706: RETURN VARCHAR2
2707: IS
2708: CURSOR c_header_adj IS
2709: SELECT PRICE_ADJUSTMENT_ID
2710: FROM OE_PRICE_ADJUSTMENTS
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

Line 2759: FROM oe_price_adjustments

2755:
2756: -- Lock the price adjustments record.
2757: SELECT price_adjustment_id
2758: INTO l_lock_adjustment_id
2759: FROM oe_price_adjustments
2760: WHERE price_adjustment_id = l_price_adjustment_id
2761: FOR UPDATE NOWAIT;
2762:
2763: -- Delete from price_adj_attribs.

Line 2807: DELETE FROM OE_PRICE_ADJUSTMENTS

2803: oe_debug_pub.add('Number of price_adj_assocs deleted : '||to_char(c_price_adj_assocs%ROWCOUNT),1);
2804: CLOSE c_price_adj_assocs;
2805:
2806:
2807: DELETE FROM OE_PRICE_ADJUSTMENTS
2808: WHERE price_adjustment_id = l_lock_adjustment_id;
2809:
2810: END LOOP;
2811:

Line 2845: FROM OE_PRICE_ADJUSTMENTS

2841: RETURN VARCHAR2
2842: IS
2843: CURSOR c_line_adj IS
2844: SELECT PRICE_ADJUSTMENT_ID
2845: FROM OE_PRICE_ADJUSTMENTS
2846: WHERE LINE_ID = p_line_id;
2847:
2848: -- Added cursor c_price_adj for bug # 4701261
2849:

Line 2891: FROM oe_price_adjustments

2887:
2888: -- Lock the price adjustments record.
2889: SELECT price_adjustment_id
2890: INTO l_lock_adjustment_id
2891: FROM oe_price_adjustments
2892: WHERE price_adjustment_id = l_price_adjustment_id
2893: FOR UPDATE NOWAIT;
2894:
2895:

Line 2953: DELETE FROM OE_PRICE_ADJUSTMENTS

2949:
2950: oe_debug_pub.add('Number of price_adj_assocs deleted : '||to_char(c_price_adj_assocs%ROWCOUNT),1);
2951: CLOSE c_price_adj_assocs;
2952:
2953: DELETE FROM OE_PRICE_ADJUSTMENTS
2954: WHERE price_adjustment_id = l_lock_adjustment_id;
2955:
2956: END LOOP;
2957: