APPS.OE_FREIGHT_RATING_PVT dependencies on OE_PRICE_ADJUSTMENTS

Line 54: FROM oe_price_adjustments

50:
51: BEGIN
52: SELECT list_line_type_code
53: INTO l_list_line_type_code
54: FROM oe_price_adjustments
55: WHERE header_id = p_key
56: AND list_header_id = p_key * (-1);
57:
58: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 149: select oe_price_adjustments_s.nextval into l_price_adjustment_id

145: oe_debug_pub.add( 'ENTERING PROCEDURE PREPARE_ADJ_DETAIL.' , 3 ) ;
146: END IF;
147: x_return_status := FND_API.G_RET_STS_SUCCESS;
148:
149: select oe_price_adjustments_s.nextval into l_price_adjustment_id
150: from dual;
151:
152: IF l_debug_level > 0 THEN
153: oe_debug_pub.add( 'PRICE ADJUSTMENT ID IN PREPARE_ADJ_DETAIL IS: ' ||L_PRICE_ADJUSTMENT_ID , 1 ) ;

Line 235: ,oe_price_adjustments opa

231: SELECT opa.price_adjustment_id,ool.line_id,
232: opa.adjusted_amount, opa.list_line_type_code,
233: opa.charge_type_code
234: FROM oe_order_lines ool
235: ,oe_price_adjustments opa
236: WHERE opa.charge_type_code IN ('FTEPRICE','FTECHARGE')
237: AND ool.line_id = opa.line_id
238: AND ool.item_type_code <> OE_GLOBALS.G_ITEM_CONFIG
239: AND ool.ato_line_id = p_ato_line_id;

Line 252: DELETE FROM OE_PRICE_ADJUSTMENTS

248: x_return_status := FND_API.G_RET_STS_SUCCESS;
249:
250:
251: -- delete the old records from previous FTE call.
252: DELETE FROM OE_PRICE_ADJUSTMENTS
253: WHERE HEADER_ID = P_HEADER_ID
254: AND CHARGE_TYPE_CODE IN ('FTEPRICE','FTECHARGE')
255: AND list_line_type_code = 'COST'
256: AND ESTIMATED_FLAG = 'Y'

Line 393: DELETE FROM oe_price_adjustments

389: -- deleting the parents of the config line.
390: -- these deleted parent lines have been registered in
391: -- previous loop looping through p_fte_rates_tab, so
392: -- no need to register changed line again for these lines.
393: DELETE FROM oe_price_adjustments
394: WHERE price_adjustment_id = l_bulk_adj_rec.price_adjustment_id(i);
395:
396: l_adj_index := l_adj_index + 1;
397:

Line 448: select oe_price_adjustments_s.nextval

444: -- FTE being called.
445: IF NVL(OE_FREIGHT_RATING_UTIL.get_list_line_type_code(p_header_id),'N')
446: <> 'OM_CALLED_FREIGHT_RATES' THEN
447:
448: select oe_price_adjustments_s.nextval
449: into l_price_adjustment_id
450: from dual;
451: INSERT INTO oe_price_adjustments
452: (PRICE_ADJUSTMENT_ID

Line 451: INSERT INTO oe_price_adjustments

447:
448: select oe_price_adjustments_s.nextval
449: into l_price_adjustment_id
450: from dual;
451: INSERT INTO oe_price_adjustments
452: (PRICE_ADJUSTMENT_ID
453: ,HEADER_ID
454: ,LINE_ID
455: ,PRICING_PHASE_ID