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.24.12020000.5 2013/01/23 10:08:11 sujithku 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.24.12020000.5 2013/01/23 10:08:11 sujithku 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 1810: , p_header_customer_info_tbl IN OE_ORDER_PUB.CUSTOMER_INFO_TABLE_TYPE :=

1806: --For bug 3390458
1807: , p_rtrim_data IN Varchar2 :='N'
1808: , p_validate_desc_flex in varchar2 default 'Y' --bug4343612
1809: --ER7675548
1810: , p_header_customer_info_tbl IN OE_ORDER_PUB.CUSTOMER_INFO_TABLE_TYPE :=
1811: OE_ORDER_PUB.G_MISS_CUSTOMER_INFO_TBL
1812: , p_line_customer_info_tbl IN OE_ORDER_PUB.CUSTOMER_INFO_TABLE_TYPE :=
1813: OE_ORDER_PUB.G_MISS_CUSTOMER_INFO_TBL
1814: )

Line 1811: OE_ORDER_PUB.G_MISS_CUSTOMER_INFO_TBL

1807: , p_rtrim_data IN Varchar2 :='N'
1808: , p_validate_desc_flex in varchar2 default 'Y' --bug4343612
1809: --ER7675548
1810: , p_header_customer_info_tbl IN OE_ORDER_PUB.CUSTOMER_INFO_TABLE_TYPE :=
1811: OE_ORDER_PUB.G_MISS_CUSTOMER_INFO_TBL
1812: , p_line_customer_info_tbl IN OE_ORDER_PUB.CUSTOMER_INFO_TABLE_TYPE :=
1813: OE_ORDER_PUB.G_MISS_CUSTOMER_INFO_TBL
1814: )
1815: IS

Line 1812: , p_line_customer_info_tbl IN OE_ORDER_PUB.CUSTOMER_INFO_TABLE_TYPE :=

1808: , p_validate_desc_flex in varchar2 default 'Y' --bug4343612
1809: --ER7675548
1810: , p_header_customer_info_tbl IN OE_ORDER_PUB.CUSTOMER_INFO_TABLE_TYPE :=
1811: OE_ORDER_PUB.G_MISS_CUSTOMER_INFO_TBL
1812: , p_line_customer_info_tbl IN OE_ORDER_PUB.CUSTOMER_INFO_TABLE_TYPE :=
1813: OE_ORDER_PUB.G_MISS_CUSTOMER_INFO_TBL
1814: )
1815: IS
1816: l_api_version_number CONSTANT NUMBER := 1.0;

Line 1813: OE_ORDER_PUB.G_MISS_CUSTOMER_INFO_TBL

1809: --ER7675548
1810: , p_header_customer_info_tbl IN OE_ORDER_PUB.CUSTOMER_INFO_TABLE_TYPE :=
1811: OE_ORDER_PUB.G_MISS_CUSTOMER_INFO_TBL
1812: , p_line_customer_info_tbl IN OE_ORDER_PUB.CUSTOMER_INFO_TABLE_TYPE :=
1813: OE_ORDER_PUB.G_MISS_CUSTOMER_INFO_TBL
1814: )
1815: IS
1816: l_api_version_number CONSTANT NUMBER := 1.0;
1817: l_api_name CONSTANT VARCHAR2(30):= 'Process_Order';

Line 2527: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

2523: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2524: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
2525: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2526: ) IS
2527: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2528: l_control_rec OE_GLOBALS.control_rec_type;
2529: l_api_name CONSTANT VARCHAR2(30) := 'Update Line';
2530: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
2531: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;

Line 2530: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;

2526: ) IS
2527: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2528: l_control_rec OE_GLOBALS.control_rec_type;
2529: l_api_name CONSTANT VARCHAR2(30) := 'Update Line';
2530: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
2531: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
2532: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2533: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2534: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 2531: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;

2527: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2528: l_control_rec OE_GLOBALS.control_rec_type;
2529: l_api_name CONSTANT VARCHAR2(30) := 'Update Line';
2530: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
2531: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
2532: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2533: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2534: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2535: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;

Line 2532: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

2528: l_control_rec OE_GLOBALS.control_rec_type;
2529: l_api_name CONSTANT VARCHAR2(30) := 'Update Line';
2530: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
2531: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
2532: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2533: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2534: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2535: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2536: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;

