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.OTA_WF dependencies on OE_ORDER_PUB

Line 77: l_header_rec OE_Order_PUB.Header_Rec_Type;

73: l_return_values varchar2(50);
74: l_return_status VARCHAR2(1) ;
75: l_msg_count NUMBER;
76: l_msg_data VARCHAR2(2000);
77: l_header_rec OE_Order_PUB.Header_Rec_Type;
78: x_header_rec OE_Order_PUB.Header_Rec_Type; --added for bug 6347596
79: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
80: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
81: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;

Line 78: x_header_rec OE_Order_PUB.Header_Rec_Type; --added for bug 6347596

74: l_return_status VARCHAR2(1) ;
75: l_msg_count NUMBER;
76: l_msg_data VARCHAR2(2000);
77: l_header_rec OE_Order_PUB.Header_Rec_Type;
78: x_header_rec OE_Order_PUB.Header_Rec_Type; --added for bug 6347596
79: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
80: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
81: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
82: l_header_price_att_tbl OE_Order_PUB.header_Price_Att_Tbl_Type;

Line 79: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;

75: l_msg_count NUMBER;
76: l_msg_data VARCHAR2(2000);
77: l_header_rec OE_Order_PUB.Header_Rec_Type;
78: x_header_rec OE_Order_PUB.Header_Rec_Type; --added for bug 6347596
79: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
80: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
81: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
82: l_header_price_att_tbl OE_Order_PUB.header_Price_Att_Tbl_Type;
83: l_header_adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

Line 80: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

76: l_msg_data VARCHAR2(2000);
77: l_header_rec OE_Order_PUB.Header_Rec_Type;
78: x_header_rec OE_Order_PUB.Header_Rec_Type; --added for bug 6347596
79: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
80: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
81: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
82: l_header_price_att_tbl OE_Order_PUB.header_Price_Att_Tbl_Type;
83: l_header_adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
84: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

Line 81: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;

77: l_header_rec OE_Order_PUB.Header_Rec_Type;
78: x_header_rec OE_Order_PUB.Header_Rec_Type; --added for bug 6347596
79: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
80: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
81: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
82: l_header_price_att_tbl OE_Order_PUB.header_Price_Att_Tbl_Type;
83: l_header_adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
84: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
85: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

Line 82: l_header_price_att_tbl OE_Order_PUB.header_Price_Att_Tbl_Type;

78: x_header_rec OE_Order_PUB.Header_Rec_Type; --added for bug 6347596
79: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
80: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
81: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
82: l_header_price_att_tbl OE_Order_PUB.header_Price_Att_Tbl_Type;
83: l_header_adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
84: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
85: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
86: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;

Line 83: l_header_adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

79: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
80: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
81: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
82: l_header_price_att_tbl OE_Order_PUB.header_Price_Att_Tbl_Type;
83: l_header_adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
84: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
85: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
86: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
87: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

Line 84: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

80: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
81: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
82: l_header_price_att_tbl OE_Order_PUB.header_Price_Att_Tbl_Type;
83: l_header_adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
84: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
85: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
86: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
87: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
88: x_line_tbl OE_Order_PUB.Line_Tbl_Type; --added for bug 6347596

Line 85: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

81: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
82: l_header_price_att_tbl OE_Order_PUB.header_Price_Att_Tbl_Type;
83: l_header_adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
84: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
85: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
86: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
87: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
88: x_line_tbl OE_Order_PUB.Line_Tbl_Type; --added for bug 6347596
89: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;

Line 86: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;

82: l_header_price_att_tbl OE_Order_PUB.header_Price_Att_Tbl_Type;
83: l_header_adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
84: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
85: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
86: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
87: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
88: x_line_tbl OE_Order_PUB.Line_Tbl_Type; --added for bug 6347596
89: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
90: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

Line 87: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

83: l_header_adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
84: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
85: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
86: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
87: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
88: x_line_tbl OE_Order_PUB.Line_Tbl_Type; --added for bug 6347596
89: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
90: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
91: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;

Line 88: x_line_tbl OE_Order_PUB.Line_Tbl_Type; --added for bug 6347596

