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_HEADER_SCREDIT_UTIL dependencies on OE_HEADER_SCREDIT_UTIL

Line 1: PACKAGE BODY OE_Header_Scredit_Util AS

1: PACKAGE BODY OE_Header_Scredit_Util AS
2: /* $Header: OEXUHSCB.pls 120.0.12000000.2 2007/04/13 12:25:46 sgoli ship $ */
3:
4: -- Global constant holding the package name
5:

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

2: /* $Header: OEXUHSCB.pls 120.0.12000000.2 2007/04/13 12:25:46 sgoli ship $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Header_Scredit_Util';
7: G_ACTIVATE_ORCL_CUSTOMIZATION VARCHAR2(1):= NVL(FND_PROFILE.VALUE('ONT_ACTIVATE_ORACLE_CUSTOMIZATION'),'N');
8: G_ORG_ID NUMBER;
9: FUNCTION G_MISS_OE_AK_HSCREDIT_REC
10: RETURN OE_AK_HEADER_SCREDITS_V%ROWTYPE IS

Line 172: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE1;

168:
169: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute1,p_old_Header_Scredit_rec.attribute1)
170: THEN
171: l_index := l_index + 1;
172: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE1;
173: END IF;
174:
175: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute10,p_old_Header_Scredit_rec.attribute10)
176: THEN

Line 178: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE10;

174:
175: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute10,p_old_Header_Scredit_rec.attribute10)
176: THEN
177: l_index := l_index + 1;
178: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE10;
179: END IF;
180:
181: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute11,p_old_Header_Scredit_rec.attribute11)
182: THEN

Line 184: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE11;

180:
181: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute11,p_old_Header_Scredit_rec.attribute11)
182: THEN
183: l_index := l_index + 1;
184: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE11;
185: END IF;
186:
187: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute12,p_old_Header_Scredit_rec.attribute12)
188: THEN

Line 190: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE12;

186:
187: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute12,p_old_Header_Scredit_rec.attribute12)
188: THEN
189: l_index := l_index + 1;
190: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE12;
191: END IF;
192:
193: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute13,p_old_Header_Scredit_rec.attribute13)
194: THEN

Line 196: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE13;

192:
193: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute13,p_old_Header_Scredit_rec.attribute13)
194: THEN
195: l_index := l_index + 1;
196: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE13;
197: END IF;
198:
199: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute14,p_old_Header_Scredit_rec.attribute14)
200: THEN

Line 202: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE14;

198:
199: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute14,p_old_Header_Scredit_rec.attribute14)
200: THEN
201: l_index := l_index + 1;
202: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE14;
203: END IF;
204:
205: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute15,p_old_Header_Scredit_rec.attribute15)
206: THEN

Line 208: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE15;

204:
205: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute15,p_old_Header_Scredit_rec.attribute15)
206: THEN
207: l_index := l_index + 1;
208: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE15;
209: END IF;
210:
211: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute2,p_old_Header_Scredit_rec.attribute2)
212: THEN

Line 214: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE2;

210:
211: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute2,p_old_Header_Scredit_rec.attribute2)
212: THEN
213: l_index := l_index + 1;
214: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE2;
215: END IF;
216:
217: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute3,p_old_Header_Scredit_rec.attribute3)
218: THEN

Line 220: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE3;

216:
217: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute3,p_old_Header_Scredit_rec.attribute3)
218: THEN
219: l_index := l_index + 1;
220: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE3;
221: END IF;
222:
223: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute4,p_old_Header_Scredit_rec.attribute4)
224: THEN

Line 226: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE4;

222:
223: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute4,p_old_Header_Scredit_rec.attribute4)
224: THEN
225: l_index := l_index + 1;
226: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE4;
227: END IF;
228:
229: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute5,p_old_Header_Scredit_rec.attribute5)
230: THEN

Line 232: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE5;

228:
229: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute5,p_old_Header_Scredit_rec.attribute5)
230: THEN
231: l_index := l_index + 1;
232: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE5;
233: END IF;
234:
235: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute6,p_old_Header_Scredit_rec.attribute6)
236: THEN

Line 238: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE6;

234:
235: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute6,p_old_Header_Scredit_rec.attribute6)
236: THEN
237: l_index := l_index + 1;
238: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE6;
239: END IF;
240:
241: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute7,p_old_Header_Scredit_rec.attribute7)
242: THEN

Line 244: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE7;

240:
241: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute7,p_old_Header_Scredit_rec.attribute7)
242: THEN
243: l_index := l_index + 1;
244: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE7;
245: END IF;
246:
247: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute8,p_old_Header_Scredit_rec.attribute8)
248: THEN

Line 250: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE8;

246:
247: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute8,p_old_Header_Scredit_rec.attribute8)
248: THEN
249: l_index := l_index + 1;
250: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE8;
251: END IF;
252:
253: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute9,p_old_Header_Scredit_rec.attribute9)
254: THEN

Line 256: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE9;

252:
253: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute9,p_old_Header_Scredit_rec.attribute9)
254: THEN
255: l_index := l_index + 1;
256: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE9;
257: END IF;
258:
259: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.context,p_old_Header_Scredit_rec.context)
260: THEN

Line 262: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_CONTEXT;

258:
259: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.context,p_old_Header_Scredit_rec.context)
260: THEN
261: l_index := l_index + 1;
262: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_CONTEXT;
263: END IF;
264:
265: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.created_by,p_old_Header_Scredit_rec.created_by)
266: THEN

Line 268: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_CREATED_BY;

264:
265: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.created_by,p_old_Header_Scredit_rec.created_by)
266: THEN
267: l_index := l_index + 1;
268: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_CREATED_BY;
269: END IF;
270:
271: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.creation_date,p_old_Header_Scredit_rec.creation_date)
272: THEN

Line 274: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_CREATION_DATE;

270:
271: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.creation_date,p_old_Header_Scredit_rec.creation_date)
272: THEN
273: l_index := l_index + 1;
274: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_CREATION_DATE;
275: END IF;
276:
277: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.dw_update_advice_flag,p_old_Header_Scredit_rec.dw_update_advice_flag)
278: THEN

Line 280: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_DW_UPDATE_ADVICE;

276:
277: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.dw_update_advice_flag,p_old_Header_Scredit_rec.dw_update_advice_flag)
278: THEN
279: l_index := l_index + 1;
280: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_DW_UPDATE_ADVICE;
281: END IF;
282:
283: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.header_id,p_old_Header_Scredit_rec.header_id)
284: THEN

Line 286: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_HEADER;

282:
283: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.header_id,p_old_Header_Scredit_rec.header_id)
284: THEN
285: l_index := l_index + 1;
286: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_HEADER;
287: END IF;
288:
289: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.last_updated_by,p_old_Header_Scredit_rec.last_updated_by)
290: THEN

Line 292: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_LAST_UPDATED_BY;

288:
289: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.last_updated_by,p_old_Header_Scredit_rec.last_updated_by)
290: THEN
291: l_index := l_index + 1;
292: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_LAST_UPDATED_BY;
293: END IF;
294:
295: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.last_update_date,p_old_Header_Scredit_rec.last_update_date)
296: THEN

Line 298: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_LAST_UPDATE_DATE;

294:
295: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.last_update_date,p_old_Header_Scredit_rec.last_update_date)
296: THEN
297: l_index := l_index + 1;
298: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_LAST_UPDATE_DATE;
299: END IF;
300:
301: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.last_update_login,p_old_Header_Scredit_rec.last_update_login)
302: THEN

Line 304: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_LAST_UPDATE_LOGIN;

300:
301: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.last_update_login,p_old_Header_Scredit_rec.last_update_login)
302: THEN
303: l_index := l_index + 1;
304: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_LAST_UPDATE_LOGIN;
305: END IF;
306:
307: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.line_id,p_old_Header_Scredit_rec.line_id)
308: THEN

Line 310: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_LINE;

306:
307: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.line_id,p_old_Header_Scredit_rec.line_id)
308: THEN
309: l_index := l_index + 1;
310: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_LINE;
311: END IF;
312:
313: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.percent,p_old_Header_Scredit_rec.percent)
314: THEN

Line 316: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_PERCENT;

312:
313: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.percent,p_old_Header_Scredit_rec.percent)
314: THEN
315: l_index := l_index + 1;
316: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_PERCENT;
317: END IF;
318:
319:
320: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.salesrep_id,p_old_Header_Scredit_rec.salesrep_id)

Line 323: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_SALESREP;

319:
320: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.salesrep_id,p_old_Header_Scredit_rec.salesrep_id)
321: THEN
322: l_index := l_index + 1;
323: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_SALESREP;
324: END IF;
325: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.sales_credit_type_id,p_old_Header_Scredit_rec.sales_credit_type_id)
326: THEN
327: l_index := l_index + 1;

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

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

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

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

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

336:
337: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.wh_update_date,p_old_Header_Scredit_rec.wh_update_date)
338: THEN
339: l_index := l_index + 1;
340: l_src_attr_tbl(l_index) := OE_HEADER_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_HEADER_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_HEADER_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_HEADER_SCREDIT_UTIL.G_ATTRIBUTE10;
349: ELSIF p_attr_id = G_ATTRIBUTE11 THEN

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

344: l_index := l_index + 1;
345: l_src_attr_tbl(l_index) := OE_HEADER_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_HEADER_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_HEADER_SCREDIT_UTIL.G_ATTRIBUTE11;
352: ELSIF p_attr_id = G_ATTRIBUTE12 THEN

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

347: l_index := l_index + 1;
348: l_src_attr_tbl(l_index) := OE_HEADER_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_HEADER_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_HEADER_SCREDIT_UTIL.G_ATTRIBUTE12;
355: ELSIF p_attr_id = G_ATTRIBUTE13 THEN

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

350: l_index := l_index + 1;
351: l_src_attr_tbl(l_index) := OE_HEADER_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_HEADER_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_HEADER_SCREDIT_UTIL.G_ATTRIBUTE13;
358: ELSIF p_attr_id = G_ATTRIBUTE14 THEN

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

353: l_index := l_index + 1;
354: l_src_attr_tbl(l_index) := OE_HEADER_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_HEADER_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_HEADER_SCREDIT_UTIL.G_ATTRIBUTE14;
361: ELSIF p_attr_id = G_ATTRIBUTE15 THEN

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

356: l_index := l_index + 1;
357: l_src_attr_tbl(l_index) := OE_HEADER_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_HEADER_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_HEADER_SCREDIT_UTIL.G_ATTRIBUTE15;
364: ELSIF p_attr_id = G_ATTRIBUTE2 THEN

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

359: l_index := l_index + 1;
360: l_src_attr_tbl(l_index) := OE_HEADER_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_HEADER_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_HEADER_SCREDIT_UTIL.G_ATTRIBUTE2;
367: ELSIF p_attr_id = G_ATTRIBUTE3 THEN

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

362: l_index := l_index + 1;
363: l_src_attr_tbl(l_index) := OE_HEADER_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_HEADER_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_HEADER_SCREDIT_UTIL.G_ATTRIBUTE3;
370: ELSIF p_attr_id = G_ATTRIBUTE4 THEN

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

365: l_index := l_index + 1;
366: l_src_attr_tbl(l_index) := OE_HEADER_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_HEADER_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_HEADER_SCREDIT_UTIL.G_ATTRIBUTE4;
373: ELSIF p_attr_id = G_ATTRIBUTE5 THEN

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

368: l_index := l_index + 1;
369: l_src_attr_tbl(l_index) := OE_HEADER_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_HEADER_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_HEADER_SCREDIT_UTIL.G_ATTRIBUTE5;
376: ELSIF p_attr_id = G_ATTRIBUTE6 THEN

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

371: l_index := l_index + 1;
372: l_src_attr_tbl(l_index) := OE_HEADER_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_HEADER_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_HEADER_SCREDIT_UTIL.G_ATTRIBUTE6;
379: ELSIF p_attr_id = G_ATTRIBUTE7 THEN

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

374: l_index := l_index + 1;
375: l_src_attr_tbl(l_index) := OE_HEADER_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_HEADER_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_HEADER_SCREDIT_UTIL.G_ATTRIBUTE7;
382: ELSIF p_attr_id = G_ATTRIBUTE8 THEN

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

377: l_index := l_index + 1;
378: l_src_attr_tbl(l_index) := OE_HEADER_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_HEADER_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_HEADER_SCREDIT_UTIL.G_ATTRIBUTE8;
385: ELSIF p_attr_id = G_ATTRIBUTE9 THEN

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

380: l_index := l_index + 1;
381: l_src_attr_tbl(l_index) := OE_HEADER_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_HEADER_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_HEADER_SCREDIT_UTIL.G_ATTRIBUTE9;
388: ELSIF p_attr_id = G_CONTEXT THEN

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

383: l_index := l_index + 1;
384: l_src_attr_tbl(l_index) := OE_HEADER_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_HEADER_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_HEADER_SCREDIT_UTIL.G_CONTEXT;
391: ELSIF p_attr_id = G_CREATED_BY THEN

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

386: l_index := l_index + 1;
387: l_src_attr_tbl(l_index) := OE_HEADER_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_HEADER_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_HEADER_SCREDIT_UTIL.G_CREATED_BY;
394: ELSIF p_attr_id = G_CREATION_DATE THEN

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

389: l_index := l_index + 1;
390: l_src_attr_tbl(l_index) := OE_HEADER_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_HEADER_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_HEADER_SCREDIT_UTIL.G_CREATION_DATE;
397: ELSIF p_attr_id = G_DW_UPDATE_ADVICE THEN

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

392: l_index := l_index + 1;
393: l_src_attr_tbl(l_index) := OE_HEADER_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_HEADER_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_HEADER_SCREDIT_UTIL.G_DW_UPDATE_ADVICE;
400: ELSIF p_attr_id = G_HEADER THEN

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

395: l_index := l_index + 1;
396: l_src_attr_tbl(l_index) := OE_HEADER_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_HEADER_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_HEADER_SCREDIT_UTIL.G_HEADER;
403: ELSIF p_attr_id = G_LAST_UPDATED_BY THEN

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

398: l_index := l_index + 1;
399: l_src_attr_tbl(l_index) := OE_HEADER_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_HEADER_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_HEADER_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_HEADER_SCREDIT_UTIL.G_LAST_UPDATED_BY;

401: l_index := l_index + 1;
402: l_src_attr_tbl(l_index) := OE_HEADER_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_HEADER_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_HEADER_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_HEADER_SCREDIT_UTIL.G_LAST_UPDATE_DATE;

404: l_index := l_index + 1;
405: l_src_attr_tbl(l_index) := OE_HEADER_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_HEADER_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_HEADER_SCREDIT_UTIL.G_LAST_UPDATE_LOGIN;
412: ELSIF p_attr_id = G_LINE THEN

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

407: l_index := l_index + 1;
408: l_src_attr_tbl(l_index) := OE_HEADER_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_HEADER_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_HEADER_SCREDIT_UTIL.G_LINE;
415: ELSIF p_attr_id = G_PERCENT THEN

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

410: l_index := l_index + 1;
411: l_src_attr_tbl(l_index) := OE_HEADER_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_HEADER_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_HEADER_SCREDIT_UTIL.G_PERCENT;
418: ELSIF p_attr_id = G_SALESREP THEN

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

413: l_index := l_index + 1;
414: l_src_attr_tbl(l_index) := OE_HEADER_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_HEADER_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_HEADER_SCREDIT_UTIL.G_SALESREP;
421: ELSIF p_attr_id = G_sales_credit_type THEN

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

416: l_index := l_index + 1;
417: l_src_attr_tbl(l_index) := OE_HEADER_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_HEADER_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_HEADER_SCREDIT_UTIL.G_sales_credit_type;
424: ELSIF p_attr_id = G_SALES_CREDIT THEN

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

419: l_index := l_index + 1;
420: l_src_attr_tbl(l_index) := OE_HEADER_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_HEADER_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_HEADER_SCREDIT_UTIL.G_SALES_CREDIT;
427: ELSIF p_attr_id = G_WH_UPDATE_DATE THEN

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

422: l_index := l_index + 1;
423: l_src_attr_tbl(l_index) := OE_HEADER_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_HEADER_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_HEADER_SCREDIT_UTIL.G_WH_UPDATE_DATE;
430: END IF;

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

425: l_index := l_index + 1;
426: l_src_attr_tbl(l_index) := OE_HEADER_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_HEADER_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_HEADER_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_HEADER_SCREDIT_UTIL.G_ATTRIBUTE1 THEN
441: p_x_Header_Scredit_rec.ATTRIBUTE1 := FND_API.G_MISS_NUM;
442: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE10 THEN
443: p_x_Header_Scredit_rec.ATTRIBUTE10 := FND_API.G_MISS_CHAR;
444: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE11 THEN

Line 442: ELSIF l_dep_attr_tbl(I) = OE_HEADER_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_HEADER_SCREDIT_UTIL.G_ATTRIBUTE1 THEN
441: p_x_Header_Scredit_rec.ATTRIBUTE1 := FND_API.G_MISS_NUM;
442: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE10 THEN
443: p_x_Header_Scredit_rec.ATTRIBUTE10 := FND_API.G_MISS_CHAR;
444: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE11 THEN
445: p_x_Header_Scredit_rec.ATTRIBUTE11 := FND_API.G_MISS_CHAR;
446: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE12 THEN

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1085: p_hdr_scr_id => p_header_scredit_rec.sales_credit_id,
1086: x_index => l_index,
1087: x_return_status => l_return_status);
1088: IF l_debug_level > 0 THEN
1089: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_HEADER_SCREDIT_UTIL.UPDATE_ROW IS: ' || L_RETURN_STATUS ) ;
1090: END IF;
1091: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1092: IF l_debug_level > 0 THEN
1093: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;

Line 1096: oe_debug_pub.add( 'EXITING OE_HEADER_SCREDIT_UTIL.UPDATE_ROW' , 1 ) ;

1092: IF l_debug_level > 0 THEN
1093: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
1094: END IF;
1095: IF l_debug_level > 0 THEN
1096: oe_debug_pub.add( 'EXITING OE_HEADER_SCREDIT_UTIL.UPDATE_ROW' , 1 ) ;
1097: END IF;
1098: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1099: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1100: IF l_debug_level > 0 THEN

Line 1101: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_SCREDIT_UTIL.UPDATE_ROW' ) ;

1097: END IF;
1098: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1099: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1100: IF l_debug_level > 0 THEN
1101: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_SCREDIT_UTIL.UPDATE_ROW' ) ;
1102: END IF;
1103: IF l_debug_level > 0 THEN
1104: oe_debug_pub.add( 'EXITING OE_HEADER_SCREDIT_UTIL.UPDATE_ROW' , 1 ) ;
1105: END IF;

Line 1104: oe_debug_pub.add( 'EXITING OE_HEADER_SCREDIT_UTIL.UPDATE_ROW' , 1 ) ;

1100: IF l_debug_level > 0 THEN
1101: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_SCREDIT_UTIL.UPDATE_ROW' ) ;
1102: END IF;
1103: IF l_debug_level > 0 THEN
1104: oe_debug_pub.add( 'EXITING OE_HEADER_SCREDIT_UTIL.UPDATE_ROW' , 1 ) ;
1105: END IF;
1106: RAISE FND_API.G_EXC_ERROR;
1107: END IF;
1108: END IF; /*code_release_level*/

