APPS.OE_FREIGHT_RATING_UTIL dependencies on OE_PRICE_ADJUSTMENTS

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

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

Line 127: FROM OE_PRICE_ADJUSTMENTS

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

Line 141: FROM OE_PRICE_ADJUSTMENTS

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

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

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

Line 219: FROM oe_price_adjustments

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

Line 324: FROM OE_PRICE_ADJUSTMENTS

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

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

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

Line 377: select oe_price_adjustments_s.nextval

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

Line 381: INSERT INTO oe_price_adjustments

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

Line 464: FROM OE_PRICE_ADJUSTMENTS

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

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

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