84: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
85: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
86: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
87: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
88: x_line_tbl OE_Order_PUB.Line_Tbl_Type; --added for bug 6347596
89: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
90: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
91: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
92: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;

Line 89: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;

85: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
86: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
87: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
88: x_line_tbl OE_Order_PUB.Line_Tbl_Type; --added for bug 6347596
89: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
90: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
91: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
92: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
93: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;

Line 90: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

86: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
87: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
88: x_line_tbl OE_Order_PUB.Line_Tbl_Type; --added for bug 6347596
89: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
90: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
91: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
92: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
93: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
94: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;

Line 91: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;

87: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
88: x_line_tbl OE_Order_PUB.Line_Tbl_Type; --added for bug 6347596
89: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
90: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
91: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
92: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
93: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
94: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
95: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 92: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;

88: x_line_tbl OE_Order_PUB.Line_Tbl_Type; --added for bug 6347596
89: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
90: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
91: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
92: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
93: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
94: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
95: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
96: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;

Line 93: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;

89: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
90: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
91: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
92: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
93: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
94: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
95: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
96: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
97: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

Line 94: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;

90: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
91: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
92: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
93: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
94: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
95: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
96: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
97: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
98: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;

Line 95: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

91: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
92: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
93: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
94: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
95: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
96: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
97: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
98: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
99: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type ;

Line 96: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;

92: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
93: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
94: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
95: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
96: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
97: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
98: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
99: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type ;
100:

Line 97: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

93: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
94: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
95: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
96: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
97: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
98: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
99: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type ;
100:
101: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;

Line 98: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;

94: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
95: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
96: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
97: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
98: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
99: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type ;
100:
101: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
102: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=

Line 99: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type ;

95: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
96: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
97: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
98: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
99: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type ;
100:
101: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
102: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=
103: OE_Order_PUB.G_MISS_REQUEST_TBL;

Line 101: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;

97: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
98: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
99: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type ;
100:
101: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
102: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=
103: OE_Order_PUB.G_MISS_REQUEST_TBL;
104:
105: l_old_header_rec OE_Order_PUB.Header_Rec_Type ;

Line 102: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=

98: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
99: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type ;
100:
101: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
102: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=
103: OE_Order_PUB.G_MISS_REQUEST_TBL;
104:
105: l_old_header_rec OE_Order_PUB.Header_Rec_Type ;
106: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type ;

Line 103: OE_Order_PUB.G_MISS_REQUEST_TBL;

99: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type ;
100:
101: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
102: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=
103: OE_Order_PUB.G_MISS_REQUEST_TBL;
104:
105: l_old_header_rec OE_Order_PUB.Header_Rec_Type ;
106: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type ;
107: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type ;

Line 105: l_old_header_rec OE_Order_PUB.Header_Rec_Type ;

101: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
102: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=
103: OE_Order_PUB.G_MISS_REQUEST_TBL;
104:
105: l_old_header_rec OE_Order_PUB.Header_Rec_Type ;
106: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type ;
107: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type ;
108: l_old_Header_Adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type ;
109: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;

Line 106: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type ;

102: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=
103: OE_Order_PUB.G_MISS_REQUEST_TBL;
104:
105: l_old_header_rec OE_Order_PUB.Header_Rec_Type ;
106: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type ;
107: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type ;
108: l_old_Header_Adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type ;
109: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
110: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;

Line 107: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type ;

103: OE_Order_PUB.G_MISS_REQUEST_TBL;
104:
105: l_old_header_rec OE_Order_PUB.Header_Rec_Type ;
106: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type ;
107: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type ;
108: l_old_Header_Adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type ;
109: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
110: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
111: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;

Line 108: l_old_Header_Adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type ;

104:
105: l_old_header_rec OE_Order_PUB.Header_Rec_Type ;
106: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type ;
107: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type ;
108: l_old_Header_Adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type ;
109: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
110: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
111: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
112: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type ;

Line 109: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;

105: l_old_header_rec OE_Order_PUB.Header_Rec_Type ;
106: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type ;
107: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type ;
108: l_old_Header_Adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type ;
109: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
110: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
111: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
112: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type ;
113: l_old_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type ;