Line 1181: oe_debug_pub.add( 'ENTERING OE_HEADER_SCREDIT_UTIL.INSERT_ROW' , 1 ) ;

1177: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1178: --
1179: BEGIN
1180: IF l_debug_level > 0 THEN
1181: oe_debug_pub.add( 'ENTERING OE_HEADER_SCREDIT_UTIL.INSERT_ROW' , 1 ) ;
1182: END IF;
1183:
1184: INSERT INTO OE_SALES_CREDITS
1185: ( ATTRIBUTE1

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

1267: p_hdr_scr_id => p_header_scredit_rec.sales_credit_id,
1268: x_index => l_index,
1269: x_return_status => l_return_status);
1270: IF l_debug_level > 0 THEN
1271: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_HEADER_SCREDIT_UTIL.INSERT_ROW IS: ' || L_RETURN_STATUS ) ;
1272: END IF;
1273: IF l_debug_level > 0 THEN
1274: oe_debug_pub.add( 'RETURNED INDEX IS: ' || L_INDEX , 1 ) ;
1275: END IF;

Line 1282: oe_debug_pub.add( 'EXITING OE_HEADER_SCREDIT_UTIL.INSERT_ROW' , 1 ) ;

1278: IF l_debug_level > 0 THEN
1279: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
1280: END IF;
1281: IF l_debug_level > 0 THEN
1282: oe_debug_pub.add( 'EXITING OE_HEADER_SCREDIT_UTIL.INSERT_ROW' , 1 ) ;
1283: END IF;
1284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1285: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1286: IF l_debug_level > 0 THEN

