DBA Data[Home] [Help]

APPS.OE_MARGIN_PVT dependencies on OE_ORDER_PUB

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

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

Line 51: l_Line_Tbl oe_order_pub.line_tbl_type;

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

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

195: End CHECK_MANUAL_RELEASED_HOLDS;
196:
197:
198: ----------------------------------------------------------------
199: FUNCTION Get_Cost (p_line_rec IN OE_ORDER_PUB.LINE_REC_TYPE DEFAULT OE_Order_Pub.G_MISS_LINE_REC
200: ,p_request_rec IN Oe_Order_Pub.Request_Rec_Type DEFAULT Oe_Order_Pub.G_MISS_REQUEST_REC
201: ,p_order_currency IN VARCHAR2 Default NULL
202: ,p_sob_currency IN VARCHAR2 Default NULL
203: ,p_inventory_item_id IN NUMBER Default NULL

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

196:
197:
198: ----------------------------------------------------------------
199: FUNCTION Get_Cost (p_line_rec IN OE_ORDER_PUB.LINE_REC_TYPE DEFAULT OE_Order_Pub.G_MISS_LINE_REC
200: ,p_request_rec IN Oe_Order_Pub.Request_Rec_Type DEFAULT Oe_Order_Pub.G_MISS_REQUEST_REC
201: ,p_order_currency IN VARCHAR2 Default NULL
202: ,p_sob_currency IN VARCHAR2 Default NULL
203: ,p_inventory_item_id IN NUMBER Default NULL
204: ,p_ship_from_org_id IN NUMBER Default NULL

Line 211: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;

207: ,p_item_type_code IN VARCHAR2 Default 'STANDARD'
208: ,p_header_flag IN Boolean Default FALSE)
209: ----------------------------------------------------------------
210: RETURN NUMBER IS
211: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
212: l_unit_cost NUMBER;
213: l_cost_group_id NUMBER;
214: l_item_rec OE_ORDER_CACHE.item_rec_type;
215: l_set_of_books Oe_Order_Cache.Set_Of_Books_Rec_Type;

Line 221: l_line_tbl Oe_Order_Pub.Line_Tbl_Type;

217: l_set_of_books_id VARCHAR2(30);
218: l_sob_currency VARCHAR2(30);
219: l_old_unit_cost NUMBER;
220: l_control_rec OE_GLOBALS.Control_Rec_Type;
221: l_line_tbl Oe_Order_Pub.Line_Tbl_Type;
222: l_old_line_tbl Oe_Order_Pub.Line_Tbl_Type;
223: l_return_status VARCHAR2(30);
224: l_denominator NUMBER;
225: l_numerator NUMBER;

Line 222: l_old_line_tbl Oe_Order_Pub.Line_Tbl_Type;

218: l_sob_currency VARCHAR2(30);
219: l_old_unit_cost NUMBER;
220: l_control_rec OE_GLOBALS.Control_Rec_Type;
221: l_line_tbl Oe_Order_Pub.Line_Tbl_Type;
222: l_old_line_tbl Oe_Order_Pub.Line_Tbl_Type;
223: l_return_status VARCHAR2(30);
224: l_denominator NUMBER;
225: l_numerator NUMBER;
226: l_rate NUMBER;

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

1096: --above logic when checking in the code!
1097: Return True;
1098: END;
1099:
1100: Procedure Get_Line_Margin(p_line_rec In OE_ORDER_PUB.LINE_REC_TYPE,
1101: x_unit_cost Out NOCOPY Number,
1102: x_unit_margin_amount Out NOCOPY Number,
1103: x_margin_percent Out NOCOPY Number) As
1104: l_cost Number;