Line 110: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;

106: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type ;
107: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type ;
108: l_old_Header_Adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type ;
109: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
110: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
111: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
112: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type ;
113: l_old_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type ;
114: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type ;

Line 111: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;

107: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type ;
108: l_old_Header_Adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type ;
109: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
110: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
111: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
112: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type ;
113: l_old_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type ;
114: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type ;
115: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type ;

Line 112: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type ;

108: l_old_Header_Adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type ;
109: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
110: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
111: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
112: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type ;
113: l_old_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type ;
114: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type ;
115: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type ;
116: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type ;

Line 113: l_old_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type ;

109: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
110: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
111: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
112: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type ;
113: l_old_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type ;
114: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type ;
115: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type ;
116: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type ;
117: l_old_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type ;

Line 114: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type ;

110: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
111: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
112: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type ;
113: l_old_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type ;
114: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type ;
115: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type ;
116: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type ;
117: l_old_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type ;
118: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;

Line 115: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type ;

111: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
112: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type ;
113: l_old_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type ;
114: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type ;
115: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type ;
116: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type ;
117: l_old_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type ;
118: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
119: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;

Line 116: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type ;

112: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type ;
113: l_old_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type ;
114: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type ;
115: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type ;
116: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type ;
117: l_old_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type ;
118: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
119: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
120: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;

Line 117: l_old_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type ;

113: l_old_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type ;
114: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type ;
115: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type ;
116: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type ;
117: l_old_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type ;
118: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
119: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
120: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
121: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type ;

Line 118: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;

114: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type ;
115: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type ;
116: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type ;
117: l_old_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type ;
118: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
119: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
120: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
121: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type ;
122: l_old_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type ;

Line 119: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;

115: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type ;
116: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type ;
117: l_old_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type ;
118: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
119: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
120: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
121: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type ;
122: l_old_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type ;
123: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type ;

Line 120: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;

116: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type ;
117: l_old_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type ;
118: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
119: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
120: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
121: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type ;
122: l_old_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type ;
123: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type ;
124: l_old_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type ;

Line 121: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type ;

117: l_old_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type ;
118: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
119: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
120: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
121: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type ;
122: l_old_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type ;
123: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type ;
124: l_old_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type ;
125:

Line 122: l_old_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type ;

118: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
119: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
120: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
121: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type ;
122: l_old_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type ;
123: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type ;
124: l_old_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type ;
125:
126: l_message_data varchar2(2000);

Line 123: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type ;

119: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
120: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
121: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type ;
122: l_old_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type ;
123: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type ;
124: l_old_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type ;
125:
126: l_message_data varchar2(2000);
127:

Line 124: l_old_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type ;

120: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
121: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type ;
122: l_old_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type ;
123: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type ;
124: l_old_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type ;
125:
126: l_message_data varchar2(2000);
127:
128: l_org_id oe_order_lines.org_id%type;

Line 314: l_header_rec OE_Order_PUB.Header_Rec_Type;

310: l_return_values varchar2(50);
311: l_return_status VARCHAR2(1) ;
312: l_msg_count NUMBER;
313: l_msg_data VARCHAR2(2000);
314: l_header_rec OE_Order_PUB.Header_Rec_Type;
315: x_header_rec OE_Order_PUB.Header_Rec_Type; --added for bug 6347596
316: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
317: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
318: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;

Line 315: x_header_rec OE_Order_PUB.Header_Rec_Type; --added for bug 6347596

311: l_return_status VARCHAR2(1) ;
312: l_msg_count NUMBER;
313: l_msg_data VARCHAR2(2000);
314: l_header_rec OE_Order_PUB.Header_Rec_Type;
315: x_header_rec OE_Order_PUB.Header_Rec_Type; --added for bug 6347596
316: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
317: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
318: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
319: l_header_price_att_tbl OE_Order_PUB.header_Price_Att_Tbl_Type;

Line 316: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;