Line 2533: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

2529: l_api_name CONSTANT VARCHAR2(30) := 'Update Line';
2530: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
2531: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
2532: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2533: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2534: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2535: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2536: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2537: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;

Line 2534: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

2530: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
2531: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
2532: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2533: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2534: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2535: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2536: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2537: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
2538: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

Line 2535: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;

2531: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
2532: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2533: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2534: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2535: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2536: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2537: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
2538: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2539: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

Line 2536: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;

2532: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2533: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2534: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2535: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2536: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2537: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
2538: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2539: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2540: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

Line 2537: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;

2533: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2534: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2535: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2536: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2537: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
2538: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2539: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2540: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2541: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

Line 2538: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

2534: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2535: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2536: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2537: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
2538: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2539: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2540: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2541: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2542: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

Line 2539: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

2535: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2536: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2537: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
2538: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2539: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2540: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2541: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2542: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2543: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

Line 2540: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

2536: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2537: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
2538: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2539: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2540: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2541: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2542: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2543: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2544: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

Line 2541: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

2537: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
2538: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2539: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2540: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2541: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2542: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2543: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2544: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2545: l_return_status VARCHAR2(30);

Line 2542: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

2538: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2539: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2540: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2541: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2542: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2543: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2544: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2545: l_return_status VARCHAR2(30);
2546: l_org_id number;

Line 2543: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

2539: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2540: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2541: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2542: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2543: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2544: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2545: l_return_status VARCHAR2(30);
2546: l_org_id number;
2547:

Line 2544: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

2540: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2541: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2542: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2543: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2544: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2545: l_return_status VARCHAR2(30);
2546: l_org_id number;
2547:
2548: BEGIN

Line 2723: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;

2719: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2720: )IS
2721: l_control_rec OE_GLOBALS.Control_Rec_Type;
2722: l_api_name CONSTANT VARCHAR2(30) := 'Process_header';
2723: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
2724: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
2725: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2726: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2727: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 2724: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;

2720: )IS
2721: l_control_rec OE_GLOBALS.Control_Rec_Type;
2722: l_api_name CONSTANT VARCHAR2(30) := 'Process_header';
2723: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
2724: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
2725: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2726: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2727: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2728: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;

Line 2725: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

2721: l_control_rec OE_GLOBALS.Control_Rec_Type;
2722: l_api_name CONSTANT VARCHAR2(30) := 'Process_header';
2723: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
2724: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
2725: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2726: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2727: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2728: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2729: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;

Line 2726: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

2722: l_api_name CONSTANT VARCHAR2(30) := 'Process_header';
2723: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
2724: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
2725: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2726: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2727: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2728: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2729: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2730: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;

Line 2727: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

2723: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
2724: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
2725: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2726: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2727: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2728: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2729: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2730: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
2731: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

Line 2728: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;

2724: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
2725: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2726: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2727: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2728: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2729: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2730: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
2731: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2732: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

Line 2729: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;

2725: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2726: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2727: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2728: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2729: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2730: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
2731: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2732: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2733: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

Line 2730: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;

2726: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2727: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2728: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2729: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2730: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
2731: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2732: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2733: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2734: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

Line 2731: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

2727: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2728: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2729: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2730: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
2731: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2732: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2733: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2734: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2735: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

Line 2732: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

2728: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2729: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2730: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
2731: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2732: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2733: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2734: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2735: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2736: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

Line 2733: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

2729: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2730: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
2731: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2732: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2733: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2734: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2735: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2736: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2737: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

Line 2734: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

2730: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
2731: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2732: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2733: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2734: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2735: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2736: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2737: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2738: l_return_status VARCHAR2(30);

Line 2735: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

2731: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2732: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2733: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2734: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2735: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2736: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2737: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2738: l_return_status VARCHAR2(30);
2739: l_org_id number;

Line 2736: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

2732: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2733: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2734: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2735: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2736: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2737: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2738: l_return_status VARCHAR2(30);
2739: l_org_id number;
2740:

Line 2737: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

2733: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2734: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2735: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2736: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2737: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2738: l_return_status VARCHAR2(30);
2739: l_org_id number;
2740:
2741: Begin

