APPS.OE_FREIGHT_RATING_PVT dependencies on OE_PRICE_ADJUSTMENTS

Line 55: FROM oe_price_adjustments

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

Line 150: select oe_price_adjustments_s.nextval into l_price_adjustment_id

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

Line 236: ,oe_price_adjustments opa

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

Line 253: DELETE FROM OE_PRICE_ADJUSTMENTS

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

Line 394: DELETE FROM oe_price_adjustments

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

Line 449: select oe_price_adjustments_s.nextval

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

Line 452: INSERT INTO oe_price_adjustments

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