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.16.12020000.3 2013/03/27 11:06:32 sahvivek 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: --bug 8472737

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: --bug 8472737
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: --bug 8472737
269: IF l_debug_level > 0 THEN
270: oe_debug_pub.add( 'CSS: BEFORE CALLS UPDATE_NOTICE ',0.5 ) ; -- debug level 0.5 added for bug 13435459

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 579: /* OE_SERVICE_UTIL.CHECK_PROC('OKS_OMINT_PUB.GET_DURATION', l_return_status); */

575: x_return_status => x_return_status);
576: RETURN;
577: END IF;
578:
579: /* OE_SERVICE_UTIL.CHECK_PROC('OKS_OMINT_PUB.GET_DURATION', l_return_status); */
580:
581:
582: IF l_debug_level > 0 THEN
583: oe_debug_pub.add( 'JPN: SERVICE DURATION PASSED IS ' || P_X_LINE_REC.SERVICE_DURATION ) ;

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

970: END IF;
971:
972: -- IF OKS_OMINT_PUB.IS_SERVICE_AVAILABLE exists in DB
973: -- Then Call it Else Not
974: /* OE_SERVICE_UTIL.CHECK_PROC('OKS_OMINT_PUB.IS_SERVICE_AVAILABLE', l_return_status);
975: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN */
976:
977: -- IF Get_Product_Status(515) IN ('I','S') THEN
978:

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

1327:
1328:
1329: -- IF OKS_OMINT_PUB.IS_SERVICE_AVAILABLE exists in DB
1330: -- Then Call it Else Not
1331: /* OE_SERVICE_UTIL.CHECK_PROC('OKS_OMINT_PUB.IS_SERVICE_AVAILABLE', l_return_status);
1332: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN */
1333:
1334: -- IF Get_Product_Status(515) IN ('I','S') THEN
1335:

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

1502: oe_debug_pub.add( 'ENTERING GET_SERVICE_DURATION',0.5 ) ; -- debug level 0.5 added for bug 13435459
1503: END IF;
1504:
1505: x_line_rec := p_line_rec;
1506: /* OE_SERVICE_UTIL.CHECK_PROC('OKS_OMINT_PUB.GET_DURATION', l_return_status);
1507: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN */
1508:
1509: -- IF Get_Product_Status(515) IN ('I','S') THEN
1510:

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