Line 2902: l_header_rec OE_ORDER_PUB.Header_Rec_Type;

2898: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2899: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
2900: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2901: )IS
2902: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
2903: l_old_header_rec OE_ORDER_PUB.Header_Rec_Type;
2904: l_control_rec OE_GLOBALS.Control_Rec_Type;
2905: l_api_name CONSTANT VARCHAR2(30) := 'Delete Order';
2906: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;

Line 2903: l_old_header_rec OE_ORDER_PUB.Header_Rec_Type;

2899: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
2900: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2901: )IS
2902: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
2903: l_old_header_rec OE_ORDER_PUB.Header_Rec_Type;
2904: l_control_rec OE_GLOBALS.Control_Rec_Type;
2905: l_api_name CONSTANT VARCHAR2(30) := 'Delete Order';
2906: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
2907: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;

Line 2906: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;

2902: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
2903: l_old_header_rec OE_ORDER_PUB.Header_Rec_Type;
2904: l_control_rec OE_GLOBALS.Control_Rec_Type;
2905: l_api_name CONSTANT VARCHAR2(30) := 'Delete Order';
2906: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
2907: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
2908: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
2909: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2910: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

Line 2907: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;

2903: l_old_header_rec OE_ORDER_PUB.Header_Rec_Type;
2904: l_control_rec OE_GLOBALS.Control_Rec_Type;
2905: l_api_name CONSTANT VARCHAR2(30) := 'Delete Order';
2906: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
2907: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
2908: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
2909: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2910: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2911: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 2908: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;

2904: l_control_rec OE_GLOBALS.Control_Rec_Type;
2905: l_api_name CONSTANT VARCHAR2(30) := 'Delete Order';
2906: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
2907: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
2908: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
2909: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2910: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2911: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2912: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;

Line 2909: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

2905: l_api_name CONSTANT VARCHAR2(30) := 'Delete Order';
2906: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
2907: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
2908: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
2909: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2910: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2911: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2912: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2913: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;

Line 2910: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

2906: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
2907: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
2908: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
2909: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2910: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2911: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2912: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2913: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2914: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;

Line 2911: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

2907: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
2908: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
2909: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2910: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2911: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2912: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2913: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2914: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
2915: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

Line 2912: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;

2908: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
2909: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2910: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2911: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2912: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2913: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2914: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
2915: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2916: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

Line 2913: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;

2909: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2910: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2911: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2912: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2913: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2914: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
2915: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2916: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2917: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

Line 2914: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;

2910: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2911: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2912: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2913: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2914: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
2915: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2916: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2917: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2918: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

Line 2915: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

2911: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2912: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2913: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2914: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
2915: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2916: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2917: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2918: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2919: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

Line 2916: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

2912: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2913: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2914: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
2915: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2916: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2917: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2918: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2919: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2920: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

Line 2917: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

2913: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2914: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
2915: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2916: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2917: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2918: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2919: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2920: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2921: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

Line 2918: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

2914: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
2915: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2916: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2917: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2918: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2919: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2920: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2921: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2922: l_return_status VARCHAR2(30);

Line 2919: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

2915: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2916: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2917: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2918: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2919: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2920: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2921: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2922: l_return_status VARCHAR2(30);
2923: l_org_id number;

Line 2920: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

2916: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2917: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2918: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2919: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2920: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2921: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2922: l_return_status VARCHAR2(30);
2923: l_org_id number;
2924:

Line 2921: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

2917: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2918: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2919: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2920: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2921: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2922: l_return_status VARCHAR2(30);
2923: l_org_id number;
2924:
2925: Begin

Line 2994: l_header_rec := OE_Order_PUB.G_MISS_HEADER_REC;

2990:
2991:
2992:
2993:
2994: l_header_rec := OE_Order_PUB.G_MISS_HEADER_REC;
2995: l_header_rec.header_id := p_header_id;
2996: -- Set Operation. Bug #1198949
2997: l_header_rec.operation := OE_GLOBALS.G_OPR_DELETE;
2998:

Line 3090: l_line_tbl OE_ORDER_PUB.Line_tbl_Type;