Line 1287: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_SCREDIT_UTIL.INSERT_ROW' ) ;

1283: END IF;
1284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1285: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1286: IF l_debug_level > 0 THEN
1287: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_SCREDIT_UTIL.INSERT_ROW' ) ;
1288: END IF;
1289: IF l_debug_level > 0 THEN
1290: oe_debug_pub.add( 'EXITING OE_HEADER_SCREDIT_UTIL.INSERT_ROW' , 1 ) ;
1291: END IF;

Line 1290: oe_debug_pub.add( 'EXITING OE_HEADER_SCREDIT_UTIL.INSERT_ROW' , 1 ) ;

1286: IF l_debug_level > 0 THEN
1287: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_SCREDIT_UTIL.INSERT_ROW' ) ;
1288: END IF;
1289: IF l_debug_level > 0 THEN
1290: oe_debug_pub.add( 'EXITING OE_HEADER_SCREDIT_UTIL.INSERT_ROW' , 1 ) ;
1291: END IF;
1292: RAISE FND_API.G_EXC_ERROR;
1293: END IF;
1294: END IF; /*code_release_level*/

Line 1298: oe_debug_pub.add( 'EXITING OE_HEADER_SCREDIT_UTIL.INSERT_ROW' , 1 ) ;

1294: END IF; /*code_release_level*/
1295: -- notification framework end
1296:
1297: IF l_debug_level > 0 THEN
1298: oe_debug_pub.add( 'EXITING OE_HEADER_SCREDIT_UTIL.INSERT_ROW' , 1 ) ;
1299: END IF;
1300:
1301: EXCEPTION
1302:

