DBA Data[Home] [Help]

APPS.OE_MARGIN_PVT dependencies on OE_ORDER_PUB

Line 47: l_request_rec Oe_Order_Pub.Request_Rec_Type DEFAULT Oe_Order_Pub.G_MISS_REQUEST_REC;

43: )
44:
45: is
46:
47: l_request_rec Oe_Order_Pub.Request_Rec_Type DEFAULT Oe_Order_Pub.G_MISS_REQUEST_REC;
48: l_line_id number;
49: l_header_id number;
50: l_unit_cost number;
51: j number;

Line 52: l_Line_Tbl oe_order_pub.line_tbl_type;

48: l_line_id number;
49: l_header_id number;
50: l_unit_cost number;
51: j number;
52: l_Line_Tbl oe_order_pub.line_tbl_type;
53: l_header_flag boolean;
54: i number;
55: l_org_id Number;
56: l_prev_org_id Number;

Line 269: FUNCTION Get_Cost (p_line_rec IN OE_ORDER_PUB.LINE_REC_TYPE DEFAULT OE_Order_Pub.G_MISS_LINE_REC

265: End CHECK_MANUAL_RELEASED_HOLDS;
266:
267:
268: ----------------------------------------------------------------
269: FUNCTION Get_Cost (p_line_rec IN OE_ORDER_PUB.LINE_REC_TYPE DEFAULT OE_Order_Pub.G_MISS_LINE_REC
270: ,p_request_rec IN Oe_Order_Pub.Request_Rec_Type DEFAULT Oe_Order_Pub.G_MISS_REQUEST_REC
271: ,p_order_currency IN VARCHAR2 Default NULL
272: ,p_sob_currency IN VARCHAR2 Default NULL
273: ,p_inventory_item_id IN NUMBER Default NULL

Line 270: ,p_request_rec IN Oe_Order_Pub.Request_Rec_Type DEFAULT Oe_Order_Pub.G_MISS_REQUEST_REC

266:
267:
268: ----------------------------------------------------------------
269: FUNCTION Get_Cost (p_line_rec IN OE_ORDER_PUB.LINE_REC_TYPE DEFAULT OE_Order_Pub.G_MISS_LINE_REC
270: ,p_request_rec IN Oe_Order_Pub.Request_Rec_Type DEFAULT Oe_Order_Pub.G_MISS_REQUEST_REC
271: ,p_order_currency IN VARCHAR2 Default NULL
272: ,p_sob_currency IN VARCHAR2 Default NULL
273: ,p_inventory_item_id IN NUMBER Default NULL
274: ,p_ship_from_org_id IN NUMBER Default NULL

Line 283: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;

279: ,p_ordered_uom IN VARCHAR2 Default NULL --Bug 11880399
280: )
281: ----------------------------------------------------------------
282: RETURN NUMBER IS
283: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
284: l_unit_cost NUMBER;
285: l_cost_group_id NUMBER;
286: l_item_rec OE_ORDER_CACHE.item_rec_type;
287: l_set_of_books Oe_Order_Cache.Set_Of_Books_Rec_Type;

Line 293: l_line_tbl Oe_Order_Pub.Line_Tbl_Type;

289: l_set_of_books_id VARCHAR2(30);
290: l_sob_currency VARCHAR2(30);
291: l_old_unit_cost NUMBER;
292: l_control_rec OE_GLOBALS.Control_Rec_Type;
293: l_line_tbl Oe_Order_Pub.Line_Tbl_Type;
294: l_old_line_tbl Oe_Order_Pub.Line_Tbl_Type;
295: l_return_status VARCHAR2(30);
296: l_denominator NUMBER;
297: l_numerator NUMBER;

Line 294: l_old_line_tbl Oe_Order_Pub.Line_Tbl_Type;

290: l_sob_currency VARCHAR2(30);
291: l_old_unit_cost NUMBER;
292: l_control_rec OE_GLOBALS.Control_Rec_Type;
293: l_line_tbl Oe_Order_Pub.Line_Tbl_Type;
294: l_old_line_tbl Oe_Order_Pub.Line_Tbl_Type;
295: l_return_status VARCHAR2(30);
296: l_denominator NUMBER;
297: l_numerator NUMBER;
298: l_rate NUMBER;

Line 1216: Procedure Get_Line_Margin(p_line_rec In OE_ORDER_PUB.LINE_REC_TYPE,

1212: --above logic when checking in the code!
1213: Return True;
1214: END;
1215:
1216: Procedure Get_Line_Margin(p_line_rec In OE_ORDER_PUB.LINE_REC_TYPE,
1217: x_unit_cost Out NOCOPY Number,
1218: x_unit_margin_amount Out NOCOPY Number,
1219: x_margin_percent Out NOCOPY Number) As
1220: l_cost Number;