3086: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
3087: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
3088: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
3089: )IS
3090: l_line_tbl OE_ORDER_PUB.Line_tbl_Type;
3091: l_control_rec OE_GLOBALS.control_rec_type;
3092: l_api_name CONSTANT VARCHAR2(30) := 'Update Line';
3093: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
3094: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;

Line 3093: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;

3089: )IS
3090: l_line_tbl OE_ORDER_PUB.Line_tbl_Type;
3091: l_control_rec OE_GLOBALS.control_rec_type;
3092: l_api_name CONSTANT VARCHAR2(30) := 'Update Line';
3093: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
3094: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
3095: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
3096: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3097: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

Line 3094: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;

3090: l_line_tbl OE_ORDER_PUB.Line_tbl_Type;
3091: l_control_rec OE_GLOBALS.control_rec_type;
3092: l_api_name CONSTANT VARCHAR2(30) := 'Update Line';
3093: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
3094: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
3095: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
3096: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3097: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3098: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 3095: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;

3091: l_control_rec OE_GLOBALS.control_rec_type;
3092: l_api_name CONSTANT VARCHAR2(30) := 'Update Line';
3093: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
3094: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
3095: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
3096: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3097: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3098: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3099: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;

Line 3096: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

3092: l_api_name CONSTANT VARCHAR2(30) := 'Update Line';
3093: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
3094: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
3095: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
3096: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3097: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3098: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3099: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
3100: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;

Line 3097: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

3093: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
3094: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
3095: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
3096: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3097: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3098: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3099: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
3100: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
3101: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;

Line 3098: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

3094: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
3095: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
3096: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3097: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3098: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3099: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
3100: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
3101: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
3102: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

Line 3099: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;

3095: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
3096: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3097: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3098: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3099: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
3100: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
3101: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
3102: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3103: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

Line 3100: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;

3096: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3097: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3098: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3099: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
3100: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
3101: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
3102: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3103: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3104: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

Line 3101: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;

3097: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3098: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3099: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
3100: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
3101: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
3102: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3103: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3104: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3105: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

Line 3102: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

3098: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3099: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
3100: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
3101: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
3102: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3103: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3104: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3105: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3106: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

Line 3103: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

3099: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
3100: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
3101: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
3102: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3103: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3104: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3105: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3106: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
3107: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

Line 3104: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

3100: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
3101: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
3102: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3103: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3104: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3105: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3106: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
3107: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
3108: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

Line 3105: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

3101: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
3102: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3103: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3104: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3105: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3106: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
3107: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
3108: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
3109: l_return_status VARCHAR2(30);

Line 3106: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

3102: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3103: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3104: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3105: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3106: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
3107: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
3108: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
3109: l_return_status VARCHAR2(30);
3110: l_org_id number;

Line 3107: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

3103: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3104: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3105: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3106: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
3107: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
3108: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
3109: l_return_status VARCHAR2(30);
3110: l_org_id number;
3111:

Line 3108: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

3104: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3105: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3106: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
3107: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
3108: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
3109: l_return_status VARCHAR2(30);
3110: l_org_id number;
3111:
3112: Begin

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

3178:
3179:
3180:
3181:
3182: l_line_tbl(1) := OE_Order_PUB.G_MISS_LINE_REC;
3183: l_line_tbl(1).line_id := p_line_id;
3184:
3185: -- Set Operation.
3186:

Line 3281: l_header_rec OE_ORDER_PUB.Header_Rec_Type;

3277: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
3278: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
3279: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
3280: )IS
3281: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
3282: l_old_header_rec OE_ORDER_PUB.Header_Rec_Type;
3283: l_control_rec OE_GLOBALS.Control_Rec_Type;
3284: l_api_name CONSTANT VARCHAR2(30) := 'Process_header';
3285: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;

Line 3282: l_old_header_rec OE_ORDER_PUB.Header_Rec_Type;

3278: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
3279: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
3280: )IS
3281: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
3282: l_old_header_rec OE_ORDER_PUB.Header_Rec_Type;
3283: l_control_rec OE_GLOBALS.Control_Rec_Type;
3284: l_api_name CONSTANT VARCHAR2(30) := 'Process_header';
3285: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
3286: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;

Line 3285: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;

