DBA Data[Home] [Help]

APPS.OE_FREIGHT_RATING_UTIL dependencies on OE_ORDER_PUB

Line 69: l_line_rec OE_Order_PUB.Line_Rec_Type;

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

Line 81: l_line_rec := OE_ORDER_PUB.G_LINE;

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

Line 273: l_line_rec OE_Order_PUB.Line_Rec_Type;

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

Line 285: l_line_rec := OE_ORDER_PUB.G_LINE;

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

Line 428: l_line_rec OE_Order_PUB.Line_Rec_Type;

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

Line 440: l_line_rec := OE_ORDER_PUB.G_LINE;

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