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_LINE_SCREDIT_UTIL dependencies on OE_LINE_SCREDIT_UTIL

Line 1: PACKAGE BODY OE_Line_Scredit_Util AS

1: PACKAGE BODY OE_Line_Scredit_Util AS
2: /* $Header: OEXULSCB.pls 120.4.12010000.3 2009/06/23 06:33:53 nitagarw ship $ */
3:
4: -- Global constant holding the package name
5:

Line 6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Line_Scredit_Util';

2: /* $Header: OEXULSCB.pls 120.4.12010000.3 2009/06/23 06:33:53 nitagarw ship $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Line_Scredit_Util';
7: G_HEADER_ID NUMBER;
8: G_SALESREP_ID NUMBER;
9:
10: FUNCTION G_MISS_OE_AK_LINE_SCREDIT_REC

Line 160: oe_debug_pub.add( 'ENTERING OE_LINE_SCREDIT_UTIL.CLEAR_DEPENDENT_ATTR' , 1 ) ;

156: --
157: BEGIN
158:
159: IF l_debug_level > 0 THEN
160: oe_debug_pub.add( 'ENTERING OE_LINE_SCREDIT_UTIL.CLEAR_DEPENDENT_ATTR' , 1 ) ;
161: END IF;
162:
163: -- If attr_id is missing compare old and new records and for
164: -- every changed attribute clear its dependent fields.

Line 171: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE1;

167:
168: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute1,p_old_Line_Scredit_rec.attribute1)
169: THEN
170: l_index := l_index + 1;
171: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE1;
172: END IF;
173:
174: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute10,p_old_Line_Scredit_rec.attribute10)
175: THEN

Line 177: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE10;

173:
174: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute10,p_old_Line_Scredit_rec.attribute10)
175: THEN
176: l_index := l_index + 1;
177: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE10;
178: END IF;
179:
180: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute11,p_old_Line_Scredit_rec.attribute11)
181: THEN

Line 183: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE11;

179:
180: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute11,p_old_Line_Scredit_rec.attribute11)
181: THEN
182: l_index := l_index + 1;
183: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE11;
184: END IF;
185:
186: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute12,p_old_Line_Scredit_rec.attribute12)
187: THEN

Line 189: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE12;

185:
186: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute12,p_old_Line_Scredit_rec.attribute12)
187: THEN
188: l_index := l_index + 1;
189: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE12;
190: END IF;
191:
192: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute13,p_old_Line_Scredit_rec.attribute13)
193: THEN

Line 195: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE13;

191:
192: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute13,p_old_Line_Scredit_rec.attribute13)
193: THEN
194: l_index := l_index + 1;
195: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE13;
196: END IF;
197:
198: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute14,p_old_Line_Scredit_rec.attribute14)
199: THEN

Line 201: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE14;

197:
198: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute14,p_old_Line_Scredit_rec.attribute14)
199: THEN
200: l_index := l_index + 1;
201: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE14;
202: END IF;
203:
204: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute15,p_old_Line_Scredit_rec.attribute15)
205: THEN

Line 207: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE15;

203:
204: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute15,p_old_Line_Scredit_rec.attribute15)
205: THEN
206: l_index := l_index + 1;
207: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE15;
208: END IF;
209:
210: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute2,p_old_Line_Scredit_rec.attribute2)
211: THEN

Line 213: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE2;

209:
210: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute2,p_old_Line_Scredit_rec.attribute2)
211: THEN
212: l_index := l_index + 1;
213: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE2;
214: END IF;
215:
216: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute3,p_old_Line_Scredit_rec.attribute3)
217: THEN

Line 219: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE3;

215:
216: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute3,p_old_Line_Scredit_rec.attribute3)
217: THEN
218: l_index := l_index + 1;
219: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE3;
220: END IF;
221:
222: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute4,p_old_Line_Scredit_rec.attribute4)
223: THEN

Line 225: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE4;

221:
222: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute4,p_old_Line_Scredit_rec.attribute4)
223: THEN
224: l_index := l_index + 1;
225: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE4;
226: END IF;
227:
228: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute5,p_old_Line_Scredit_rec.attribute5)
229: THEN

Line 231: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE5;

227:
228: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute5,p_old_Line_Scredit_rec.attribute5)
229: THEN
230: l_index := l_index + 1;
231: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE5;
232: END IF;
233:
234: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute6,p_old_Line_Scredit_rec.attribute6)
235: THEN

Line 237: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE6;

233:
234: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute6,p_old_Line_Scredit_rec.attribute6)
235: THEN
236: l_index := l_index + 1;
237: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE6;
238: END IF;
239:
240: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute7,p_old_Line_Scredit_rec.attribute7)
241: THEN

Line 243: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE7;

239:
240: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute7,p_old_Line_Scredit_rec.attribute7)
241: THEN
242: l_index := l_index + 1;
243: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE7;
244: END IF;
245:
246: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute8,p_old_Line_Scredit_rec.attribute8)
247: THEN

Line 249: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE8;

245:
246: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute8,p_old_Line_Scredit_rec.attribute8)
247: THEN
248: l_index := l_index + 1;
249: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE8;
250: END IF;
251:
252: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute9,p_old_Line_Scredit_rec.attribute9)
253: THEN

Line 255: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE9;

251:
252: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute9,p_old_Line_Scredit_rec.attribute9)
253: THEN
254: l_index := l_index + 1;
255: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE9;
256: END IF;
257:
258: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.context,p_old_Line_Scredit_rec.context)
259: THEN

Line 261: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_CONTEXT;

257:
258: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.context,p_old_Line_Scredit_rec.context)
259: THEN
260: l_index := l_index + 1;
261: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_CONTEXT;
262: END IF;
263:
264: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.created_by,p_old_Line_Scredit_rec.created_by)
265: THEN

Line 267: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_CREATED_BY;

263:
264: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.created_by,p_old_Line_Scredit_rec.created_by)
265: THEN
266: l_index := l_index + 1;
267: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_CREATED_BY;
268: END IF;
269:
270: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.creation_date,p_old_Line_Scredit_rec.creation_date)
271: THEN

Line 273: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_CREATION_DATE;

269:
270: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.creation_date,p_old_Line_Scredit_rec.creation_date)
271: THEN
272: l_index := l_index + 1;
273: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_CREATION_DATE;
274: END IF;
275:
276: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.dw_update_advice_flag,p_old_Line_Scredit_rec.dw_update_advice_flag)
277: THEN

Line 279: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_DW_UPDATE_ADVICE;

275:
276: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.dw_update_advice_flag,p_old_Line_Scredit_rec.dw_update_advice_flag)
277: THEN
278: l_index := l_index + 1;
279: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_DW_UPDATE_ADVICE;
280: END IF;
281:
282: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.header_id,p_old_Line_Scredit_rec.header_id)
283: THEN

Line 285: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_HEADER;

281:
282: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.header_id,p_old_Line_Scredit_rec.header_id)
283: THEN
284: l_index := l_index + 1;
285: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_HEADER;
286: END IF;
287:
288: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.last_updated_by,p_old_Line_Scredit_rec.last_updated_by)
289: THEN

Line 291: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_LAST_UPDATED_BY;

287:
288: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.last_updated_by,p_old_Line_Scredit_rec.last_updated_by)
289: THEN
290: l_index := l_index + 1;
291: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_LAST_UPDATED_BY;
292: END IF;
293:
294: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.last_update_date,p_old_Line_Scredit_rec.last_update_date)
295: THEN

Line 297: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_LAST_UPDATE_DATE;

293:
294: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.last_update_date,p_old_Line_Scredit_rec.last_update_date)
295: THEN
296: l_index := l_index + 1;
297: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_LAST_UPDATE_DATE;
298: END IF;
299:
300: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.last_update_login,p_old_Line_Scredit_rec.last_update_login)
301: THEN

Line 303: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_LAST_UPDATE_LOGIN;

299:
300: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.last_update_login,p_old_Line_Scredit_rec.last_update_login)
301: THEN
302: l_index := l_index + 1;
303: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_LAST_UPDATE_LOGIN;
304: END IF;
305:
306: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.line_id,p_old_Line_Scredit_rec.line_id)
307: THEN

Line 309: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_LINE;

305:
306: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.line_id,p_old_Line_Scredit_rec.line_id)
307: THEN
308: l_index := l_index + 1;
309: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_LINE;
310: END IF;
311:
312: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.percent,p_old_Line_Scredit_rec.percent)
313: THEN

Line 315: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_PERCENT;

311:
312: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.percent,p_old_Line_Scredit_rec.percent)
313: THEN
314: l_index := l_index + 1;
315: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_PERCENT;
316: END IF;
317:
318:
319: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.salesrep_id,p_old_Line_Scredit_rec.salesrep_id)

Line 322: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_SALESREP;

318:
319: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.salesrep_id,p_old_Line_Scredit_rec.salesrep_id)
320: THEN
321: l_index := l_index + 1;
322: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_SALESREP;
323: END IF;
324:
325: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.sales_credit_type_id,p_old_Line_Scredit_rec.sales_credit_type_id)
326: THEN

Line 328: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_sales_credit_type;

324:
325: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.sales_credit_type_id,p_old_Line_Scredit_rec.sales_credit_type_id)
326: THEN
327: l_index := l_index + 1;
328: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_sales_credit_type;
329: END IF;
330:
331: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.sales_credit_id,p_old_Line_Scredit_rec.sales_credit_id)
332: THEN

Line 334: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_SALES_CREDIT;

330:
331: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.sales_credit_id,p_old_Line_Scredit_rec.sales_credit_id)
332: THEN
333: l_index := l_index + 1;
334: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_SALES_CREDIT;
335: END IF;
336:
337: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.wh_update_date,p_old_Line_Scredit_rec.wh_update_date)
338: THEN

Line 340: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_WH_UPDATE_DATE;

336:
337: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.wh_update_date,p_old_Line_Scredit_rec.wh_update_date)
338: THEN
339: l_index := l_index + 1;
340: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_WH_UPDATE_DATE;
341: END IF;
342:
343: ELSIF p_attr_id = G_ATTRIBUTE1 THEN
344: l_index := l_index + 1;

Line 345: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE1;

341: END IF;
342:
343: ELSIF p_attr_id = G_ATTRIBUTE1 THEN
344: l_index := l_index + 1;
345: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE1;
346: ELSIF p_attr_id = G_ATTRIBUTE10 THEN
347: l_index := l_index + 1;
348: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE10;
349: ELSIF p_attr_id = G_ATTRIBUTE11 THEN

Line 348: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE10;

344: l_index := l_index + 1;
345: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE1;
346: ELSIF p_attr_id = G_ATTRIBUTE10 THEN
347: l_index := l_index + 1;
348: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE10;
349: ELSIF p_attr_id = G_ATTRIBUTE11 THEN
350: l_index := l_index + 1;
351: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE11;
352: ELSIF p_attr_id = G_ATTRIBUTE12 THEN

Line 351: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE11;

347: l_index := l_index + 1;
348: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE10;
349: ELSIF p_attr_id = G_ATTRIBUTE11 THEN
350: l_index := l_index + 1;
351: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE11;
352: ELSIF p_attr_id = G_ATTRIBUTE12 THEN
353: l_index := l_index + 1;
354: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE12;
355: ELSIF p_attr_id = G_ATTRIBUTE13 THEN

Line 354: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE12;

350: l_index := l_index + 1;
351: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE11;
352: ELSIF p_attr_id = G_ATTRIBUTE12 THEN
353: l_index := l_index + 1;
354: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE12;
355: ELSIF p_attr_id = G_ATTRIBUTE13 THEN
356: l_index := l_index + 1;
357: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE13;
358: ELSIF p_attr_id = G_ATTRIBUTE14 THEN

Line 357: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE13;

353: l_index := l_index + 1;
354: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE12;
355: ELSIF p_attr_id = G_ATTRIBUTE13 THEN
356: l_index := l_index + 1;
357: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE13;
358: ELSIF p_attr_id = G_ATTRIBUTE14 THEN
359: l_index := l_index + 1;
360: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE14;
361: ELSIF p_attr_id = G_ATTRIBUTE15 THEN

Line 360: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE14;

356: l_index := l_index + 1;
357: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE13;
358: ELSIF p_attr_id = G_ATTRIBUTE14 THEN
359: l_index := l_index + 1;
360: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE14;
361: ELSIF p_attr_id = G_ATTRIBUTE15 THEN
362: l_index := l_index + 1;
363: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE15;
364: ELSIF p_attr_id = G_ATTRIBUTE2 THEN

Line 363: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE15;

359: l_index := l_index + 1;
360: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE14;
361: ELSIF p_attr_id = G_ATTRIBUTE15 THEN
362: l_index := l_index + 1;
363: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE15;
364: ELSIF p_attr_id = G_ATTRIBUTE2 THEN
365: l_index := l_index + 1;
366: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE2;
367: ELSIF p_attr_id = G_ATTRIBUTE3 THEN

Line 366: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE2;

362: l_index := l_index + 1;
363: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE15;
364: ELSIF p_attr_id = G_ATTRIBUTE2 THEN
365: l_index := l_index + 1;
366: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE2;
367: ELSIF p_attr_id = G_ATTRIBUTE3 THEN
368: l_index := l_index + 1;
369: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE3;
370: ELSIF p_attr_id = G_ATTRIBUTE4 THEN

Line 369: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE3;

365: l_index := l_index + 1;
366: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE2;
367: ELSIF p_attr_id = G_ATTRIBUTE3 THEN
368: l_index := l_index + 1;
369: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE3;
370: ELSIF p_attr_id = G_ATTRIBUTE4 THEN
371: l_index := l_index + 1;
372: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE4;
373: ELSIF p_attr_id = G_ATTRIBUTE5 THEN

Line 372: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE4;

368: l_index := l_index + 1;
369: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE3;
370: ELSIF p_attr_id = G_ATTRIBUTE4 THEN
371: l_index := l_index + 1;
372: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE4;
373: ELSIF p_attr_id = G_ATTRIBUTE5 THEN
374: l_index := l_index + 1;
375: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE5;
376: ELSIF p_attr_id = G_ATTRIBUTE6 THEN

Line 375: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE5;

371: l_index := l_index + 1;
372: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE4;
373: ELSIF p_attr_id = G_ATTRIBUTE5 THEN
374: l_index := l_index + 1;
375: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE5;
376: ELSIF p_attr_id = G_ATTRIBUTE6 THEN
377: l_index := l_index + 1;
378: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE6;
379: ELSIF p_attr_id = G_ATTRIBUTE7 THEN

Line 378: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE6;

374: l_index := l_index + 1;
375: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE5;
376: ELSIF p_attr_id = G_ATTRIBUTE6 THEN
377: l_index := l_index + 1;
378: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE6;
379: ELSIF p_attr_id = G_ATTRIBUTE7 THEN
380: l_index := l_index + 1;
381: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE7;
382: ELSIF p_attr_id = G_ATTRIBUTE8 THEN

Line 381: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE7;

377: l_index := l_index + 1;
378: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE6;
379: ELSIF p_attr_id = G_ATTRIBUTE7 THEN
380: l_index := l_index + 1;
381: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE7;
382: ELSIF p_attr_id = G_ATTRIBUTE8 THEN
383: l_index := l_index + 1;
384: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE8;
385: ELSIF p_attr_id = G_ATTRIBUTE9 THEN

Line 384: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE8;

380: l_index := l_index + 1;
381: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE7;
382: ELSIF p_attr_id = G_ATTRIBUTE8 THEN
383: l_index := l_index + 1;
384: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE8;
385: ELSIF p_attr_id = G_ATTRIBUTE9 THEN
386: l_index := l_index + 1;
387: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE9;
388: ELSIF p_attr_id = G_CONTEXT THEN

Line 387: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE9;

383: l_index := l_index + 1;
384: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE8;
385: ELSIF p_attr_id = G_ATTRIBUTE9 THEN
386: l_index := l_index + 1;
387: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE9;
388: ELSIF p_attr_id = G_CONTEXT THEN
389: l_index := l_index + 1;
390: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_CONTEXT;
391: ELSIF p_attr_id = G_CREATED_BY THEN

Line 390: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_CONTEXT;

386: l_index := l_index + 1;
387: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE9;
388: ELSIF p_attr_id = G_CONTEXT THEN
389: l_index := l_index + 1;
390: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_CONTEXT;
391: ELSIF p_attr_id = G_CREATED_BY THEN
392: l_index := l_index + 1;
393: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_CREATED_BY;
394: ELSIF p_attr_id = G_CREATION_DATE THEN

Line 393: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_CREATED_BY;

389: l_index := l_index + 1;
390: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_CONTEXT;
391: ELSIF p_attr_id = G_CREATED_BY THEN
392: l_index := l_index + 1;
393: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_CREATED_BY;
394: ELSIF p_attr_id = G_CREATION_DATE THEN
395: l_index := l_index + 1;
396: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_CREATION_DATE;
397: ELSIF p_attr_id = G_DW_UPDATE_ADVICE THEN

Line 396: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_CREATION_DATE;

392: l_index := l_index + 1;
393: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_CREATED_BY;
394: ELSIF p_attr_id = G_CREATION_DATE THEN
395: l_index := l_index + 1;
396: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_CREATION_DATE;
397: ELSIF p_attr_id = G_DW_UPDATE_ADVICE THEN
398: l_index := l_index + 1;
399: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_DW_UPDATE_ADVICE;
400: ELSIF p_attr_id = G_HEADER THEN

Line 399: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_DW_UPDATE_ADVICE;

395: l_index := l_index + 1;
396: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_CREATION_DATE;
397: ELSIF p_attr_id = G_DW_UPDATE_ADVICE THEN
398: l_index := l_index + 1;
399: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_DW_UPDATE_ADVICE;
400: ELSIF p_attr_id = G_HEADER THEN
401: l_index := l_index + 1;
402: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_HEADER;
403: ELSIF p_attr_id = G_LAST_UPDATED_BY THEN

Line 402: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_HEADER;

398: l_index := l_index + 1;
399: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_DW_UPDATE_ADVICE;
400: ELSIF p_attr_id = G_HEADER THEN
401: l_index := l_index + 1;
402: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_HEADER;
403: ELSIF p_attr_id = G_LAST_UPDATED_BY THEN
404: l_index := l_index + 1;
405: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_LAST_UPDATED_BY;
406: ELSIF p_attr_id = G_LAST_UPDATE_DATE THEN

Line 405: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_LAST_UPDATED_BY;

401: l_index := l_index + 1;
402: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_HEADER;
403: ELSIF p_attr_id = G_LAST_UPDATED_BY THEN
404: l_index := l_index + 1;
405: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_LAST_UPDATED_BY;
406: ELSIF p_attr_id = G_LAST_UPDATE_DATE THEN
407: l_index := l_index + 1;
408: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_LAST_UPDATE_DATE;
409: ELSIF p_attr_id = G_LAST_UPDATE_LOGIN THEN

Line 408: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_LAST_UPDATE_DATE;

404: l_index := l_index + 1;
405: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_LAST_UPDATED_BY;
406: ELSIF p_attr_id = G_LAST_UPDATE_DATE THEN
407: l_index := l_index + 1;
408: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_LAST_UPDATE_DATE;
409: ELSIF p_attr_id = G_LAST_UPDATE_LOGIN THEN
410: l_index := l_index + 1;
411: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_LAST_UPDATE_LOGIN;
412: ELSIF p_attr_id = G_LINE THEN

Line 411: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_LAST_UPDATE_LOGIN;

407: l_index := l_index + 1;
408: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_LAST_UPDATE_DATE;
409: ELSIF p_attr_id = G_LAST_UPDATE_LOGIN THEN
410: l_index := l_index + 1;
411: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_LAST_UPDATE_LOGIN;
412: ELSIF p_attr_id = G_LINE THEN
413: l_index := l_index + 1;
414: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_LINE;
415: ELSIF p_attr_id = G_PERCENT THEN

Line 414: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_LINE;

410: l_index := l_index + 1;
411: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_LAST_UPDATE_LOGIN;
412: ELSIF p_attr_id = G_LINE THEN
413: l_index := l_index + 1;
414: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_LINE;
415: ELSIF p_attr_id = G_PERCENT THEN
416: l_index := l_index + 1;
417: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_PERCENT;
418: ELSIF p_attr_id = G_SALESREP THEN

Line 417: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_PERCENT;

413: l_index := l_index + 1;
414: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_LINE;
415: ELSIF p_attr_id = G_PERCENT THEN
416: l_index := l_index + 1;
417: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_PERCENT;
418: ELSIF p_attr_id = G_SALESREP THEN
419: l_index := l_index + 1;
420: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_SALESREP;
421: ELSIF p_attr_id = G_sales_credit_type THEN

Line 420: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_SALESREP;

416: l_index := l_index + 1;
417: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_PERCENT;
418: ELSIF p_attr_id = G_SALESREP THEN
419: l_index := l_index + 1;
420: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_SALESREP;
421: ELSIF p_attr_id = G_sales_credit_type THEN
422: l_index := l_index + 1;
423: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_sales_credit_type;
424: ELSIF p_attr_id = G_SALES_CREDIT THEN

Line 423: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_sales_credit_type;

419: l_index := l_index + 1;
420: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_SALESREP;
421: ELSIF p_attr_id = G_sales_credit_type THEN
422: l_index := l_index + 1;
423: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_sales_credit_type;
424: ELSIF p_attr_id = G_SALES_CREDIT THEN
425: l_index := l_index + 1;
426: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_SALES_CREDIT;
427: ELSIF p_attr_id = G_WH_UPDATE_DATE THEN

Line 426: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_SALES_CREDIT;

422: l_index := l_index + 1;
423: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_sales_credit_type;
424: ELSIF p_attr_id = G_SALES_CREDIT THEN
425: l_index := l_index + 1;
426: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_SALES_CREDIT;
427: ELSIF p_attr_id = G_WH_UPDATE_DATE THEN
428: l_index := l_index + 1;
429: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_WH_UPDATE_DATE;
430: END IF;

Line 429: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_WH_UPDATE_DATE;

425: l_index := l_index + 1;
426: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_SALES_CREDIT;
427: ELSIF p_attr_id = G_WH_UPDATE_DATE THEN
428: l_index := l_index + 1;
429: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_WH_UPDATE_DATE;
430: END IF;
431:
432: If l_src_attr_tbl.COUNT <> 0 THEN
433:

Line 440: IF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE1 THEN

436: p_source_attr_tbl => l_src_attr_tbl,
437: p_dep_attr_tbl => l_dep_attr_tbl);
438:
439: FOR I IN 1..l_dep_attr_tbl.COUNT LOOP
440: IF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE1 THEN
441: p_x_Line_Scredit_rec.ATTRIBUTE1 := FND_API.G_MISS_NUM;
442: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE10 THEN
443: p_x_Line_Scredit_rec.ATTRIBUTE10 := FND_API.G_MISS_CHAR;
444: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE11 THEN

Line 442: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE10 THEN

438:
439: FOR I IN 1..l_dep_attr_tbl.COUNT LOOP
440: IF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE1 THEN
441: p_x_Line_Scredit_rec.ATTRIBUTE1 := FND_API.G_MISS_NUM;
442: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE10 THEN
443: p_x_Line_Scredit_rec.ATTRIBUTE10 := FND_API.G_MISS_CHAR;
444: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE11 THEN
445: p_x_Line_Scredit_rec.ATTRIBUTE11 := FND_API.G_MISS_CHAR;
446: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE12 THEN

Line 444: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE11 THEN

440: IF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE1 THEN
441: p_x_Line_Scredit_rec.ATTRIBUTE1 := FND_API.G_MISS_NUM;
442: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE10 THEN
443: p_x_Line_Scredit_rec.ATTRIBUTE10 := FND_API.G_MISS_CHAR;
444: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE11 THEN
445: p_x_Line_Scredit_rec.ATTRIBUTE11 := FND_API.G_MISS_CHAR;
446: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE12 THEN
447: p_x_Line_Scredit_rec.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
448: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE13 THEN

Line 446: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE12 THEN

442: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE10 THEN
443: p_x_Line_Scredit_rec.ATTRIBUTE10 := FND_API.G_MISS_CHAR;
444: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE11 THEN
445: p_x_Line_Scredit_rec.ATTRIBUTE11 := FND_API.G_MISS_CHAR;
446: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE12 THEN
447: p_x_Line_Scredit_rec.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
448: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE13 THEN
449: p_x_Line_Scredit_rec.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
450: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE14 THEN

Line 448: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE13 THEN

444: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE11 THEN
445: p_x_Line_Scredit_rec.ATTRIBUTE11 := FND_API.G_MISS_CHAR;
446: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE12 THEN
447: p_x_Line_Scredit_rec.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
448: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE13 THEN
449: p_x_Line_Scredit_rec.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
450: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE14 THEN
451: p_x_Line_Scredit_rec.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
452: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE15 THEN

Line 450: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE14 THEN

446: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE12 THEN
447: p_x_Line_Scredit_rec.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
448: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE13 THEN
449: p_x_Line_Scredit_rec.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
450: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE14 THEN
451: p_x_Line_Scredit_rec.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
452: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE15 THEN
453: p_x_Line_Scredit_rec.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
454: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE2 THEN

Line 452: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE15 THEN

448: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE13 THEN
449: p_x_Line_Scredit_rec.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
450: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE14 THEN
451: p_x_Line_Scredit_rec.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
452: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE15 THEN
453: p_x_Line_Scredit_rec.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
454: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE2 THEN
455: p_x_Line_Scredit_rec.ATTRIBUTE2 := FND_API.G_MISS_CHAR;
456: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE3 THEN

Line 454: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE2 THEN

450: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE14 THEN
451: p_x_Line_Scredit_rec.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
452: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE15 THEN
453: p_x_Line_Scredit_rec.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
454: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE2 THEN
455: p_x_Line_Scredit_rec.ATTRIBUTE2 := FND_API.G_MISS_CHAR;
456: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE3 THEN
457: p_x_Line_Scredit_rec.ATTRIBUTE3 := FND_API.G_MISS_CHAR;
458: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE4 THEN

Line 456: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE3 THEN

452: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE15 THEN
453: p_x_Line_Scredit_rec.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
454: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE2 THEN
455: p_x_Line_Scredit_rec.ATTRIBUTE2 := FND_API.G_MISS_CHAR;
456: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE3 THEN
457: p_x_Line_Scredit_rec.ATTRIBUTE3 := FND_API.G_MISS_CHAR;
458: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE4 THEN
459: p_x_Line_Scredit_rec.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
460: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE5 THEN

Line 458: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE4 THEN

454: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE2 THEN
455: p_x_Line_Scredit_rec.ATTRIBUTE2 := FND_API.G_MISS_CHAR;
456: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE3 THEN
457: p_x_Line_Scredit_rec.ATTRIBUTE3 := FND_API.G_MISS_CHAR;
458: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE4 THEN
459: p_x_Line_Scredit_rec.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
460: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE5 THEN
461: p_x_Line_Scredit_rec.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
462: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE6 THEN

Line 460: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE5 THEN

456: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE3 THEN
457: p_x_Line_Scredit_rec.ATTRIBUTE3 := FND_API.G_MISS_CHAR;
458: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE4 THEN
459: p_x_Line_Scredit_rec.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
460: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE5 THEN
461: p_x_Line_Scredit_rec.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
462: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE6 THEN
463: p_x_Line_Scredit_rec.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
464: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE7 THEN

Line 462: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE6 THEN

458: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE4 THEN
459: p_x_Line_Scredit_rec.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
460: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE5 THEN
461: p_x_Line_Scredit_rec.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
462: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE6 THEN
463: p_x_Line_Scredit_rec.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
464: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE7 THEN
465: p_x_Line_Scredit_rec.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
466: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE8 THEN

Line 464: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE7 THEN

460: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE5 THEN
461: p_x_Line_Scredit_rec.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
462: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE6 THEN
463: p_x_Line_Scredit_rec.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
464: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE7 THEN
465: p_x_Line_Scredit_rec.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
466: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE8 THEN
467: p_x_Line_Scredit_rec.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
468: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE9 THEN

Line 466: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE8 THEN

462: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE6 THEN
463: p_x_Line_Scredit_rec.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
464: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE7 THEN
465: p_x_Line_Scredit_rec.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
466: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE8 THEN
467: p_x_Line_Scredit_rec.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
468: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE9 THEN
469: p_x_Line_Scredit_rec.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
470: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_CONTEXT THEN

Line 468: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE9 THEN

464: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE7 THEN
465: p_x_Line_Scredit_rec.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
466: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE8 THEN
467: p_x_Line_Scredit_rec.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
468: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE9 THEN
469: p_x_Line_Scredit_rec.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
470: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_CONTEXT THEN
471: p_x_Line_Scredit_rec.CONTEXT := FND_API.G_MISS_CHAR;
472: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_CREATED_BY THEN

Line 470: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_CONTEXT THEN

466: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE8 THEN
467: p_x_Line_Scredit_rec.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
468: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE9 THEN
469: p_x_Line_Scredit_rec.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
470: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_CONTEXT THEN
471: p_x_Line_Scredit_rec.CONTEXT := FND_API.G_MISS_CHAR;
472: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_CREATED_BY THEN
473: p_x_Line_Scredit_rec.CREATED_BY := FND_API.G_MISS_NUM;
474: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_CREATION_DATE THEN

Line 472: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_CREATED_BY THEN

468: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE9 THEN
469: p_x_Line_Scredit_rec.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
470: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_CONTEXT THEN
471: p_x_Line_Scredit_rec.CONTEXT := FND_API.G_MISS_CHAR;
472: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_CREATED_BY THEN
473: p_x_Line_Scredit_rec.CREATED_BY := FND_API.G_MISS_NUM;
474: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_CREATION_DATE THEN
475: p_x_Line_Scredit_rec.CREATION_DATE := FND_API.G_MISS_DATE;
476: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_DW_UPDATE_ADVICE THEN

Line 474: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_CREATION_DATE THEN

470: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_CONTEXT THEN
471: p_x_Line_Scredit_rec.CONTEXT := FND_API.G_MISS_CHAR;
472: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_CREATED_BY THEN
473: p_x_Line_Scredit_rec.CREATED_BY := FND_API.G_MISS_NUM;
474: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_CREATION_DATE THEN
475: p_x_Line_Scredit_rec.CREATION_DATE := FND_API.G_MISS_DATE;
476: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_DW_UPDATE_ADVICE THEN
477: p_x_Line_Scredit_rec.DW_UPDATE_ADVICE_FLAG := FND_API.G_MISS_CHAR;
478: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_HEADER THEN

Line 476: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_DW_UPDATE_ADVICE THEN

472: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_CREATED_BY THEN
473: p_x_Line_Scredit_rec.CREATED_BY := FND_API.G_MISS_NUM;
474: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_CREATION_DATE THEN
475: p_x_Line_Scredit_rec.CREATION_DATE := FND_API.G_MISS_DATE;
476: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_DW_UPDATE_ADVICE THEN
477: p_x_Line_Scredit_rec.DW_UPDATE_ADVICE_FLAG := FND_API.G_MISS_CHAR;
478: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_HEADER THEN
479: p_x_Line_Scredit_rec.HEADER_ID := FND_API.G_MISS_NUM;
480: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_LAST_UPDATED_BY THEN

Line 478: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_HEADER THEN

474: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_CREATION_DATE THEN
475: p_x_Line_Scredit_rec.CREATION_DATE := FND_API.G_MISS_DATE;
476: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_DW_UPDATE_ADVICE THEN
477: p_x_Line_Scredit_rec.DW_UPDATE_ADVICE_FLAG := FND_API.G_MISS_CHAR;
478: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_HEADER THEN
479: p_x_Line_Scredit_rec.HEADER_ID := FND_API.G_MISS_NUM;
480: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_LAST_UPDATED_BY THEN
481: p_x_Line_Scredit_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
482: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_LAST_UPDATE_DATE THEN

Line 480: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_LAST_UPDATED_BY THEN

476: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_DW_UPDATE_ADVICE THEN
477: p_x_Line_Scredit_rec.DW_UPDATE_ADVICE_FLAG := FND_API.G_MISS_CHAR;
478: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_HEADER THEN
479: p_x_Line_Scredit_rec.HEADER_ID := FND_API.G_MISS_NUM;
480: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_LAST_UPDATED_BY THEN
481: p_x_Line_Scredit_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
482: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_LAST_UPDATE_DATE THEN
483: p_x_Line_Scredit_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
484: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_LAST_UPDATE_LOGIN THEN

Line 482: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_LAST_UPDATE_DATE THEN

478: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_HEADER THEN
479: p_x_Line_Scredit_rec.HEADER_ID := FND_API.G_MISS_NUM;
480: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_LAST_UPDATED_BY THEN
481: p_x_Line_Scredit_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
482: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_LAST_UPDATE_DATE THEN
483: p_x_Line_Scredit_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
484: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_LAST_UPDATE_LOGIN THEN
485: p_x_Line_Scredit_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
486: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_LINE THEN

Line 484: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_LAST_UPDATE_LOGIN THEN

480: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_LAST_UPDATED_BY THEN
481: p_x_Line_Scredit_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
482: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_LAST_UPDATE_DATE THEN
483: p_x_Line_Scredit_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
484: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_LAST_UPDATE_LOGIN THEN
485: p_x_Line_Scredit_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
486: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_LINE THEN
487: p_x_Line_Scredit_rec.LINE_ID := FND_API.G_MISS_NUM;
488: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_PERCENT THEN

Line 486: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_LINE THEN

482: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_LAST_UPDATE_DATE THEN
483: p_x_Line_Scredit_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
484: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_LAST_UPDATE_LOGIN THEN
485: p_x_Line_Scredit_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
486: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_LINE THEN
487: p_x_Line_Scredit_rec.LINE_ID := FND_API.G_MISS_NUM;
488: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_PERCENT THEN
489: p_x_Line_Scredit_rec.PERCENT := FND_API.G_MISS_NUM;
490: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_SALESREP THEN

Line 488: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_PERCENT THEN

484: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_LAST_UPDATE_LOGIN THEN
485: p_x_Line_Scredit_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
486: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_LINE THEN
487: p_x_Line_Scredit_rec.LINE_ID := FND_API.G_MISS_NUM;
488: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_PERCENT THEN
489: p_x_Line_Scredit_rec.PERCENT := FND_API.G_MISS_NUM;
490: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_SALESREP THEN
491: p_x_Line_Scredit_rec.SALESREP_ID := FND_API.G_MISS_NUM;
492: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_sales_credit_type THEN

Line 490: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_SALESREP THEN

486: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_LINE THEN
487: p_x_Line_Scredit_rec.LINE_ID := FND_API.G_MISS_NUM;
488: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_PERCENT THEN
489: p_x_Line_Scredit_rec.PERCENT := FND_API.G_MISS_NUM;
490: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_SALESREP THEN
491: p_x_Line_Scredit_rec.SALESREP_ID := FND_API.G_MISS_NUM;
492: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_sales_credit_type THEN
493: p_x_Line_Scredit_rec.sales_credit_type_id := FND_API.G_MISS_NUM;
494: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_SALES_CREDIT THEN

Line 492: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_sales_credit_type THEN

488: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_PERCENT THEN
489: p_x_Line_Scredit_rec.PERCENT := FND_API.G_MISS_NUM;
490: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_SALESREP THEN
491: p_x_Line_Scredit_rec.SALESREP_ID := FND_API.G_MISS_NUM;
492: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_sales_credit_type THEN
493: p_x_Line_Scredit_rec.sales_credit_type_id := FND_API.G_MISS_NUM;
494: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_SALES_CREDIT THEN
495: p_x_Line_Scredit_rec.SALES_CREDIT_ID := FND_API.G_MISS_NUM;
496: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_WH_UPDATE_DATE THEN

Line 494: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_SALES_CREDIT THEN

490: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_SALESREP THEN
491: p_x_Line_Scredit_rec.SALESREP_ID := FND_API.G_MISS_NUM;
492: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_sales_credit_type THEN
493: p_x_Line_Scredit_rec.sales_credit_type_id := FND_API.G_MISS_NUM;
494: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_SALES_CREDIT THEN
495: p_x_Line_Scredit_rec.SALES_CREDIT_ID := FND_API.G_MISS_NUM;
496: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_WH_UPDATE_DATE THEN
497: p_x_Line_Scredit_rec.WH_UPDATE_DATE := FND_API.G_MISS_DATE;
498: END IF;

Line 496: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_WH_UPDATE_DATE THEN

492: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_sales_credit_type THEN
493: p_x_Line_Scredit_rec.sales_credit_type_id := FND_API.G_MISS_NUM;
494: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_SALES_CREDIT THEN
495: p_x_Line_Scredit_rec.SALES_CREDIT_ID := FND_API.G_MISS_NUM;
496: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_WH_UPDATE_DATE THEN
497: p_x_Line_Scredit_rec.WH_UPDATE_DATE := FND_API.G_MISS_DATE;
498: END IF;
499: END LOOP;
500: END IF;

Line 503: oe_debug_pub.add( 'EXITING OE_LINE_SCREDIT_UTIL.CLEAR_DEPENDENT_ATTR' , 1 ) ;

499: END LOOP;
500: END IF;
501:
502: IF l_debug_level > 0 THEN
503: oe_debug_pub.add( 'EXITING OE_LINE_SCREDIT_UTIL.CLEAR_DEPENDENT_ATTR' , 1 ) ;
504: END IF;
505:
506: END Clear_Dependent_Attr;
507:

Line 559: oe_debug_pub.add( 'ENTERING OE_LINE_SCREDIT_UTIL.APPLY_ATTRIBUTE_CHANGES' , 1 ) ;

555: --
556: BEGIN
557:
558: IF l_debug_level > 0 THEN
559: oe_debug_pub.add( 'ENTERING OE_LINE_SCREDIT_UTIL.APPLY_ATTRIBUTE_CHANGES' , 1 ) ;
560: END IF;
561:
562: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute1,p_old_Line_Scredit_rec.attribute1)
563: THEN

Line 868: oe_debug_pub.add( 'EXITING OE_LINE_SCREDIT_UTIL.APPLY_ATTRIBUTE_CHANGES' , 1 ) ;

864: NULL;
865: END IF;
866:
867: IF l_debug_level > 0 THEN
868: oe_debug_pub.add( 'EXITING OE_LINE_SCREDIT_UTIL.APPLY_ATTRIBUTE_CHANGES' , 1 ) ;
869: END IF;
870:
871: END Apply_Attribute_Changes;
872:

Line 886: oe_debug_pub.add( 'ENTERING OE_LINE_SCREDIT_UTIL.COMPLETE_RECORD' , 1 ) ;

882: --
883: BEGIN
884:
885: IF l_debug_level > 0 THEN
886: oe_debug_pub.add( 'ENTERING OE_LINE_SCREDIT_UTIL.COMPLETE_RECORD' , 1 ) ;
887: END IF;
888:
889: IF p_x_Line_Scredit_rec.attribute1 = FND_API.G_MISS_CHAR THEN
890: p_x_Line_Scredit_rec.attribute1 := p_old_Line_Scredit_rec.attribute1;

Line 1006: oe_debug_pub.add( 'EXITING OE_LINE_SCREDIT_UTIL.COMPLETE_RECORD' , 1 ) ;

1002: p_x_Line_Scredit_rec.wh_update_date := p_old_Line_Scredit_rec.wh_update_date;
1003: END IF;
1004:
1005: IF l_debug_level > 0 THEN
1006: oe_debug_pub.add( 'EXITING OE_LINE_SCREDIT_UTIL.COMPLETE_RECORD' , 1 ) ;
1007: END IF;
1008:
1009: END Complete_Record;
1010:

Line 1023: oe_debug_pub.add( 'ENTERING OE_LINE_SCREDIT_UTIL.CONVERT_MISS_TO_NULL' , 1 ) ;

1019: --
1020: BEGIN
1021:
1022: IF l_debug_level > 0 THEN
1023: oe_debug_pub.add( 'ENTERING OE_LINE_SCREDIT_UTIL.CONVERT_MISS_TO_NULL' , 1 ) ;
1024: END IF;
1025:
1026: IF p_x_Line_Scredit_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1027: p_x_Line_Scredit_rec.attribute1 := NULL;

Line 1143: oe_debug_pub.add( 'EXITING OE_LINE_SCREDIT_UTIL.CONVERT_MISS_TO_NULL' , 1 ) ;

1139: p_x_Line_Scredit_rec.wh_update_date := NULL;
1140: END IF;
1141:
1142: IF l_debug_level > 0 THEN
1143: oe_debug_pub.add( 'EXITING OE_LINE_SCREDIT_UTIL.CONVERT_MISS_TO_NULL' , 1 ) ;
1144: END IF;
1145:
1146: END Convert_Miss_To_Null;
1147:

Line 1168: oe_debug_pub.add( 'ENTERING OE_LINE_SCREDIT_UTIL.UPDATE_ROW' , 1 ) ;

1164: --
1165: BEGIN
1166:
1167: IF l_debug_level > 0 THEN
1168: oe_debug_pub.add( 'ENTERING OE_LINE_SCREDIT_UTIL.UPDATE_ROW' , 1 ) ;
1169: END IF;
1170:
1171: SELECT lock_control
1172: INTO l_lock_control

Line 1184: OE_LINE_SCREDIT_UTIL.Query_Row(p_sales_credit_id => p_line_scredit_rec.sales_credit_id,

1180: --added query_row for notification framework
1181: --before update, query sales credit record, this record will be used
1182: --to update global picture
1183:
1184: OE_LINE_SCREDIT_UTIL.Query_Row(p_sales_credit_id => p_line_scredit_rec.sales_credit_id,
1185: x_line_scredit_rec =>l_line_scredit_rec);
1186: IF l_debug_level > 0 THEN
1187: oe_debug_pub.add( 'BEFORE UPDATE , SALES_CREDIT_ID= '|| L_LINE_SCREDIT_REC.SALES_CREDIT_ID , 1 ) ;
1188: END IF;

Line 1251: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_LINE_SCREDIT_UTIL.UPDATE_ROW IS: ' || L_RETURN_STATUS ) ;

1247: x_index => l_index,
1248: x_return_status => l_return_status);
1249:
1250: IF l_debug_level > 0 THEN
1251: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_LINE_SCREDIT_UTIL.UPDATE_ROW IS: ' || L_RETURN_STATUS ) ;
1252: END IF;
1253:
1254: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1255: IF l_debug_level > 0 THEN

Line 1259: oe_debug_pub.add( 'EXITING OE_LINE_SCREDIT_UTIL.UPDATE_ROW' , 1 ) ;

1255: IF l_debug_level > 0 THEN
1256: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
1257: END IF;
1258: IF l_debug_level > 0 THEN
1259: oe_debug_pub.add( 'EXITING OE_LINE_SCREDIT_UTIL.UPDATE_ROW' , 1 ) ;
1260: END IF;
1261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1262: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1263: IF l_debug_level > 0 THEN

Line 1264: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_LINE_SCREDIT_UTIL.UPDATE_ROW' ) ;

1260: END IF;
1261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1262: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1263: IF l_debug_level > 0 THEN
1264: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_LINE_SCREDIT_UTIL.UPDATE_ROW' ) ;
1265: END IF;
1266: IF l_debug_level > 0 THEN
1267: oe_debug_pub.add( 'EXITING OE_LINE_SCREDIT_UTIL.UPDATE_ROW' , 1 ) ;
1268: END IF;

Line 1267: oe_debug_pub.add( 'EXITING OE_LINE_SCREDIT_UTIL.UPDATE_ROW' , 1 ) ;

1263: IF l_debug_level > 0 THEN
1264: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_LINE_SCREDIT_UTIL.UPDATE_ROW' ) ;
1265: END IF;
1266: IF l_debug_level > 0 THEN
1267: oe_debug_pub.add( 'EXITING OE_LINE_SCREDIT_UTIL.UPDATE_ROW' , 1 ) ;
1268: END IF;
1269: RAISE FND_API.G_EXC_ERROR;
1270: END IF;
1271: -- notification framework end

Line 1276: oe_debug_pub.add( 'EXITING OE_LINE_SCREDIT_UTIL.UPDATE_ROW' , 1 ) ;

1272: END IF; /* code set is pack H or higher */
1273: /* jolin end*/
1274:
1275: IF l_debug_level > 0 THEN
1276: oe_debug_pub.add( 'EXITING OE_LINE_SCREDIT_UTIL.UPDATE_ROW' , 1 ) ;
1277: END IF;
1278:
1279: EXCEPTION
1280:

Line 1314: oe_debug_pub.add( 'ENTERING OE_LINE_SCREDIT_UTIL.INSERT_ROW' , 1 ) ;

1310: --
1311: BEGIN
1312:
1313: IF l_debug_level > 0 THEN
1314: oe_debug_pub.add( 'ENTERING OE_LINE_SCREDIT_UTIL.INSERT_ROW' , 1 ) ;
1315: END IF;
1316:
1317: INSERT INTO OE_SALES_CREDITS
1318: ( ATTRIBUTE1

Line 1407: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_LINE_SCREDIT_UTIL.INSERT_ROW IS: ' || L_RETURN_STATUS ) ;

1403: x_index => l_index,
1404: x_return_status => l_return_status);
1405:
1406: IF l_debug_level > 0 THEN
1407: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_LINE_SCREDIT_UTIL.INSERT_ROW IS: ' || L_RETURN_STATUS ) ;
1408: END IF;
1409: IF l_debug_level > 0 THEN
1410: oe_debug_pub.add( 'RETURNED INDEX IS: ' || L_INDEX , 1 ) ;
1411: END IF;

Line 1418: oe_debug_pub.add( 'EXITING OE_LINE_SCREDIT_UTIL.INSERT_ROW' , 1 ) ;

1414: IF l_debug_level > 0 THEN
1415: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
1416: END IF;
1417: IF l_debug_level > 0 THEN
1418: oe_debug_pub.add( 'EXITING OE_LINE_SCREDIT_UTIL.INSERT_ROW' , 1 ) ;
1419: END IF;
1420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1421: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1422: IF l_debug_level > 0 THEN