312: l_msg_count NUMBER;
313: l_msg_data VARCHAR2(2000);
314: l_header_rec OE_Order_PUB.Header_Rec_Type;
315: x_header_rec OE_Order_PUB.Header_Rec_Type; --added for bug 6347596
316: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
317: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
318: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
319: l_header_price_att_tbl OE_Order_PUB.header_Price_Att_Tbl_Type;
320: l_header_adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

Line 317: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

313: l_msg_data VARCHAR2(2000);
314: l_header_rec OE_Order_PUB.Header_Rec_Type;
315: x_header_rec OE_Order_PUB.Header_Rec_Type; --added for bug 6347596
316: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
317: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
318: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
319: l_header_price_att_tbl OE_Order_PUB.header_Price_Att_Tbl_Type;
320: l_header_adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
321: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

Line 318: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;

314: l_header_rec OE_Order_PUB.Header_Rec_Type;
315: x_header_rec OE_Order_PUB.Header_Rec_Type; --added for bug 6347596
316: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
317: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
318: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
319: l_header_price_att_tbl OE_Order_PUB.header_Price_Att_Tbl_Type;
320: l_header_adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
321: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
322: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

Line 319: l_header_price_att_tbl OE_Order_PUB.header_Price_Att_Tbl_Type;

315: x_header_rec OE_Order_PUB.Header_Rec_Type; --added for bug 6347596
316: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
317: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
318: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
319: l_header_price_att_tbl OE_Order_PUB.header_Price_Att_Tbl_Type;
320: l_header_adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
321: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
322: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
323: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;

Line 320: l_header_adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

316: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
317: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
318: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
319: l_header_price_att_tbl OE_Order_PUB.header_Price_Att_Tbl_Type;
320: l_header_adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
321: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
322: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
323: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
324: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

Line 321: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

317: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
318: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
319: l_header_price_att_tbl OE_Order_PUB.header_Price_Att_Tbl_Type;
320: l_header_adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
321: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
322: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
323: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
324: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
325: x_line_tbl OE_Order_PUB.Line_Tbl_Type; --added for bug 6347596

Line 322: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

318: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
319: l_header_price_att_tbl OE_Order_PUB.header_Price_Att_Tbl_Type;
320: l_header_adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
321: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
322: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
323: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
324: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
325: x_line_tbl OE_Order_PUB.Line_Tbl_Type; --added for bug 6347596
326: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;

Line 323: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;

319: l_header_price_att_tbl OE_Order_PUB.header_Price_Att_Tbl_Type;
320: l_header_adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
321: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
322: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
323: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
324: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
325: x_line_tbl OE_Order_PUB.Line_Tbl_Type; --added for bug 6347596
326: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
327: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

Line 324: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

320: l_header_adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
321: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
322: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
323: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
324: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
325: x_line_tbl OE_Order_PUB.Line_Tbl_Type; --added for bug 6347596
326: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
327: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
328: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;

Line 325: x_line_tbl OE_Order_PUB.Line_Tbl_Type; --added for bug 6347596

321: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
322: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
323: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
324: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
325: x_line_tbl OE_Order_PUB.Line_Tbl_Type; --added for bug 6347596
326: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
327: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
328: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
329: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;

Line 326: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;

322: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
323: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
324: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
325: x_line_tbl OE_Order_PUB.Line_Tbl_Type; --added for bug 6347596
326: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
327: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
328: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
329: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
330: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;

Line 327: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

323: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
324: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
325: x_line_tbl OE_Order_PUB.Line_Tbl_Type; --added for bug 6347596
326: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
327: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
328: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
329: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
330: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
331: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;

Line 328: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;

324: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
325: x_line_tbl OE_Order_PUB.Line_Tbl_Type; --added for bug 6347596
326: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
327: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
328: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
329: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
330: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
331: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
332: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 329: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;

325: x_line_tbl OE_Order_PUB.Line_Tbl_Type; --added for bug 6347596
326: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
327: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
328: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
329: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
330: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
331: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
332: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
333: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;

Line 330: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;

326: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
327: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
328: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
329: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
330: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
331: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
332: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
333: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
334: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

Line 331: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;

