DBA Data[Home] [Help]

APPS.OE_RMA_RECEIVING dependencies on OE_ORDER_PUB

Line 133: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;

129: p_Quantity2 IN NUMBER DEFAULT NULL,
130: p_R2Cust_Parent_Trn_Type IN VARCHAR2 DEFAULT NULL
131: )
132: IS
133: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
134: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
135: l_item_key varchar2(30);
136: l_control_rec OE_GLOBALS.Control_Rec_Type;
137: l_x_header_rec OE_Order_PUB.Header_Rec_Type;

Line 134: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

130: p_R2Cust_Parent_Trn_Type IN VARCHAR2 DEFAULT NULL
131: )
132: IS
133: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
134: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
135: l_item_key varchar2(30);
136: l_control_rec OE_GLOBALS.Control_Rec_Type;
137: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
138: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;

Line 137: l_x_header_rec OE_Order_PUB.Header_Rec_Type;

133: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
134: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
135: l_item_key varchar2(30);
136: l_control_rec OE_GLOBALS.Control_Rec_Type;
137: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
138: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
139: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
140: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
141: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

Line 138: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;

134: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
135: l_item_key varchar2(30);
136: l_control_rec OE_GLOBALS.Control_Rec_Type;
137: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
138: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
139: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
140: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
141: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
142: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;

Line 139: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

135: l_item_key varchar2(30);
136: l_control_rec OE_GLOBALS.Control_Rec_Type;
137: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
138: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
139: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
140: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
141: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
142: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
143: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

Line 140: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;

136: l_control_rec OE_GLOBALS.Control_Rec_Type;
137: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
138: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
139: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
140: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
141: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
142: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
143: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
144: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;

Line 141: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

137: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
138: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
139: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
140: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
141: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
142: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
143: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
144: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
145: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 142: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;

138: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
139: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
140: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
141: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
142: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
143: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
144: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
145: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
146: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

Line 143: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

139: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
140: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
141: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
142: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
143: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
144: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
145: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
146: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
147: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

Line 144: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;

140: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
141: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
142: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
143: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
144: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
145: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
146: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
147: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
148: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

Line 145: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

141: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
142: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
143: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
144: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
145: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
146: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
147: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
148: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
149: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

Line 146: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

142: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
143: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
144: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
145: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
146: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
147: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
148: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
149: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
150: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

Line 147: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

143: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
144: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
145: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
146: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
147: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
148: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
149: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
150: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
151: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

Line 148: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

144: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
145: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
146: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
147: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
148: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
149: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
150: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
151: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
152: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

Line 149: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

145: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
146: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
147: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
148: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
149: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
150: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
151: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
152: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
153: l_x_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;

Line 150: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

146: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
147: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
148: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
149: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
150: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
151: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
152: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
153: l_x_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;
154: l_return_status VARCHAR2(30);

Line 151: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

147: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
148: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
149: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
150: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
151: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
152: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
153: l_x_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;
154: l_return_status VARCHAR2(30);
155: l_tolerance_below NUMBER;

Line 152: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

148: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
149: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
150: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
151: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
152: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
153: l_x_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;
154: l_return_status VARCHAR2(30);
155: l_tolerance_below NUMBER;
156: l_tolerance_above NUMBER;

Line 153: l_x_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;

149: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
150: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
151: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
152: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
153: l_x_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;
154: l_return_status VARCHAR2(30);
155: l_tolerance_below NUMBER;
156: l_tolerance_above NUMBER;
157: l_open_line_id NUMBER;

Line 158: l_open_line_rec OE_Order_PUB.Line_Rec_Type;

154: l_return_status VARCHAR2(30);
155: l_tolerance_below NUMBER;
156: l_tolerance_above NUMBER;
157: l_open_line_id NUMBER;
158: l_open_line_rec OE_Order_PUB.Line_Rec_Type;
159: l_temp_open_line_rec OE_Order_PUB.Line_Rec_Type;
160: l_updated_quantity NUMBER;
161: b_om_processing boolean := FALSE;
162: /* to indicate if om processing is needed*/

Line 159: l_temp_open_line_rec OE_Order_PUB.Line_Rec_Type;

155: l_tolerance_below NUMBER;
156: l_tolerance_above NUMBER;
157: l_open_line_id NUMBER;
158: l_open_line_rec OE_Order_PUB.Line_Rec_Type;
159: l_temp_open_line_rec OE_Order_PUB.Line_Rec_Type;
160: l_updated_quantity NUMBER;
161: b_om_processing boolean := FALSE;
162: /* to indicate if om processing is needed*/
163: l_updated_quantity2 NUMBER; -- 04/20/2001 OPM

Line 173: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;

169: b_neg_corr_zero_qty boolean := FALSE;
170: b_positive_correction boolean := FALSE;
171: l_temp_var VARCHAR2(2000) := NULL;
172: --serla begin
173: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
174: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
175: --serla end
176: --
177: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 174: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;

170: b_positive_correction boolean := FALSE;
171: l_temp_var VARCHAR2(2000) := NULL;
172: --serla begin
173: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
174: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
175: --serla end
176: --
177: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
178: --

Line 1319: FUNCTION Get_Open_Line_Id (p_line_rec IN OE_ORDER_PUB.line_rec_type)

1315:
1316: END Push_Receiving_Info;
1317:
1318:
1319: FUNCTION Get_Open_Line_Id (p_line_rec IN OE_ORDER_PUB.line_rec_type)
1320: RETURN NUMBER
1321: IS
1322:
1323: l_open_line_id NUMBER;