1687: AND m.organization_id = to_number(OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID'));
1688:
1689: -- IF OKS_OMINT_PUB.IS_SERVICE_AVAILABLE exists in DB
1690: -- Then Call it Else Not
1691: /* OE_SERVICE_UTIL.CHECK_PROC('OKS_OMINT_PUB.IS_SERVICE_AVAILABLE', l_return_status);
1692: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN */
1693:
1694: -- IF Get_Product_Status(515) IN ('I','S') THEN
1695:

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

1886:
1887:
1888: -- IF OKS_OMINT_PUB.IS_SERVICE_AVAILABLE exists in DB
1889: -- Then Call it Else Not
1890: /* OE_SERVICE_UTIL.CHECK_PROC('OKS_OMINT_PUB.IS_SERVICE_AVAILABLE', l_return_status);
1891: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN */
1892:
1893: -- IF Get_Product_Status(515) IN ('I','S') THEN
1894:

Line 2453: , x_srv_cust_prod_tbl OUT NOCOPY OE_SERVICE_UTIL.SRV_CUST_PROD_TBL

2449: PROCEDURE Get_Cust_Prod_RG
2450: ( x_return_status OUT NOCOPY VARCHAR2
2451:
2452: , p_customer_id IN NUMBER
2453: , x_srv_cust_prod_tbl OUT NOCOPY OE_SERVICE_UTIL.SRV_CUST_PROD_TBL
2454:
2455: )
2456: IS
2457: Type CustProdCurTyp IS REF CURSOR;

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

2494: IF l_exists = 'Y' AND -- other conditions added for 2225343
2495: (p_customer_id <> g_customer_id OR
2496: g_customer_id IS NULL) THEN
2497:
2498: OE_SERVICE_UTIL.l_srv_cust_prod_tbl.DELETE; -- 2225343 end
2499:
2500: --IF NOT (CSI_UTILITY_GRP.IB_ACTIVE()) THEN
2501: IF NOT (IB_ACTIVE()) THEN
2502: OPEN cust_cv FOR

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

2514: I := 1;
2515:
2516: LOOP
2517: FETCH cust_cv INTO
2518: OE_SERVICE_UTIL.l_srv_cust_prod_tbl(I).customer_product_id,
2519: OE_SERVICE_UTIL.l_srv_cust_prod_tbl(I).product,
2520: OE_SERVICE_UTIL.l_srv_cust_prod_tbl(I).product_description,
2521: OE_SERVICE_UTIL.l_srv_cust_prod_tbl(I).reference_number,
2522: OE_SERVICE_UTIL.l_srv_cust_prod_tbl(I).current_serial_number;

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

2515:
2516: LOOP
2517: FETCH cust_cv INTO
2518: OE_SERVICE_UTIL.l_srv_cust_prod_tbl(I).customer_product_id,
2519: OE_SERVICE_UTIL.l_srv_cust_prod_tbl(I).product,
2520: OE_SERVICE_UTIL.l_srv_cust_prod_tbl(I).product_description,
2521: OE_SERVICE_UTIL.l_srv_cust_prod_tbl(I).reference_number,
2522: OE_SERVICE_UTIL.l_srv_cust_prod_tbl(I).current_serial_number;
2523: I := I + 1;

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

2516: LOOP
2517: FETCH cust_cv INTO
2518: OE_SERVICE_UTIL.l_srv_cust_prod_tbl(I).customer_product_id,
2519: OE_SERVICE_UTIL.l_srv_cust_prod_tbl(I).product,
2520: OE_SERVICE_UTIL.l_srv_cust_prod_tbl(I).product_description,
2521: OE_SERVICE_UTIL.l_srv_cust_prod_tbl(I).reference_number,
2522: OE_SERVICE_UTIL.l_srv_cust_prod_tbl(I).current_serial_number;
2523: I := I + 1;
2524: EXIT WHEN cust_cv%NOTFOUND;

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

2517: FETCH cust_cv INTO
2518: OE_SERVICE_UTIL.l_srv_cust_prod_tbl(I).customer_product_id,
2519: OE_SERVICE_UTIL.l_srv_cust_prod_tbl(I).product,
2520: OE_SERVICE_UTIL.l_srv_cust_prod_tbl(I).product_description,
2521: OE_SERVICE_UTIL.l_srv_cust_prod_tbl(I).reference_number,
2522: OE_SERVICE_UTIL.l_srv_cust_prod_tbl(I).current_serial_number;
2523: I := I + 1;
2524: EXIT WHEN cust_cv%NOTFOUND;
2525: END LOOP;

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

2518: OE_SERVICE_UTIL.l_srv_cust_prod_tbl(I).customer_product_id,
2519: OE_SERVICE_UTIL.l_srv_cust_prod_tbl(I).product,
2520: OE_SERVICE_UTIL.l_srv_cust_prod_tbl(I).product_description,
2521: OE_SERVICE_UTIL.l_srv_cust_prod_tbl(I).reference_number,
2522: OE_SERVICE_UTIL.l_srv_cust_prod_tbl(I).current_serial_number;
2523: I := I + 1;
2524: EXIT WHEN cust_cv%NOTFOUND;
2525: END LOOP;
2526: END IF;

Line 2527: x_srv_cust_prod_tbl := OE_SERVICE_UTIL.l_srv_cust_prod_tbl;

2523: I := I + 1;
2524: EXIT WHEN cust_cv%NOTFOUND;
2525: END LOOP;
2526: END IF;
2527: x_srv_cust_prod_tbl := OE_SERVICE_UTIL.l_srv_cust_prod_tbl;
2528: x_return_status := FND_API.G_RET_STS_SUCCESS;
2529: IF l_debug_level > 0 THEN
2530: oe_debug_pub.add( 'EXITING SUCCESS GET_CUST_PROD_RG' ) ;
2531: END IF;

Line 2545: , p_service_rec IN OE_SERVICE_UTIL.T_SERVICE_REC

2541:
2542: PROCEDURE Get_Avail_Service_RG
2543: ( x_return_status OUT NOCOPY VARCHAR2
2544:
2545: , p_service_rec IN OE_SERVICE_UTIL.T_SERVICE_REC
2546: , x_srv_cust_prod_tbl OUT NOCOPY OE_SERVICE_UTIL.SRV_ITEM_ID_TBL
2547:
2548: )
2549: IS

Line 2546: , x_srv_cust_prod_tbl OUT NOCOPY OE_SERVICE_UTIL.SRV_ITEM_ID_TBL

2542: PROCEDURE Get_Avail_Service_RG
2543: ( x_return_status OUT NOCOPY VARCHAR2
2544:
2545: , p_service_rec IN OE_SERVICE_UTIL.T_SERVICE_REC
2546: , x_srv_cust_prod_tbl OUT NOCOPY OE_SERVICE_UTIL.SRV_ITEM_ID_TBL
2547:
2548: )
2549: IS
2550: l_sql_stat VARCHAR2(500);

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

2561:
2562: -- Call Describe_Proc to check for the existance of the CRM's
2563: -- AVAILABLE_SERVICES API. If exists Then Call it else No Problem.
2564:
2565: /* OE_SERVICE_UTIL.CHECK_PROC('OKS_OMINT_PUB.OKS_AVAILABLE_SERVICES', l_return_status);
2566: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN */
2567:
2568: -- IF Get_Product_Status(515) IN ('I','S') THEN
2569:

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

2591: , :x_return_status
2592: , l_service_rec
2593: , l_service_tbl);
2594:
2595: OE_SERVICE_UTIL.l_srv_tbl := l_service_tbl; ';
2596:
2597: IF l_debug_level > 0 THEN
2598: oe_debug_pub.add( 'BEFORE OKS_OMINT_PUB.OKS_AVAILABLE_SERVICES', 0.5 ) ; -- Added debug for bug 13435459
2599: oe_debug_pub.add( L_SQL_STAT ) ;

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