3281: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
3282: l_old_header_rec OE_ORDER_PUB.Header_Rec_Type;
3283: l_control_rec OE_GLOBALS.Control_Rec_Type;
3284: l_api_name CONSTANT VARCHAR2(30) := 'Process_header';
3285: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
3286: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
3287: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
3288: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3289: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

Line 3286: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;

3282: l_old_header_rec OE_ORDER_PUB.Header_Rec_Type;
3283: l_control_rec OE_GLOBALS.Control_Rec_Type;
3284: l_api_name CONSTANT VARCHAR2(30) := 'Process_header';
3285: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
3286: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
3287: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
3288: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3289: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3290: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 3287: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;

3283: l_control_rec OE_GLOBALS.Control_Rec_Type;
3284: l_api_name CONSTANT VARCHAR2(30) := 'Process_header';
3285: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
3286: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
3287: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
3288: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3289: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3290: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3291: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;

Line 3288: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

3284: l_api_name CONSTANT VARCHAR2(30) := 'Process_header';
3285: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
3286: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
3287: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
3288: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3289: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3290: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3291: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
3292: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;

Line 3289: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

3285: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
3286: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
3287: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
3288: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3289: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3290: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3291: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
3292: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
3293: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;

Line 3290: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

3286: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
3287: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
3288: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3289: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3290: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3291: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
3292: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
3293: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
3294: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

Line 3291: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;

3287: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
3288: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3289: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3290: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3291: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
3292: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
3293: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
3294: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3295: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

Line 3292: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;

3288: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3289: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3290: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3291: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
3292: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
3293: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
3294: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3295: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3296: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

Line 3293: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;

3289: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3290: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3291: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
3292: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
3293: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
3294: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3295: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3296: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3297: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

Line 3294: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

3290: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3291: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
3292: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
3293: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
3294: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3295: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3296: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3297: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3298: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

Line 3295: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

3291: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
3292: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
3293: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
3294: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3295: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3296: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3297: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3298: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
3299: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

Line 3296: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

3292: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
3293: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
3294: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3295: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3296: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3297: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3298: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
3299: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
3300: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

Line 3297: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

3293: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
3294: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3295: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3296: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3297: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3298: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
3299: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
3300: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
3301: l_return_status VARCHAR2(30);

Line 3298: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

3294: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3295: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3296: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3297: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3298: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
3299: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
3300: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
3301: l_return_status VARCHAR2(30);
3302: l_org_id number;

Line 3299: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

3295: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3296: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3297: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3298: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
3299: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
3300: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
3301: l_return_status VARCHAR2(30);
3302: l_org_id number;
3303:

Line 3300: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

3296: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3297: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3298: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
3299: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
3300: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
3301: l_return_status VARCHAR2(30);
3302: l_org_id number;
3303:
3304: BEGIN

Line 3373: l_header_rec := OE_Order_PUB.G_MISS_HEADER_REC;

3369:
3370:
3371:
3372:
3373: l_header_rec := OE_Order_PUB.G_MISS_HEADER_REC;
3374: l_header_rec.header_id := p_header_id;
3375: l_header_rec.operation := OE_GLOBALS.G_OPR_UPDATE; -- Bug 8340976
3376:
3377:

Line 3485: l_line_rec OE_ORDER_PUB.Line_rec_Type;

3481: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
3482: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
3483: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
3484: )IS
3485: l_line_rec OE_ORDER_PUB.Line_rec_Type;
3486: l_line_tbl OE_ORDER_PUB.Line_tbl_Type;
3487: l_control_rec OE_GLOBALS.control_rec_type;
3488: l_api_name CONSTANT VARCHAR2(30) := 'Update Line';
3489: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;

Line 3486: l_line_tbl OE_ORDER_PUB.Line_tbl_Type;

3482: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
3483: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
3484: )IS
3485: l_line_rec OE_ORDER_PUB.Line_rec_Type;
3486: l_line_tbl OE_ORDER_PUB.Line_tbl_Type;
3487: l_control_rec OE_GLOBALS.control_rec_type;
3488: l_api_name CONSTANT VARCHAR2(30) := 'Update Line';
3489: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
3490: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;

Line 3489: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;