327: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
328: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
329: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
330: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
331: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
332: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
333: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
334: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
335: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;

Line 332: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

328: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
329: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
330: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
331: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
332: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
333: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
334: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
335: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
336: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type ;

Line 333: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;

329: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
330: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
331: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
332: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
333: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
334: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
335: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
336: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type ;
337:

Line 334: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

330: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
331: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
332: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
333: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
334: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
335: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
336: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type ;
337:
338: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;

Line 335: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;

331: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
332: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
333: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
334: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
335: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
336: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type ;
337:
338: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
339: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=

Line 336: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type ;

332: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
333: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
334: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
335: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
336: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type ;
337:
338: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
339: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=
340: OE_Order_PUB.G_MISS_REQUEST_TBL;

Line 338: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;

334: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
335: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
336: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type ;
337:
338: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
339: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=
340: OE_Order_PUB.G_MISS_REQUEST_TBL;
341:
342: l_old_header_rec OE_Order_PUB.Header_Rec_Type ;

Line 339: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=

335: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
336: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type ;
337:
338: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
339: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=
340: OE_Order_PUB.G_MISS_REQUEST_TBL;
341:
342: l_old_header_rec OE_Order_PUB.Header_Rec_Type ;
343: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type ;

Line 340: OE_Order_PUB.G_MISS_REQUEST_TBL;

336: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type ;
337:
338: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
339: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=
340: OE_Order_PUB.G_MISS_REQUEST_TBL;
341:
342: l_old_header_rec OE_Order_PUB.Header_Rec_Type ;
343: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type ;
344: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type ;

Line 342: l_old_header_rec OE_Order_PUB.Header_Rec_Type ;

338: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
339: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=
340: OE_Order_PUB.G_MISS_REQUEST_TBL;
341:
342: l_old_header_rec OE_Order_PUB.Header_Rec_Type ;
343: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type ;
344: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type ;
345: l_old_Header_Adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type ;
346: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;

Line 343: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type ;

339: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=
340: OE_Order_PUB.G_MISS_REQUEST_TBL;
341:
342: l_old_header_rec OE_Order_PUB.Header_Rec_Type ;
343: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type ;
344: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type ;
345: l_old_Header_Adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type ;
346: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
347: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;

Line 344: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type ;

340: OE_Order_PUB.G_MISS_REQUEST_TBL;
341:
342: l_old_header_rec OE_Order_PUB.Header_Rec_Type ;
343: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type ;
344: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type ;
345: l_old_Header_Adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type ;
346: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
347: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
348: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;

Line 345: l_old_Header_Adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type ;

341:
342: l_old_header_rec OE_Order_PUB.Header_Rec_Type ;
343: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type ;
344: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type ;
345: l_old_Header_Adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type ;
346: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
347: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
348: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
349: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type ;

Line 346: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;

342: l_old_header_rec OE_Order_PUB.Header_Rec_Type ;
343: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type ;
344: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type ;
345: l_old_Header_Adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type ;
346: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
347: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
348: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
349: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type ;
350: l_old_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type ;

Line 347: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;

343: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type ;
344: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type ;
345: l_old_Header_Adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type ;
346: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
347: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
348: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
349: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type ;
350: l_old_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type ;
351: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type ;

Line 348: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;

344: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type ;
345: l_old_Header_Adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type ;
346: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
347: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
348: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
349: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type ;
350: l_old_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type ;
351: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type ;
352: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type ;

Line 349: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type ;

345: l_old_Header_Adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type ;
346: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
347: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
348: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
349: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type ;
350: l_old_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type ;
351: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type ;
352: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type ;
353: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type ;

Line 350: l_old_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type ;

346: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
347: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
348: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
349: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type ;
350: l_old_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type ;
351: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type ;
352: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type ;
353: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type ;
354: l_old_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type ;

Line 351: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type ;

347: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
348: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
349: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type ;
350: l_old_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type ;
351: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type ;
352: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type ;
353: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type ;
354: l_old_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type ;
355: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;

Line 352: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type ;

348: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
349: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type ;
350: l_old_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type ;
351: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type ;
352: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type ;
353: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type ;
354: l_old_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type ;
355: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
356: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;