Line 1339: oe_debug_pub.add( 'ENTERING OE_HEADER_SCREDIT_UTIL.DELETE_ROW' , 1 ) ;

1335: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1336: --
1337: BEGIN
1338: IF l_debug_level > 0 THEN
1339: oe_debug_pub.add( 'ENTERING OE_HEADER_SCREDIT_UTIL.DELETE_ROW' , 1 ) ;
1340: END IF;
1341:
1342: IF p_header_id <> FND_API.G_MISS_NUM
1343: THEN

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

1355: p_hdr_scr_id => l_scr.sales_credit_id,
1356: x_index => l_index,
1357: x_return_status => l_return_status);
1358: IF l_debug_level > 0 THEN
1359: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_HEADER_SCREDIT_UTIL.DELETE_ROW IS: ' || L_RETURN_STATUS ) ;
1360: END IF;
1361: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1362: IF l_debug_level > 0 THEN
1363: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;

Line 1366: oe_debug_pub.add( 'EXITING OE_HEADER_SCREDIT_UTIL.DELETE_ROW' , 1 ) ;

1362: IF l_debug_level > 0 THEN
1363: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
1364: END IF;
1365: IF l_debug_level > 0 THEN
1366: oe_debug_pub.add( 'EXITING OE_HEADER_SCREDIT_UTIL.DELETE_ROW' , 1 ) ;
1367: END IF;
1368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1369: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1370: IF l_debug_level > 0 THEN

