APPS.OE_ORDER_CLOSE_UTIL dependencies on OE_PRICE_ADJUSTMENTS

Line 25: FROM oe_price_adjustments

21: -- Adding the condition retrobill_request_id IS NULL in both the cursors to prevent the deletion of manual modifier record corresponding to the latest price in the set up in the case of retrobill lines.
22:
23: CURSOR c_adjustment_header IS
24: SELECT price_adjustment_id
25: FROM oe_price_adjustments
26: WHERE header_id = p_header_id
27: AND list_line_type_code<>'TAX'
28: AND automatic_flag = 'N'
29: AND applied_flag = 'N'

Line 33: from oe_price_adjustments for bug 2516895 */

29: AND applied_flag = 'N'
30: AND retrobill_request_id IS NULL; --bug4099565
31:
32: /* Added a condition to avoid deleting unapplied Price Break Child line adjustments
33: from oe_price_adjustments for bug 2516895 */
34: CURSOR c_adjustment_line IS
35: SELECT price_adjustment_id
36: FROM oe_price_adjustments adj
37: WHERE line_id = p_line_id

Line 36: FROM oe_price_adjustments adj

32: /* Added a condition to avoid deleting unapplied Price Break Child line adjustments
33: from oe_price_adjustments for bug 2516895 */
34: CURSOR c_adjustment_line IS
35: SELECT price_adjustment_id
36: FROM oe_price_adjustments adj
37: WHERE line_id = p_line_id
38: AND list_line_type_code<>'TAX'
39: AND automatic_flag = 'N'
40: AND applied_flag = 'N'

Line 67: DELETE FROM oe_price_adjustments

63: --
64: DELETE FROM oe_price_adj_attribs
65: WHERE price_adjustment_id = l_adjustment_id;
66: --
67: DELETE FROM oe_price_adjustments
68: WHERE price_adjustment_id = l_adjustment_id;
69: EXCEPTION
70: WHEN OTHERS THEN
71: IF l_debug_level > 0 THEN

Line 93: DELETE FROM oe_price_adjustments

89: --
90: DELETE FROM oe_price_adj_attribs
91: WHERE price_adjustment_id = l_adjustment_id;
92: --
93: DELETE FROM oe_price_adjustments
94: WHERE price_adjustment_id = l_adjustment_id;
95: EXCEPTION
96: WHEN OTHERS THEN
97: IF l_debug_level > 0 THEN