eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_ORDER_PUB dependencies on OE_ORDER_PUB

Line 1: PACKAGE BODY OE_Order_PUB AS

1: PACKAGE BODY OE_Order_PUB AS
2: /* $Header: OEXPORDB.pls 120.13.12000000.2 2007/07/16 10:57:09 gtewani ship $ */
3:
4: -- Global constant holding the package name
5:

Line 6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Order_PUB';

2: /* $Header: OEXPORDB.pls 120.13.12000000.2 2007/07/16 10:57:09 gtewani ship $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Order_PUB';
7:
8:
9: -- Header record type
10:

Line 2405: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

2401: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2402: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
2403: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2404: ) IS
2405: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2406: l_control_rec OE_GLOBALS.control_rec_type;
2407: l_api_name CONSTANT VARCHAR2(30) := 'Update Line';
2408: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
2409: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;

Line 2408: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;

2404: ) IS
2405: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2406: l_control_rec OE_GLOBALS.control_rec_type;
2407: l_api_name CONSTANT VARCHAR2(30) := 'Update Line';
2408: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
2409: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
2410: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2411: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2412: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 2409: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;

2405: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2406: l_control_rec OE_GLOBALS.control_rec_type;
2407: l_api_name CONSTANT VARCHAR2(30) := 'Update Line';
2408: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
2409: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
2410: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2411: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2412: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2413: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;

Line 2410: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

2406: l_control_rec OE_GLOBALS.control_rec_type;
2407: l_api_name CONSTANT VARCHAR2(30) := 'Update Line';
2408: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
2409: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
2410: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2411: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2412: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2413: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2414: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;

Line 2411: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

2407: l_api_name CONSTANT VARCHAR2(30) := 'Update Line';
2408: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
2409: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
2410: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2411: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2412: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2413: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2414: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2415: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;

Line 2412: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

2408: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
2409: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
2410: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2411: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2412: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2413: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2414: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2415: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
2416: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

Line 2413: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;

2409: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
2410: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2411: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2412: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2413: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2414: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2415: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
2416: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2417: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

Line 2414: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;

2410: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2411: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2412: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2413: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2414: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2415: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
2416: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2417: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2418: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

Line 2415: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;

2411: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2412: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2413: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2414: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2415: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
2416: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2417: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2418: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2419: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

Line 2416: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

2412: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2413: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2414: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2415: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
2416: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2417: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2418: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2419: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2420: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

Line 2417: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

2413: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2414: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2415: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
2416: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2417: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2418: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2419: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2420: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2421: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

Line 2418: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

2414: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2415: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
2416: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2417: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2418: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2419: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2420: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2421: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2422: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

Line 2419: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

2415: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
2416: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2417: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2418: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2419: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2420: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2421: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2422: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2423: l_return_status VARCHAR2(30);

Line 2420: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

2416: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2417: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2418: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2419: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2420: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2421: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2422: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2423: l_return_status VARCHAR2(30);
2424: l_org_id number;

Line 2421: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

2417: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2418: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2419: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2420: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2421: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2422: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2423: l_return_status VARCHAR2(30);
2424: l_org_id number;
2425:

Line 2422: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

2418: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2419: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2420: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2421: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2422: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2423: l_return_status VARCHAR2(30);
2424: l_org_id number;
2425:
2426: BEGIN

Line 2588: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;

2584: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2585: )IS
2586: l_control_rec OE_GLOBALS.Control_Rec_Type;
2587: l_api_name CONSTANT VARCHAR2(30) := 'Process_header';
2588: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
2589: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
2590: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2591: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2592: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 2589: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;

2585: )IS
2586: l_control_rec OE_GLOBALS.Control_Rec_Type;
2587: l_api_name CONSTANT VARCHAR2(30) := 'Process_header';
2588: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
2589: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
2590: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2591: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2592: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2593: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;

Line 2590: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

2586: l_control_rec OE_GLOBALS.Control_Rec_Type;
2587: l_api_name CONSTANT VARCHAR2(30) := 'Process_header';
2588: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
2589: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
2590: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2591: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2592: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2593: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2594: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;

Line 2591: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

2587: l_api_name CONSTANT VARCHAR2(30) := 'Process_header';
2588: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
2589: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
2590: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2591: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2592: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2593: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2594: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2595: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;

Line 2592: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

2588: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
2589: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
2590: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2591: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2592: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2593: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2594: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2595: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
2596: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

Line 2593: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;

2589: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
2590: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2591: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2592: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2593: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2594: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2595: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
2596: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2597: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

Line 2594: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;

2590: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2591: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2592: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2593: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2594: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2595: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
2596: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2597: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2598: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

Line 2595: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;

2591: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2592: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2593: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2594: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2595: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
2596: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2597: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2598: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2599: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

Line 2596: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

2592: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2593: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2594: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2595: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
2596: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2597: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2598: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2599: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2600: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

Line 2597: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

2593: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2594: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2595: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
2596: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2597: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2598: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2599: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2600: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2601: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

Line 2598: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

2594: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2595: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
2596: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2597: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2598: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2599: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2600: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2601: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2602: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

Line 2599: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

2595: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
2596: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2597: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2598: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2599: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2600: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2601: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2602: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2603: l_return_status VARCHAR2(30);

Line 2600: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

2596: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2597: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2598: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2599: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2600: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2601: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2602: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2603: l_return_status VARCHAR2(30);
2604: l_org_id number;

Line 2601: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

2597: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2598: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2599: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2600: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2601: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2602: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2603: l_return_status VARCHAR2(30);
2604: l_org_id number;
2605:

Line 2602: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

2598: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2599: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2600: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2601: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2602: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2603: l_return_status VARCHAR2(30);
2604: l_org_id number;
2605:
2606: Begin

Line 2767: l_header_rec OE_ORDER_PUB.Header_Rec_Type;

2763: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2764: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
2765: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2766: )IS
2767: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
2768: l_old_header_rec OE_ORDER_PUB.Header_Rec_Type;
2769: l_control_rec OE_GLOBALS.Control_Rec_Type;
2770: l_api_name CONSTANT VARCHAR2(30) := 'Delete Order';
2771: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;

Line 2768: l_old_header_rec OE_ORDER_PUB.Header_Rec_Type;

2764: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
2765: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2766: )IS
2767: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
2768: l_old_header_rec OE_ORDER_PUB.Header_Rec_Type;
2769: l_control_rec OE_GLOBALS.Control_Rec_Type;
2770: l_api_name CONSTANT VARCHAR2(30) := 'Delete Order';
2771: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
2772: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;

Line 2771: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;

2767: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
2768: l_old_header_rec OE_ORDER_PUB.Header_Rec_Type;
2769: l_control_rec OE_GLOBALS.Control_Rec_Type;
2770: l_api_name CONSTANT VARCHAR2(30) := 'Delete Order';
2771: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
2772: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
2773: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
2774: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2775: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

Line 2772: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;

2768: l_old_header_rec OE_ORDER_PUB.Header_Rec_Type;
2769: l_control_rec OE_GLOBALS.Control_Rec_Type;
2770: l_api_name CONSTANT VARCHAR2(30) := 'Delete Order';
2771: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
2772: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
2773: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
2774: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2775: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2776: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 2773: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;

2769: l_control_rec OE_GLOBALS.Control_Rec_Type;
2770: l_api_name CONSTANT VARCHAR2(30) := 'Delete Order';
2771: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
2772: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
2773: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
2774: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2775: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2776: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2777: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;

Line 2774: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

2770: l_api_name CONSTANT VARCHAR2(30) := 'Delete Order';
2771: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
2772: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
2773: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
2774: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2775: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2776: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2777: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2778: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;

Line 2775: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

2771: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
2772: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
2773: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
2774: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2775: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2776: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2777: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2778: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2779: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;

Line 2776: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

2772: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
2773: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
2774: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2775: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2776: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2777: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2778: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2779: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
2780: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

Line 2777: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;

2773: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
2774: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2775: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2776: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2777: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2778: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2779: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
2780: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2781: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

Line 2778: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;

2774: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2775: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2776: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2777: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2778: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2779: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
2780: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2781: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2782: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

Line 2779: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;

2775: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2776: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2777: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2778: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2779: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
2780: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2781: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2782: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2783: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

Line 2780: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

2776: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2777: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2778: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2779: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
2780: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2781: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2782: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2783: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2784: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

Line 2781: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

2777: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2778: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2779: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
2780: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2781: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2782: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2783: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2784: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2785: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

Line 2782: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

2778: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2779: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
2780: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2781: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2782: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2783: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2784: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2785: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2786: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

Line 2783: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

2779: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
2780: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2781: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2782: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2783: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2784: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2785: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2786: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2787: l_return_status VARCHAR2(30);

Line 2784: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

2780: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2781: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2782: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2783: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2784: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2785: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2786: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2787: l_return_status VARCHAR2(30);
2788: l_org_id number;

Line 2785: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

2781: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2782: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2783: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2784: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2785: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2786: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2787: l_return_status VARCHAR2(30);
2788: l_org_id number;
2789:

Line 2786: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

2782: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2783: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2784: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2785: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2786: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2787: l_return_status VARCHAR2(30);
2788: l_org_id number;
2789:
2790: Begin

Line 2859: l_header_rec := OE_Order_PUB.G_MISS_HEADER_REC;

2855:
2856:
2857:
2858:
2859: l_header_rec := OE_Order_PUB.G_MISS_HEADER_REC;
2860: l_header_rec.header_id := p_header_id;
2861: -- Set Operation. Bug #1198949
2862: l_header_rec.operation := OE_GLOBALS.G_OPR_DELETE;
2863:

Line 2955: l_line_tbl OE_ORDER_PUB.Line_tbl_Type;

2951: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2952: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
2953: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2954: )IS
2955: l_line_tbl OE_ORDER_PUB.Line_tbl_Type;
2956: l_control_rec OE_GLOBALS.control_rec_type;
2957: l_api_name CONSTANT VARCHAR2(30) := 'Update Line';
2958: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
2959: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;

Line 2958: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;

2954: )IS
2955: l_line_tbl OE_ORDER_PUB.Line_tbl_Type;
2956: l_control_rec OE_GLOBALS.control_rec_type;
2957: l_api_name CONSTANT VARCHAR2(30) := 'Update Line';
2958: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
2959: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
2960: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
2961: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2962: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

Line 2959: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;

2955: l_line_tbl OE_ORDER_PUB.Line_tbl_Type;
2956: l_control_rec OE_GLOBALS.control_rec_type;
2957: l_api_name CONSTANT VARCHAR2(30) := 'Update Line';
2958: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
2959: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
2960: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
2961: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2962: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2963: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 2960: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;

2956: l_control_rec OE_GLOBALS.control_rec_type;
2957: l_api_name CONSTANT VARCHAR2(30) := 'Update Line';
2958: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
2959: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
2960: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
2961: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2962: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2963: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2964: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;

Line 2961: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

2957: l_api_name CONSTANT VARCHAR2(30) := 'Update Line';
2958: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
2959: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
2960: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
2961: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2962: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2963: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2964: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2965: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;

Line 2962: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

2958: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
2959: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
2960: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
2961: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2962: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2963: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2964: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2965: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2966: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;

Line 2963: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

2959: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
2960: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
2961: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2962: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2963: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2964: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2965: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2966: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
2967: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

Line 2964: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;

2960: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
2961: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2962: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2963: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2964: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2965: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2966: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
2967: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2968: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

Line 2965: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;

2961: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2962: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2963: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2964: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2965: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2966: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
2967: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2968: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2969: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

Line 2966: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;

2962: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2963: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2964: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2965: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2966: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
2967: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2968: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2969: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2970: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

Line 2967: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

2963: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2964: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2965: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2966: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
2967: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2968: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2969: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2970: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2971: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

Line 2968: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

2964: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2965: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2966: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
2967: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2968: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2969: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2970: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2971: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2972: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

Line 2969: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

2965: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2966: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
2967: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2968: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2969: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2970: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2971: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2972: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2973: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

Line 2970: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

2966: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
2967: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2968: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2969: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2970: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2971: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2972: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2973: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2974: l_return_status VARCHAR2(30);

Line 2971: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

2967: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2968: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2969: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2970: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2971: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2972: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2973: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2974: l_return_status VARCHAR2(30);
2975: l_org_id number;

Line 2972: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

2968: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2969: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2970: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2971: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2972: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2973: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2974: l_return_status VARCHAR2(30);
2975: l_org_id number;
2976:

Line 2973: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

2969: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2970: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2971: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2972: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2973: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2974: l_return_status VARCHAR2(30);
2975: l_org_id number;
2976:
2977: Begin

Line 3047: l_line_tbl(1) := OE_Order_PUB.G_MISS_LINE_REC;

3043:
3044:
3045:
3046:
3047: l_line_tbl(1) := OE_Order_PUB.G_MISS_LINE_REC;
3048: l_line_tbl(1).line_id := p_line_id;
3049:
3050: -- Set Operation.
3051:

Line 3146: l_header_rec OE_ORDER_PUB.Header_Rec_Type;

3142: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
3143: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
3144: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
3145: )IS
3146: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
3147: l_old_header_rec OE_ORDER_PUB.Header_Rec_Type;
3148: l_control_rec OE_GLOBALS.Control_Rec_Type;
3149: l_api_name CONSTANT VARCHAR2(30) := 'Process_header';
3150: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;

Line 3147: l_old_header_rec OE_ORDER_PUB.Header_Rec_Type;

3143: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
3144: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
3145: )IS
3146: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
3147: l_old_header_rec OE_ORDER_PUB.Header_Rec_Type;
3148: l_control_rec OE_GLOBALS.Control_Rec_Type;
3149: l_api_name CONSTANT VARCHAR2(30) := 'Process_header';
3150: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
3151: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;

Line 3150: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;

3146: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
3147: l_old_header_rec OE_ORDER_PUB.Header_Rec_Type;
3148: l_control_rec OE_GLOBALS.Control_Rec_Type;
3149: l_api_name CONSTANT VARCHAR2(30) := 'Process_header';
3150: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
3151: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
3152: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
3153: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3154: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

Line 3151: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;

3147: l_old_header_rec OE_ORDER_PUB.Header_Rec_Type;
3148: l_control_rec OE_GLOBALS.Control_Rec_Type;
3149: l_api_name CONSTANT VARCHAR2(30) := 'Process_header';
3150: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
3151: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
3152: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
3153: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3154: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3155: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 3152: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;

3148: l_control_rec OE_GLOBALS.Control_Rec_Type;
3149: l_api_name CONSTANT VARCHAR2(30) := 'Process_header';
3150: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
3151: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
3152: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
3153: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3154: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3155: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3156: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;

Line 3153: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

3149: l_api_name CONSTANT VARCHAR2(30) := 'Process_header';
3150: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
3151: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
3152: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
3153: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3154: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3155: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3156: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
3157: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;

Line 3154: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

3150: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
3151: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
3152: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
3153: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3154: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3155: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3156: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
3157: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
3158: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;

Line 3155: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

3151: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
3152: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
3153: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3154: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3155: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3156: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
3157: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
3158: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
3159: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

Line 3156: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;

3152: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
3153: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3154: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3155: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3156: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
3157: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
3158: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
3159: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3160: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

Line 3157: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;

3153: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3154: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3155: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3156: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
3157: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
3158: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
3159: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3160: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3161: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

Line 3158: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;

3154: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3155: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3156: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
3157: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
3158: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
3159: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3160: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3161: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3162: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

Line 3159: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

3155: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3156: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
3157: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
3158: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
3159: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3160: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3161: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3162: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3163: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

Line 3160: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

3156: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
3157: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
3158: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
3159: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3160: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3161: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3162: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3163: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
3164: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

Line 3161: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

3157: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
3158: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
3159: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3160: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3161: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3162: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3163: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
3164: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
3165: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

Line 3162: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

3158: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
3159: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3160: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3161: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3162: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3163: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
3164: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
3165: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
3166: l_return_status VARCHAR2(30);

Line 3163: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

3159: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3160: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3161: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3162: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3163: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
3164: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
3165: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
3166: l_return_status VARCHAR2(30);
3167: l_org_id number;

Line 3164: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

3160: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3161: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3162: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3163: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
3164: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
3165: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
3166: l_return_status VARCHAR2(30);
3167: l_org_id number;
3168:

Line 3165: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

3161: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3162: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3163: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
3164: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
3165: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
3166: l_return_status VARCHAR2(30);
3167: l_org_id number;
3168:
3169: BEGIN

Line 3238: l_header_rec := OE_Order_PUB.G_MISS_HEADER_REC;

3234:
3235:
3236:
3237:
3238: l_header_rec := OE_Order_PUB.G_MISS_HEADER_REC;
3239: l_header_rec.header_id := p_header_id;
3240:
3241: OE_Header_Util.Get_Ids
3242: ( p_x_header_rec => l_header_rec

Line 3346: l_line_rec OE_ORDER_PUB.Line_rec_Type;

3342: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
3343: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
3344: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
3345: )IS
3346: l_line_rec OE_ORDER_PUB.Line_rec_Type;
3347: l_line_tbl OE_ORDER_PUB.Line_tbl_Type;
3348: l_control_rec OE_GLOBALS.control_rec_type;
3349: l_api_name CONSTANT VARCHAR2(30) := 'Update Line';
3350: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;

Line 3347: l_line_tbl OE_ORDER_PUB.Line_tbl_Type;

3343: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
3344: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
3345: )IS
3346: l_line_rec OE_ORDER_PUB.Line_rec_Type;
3347: l_line_tbl OE_ORDER_PUB.Line_tbl_Type;
3348: l_control_rec OE_GLOBALS.control_rec_type;
3349: l_api_name CONSTANT VARCHAR2(30) := 'Update Line';
3350: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
3351: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;

Line 3350: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;

3346: l_line_rec OE_ORDER_PUB.Line_rec_Type;
3347: l_line_tbl OE_ORDER_PUB.Line_tbl_Type;
3348: l_control_rec OE_GLOBALS.control_rec_type;
3349: l_api_name CONSTANT VARCHAR2(30) := 'Update Line';
3350: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
3351: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
3352: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
3353: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3354: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

Line 3351: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;

3347: l_line_tbl OE_ORDER_PUB.Line_tbl_Type;
3348: l_control_rec OE_GLOBALS.control_rec_type;
3349: l_api_name CONSTANT VARCHAR2(30) := 'Update Line';
3350: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
3351: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
3352: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
3353: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3354: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3355: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 3352: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;

3348: l_control_rec OE_GLOBALS.control_rec_type;
3349: l_api_name CONSTANT VARCHAR2(30) := 'Update Line';
3350: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
3351: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
3352: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
3353: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3354: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3355: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3356: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;

Line 3353: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

3349: l_api_name CONSTANT VARCHAR2(30) := 'Update Line';
3350: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
3351: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
3352: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
3353: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3354: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3355: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3356: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
3357: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;

Line 3354: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

3350: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
3351: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
3352: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
3353: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3354: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3355: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3356: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
3357: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
3358: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;

Line 3355: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

3351: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
3352: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
3353: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3354: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3355: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3356: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
3357: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
3358: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
3359: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

Line 3356: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;

3352: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
3353: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3354: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3355: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3356: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
3357: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
3358: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
3359: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3360: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

Line 3357: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;

3353: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3354: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3355: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3356: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
3357: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
3358: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
3359: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3360: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3361: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

Line 3358: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;

3354: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3355: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3356: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
3357: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
3358: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
3359: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3360: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3361: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3362: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

Line 3359: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

3355: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3356: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
3357: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
3358: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
3359: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3360: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3361: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3362: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3363: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

Line 3360: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

3356: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
3357: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
3358: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
3359: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3360: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3361: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3362: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3363: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
3364: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

Line 3361: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

3357: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
3358: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
3359: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3360: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3361: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3362: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3363: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
3364: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
3365: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

Line 3362: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

3358: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
3359: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3360: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3361: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3362: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3363: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
3364: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
3365: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
3366: l_return_status VARCHAR2(30);

Line 3363: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

3359: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3360: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3361: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3362: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3363: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
3364: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
3365: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
3366: l_return_status VARCHAR2(30);
3367: l_org_id number;

Line 3364: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

3360: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3361: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3362: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3363: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
3364: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
3365: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
3366: l_return_status VARCHAR2(30);
3367: l_org_id number;
3368:

Line 3365: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

3361: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3362: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3363: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
3364: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
3365: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
3366: l_return_status VARCHAR2(30);
3367: l_org_id number;
3368:
3369: Begin

Line 3438: l_line_rec := OE_Order_PUB.G_MISS_LINE_REC;

3434:
3435:
3436:
3437:
3438: l_line_rec := OE_Order_PUB.G_MISS_LINE_REC;
3439: l_line_rec.line_id := p_line_id;
3440: OE_Line_Util.Get_Ids
3441: (p_x_line_rec => l_line_rec
3442: ,p_line_val_rec => p_Line_val_rec

Line 3713: l_aac_header_rec OE_Order_PUB.Header_Rec_Type;

3709: l_old_Line_Scredit_tbl Line_Scredit_Tbl_Type;
3710: l_old_Line_Payment_tbl Line_Payment_Tbl_Type;
3711: l_old_Lot_Serial_tbl Lot_Serial_Tbl_Type;
3712:
3713: l_aac_header_rec OE_Order_PUB.Header_Rec_Type;
3714: l_aac_line_tbl OE_Order_PUB.Line_Tbl_Type;
3715:
3716:
3717: BEGIN

Line 3714: l_aac_line_tbl OE_Order_PUB.Line_Tbl_Type;

3710: l_old_Line_Payment_tbl Line_Payment_Tbl_Type;
3711: l_old_Lot_Serial_tbl Lot_Serial_Tbl_Type;
3712:
3713: l_aac_header_rec OE_Order_PUB.Header_Rec_Type;
3714: l_aac_line_tbl OE_Order_PUB.Line_Tbl_Type;
3715:
3716:
3717: BEGIN
3718:

Line 5538: END OE_Order_PUB;

5534: G_MISS_LINE_REC.REVREC_IMPLICIT_FLAG := FND_API.G_MISS_CHAR;
5535: G_MISS_LINE_REC.mfg_lead_time := FND_API.G_MISS_NUM;
5536:
5537:
5538: END OE_Order_PUB;