Line 1371: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_SCREDIT_UTIL.DELETE_ROW' ) ;

1367: END IF;
1368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1369: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1370: IF l_debug_level > 0 THEN
1371: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_SCREDIT_UTIL.DELETE_ROW' ) ;
1372: END IF;
1373: IF l_debug_level > 0 THEN
1374: oe_debug_pub.add( 'EXITING OE_HEADER_SCREDIT_UTIL.DELETE_ROW' , 1 ) ;
1375: END IF;

Line 1374: oe_debug_pub.add( 'EXITING OE_HEADER_SCREDIT_UTIL.DELETE_ROW' , 1 ) ;

1370: IF l_debug_level > 0 THEN
1371: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_SCREDIT_UTIL.DELETE_ROW' ) ;
1372: END IF;
1373: IF l_debug_level > 0 THEN
1374: oe_debug_pub.add( 'EXITING OE_HEADER_SCREDIT_UTIL.DELETE_ROW' , 1 ) ;
1375: END IF;
1376: RAISE FND_API.G_EXC_ERROR;
1377: END IF;
1378: END IF; /*code_release_level*/

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

1404: p_hdr_scr_id => p_sales_credit_id,
1405: x_index => l_index,
1406: x_return_status => l_return_status);
1407: IF l_debug_level > 0 THEN
1408: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_HEADER_SCREDIT_UTIL.DELETE_ROW IS: ' || L_RETURN_STATUS ) ;
1409: END IF;
1410:
1411: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1412: IF l_debug_level > 0 THEN