2720: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2721: BEGIN
2722:
2723: IF l_debug_level > 0 THEN
2724: oe_debug_pub.add( 'ENTERING OE_SERVICE_UTIL.NEW_SERVICE_LINES' , 1 ) ;
2725: END IF;
2726:
2727: --lchen fix bug 2027650
2728: I := p_x_line_tbl.FIRST;

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

2748: ( p_x_line_tbl(i).operation = OE_GLOBALS.G_OPR_CREATE or
2749: p_x_line_tbl(i).operation= OE_GLOBALS.G_OPR_UPDATE) THEN
2750:
2751: IF l_debug_level > 0 THEN
2752: oe_debug_pub.add( 'IN OE_SERVICE_UTIL.UPDATE_SERVICE_LINES.ENTERING OE_SERVICE_UTIL.NEW_SERVICE_LINES' , 1 ) ;
2753: END IF;
2754:
2755: -- oe_debug_pub.ADD('headerId:' || l_line_rec.header_id , 1);
2756: -- oe_debug_pub.ADD('line_id:' || l_line_rec.line_id , 1);

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

2815: OE_GLOBALS.G_CASCADING_REQUEST_LOGGED := TRUE;
2816: END IF;
2817:
2818: IF l_debug_level > 0 THEN
2819: oe_debug_pub.add( 'EXITING OE_SERVICE_UTIL.UPDATE_SERVICE_LINES' , 1 ) ;
2820: END IF;
2821:
2822:
2823: EXCEPTION

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

2893: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2894: BEGIN
2895:
2896: IF l_debug_level > 0 THEN
2897: oe_debug_pub.add( 'ENTER OE_SERVICE_UTIL.CASCADE_CHANGES' , 1 ) ;
2898: END IF;
2899:
2900: IF fnd_profile.value('ONT_CASCADE_SERVICE') = 'N' THEN
2901: /* 3128684 */

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

2984: END LOOP;
2985:
2986: IF l_line_count = 0 THEN
2987: IF l_debug_level > 0 THEN
2988: oe_debug_pub.add( 'EXITING OE_SERVICE_UTIL.CASCADE_CHANGES' , 1 ) ;
2989: END IF;
2990: IF l_debug_level > 0 THEN
2991: oe_debug_pub.add( 'NO ROWS TO CASCADE' , 2 ) ;
2992: END IF;

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

3214: l_ref_type_code CONSTANT VARCHAR2(5) := 'ORDER';
3215: BEGIN
3216:
3217: IF l_debug_level > 0 THEN
3218: oe_debug_pub.add( 'ENTERING OE_SERVICE_UTIL.UPDATE_SERVICE_OPTION_NUMBERS' , 2 ) ;
3219: END IF;
3220:
3221: OPEN option_lines;
3222: FETCH option_lines BULK COLLECT INTO l_line_ids, l_option_numbers;

Line 3237: END OE_SERVICE_UTIL;

3233: END IF;
3234:
3235: END;
3236:
3237: END OE_SERVICE_UTIL;