DBA Data[Home] [Help]

APPS.OE_UPG_SO_NEW dependencies on OE_PRICE_ADJUSTMENTS

Line 149: oe_price_adjustments

145: price_adjustment_id
146: into
147: v_price_adjustment_id
148: from
149: oe_price_adjustments
150: where price_adjustment_id = mpa.price_adjustment_id;
151:
152: G_ERROR_LOCATION := 102;
153:

Line 155: oe_price_adjustments_s.nextval

151:
152: G_ERROR_LOCATION := 102;
153:
154: select
155: oe_price_adjustments_s.nextval
156: into
157: v_price_adjustment_id
158: from dual;
159: G_ERROR_LOCATION := 103;

Line 191: insert into oe_price_adjustments

187: p_error_type => 'PRICE_ADJUSTMENT-After call',
188: p_error_desc => pa_rec.list_line_id ,
189: p_error_module => 'Upg_Price_Adjustments');
190: */
191: insert into oe_price_adjustments
192: (
193: price_adjustment_id,
194: creation_date,
195: created_by,

Line 8710: delete from oe_price_adjustments

8706: where reference_line_id = l_ref_line_id
8707: and line_id <> l_line_id
8708: and header_id = l_header_id;
8709: /*
8710: delete from oe_price_adjustments
8711: where line_id in (select line_id
8712: from oe_order_lines_all
8713: where reference_line_id = l_config_line_id);
8714: */