Line 1416: oe_debug_pub.add( 'EXITING OE_HEADER_SCREDIT_UTIL.DELETE_ROW' , 1 ) ;

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

Line 1421: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_SCREDIT_UTIL.DELETE_ROW' ) ;

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

Line 1424: oe_debug_pub.add( 'EXITING OE_HEADER_SCREDIT_UTIL.DELETE_ROW' , 1 ) ;

1420: IF l_debug_level > 0 THEN
1421: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_SCREDIT_UTIL.DELETE_ROW' ) ;
1422: END IF;
1423: IF l_debug_level > 0 THEN
1424: oe_debug_pub.add( 'EXITING OE_HEADER_SCREDIT_UTIL.DELETE_ROW' , 1 ) ;
1425: END IF;
1426: RAISE FND_API.G_EXC_ERROR;
1427: END IF;
1428: END IF; /*code_release_level*/

Line 1736: oe_debug_pub.add( 'ENTERING OE_HEADER_SCREDIT_UTIL.LOCK_ROW' , 1 ) ;

1732: --
1733: BEGIN
1734:
1735: IF l_debug_level > 0 THEN
1736: oe_debug_pub.add( 'ENTERING OE_HEADER_SCREDIT_UTIL.LOCK_ROW' , 1 ) ;
1737: END IF;
1738:
1739: SAVEPOINT Lock_Row;
1740:

