APPS.OE_FREIGHT_RATING_UTIL dependencies on OE_PRICE_ADJUSTMENTS

Line 121: -- Cost records are stored in OE_PRICE_ADJUSTMENTS table with

117:
118: IF l_line_rec.shippable_flag = 'Y' THEN
119: IF l_line_rec.shipped_quantity > 0 THEN
120:
121: -- Cost records are stored in OE_PRICE_ADJUSTMENTS table with
122: -- list_line_type_code = 'COST'
123: IF l_debug_level > 0 THEN
124: oe_debug_pub.add( 'LINE IS SHIPPABLE AND IS SHIPPED' , 3 ) ;
125: END IF;

Line 128: FROM OE_PRICE_ADJUSTMENTS

124: oe_debug_pub.add( 'LINE IS SHIPPABLE AND IS SHIPPED' , 3 ) ;
125: END IF;
126: SELECT NVL(SUM(ADJUSTED_AMOUNT),0)
127: INTO l_cost_amount
128: FROM OE_PRICE_ADJUSTMENTS
129: WHERE LINE_ID = l_line_rec.line_id
130: AND LIST_LINE_TYPE_CODE = 'COST'
131: AND CHARGE_TYPE_CODE = p_cost_type_code
132: AND nvl(ESTIMATED_FLAG, 'N') <> 'Y';

Line 142: FROM OE_PRICE_ADJUSTMENTS

138: RETURN FND_NUMBER.NUMBER_TO_CANONICAL(l_cost_amount);
139: ELSE
140: SELECT NVL(SUM(ADJUSTED_AMOUNT),0)
141: INTO l_cost_amount
142: FROM OE_PRICE_ADJUSTMENTS
143: WHERE LINE_ID = l_line_rec.line_id
144: AND LIST_LINE_TYPE_CODE = 'COST'
145: AND CHARGE_TYPE_CODE = p_cost_type_code
146: AND ESTIMATED_FLAG = 'Y';

Line 168: oe_debug_pub.add( 'NO COST INFORMATION FOUND IN OE_PRICE_ADJUSTMENTS' ) ;

164: EXCEPTION
165:
166: WHEN NO_DATA_FOUND THEN
167: IF l_debug_level > 0 THEN
168: oe_debug_pub.add( 'NO COST INFORMATION FOUND IN OE_PRICE_ADJUSTMENTS' ) ;
169: END IF;
170: RETURN FND_NUMBER.NUMBER_TO_CANONICAL(0);
171:
172: WHEN OTHERS THEN

Line 220: FROM oe_price_adjustments

216:
217: BEGIN
218: SELECT list_line_type_code
219: INTO l_list_line_type_code
220: FROM oe_price_adjustments
221: WHERE header_id = p_key
222: AND list_header_id = p_key * (-1)
223: AND list_line_type_code = 'OM_CALLED_FREIGHT_RATES'
224: AND rownum = 1;

Line 325: FROM OE_PRICE_ADJUSTMENTS

321:
322: IF l_line_rec.shippable_flag = 'Y' THEN
323: SELECT NVL(SUM(ADJUSTED_AMOUNT),0)
324: INTO l_cost_amount
325: FROM OE_PRICE_ADJUSTMENTS
326: WHERE LINE_ID = l_line_rec.line_id
327: AND LIST_LINE_TYPE_CODE = 'COST'
328: AND CHARGE_TYPE_CODE = p_cost_type_code
329: AND ESTIMATED_FLAG = 'Y';

Line 350: oe_debug_pub.add( 'NO COST INFORMATION FOUND IN OE_PRICE_ADJUSTMENTS' ) ;

346: EXCEPTION
347:
348: WHEN NO_DATA_FOUND THEN
349: IF l_debug_level > 0 THEN
350: oe_debug_pub.add( 'NO COST INFORMATION FOUND IN OE_PRICE_ADJUSTMENTS' ) ;
351: END IF;
352: RETURN FND_NUMBER.NUMBER_TO_CANONICAL(0);
353:
354: WHEN OTHERS THEN

Line 378: select oe_price_adjustments_s.nextval

374: BEGIN
375:
376: IF p_header_id is not null THEN
377:
378: select oe_price_adjustments_s.nextval
379: into l_price_adjustment_id
380: from dual;
381:
382: INSERT INTO oe_price_adjustments

Line 382: INSERT INTO oe_price_adjustments

378: select oe_price_adjustments_s.nextval
379: into l_price_adjustment_id
380: from dual;
381:
382: INSERT INTO oe_price_adjustments
383: (PRICE_ADJUSTMENT_ID
384: ,HEADER_ID
385: ,LINE_ID
386: ,PRICING_PHASE_ID

Line 465: FROM OE_PRICE_ADJUSTMENTS

461: END IF;
462:
463: SELECT NVL(SUM(ADJUSTED_AMOUNT),0)
464: INTO l_cost_amount
465: FROM OE_PRICE_ADJUSTMENTS
466: WHERE LINE_ID = l_line_rec.line_id
467: AND LIST_LINE_TYPE_CODE = 'COST'
468: AND CHARGE_TYPE_CODE = p_cost_type_code
469: AND ESTIMATED_FLAG = 'Y';

Line 481: oe_debug_pub.add( 'NO COST INFORMATION FOUND IN OE_PRICE_ADJUSTMENTS' ) ;

477: END IF;
478: EXCEPTION
479: WHEN NO_DATA_FOUND THEN
480: IF l_debug_level > 0 THEN
481: oe_debug_pub.add( 'NO COST INFORMATION FOUND IN OE_PRICE_ADJUSTMENTS' ) ;
482: END IF;
483: RETURN FND_NUMBER.NUMBER_TO_CANONICAL(0);
484: WHEN OTHERS THEN
485: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)