3485: l_line_rec OE_ORDER_PUB.Line_rec_Type;
3486: l_line_tbl OE_ORDER_PUB.Line_tbl_Type;
3487: l_control_rec OE_GLOBALS.control_rec_type;
3488: l_api_name CONSTANT VARCHAR2(30) := 'Update Line';
3489: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
3490: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
3491: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
3492: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3493: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

Line 3490: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;

3486: l_line_tbl OE_ORDER_PUB.Line_tbl_Type;
3487: l_control_rec OE_GLOBALS.control_rec_type;
3488: l_api_name CONSTANT VARCHAR2(30) := 'Update Line';
3489: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
3490: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
3491: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
3492: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3493: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3494: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 3491: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;

3487: l_control_rec OE_GLOBALS.control_rec_type;
3488: l_api_name CONSTANT VARCHAR2(30) := 'Update Line';
3489: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
3490: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
3491: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
3492: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3493: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3494: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3495: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;

Line 3492: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

3488: l_api_name CONSTANT VARCHAR2(30) := 'Update Line';
3489: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
3490: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
3491: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
3492: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3493: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3494: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3495: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
3496: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;

Line 3493: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

3489: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
3490: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
3491: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
3492: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3493: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3494: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3495: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
3496: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
3497: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;

Line 3494: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

3490: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
3491: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
3492: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3493: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3494: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3495: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
3496: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
3497: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
3498: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

Line 3495: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;

3491: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
3492: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3493: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3494: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3495: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
3496: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
3497: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
3498: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3499: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

Line 3496: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;

3492: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3493: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3494: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3495: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
3496: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
3497: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
3498: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3499: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3500: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

Line 3497: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;

3493: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3494: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3495: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
3496: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
3497: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
3498: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3499: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3500: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3501: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

Line 3498: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

3494: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3495: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
3496: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
3497: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
3498: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3499: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3500: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3501: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3502: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

Line 3499: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

3495: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
3496: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
3497: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
3498: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3499: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3500: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3501: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3502: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
3503: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

Line 3500: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

3496: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
3497: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
3498: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3499: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3500: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3501: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3502: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
3503: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
3504: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

Line 3501: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

3497: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
3498: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3499: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3500: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3501: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3502: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
3503: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
3504: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
3505: l_return_status VARCHAR2(30);

Line 3502: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

3498: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3499: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3500: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3501: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3502: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
3503: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
3504: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
3505: l_return_status VARCHAR2(30);
3506: l_org_id number;

Line 3503: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

3499: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3500: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3501: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3502: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
3503: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
3504: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
3505: l_return_status VARCHAR2(30);
3506: l_org_id number;
3507:

Line 3504: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

3500: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3501: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3502: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
3503: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
3504: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
3505: l_return_status VARCHAR2(30);
3506: l_org_id number;
3507:
3508: Begin

Line 3577: l_line_rec := OE_Order_PUB.G_MISS_LINE_REC;

3573:
3574:
3575:
3576:
3577: l_line_rec := OE_Order_PUB.G_MISS_LINE_REC;
3578: l_line_rec.line_id := p_line_id;
3579: OE_Line_Util.Get_Ids
3580: (p_x_line_rec => l_line_rec
3581: ,p_line_val_rec => p_Line_val_rec

Line 3812: , p_header_customer_info_tbl IN OE_ORDER_PUB.CUSTOMER_INFO_TABLE_TYPE :=

3808: --For bug 3390458
3809: , p_rtrim_data IN Varchar2 :='N'
3810: , p_validate_desc_flex in varchar2 default 'Y' --bug4343612
3811: --ER7675548
3812: , p_header_customer_info_tbl IN OE_ORDER_PUB.CUSTOMER_INFO_TABLE_TYPE :=
3813: OE_ORDER_PUB.G_MISS_CUSTOMER_INFO_TBL
3814: , p_line_customer_info_tbl IN OE_ORDER_PUB.CUSTOMER_INFO_TABLE_TYPE :=
3815: OE_ORDER_PUB.G_MISS_CUSTOMER_INFO_TBL
3816: )

Line 3813: OE_ORDER_PUB.G_MISS_CUSTOMER_INFO_TBL