Line 1761: OE_Header_Scredit_Util.Query_Row

1757: IF l_debug_level > 0 THEN
1758: oe_debug_pub.add( 'SELECTED FOR UPDATE' , 1 ) ;
1759: END IF;
1760:
1761: OE_Header_Scredit_Util.Query_Row
1762: (p_sales_credit_id => l_sales_credit_id
1763: ,x_header_scredit_rec => p_x_header_scredit_rec );
1764:
1765:

Line 1941: OE_Header_Scredit_Util.Query_Rows

1937: END;
1938:
1939: -- locked all
1940:
1941: OE_Header_Scredit_Util.Query_Rows
1942: (p_sales_credit_id => p_sales_credit_id
1943: ,p_header_id => p_header_id
1944: ,x_header_scredit_tbl => x_header_scredit_tbl
1945: );

Line 2331: oe_debug_pub.add( 'ENTERING OE_HEADER_SCREDIT_UTIL.DFLT_HSCREDIT_PRIMARY_SREP' , 1 ) ;

2327: --
2328: Begin
2329:
2330: IF l_debug_level > 0 THEN
2331: oe_debug_pub.add( 'ENTERING OE_HEADER_SCREDIT_UTIL.DFLT_HSCREDIT_PRIMARY_SREP' , 1 ) ;
2332: END IF;
2333:
2334: BEGIN
2335: SELECT header_id INTO l_header_id