Line 1423: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_LINE_SCREDIT_UTIL.INSERT_ROW' ) ;

1419: END IF;
1420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1421: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1422: IF l_debug_level > 0 THEN
1423: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_LINE_SCREDIT_UTIL.INSERT_ROW' ) ;
1424: END IF;
1425: IF l_debug_level > 0 THEN
1426: oe_debug_pub.add( 'EXITING OE_LINE_SCREDIT_UTIL.INSERT_ROW' , 1 ) ;
1427: END IF;

Line 1426: oe_debug_pub.add( 'EXITING OE_LINE_SCREDIT_UTIL.INSERT_ROW' , 1 ) ;

1422: IF l_debug_level > 0 THEN
1423: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_LINE_SCREDIT_UTIL.INSERT_ROW' ) ;
1424: END IF;
1425: IF l_debug_level > 0 THEN
1426: oe_debug_pub.add( 'EXITING OE_LINE_SCREDIT_UTIL.INSERT_ROW' , 1 ) ;
1427: END IF;
1428: RAISE FND_API.G_EXC_ERROR;
1429: END IF;
1430: -- notification framework end

Line 1435: oe_debug_pub.add( 'EXITING OE_LINE_SCREDIT_UTIL.INSERT_ROW' , 1 ) ;

1431: END IF; /* code set is pack H or higher */
1432: /* jolin end*/
1433:
1434: IF l_debug_level > 0 THEN
1435: oe_debug_pub.add( 'EXITING OE_LINE_SCREDIT_UTIL.INSERT_ROW' , 1 ) ;
1436: END IF;
1437:
1438: EXCEPTION
1439:

Line 1481: oe_debug_pub.add( 'ENTERING OE_LINE_SCREDIT_UTIL.DELETE_ROW' , 1 ) ;

1477: --
1478: BEGIN
1479:
1480: IF l_debug_level > 0 THEN
1481: oe_debug_pub.add( 'ENTERING OE_LINE_SCREDIT_UTIL.DELETE_ROW' , 1 ) ;
1482: END IF;
1483:
1484: IF p_line_id <> FND_API.G_MISS_NUM
1485: THEN

Line 1492: OE_LINE_SCREDIT_UTIL.Query_Row(p_sales_credit_id => l_scr.sales_credit_id,

1488: /* jolin start*/
1489: --added for notification framework
1490: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN
1491: --query line scredit record, then call notification framework to update global picture.
1492: OE_LINE_SCREDIT_UTIL.Query_Row(p_sales_credit_id => l_scr.sales_credit_id,
1493: x_line_scredit_rec =>l_line_scredit_rec);
1494:
1495: IF l_debug_level > 0 THEN
1496: oe_debug_pub.add( 'IN DELETE ROW , SALES_CREDIT_ID= '|| L_SCR.SALES_CREDIT_ID , 1 ) ;

Line 1512: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_LINE_SCREDIT_UTIL.DELETE_ROW IS: ' || L_RETURN_STATUS ) ;

1508: x_index => l_index,
1509: x_return_status => l_return_status);
1510:
1511: IF l_debug_level > 0 THEN
1512: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_LINE_SCREDIT_UTIL.DELETE_ROW IS: ' || L_RETURN_STATUS ) ;
1513: END IF;
1514:
1515: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1516: IF l_debug_level > 0 THEN