Line 353: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type ;

349: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type ;
350: l_old_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type ;
351: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type ;
352: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type ;
353: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type ;
354: l_old_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type ;
355: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
356: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
357: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;

Line 354: l_old_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type ;

350: l_old_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type ;
351: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type ;
352: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type ;
353: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type ;
354: l_old_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type ;
355: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
356: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
357: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
358: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type ;

Line 355: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;

351: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type ;
352: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type ;
353: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type ;
354: l_old_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type ;
355: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
356: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
357: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
358: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type ;
359: l_old_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type ;

Line 356: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;

352: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type ;
353: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type ;
354: l_old_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type ;
355: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
356: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
357: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
358: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type ;
359: l_old_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type ;
360: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type ;

Line 357: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;

353: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type ;
354: l_old_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type ;
355: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
356: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
357: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
358: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type ;
359: l_old_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type ;
360: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type ;
361: l_old_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type ;

Line 358: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type ;

354: l_old_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type ;
355: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
356: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
357: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
358: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type ;
359: l_old_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type ;
360: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type ;
361: l_old_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type ;
362:

Line 359: l_old_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type ;

355: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
356: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
357: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
358: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type ;
359: l_old_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type ;
360: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type ;
361: l_old_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type ;
362:
363: l_message_data varchar2(2000);

Line 360: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type ;

356: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
357: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
358: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type ;
359: l_old_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type ;
360: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type ;
361: l_old_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type ;
362:
363: l_message_data varchar2(2000);
364: l_org_id oe_order_lines.org_id%type;

Line 361: l_old_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type ;

357: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
358: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type ;
359: l_old_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type ;
360: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type ;
361: l_old_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type ;
362:
363: l_message_data varchar2(2000);
364: l_org_id oe_order_lines.org_id%type;
365:

Line 578: l_header_rec OE_Order_PUB.Header_Rec_Type;

574: l_return_values varchar2(50);
575: l_return_status VARCHAR2(1) ;
576: l_msg_count NUMBER;
577: l_msg_data VARCHAR2(2000);
578: l_header_rec OE_Order_PUB.Header_Rec_Type;
579: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
580: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
581: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
582: l_header_price_att_tbl OE_Order_PUB.header_Price_Att_Tbl_Type;

Line 579: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;

575: l_return_status VARCHAR2(1) ;
576: l_msg_count NUMBER;
577: l_msg_data VARCHAR2(2000);
578: l_header_rec OE_Order_PUB.Header_Rec_Type;
579: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
580: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
581: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
582: l_header_price_att_tbl OE_Order_PUB.header_Price_Att_Tbl_Type;
583: l_header_adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

Line 580: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

576: l_msg_count NUMBER;
577: l_msg_data VARCHAR2(2000);
578: l_header_rec OE_Order_PUB.Header_Rec_Type;
579: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
580: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
581: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
582: l_header_price_att_tbl OE_Order_PUB.header_Price_Att_Tbl_Type;
583: l_header_adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
584: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

Line 581: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;

577: l_msg_data VARCHAR2(2000);
578: l_header_rec OE_Order_PUB.Header_Rec_Type;
579: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
580: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
581: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
582: l_header_price_att_tbl OE_Order_PUB.header_Price_Att_Tbl_Type;
583: l_header_adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
584: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
585: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

Line 582: l_header_price_att_tbl OE_Order_PUB.header_Price_Att_Tbl_Type;

578: l_header_rec OE_Order_PUB.Header_Rec_Type;
579: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
580: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
581: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
582: l_header_price_att_tbl OE_Order_PUB.header_Price_Att_Tbl_Type;
583: l_header_adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
584: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
585: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
586: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;

Line 583: l_header_adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

579: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
580: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
581: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
582: l_header_price_att_tbl OE_Order_PUB.header_Price_Att_Tbl_Type;
583: l_header_adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
584: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
585: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
586: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
587: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

Line 584: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

