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

APPS.OE_ACKNOWLEDGMENT_PVT dependencies on OE_ORDER_PUB

Line 186: ,p_header_rec IN OE_Order_Pub.Header_Rec_Type :=

182: PROCEDURE Process_Acknowledgment
183: (p_api_version_number IN NUMBER
184: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
185:
186: ,p_header_rec IN OE_Order_Pub.Header_Rec_Type :=
187: OE_Order_Pub.G_MISS_HEADER_REC
188: ,p_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type
189: ,p_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
190: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL

Line 187: OE_Order_Pub.G_MISS_HEADER_REC

183: (p_api_version_number IN NUMBER
184: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
185:
186: ,p_header_rec IN OE_Order_Pub.Header_Rec_Type :=
187: OE_Order_Pub.G_MISS_HEADER_REC
188: ,p_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type
189: ,p_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
190: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
191: ,p_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=

Line 188: ,p_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type

184: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
185:
186: ,p_header_rec IN OE_Order_Pub.Header_Rec_Type :=
187: OE_Order_Pub.G_MISS_HEADER_REC
188: ,p_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type
189: ,p_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
190: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
191: ,p_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
192: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL

Line 189: ,p_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=

185:
186: ,p_header_rec IN OE_Order_Pub.Header_Rec_Type :=
187: OE_Order_Pub.G_MISS_HEADER_REC
188: ,p_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type
189: ,p_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
190: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
191: ,p_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
192: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
193: ,p_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=

Line 190: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL

186: ,p_header_rec IN OE_Order_Pub.Header_Rec_Type :=
187: OE_Order_Pub.G_MISS_HEADER_REC
188: ,p_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type
189: ,p_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
190: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
191: ,p_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
192: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
193: ,p_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
194: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL

Line 191: ,p_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=

187: OE_Order_Pub.G_MISS_HEADER_REC
188: ,p_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type
189: ,p_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
190: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
191: ,p_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
192: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
193: ,p_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
194: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
195: ,p_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=

Line 192: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL

188: ,p_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type
189: ,p_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
190: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
191: ,p_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
192: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
193: ,p_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
194: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
195: ,p_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
196: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL

Line 193: ,p_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=

189: ,p_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
190: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
191: ,p_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
192: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
193: ,p_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
194: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
195: ,p_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
196: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
197: ,p_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=

Line 194: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL

190: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
191: ,p_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
192: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
193: ,p_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
194: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
195: ,p_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
196: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
197: ,p_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
198: OE_Order_Pub.G_MISS_LINE_TBL

Line 195: ,p_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=

191: ,p_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
192: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
193: ,p_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
194: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
195: ,p_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
196: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
197: ,p_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
198: OE_Order_Pub.G_MISS_LINE_TBL
199: ,p_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type

Line 196: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL

192: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
193: ,p_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
194: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
195: ,p_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
196: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
197: ,p_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
198: OE_Order_Pub.G_MISS_LINE_TBL
199: ,p_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type
200: ,p_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=

Line 197: ,p_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=

193: ,p_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
194: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
195: ,p_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
196: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
197: ,p_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
198: OE_Order_Pub.G_MISS_LINE_TBL
199: ,p_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type
200: ,p_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
201: OE_Order_Pub.G_MISS_LINE_ADJ_TBL

Line 198: OE_Order_Pub.G_MISS_LINE_TBL

194: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
195: ,p_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
196: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
197: ,p_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
198: OE_Order_Pub.G_MISS_LINE_TBL
199: ,p_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type
200: ,p_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
201: OE_Order_Pub.G_MISS_LINE_ADJ_TBL
202: ,p_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=

Line 199: ,p_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type

195: ,p_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
196: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
197: ,p_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
198: OE_Order_Pub.G_MISS_LINE_TBL
199: ,p_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type
200: ,p_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
201: OE_Order_Pub.G_MISS_LINE_ADJ_TBL
202: ,p_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
203: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL

Line 200: ,p_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=

196: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
197: ,p_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
198: OE_Order_Pub.G_MISS_LINE_TBL
199: ,p_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type
200: ,p_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
201: OE_Order_Pub.G_MISS_LINE_ADJ_TBL
202: ,p_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
203: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
204: ,p_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=

Line 201: OE_Order_Pub.G_MISS_LINE_ADJ_TBL

197: ,p_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
198: OE_Order_Pub.G_MISS_LINE_TBL
199: ,p_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type
200: ,p_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
201: OE_Order_Pub.G_MISS_LINE_ADJ_TBL
202: ,p_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
203: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
204: ,p_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
205: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL

Line 202: ,p_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=

198: OE_Order_Pub.G_MISS_LINE_TBL
199: ,p_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type
200: ,p_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
201: OE_Order_Pub.G_MISS_LINE_ADJ_TBL
202: ,p_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
203: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
204: ,p_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
205: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
206: ,p_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=

Line 203: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL

199: ,p_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type
200: ,p_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
201: OE_Order_Pub.G_MISS_LINE_ADJ_TBL
202: ,p_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
203: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
204: ,p_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
205: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
206: ,p_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
207: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL

Line 204: ,p_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=

200: ,p_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
201: OE_Order_Pub.G_MISS_LINE_ADJ_TBL
202: ,p_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
203: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
204: ,p_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
205: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
206: ,p_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
207: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
208: ,p_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=

Line 205: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL

201: OE_Order_Pub.G_MISS_LINE_ADJ_TBL
202: ,p_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
203: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
204: ,p_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
205: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
206: ,p_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
207: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
208: ,p_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=
209: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL

Line 206: ,p_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=

202: ,p_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
203: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
204: ,p_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
205: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
206: ,p_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
207: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
208: ,p_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=
209: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL
210: ,p_Lot_Serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=

Line 207: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL

203: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
204: ,p_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
205: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
206: ,p_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
207: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
208: ,p_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=
209: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL
210: ,p_Lot_Serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=
211: OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL

Line 208: ,p_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=

204: ,p_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
205: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
206: ,p_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
207: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
208: ,p_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=
209: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL
210: ,p_Lot_Serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=
211: OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL
212: ,p_action_request_tbl IN OE_Order_Pub.Request_Tbl_Type :=

Line 209: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL

205: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
206: ,p_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
207: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
208: ,p_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=
209: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL
210: ,p_Lot_Serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=
211: OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL
212: ,p_action_request_tbl IN OE_Order_Pub.Request_Tbl_Type :=
213: OE_Order_Pub.G_MISS_REQUEST_TBL

Line 210: ,p_Lot_Serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=

206: ,p_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
207: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
208: ,p_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=
209: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL
210: ,p_Lot_Serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=
211: OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL
212: ,p_action_request_tbl IN OE_Order_Pub.Request_Tbl_Type :=
213: OE_Order_Pub.G_MISS_REQUEST_TBL
214: ,p_old_header_rec IN OE_Order_Pub.Header_Rec_Type :=

Line 211: OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL

207: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
208: ,p_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=
209: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL
210: ,p_Lot_Serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=
211: OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL
212: ,p_action_request_tbl IN OE_Order_Pub.Request_Tbl_Type :=
213: OE_Order_Pub.G_MISS_REQUEST_TBL
214: ,p_old_header_rec IN OE_Order_Pub.Header_Rec_Type :=
215: OE_Order_Pub.G_MISS_HEADER_REC

Line 212: ,p_action_request_tbl IN OE_Order_Pub.Request_Tbl_Type :=

208: ,p_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=
209: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL
210: ,p_Lot_Serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=
211: OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL
212: ,p_action_request_tbl IN OE_Order_Pub.Request_Tbl_Type :=
213: OE_Order_Pub.G_MISS_REQUEST_TBL
214: ,p_old_header_rec IN OE_Order_Pub.Header_Rec_Type :=
215: OE_Order_Pub.G_MISS_HEADER_REC
216: ,p_old_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type :=

Line 213: OE_Order_Pub.G_MISS_REQUEST_TBL

209: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL
210: ,p_Lot_Serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=
211: OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL
212: ,p_action_request_tbl IN OE_Order_Pub.Request_Tbl_Type :=
213: OE_Order_Pub.G_MISS_REQUEST_TBL
214: ,p_old_header_rec IN OE_Order_Pub.Header_Rec_Type :=
215: OE_Order_Pub.G_MISS_HEADER_REC
216: ,p_old_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type :=
217: OE_Order_Pub.G_MISS_HEADER_VAL_REC

Line 214: ,p_old_header_rec IN OE_Order_Pub.Header_Rec_Type :=

210: ,p_Lot_Serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=
211: OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL
212: ,p_action_request_tbl IN OE_Order_Pub.Request_Tbl_Type :=
213: OE_Order_Pub.G_MISS_REQUEST_TBL
214: ,p_old_header_rec IN OE_Order_Pub.Header_Rec_Type :=
215: OE_Order_Pub.G_MISS_HEADER_REC
216: ,p_old_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type :=
217: OE_Order_Pub.G_MISS_HEADER_VAL_REC
218: ,p_old_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=

Line 215: OE_Order_Pub.G_MISS_HEADER_REC

211: OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL
212: ,p_action_request_tbl IN OE_Order_Pub.Request_Tbl_Type :=
213: OE_Order_Pub.G_MISS_REQUEST_TBL
214: ,p_old_header_rec IN OE_Order_Pub.Header_Rec_Type :=
215: OE_Order_Pub.G_MISS_HEADER_REC
216: ,p_old_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type :=
217: OE_Order_Pub.G_MISS_HEADER_VAL_REC
218: ,p_old_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
219: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL

Line 216: ,p_old_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type :=

212: ,p_action_request_tbl IN OE_Order_Pub.Request_Tbl_Type :=
213: OE_Order_Pub.G_MISS_REQUEST_TBL
214: ,p_old_header_rec IN OE_Order_Pub.Header_Rec_Type :=
215: OE_Order_Pub.G_MISS_HEADER_REC
216: ,p_old_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type :=
217: OE_Order_Pub.G_MISS_HEADER_VAL_REC
218: ,p_old_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
219: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
220: ,p_old_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=

Line 217: OE_Order_Pub.G_MISS_HEADER_VAL_REC

213: OE_Order_Pub.G_MISS_REQUEST_TBL
214: ,p_old_header_rec IN OE_Order_Pub.Header_Rec_Type :=
215: OE_Order_Pub.G_MISS_HEADER_REC
216: ,p_old_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type :=
217: OE_Order_Pub.G_MISS_HEADER_VAL_REC
218: ,p_old_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
219: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
220: ,p_old_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
221: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL

Line 218: ,p_old_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=

214: ,p_old_header_rec IN OE_Order_Pub.Header_Rec_Type :=
215: OE_Order_Pub.G_MISS_HEADER_REC
216: ,p_old_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type :=
217: OE_Order_Pub.G_MISS_HEADER_VAL_REC
218: ,p_old_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
219: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
220: ,p_old_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
221: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
222: ,p_old_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=

Line 219: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL

215: OE_Order_Pub.G_MISS_HEADER_REC
216: ,p_old_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type :=
217: OE_Order_Pub.G_MISS_HEADER_VAL_REC
218: ,p_old_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
219: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
220: ,p_old_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
221: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
222: ,p_old_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
223: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL

Line 220: ,p_old_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=

216: ,p_old_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type :=
217: OE_Order_Pub.G_MISS_HEADER_VAL_REC
218: ,p_old_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
219: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
220: ,p_old_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
221: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
222: ,p_old_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
223: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
224: ,p_old_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=

Line 221: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL

217: OE_Order_Pub.G_MISS_HEADER_VAL_REC
218: ,p_old_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
219: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
220: ,p_old_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
221: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
222: ,p_old_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
223: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
224: ,p_old_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
225: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL

Line 222: ,p_old_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=

218: ,p_old_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
219: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
220: ,p_old_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
221: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
222: ,p_old_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
223: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
224: ,p_old_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
225: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
226: ,p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=

Line 223: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL

219: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
220: ,p_old_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
221: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
222: ,p_old_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
223: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
224: ,p_old_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
225: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
226: ,p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
227: OE_Order_Pub.G_MISS_LINE_TBL

Line 224: ,p_old_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=

220: ,p_old_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
221: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
222: ,p_old_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
223: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
224: ,p_old_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
225: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
226: ,p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
227: OE_Order_Pub.G_MISS_LINE_TBL
228: ,p_old_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=

Line 225: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL

221: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
222: ,p_old_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
223: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
224: ,p_old_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
225: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
226: ,p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
227: OE_Order_Pub.G_MISS_LINE_TBL
228: ,p_old_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=
229: OE_Order_Pub.G_MISS_LINE_VAL_TBL

Line 226: ,p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=

222: ,p_old_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
223: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
224: ,p_old_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
225: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
226: ,p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
227: OE_Order_Pub.G_MISS_LINE_TBL
228: ,p_old_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=
229: OE_Order_Pub.G_MISS_LINE_VAL_TBL
230: ,p_old_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=

Line 227: OE_Order_Pub.G_MISS_LINE_TBL

223: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
224: ,p_old_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
225: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
226: ,p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
227: OE_Order_Pub.G_MISS_LINE_TBL
228: ,p_old_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=
229: OE_Order_Pub.G_MISS_LINE_VAL_TBL
230: ,p_old_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
231: OE_Order_Pub.G_MISS_LINE_ADJ_TBL

Line 228: ,p_old_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=

224: ,p_old_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
225: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
226: ,p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
227: OE_Order_Pub.G_MISS_LINE_TBL
228: ,p_old_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=
229: OE_Order_Pub.G_MISS_LINE_VAL_TBL
230: ,p_old_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
231: OE_Order_Pub.G_MISS_LINE_ADJ_TBL
232: ,p_old_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=

Line 229: OE_Order_Pub.G_MISS_LINE_VAL_TBL

225: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
226: ,p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
227: OE_Order_Pub.G_MISS_LINE_TBL
228: ,p_old_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=
229: OE_Order_Pub.G_MISS_LINE_VAL_TBL
230: ,p_old_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
231: OE_Order_Pub.G_MISS_LINE_ADJ_TBL
232: ,p_old_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
233: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL

Line 230: ,p_old_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=

226: ,p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
227: OE_Order_Pub.G_MISS_LINE_TBL
228: ,p_old_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=
229: OE_Order_Pub.G_MISS_LINE_VAL_TBL
230: ,p_old_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
231: OE_Order_Pub.G_MISS_LINE_ADJ_TBL
232: ,p_old_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
233: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
234: ,p_old_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=

Line 231: OE_Order_Pub.G_MISS_LINE_ADJ_TBL

227: OE_Order_Pub.G_MISS_LINE_TBL
228: ,p_old_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=
229: OE_Order_Pub.G_MISS_LINE_VAL_TBL
230: ,p_old_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
231: OE_Order_Pub.G_MISS_LINE_ADJ_TBL
232: ,p_old_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
233: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
234: ,p_old_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
235: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL

Line 232: ,p_old_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=

228: ,p_old_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=
229: OE_Order_Pub.G_MISS_LINE_VAL_TBL
230: ,p_old_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
231: OE_Order_Pub.G_MISS_LINE_ADJ_TBL
232: ,p_old_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
233: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
234: ,p_old_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
235: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
236: ,p_old_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=

Line 233: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL

229: OE_Order_Pub.G_MISS_LINE_VAL_TBL
230: ,p_old_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
231: OE_Order_Pub.G_MISS_LINE_ADJ_TBL
232: ,p_old_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
233: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
234: ,p_old_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
235: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
236: ,p_old_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
237: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL

Line 234: ,p_old_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=

230: ,p_old_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
231: OE_Order_Pub.G_MISS_LINE_ADJ_TBL
232: ,p_old_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
233: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
234: ,p_old_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
235: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
236: ,p_old_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
237: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
238: ,p_old_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=

Line 235: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL

231: OE_Order_Pub.G_MISS_LINE_ADJ_TBL
232: ,p_old_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
233: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
234: ,p_old_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
235: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
236: ,p_old_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
237: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
238: ,p_old_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=
239: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL

Line 236: ,p_old_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=

232: ,p_old_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
233: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
234: ,p_old_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
235: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
236: ,p_old_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
237: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
238: ,p_old_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=
239: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL
240: ,p_old_Lot_Serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=

Line 237: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL

233: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
234: ,p_old_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
235: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
236: ,p_old_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
237: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
238: ,p_old_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=
239: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL
240: ,p_old_Lot_Serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=
241: OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL

Line 238: ,p_old_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=

234: ,p_old_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
235: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
236: ,p_old_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
237: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
238: ,p_old_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=
239: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL
240: ,p_old_Lot_Serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=
241: OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL
242:

Line 239: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL

235: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
236: ,p_old_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
237: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
238: ,p_old_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=
239: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL
240: ,p_old_Lot_Serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=
241: OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL
242:
243: ,p_buyer_seller_flag IN VARCHAR2 DEFAULT 'B'

Line 240: ,p_old_Lot_Serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=

236: ,p_old_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
237: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
238: ,p_old_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=
239: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL
240: ,p_old_Lot_Serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=
241: OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL
242:
243: ,p_buyer_seller_flag IN VARCHAR2 DEFAULT 'B'
244: ,p_reject_order IN VARCHAR2 DEFAULT 'N'

Line 241: OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL

237: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
238: ,p_old_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=
239: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL
240: ,p_old_Lot_Serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=
241: OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL
242:
243: ,p_buyer_seller_flag IN VARCHAR2 DEFAULT 'B'
244: ,p_reject_order IN VARCHAR2 DEFAULT 'N'
245:

Line 256: l_header_rec OE_Order_Pub.Header_Rec_Type :=

252: l_return_status VARCHAR2(1) := FND_API.G_MISS_CHAR;
253:
254: l_header_id NUMBER;
255:
256: l_header_rec OE_Order_Pub.Header_Rec_Type :=
257: p_header_rec;
258: l_header_val_rec OE_Order_Pub.Header_Val_Rec_Type :=
259: p_header_val_rec;
260: l_Header_Adj_tbl OE_Order_Pub.Header_Adj_Tbl_Type :=

Line 258: l_header_val_rec OE_Order_Pub.Header_Val_Rec_Type :=

254: l_header_id NUMBER;
255:
256: l_header_rec OE_Order_Pub.Header_Rec_Type :=
257: p_header_rec;
258: l_header_val_rec OE_Order_Pub.Header_Val_Rec_Type :=
259: p_header_val_rec;
260: l_Header_Adj_tbl OE_Order_Pub.Header_Adj_Tbl_Type :=
261: p_Header_Adj_tbl;
262: l_Header_Adj_val_tbl OE_Order_Pub.Header_Adj_Val_Tbl_Type :=

Line 260: l_Header_Adj_tbl OE_Order_Pub.Header_Adj_Tbl_Type :=

256: l_header_rec OE_Order_Pub.Header_Rec_Type :=
257: p_header_rec;
258: l_header_val_rec OE_Order_Pub.Header_Val_Rec_Type :=
259: p_header_val_rec;
260: l_Header_Adj_tbl OE_Order_Pub.Header_Adj_Tbl_Type :=
261: p_Header_Adj_tbl;
262: l_Header_Adj_val_tbl OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
263: p_Header_Adj_val_tbl;
264: l_Header_Price_Att_tbl OE_Order_Pub.Header_Price_Att_Tbl_Type;

Line 262: l_Header_Adj_val_tbl OE_Order_Pub.Header_Adj_Val_Tbl_Type :=

258: l_header_val_rec OE_Order_Pub.Header_Val_Rec_Type :=
259: p_header_val_rec;
260: l_Header_Adj_tbl OE_Order_Pub.Header_Adj_Tbl_Type :=
261: p_Header_Adj_tbl;
262: l_Header_Adj_val_tbl OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
263: p_Header_Adj_val_tbl;
264: l_Header_Price_Att_tbl OE_Order_Pub.Header_Price_Att_Tbl_Type;
265: l_Header_Adj_Att_tbl OE_Order_Pub.Header_Adj_Att_Tbl_Type;
266: l_Header_Adj_Assoc_tbl OE_Order_Pub.Header_Adj_Assoc_Tbl_Type;

Line 264: l_Header_Price_Att_tbl OE_Order_Pub.Header_Price_Att_Tbl_Type;

260: l_Header_Adj_tbl OE_Order_Pub.Header_Adj_Tbl_Type :=
261: p_Header_Adj_tbl;
262: l_Header_Adj_val_tbl OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
263: p_Header_Adj_val_tbl;
264: l_Header_Price_Att_tbl OE_Order_Pub.Header_Price_Att_Tbl_Type;
265: l_Header_Adj_Att_tbl OE_Order_Pub.Header_Adj_Att_Tbl_Type;
266: l_Header_Adj_Assoc_tbl OE_Order_Pub.Header_Adj_Assoc_Tbl_Type;
267: l_Header_Scredit_tbl OE_Order_Pub.Header_Scredit_Tbl_Type :=
268: p_Header_Scredit_tbl;

Line 265: l_Header_Adj_Att_tbl OE_Order_Pub.Header_Adj_Att_Tbl_Type;

261: p_Header_Adj_tbl;
262: l_Header_Adj_val_tbl OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
263: p_Header_Adj_val_tbl;
264: l_Header_Price_Att_tbl OE_Order_Pub.Header_Price_Att_Tbl_Type;
265: l_Header_Adj_Att_tbl OE_Order_Pub.Header_Adj_Att_Tbl_Type;
266: l_Header_Adj_Assoc_tbl OE_Order_Pub.Header_Adj_Assoc_Tbl_Type;
267: l_Header_Scredit_tbl OE_Order_Pub.Header_Scredit_Tbl_Type :=
268: p_Header_Scredit_tbl;
269: l_Header_Scredit_val_tbl OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=

Line 266: l_Header_Adj_Assoc_tbl OE_Order_Pub.Header_Adj_Assoc_Tbl_Type;

262: l_Header_Adj_val_tbl OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
263: p_Header_Adj_val_tbl;
264: l_Header_Price_Att_tbl OE_Order_Pub.Header_Price_Att_Tbl_Type;
265: l_Header_Adj_Att_tbl OE_Order_Pub.Header_Adj_Att_Tbl_Type;
266: l_Header_Adj_Assoc_tbl OE_Order_Pub.Header_Adj_Assoc_Tbl_Type;
267: l_Header_Scredit_tbl OE_Order_Pub.Header_Scredit_Tbl_Type :=
268: p_Header_Scredit_tbl;
269: l_Header_Scredit_val_tbl OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
270: p_Header_Scredit_val_tbl;

Line 267: l_Header_Scredit_tbl OE_Order_Pub.Header_Scredit_Tbl_Type :=

263: p_Header_Adj_val_tbl;
264: l_Header_Price_Att_tbl OE_Order_Pub.Header_Price_Att_Tbl_Type;
265: l_Header_Adj_Att_tbl OE_Order_Pub.Header_Adj_Att_Tbl_Type;
266: l_Header_Adj_Assoc_tbl OE_Order_Pub.Header_Adj_Assoc_Tbl_Type;
267: l_Header_Scredit_tbl OE_Order_Pub.Header_Scredit_Tbl_Type :=
268: p_Header_Scredit_tbl;
269: l_Header_Scredit_val_tbl OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
270: p_Header_Scredit_val_tbl;
271: l_line_rec OE_Order_Pub.Line_Rec_Type ;

Line 269: l_Header_Scredit_val_tbl OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=

265: l_Header_Adj_Att_tbl OE_Order_Pub.Header_Adj_Att_Tbl_Type;
266: l_Header_Adj_Assoc_tbl OE_Order_Pub.Header_Adj_Assoc_Tbl_Type;
267: l_Header_Scredit_tbl OE_Order_Pub.Header_Scredit_Tbl_Type :=
268: p_Header_Scredit_tbl;
269: l_Header_Scredit_val_tbl OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
270: p_Header_Scredit_val_tbl;
271: l_line_rec OE_Order_Pub.Line_Rec_Type ;
272: l_line_tbl OE_Order_Pub.Line_Tbl_Type :=
273: p_line_tbl;

Line 271: l_line_rec OE_Order_Pub.Line_Rec_Type ;

267: l_Header_Scredit_tbl OE_Order_Pub.Header_Scredit_Tbl_Type :=
268: p_Header_Scredit_tbl;
269: l_Header_Scredit_val_tbl OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
270: p_Header_Scredit_val_tbl;
271: l_line_rec OE_Order_Pub.Line_Rec_Type ;
272: l_line_tbl OE_Order_Pub.Line_Tbl_Type :=
273: p_line_tbl;
274: l_line_val_tbl OE_Order_Pub.Line_Val_Tbl_Type :=
275: p_line_val_tbl;

Line 272: l_line_tbl OE_Order_Pub.Line_Tbl_Type :=

268: p_Header_Scredit_tbl;
269: l_Header_Scredit_val_tbl OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
270: p_Header_Scredit_val_tbl;
271: l_line_rec OE_Order_Pub.Line_Rec_Type ;
272: l_line_tbl OE_Order_Pub.Line_Tbl_Type :=
273: p_line_tbl;
274: l_line_val_tbl OE_Order_Pub.Line_Val_Tbl_Type :=
275: p_line_val_tbl;
276: l_Line_Adj_tbl OE_Order_Pub.Line_Adj_Tbl_Type :=

Line 274: l_line_val_tbl OE_Order_Pub.Line_Val_Tbl_Type :=

270: p_Header_Scredit_val_tbl;
271: l_line_rec OE_Order_Pub.Line_Rec_Type ;
272: l_line_tbl OE_Order_Pub.Line_Tbl_Type :=
273: p_line_tbl;
274: l_line_val_tbl OE_Order_Pub.Line_Val_Tbl_Type :=
275: p_line_val_tbl;
276: l_Line_Adj_tbl OE_Order_Pub.Line_Adj_Tbl_Type :=
277: p_Line_Adj_tbl;
278: l_Line_Adj_val_tbl OE_Order_Pub.Line_Adj_Val_Tbl_Type :=

Line 276: l_Line_Adj_tbl OE_Order_Pub.Line_Adj_Tbl_Type :=

272: l_line_tbl OE_Order_Pub.Line_Tbl_Type :=
273: p_line_tbl;
274: l_line_val_tbl OE_Order_Pub.Line_Val_Tbl_Type :=
275: p_line_val_tbl;
276: l_Line_Adj_tbl OE_Order_Pub.Line_Adj_Tbl_Type :=
277: p_Line_Adj_tbl;
278: l_Line_Adj_val_tbl OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
279: p_Line_Adj_val_tbl;
280: l_Line_Price_Att_tbl OE_Order_Pub.Line_Price_Att_Tbl_Type;

Line 278: l_Line_Adj_val_tbl OE_Order_Pub.Line_Adj_Val_Tbl_Type :=

274: l_line_val_tbl OE_Order_Pub.Line_Val_Tbl_Type :=
275: p_line_val_tbl;
276: l_Line_Adj_tbl OE_Order_Pub.Line_Adj_Tbl_Type :=
277: p_Line_Adj_tbl;
278: l_Line_Adj_val_tbl OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
279: p_Line_Adj_val_tbl;
280: l_Line_Price_Att_tbl OE_Order_Pub.Line_Price_Att_Tbl_Type;
281: l_Line_Adj_Att_tbl OE_Order_Pub.Line_Adj_Att_Tbl_Type;
282: l_Line_Adj_Assoc_tbl OE_Order_Pub.Line_Adj_Assoc_Tbl_Type;

Line 280: l_Line_Price_Att_tbl OE_Order_Pub.Line_Price_Att_Tbl_Type;

276: l_Line_Adj_tbl OE_Order_Pub.Line_Adj_Tbl_Type :=
277: p_Line_Adj_tbl;
278: l_Line_Adj_val_tbl OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
279: p_Line_Adj_val_tbl;
280: l_Line_Price_Att_tbl OE_Order_Pub.Line_Price_Att_Tbl_Type;
281: l_Line_Adj_Att_tbl OE_Order_Pub.Line_Adj_Att_Tbl_Type;
282: l_Line_Adj_Assoc_tbl OE_Order_Pub.Line_Adj_Assoc_Tbl_Type;
283: l_Line_Scredit_tbl OE_Order_Pub.Line_Scredit_Tbl_Type :=
284: p_Line_Scredit_tbl;

Line 281: l_Line_Adj_Att_tbl OE_Order_Pub.Line_Adj_Att_Tbl_Type;

277: p_Line_Adj_tbl;
278: l_Line_Adj_val_tbl OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
279: p_Line_Adj_val_tbl;
280: l_Line_Price_Att_tbl OE_Order_Pub.Line_Price_Att_Tbl_Type;
281: l_Line_Adj_Att_tbl OE_Order_Pub.Line_Adj_Att_Tbl_Type;
282: l_Line_Adj_Assoc_tbl OE_Order_Pub.Line_Adj_Assoc_Tbl_Type;
283: l_Line_Scredit_tbl OE_Order_Pub.Line_Scredit_Tbl_Type :=
284: p_Line_Scredit_tbl;
285: l_Line_Scredit_val_tbl OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=

Line 282: l_Line_Adj_Assoc_tbl OE_Order_Pub.Line_Adj_Assoc_Tbl_Type;

278: l_Line_Adj_val_tbl OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
279: p_Line_Adj_val_tbl;
280: l_Line_Price_Att_tbl OE_Order_Pub.Line_Price_Att_Tbl_Type;
281: l_Line_Adj_Att_tbl OE_Order_Pub.Line_Adj_Att_Tbl_Type;
282: l_Line_Adj_Assoc_tbl OE_Order_Pub.Line_Adj_Assoc_Tbl_Type;
283: l_Line_Scredit_tbl OE_Order_Pub.Line_Scredit_Tbl_Type :=
284: p_Line_Scredit_tbl;
285: l_Line_Scredit_val_tbl OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
286: p_Line_Scredit_val_tbl;

Line 283: l_Line_Scredit_tbl OE_Order_Pub.Line_Scredit_Tbl_Type :=

279: p_Line_Adj_val_tbl;
280: l_Line_Price_Att_tbl OE_Order_Pub.Line_Price_Att_Tbl_Type;
281: l_Line_Adj_Att_tbl OE_Order_Pub.Line_Adj_Att_Tbl_Type;
282: l_Line_Adj_Assoc_tbl OE_Order_Pub.Line_Adj_Assoc_Tbl_Type;
283: l_Line_Scredit_tbl OE_Order_Pub.Line_Scredit_Tbl_Type :=
284: p_Line_Scredit_tbl;
285: l_Line_Scredit_val_tbl OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
286: p_Line_Scredit_val_tbl;
287: l_Lot_Serial_tbl OE_Order_Pub.Lot_Serial_Tbl_Type :=

Line 285: l_Line_Scredit_val_tbl OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=

281: l_Line_Adj_Att_tbl OE_Order_Pub.Line_Adj_Att_Tbl_Type;
282: l_Line_Adj_Assoc_tbl OE_Order_Pub.Line_Adj_Assoc_Tbl_Type;
283: l_Line_Scredit_tbl OE_Order_Pub.Line_Scredit_Tbl_Type :=
284: p_Line_Scredit_tbl;
285: l_Line_Scredit_val_tbl OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
286: p_Line_Scredit_val_tbl;
287: l_Lot_Serial_tbl OE_Order_Pub.Lot_Serial_Tbl_Type :=
288: p_Lot_Serial_tbl;
289: l_Lot_Serial_val_tbl OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=

Line 287: l_Lot_Serial_tbl OE_Order_Pub.Lot_Serial_Tbl_Type :=

283: l_Line_Scredit_tbl OE_Order_Pub.Line_Scredit_Tbl_Type :=
284: p_Line_Scredit_tbl;
285: l_Line_Scredit_val_tbl OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
286: p_Line_Scredit_val_tbl;
287: l_Lot_Serial_tbl OE_Order_Pub.Lot_Serial_Tbl_Type :=
288: p_Lot_Serial_tbl;
289: l_Lot_Serial_val_tbl OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=
290: p_Lot_Serial_val_tbl;
291: l_action_request_tbl OE_Order_Pub.Request_Tbl_Type :=

Line 289: l_Lot_Serial_val_tbl OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=

285: l_Line_Scredit_val_tbl OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
286: p_Line_Scredit_val_tbl;
287: l_Lot_Serial_tbl OE_Order_Pub.Lot_Serial_Tbl_Type :=
288: p_Lot_Serial_tbl;
289: l_Lot_Serial_val_tbl OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=
290: p_Lot_Serial_val_tbl;
291: l_action_request_tbl OE_Order_Pub.Request_Tbl_Type :=
292: p_action_request_tbl;
293:

Line 291: l_action_request_tbl OE_Order_Pub.Request_Tbl_Type :=

287: l_Lot_Serial_tbl OE_Order_Pub.Lot_Serial_Tbl_Type :=
288: p_Lot_Serial_tbl;
289: l_Lot_Serial_val_tbl OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=
290: p_Lot_Serial_val_tbl;
291: l_action_request_tbl OE_Order_Pub.Request_Tbl_Type :=
292: p_action_request_tbl;
293:
294: l_old_header_rec OE_Order_Pub.Header_Rec_Type :=
295: p_old_header_rec;

Line 294: l_old_header_rec OE_Order_Pub.Header_Rec_Type :=

290: p_Lot_Serial_val_tbl;
291: l_action_request_tbl OE_Order_Pub.Request_Tbl_Type :=
292: p_action_request_tbl;
293:
294: l_old_header_rec OE_Order_Pub.Header_Rec_Type :=
295: p_old_header_rec;
296: l_old_header_val_rec OE_Order_Pub.Header_Val_Rec_Type :=
297: p_old_header_val_rec;
298: l_old_Header_Adj_tbl OE_Order_Pub.Header_Adj_Tbl_Type :=

Line 296: l_old_header_val_rec OE_Order_Pub.Header_Val_Rec_Type :=

292: p_action_request_tbl;
293:
294: l_old_header_rec OE_Order_Pub.Header_Rec_Type :=
295: p_old_header_rec;
296: l_old_header_val_rec OE_Order_Pub.Header_Val_Rec_Type :=
297: p_old_header_val_rec;
298: l_old_Header_Adj_tbl OE_Order_Pub.Header_Adj_Tbl_Type :=
299: p_old_Header_Adj_tbl;
300: l_old_Header_Adj_val_tbl OE_Order_Pub.Header_Adj_Val_Tbl_Type :=

Line 298: l_old_Header_Adj_tbl OE_Order_Pub.Header_Adj_Tbl_Type :=

294: l_old_header_rec OE_Order_Pub.Header_Rec_Type :=
295: p_old_header_rec;
296: l_old_header_val_rec OE_Order_Pub.Header_Val_Rec_Type :=
297: p_old_header_val_rec;
298: l_old_Header_Adj_tbl OE_Order_Pub.Header_Adj_Tbl_Type :=
299: p_old_Header_Adj_tbl;
300: l_old_Header_Adj_val_tbl OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
301: p_old_Header_Adj_val_tbl;
302: l_old_Header_Price_Att_tbl OE_Order_Pub.Header_Price_Att_Tbl_Type;

Line 300: l_old_Header_Adj_val_tbl OE_Order_Pub.Header_Adj_Val_Tbl_Type :=

296: l_old_header_val_rec OE_Order_Pub.Header_Val_Rec_Type :=
297: p_old_header_val_rec;
298: l_old_Header_Adj_tbl OE_Order_Pub.Header_Adj_Tbl_Type :=
299: p_old_Header_Adj_tbl;
300: l_old_Header_Adj_val_tbl OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
301: p_old_Header_Adj_val_tbl;
302: l_old_Header_Price_Att_tbl OE_Order_Pub.Header_Price_Att_Tbl_Type;
303: l_old_Header_Adj_Att_tbl OE_Order_Pub.Header_Adj_Att_Tbl_Type;
304: l_old_Header_Adj_Assoc_tbl OE_Order_Pub.Header_Adj_Assoc_Tbl_Type;

Line 302: l_old_Header_Price_Att_tbl OE_Order_Pub.Header_Price_Att_Tbl_Type;

298: l_old_Header_Adj_tbl OE_Order_Pub.Header_Adj_Tbl_Type :=
299: p_old_Header_Adj_tbl;
300: l_old_Header_Adj_val_tbl OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
301: p_old_Header_Adj_val_tbl;
302: l_old_Header_Price_Att_tbl OE_Order_Pub.Header_Price_Att_Tbl_Type;
303: l_old_Header_Adj_Att_tbl OE_Order_Pub.Header_Adj_Att_Tbl_Type;
304: l_old_Header_Adj_Assoc_tbl OE_Order_Pub.Header_Adj_Assoc_Tbl_Type;
305: l_old_Header_Scredit_tbl OE_Order_Pub.Header_Scredit_Tbl_Type :=
306: p_old_Header_Scredit_tbl;

Line 303: l_old_Header_Adj_Att_tbl OE_Order_Pub.Header_Adj_Att_Tbl_Type;

299: p_old_Header_Adj_tbl;
300: l_old_Header_Adj_val_tbl OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
301: p_old_Header_Adj_val_tbl;
302: l_old_Header_Price_Att_tbl OE_Order_Pub.Header_Price_Att_Tbl_Type;
303: l_old_Header_Adj_Att_tbl OE_Order_Pub.Header_Adj_Att_Tbl_Type;
304: l_old_Header_Adj_Assoc_tbl OE_Order_Pub.Header_Adj_Assoc_Tbl_Type;
305: l_old_Header_Scredit_tbl OE_Order_Pub.Header_Scredit_Tbl_Type :=
306: p_old_Header_Scredit_tbl;
307: l_old_Header_Scredit_val_tbl OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=

Line 304: l_old_Header_Adj_Assoc_tbl OE_Order_Pub.Header_Adj_Assoc_Tbl_Type;

300: l_old_Header_Adj_val_tbl OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
301: p_old_Header_Adj_val_tbl;
302: l_old_Header_Price_Att_tbl OE_Order_Pub.Header_Price_Att_Tbl_Type;
303: l_old_Header_Adj_Att_tbl OE_Order_Pub.Header_Adj_Att_Tbl_Type;
304: l_old_Header_Adj_Assoc_tbl OE_Order_Pub.Header_Adj_Assoc_Tbl_Type;
305: l_old_Header_Scredit_tbl OE_Order_Pub.Header_Scredit_Tbl_Type :=
306: p_old_Header_Scredit_tbl;
307: l_old_Header_Scredit_val_tbl OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
308: p_old_Header_Scredit_val_tbl;

Line 305: l_old_Header_Scredit_tbl OE_Order_Pub.Header_Scredit_Tbl_Type :=

301: p_old_Header_Adj_val_tbl;
302: l_old_Header_Price_Att_tbl OE_Order_Pub.Header_Price_Att_Tbl_Type;
303: l_old_Header_Adj_Att_tbl OE_Order_Pub.Header_Adj_Att_Tbl_Type;
304: l_old_Header_Adj_Assoc_tbl OE_Order_Pub.Header_Adj_Assoc_Tbl_Type;
305: l_old_Header_Scredit_tbl OE_Order_Pub.Header_Scredit_Tbl_Type :=
306: p_old_Header_Scredit_tbl;
307: l_old_Header_Scredit_val_tbl OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
308: p_old_Header_Scredit_val_tbl;
309: l_old_line_tbl OE_Order_Pub.Line_Tbl_Type :=

Line 307: l_old_Header_Scredit_val_tbl OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=

303: l_old_Header_Adj_Att_tbl OE_Order_Pub.Header_Adj_Att_Tbl_Type;
304: l_old_Header_Adj_Assoc_tbl OE_Order_Pub.Header_Adj_Assoc_Tbl_Type;
305: l_old_Header_Scredit_tbl OE_Order_Pub.Header_Scredit_Tbl_Type :=
306: p_old_Header_Scredit_tbl;
307: l_old_Header_Scredit_val_tbl OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
308: p_old_Header_Scredit_val_tbl;
309: l_old_line_tbl OE_Order_Pub.Line_Tbl_Type :=
310: p_old_line_tbl;
311: l_old_line_val_tbl OE_Order_Pub.Line_Val_Tbl_Type :=

Line 309: l_old_line_tbl OE_Order_Pub.Line_Tbl_Type :=

305: l_old_Header_Scredit_tbl OE_Order_Pub.Header_Scredit_Tbl_Type :=
306: p_old_Header_Scredit_tbl;
307: l_old_Header_Scredit_val_tbl OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
308: p_old_Header_Scredit_val_tbl;
309: l_old_line_tbl OE_Order_Pub.Line_Tbl_Type :=
310: p_old_line_tbl;
311: l_old_line_val_tbl OE_Order_Pub.Line_Val_Tbl_Type :=
312: p_old_line_val_tbl;
313: l_old_Line_Adj_tbl OE_Order_Pub.Line_Adj_Tbl_Type :=

Line 311: l_old_line_val_tbl OE_Order_Pub.Line_Val_Tbl_Type :=

307: l_old_Header_Scredit_val_tbl OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
308: p_old_Header_Scredit_val_tbl;
309: l_old_line_tbl OE_Order_Pub.Line_Tbl_Type :=
310: p_old_line_tbl;
311: l_old_line_val_tbl OE_Order_Pub.Line_Val_Tbl_Type :=
312: p_old_line_val_tbl;
313: l_old_Line_Adj_tbl OE_Order_Pub.Line_Adj_Tbl_Type :=
314: p_old_Line_Adj_tbl;
315: l_old_Line_Adj_val_tbl OE_Order_Pub.Line_Adj_Val_Tbl_Type :=

Line 313: l_old_Line_Adj_tbl OE_Order_Pub.Line_Adj_Tbl_Type :=

309: l_old_line_tbl OE_Order_Pub.Line_Tbl_Type :=
310: p_old_line_tbl;
311: l_old_line_val_tbl OE_Order_Pub.Line_Val_Tbl_Type :=
312: p_old_line_val_tbl;
313: l_old_Line_Adj_tbl OE_Order_Pub.Line_Adj_Tbl_Type :=
314: p_old_Line_Adj_tbl;
315: l_old_Line_Adj_val_tbl OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
316: p_old_Line_Adj_val_tbl;
317: l_old_Line_Price_Att_tbl OE_Order_Pub.Line_Price_Att_Tbl_Type;

Line 315: l_old_Line_Adj_val_tbl OE_Order_Pub.Line_Adj_Val_Tbl_Type :=

311: l_old_line_val_tbl OE_Order_Pub.Line_Val_Tbl_Type :=
312: p_old_line_val_tbl;
313: l_old_Line_Adj_tbl OE_Order_Pub.Line_Adj_Tbl_Type :=
314: p_old_Line_Adj_tbl;
315: l_old_Line_Adj_val_tbl OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
316: p_old_Line_Adj_val_tbl;
317: l_old_Line_Price_Att_tbl OE_Order_Pub.Line_Price_Att_Tbl_Type;
318: l_old_Line_Adj_Att_tbl OE_Order_Pub.Line_Adj_Att_Tbl_Type;
319: l_old_Line_Adj_Assoc_tbl OE_Order_Pub.Line_Adj_Assoc_Tbl_Type;

Line 317: l_old_Line_Price_Att_tbl OE_Order_Pub.Line_Price_Att_Tbl_Type;

313: l_old_Line_Adj_tbl OE_Order_Pub.Line_Adj_Tbl_Type :=
314: p_old_Line_Adj_tbl;
315: l_old_Line_Adj_val_tbl OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
316: p_old_Line_Adj_val_tbl;
317: l_old_Line_Price_Att_tbl OE_Order_Pub.Line_Price_Att_Tbl_Type;
318: l_old_Line_Adj_Att_tbl OE_Order_Pub.Line_Adj_Att_Tbl_Type;
319: l_old_Line_Adj_Assoc_tbl OE_Order_Pub.Line_Adj_Assoc_Tbl_Type;
320: l_old_Line_Scredit_tbl OE_Order_Pub.Line_Scredit_Tbl_Type :=
321: p_old_Line_Scredit_tbl;

Line 318: l_old_Line_Adj_Att_tbl OE_Order_Pub.Line_Adj_Att_Tbl_Type;

314: p_old_Line_Adj_tbl;
315: l_old_Line_Adj_val_tbl OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
316: p_old_Line_Adj_val_tbl;
317: l_old_Line_Price_Att_tbl OE_Order_Pub.Line_Price_Att_Tbl_Type;
318: l_old_Line_Adj_Att_tbl OE_Order_Pub.Line_Adj_Att_Tbl_Type;
319: l_old_Line_Adj_Assoc_tbl OE_Order_Pub.Line_Adj_Assoc_Tbl_Type;
320: l_old_Line_Scredit_tbl OE_Order_Pub.Line_Scredit_Tbl_Type :=
321: p_old_Line_Scredit_tbl;
322: l_old_Line_Scredit_val_tbl OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=

Line 319: l_old_Line_Adj_Assoc_tbl OE_Order_Pub.Line_Adj_Assoc_Tbl_Type;

315: l_old_Line_Adj_val_tbl OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
316: p_old_Line_Adj_val_tbl;
317: l_old_Line_Price_Att_tbl OE_Order_Pub.Line_Price_Att_Tbl_Type;
318: l_old_Line_Adj_Att_tbl OE_Order_Pub.Line_Adj_Att_Tbl_Type;
319: l_old_Line_Adj_Assoc_tbl OE_Order_Pub.Line_Adj_Assoc_Tbl_Type;
320: l_old_Line_Scredit_tbl OE_Order_Pub.Line_Scredit_Tbl_Type :=
321: p_old_Line_Scredit_tbl;
322: l_old_Line_Scredit_val_tbl OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
323: p_old_Line_Scredit_val_tbl;

Line 320: l_old_Line_Scredit_tbl OE_Order_Pub.Line_Scredit_Tbl_Type :=

316: p_old_Line_Adj_val_tbl;
317: l_old_Line_Price_Att_tbl OE_Order_Pub.Line_Price_Att_Tbl_Type;
318: l_old_Line_Adj_Att_tbl OE_Order_Pub.Line_Adj_Att_Tbl_Type;
319: l_old_Line_Adj_Assoc_tbl OE_Order_Pub.Line_Adj_Assoc_Tbl_Type;
320: l_old_Line_Scredit_tbl OE_Order_Pub.Line_Scredit_Tbl_Type :=
321: p_old_Line_Scredit_tbl;
322: l_old_Line_Scredit_val_tbl OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
323: p_old_Line_Scredit_val_tbl;
324: l_old_Lot_Serial_tbl OE_Order_Pub.Lot_Serial_Tbl_Type :=

Line 322: l_old_Line_Scredit_val_tbl OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=

318: l_old_Line_Adj_Att_tbl OE_Order_Pub.Line_Adj_Att_Tbl_Type;
319: l_old_Line_Adj_Assoc_tbl OE_Order_Pub.Line_Adj_Assoc_Tbl_Type;
320: l_old_Line_Scredit_tbl OE_Order_Pub.Line_Scredit_Tbl_Type :=
321: p_old_Line_Scredit_tbl;
322: l_old_Line_Scredit_val_tbl OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
323: p_old_Line_Scredit_val_tbl;
324: l_old_Lot_Serial_tbl OE_Order_Pub.Lot_Serial_Tbl_Type :=
325: p_old_Lot_Serial_tbl;
326: l_old_Lot_Serial_val_tbl OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=

Line 324: l_old_Lot_Serial_tbl OE_Order_Pub.Lot_Serial_Tbl_Type :=

320: l_old_Line_Scredit_tbl OE_Order_Pub.Line_Scredit_Tbl_Type :=
321: p_old_Line_Scredit_tbl;
322: l_old_Line_Scredit_val_tbl OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
323: p_old_Line_Scredit_val_tbl;
324: l_old_Lot_Serial_tbl OE_Order_Pub.Lot_Serial_Tbl_Type :=
325: p_old_Lot_Serial_tbl;
326: l_old_Lot_Serial_val_tbl OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=
327: p_old_Lot_Serial_val_tbl;
328:

Line 326: l_old_Lot_Serial_val_tbl OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=

322: l_old_Line_Scredit_val_tbl OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
323: p_old_Line_Scredit_val_tbl;
324: l_old_Lot_Serial_tbl OE_Order_Pub.Lot_Serial_Tbl_Type :=
325: p_old_Lot_Serial_tbl;
326: l_old_Lot_Serial_val_tbl OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=
327: p_old_Lot_Serial_val_tbl;
328:
329: l_address_id NUMBER;
330: l_tp_ret BOOLEAN;

Line 349: l_reject_line_tbl OE_Order_Pub.Line_Tbl_Type :=

345: l_rejected_lines VARCHAR2(1) := FND_API.G_MISS_CHAR;
346:
347: -- Following Local Variables are for getting the data related to
348: -- Rejected Lines and Corresponding Lotserial for Acknowledgment
349: l_reject_line_tbl OE_Order_Pub.Line_Tbl_Type :=
350: OE_Order_Pub.G_MISS_LINE_TBL;
351: l_reject_line_val_tbl OE_Order_Pub.Line_Val_Tbl_Type :=
352: OE_Order_Pub.G_MISS_LINE_VAL_TBL;
353: l_reject_Lot_Serial_tbl OE_Order_Pub.Lot_Serial_Tbl_Type :=

Line 350: OE_Order_Pub.G_MISS_LINE_TBL;

346:
347: -- Following Local Variables are for getting the data related to
348: -- Rejected Lines and Corresponding Lotserial for Acknowledgment
349: l_reject_line_tbl OE_Order_Pub.Line_Tbl_Type :=
350: OE_Order_Pub.G_MISS_LINE_TBL;
351: l_reject_line_val_tbl OE_Order_Pub.Line_Val_Tbl_Type :=
352: OE_Order_Pub.G_MISS_LINE_VAL_TBL;
353: l_reject_Lot_Serial_tbl OE_Order_Pub.Lot_Serial_Tbl_Type :=
354: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL;

Line 351: l_reject_line_val_tbl OE_Order_Pub.Line_Val_Tbl_Type :=

347: -- Following Local Variables are for getting the data related to
348: -- Rejected Lines and Corresponding Lotserial for Acknowledgment
349: l_reject_line_tbl OE_Order_Pub.Line_Tbl_Type :=
350: OE_Order_Pub.G_MISS_LINE_TBL;
351: l_reject_line_val_tbl OE_Order_Pub.Line_Val_Tbl_Type :=
352: OE_Order_Pub.G_MISS_LINE_VAL_TBL;
353: l_reject_Lot_Serial_tbl OE_Order_Pub.Lot_Serial_Tbl_Type :=
354: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL;
355: l_reject_Lot_Serial_val_tbl OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=

Line 352: OE_Order_Pub.G_MISS_LINE_VAL_TBL;

348: -- Rejected Lines and Corresponding Lotserial for Acknowledgment
349: l_reject_line_tbl OE_Order_Pub.Line_Tbl_Type :=
350: OE_Order_Pub.G_MISS_LINE_TBL;
351: l_reject_line_val_tbl OE_Order_Pub.Line_Val_Tbl_Type :=
352: OE_Order_Pub.G_MISS_LINE_VAL_TBL;
353: l_reject_Lot_Serial_tbl OE_Order_Pub.Lot_Serial_Tbl_Type :=
354: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL;
355: l_reject_Lot_Serial_val_tbl OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=
356: OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL;

Line 353: l_reject_Lot_Serial_tbl OE_Order_Pub.Lot_Serial_Tbl_Type :=

349: l_reject_line_tbl OE_Order_Pub.Line_Tbl_Type :=
350: OE_Order_Pub.G_MISS_LINE_TBL;
351: l_reject_line_val_tbl OE_Order_Pub.Line_Val_Tbl_Type :=
352: OE_Order_Pub.G_MISS_LINE_VAL_TBL;
353: l_reject_Lot_Serial_tbl OE_Order_Pub.Lot_Serial_Tbl_Type :=
354: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL;
355: l_reject_Lot_Serial_val_tbl OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=
356: OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL;
357:

Line 354: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL;

350: OE_Order_Pub.G_MISS_LINE_TBL;
351: l_reject_line_val_tbl OE_Order_Pub.Line_Val_Tbl_Type :=
352: OE_Order_Pub.G_MISS_LINE_VAL_TBL;
353: l_reject_Lot_Serial_tbl OE_Order_Pub.Lot_Serial_Tbl_Type :=
354: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL;
355: l_reject_Lot_Serial_val_tbl OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=
356: OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL;
357:
358: -- This variable will be passed as value for parameter p_reject_order

Line 355: l_reject_Lot_Serial_val_tbl OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=

351: l_reject_line_val_tbl OE_Order_Pub.Line_Val_Tbl_Type :=
352: OE_Order_Pub.G_MISS_LINE_VAL_TBL;
353: l_reject_Lot_Serial_tbl OE_Order_Pub.Lot_Serial_Tbl_Type :=
354: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL;
355: l_reject_Lot_Serial_val_tbl OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=
356: OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL;
357:
358: -- This variable will be passed as value for parameter p_reject_order
359: -- In Insert_Row APIs for creating new rows for the rejected lines

Line 356: OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL;

352: OE_Order_Pub.G_MISS_LINE_VAL_TBL;
353: l_reject_Lot_Serial_tbl OE_Order_Pub.Lot_Serial_Tbl_Type :=
354: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL;
355: l_reject_Lot_Serial_val_tbl OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=
356: OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL;
357:
358: -- This variable will be passed as value for parameter p_reject_order
359: -- In Insert_Row APIs for creating new rows for the rejected lines
360: -- in Acknowledgment Line and Lotserial tables.

Line 2010: (p_header_rec In OE_Order_Pub.Header_Rec_Type,

2006: END Process_Acknowledgment;
2007:
2008:
2009: Procedure Process_Acknowledgment
2010: (p_header_rec In OE_Order_Pub.Header_Rec_Type,
2011: p_line_tbl In OE_Order_Pub.Line_Tbl_Type,
2012: p_old_header_rec In OE_Order_Pub.Header_Rec_Type,
2013: p_old_line_tbl In OE_Order_Pub.Line_Tbl_Type,
2014: x_return_status Out NOCOPY /* file.sql.39 change */ VARCHAR2

Line 2011: p_line_tbl In OE_Order_Pub.Line_Tbl_Type,

2007:
2008:
2009: Procedure Process_Acknowledgment
2010: (p_header_rec In OE_Order_Pub.Header_Rec_Type,
2011: p_line_tbl In OE_Order_Pub.Line_Tbl_Type,
2012: p_old_header_rec In OE_Order_Pub.Header_Rec_Type,
2013: p_old_line_tbl In OE_Order_Pub.Line_Tbl_Type,
2014: x_return_status Out NOCOPY /* file.sql.39 change */ VARCHAR2
2015: )

Line 2012: p_old_header_rec In OE_Order_Pub.Header_Rec_Type,

2008:
2009: Procedure Process_Acknowledgment
2010: (p_header_rec In OE_Order_Pub.Header_Rec_Type,
2011: p_line_tbl In OE_Order_Pub.Line_Tbl_Type,
2012: p_old_header_rec In OE_Order_Pub.Header_Rec_Type,
2013: p_old_line_tbl In OE_Order_Pub.Line_Tbl_Type,
2014: x_return_status Out NOCOPY /* file.sql.39 change */ VARCHAR2
2015: )
2016: Is

Line 2013: p_old_line_tbl In OE_Order_Pub.Line_Tbl_Type,

2009: Procedure Process_Acknowledgment
2010: (p_header_rec In OE_Order_Pub.Header_Rec_Type,
2011: p_line_tbl In OE_Order_Pub.Line_Tbl_Type,
2012: p_old_header_rec In OE_Order_Pub.Header_Rec_Type,
2013: p_old_line_tbl In OE_Order_Pub.Line_Tbl_Type,
2014: x_return_status Out NOCOPY /* file.sql.39 change */ VARCHAR2
2015: )
2016: Is
2017:

Line 2024: l_header_rec OE_Order_Pub.Header_Rec_Type := p_header_rec;

2020: l_industry Varchar2(1);
2021: l_o_schema Varchar2(30);
2022: l_booked_flag Varchar2(1);
2023: l_line_index Pls_Integer;
2024: l_header_rec OE_Order_Pub.Header_Rec_Type := p_header_rec;
2025: l_line_tbl OE_Order_Pub.Line_Tbl_Type := p_line_tbl;
2026: l_address_id Number;
2027: l_site_use_id Number;
2028: l_tp_ret Boolean;

Line 2025: l_line_tbl OE_Order_Pub.Line_Tbl_Type := p_line_tbl;

2021: l_o_schema Varchar2(30);
2022: l_booked_flag Varchar2(1);
2023: l_line_index Pls_Integer;
2024: l_header_rec OE_Order_Pub.Header_Rec_Type := p_header_rec;
2025: l_line_tbl OE_Order_Pub.Line_Tbl_Type := p_line_tbl;
2026: l_address_id Number;
2027: l_site_use_id Number;
2028: l_tp_ret Boolean;
2029: l_tp_ret_status Varchar2(200);

Line 2035: l_line_rec OE_Order_Pub.Line_Rec_Type ;

2031: l_msg_data Varchar2(200);
2032: l_ack_req_flag Varchar2(1) := 'N';
2033: i Pls_Integer;
2034: j Pls_Integer;
2035: l_line_rec OE_Order_Pub.Line_Rec_Type ;
2036: l_old_line_tbl OE_Order_Pub.Line_Tbl_Type := p_old_line_tbl;
2037: l_old_header_rec OE_Order_Pub.Header_Rec_Type := p_old_header_rec;
2038: l_return_status Varchar2(1);
2039: l_rejected_lines Varchar2(1);

Line 2036: l_old_line_tbl OE_Order_Pub.Line_Tbl_Type := p_old_line_tbl;

2032: l_ack_req_flag Varchar2(1) := 'N';
2033: i Pls_Integer;
2034: j Pls_Integer;
2035: l_line_rec OE_Order_Pub.Line_Rec_Type ;
2036: l_old_line_tbl OE_Order_Pub.Line_Tbl_Type := p_old_line_tbl;
2037: l_old_header_rec OE_Order_Pub.Header_Rec_Type := p_old_header_rec;
2038: l_return_status Varchar2(1);
2039: l_rejected_lines Varchar2(1);
2040:

Line 2037: l_old_header_rec OE_Order_Pub.Header_Rec_Type := p_old_header_rec;

2033: i Pls_Integer;
2034: j Pls_Integer;
2035: l_line_rec OE_Order_Pub.Line_Rec_Type ;
2036: l_old_line_tbl OE_Order_Pub.Line_Tbl_Type := p_old_line_tbl;
2037: l_old_header_rec OE_Order_Pub.Header_Rec_Type := p_old_header_rec;
2038: l_return_status Varchar2(1);
2039: l_rejected_lines Varchar2(1);
2040:
2041: l_reject_line_tbl OE_Order_Pub.Line_Tbl_Type;

Line 2041: l_reject_line_tbl OE_Order_Pub.Line_Tbl_Type;

2037: l_old_header_rec OE_Order_Pub.Header_Rec_Type := p_old_header_rec;
2038: l_return_status Varchar2(1);
2039: l_rejected_lines Varchar2(1);
2040:
2041: l_reject_line_tbl OE_Order_Pub.Line_Tbl_Type;
2042: l_reject_line_val_tbl OE_Order_Pub.Line_Val_Tbl_Type;
2043: l_reject_Lot_Serial_tbl OE_Order_Pub.Lot_Serial_Tbl_Type;
2044: l_reject_Lot_Serial_val_tbl OE_Order_Pub.Lot_Serial_Val_Tbl_Type;
2045:

Line 2042: l_reject_line_val_tbl OE_Order_Pub.Line_Val_Tbl_Type;

2038: l_return_status Varchar2(1);
2039: l_rejected_lines Varchar2(1);
2040:
2041: l_reject_line_tbl OE_Order_Pub.Line_Tbl_Type;
2042: l_reject_line_val_tbl OE_Order_Pub.Line_Val_Tbl_Type;
2043: l_reject_Lot_Serial_tbl OE_Order_Pub.Lot_Serial_Tbl_Type;
2044: l_reject_Lot_Serial_val_tbl OE_Order_Pub.Lot_Serial_Val_Tbl_Type;
2045:
2046: l_xml_message_id Number;

Line 2043: l_reject_Lot_Serial_tbl OE_Order_Pub.Lot_Serial_Tbl_Type;

2039: l_rejected_lines Varchar2(1);
2040:
2041: l_reject_line_tbl OE_Order_Pub.Line_Tbl_Type;
2042: l_reject_line_val_tbl OE_Order_Pub.Line_Val_Tbl_Type;
2043: l_reject_Lot_Serial_tbl OE_Order_Pub.Lot_Serial_Tbl_Type;
2044: l_reject_Lot_Serial_val_tbl OE_Order_Pub.Lot_Serial_Val_Tbl_Type;
2045:
2046: l_xml_message_id Number;
2047: l_ack_type Varchar2(30);

Line 2044: l_reject_Lot_Serial_val_tbl OE_Order_Pub.Lot_Serial_Val_Tbl_Type;

2040:
2041: l_reject_line_tbl OE_Order_Pub.Line_Tbl_Type;
2042: l_reject_line_val_tbl OE_Order_Pub.Line_Val_Tbl_Type;
2043: l_reject_Lot_Serial_tbl OE_Order_Pub.Lot_Serial_Tbl_Type;
2044: l_reject_Lot_Serial_val_tbl OE_Order_Pub.Lot_Serial_Val_Tbl_Type;
2045:
2046: l_xml_message_id Number;
2047: l_ack_type Varchar2(30);
2048: l_sold_to_org Varchar2(360);