Line 1520: oe_debug_pub.add( 'EXITING OE_LINE_SCREDIT_UTIL.DELETE_ROW' , 1 ) ;

1516: IF l_debug_level > 0 THEN
1517: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
1518: END IF;
1519: IF l_debug_level > 0 THEN
1520: oe_debug_pub.add( 'EXITING OE_LINE_SCREDIT_UTIL.DELETE_ROW' , 1 ) ;
1521: END IF;
1522: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1523: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1524: IF l_debug_level > 0 THEN

Line 1525: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_LINE_SCREDIT_UTIL.DELETE_ROW' ) ;

1521: END IF;
1522: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1523: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1524: IF l_debug_level > 0 THEN
1525: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_LINE_SCREDIT_UTIL.DELETE_ROW' ) ;
1526: END IF;
1527: IF l_debug_level > 0 THEN
1528: oe_debug_pub.add( 'EXITING OE_LINE_SCREDIT_UTIL.DELETE_ROW' , 1 ) ;
1529: END IF;

Line 1528: oe_debug_pub.add( 'EXITING OE_LINE_SCREDIT_UTIL.DELETE_ROW' , 1 ) ;

1524: IF l_debug_level > 0 THEN
1525: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_LINE_SCREDIT_UTIL.DELETE_ROW' ) ;
1526: END IF;
1527: IF l_debug_level > 0 THEN
1528: oe_debug_pub.add( 'EXITING OE_LINE_SCREDIT_UTIL.DELETE_ROW' , 1 ) ;
1529: END IF;
1530: RAISE FND_API.G_EXC_ERROR;
1531: END IF;
1532:

Line 1569: OE_LINE_SCREDIT_UTIL.Query_Row(p_sales_credit_id => p_sales_credit_id,

1565: /* jolin start*/
1566: --added for notification framework
1567: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN
1568: --query line scredit record, then call notification framework to update global picture.
1569: OE_LINE_SCREDIT_UTIL.Query_Row(p_sales_credit_id => p_sales_credit_id,
1570: x_line_scredit_rec =>l_line_scredit_rec);
1571:
1572: IF l_debug_level > 0 THEN
1573: oe_debug_pub.add( 'IN DELETE ROW , LINE_ID IS G_MISS_NUM , SALES_CREDIT_ID= '|| P_SALES_CREDIT_ID , 1 ) ;

Line 1589: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_LINE_SCREDIT_UTIL.DELETE_ROW IS: ' || L_RETURN_STATUS ) ;

1585: x_index => l_index,
1586: x_return_status => l_return_status);
1587:
1588: IF l_debug_level > 0 THEN
1589: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_LINE_SCREDIT_UTIL.DELETE_ROW IS: ' || L_RETURN_STATUS ) ;
1590: END IF;
1591:
1592: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1593: IF l_debug_level > 0 THEN

Line 1597: oe_debug_pub.add( 'EXITING OE_LINE_SCREDIT_UTIL.DELETE_ROW' , 1 ) ;

1593: IF l_debug_level > 0 THEN
1594: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
1595: END IF;
1596: IF l_debug_level > 0 THEN
1597: oe_debug_pub.add( 'EXITING OE_LINE_SCREDIT_UTIL.DELETE_ROW' , 1 ) ;
1598: END IF;
1599: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1600: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1601: IF l_debug_level > 0 THEN

Line 1602: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_LINE_SCREDIT_UTIL.DELETE_ROW' ) ;

1598: END IF;
1599: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1600: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1601: IF l_debug_level > 0 THEN
1602: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_LINE_SCREDIT_UTIL.DELETE_ROW' ) ;
1603: END IF;
1604: IF l_debug_level > 0 THEN
1605: oe_debug_pub.add( 'EXITING OE_LINE_SCREDIT_UTIL.DELETE_ROW' , 1 ) ;
1606: END IF;

Line 1605: oe_debug_pub.add( 'EXITING OE_LINE_SCREDIT_UTIL.DELETE_ROW' , 1 ) ;

1601: IF l_debug_level > 0 THEN
1602: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_LINE_SCREDIT_UTIL.DELETE_ROW' ) ;
1603: END IF;
1604: IF l_debug_level > 0 THEN
1605: oe_debug_pub.add( 'EXITING OE_LINE_SCREDIT_UTIL.DELETE_ROW' , 1 ) ;
1606: END IF;
1607: RAISE FND_API.G_EXC_ERROR;
1608: END IF;
1609:

Line 1641: oe_debug_pub.add( 'EXITING OE_LINE_SCREDIT_UTIL.DELETE_ROW' , 1 ) ;

1637: ;
1638: END IF;
1639:
1640: IF l_debug_level > 0 THEN
1641: oe_debug_pub.add( 'EXITING OE_LINE_SCREDIT_UTIL.DELETE_ROW' , 1 ) ;
1642: END IF;
1643:
1644: EXCEPTION
1645:

Line 1674: oe_debug_pub.add( 'ENTERING OE_LINE_SCREDIT_UTIL.QUERY_ROW' , 1 ) ;

1670: --
1671: BEGIN
1672:
1673: IF l_debug_level > 0 THEN
1674: oe_debug_pub.add( 'ENTERING OE_LINE_SCREDIT_UTIL.QUERY_ROW' , 1 ) ;
1675: END IF;
1676:
1677: Query_Rows
1678: ( p_sales_credit_id => p_sales_credit_id

Line 1936: oe_debug_pub.add( 'EXITING OE_LINE_SCREDIT_UTIL.QUERY_ROWS' , 1 ) ;

1932:
1933: -- Return fetched table
1934:
1935: IF l_debug_level > 0 THEN
1936: oe_debug_pub.add( 'EXITING OE_LINE_SCREDIT_UTIL.QUERY_ROWS' , 1 ) ;
1937: END IF;
1938:
1939:
1940: EXCEPTION

Line 1979: oe_debug_pub.add( 'ENTERING OE_LINE_SCREDIT_UTIL.LOCK_ROW' , 1 ) ;

1975: --
1976: BEGIN
1977:
1978: IF l_debug_level > 0 THEN
1979: oe_debug_pub.add( 'ENTERING OE_LINE_SCREDIT_UTIL.LOCK_ROW' , 1 ) ;
1980: END IF;
1981:
1982: SAVEPOINT Lock_Row;
1983:

Line 2004: OE_Line_Scredit_Util.Query_Row

2000: IF l_debug_level > 0 THEN
2001: oe_debug_pub.add( 'SELECTED FOR UPDATE' , 1 ) ;
2002: END IF;
2003:
2004: OE_Line_Scredit_Util.Query_Row
2005: (p_sales_credit_id => l_sales_credit_id
2006: ,x_line_scredit_rec => p_x_line_scredit_rec );
2007:
2008:

Line 2054: oe_debug_pub.add( 'EXITING OE_LINE_SCREDIT_UTIL.LOCK_ROW' , 1 ) ;

2050:
2051: END IF;
2052:
2053: IF l_debug_level > 0 THEN
2054: oe_debug_pub.add( 'EXITING OE_LINE_SCREDIT_UTIL.LOCK_ROW' , 1 ) ;
2055: END IF;
2056:
2057: EXCEPTION
2058:

Line 2184: OE_Line_Scredit_Util.Query_Rows

2180: END;
2181:
2182: -- locked all
2183:
2184: OE_Line_Scredit_Util.Query_Rows
2185: (p_sales_credit_id => p_sales_credit_id
2186: ,p_line_id => p_line_id
2187: ,x_line_scredit_tbl => x_line_scredit_tbl
2188: );

Line 2484: OE_Line_Scredit_Util.Lock_Rows

2480: RAISE FND_API.G_EXC_ERROR;
2481:
2482: elsif l_sales_credits_count = 1 then -- update with new salesrep
2483:
2484: OE_Line_Scredit_Util.Lock_Rows
2485: ( p_sales_credit_id => l_sales_credit_id,
2486: x_line_scredit_tbl => l_old_line_scredit_tbl,
2487: x_return_status => l_return_status
2488: );

Line 2504: OE_Line_Scredit_Util.Delete_Row

2500:
2501: /*Added to fix bug 6445046 START*/
2502: IF l_scredit_Type_id IS NULL THEN
2503: oe_debug_pub.add( 'Row in the sales credit table is being removed as the sales peason is removed.' ) ;
2504: OE_Line_Scredit_Util.Delete_Row
2505: ( p_sales_credit_id => l_sales_credit_id,
2506: p_line_id => p_line_rec.line_id
2507: );
2508:

Line 2782: END OE_Line_Scredit_Util;

2778:
2779: END Pre_Write_Process;
2780: /* End AuditTrail */
2781:
2782: END OE_Line_Scredit_Util;