DBA Data[Home] [Help]

APPS.OE_FREIGHT_RATING_UTIL dependencies on OE_ORDER_PUB

Line 68: l_line_rec OE_Order_PUB.Line_Rec_Type;

64: ( p_cost_type_code IN VARCHAR2
65: )RETURN VARCHAR2 IS
66: l_api_version_number CONSTANT NUMBER := 1.0;
67: l_api_name CONSTANT VARCHAR2(30):= 'Get_Cost_Amount';
68: l_line_rec OE_Order_PUB.Line_Rec_Type;
69: l_cost_amount NUMBER := 0.0;
70: --
71: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
72: --

Line 80: l_line_rec := OE_ORDER_PUB.G_LINE;

76: oe_debug_pub.add( 'OEXUFRRB:INSIDE GET COST AMOUNT FOR' || P_COST_TYPE_CODE , 1 ) ;
77: END IF;
78:
79: -- Get the Line record from the Global Record
80: l_line_rec := OE_ORDER_PUB.G_LINE;
81:
82: -- Validate the Line_id.
83:
84: IF l_line_rec.line_id is NULL OR l_line_rec.line_id = FND_API.G_MISS_NUM

Line 272: l_line_rec OE_Order_PUB.Line_Rec_Type;

268: ( p_cost_type_code IN VARCHAR2
269: )RETURN VARCHAR2 IS
270: l_api_version_number CONSTANT NUMBER := 1.0;
271: l_api_name CONSTANT VARCHAR2(30):= 'Get_Cost_Amount';
272: l_line_rec OE_Order_PUB.Line_Rec_Type;
273: l_cost_amount NUMBER := 0.0;
274: --
275: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
276: --

Line 284: l_line_rec := OE_ORDER_PUB.G_LINE;

280: oe_debug_pub.add( 'OEXUFRRB:INSIDE get_estimated_cost_amount FOR' || P_COST_TYPE_CODE , 1 ) ;
281: END IF;
282:
283: -- Get the Line record from the Global Record
284: l_line_rec := OE_ORDER_PUB.G_LINE;
285:
286: -- Validate the Line_id.
287:
288: IF l_line_rec.line_id is NULL OR l_line_rec.line_id = FND_API.G_MISS_NUM

Line 427: l_line_rec OE_Order_PUB.Line_Rec_Type;

423: ( p_cost_type_code IN VARCHAR2
424: )RETURN VARCHAR2 IS
425: l_api_version_number CONSTANT NUMBER := 1.0;
426: l_api_name CONSTANT VARCHAR2(30):= 'Get_Estimated_Cost_Amount_Ns';
427: l_line_rec OE_Order_PUB.Line_Rec_Type;
428: l_cost_amount NUMBER := 0.0;
429: --
430: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
431: --

Line 439: l_line_rec := OE_ORDER_PUB.G_LINE;

435: oe_debug_pub.add('OEXUFRRB: Inside Procedure Get_Estimated_Cost_Amount_Ns');
436: oe_debug_pub.add('p_cost_type_code : ' || P_COST_TYPE_CODE , 1 ) ;
437: END IF;
438: -- Get the Line record from the Global Record
439: l_line_rec := OE_ORDER_PUB.G_LINE;
440:
441: -- Validate the Line_id.
442:
443: IF l_line_rec.line_id is NULL OR l_line_rec.line_id = FND_API.G_MISS_NUM