580: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
581: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
582: l_header_price_att_tbl OE_Order_PUB.header_Price_Att_Tbl_Type;
583: l_header_adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
584: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
585: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
586: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
587: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
588: x_line_tbl OE_Order_PUB.Line_Tbl_Type; --added for bug 6347596

Line 585: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

581: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
582: l_header_price_att_tbl OE_Order_PUB.header_Price_Att_Tbl_Type;
583: l_header_adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
584: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
585: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
586: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
587: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
588: x_line_tbl OE_Order_PUB.Line_Tbl_Type; --added for bug 6347596
589: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;

Line 586: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;

582: l_header_price_att_tbl OE_Order_PUB.header_Price_Att_Tbl_Type;
583: l_header_adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
584: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
585: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
586: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
587: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
588: x_line_tbl OE_Order_PUB.Line_Tbl_Type; --added for bug 6347596
589: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
590: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

Line 587: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

583: l_header_adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
584: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
585: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
586: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
587: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
588: x_line_tbl OE_Order_PUB.Line_Tbl_Type; --added for bug 6347596
589: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
590: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
591: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;

Line 588: x_line_tbl OE_Order_PUB.Line_Tbl_Type; --added for bug 6347596

584: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
585: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
586: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
587: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
588: x_line_tbl OE_Order_PUB.Line_Tbl_Type; --added for bug 6347596
589: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
590: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
591: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
592: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;

Line 589: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;

585: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
586: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
587: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
588: x_line_tbl OE_Order_PUB.Line_Tbl_Type; --added for bug 6347596
589: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
590: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
591: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
592: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
593: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;

Line 590: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

586: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
587: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
588: x_line_tbl OE_Order_PUB.Line_Tbl_Type; --added for bug 6347596
589: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
590: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
591: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
592: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
593: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
594: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;

Line 591: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;

587: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
588: x_line_tbl OE_Order_PUB.Line_Tbl_Type; --added for bug 6347596
589: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
590: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
591: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
592: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
593: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
594: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
595: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 592: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;

588: x_line_tbl OE_Order_PUB.Line_Tbl_Type; --added for bug 6347596
589: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
590: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
591: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
592: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
593: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
594: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
595: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
596: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;

Line 593: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;

589: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
590: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
591: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
592: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
593: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
594: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
595: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
596: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
597: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

Line 594: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;

590: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
591: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
592: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
593: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
594: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
595: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
596: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
597: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
598: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;

Line 595: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

591: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
592: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
593: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
594: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
595: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
596: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
597: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
598: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
599: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type ;

Line 596: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;

592: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
593: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
594: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
595: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
596: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
597: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
598: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
599: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type ;
600:

Line 597: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

593: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
594: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
595: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
596: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
597: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
598: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
599: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type ;
600:
601: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;

Line 598: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;

594: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
595: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
596: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
597: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
598: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
599: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type ;
600:
601: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
602: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=

Line 599: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type ;

595: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
596: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
597: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
598: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
599: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type ;
600:
601: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
602: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=
603: OE_Order_PUB.G_MISS_REQUEST_TBL;

Line 601: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;

597: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
598: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
599: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type ;
600:
601: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
602: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=
603: OE_Order_PUB.G_MISS_REQUEST_TBL;
604:
605: l_old_header_rec OE_Order_PUB.Header_Rec_Type ;

Line 602: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=

598: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
599: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type ;
600:
601: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
602: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=
603: OE_Order_PUB.G_MISS_REQUEST_TBL;
604:
605: l_old_header_rec OE_Order_PUB.Header_Rec_Type ;
606: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type ;

Line 603: OE_Order_PUB.G_MISS_REQUEST_TBL;

599: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type ;
600:
601: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
602: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=
603: OE_Order_PUB.G_MISS_REQUEST_TBL;
604:
605: l_old_header_rec OE_Order_PUB.Header_Rec_Type ;
606: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type ;
607: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type ;

Line 605: l_old_header_rec OE_Order_PUB.Header_Rec_Type ;

601: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
602: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=
603: OE_Order_PUB.G_MISS_REQUEST_TBL;
604:
605: l_old_header_rec OE_Order_PUB.Header_Rec_Type ;
606: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type ;
607: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type ;
608: l_old_Header_Adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type ;
609: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;