Line 2341: oe_debug_pub.add( 'EXITING OE_HEADER_SCREDIT_UTIL.DFLT_HSCREDIT_PRIMARY_SREP,header not created' , 1 ) ;

2337: WHERE header_id = p_header_id;
2338: EXCEPTION
2339: WHEN NO_DATA_FOUND THEN
2340: IF l_debug_level > 0 THEN
2341: oe_debug_pub.add( 'EXITING OE_HEADER_SCREDIT_UTIL.DFLT_HSCREDIT_PRIMARY_SREP,header not created' , 1 ) ;
2342: END IF;
2343: RETURN;
2344: END;
2345:

Line 2366: OE_Header_Scredit_Util.Lock_Row

2362: ELSIF l_sales_credits_count = 1 THEN */
2363: -- update with new salesrep
2364: -- Commented to fix bug 1589196 End
2365: IF l_sales_credits_count = 1 THEN
2366: OE_Header_Scredit_Util.Lock_Row
2367: ( p_sales_credit_id => l_sales_credit_id
2368: , p_x_Header_Scredit_rec => l_Header_Scredit_rec
2369: , x_return_status => l_return_status
2370: );

Line 2493: oe_debug_pub.add( 'EXITING OE_HEADER_SCREDIT_UTIL.DFLT_HSCREDIT_PRIMARY_SREP' , 1 ) ;

2489: OE_MSG_PUB.Add;
2490: END IF;
2491:
2492: IF l_debug_level > 0 THEN
2493: oe_debug_pub.add( 'EXITING OE_HEADER_SCREDIT_UTIL.DFLT_HSCREDIT_PRIMARY_SREP' , 1 ) ;
2494: END IF;
2495:
2496: EXCEPTION
2497:

Line 2616: Oe_Debug_Pub.add('Exception occured OE_Header_Scredit_Util.Redefaut..:'||SQLERRM);

2612: oe_debug_pub.add('Leaving redefault sales group');
2613: end If;
2614: Exception
2615: When Others Then
2616: Oe_Debug_Pub.add('Exception occured OE_Header_Scredit_Util.Redefaut..:'||SQLERRM);
2617: End;
2618: --SG}
2619:
2620:

Line 2621: END OE_Header_Scredit_Util;

2617: End;
2618: --SG}
2619:
2620:
2621: END OE_Header_Scredit_Util;