3809: , p_rtrim_data IN Varchar2 :='N'
3810: , p_validate_desc_flex in varchar2 default 'Y' --bug4343612
3811: --ER7675548
3812: , p_header_customer_info_tbl IN OE_ORDER_PUB.CUSTOMER_INFO_TABLE_TYPE :=
3813: OE_ORDER_PUB.G_MISS_CUSTOMER_INFO_TBL
3814: , p_line_customer_info_tbl IN OE_ORDER_PUB.CUSTOMER_INFO_TABLE_TYPE :=
3815: OE_ORDER_PUB.G_MISS_CUSTOMER_INFO_TBL
3816: )
3817: IS

Line 3814: , p_line_customer_info_tbl IN OE_ORDER_PUB.CUSTOMER_INFO_TABLE_TYPE :=

3810: , p_validate_desc_flex in varchar2 default 'Y' --bug4343612
3811: --ER7675548
3812: , p_header_customer_info_tbl IN OE_ORDER_PUB.CUSTOMER_INFO_TABLE_TYPE :=
3813: OE_ORDER_PUB.G_MISS_CUSTOMER_INFO_TBL
3814: , p_line_customer_info_tbl IN OE_ORDER_PUB.CUSTOMER_INFO_TABLE_TYPE :=
3815: OE_ORDER_PUB.G_MISS_CUSTOMER_INFO_TBL
3816: )
3817: IS
3818: --MOAC

Line 3815: OE_ORDER_PUB.G_MISS_CUSTOMER_INFO_TBL

3811: --ER7675548
3812: , p_header_customer_info_tbl IN OE_ORDER_PUB.CUSTOMER_INFO_TABLE_TYPE :=
3813: OE_ORDER_PUB.G_MISS_CUSTOMER_INFO_TBL
3814: , p_line_customer_info_tbl IN OE_ORDER_PUB.CUSTOMER_INFO_TABLE_TYPE :=
3815: OE_ORDER_PUB.G_MISS_CUSTOMER_INFO_TBL
3816: )
3817: IS
3818: --MOAC
3819: l_org_id NUMBER;

Line 3857: l_aac_header_rec OE_Order_PUB.Header_Rec_Type;

3853: l_old_Line_Scredit_tbl Line_Scredit_Tbl_Type;
3854: l_old_Line_Payment_tbl Line_Payment_Tbl_Type;
3855: l_old_Lot_Serial_tbl Lot_Serial_Tbl_Type;
3856:
3857: l_aac_header_rec OE_Order_PUB.Header_Rec_Type;
3858: l_aac_line_tbl OE_Order_PUB.Line_Tbl_Type;
3859:
3860: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3861: l_cust_info_tbl OE_ORDER_PUB.CUSTOMER_INFO_TABLE_TYPE; --ER7675548

Line 3858: l_aac_line_tbl OE_Order_PUB.Line_Tbl_Type;

3854: l_old_Line_Payment_tbl Line_Payment_Tbl_Type;
3855: l_old_Lot_Serial_tbl Lot_Serial_Tbl_Type;
3856:
3857: l_aac_header_rec OE_Order_PUB.Header_Rec_Type;
3858: l_aac_line_tbl OE_Order_PUB.Line_Tbl_Type;
3859:
3860: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3861: l_cust_info_tbl OE_ORDER_PUB.CUSTOMER_INFO_TABLE_TYPE; --ER7675548
3862: BEGIN

Line 3861: l_cust_info_tbl OE_ORDER_PUB.CUSTOMER_INFO_TABLE_TYPE; --ER7675548

3857: l_aac_header_rec OE_Order_PUB.Header_Rec_Type;
3858: l_aac_line_tbl OE_Order_PUB.Line_Tbl_Type;
3859:
3860: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3861: l_cust_info_tbl OE_ORDER_PUB.CUSTOMER_INFO_TABLE_TYPE; --ER7675548
3862: BEGIN
3863:
3864: -- Standard call to check for call compatibility
3865:

Line 5765: END OE_Order_PUB;

5761: G_MISS_LINE_REC.service_first_period_enddate := FND_API.G_MISS_DATE;
5762: -- sol_ord_er #16014165
5763: G_MISS_LINE_REC.fulfillment_base := FND_API.G_MISS_CHAR; --ER#14763609
5764:
5765: END OE_Order_PUB;