Line 606: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type ;

602: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=
603: OE_Order_PUB.G_MISS_REQUEST_TBL;
604:
605: l_old_header_rec OE_Order_PUB.Header_Rec_Type ;
606: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type ;
607: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type ;
608: l_old_Header_Adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type ;
609: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
610: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;

Line 607: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type ;

603: OE_Order_PUB.G_MISS_REQUEST_TBL;
604:
605: l_old_header_rec OE_Order_PUB.Header_Rec_Type ;
606: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type ;
607: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type ;
608: l_old_Header_Adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type ;
609: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
610: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
611: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;

Line 608: l_old_Header_Adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type ;

604:
605: l_old_header_rec OE_Order_PUB.Header_Rec_Type ;
606: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type ;
607: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type ;
608: l_old_Header_Adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type ;
609: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
610: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
611: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
612: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type ;

Line 609: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;

605: l_old_header_rec OE_Order_PUB.Header_Rec_Type ;
606: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type ;
607: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type ;
608: l_old_Header_Adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type ;
609: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
610: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
611: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
612: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type ;
613: l_old_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type ;

Line 610: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;

606: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type ;
607: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type ;
608: l_old_Header_Adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type ;
609: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
610: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
611: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
612: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type ;
613: l_old_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type ;
614: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type ;

Line 611: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;

607: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type ;
608: l_old_Header_Adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type ;
609: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
610: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
611: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
612: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type ;
613: l_old_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type ;
614: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type ;
615: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type ;

Line 612: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type ;

608: l_old_Header_Adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type ;
609: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
610: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
611: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
612: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type ;
613: l_old_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type ;
614: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type ;
615: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type ;
616: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type ;

Line 613: l_old_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type ;

609: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
610: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
611: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
612: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type ;
613: l_old_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type ;
614: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type ;
615: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type ;
616: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type ;
617: l_old_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type ;

Line 614: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type ;

610: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
611: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
612: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type ;
613: l_old_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type ;
614: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type ;
615: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type ;
616: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type ;
617: l_old_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type ;
618: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;

Line 615: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type ;

611: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
612: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type ;
613: l_old_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type ;
614: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type ;
615: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type ;
616: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type ;
617: l_old_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type ;
618: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
619: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;

Line 616: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type ;

612: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type ;
613: l_old_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type ;
614: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type ;
615: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type ;
616: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type ;
617: l_old_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type ;
618: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
619: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
620: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;

Line 617: l_old_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type ;

613: l_old_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type ;
614: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type ;
615: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type ;
616: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type ;
617: l_old_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type ;
618: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
619: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
620: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
621: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type ;

Line 618: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;

614: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type ;
615: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type ;
616: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type ;
617: l_old_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type ;
618: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
619: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
620: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
621: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type ;
622: l_old_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type ;

Line 619: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;

615: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type ;
616: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type ;
617: l_old_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type ;
618: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
619: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
620: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
621: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type ;
622: l_old_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type ;
623: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type ;

Line 620: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;

616: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type ;
617: l_old_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type ;
618: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
619: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
620: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
621: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type ;
622: l_old_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type ;
623: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type ;
624: l_old_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type ;

Line 621: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type ;

617: l_old_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type ;
618: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
619: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
620: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
621: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type ;
622: l_old_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type ;
623: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type ;
624: l_old_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type ;
625:

Line 622: l_old_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type ;

618: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
619: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
620: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
621: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type ;
622: l_old_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type ;
623: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type ;
624: l_old_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type ;
625:
626: l_message_data varchar2(2000);

Line 623: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type ;

619: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
620: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
621: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type ;
622: l_old_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type ;
623: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type ;
624: l_old_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type ;
625:
626: l_message_data varchar2(2000);
627: l_org_id oe_order_lines.org_id%type;

Line 624: l_old_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type ;

620: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
621: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type ;
622: l_old_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type ;
623: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type ;
624: l_old_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type ;
625:
626: l_message_data varchar2(2000);
627: l_org_id oe_order_lines.org_id%type;
628: