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_SERVICE_UTIL dependencies on OE_SERVICE_UTIL

Line 1: Package body OE_SERVICE_UTIL As

1: Package body OE_SERVICE_UTIL As
2: /* $Header: OEXUSVCB.pls 120.9.12010000.2 2008/11/14 11:28:28 smanian ship $ */
3:
4: G_ASO_STATUS VARCHAR2(1) := FND_API.G_MISS_CHAR;
5: G_OKC_STATUS VARCHAR2(1) := FND_API.G_MISS_CHAR;

Line 151: OE_SERVICE_UTIL.CHECK_PROC('ASO_ORDER_FEEDBACK_PUB.UPDATE_NOTICE', l_return_status);

147: -- Update_Notice API. If exists Then Call it else No Problem.
148:
149: -- Commenting out the call to check proc for performance improvement
150: /*
151: OE_SERVICE_UTIL.CHECK_PROC('ASO_ORDER_FEEDBACK_PUB.UPDATE_NOTICE', l_return_status);
152: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
153: */
154:
155: /* The application id for Order Capture is 697 */

Line 190: , OE_SERVICE_UTIL.g_header_rec

186: , :p_commit
187: , :x_return_status
188: , :x_msg_count
189: , :x_msg_data
190: , OE_SERVICE_UTIL.g_header_rec
191: , OE_SERVICE_UTIL.g_old_header_rec
192: , OE_SERVICE_UTIL.g_header_adj_tbl
193: , OE_SERVICE_UTIL.g_old_header_adj_tbl
194: , OE_SERVICE_UTIL.g_header_price_att_tbl

Line 191: , OE_SERVICE_UTIL.g_old_header_rec

187: , :x_return_status
188: , :x_msg_count
189: , :x_msg_data
190: , OE_SERVICE_UTIL.g_header_rec
191: , OE_SERVICE_UTIL.g_old_header_rec
192: , OE_SERVICE_UTIL.g_header_adj_tbl
193: , OE_SERVICE_UTIL.g_old_header_adj_tbl
194: , OE_SERVICE_UTIL.g_header_price_att_tbl
195: , OE_SERVICE_UTIL.g_old_header_price_att_tbl

Line 192: , OE_SERVICE_UTIL.g_header_adj_tbl

188: , :x_msg_count
189: , :x_msg_data
190: , OE_SERVICE_UTIL.g_header_rec
191: , OE_SERVICE_UTIL.g_old_header_rec
192: , OE_SERVICE_UTIL.g_header_adj_tbl
193: , OE_SERVICE_UTIL.g_old_header_adj_tbl
194: , OE_SERVICE_UTIL.g_header_price_att_tbl
195: , OE_SERVICE_UTIL.g_old_header_price_att_tbl
196: , OE_SERVICE_UTIL.g_header_adj_att_tbl

Line 193: , OE_SERVICE_UTIL.g_old_header_adj_tbl

189: , :x_msg_data
190: , OE_SERVICE_UTIL.g_header_rec
191: , OE_SERVICE_UTIL.g_old_header_rec
192: , OE_SERVICE_UTIL.g_header_adj_tbl
193: , OE_SERVICE_UTIL.g_old_header_adj_tbl
194: , OE_SERVICE_UTIL.g_header_price_att_tbl
195: , OE_SERVICE_UTIL.g_old_header_price_att_tbl
196: , OE_SERVICE_UTIL.g_header_adj_att_tbl
197: , OE_SERVICE_UTIL.g_old_header_adj_att_tbl

Line 194: , OE_SERVICE_UTIL.g_header_price_att_tbl

190: , OE_SERVICE_UTIL.g_header_rec
191: , OE_SERVICE_UTIL.g_old_header_rec
192: , OE_SERVICE_UTIL.g_header_adj_tbl
193: , OE_SERVICE_UTIL.g_old_header_adj_tbl
194: , OE_SERVICE_UTIL.g_header_price_att_tbl
195: , OE_SERVICE_UTIL.g_old_header_price_att_tbl
196: , OE_SERVICE_UTIL.g_header_adj_att_tbl
197: , OE_SERVICE_UTIL.g_old_header_adj_att_tbl
198: , OE_SERVICE_UTIL.g_header_adj_assoc_tbl

Line 195: , OE_SERVICE_UTIL.g_old_header_price_att_tbl

191: , OE_SERVICE_UTIL.g_old_header_rec
192: , OE_SERVICE_UTIL.g_header_adj_tbl
193: , OE_SERVICE_UTIL.g_old_header_adj_tbl
194: , OE_SERVICE_UTIL.g_header_price_att_tbl
195: , OE_SERVICE_UTIL.g_old_header_price_att_tbl
196: , OE_SERVICE_UTIL.g_header_adj_att_tbl
197: , OE_SERVICE_UTIL.g_old_header_adj_att_tbl
198: , OE_SERVICE_UTIL.g_header_adj_assoc_tbl
199: , OE_SERVICE_UTIL.g_old_header_adj_assoc_tbl

Line 196: , OE_SERVICE_UTIL.g_header_adj_att_tbl

192: , OE_SERVICE_UTIL.g_header_adj_tbl
193: , OE_SERVICE_UTIL.g_old_header_adj_tbl
194: , OE_SERVICE_UTIL.g_header_price_att_tbl
195: , OE_SERVICE_UTIL.g_old_header_price_att_tbl
196: , OE_SERVICE_UTIL.g_header_adj_att_tbl
197: , OE_SERVICE_UTIL.g_old_header_adj_att_tbl
198: , OE_SERVICE_UTIL.g_header_adj_assoc_tbl
199: , OE_SERVICE_UTIL.g_old_header_adj_assoc_tbl
200: , OE_SERVICE_UTIL.g_header_scredit_tbl

Line 197: , OE_SERVICE_UTIL.g_old_header_adj_att_tbl

193: , OE_SERVICE_UTIL.g_old_header_adj_tbl
194: , OE_SERVICE_UTIL.g_header_price_att_tbl
195: , OE_SERVICE_UTIL.g_old_header_price_att_tbl
196: , OE_SERVICE_UTIL.g_header_adj_att_tbl
197: , OE_SERVICE_UTIL.g_old_header_adj_att_tbl
198: , OE_SERVICE_UTIL.g_header_adj_assoc_tbl
199: , OE_SERVICE_UTIL.g_old_header_adj_assoc_tbl
200: , OE_SERVICE_UTIL.g_header_scredit_tbl
201: , OE_SERVICE_UTIL.g_old_header_scredit_tbl

Line 198: , OE_SERVICE_UTIL.g_header_adj_assoc_tbl

194: , OE_SERVICE_UTIL.g_header_price_att_tbl
195: , OE_SERVICE_UTIL.g_old_header_price_att_tbl
196: , OE_SERVICE_UTIL.g_header_adj_att_tbl
197: , OE_SERVICE_UTIL.g_old_header_adj_att_tbl
198: , OE_SERVICE_UTIL.g_header_adj_assoc_tbl
199: , OE_SERVICE_UTIL.g_old_header_adj_assoc_tbl
200: , OE_SERVICE_UTIL.g_header_scredit_tbl
201: , OE_SERVICE_UTIL.g_old_header_scredit_tbl
202: , OE_SERVICE_UTIL.g_line_tbl

Line 199: , OE_SERVICE_UTIL.g_old_header_adj_assoc_tbl

195: , OE_SERVICE_UTIL.g_old_header_price_att_tbl
196: , OE_SERVICE_UTIL.g_header_adj_att_tbl
197: , OE_SERVICE_UTIL.g_old_header_adj_att_tbl
198: , OE_SERVICE_UTIL.g_header_adj_assoc_tbl
199: , OE_SERVICE_UTIL.g_old_header_adj_assoc_tbl
200: , OE_SERVICE_UTIL.g_header_scredit_tbl
201: , OE_SERVICE_UTIL.g_old_header_scredit_tbl
202: , OE_SERVICE_UTIL.g_line_tbl
203: , OE_SERVICE_UTIL.g_old_line_tbl

Line 200: , OE_SERVICE_UTIL.g_header_scredit_tbl

196: , OE_SERVICE_UTIL.g_header_adj_att_tbl
197: , OE_SERVICE_UTIL.g_old_header_adj_att_tbl
198: , OE_SERVICE_UTIL.g_header_adj_assoc_tbl
199: , OE_SERVICE_UTIL.g_old_header_adj_assoc_tbl
200: , OE_SERVICE_UTIL.g_header_scredit_tbl
201: , OE_SERVICE_UTIL.g_old_header_scredit_tbl
202: , OE_SERVICE_UTIL.g_line_tbl
203: , OE_SERVICE_UTIL.g_old_line_tbl
204: , OE_SERVICE_UTIL.g_line_adj_tbl

Line 201: , OE_SERVICE_UTIL.g_old_header_scredit_tbl

197: , OE_SERVICE_UTIL.g_old_header_adj_att_tbl
198: , OE_SERVICE_UTIL.g_header_adj_assoc_tbl
199: , OE_SERVICE_UTIL.g_old_header_adj_assoc_tbl
200: , OE_SERVICE_UTIL.g_header_scredit_tbl
201: , OE_SERVICE_UTIL.g_old_header_scredit_tbl
202: , OE_SERVICE_UTIL.g_line_tbl
203: , OE_SERVICE_UTIL.g_old_line_tbl
204: , OE_SERVICE_UTIL.g_line_adj_tbl
205: , OE_SERVICE_UTIL.g_old_line_adj_tbl

Line 202: , OE_SERVICE_UTIL.g_line_tbl

198: , OE_SERVICE_UTIL.g_header_adj_assoc_tbl
199: , OE_SERVICE_UTIL.g_old_header_adj_assoc_tbl
200: , OE_SERVICE_UTIL.g_header_scredit_tbl
201: , OE_SERVICE_UTIL.g_old_header_scredit_tbl
202: , OE_SERVICE_UTIL.g_line_tbl
203: , OE_SERVICE_UTIL.g_old_line_tbl
204: , OE_SERVICE_UTIL.g_line_adj_tbl
205: , OE_SERVICE_UTIL.g_old_line_adj_tbl
206: , OE_SERVICE_UTIL.g_line_price_att_tbl

Line 203: , OE_SERVICE_UTIL.g_old_line_tbl

199: , OE_SERVICE_UTIL.g_old_header_adj_assoc_tbl
200: , OE_SERVICE_UTIL.g_header_scredit_tbl
201: , OE_SERVICE_UTIL.g_old_header_scredit_tbl
202: , OE_SERVICE_UTIL.g_line_tbl
203: , OE_SERVICE_UTIL.g_old_line_tbl
204: , OE_SERVICE_UTIL.g_line_adj_tbl
205: , OE_SERVICE_UTIL.g_old_line_adj_tbl
206: , OE_SERVICE_UTIL.g_line_price_att_tbl
207: , OE_SERVICE_UTIL.g_old_line_price_att_tbl

Line 204: , OE_SERVICE_UTIL.g_line_adj_tbl

200: , OE_SERVICE_UTIL.g_header_scredit_tbl
201: , OE_SERVICE_UTIL.g_old_header_scredit_tbl
202: , OE_SERVICE_UTIL.g_line_tbl
203: , OE_SERVICE_UTIL.g_old_line_tbl
204: , OE_SERVICE_UTIL.g_line_adj_tbl
205: , OE_SERVICE_UTIL.g_old_line_adj_tbl
206: , OE_SERVICE_UTIL.g_line_price_att_tbl
207: , OE_SERVICE_UTIL.g_old_line_price_att_tbl
208: , OE_SERVICE_UTIL.g_line_adj_att_tbl

Line 205: , OE_SERVICE_UTIL.g_old_line_adj_tbl

201: , OE_SERVICE_UTIL.g_old_header_scredit_tbl
202: , OE_SERVICE_UTIL.g_line_tbl
203: , OE_SERVICE_UTIL.g_old_line_tbl
204: , OE_SERVICE_UTIL.g_line_adj_tbl
205: , OE_SERVICE_UTIL.g_old_line_adj_tbl
206: , OE_SERVICE_UTIL.g_line_price_att_tbl
207: , OE_SERVICE_UTIL.g_old_line_price_att_tbl
208: , OE_SERVICE_UTIL.g_line_adj_att_tbl
209: , OE_SERVICE_UTIL.g_old_line_adj_att_tbl

Line 206: , OE_SERVICE_UTIL.g_line_price_att_tbl

202: , OE_SERVICE_UTIL.g_line_tbl
203: , OE_SERVICE_UTIL.g_old_line_tbl
204: , OE_SERVICE_UTIL.g_line_adj_tbl
205: , OE_SERVICE_UTIL.g_old_line_adj_tbl
206: , OE_SERVICE_UTIL.g_line_price_att_tbl
207: , OE_SERVICE_UTIL.g_old_line_price_att_tbl
208: , OE_SERVICE_UTIL.g_line_adj_att_tbl
209: , OE_SERVICE_UTIL.g_old_line_adj_att_tbl
210: , OE_SERVICE_UTIL.g_line_adj_assoc_tbl

Line 207: , OE_SERVICE_UTIL.g_old_line_price_att_tbl

203: , OE_SERVICE_UTIL.g_old_line_tbl
204: , OE_SERVICE_UTIL.g_line_adj_tbl
205: , OE_SERVICE_UTIL.g_old_line_adj_tbl
206: , OE_SERVICE_UTIL.g_line_price_att_tbl
207: , OE_SERVICE_UTIL.g_old_line_price_att_tbl
208: , OE_SERVICE_UTIL.g_line_adj_att_tbl
209: , OE_SERVICE_UTIL.g_old_line_adj_att_tbl
210: , OE_SERVICE_UTIL.g_line_adj_assoc_tbl
211: , OE_SERVICE_UTIL.g_old_line_adj_assoc_tbl

Line 208: , OE_SERVICE_UTIL.g_line_adj_att_tbl

204: , OE_SERVICE_UTIL.g_line_adj_tbl
205: , OE_SERVICE_UTIL.g_old_line_adj_tbl
206: , OE_SERVICE_UTIL.g_line_price_att_tbl
207: , OE_SERVICE_UTIL.g_old_line_price_att_tbl
208: , OE_SERVICE_UTIL.g_line_adj_att_tbl
209: , OE_SERVICE_UTIL.g_old_line_adj_att_tbl
210: , OE_SERVICE_UTIL.g_line_adj_assoc_tbl
211: , OE_SERVICE_UTIL.g_old_line_adj_assoc_tbl
212: , OE_SERVICE_UTIL.g_line_scredit_tbl

Line 209: , OE_SERVICE_UTIL.g_old_line_adj_att_tbl

205: , OE_SERVICE_UTIL.g_old_line_adj_tbl
206: , OE_SERVICE_UTIL.g_line_price_att_tbl
207: , OE_SERVICE_UTIL.g_old_line_price_att_tbl
208: , OE_SERVICE_UTIL.g_line_adj_att_tbl
209: , OE_SERVICE_UTIL.g_old_line_adj_att_tbl
210: , OE_SERVICE_UTIL.g_line_adj_assoc_tbl
211: , OE_SERVICE_UTIL.g_old_line_adj_assoc_tbl
212: , OE_SERVICE_UTIL.g_line_scredit_tbl
213: , OE_SERVICE_UTIL.g_old_line_scredit_tbl

Line 210: , OE_SERVICE_UTIL.g_line_adj_assoc_tbl

206: , OE_SERVICE_UTIL.g_line_price_att_tbl
207: , OE_SERVICE_UTIL.g_old_line_price_att_tbl
208: , OE_SERVICE_UTIL.g_line_adj_att_tbl
209: , OE_SERVICE_UTIL.g_old_line_adj_att_tbl
210: , OE_SERVICE_UTIL.g_line_adj_assoc_tbl
211: , OE_SERVICE_UTIL.g_old_line_adj_assoc_tbl
212: , OE_SERVICE_UTIL.g_line_scredit_tbl
213: , OE_SERVICE_UTIL.g_old_line_scredit_tbl
214: , OE_SERVICE_UTIL.g_lot_serial_tbl

Line 211: , OE_SERVICE_UTIL.g_old_line_adj_assoc_tbl

207: , OE_SERVICE_UTIL.g_old_line_price_att_tbl
208: , OE_SERVICE_UTIL.g_line_adj_att_tbl
209: , OE_SERVICE_UTIL.g_old_line_adj_att_tbl
210: , OE_SERVICE_UTIL.g_line_adj_assoc_tbl
211: , OE_SERVICE_UTIL.g_old_line_adj_assoc_tbl
212: , OE_SERVICE_UTIL.g_line_scredit_tbl
213: , OE_SERVICE_UTIL.g_old_line_scredit_tbl
214: , OE_SERVICE_UTIL.g_lot_serial_tbl
215: , OE_SERVICE_UTIL.g_old_lot_serial_tbl

Line 212: , OE_SERVICE_UTIL.g_line_scredit_tbl

208: , OE_SERVICE_UTIL.g_line_adj_att_tbl
209: , OE_SERVICE_UTIL.g_old_line_adj_att_tbl
210: , OE_SERVICE_UTIL.g_line_adj_assoc_tbl
211: , OE_SERVICE_UTIL.g_old_line_adj_assoc_tbl
212: , OE_SERVICE_UTIL.g_line_scredit_tbl
213: , OE_SERVICE_UTIL.g_old_line_scredit_tbl
214: , OE_SERVICE_UTIL.g_lot_serial_tbl
215: , OE_SERVICE_UTIL.g_old_lot_serial_tbl
216: , OE_SERVICE_UTIL.g_action_request_tbl);

Line 213: , OE_SERVICE_UTIL.g_old_line_scredit_tbl

209: , OE_SERVICE_UTIL.g_old_line_adj_att_tbl
210: , OE_SERVICE_UTIL.g_line_adj_assoc_tbl
211: , OE_SERVICE_UTIL.g_old_line_adj_assoc_tbl
212: , OE_SERVICE_UTIL.g_line_scredit_tbl
213: , OE_SERVICE_UTIL.g_old_line_scredit_tbl
214: , OE_SERVICE_UTIL.g_lot_serial_tbl
215: , OE_SERVICE_UTIL.g_old_lot_serial_tbl
216: , OE_SERVICE_UTIL.g_action_request_tbl);
217: END;';

Line 214: , OE_SERVICE_UTIL.g_lot_serial_tbl

210: , OE_SERVICE_UTIL.g_line_adj_assoc_tbl
211: , OE_SERVICE_UTIL.g_old_line_adj_assoc_tbl
212: , OE_SERVICE_UTIL.g_line_scredit_tbl
213: , OE_SERVICE_UTIL.g_old_line_scredit_tbl
214: , OE_SERVICE_UTIL.g_lot_serial_tbl
215: , OE_SERVICE_UTIL.g_old_lot_serial_tbl
216: , OE_SERVICE_UTIL.g_action_request_tbl);
217: END;';
218:

Line 215: , OE_SERVICE_UTIL.g_old_lot_serial_tbl

211: , OE_SERVICE_UTIL.g_old_line_adj_assoc_tbl
212: , OE_SERVICE_UTIL.g_line_scredit_tbl
213: , OE_SERVICE_UTIL.g_old_line_scredit_tbl
214: , OE_SERVICE_UTIL.g_lot_serial_tbl
215: , OE_SERVICE_UTIL.g_old_lot_serial_tbl
216: , OE_SERVICE_UTIL.g_action_request_tbl);
217: END;';
218:
219:

Line 216: , OE_SERVICE_UTIL.g_action_request_tbl);

212: , OE_SERVICE_UTIL.g_line_scredit_tbl
213: , OE_SERVICE_UTIL.g_old_line_scredit_tbl
214: , OE_SERVICE_UTIL.g_lot_serial_tbl
215: , OE_SERVICE_UTIL.g_old_lot_serial_tbl
216: , OE_SERVICE_UTIL.g_action_request_tbl);
217: END;';
218:
219:
220: EXECUTE IMMEDIATE l_sql_stat

Line 233: OE_SERVICE_UTIL.g_Header_Rec := p_Header_Rec;

229: */
230: -- Bug 5603656
231: -- Moved the code to the else part
232: -- Assign the value of the passed parameters to the Global variable
233: OE_SERVICE_UTIL.g_Header_Rec := p_Header_Rec;
234: OE_SERVICE_UTIL.g_old_header_rec := p_old_header_rec ;
235: OE_SERVICE_UTIL.g_Header_Adj_tbl := p_Header_Adj_tbl;
236: OE_SERVICE_UTIL.g_old_Header_Adj_tbl := p_old_Header_Adj_tbl;
237:

Line 234: OE_SERVICE_UTIL.g_old_header_rec := p_old_header_rec ;

230: -- Bug 5603656
231: -- Moved the code to the else part
232: -- Assign the value of the passed parameters to the Global variable
233: OE_SERVICE_UTIL.g_Header_Rec := p_Header_Rec;
234: OE_SERVICE_UTIL.g_old_header_rec := p_old_header_rec ;
235: OE_SERVICE_UTIL.g_Header_Adj_tbl := p_Header_Adj_tbl;
236: OE_SERVICE_UTIL.g_old_Header_Adj_tbl := p_old_Header_Adj_tbl;
237:
238: /* Notification Project changes */

Line 235: OE_SERVICE_UTIL.g_Header_Adj_tbl := p_Header_Adj_tbl;

231: -- Moved the code to the else part
232: -- Assign the value of the passed parameters to the Global variable
233: OE_SERVICE_UTIL.g_Header_Rec := p_Header_Rec;
234: OE_SERVICE_UTIL.g_old_header_rec := p_old_header_rec ;
235: OE_SERVICE_UTIL.g_Header_Adj_tbl := p_Header_Adj_tbl;
236: OE_SERVICE_UTIL.g_old_Header_Adj_tbl := p_old_Header_Adj_tbl;
237:
238: /* Notification Project changes */
239: /* Comment out nocopy the calls to entities that are not used by the subscriber */

Line 236: OE_SERVICE_UTIL.g_old_Header_Adj_tbl := p_old_Header_Adj_tbl;

232: -- Assign the value of the passed parameters to the Global variable
233: OE_SERVICE_UTIL.g_Header_Rec := p_Header_Rec;
234: OE_SERVICE_UTIL.g_old_header_rec := p_old_header_rec ;
235: OE_SERVICE_UTIL.g_Header_Adj_tbl := p_Header_Adj_tbl;
236: OE_SERVICE_UTIL.g_old_Header_Adj_tbl := p_old_Header_Adj_tbl;
237:
238: /* Notification Project changes */
239: /* Comment out nocopy the calls to entities that are not used by the subscriber */
240:

Line 242: -- OE_SERVICE_UTIL.g_Header_Price_Att_tbl := p_Header_Price_Att_tbl;

238: /* Notification Project changes */
239: /* Comment out nocopy the calls to entities that are not used by the subscriber */
240:
241:
242: -- OE_SERVICE_UTIL.g_Header_Price_Att_tbl := p_Header_Price_Att_tbl;
243: -- OE_SERVICE_UTIL.g_old_Header_Price_Att_tbl := p_old_Header_Price_Att_tbl;
244: -- OE_SERVICE_UTIL.g_Header_Adj_Att_tbl := p_Header_Adj_Att_tbl;
245: -- OE_SERVICE_UTIL.g_old_Header_Adj_Att_tbl := p_old_Header_Adj_Att_tbl;
246: -- OE_SERVICE_UTIL.g_Header_Adj_Assoc_tbl := p_Header_Adj_Assoc_tbl;

Line 243: -- OE_SERVICE_UTIL.g_old_Header_Price_Att_tbl := p_old_Header_Price_Att_tbl;

239: /* Comment out nocopy the calls to entities that are not used by the subscriber */
240:
241:
242: -- OE_SERVICE_UTIL.g_Header_Price_Att_tbl := p_Header_Price_Att_tbl;
243: -- OE_SERVICE_UTIL.g_old_Header_Price_Att_tbl := p_old_Header_Price_Att_tbl;
244: -- OE_SERVICE_UTIL.g_Header_Adj_Att_tbl := p_Header_Adj_Att_tbl;
245: -- OE_SERVICE_UTIL.g_old_Header_Adj_Att_tbl := p_old_Header_Adj_Att_tbl;
246: -- OE_SERVICE_UTIL.g_Header_Adj_Assoc_tbl := p_Header_Adj_Assoc_tbl;
247: -- OE_SERVICE_UTIL.g_old_Header_Adj_Assoc_tbl := p_old_Header_Adj_Assoc_tbl;

Line 244: -- OE_SERVICE_UTIL.g_Header_Adj_Att_tbl := p_Header_Adj_Att_tbl;

240:
241:
242: -- OE_SERVICE_UTIL.g_Header_Price_Att_tbl := p_Header_Price_Att_tbl;
243: -- OE_SERVICE_UTIL.g_old_Header_Price_Att_tbl := p_old_Header_Price_Att_tbl;
244: -- OE_SERVICE_UTIL.g_Header_Adj_Att_tbl := p_Header_Adj_Att_tbl;
245: -- OE_SERVICE_UTIL.g_old_Header_Adj_Att_tbl := p_old_Header_Adj_Att_tbl;
246: -- OE_SERVICE_UTIL.g_Header_Adj_Assoc_tbl := p_Header_Adj_Assoc_tbl;
247: -- OE_SERVICE_UTIL.g_old_Header_Adj_Assoc_tbl := p_old_Header_Adj_Assoc_tbl;
248: OE_SERVICE_UTIL.g_Header_Scredit_tbl := p_Header_Scredit_tbl;

Line 245: -- OE_SERVICE_UTIL.g_old_Header_Adj_Att_tbl := p_old_Header_Adj_Att_tbl;

241:
242: -- OE_SERVICE_UTIL.g_Header_Price_Att_tbl := p_Header_Price_Att_tbl;
243: -- OE_SERVICE_UTIL.g_old_Header_Price_Att_tbl := p_old_Header_Price_Att_tbl;
244: -- OE_SERVICE_UTIL.g_Header_Adj_Att_tbl := p_Header_Adj_Att_tbl;
245: -- OE_SERVICE_UTIL.g_old_Header_Adj_Att_tbl := p_old_Header_Adj_Att_tbl;
246: -- OE_SERVICE_UTIL.g_Header_Adj_Assoc_tbl := p_Header_Adj_Assoc_tbl;
247: -- OE_SERVICE_UTIL.g_old_Header_Adj_Assoc_tbl := p_old_Header_Adj_Assoc_tbl;
248: OE_SERVICE_UTIL.g_Header_Scredit_tbl := p_Header_Scredit_tbl;
249: OE_SERVICE_UTIL.g_old_Header_Scredit_tbl := p_old_Header_Scredit_tbl;

Line 246: -- OE_SERVICE_UTIL.g_Header_Adj_Assoc_tbl := p_Header_Adj_Assoc_tbl;

242: -- OE_SERVICE_UTIL.g_Header_Price_Att_tbl := p_Header_Price_Att_tbl;
243: -- OE_SERVICE_UTIL.g_old_Header_Price_Att_tbl := p_old_Header_Price_Att_tbl;
244: -- OE_SERVICE_UTIL.g_Header_Adj_Att_tbl := p_Header_Adj_Att_tbl;
245: -- OE_SERVICE_UTIL.g_old_Header_Adj_Att_tbl := p_old_Header_Adj_Att_tbl;
246: -- OE_SERVICE_UTIL.g_Header_Adj_Assoc_tbl := p_Header_Adj_Assoc_tbl;
247: -- OE_SERVICE_UTIL.g_old_Header_Adj_Assoc_tbl := p_old_Header_Adj_Assoc_tbl;
248: OE_SERVICE_UTIL.g_Header_Scredit_tbl := p_Header_Scredit_tbl;
249: OE_SERVICE_UTIL.g_old_Header_Scredit_tbl := p_old_Header_Scredit_tbl;
250: OE_SERVICE_UTIL.g_line_tbl := p_line_tbl;

Line 247: -- OE_SERVICE_UTIL.g_old_Header_Adj_Assoc_tbl := p_old_Header_Adj_Assoc_tbl;

243: -- OE_SERVICE_UTIL.g_old_Header_Price_Att_tbl := p_old_Header_Price_Att_tbl;
244: -- OE_SERVICE_UTIL.g_Header_Adj_Att_tbl := p_Header_Adj_Att_tbl;
245: -- OE_SERVICE_UTIL.g_old_Header_Adj_Att_tbl := p_old_Header_Adj_Att_tbl;
246: -- OE_SERVICE_UTIL.g_Header_Adj_Assoc_tbl := p_Header_Adj_Assoc_tbl;
247: -- OE_SERVICE_UTIL.g_old_Header_Adj_Assoc_tbl := p_old_Header_Adj_Assoc_tbl;
248: OE_SERVICE_UTIL.g_Header_Scredit_tbl := p_Header_Scredit_tbl;
249: OE_SERVICE_UTIL.g_old_Header_Scredit_tbl := p_old_Header_Scredit_tbl;
250: OE_SERVICE_UTIL.g_line_tbl := p_line_tbl;
251: OE_SERVICE_UTIL.g_old_line_tbl := p_old_line_tbl;

Line 248: OE_SERVICE_UTIL.g_Header_Scredit_tbl := p_Header_Scredit_tbl;

244: -- OE_SERVICE_UTIL.g_Header_Adj_Att_tbl := p_Header_Adj_Att_tbl;
245: -- OE_SERVICE_UTIL.g_old_Header_Adj_Att_tbl := p_old_Header_Adj_Att_tbl;
246: -- OE_SERVICE_UTIL.g_Header_Adj_Assoc_tbl := p_Header_Adj_Assoc_tbl;
247: -- OE_SERVICE_UTIL.g_old_Header_Adj_Assoc_tbl := p_old_Header_Adj_Assoc_tbl;
248: OE_SERVICE_UTIL.g_Header_Scredit_tbl := p_Header_Scredit_tbl;
249: OE_SERVICE_UTIL.g_old_Header_Scredit_tbl := p_old_Header_Scredit_tbl;
250: OE_SERVICE_UTIL.g_line_tbl := p_line_tbl;
251: OE_SERVICE_UTIL.g_old_line_tbl := p_old_line_tbl;
252: OE_SERVICE_UTIL.g_Line_Adj_tbl := p_Line_Adj_tbl;

Line 249: OE_SERVICE_UTIL.g_old_Header_Scredit_tbl := p_old_Header_Scredit_tbl;

245: -- OE_SERVICE_UTIL.g_old_Header_Adj_Att_tbl := p_old_Header_Adj_Att_tbl;
246: -- OE_SERVICE_UTIL.g_Header_Adj_Assoc_tbl := p_Header_Adj_Assoc_tbl;
247: -- OE_SERVICE_UTIL.g_old_Header_Adj_Assoc_tbl := p_old_Header_Adj_Assoc_tbl;
248: OE_SERVICE_UTIL.g_Header_Scredit_tbl := p_Header_Scredit_tbl;
249: OE_SERVICE_UTIL.g_old_Header_Scredit_tbl := p_old_Header_Scredit_tbl;
250: OE_SERVICE_UTIL.g_line_tbl := p_line_tbl;
251: OE_SERVICE_UTIL.g_old_line_tbl := p_old_line_tbl;
252: OE_SERVICE_UTIL.g_Line_Adj_tbl := p_Line_Adj_tbl;
253: OE_SERVICE_UTIL.g_old_Line_Adj_tbl := p_old_Line_Adj_tbl;

Line 250: OE_SERVICE_UTIL.g_line_tbl := p_line_tbl;

246: -- OE_SERVICE_UTIL.g_Header_Adj_Assoc_tbl := p_Header_Adj_Assoc_tbl;
247: -- OE_SERVICE_UTIL.g_old_Header_Adj_Assoc_tbl := p_old_Header_Adj_Assoc_tbl;
248: OE_SERVICE_UTIL.g_Header_Scredit_tbl := p_Header_Scredit_tbl;
249: OE_SERVICE_UTIL.g_old_Header_Scredit_tbl := p_old_Header_Scredit_tbl;
250: OE_SERVICE_UTIL.g_line_tbl := p_line_tbl;
251: OE_SERVICE_UTIL.g_old_line_tbl := p_old_line_tbl;
252: OE_SERVICE_UTIL.g_Line_Adj_tbl := p_Line_Adj_tbl;
253: OE_SERVICE_UTIL.g_old_Line_Adj_tbl := p_old_Line_Adj_tbl;
254: -- OE_SERVICE_UTIL.g_Line_Price_Att_tbl := p_Line_Price_Att_tbl;

Line 251: OE_SERVICE_UTIL.g_old_line_tbl := p_old_line_tbl;

247: -- OE_SERVICE_UTIL.g_old_Header_Adj_Assoc_tbl := p_old_Header_Adj_Assoc_tbl;
248: OE_SERVICE_UTIL.g_Header_Scredit_tbl := p_Header_Scredit_tbl;
249: OE_SERVICE_UTIL.g_old_Header_Scredit_tbl := p_old_Header_Scredit_tbl;
250: OE_SERVICE_UTIL.g_line_tbl := p_line_tbl;
251: OE_SERVICE_UTIL.g_old_line_tbl := p_old_line_tbl;
252: OE_SERVICE_UTIL.g_Line_Adj_tbl := p_Line_Adj_tbl;
253: OE_SERVICE_UTIL.g_old_Line_Adj_tbl := p_old_Line_Adj_tbl;
254: -- OE_SERVICE_UTIL.g_Line_Price_Att_tbl := p_Line_Price_Att_tbl;
255: -- OE_SERVICE_UTIL.g_old_Line_Price_Att_tbl := p_old_Line_Price_Att_tbl;

Line 252: OE_SERVICE_UTIL.g_Line_Adj_tbl := p_Line_Adj_tbl;

248: OE_SERVICE_UTIL.g_Header_Scredit_tbl := p_Header_Scredit_tbl;
249: OE_SERVICE_UTIL.g_old_Header_Scredit_tbl := p_old_Header_Scredit_tbl;
250: OE_SERVICE_UTIL.g_line_tbl := p_line_tbl;
251: OE_SERVICE_UTIL.g_old_line_tbl := p_old_line_tbl;
252: OE_SERVICE_UTIL.g_Line_Adj_tbl := p_Line_Adj_tbl;
253: OE_SERVICE_UTIL.g_old_Line_Adj_tbl := p_old_Line_Adj_tbl;
254: -- OE_SERVICE_UTIL.g_Line_Price_Att_tbl := p_Line_Price_Att_tbl;
255: -- OE_SERVICE_UTIL.g_old_Line_Price_Att_tbl := p_old_Line_Price_Att_tbl;
256: -- OE_SERVICE_UTIL.g_Line_Adj_Att_tbl := p_Line_Adj_Att_tbl;

Line 253: OE_SERVICE_UTIL.g_old_Line_Adj_tbl := p_old_Line_Adj_tbl;

249: OE_SERVICE_UTIL.g_old_Header_Scredit_tbl := p_old_Header_Scredit_tbl;
250: OE_SERVICE_UTIL.g_line_tbl := p_line_tbl;
251: OE_SERVICE_UTIL.g_old_line_tbl := p_old_line_tbl;
252: OE_SERVICE_UTIL.g_Line_Adj_tbl := p_Line_Adj_tbl;
253: OE_SERVICE_UTIL.g_old_Line_Adj_tbl := p_old_Line_Adj_tbl;
254: -- OE_SERVICE_UTIL.g_Line_Price_Att_tbl := p_Line_Price_Att_tbl;
255: -- OE_SERVICE_UTIL.g_old_Line_Price_Att_tbl := p_old_Line_Price_Att_tbl;
256: -- OE_SERVICE_UTIL.g_Line_Adj_Att_tbl := p_Line_Adj_Att_tbl;
257: -- OE_SERVICE_UTIL.g_old_Line_Adj_Att_tbl := p_old_Line_Adj_Att_tbl;

Line 254: -- OE_SERVICE_UTIL.g_Line_Price_Att_tbl := p_Line_Price_Att_tbl;

250: OE_SERVICE_UTIL.g_line_tbl := p_line_tbl;
251: OE_SERVICE_UTIL.g_old_line_tbl := p_old_line_tbl;
252: OE_SERVICE_UTIL.g_Line_Adj_tbl := p_Line_Adj_tbl;
253: OE_SERVICE_UTIL.g_old_Line_Adj_tbl := p_old_Line_Adj_tbl;
254: -- OE_SERVICE_UTIL.g_Line_Price_Att_tbl := p_Line_Price_Att_tbl;
255: -- OE_SERVICE_UTIL.g_old_Line_Price_Att_tbl := p_old_Line_Price_Att_tbl;
256: -- OE_SERVICE_UTIL.g_Line_Adj_Att_tbl := p_Line_Adj_Att_tbl;
257: -- OE_SERVICE_UTIL.g_old_Line_Adj_Att_tbl := p_old_Line_Adj_Att_tbl;
258: -- OE_SERVICE_UTIL.g_Line_Adj_Assoc_tbl := p_Line_Adj_Assoc_tbl;

Line 255: -- OE_SERVICE_UTIL.g_old_Line_Price_Att_tbl := p_old_Line_Price_Att_tbl;

251: OE_SERVICE_UTIL.g_old_line_tbl := p_old_line_tbl;
252: OE_SERVICE_UTIL.g_Line_Adj_tbl := p_Line_Adj_tbl;
253: OE_SERVICE_UTIL.g_old_Line_Adj_tbl := p_old_Line_Adj_tbl;
254: -- OE_SERVICE_UTIL.g_Line_Price_Att_tbl := p_Line_Price_Att_tbl;
255: -- OE_SERVICE_UTIL.g_old_Line_Price_Att_tbl := p_old_Line_Price_Att_tbl;
256: -- OE_SERVICE_UTIL.g_Line_Adj_Att_tbl := p_Line_Adj_Att_tbl;
257: -- OE_SERVICE_UTIL.g_old_Line_Adj_Att_tbl := p_old_Line_Adj_Att_tbl;
258: -- OE_SERVICE_UTIL.g_Line_Adj_Assoc_tbl := p_Line_Adj_Assoc_tbl;
259: -- OE_SERVICE_UTIL.g_old_Line_Adj_Assoc_tbl := p_old_Line_Adj_Assoc_tbl;

Line 256: -- OE_SERVICE_UTIL.g_Line_Adj_Att_tbl := p_Line_Adj_Att_tbl;

252: OE_SERVICE_UTIL.g_Line_Adj_tbl := p_Line_Adj_tbl;
253: OE_SERVICE_UTIL.g_old_Line_Adj_tbl := p_old_Line_Adj_tbl;
254: -- OE_SERVICE_UTIL.g_Line_Price_Att_tbl := p_Line_Price_Att_tbl;
255: -- OE_SERVICE_UTIL.g_old_Line_Price_Att_tbl := p_old_Line_Price_Att_tbl;
256: -- OE_SERVICE_UTIL.g_Line_Adj_Att_tbl := p_Line_Adj_Att_tbl;
257: -- OE_SERVICE_UTIL.g_old_Line_Adj_Att_tbl := p_old_Line_Adj_Att_tbl;
258: -- OE_SERVICE_UTIL.g_Line_Adj_Assoc_tbl := p_Line_Adj_Assoc_tbl;
259: -- OE_SERVICE_UTIL.g_old_Line_Adj_Assoc_tbl := p_old_Line_Adj_Assoc_tbl;
260: OE_SERVICE_UTIL.g_Line_Scredit_tbl := p_Line_Scredit_tbl;

Line 257: -- OE_SERVICE_UTIL.g_old_Line_Adj_Att_tbl := p_old_Line_Adj_Att_tbl;

253: OE_SERVICE_UTIL.g_old_Line_Adj_tbl := p_old_Line_Adj_tbl;
254: -- OE_SERVICE_UTIL.g_Line_Price_Att_tbl := p_Line_Price_Att_tbl;
255: -- OE_SERVICE_UTIL.g_old_Line_Price_Att_tbl := p_old_Line_Price_Att_tbl;
256: -- OE_SERVICE_UTIL.g_Line_Adj_Att_tbl := p_Line_Adj_Att_tbl;
257: -- OE_SERVICE_UTIL.g_old_Line_Adj_Att_tbl := p_old_Line_Adj_Att_tbl;
258: -- OE_SERVICE_UTIL.g_Line_Adj_Assoc_tbl := p_Line_Adj_Assoc_tbl;
259: -- OE_SERVICE_UTIL.g_old_Line_Adj_Assoc_tbl := p_old_Line_Adj_Assoc_tbl;
260: OE_SERVICE_UTIL.g_Line_Scredit_tbl := p_Line_Scredit_tbl;
261: OE_SERVICE_UTIL.g_old_Line_Scredit_tbl := p_old_Line_Scredit_tbl;

Line 258: -- OE_SERVICE_UTIL.g_Line_Adj_Assoc_tbl := p_Line_Adj_Assoc_tbl;

254: -- OE_SERVICE_UTIL.g_Line_Price_Att_tbl := p_Line_Price_Att_tbl;
255: -- OE_SERVICE_UTIL.g_old_Line_Price_Att_tbl := p_old_Line_Price_Att_tbl;
256: -- OE_SERVICE_UTIL.g_Line_Adj_Att_tbl := p_Line_Adj_Att_tbl;
257: -- OE_SERVICE_UTIL.g_old_Line_Adj_Att_tbl := p_old_Line_Adj_Att_tbl;
258: -- OE_SERVICE_UTIL.g_Line_Adj_Assoc_tbl := p_Line_Adj_Assoc_tbl;
259: -- OE_SERVICE_UTIL.g_old_Line_Adj_Assoc_tbl := p_old_Line_Adj_Assoc_tbl;
260: OE_SERVICE_UTIL.g_Line_Scredit_tbl := p_Line_Scredit_tbl;
261: OE_SERVICE_UTIL.g_old_Line_Scredit_tbl := p_old_Line_Scredit_tbl;
262: OE_SERVICE_UTIL.g_Lot_Serial_tbl := p_Lot_Serial_tbl;

Line 259: -- OE_SERVICE_UTIL.g_old_Line_Adj_Assoc_tbl := p_old_Line_Adj_Assoc_tbl;

255: -- OE_SERVICE_UTIL.g_old_Line_Price_Att_tbl := p_old_Line_Price_Att_tbl;
256: -- OE_SERVICE_UTIL.g_Line_Adj_Att_tbl := p_Line_Adj_Att_tbl;
257: -- OE_SERVICE_UTIL.g_old_Line_Adj_Att_tbl := p_old_Line_Adj_Att_tbl;
258: -- OE_SERVICE_UTIL.g_Line_Adj_Assoc_tbl := p_Line_Adj_Assoc_tbl;
259: -- OE_SERVICE_UTIL.g_old_Line_Adj_Assoc_tbl := p_old_Line_Adj_Assoc_tbl;
260: OE_SERVICE_UTIL.g_Line_Scredit_tbl := p_Line_Scredit_tbl;
261: OE_SERVICE_UTIL.g_old_Line_Scredit_tbl := p_old_Line_Scredit_tbl;
262: OE_SERVICE_UTIL.g_Lot_Serial_tbl := p_Lot_Serial_tbl;
263: OE_SERVICE_UTIL.g_old_Lot_Serial_tbl := p_old_Lot_Serial_tbl;

Line 260: OE_SERVICE_UTIL.g_Line_Scredit_tbl := p_Line_Scredit_tbl;

256: -- OE_SERVICE_UTIL.g_Line_Adj_Att_tbl := p_Line_Adj_Att_tbl;
257: -- OE_SERVICE_UTIL.g_old_Line_Adj_Att_tbl := p_old_Line_Adj_Att_tbl;
258: -- OE_SERVICE_UTIL.g_Line_Adj_Assoc_tbl := p_Line_Adj_Assoc_tbl;
259: -- OE_SERVICE_UTIL.g_old_Line_Adj_Assoc_tbl := p_old_Line_Adj_Assoc_tbl;
260: OE_SERVICE_UTIL.g_Line_Scredit_tbl := p_Line_Scredit_tbl;
261: OE_SERVICE_UTIL.g_old_Line_Scredit_tbl := p_old_Line_Scredit_tbl;
262: OE_SERVICE_UTIL.g_Lot_Serial_tbl := p_Lot_Serial_tbl;
263: OE_SERVICE_UTIL.g_old_Lot_Serial_tbl := p_old_Lot_Serial_tbl;
264: -- OE_SERVICE_UTIL.g_Lot_Serial_val_tbl := p_Lot_Serial_val_tbl;

Line 261: OE_SERVICE_UTIL.g_old_Line_Scredit_tbl := p_old_Line_Scredit_tbl;

257: -- OE_SERVICE_UTIL.g_old_Line_Adj_Att_tbl := p_old_Line_Adj_Att_tbl;
258: -- OE_SERVICE_UTIL.g_Line_Adj_Assoc_tbl := p_Line_Adj_Assoc_tbl;
259: -- OE_SERVICE_UTIL.g_old_Line_Adj_Assoc_tbl := p_old_Line_Adj_Assoc_tbl;
260: OE_SERVICE_UTIL.g_Line_Scredit_tbl := p_Line_Scredit_tbl;
261: OE_SERVICE_UTIL.g_old_Line_Scredit_tbl := p_old_Line_Scredit_tbl;
262: OE_SERVICE_UTIL.g_Lot_Serial_tbl := p_Lot_Serial_tbl;
263: OE_SERVICE_UTIL.g_old_Lot_Serial_tbl := p_old_Lot_Serial_tbl;
264: -- OE_SERVICE_UTIL.g_Lot_Serial_val_tbl := p_Lot_Serial_val_tbl;
265: -- OE_SERVICE_UTIL.g_old_Lot_Serial_val_tbl := p_old_Lot_Serial_val_tbl;

Line 262: OE_SERVICE_UTIL.g_Lot_Serial_tbl := p_Lot_Serial_tbl;

258: -- OE_SERVICE_UTIL.g_Line_Adj_Assoc_tbl := p_Line_Adj_Assoc_tbl;
259: -- OE_SERVICE_UTIL.g_old_Line_Adj_Assoc_tbl := p_old_Line_Adj_Assoc_tbl;
260: OE_SERVICE_UTIL.g_Line_Scredit_tbl := p_Line_Scredit_tbl;
261: OE_SERVICE_UTIL.g_old_Line_Scredit_tbl := p_old_Line_Scredit_tbl;
262: OE_SERVICE_UTIL.g_Lot_Serial_tbl := p_Lot_Serial_tbl;
263: OE_SERVICE_UTIL.g_old_Lot_Serial_tbl := p_old_Lot_Serial_tbl;
264: -- OE_SERVICE_UTIL.g_Lot_Serial_val_tbl := p_Lot_Serial_val_tbl;
265: -- OE_SERVICE_UTIL.g_old_Lot_Serial_val_tbl := p_old_Lot_Serial_val_tbl;
266: OE_SERVICE_UTIL.g_action_request_tbl := p_action_request_tbl;

Line 263: OE_SERVICE_UTIL.g_old_Lot_Serial_tbl := p_old_Lot_Serial_tbl;

259: -- OE_SERVICE_UTIL.g_old_Line_Adj_Assoc_tbl := p_old_Line_Adj_Assoc_tbl;
260: OE_SERVICE_UTIL.g_Line_Scredit_tbl := p_Line_Scredit_tbl;
261: OE_SERVICE_UTIL.g_old_Line_Scredit_tbl := p_old_Line_Scredit_tbl;
262: OE_SERVICE_UTIL.g_Lot_Serial_tbl := p_Lot_Serial_tbl;
263: OE_SERVICE_UTIL.g_old_Lot_Serial_tbl := p_old_Lot_Serial_tbl;
264: -- OE_SERVICE_UTIL.g_Lot_Serial_val_tbl := p_Lot_Serial_val_tbl;
265: -- OE_SERVICE_UTIL.g_old_Lot_Serial_val_tbl := p_old_Lot_Serial_val_tbl;
266: OE_SERVICE_UTIL.g_action_request_tbl := p_action_request_tbl;
267:

Line 264: -- OE_SERVICE_UTIL.g_Lot_Serial_val_tbl := p_Lot_Serial_val_tbl;

260: OE_SERVICE_UTIL.g_Line_Scredit_tbl := p_Line_Scredit_tbl;
261: OE_SERVICE_UTIL.g_old_Line_Scredit_tbl := p_old_Line_Scredit_tbl;
262: OE_SERVICE_UTIL.g_Lot_Serial_tbl := p_Lot_Serial_tbl;
263: OE_SERVICE_UTIL.g_old_Lot_Serial_tbl := p_old_Lot_Serial_tbl;
264: -- OE_SERVICE_UTIL.g_Lot_Serial_val_tbl := p_Lot_Serial_val_tbl;
265: -- OE_SERVICE_UTIL.g_old_Lot_Serial_val_tbl := p_old_Lot_Serial_val_tbl;
266: OE_SERVICE_UTIL.g_action_request_tbl := p_action_request_tbl;
267:
268:

Line 265: -- OE_SERVICE_UTIL.g_old_Lot_Serial_val_tbl := p_old_Lot_Serial_val_tbl;

261: OE_SERVICE_UTIL.g_old_Line_Scredit_tbl := p_old_Line_Scredit_tbl;
262: OE_SERVICE_UTIL.g_Lot_Serial_tbl := p_Lot_Serial_tbl;
263: OE_SERVICE_UTIL.g_old_Lot_Serial_tbl := p_old_Lot_Serial_tbl;
264: -- OE_SERVICE_UTIL.g_Lot_Serial_val_tbl := p_Lot_Serial_val_tbl;
265: -- OE_SERVICE_UTIL.g_old_Lot_Serial_val_tbl := p_old_Lot_Serial_val_tbl;
266: OE_SERVICE_UTIL.g_action_request_tbl := p_action_request_tbl;
267:
268:
269: IF l_debug_level > 0 THEN

Line 266: OE_SERVICE_UTIL.g_action_request_tbl := p_action_request_tbl;

262: OE_SERVICE_UTIL.g_Lot_Serial_tbl := p_Lot_Serial_tbl;
263: OE_SERVICE_UTIL.g_old_Lot_Serial_tbl := p_old_Lot_Serial_tbl;
264: -- OE_SERVICE_UTIL.g_Lot_Serial_val_tbl := p_Lot_Serial_val_tbl;
265: -- OE_SERVICE_UTIL.g_old_Lot_Serial_val_tbl := p_old_Lot_Serial_val_tbl;
266: OE_SERVICE_UTIL.g_action_request_tbl := p_action_request_tbl;
267:
268:
269: IF l_debug_level > 0 THEN
270: oe_debug_pub.add( 'CSS: BEFORE CALLS UPDATE_NOTICE ' ) ;

Line 280: , p_header_rec => OE_SERVICE_UTIL.g_header_rec

276: , p_commit => l_commit
277: , x_return_status => l_return_status
278: , x_msg_count => l_msg_count
279: , x_msg_data => l_msg_data
280: , p_header_rec => OE_SERVICE_UTIL.g_header_rec
281: , p_old_header_rec => OE_SERVICE_UTIL.g_old_header_rec
282: , p_Header_Adj_tbl => OE_SERVICE_UTIL.g_header_adj_tbl
283: , p_old_Header_Adj_tbl => OE_SERVICE_UTIL.g_old_header_adj_tbl
284: , p_Header_price_Att_tbl => OE_SERVICE_UTIL.g_header_price_att_tbl

Line 281: , p_old_header_rec => OE_SERVICE_UTIL.g_old_header_rec

277: , x_return_status => l_return_status
278: , x_msg_count => l_msg_count
279: , x_msg_data => l_msg_data
280: , p_header_rec => OE_SERVICE_UTIL.g_header_rec
281: , p_old_header_rec => OE_SERVICE_UTIL.g_old_header_rec
282: , p_Header_Adj_tbl => OE_SERVICE_UTIL.g_header_adj_tbl
283: , p_old_Header_Adj_tbl => OE_SERVICE_UTIL.g_old_header_adj_tbl
284: , p_Header_price_Att_tbl => OE_SERVICE_UTIL.g_header_price_att_tbl
285: , p_old_Header_Price_Att_tbl => OE_SERVICE_UTIL.g_old_header_price_att_tbl

Line 282: , p_Header_Adj_tbl => OE_SERVICE_UTIL.g_header_adj_tbl

278: , x_msg_count => l_msg_count
279: , x_msg_data => l_msg_data
280: , p_header_rec => OE_SERVICE_UTIL.g_header_rec
281: , p_old_header_rec => OE_SERVICE_UTIL.g_old_header_rec
282: , p_Header_Adj_tbl => OE_SERVICE_UTIL.g_header_adj_tbl
283: , p_old_Header_Adj_tbl => OE_SERVICE_UTIL.g_old_header_adj_tbl
284: , p_Header_price_Att_tbl => OE_SERVICE_UTIL.g_header_price_att_tbl
285: , p_old_Header_Price_Att_tbl => OE_SERVICE_UTIL.g_old_header_price_att_tbl
286: , p_Header_Adj_Att_tbl => OE_SERVICE_UTIL.g_header_adj_att_tbl

Line 283: , p_old_Header_Adj_tbl => OE_SERVICE_UTIL.g_old_header_adj_tbl

279: , x_msg_data => l_msg_data
280: , p_header_rec => OE_SERVICE_UTIL.g_header_rec
281: , p_old_header_rec => OE_SERVICE_UTIL.g_old_header_rec
282: , p_Header_Adj_tbl => OE_SERVICE_UTIL.g_header_adj_tbl
283: , p_old_Header_Adj_tbl => OE_SERVICE_UTIL.g_old_header_adj_tbl
284: , p_Header_price_Att_tbl => OE_SERVICE_UTIL.g_header_price_att_tbl
285: , p_old_Header_Price_Att_tbl => OE_SERVICE_UTIL.g_old_header_price_att_tbl
286: , p_Header_Adj_Att_tbl => OE_SERVICE_UTIL.g_header_adj_att_tbl
287: , p_old_Header_Adj_Att_tbl => OE_SERVICE_UTIL.g_old_header_adj_att_tbl

Line 284: , p_Header_price_Att_tbl => OE_SERVICE_UTIL.g_header_price_att_tbl

280: , p_header_rec => OE_SERVICE_UTIL.g_header_rec
281: , p_old_header_rec => OE_SERVICE_UTIL.g_old_header_rec
282: , p_Header_Adj_tbl => OE_SERVICE_UTIL.g_header_adj_tbl
283: , p_old_Header_Adj_tbl => OE_SERVICE_UTIL.g_old_header_adj_tbl
284: , p_Header_price_Att_tbl => OE_SERVICE_UTIL.g_header_price_att_tbl
285: , p_old_Header_Price_Att_tbl => OE_SERVICE_UTIL.g_old_header_price_att_tbl
286: , p_Header_Adj_Att_tbl => OE_SERVICE_UTIL.g_header_adj_att_tbl
287: , p_old_Header_Adj_Att_tbl => OE_SERVICE_UTIL.g_old_header_adj_att_tbl
288: , p_Header_Adj_Assoc_tbl => OE_SERVICE_UTIL.g_header_adj_assoc_tbl

Line 285: , p_old_Header_Price_Att_tbl => OE_SERVICE_UTIL.g_old_header_price_att_tbl

281: , p_old_header_rec => OE_SERVICE_UTIL.g_old_header_rec
282: , p_Header_Adj_tbl => OE_SERVICE_UTIL.g_header_adj_tbl
283: , p_old_Header_Adj_tbl => OE_SERVICE_UTIL.g_old_header_adj_tbl
284: , p_Header_price_Att_tbl => OE_SERVICE_UTIL.g_header_price_att_tbl
285: , p_old_Header_Price_Att_tbl => OE_SERVICE_UTIL.g_old_header_price_att_tbl
286: , p_Header_Adj_Att_tbl => OE_SERVICE_UTIL.g_header_adj_att_tbl
287: , p_old_Header_Adj_Att_tbl => OE_SERVICE_UTIL.g_old_header_adj_att_tbl
288: , p_Header_Adj_Assoc_tbl => OE_SERVICE_UTIL.g_header_adj_assoc_tbl
289: , p_old_Header_Adj_Assoc_tbl => OE_SERVICE_UTIL.g_old_header_adj_assoc_tbl

Line 286: , p_Header_Adj_Att_tbl => OE_SERVICE_UTIL.g_header_adj_att_tbl

282: , p_Header_Adj_tbl => OE_SERVICE_UTIL.g_header_adj_tbl
283: , p_old_Header_Adj_tbl => OE_SERVICE_UTIL.g_old_header_adj_tbl
284: , p_Header_price_Att_tbl => OE_SERVICE_UTIL.g_header_price_att_tbl
285: , p_old_Header_Price_Att_tbl => OE_SERVICE_UTIL.g_old_header_price_att_tbl
286: , p_Header_Adj_Att_tbl => OE_SERVICE_UTIL.g_header_adj_att_tbl
287: , p_old_Header_Adj_Att_tbl => OE_SERVICE_UTIL.g_old_header_adj_att_tbl
288: , p_Header_Adj_Assoc_tbl => OE_SERVICE_UTIL.g_header_adj_assoc_tbl
289: , p_old_Header_Adj_Assoc_tbl => OE_SERVICE_UTIL.g_old_header_adj_assoc_tbl
290: , p_Header_Scredit_tbl => OE_SERVICE_UTIL.g_header_scredit_tbl

Line 287: , p_old_Header_Adj_Att_tbl => OE_SERVICE_UTIL.g_old_header_adj_att_tbl

283: , p_old_Header_Adj_tbl => OE_SERVICE_UTIL.g_old_header_adj_tbl
284: , p_Header_price_Att_tbl => OE_SERVICE_UTIL.g_header_price_att_tbl
285: , p_old_Header_Price_Att_tbl => OE_SERVICE_UTIL.g_old_header_price_att_tbl
286: , p_Header_Adj_Att_tbl => OE_SERVICE_UTIL.g_header_adj_att_tbl
287: , p_old_Header_Adj_Att_tbl => OE_SERVICE_UTIL.g_old_header_adj_att_tbl
288: , p_Header_Adj_Assoc_tbl => OE_SERVICE_UTIL.g_header_adj_assoc_tbl
289: , p_old_Header_Adj_Assoc_tbl => OE_SERVICE_UTIL.g_old_header_adj_assoc_tbl
290: , p_Header_Scredit_tbl => OE_SERVICE_UTIL.g_header_scredit_tbl
291: , p_old_Header_Scredit_tbl => OE_SERVICE_UTIL.g_old_header_scredit_tbl

Line 288: , p_Header_Adj_Assoc_tbl => OE_SERVICE_UTIL.g_header_adj_assoc_tbl

284: , p_Header_price_Att_tbl => OE_SERVICE_UTIL.g_header_price_att_tbl
285: , p_old_Header_Price_Att_tbl => OE_SERVICE_UTIL.g_old_header_price_att_tbl
286: , p_Header_Adj_Att_tbl => OE_SERVICE_UTIL.g_header_adj_att_tbl
287: , p_old_Header_Adj_Att_tbl => OE_SERVICE_UTIL.g_old_header_adj_att_tbl
288: , p_Header_Adj_Assoc_tbl => OE_SERVICE_UTIL.g_header_adj_assoc_tbl
289: , p_old_Header_Adj_Assoc_tbl => OE_SERVICE_UTIL.g_old_header_adj_assoc_tbl
290: , p_Header_Scredit_tbl => OE_SERVICE_UTIL.g_header_scredit_tbl
291: , p_old_Header_Scredit_tbl => OE_SERVICE_UTIL.g_old_header_scredit_tbl
292: , p_line_tbl => OE_SERVICE_UTIL.g_line_tbl

Line 289: , p_old_Header_Adj_Assoc_tbl => OE_SERVICE_UTIL.g_old_header_adj_assoc_tbl

285: , p_old_Header_Price_Att_tbl => OE_SERVICE_UTIL.g_old_header_price_att_tbl
286: , p_Header_Adj_Att_tbl => OE_SERVICE_UTIL.g_header_adj_att_tbl
287: , p_old_Header_Adj_Att_tbl => OE_SERVICE_UTIL.g_old_header_adj_att_tbl
288: , p_Header_Adj_Assoc_tbl => OE_SERVICE_UTIL.g_header_adj_assoc_tbl
289: , p_old_Header_Adj_Assoc_tbl => OE_SERVICE_UTIL.g_old_header_adj_assoc_tbl
290: , p_Header_Scredit_tbl => OE_SERVICE_UTIL.g_header_scredit_tbl
291: , p_old_Header_Scredit_tbl => OE_SERVICE_UTIL.g_old_header_scredit_tbl
292: , p_line_tbl => OE_SERVICE_UTIL.g_line_tbl
293: , p_old_line_tbl => OE_SERVICE_UTIL.g_old_line_tbl

Line 290: , p_Header_Scredit_tbl => OE_SERVICE_UTIL.g_header_scredit_tbl

286: , p_Header_Adj_Att_tbl => OE_SERVICE_UTIL.g_header_adj_att_tbl
287: , p_old_Header_Adj_Att_tbl => OE_SERVICE_UTIL.g_old_header_adj_att_tbl
288: , p_Header_Adj_Assoc_tbl => OE_SERVICE_UTIL.g_header_adj_assoc_tbl
289: , p_old_Header_Adj_Assoc_tbl => OE_SERVICE_UTIL.g_old_header_adj_assoc_tbl
290: , p_Header_Scredit_tbl => OE_SERVICE_UTIL.g_header_scredit_tbl
291: , p_old_Header_Scredit_tbl => OE_SERVICE_UTIL.g_old_header_scredit_tbl
292: , p_line_tbl => OE_SERVICE_UTIL.g_line_tbl
293: , p_old_line_tbl => OE_SERVICE_UTIL.g_old_line_tbl
294: , p_Line_Adj_tbl => OE_SERVICE_UTIL.g_line_adj_tbl

Line 291: , p_old_Header_Scredit_tbl => OE_SERVICE_UTIL.g_old_header_scredit_tbl

287: , p_old_Header_Adj_Att_tbl => OE_SERVICE_UTIL.g_old_header_adj_att_tbl
288: , p_Header_Adj_Assoc_tbl => OE_SERVICE_UTIL.g_header_adj_assoc_tbl
289: , p_old_Header_Adj_Assoc_tbl => OE_SERVICE_UTIL.g_old_header_adj_assoc_tbl
290: , p_Header_Scredit_tbl => OE_SERVICE_UTIL.g_header_scredit_tbl
291: , p_old_Header_Scredit_tbl => OE_SERVICE_UTIL.g_old_header_scredit_tbl
292: , p_line_tbl => OE_SERVICE_UTIL.g_line_tbl
293: , p_old_line_tbl => OE_SERVICE_UTIL.g_old_line_tbl
294: , p_Line_Adj_tbl => OE_SERVICE_UTIL.g_line_adj_tbl
295: , p_old_Line_Adj_tbl => OE_SERVICE_UTIL.g_old_line_adj_tbl

Line 292: , p_line_tbl => OE_SERVICE_UTIL.g_line_tbl

288: , p_Header_Adj_Assoc_tbl => OE_SERVICE_UTIL.g_header_adj_assoc_tbl
289: , p_old_Header_Adj_Assoc_tbl => OE_SERVICE_UTIL.g_old_header_adj_assoc_tbl
290: , p_Header_Scredit_tbl => OE_SERVICE_UTIL.g_header_scredit_tbl
291: , p_old_Header_Scredit_tbl => OE_SERVICE_UTIL.g_old_header_scredit_tbl
292: , p_line_tbl => OE_SERVICE_UTIL.g_line_tbl
293: , p_old_line_tbl => OE_SERVICE_UTIL.g_old_line_tbl
294: , p_Line_Adj_tbl => OE_SERVICE_UTIL.g_line_adj_tbl
295: , p_old_Line_Adj_tbl => OE_SERVICE_UTIL.g_old_line_adj_tbl
296: , p_Line_Price_Att_tbl => OE_SERVICE_UTIL.g_line_price_att_tbl

Line 293: , p_old_line_tbl => OE_SERVICE_UTIL.g_old_line_tbl

289: , p_old_Header_Adj_Assoc_tbl => OE_SERVICE_UTIL.g_old_header_adj_assoc_tbl
290: , p_Header_Scredit_tbl => OE_SERVICE_UTIL.g_header_scredit_tbl
291: , p_old_Header_Scredit_tbl => OE_SERVICE_UTIL.g_old_header_scredit_tbl
292: , p_line_tbl => OE_SERVICE_UTIL.g_line_tbl
293: , p_old_line_tbl => OE_SERVICE_UTIL.g_old_line_tbl
294: , p_Line_Adj_tbl => OE_SERVICE_UTIL.g_line_adj_tbl
295: , p_old_Line_Adj_tbl => OE_SERVICE_UTIL.g_old_line_adj_tbl
296: , p_Line_Price_Att_tbl => OE_SERVICE_UTIL.g_line_price_att_tbl
297: , p_old_Line_Price_Att_tbl => OE_SERVICE_UTIL.g_old_line_price_att_tbl

Line 294: , p_Line_Adj_tbl => OE_SERVICE_UTIL.g_line_adj_tbl

290: , p_Header_Scredit_tbl => OE_SERVICE_UTIL.g_header_scredit_tbl
291: , p_old_Header_Scredit_tbl => OE_SERVICE_UTIL.g_old_header_scredit_tbl
292: , p_line_tbl => OE_SERVICE_UTIL.g_line_tbl
293: , p_old_line_tbl => OE_SERVICE_UTIL.g_old_line_tbl
294: , p_Line_Adj_tbl => OE_SERVICE_UTIL.g_line_adj_tbl
295: , p_old_Line_Adj_tbl => OE_SERVICE_UTIL.g_old_line_adj_tbl
296: , p_Line_Price_Att_tbl => OE_SERVICE_UTIL.g_line_price_att_tbl
297: , p_old_Line_Price_Att_tbl => OE_SERVICE_UTIL.g_old_line_price_att_tbl
298: , p_Line_Adj_Att_tbl => OE_SERVICE_UTIL.g_line_adj_att_tbl

Line 295: , p_old_Line_Adj_tbl => OE_SERVICE_UTIL.g_old_line_adj_tbl

291: , p_old_Header_Scredit_tbl => OE_SERVICE_UTIL.g_old_header_scredit_tbl
292: , p_line_tbl => OE_SERVICE_UTIL.g_line_tbl
293: , p_old_line_tbl => OE_SERVICE_UTIL.g_old_line_tbl
294: , p_Line_Adj_tbl => OE_SERVICE_UTIL.g_line_adj_tbl
295: , p_old_Line_Adj_tbl => OE_SERVICE_UTIL.g_old_line_adj_tbl
296: , p_Line_Price_Att_tbl => OE_SERVICE_UTIL.g_line_price_att_tbl
297: , p_old_Line_Price_Att_tbl => OE_SERVICE_UTIL.g_old_line_price_att_tbl
298: , p_Line_Adj_Att_tbl => OE_SERVICE_UTIL.g_line_adj_att_tbl
299: , p_old_Line_Adj_Att_tbl => OE_SERVICE_UTIL.g_old_line_adj_att_tbl

Line 296: , p_Line_Price_Att_tbl => OE_SERVICE_UTIL.g_line_price_att_tbl

292: , p_line_tbl => OE_SERVICE_UTIL.g_line_tbl
293: , p_old_line_tbl => OE_SERVICE_UTIL.g_old_line_tbl
294: , p_Line_Adj_tbl => OE_SERVICE_UTIL.g_line_adj_tbl
295: , p_old_Line_Adj_tbl => OE_SERVICE_UTIL.g_old_line_adj_tbl
296: , p_Line_Price_Att_tbl => OE_SERVICE_UTIL.g_line_price_att_tbl
297: , p_old_Line_Price_Att_tbl => OE_SERVICE_UTIL.g_old_line_price_att_tbl
298: , p_Line_Adj_Att_tbl => OE_SERVICE_UTIL.g_line_adj_att_tbl
299: , p_old_Line_Adj_Att_tbl => OE_SERVICE_UTIL.g_old_line_adj_att_tbl
300: , p_Line_Adj_Assoc_tbl => OE_SERVICE_UTIL.g_line_adj_assoc_tbl

Line 297: , p_old_Line_Price_Att_tbl => OE_SERVICE_UTIL.g_old_line_price_att_tbl

293: , p_old_line_tbl => OE_SERVICE_UTIL.g_old_line_tbl
294: , p_Line_Adj_tbl => OE_SERVICE_UTIL.g_line_adj_tbl
295: , p_old_Line_Adj_tbl => OE_SERVICE_UTIL.g_old_line_adj_tbl
296: , p_Line_Price_Att_tbl => OE_SERVICE_UTIL.g_line_price_att_tbl
297: , p_old_Line_Price_Att_tbl => OE_SERVICE_UTIL.g_old_line_price_att_tbl
298: , p_Line_Adj_Att_tbl => OE_SERVICE_UTIL.g_line_adj_att_tbl
299: , p_old_Line_Adj_Att_tbl => OE_SERVICE_UTIL.g_old_line_adj_att_tbl
300: , p_Line_Adj_Assoc_tbl => OE_SERVICE_UTIL.g_line_adj_assoc_tbl
301: , p_old_Line_Adj_Assoc_tbl => OE_SERVICE_UTIL.g_old_line_adj_assoc_tbl

Line 298: , p_Line_Adj_Att_tbl => OE_SERVICE_UTIL.g_line_adj_att_tbl

294: , p_Line_Adj_tbl => OE_SERVICE_UTIL.g_line_adj_tbl
295: , p_old_Line_Adj_tbl => OE_SERVICE_UTIL.g_old_line_adj_tbl
296: , p_Line_Price_Att_tbl => OE_SERVICE_UTIL.g_line_price_att_tbl
297: , p_old_Line_Price_Att_tbl => OE_SERVICE_UTIL.g_old_line_price_att_tbl
298: , p_Line_Adj_Att_tbl => OE_SERVICE_UTIL.g_line_adj_att_tbl
299: , p_old_Line_Adj_Att_tbl => OE_SERVICE_UTIL.g_old_line_adj_att_tbl
300: , p_Line_Adj_Assoc_tbl => OE_SERVICE_UTIL.g_line_adj_assoc_tbl
301: , p_old_Line_Adj_Assoc_tbl => OE_SERVICE_UTIL.g_old_line_adj_assoc_tbl
302: , p_Line_Scredit_tbl => OE_SERVICE_UTIL.g_line_scredit_tbl

Line 299: , p_old_Line_Adj_Att_tbl => OE_SERVICE_UTIL.g_old_line_adj_att_tbl

295: , p_old_Line_Adj_tbl => OE_SERVICE_UTIL.g_old_line_adj_tbl
296: , p_Line_Price_Att_tbl => OE_SERVICE_UTIL.g_line_price_att_tbl
297: , p_old_Line_Price_Att_tbl => OE_SERVICE_UTIL.g_old_line_price_att_tbl
298: , p_Line_Adj_Att_tbl => OE_SERVICE_UTIL.g_line_adj_att_tbl
299: , p_old_Line_Adj_Att_tbl => OE_SERVICE_UTIL.g_old_line_adj_att_tbl
300: , p_Line_Adj_Assoc_tbl => OE_SERVICE_UTIL.g_line_adj_assoc_tbl
301: , p_old_Line_Adj_Assoc_tbl => OE_SERVICE_UTIL.g_old_line_adj_assoc_tbl
302: , p_Line_Scredit_tbl => OE_SERVICE_UTIL.g_line_scredit_tbl
303: , p_old_Line_Scredit_tbl => OE_SERVICE_UTIL.g_old_line_scredit_tbl

Line 300: , p_Line_Adj_Assoc_tbl => OE_SERVICE_UTIL.g_line_adj_assoc_tbl

296: , p_Line_Price_Att_tbl => OE_SERVICE_UTIL.g_line_price_att_tbl
297: , p_old_Line_Price_Att_tbl => OE_SERVICE_UTIL.g_old_line_price_att_tbl
298: , p_Line_Adj_Att_tbl => OE_SERVICE_UTIL.g_line_adj_att_tbl
299: , p_old_Line_Adj_Att_tbl => OE_SERVICE_UTIL.g_old_line_adj_att_tbl
300: , p_Line_Adj_Assoc_tbl => OE_SERVICE_UTIL.g_line_adj_assoc_tbl
301: , p_old_Line_Adj_Assoc_tbl => OE_SERVICE_UTIL.g_old_line_adj_assoc_tbl
302: , p_Line_Scredit_tbl => OE_SERVICE_UTIL.g_line_scredit_tbl
303: , p_old_Line_Scredit_tbl => OE_SERVICE_UTIL.g_old_line_scredit_tbl
304: , p_Lot_Serial_tbl => OE_SERVICE_UTIL.g_lot_serial_tbl

Line 301: , p_old_Line_Adj_Assoc_tbl => OE_SERVICE_UTIL.g_old_line_adj_assoc_tbl

297: , p_old_Line_Price_Att_tbl => OE_SERVICE_UTIL.g_old_line_price_att_tbl
298: , p_Line_Adj_Att_tbl => OE_SERVICE_UTIL.g_line_adj_att_tbl
299: , p_old_Line_Adj_Att_tbl => OE_SERVICE_UTIL.g_old_line_adj_att_tbl
300: , p_Line_Adj_Assoc_tbl => OE_SERVICE_UTIL.g_line_adj_assoc_tbl
301: , p_old_Line_Adj_Assoc_tbl => OE_SERVICE_UTIL.g_old_line_adj_assoc_tbl
302: , p_Line_Scredit_tbl => OE_SERVICE_UTIL.g_line_scredit_tbl
303: , p_old_Line_Scredit_tbl => OE_SERVICE_UTIL.g_old_line_scredit_tbl
304: , p_Lot_Serial_tbl => OE_SERVICE_UTIL.g_lot_serial_tbl
305: , p_old_Lot_Serial_tbl => OE_SERVICE_UTIL.g_old_lot_serial_tbl

Line 302: , p_Line_Scredit_tbl => OE_SERVICE_UTIL.g_line_scredit_tbl

298: , p_Line_Adj_Att_tbl => OE_SERVICE_UTIL.g_line_adj_att_tbl
299: , p_old_Line_Adj_Att_tbl => OE_SERVICE_UTIL.g_old_line_adj_att_tbl
300: , p_Line_Adj_Assoc_tbl => OE_SERVICE_UTIL.g_line_adj_assoc_tbl
301: , p_old_Line_Adj_Assoc_tbl => OE_SERVICE_UTIL.g_old_line_adj_assoc_tbl
302: , p_Line_Scredit_tbl => OE_SERVICE_UTIL.g_line_scredit_tbl
303: , p_old_Line_Scredit_tbl => OE_SERVICE_UTIL.g_old_line_scredit_tbl
304: , p_Lot_Serial_tbl => OE_SERVICE_UTIL.g_lot_serial_tbl
305: , p_old_Lot_Serial_tbl => OE_SERVICE_UTIL.g_old_lot_serial_tbl
306: , p_action_request_tbl => OE_SERVICE_UTIL.g_action_request_tbl);

Line 303: , p_old_Line_Scredit_tbl => OE_SERVICE_UTIL.g_old_line_scredit_tbl

299: , p_old_Line_Adj_Att_tbl => OE_SERVICE_UTIL.g_old_line_adj_att_tbl
300: , p_Line_Adj_Assoc_tbl => OE_SERVICE_UTIL.g_line_adj_assoc_tbl
301: , p_old_Line_Adj_Assoc_tbl => OE_SERVICE_UTIL.g_old_line_adj_assoc_tbl
302: , p_Line_Scredit_tbl => OE_SERVICE_UTIL.g_line_scredit_tbl
303: , p_old_Line_Scredit_tbl => OE_SERVICE_UTIL.g_old_line_scredit_tbl
304: , p_Lot_Serial_tbl => OE_SERVICE_UTIL.g_lot_serial_tbl
305: , p_old_Lot_Serial_tbl => OE_SERVICE_UTIL.g_old_lot_serial_tbl
306: , p_action_request_tbl => OE_SERVICE_UTIL.g_action_request_tbl);
307:

Line 304: , p_Lot_Serial_tbl => OE_SERVICE_UTIL.g_lot_serial_tbl

300: , p_Line_Adj_Assoc_tbl => OE_SERVICE_UTIL.g_line_adj_assoc_tbl
301: , p_old_Line_Adj_Assoc_tbl => OE_SERVICE_UTIL.g_old_line_adj_assoc_tbl
302: , p_Line_Scredit_tbl => OE_SERVICE_UTIL.g_line_scredit_tbl
303: , p_old_Line_Scredit_tbl => OE_SERVICE_UTIL.g_old_line_scredit_tbl
304: , p_Lot_Serial_tbl => OE_SERVICE_UTIL.g_lot_serial_tbl
305: , p_old_Lot_Serial_tbl => OE_SERVICE_UTIL.g_old_lot_serial_tbl
306: , p_action_request_tbl => OE_SERVICE_UTIL.g_action_request_tbl);
307:
308: IF l_debug_level > 0 THEN

Line 305: , p_old_Lot_Serial_tbl => OE_SERVICE_UTIL.g_old_lot_serial_tbl

301: , p_old_Line_Adj_Assoc_tbl => OE_SERVICE_UTIL.g_old_line_adj_assoc_tbl
302: , p_Line_Scredit_tbl => OE_SERVICE_UTIL.g_line_scredit_tbl
303: , p_old_Line_Scredit_tbl => OE_SERVICE_UTIL.g_old_line_scredit_tbl
304: , p_Lot_Serial_tbl => OE_SERVICE_UTIL.g_lot_serial_tbl
305: , p_old_Lot_Serial_tbl => OE_SERVICE_UTIL.g_old_lot_serial_tbl
306: , p_action_request_tbl => OE_SERVICE_UTIL.g_action_request_tbl);
307:
308: IF l_debug_level > 0 THEN
309: oe_debug_pub.add( 'JPN: OC RETURN STATUS IS: ' || L_RETURN_STATUS ) ;

Line 306: , p_action_request_tbl => OE_SERVICE_UTIL.g_action_request_tbl);

302: , p_Line_Scredit_tbl => OE_SERVICE_UTIL.g_line_scredit_tbl
303: , p_old_Line_Scredit_tbl => OE_SERVICE_UTIL.g_old_line_scredit_tbl
304: , p_Lot_Serial_tbl => OE_SERVICE_UTIL.g_lot_serial_tbl
305: , p_old_Lot_Serial_tbl => OE_SERVICE_UTIL.g_old_lot_serial_tbl
306: , p_action_request_tbl => OE_SERVICE_UTIL.g_action_request_tbl);
307:
308: IF l_debug_level > 0 THEN
309: oe_debug_pub.add( 'JPN: OC RETURN STATUS IS: ' || L_RETURN_STATUS ) ;
310: END IF;

Line 574: /* OE_SERVICE_UTIL.CHECK_PROC('OKS_OMINT_PUB.GET_DURATION', l_return_status); */

570: x_return_status => x_return_status);
571: RETURN;
572: END IF;
573:
574: /* OE_SERVICE_UTIL.CHECK_PROC('OKS_OMINT_PUB.GET_DURATION', l_return_status); */
575:
576:
577: IF l_debug_level > 0 THEN
578: oe_debug_pub.add( 'JPN: SERVICE DURATION PASSED IS ' || P_X_LINE_REC.SERVICE_DURATION ) ;

Line 960: /* OE_SERVICE_UTIL.CHECK_PROC('OKS_OMINT_PUB.IS_SERVICE_AVAILABLE', l_return_status);

956: END IF;
957:
958: -- IF OKS_OMINT_PUB.IS_SERVICE_AVAILABLE exists in DB
959: -- Then Call it Else Not
960: /* OE_SERVICE_UTIL.CHECK_PROC('OKS_OMINT_PUB.IS_SERVICE_AVAILABLE', l_return_status);
961: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN */
962:
963: -- IF Get_Product_Status(515) IN ('I','S') THEN
964:

Line 1313: /* OE_SERVICE_UTIL.CHECK_PROC('OKS_OMINT_PUB.IS_SERVICE_AVAILABLE', l_return_status);

1309:
1310:
1311: -- IF OKS_OMINT_PUB.IS_SERVICE_AVAILABLE exists in DB
1312: -- Then Call it Else Not
1313: /* OE_SERVICE_UTIL.CHECK_PROC('OKS_OMINT_PUB.IS_SERVICE_AVAILABLE', l_return_status);
1314: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN */
1315:
1316: -- IF Get_Product_Status(515) IN ('I','S') THEN
1317:

Line 1488: /* OE_SERVICE_UTIL.CHECK_PROC('OKS_OMINT_PUB.GET_DURATION', l_return_status);

1484: oe_debug_pub.add( 'ENTERING GET_SERVICE_DURATION' ) ;
1485: END IF;
1486:
1487: x_line_rec := p_line_rec;
1488: /* OE_SERVICE_UTIL.CHECK_PROC('OKS_OMINT_PUB.GET_DURATION', l_return_status);
1489: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN */
1490:
1491: -- IF Get_Product_Status(515) IN ('I','S') THEN
1492:

Line 1660: /* OE_SERVICE_UTIL.CHECK_PROC('OKS_OMINT_PUB.IS_SERVICE_AVAILABLE', l_return_status);

1656: AND m.organization_id = to_number(OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID'));
1657:
1658: -- IF OKS_OMINT_PUB.IS_SERVICE_AVAILABLE exists in DB
1659: -- Then Call it Else Not
1660: /* OE_SERVICE_UTIL.CHECK_PROC('OKS_OMINT_PUB.IS_SERVICE_AVAILABLE', l_return_status);
1661: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN */
1662:
1663: -- IF Get_Product_Status(515) IN ('I','S') THEN
1664:

Line 1855: /* OE_SERVICE_UTIL.CHECK_PROC('OKS_OMINT_PUB.IS_SERVICE_AVAILABLE', l_return_status);

1851:
1852:
1853: -- IF OKS_OMINT_PUB.IS_SERVICE_AVAILABLE exists in DB
1854: -- Then Call it Else Not
1855: /* OE_SERVICE_UTIL.CHECK_PROC('OKS_OMINT_PUB.IS_SERVICE_AVAILABLE', l_return_status);
1856: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN */
1857:
1858: -- IF Get_Product_Status(515) IN ('I','S') THEN
1859:

Line 2412: , x_srv_cust_prod_tbl OUT NOCOPY OE_SERVICE_UTIL.SRV_CUST_PROD_TBL

2408: PROCEDURE Get_Cust_Prod_RG
2409: ( x_return_status OUT NOCOPY VARCHAR2
2410:
2411: , p_customer_id IN NUMBER
2412: , x_srv_cust_prod_tbl OUT NOCOPY OE_SERVICE_UTIL.SRV_CUST_PROD_TBL
2413:
2414: )
2415: IS
2416: Type CustProdCurTyp IS REF CURSOR;

Line 2457: OE_SERVICE_UTIL.l_srv_cust_prod_tbl.DELETE; -- 2225343 end

2453: IF l_exists = 'Y' AND -- other conditions added for 2225343
2454: (p_customer_id <> g_customer_id OR
2455: g_customer_id IS NULL) THEN
2456:
2457: OE_SERVICE_UTIL.l_srv_cust_prod_tbl.DELETE; -- 2225343 end
2458:
2459: --IF NOT (CSI_UTILITY_GRP.IB_ACTIVE()) THEN
2460: IF NOT (IB_ACTIVE()) THEN
2461: OPEN cust_cv FOR

Line 2477: OE_SERVICE_UTIL.l_srv_cust_prod_tbl(I).customer_product_id,

2473: I := 1;
2474:
2475: LOOP
2476: FETCH cust_cv INTO
2477: OE_SERVICE_UTIL.l_srv_cust_prod_tbl(I).customer_product_id,
2478: OE_SERVICE_UTIL.l_srv_cust_prod_tbl(I).product,
2479: OE_SERVICE_UTIL.l_srv_cust_prod_tbl(I).product_description,
2480: OE_SERVICE_UTIL.l_srv_cust_prod_tbl(I).reference_number,
2481: OE_SERVICE_UTIL.l_srv_cust_prod_tbl(I).current_serial_number;

Line 2478: OE_SERVICE_UTIL.l_srv_cust_prod_tbl(I).product,

2474:
2475: LOOP
2476: FETCH cust_cv INTO
2477: OE_SERVICE_UTIL.l_srv_cust_prod_tbl(I).customer_product_id,
2478: OE_SERVICE_UTIL.l_srv_cust_prod_tbl(I).product,
2479: OE_SERVICE_UTIL.l_srv_cust_prod_tbl(I).product_description,
2480: OE_SERVICE_UTIL.l_srv_cust_prod_tbl(I).reference_number,
2481: OE_SERVICE_UTIL.l_srv_cust_prod_tbl(I).current_serial_number;
2482: I := I + 1;

Line 2479: OE_SERVICE_UTIL.l_srv_cust_prod_tbl(I).product_description,

2475: LOOP
2476: FETCH cust_cv INTO
2477: OE_SERVICE_UTIL.l_srv_cust_prod_tbl(I).customer_product_id,
2478: OE_SERVICE_UTIL.l_srv_cust_prod_tbl(I).product,
2479: OE_SERVICE_UTIL.l_srv_cust_prod_tbl(I).product_description,
2480: OE_SERVICE_UTIL.l_srv_cust_prod_tbl(I).reference_number,
2481: OE_SERVICE_UTIL.l_srv_cust_prod_tbl(I).current_serial_number;
2482: I := I + 1;
2483: EXIT WHEN cust_cv%NOTFOUND;

Line 2480: OE_SERVICE_UTIL.l_srv_cust_prod_tbl(I).reference_number,

2476: FETCH cust_cv INTO
2477: OE_SERVICE_UTIL.l_srv_cust_prod_tbl(I).customer_product_id,
2478: OE_SERVICE_UTIL.l_srv_cust_prod_tbl(I).product,
2479: OE_SERVICE_UTIL.l_srv_cust_prod_tbl(I).product_description,
2480: OE_SERVICE_UTIL.l_srv_cust_prod_tbl(I).reference_number,
2481: OE_SERVICE_UTIL.l_srv_cust_prod_tbl(I).current_serial_number;
2482: I := I + 1;
2483: EXIT WHEN cust_cv%NOTFOUND;
2484: END LOOP;

Line 2481: OE_SERVICE_UTIL.l_srv_cust_prod_tbl(I).current_serial_number;

2477: OE_SERVICE_UTIL.l_srv_cust_prod_tbl(I).customer_product_id,
2478: OE_SERVICE_UTIL.l_srv_cust_prod_tbl(I).product,
2479: OE_SERVICE_UTIL.l_srv_cust_prod_tbl(I).product_description,
2480: OE_SERVICE_UTIL.l_srv_cust_prod_tbl(I).reference_number,
2481: OE_SERVICE_UTIL.l_srv_cust_prod_tbl(I).current_serial_number;
2482: I := I + 1;
2483: EXIT WHEN cust_cv%NOTFOUND;
2484: END LOOP;
2485: END IF;

Line 2486: x_srv_cust_prod_tbl := OE_SERVICE_UTIL.l_srv_cust_prod_tbl;

2482: I := I + 1;
2483: EXIT WHEN cust_cv%NOTFOUND;
2484: END LOOP;
2485: END IF;
2486: x_srv_cust_prod_tbl := OE_SERVICE_UTIL.l_srv_cust_prod_tbl;
2487: x_return_status := FND_API.G_RET_STS_SUCCESS;
2488: IF l_debug_level > 0 THEN
2489: oe_debug_pub.add( 'EXITING SUCCESS GET_CUST_PROD_RG' ) ;
2490: END IF;

Line 2504: , p_service_rec IN OE_SERVICE_UTIL.T_SERVICE_REC

2500:
2501: PROCEDURE Get_Avail_Service_RG
2502: ( x_return_status OUT NOCOPY VARCHAR2
2503:
2504: , p_service_rec IN OE_SERVICE_UTIL.T_SERVICE_REC
2505: , x_srv_cust_prod_tbl OUT NOCOPY OE_SERVICE_UTIL.SRV_ITEM_ID_TBL
2506:
2507: )
2508: IS

Line 2505: , x_srv_cust_prod_tbl OUT NOCOPY OE_SERVICE_UTIL.SRV_ITEM_ID_TBL

2501: PROCEDURE Get_Avail_Service_RG
2502: ( x_return_status OUT NOCOPY VARCHAR2
2503:
2504: , p_service_rec IN OE_SERVICE_UTIL.T_SERVICE_REC
2505: , x_srv_cust_prod_tbl OUT NOCOPY OE_SERVICE_UTIL.SRV_ITEM_ID_TBL
2506:
2507: )
2508: IS
2509: l_sql_stat VARCHAR2(500);

Line 2524: /* OE_SERVICE_UTIL.CHECK_PROC('OKS_OMINT_PUB.OKS_AVAILABLE_SERVICES', l_return_status);

2520:
2521: -- Call Describe_Proc to check for the existance of the CRM's
2522: -- AVAILABLE_SERVICES API. If exists Then Call it else No Problem.
2523:
2524: /* OE_SERVICE_UTIL.CHECK_PROC('OKS_OMINT_PUB.OKS_AVAILABLE_SERVICES', l_return_status);
2525: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN */
2526:
2527: -- IF Get_Product_Status(515) IN ('I','S') THEN
2528:

Line 2554: OE_SERVICE_UTIL.l_srv_tbl := l_service_tbl; ';

2550: , :x_return_status
2551: , l_service_rec
2552: , l_service_tbl);
2553:
2554: OE_SERVICE_UTIL.l_srv_tbl := l_service_tbl; ';
2555:
2556: IF l_debug_level > 0 THEN
2557: oe_debug_pub.add( L_SQL_STAT ) ;
2558: END IF;

Line 2678: oe_debug_pub.add( 'ENTERING OE_SERVICE_UTIL.NEW_SERVICE_LINES' , 1 ) ;

2674: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2675: BEGIN
2676:
2677: IF l_debug_level > 0 THEN
2678: oe_debug_pub.add( 'ENTERING OE_SERVICE_UTIL.NEW_SERVICE_LINES' , 1 ) ;
2679: END IF;
2680:
2681: --lchen fix bug 2027650
2682: I := p_x_line_tbl.FIRST;

Line 2706: oe_debug_pub.add( 'IN OE_SERVICE_UTIL.UPDATE_SERVICE_LINES.ENTERING OE_SERVICE_UTIL.NEW_SERVICE_LINES' , 1 ) ;

2702: ( p_x_line_tbl(i).operation = OE_GLOBALS.G_OPR_CREATE or
2703: p_x_line_tbl(i).operation= OE_GLOBALS.G_OPR_UPDATE) THEN
2704:
2705: IF l_debug_level > 0 THEN
2706: oe_debug_pub.add( 'IN OE_SERVICE_UTIL.UPDATE_SERVICE_LINES.ENTERING OE_SERVICE_UTIL.NEW_SERVICE_LINES' , 1 ) ;
2707: END IF;
2708:
2709: -- oe_debug_pub.ADD('headerId:' || l_line_rec.header_id , 1);
2710: -- oe_debug_pub.ADD('line_id:' || l_line_rec.line_id , 1);

Line 2773: oe_debug_pub.add( 'EXITING OE_SERVICE_UTIL.UPDATE_SERVICE_LINES' , 1 ) ;

2769: OE_GLOBALS.G_CASCADING_REQUEST_LOGGED := TRUE;
2770: END IF;
2771:
2772: IF l_debug_level > 0 THEN
2773: oe_debug_pub.add( 'EXITING OE_SERVICE_UTIL.UPDATE_SERVICE_LINES' , 1 ) ;
2774: END IF;
2775:
2776:
2777: EXCEPTION

Line 2851: oe_debug_pub.add( 'ENTER OE_SERVICE_UTIL.CASCADE_CHANGES' , 1 ) ;

2847: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2848: BEGIN
2849:
2850: IF l_debug_level > 0 THEN
2851: oe_debug_pub.add( 'ENTER OE_SERVICE_UTIL.CASCADE_CHANGES' , 1 ) ;
2852: END IF;
2853:
2854: IF fnd_profile.value('ONT_CASCADE_SERVICE') = 'N' THEN
2855: /* 3128684 */

Line 2942: oe_debug_pub.add( 'EXITING OE_SERVICE_UTIL.CASCADE_CHANGES' , 1 ) ;

2938: END LOOP;
2939:
2940: IF l_line_count = 0 THEN
2941: IF l_debug_level > 0 THEN
2942: oe_debug_pub.add( 'EXITING OE_SERVICE_UTIL.CASCADE_CHANGES' , 1 ) ;
2943: END IF;
2944: IF l_debug_level > 0 THEN
2945: oe_debug_pub.add( 'NO ROWS TO CASCADE' , 2 ) ;
2946: END IF;

Line 3172: oe_debug_pub.add( 'ENTERING OE_SERVICE_UTIL.UPDATE_SERVICE_OPTION_NUMBERS' , 2 ) ;

3168: l_ref_type_code CONSTANT VARCHAR2(5) := 'ORDER';
3169: BEGIN
3170:
3171: IF l_debug_level > 0 THEN
3172: oe_debug_pub.add( 'ENTERING OE_SERVICE_UTIL.UPDATE_SERVICE_OPTION_NUMBERS' , 2 ) ;
3173: END IF;
3174:
3175: OPEN option_lines;
3176: FETCH option_lines BULK COLLECT INTO l_line_ids, l_option_numbers;

Line 3191: END OE_SERVICE_UTIL;

3187: END IF;
3188:
3189: END;
3190:
3191: END OE_SERVICE_UTIL;