DBA Data[Home] [Help]

APPS.OE_UPGRADE_MISC_NEW dependencies on OE_PRICE_ADJUSTMENTS

Line 156: FROM OE_PRICE_ADJUSTMENTS

152: x_return_status := 'S';
153: l_count := 0;
154: SELECT count(*)
155: INTO l_count
156: FROM OE_PRICE_ADJUSTMENTS
157: WHERE header_id = p_header_id
158: AND NVL(line_id,-99) = NVL(p_line_id,-99)
159: AND cost_id = p_freight_charge_id;
160:

Line 192: SELECT OE_PRICE_ADJUSTMENTS_S.nextval INTO l_price_adjustment_id FROM DUAL;

188: END;
189:
190:
191: -- Get the price_adjustment_id
192: SELECT OE_PRICE_ADJUSTMENTS_S.nextval INTO l_price_adjustment_id FROM DUAL;
193:
194: INSERT INTO OE_PRICE_ADJUSTMENTS
195: (
196: PRICE_ADJUSTMENT_ID

Line 194: INSERT INTO OE_PRICE_ADJUSTMENTS

190:
191: -- Get the price_adjustment_id
192: SELECT OE_PRICE_ADJUSTMENTS_S.nextval INTO l_price_adjustment_id FROM DUAL;
193:
194: INSERT INTO OE_PRICE_ADJUSTMENTS
195: (
196: PRICE_ADJUSTMENT_ID
197: , CREATION_DATE
198: , CREATED_BY