DBA Data[Home] [Help]

APPS.OE_UPG_SO dependencies on OE_PRICE_ADJUSTMENTS

Line 74: oe_price_adjustments

70: price_adjustment_id
71: into
72: v_price_adjustment_id
73: from
74: oe_price_adjustments
75: where price_adjustment_id = mpa.price_adjustment_id;
76:
77: G_ERROR_LOCATION := 102;
78:

Line 80: oe_price_adjustments_s.nextval

76:
77: G_ERROR_LOCATION := 102;
78:
79: select
80: oe_price_adjustments_s.nextval
81: into
82: v_price_adjustment_id
83: from dual;
84: G_ERROR_LOCATION := 103;

Line 99: insert into oe_price_adjustments

95: -- dbms_output.put_line('ins oe_price_adjs');
96:
97: G_ERROR_LOCATION := 104;
98:
99: insert into oe_price_adjustments
100: (
101: price_adjustment_id,
102: creation_date,
103: created_by,