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.QP_LIMITS_UTIL dependencies on QP_LIMITS_UTIL

Line 1: PACKAGE BODY QP_Limits_Util AS

1: PACKAGE BODY QP_Limits_Util AS
2: /* $Header: QPXULMTB.pls 120.2.12010000.2 2009/02/04 13:41:05 jputta ship $ */
3:
4: -- Global constant holding the package name
5:

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

2: /* $Header: QPXULMTB.pls 120.2.12010000.2 2009/02/04 13:41:05 jputta ship $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'QP_Limits_Util';
7:
8: PROCEDURE Update_List_Header_And_Line
9: (p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type)
10: IS

Line 183: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_AMOUNT;

179:
180: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.amount, p_old_LIMITS_rec.amount)
181: THEN
182: l_index := l_index + 1;
183: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_AMOUNT;
184: END IF;
185:
186: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute1, p_old_LIMITS_rec.attribute1)
187: THEN

Line 189: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE1;

185:
186: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute1, p_old_LIMITS_rec.attribute1)
187: THEN
188: l_index := l_index + 1;
189: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE1;
190: END IF;
191:
192: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute10, p_old_LIMITS_rec.attribute10)
193: THEN

Line 195: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE10;

191:
192: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute10, p_old_LIMITS_rec.attribute10)
193: THEN
194: l_index := l_index + 1;
195: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE10;
196: END IF;
197:
198: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute11, p_old_LIMITS_rec.attribute11)
199: THEN

Line 201: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE11;

197:
198: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute11, p_old_LIMITS_rec.attribute11)
199: THEN
200: l_index := l_index + 1;
201: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE11;
202: END IF;
203:
204: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute12, p_old_LIMITS_rec.attribute12)
205: THEN

Line 207: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE12;

203:
204: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute12, p_old_LIMITS_rec.attribute12)
205: THEN
206: l_index := l_index + 1;
207: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE12;
208: END IF;
209:
210: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute13, p_old_LIMITS_rec.attribute13)
211: THEN

Line 213: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE13;

209:
210: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute13, p_old_LIMITS_rec.attribute13)
211: THEN
212: l_index := l_index + 1;
213: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE13;
214: END IF;
215:
216: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute14, p_old_LIMITS_rec.attribute14)
217: THEN

Line 219: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE14;

215:
216: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute14, p_old_LIMITS_rec.attribute14)
217: THEN
218: l_index := l_index + 1;
219: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE14;
220: END IF;
221:
222: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute15, p_old_LIMITS_rec.attribute15)
223: THEN

Line 225: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE15;

221:
222: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute15, p_old_LIMITS_rec.attribute15)
223: THEN
224: l_index := l_index + 1;
225: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE15;
226: END IF;
227:
228: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute2, p_old_LIMITS_rec.attribute2)
229: THEN

Line 231: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE2;

227:
228: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute2, p_old_LIMITS_rec.attribute2)
229: THEN
230: l_index := l_index + 1;
231: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE2;
232: END IF;
233:
234: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute3, p_old_LIMITS_rec.attribute3)
235: THEN

Line 237: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE3;

233:
234: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute3, p_old_LIMITS_rec.attribute3)
235: THEN
236: l_index := l_index + 1;
237: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE3;
238: END IF;
239:
240: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute4, p_old_LIMITS_rec.attribute4)
241: THEN

Line 243: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE4;

239:
240: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute4, p_old_LIMITS_rec.attribute4)
241: THEN
242: l_index := l_index + 1;
243: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE4;
244: END IF;
245:
246: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute5, p_old_LIMITS_rec.attribute5)
247: THEN

Line 249: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE5;

245:
246: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute5, p_old_LIMITS_rec.attribute5)
247: THEN
248: l_index := l_index + 1;
249: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE5;
250: END IF;
251:
252: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute6, p_old_LIMITS_rec.attribute6)
253: THEN

Line 255: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE6;

251:
252: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute6, p_old_LIMITS_rec.attribute6)
253: THEN
254: l_index := l_index + 1;
255: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE6;
256: END IF;
257:
258: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute7, p_old_LIMITS_rec.attribute7)
259: THEN

Line 261: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE7;

257:
258: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute7, p_old_LIMITS_rec.attribute7)
259: THEN
260: l_index := l_index + 1;
261: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE7;
262: END IF;
263:
264: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute8, p_old_LIMITS_rec.attribute8)
265: THEN

Line 267: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE8;

263:
264: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute8, p_old_LIMITS_rec.attribute8)
265: THEN
266: l_index := l_index + 1;
267: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE8;
268: END IF;
269:
270: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute9, p_old_LIMITS_rec.attribute9)
271: THEN

Line 273: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE9;

269:
270: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute9, p_old_LIMITS_rec.attribute9)
271: THEN
272: l_index := l_index + 1;
273: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE9;
274: END IF;
275:
276: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.basis, p_old_LIMITS_rec.basis)
277: THEN

Line 279: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_BASIS;

275:
276: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.basis, p_old_LIMITS_rec.basis)
277: THEN
278: l_index := l_index + 1;
279: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_BASIS;
280: END IF;
281:
282: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.context, p_old_LIMITS_rec.context)
283: THEN

Line 285: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_CONTEXT;

281:
282: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.context, p_old_LIMITS_rec.context)
283: THEN
284: l_index := l_index + 1;
285: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_CONTEXT;
286: END IF;
287:
288: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.created_by, p_old_LIMITS_rec.created_by)
289: THEN

Line 291: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_CREATED_BY;

287:
288: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.created_by, p_old_LIMITS_rec.created_by)
289: THEN
290: l_index := l_index + 1;
291: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_CREATED_BY;
292: END IF;
293:
294: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.creation_date, p_old_LIMITS_rec.creation_date)
295: THEN

Line 297: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_CREATION_DATE;

293:
294: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.creation_date, p_old_LIMITS_rec.creation_date)
295: THEN
296: l_index := l_index + 1;
297: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_CREATION_DATE;
298: END IF;
299:
300: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.last_updated_by, p_old_LIMITS_rec.last_updated_by)
301: THEN

Line 303: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LAST_UPDATED_BY;

299:
300: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.last_updated_by, p_old_LIMITS_rec.last_updated_by)
301: THEN
302: l_index := l_index + 1;
303: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LAST_UPDATED_BY;
304: END IF;
305:
306: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.last_update_date, p_old_LIMITS_rec.last_update_date)
307: THEN

Line 309: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LAST_UPDATE_DATE;

305:
306: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.last_update_date, p_old_LIMITS_rec.last_update_date)
307: THEN
308: l_index := l_index + 1;
309: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LAST_UPDATE_DATE;
310: END IF;
311:
312: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.last_update_login, p_old_LIMITS_rec.last_update_login)
313: THEN

Line 315: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LAST_UPDATE_LOGIN;

311:
312: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.last_update_login, p_old_LIMITS_rec.last_update_login)
313: THEN
314: l_index := l_index + 1;
315: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LAST_UPDATE_LOGIN;
316: END IF;
317:
318: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.limit_exceed_action_code, p_old_LIMITS_rec.limit_exceed_action_code)
319: THEN

Line 321: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LIMIT_EXCEED_ACTION;

317:
318: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.limit_exceed_action_code, p_old_LIMITS_rec.limit_exceed_action_code)
319: THEN
320: l_index := l_index + 1;
321: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LIMIT_EXCEED_ACTION;
322: END IF;
323:
324:
325: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.limit_id, p_old_LIMITS_rec.limit_id)

Line 328: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LIMIT;

324:
325: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.limit_id, p_old_LIMITS_rec.limit_id)
326: THEN
327: l_index := l_index + 1;
328: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LIMIT;
329: END IF;
330:
331: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.limit_level_code, p_old_LIMITS_rec.limit_level_code)
332: THEN

Line 334: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LIMIT_LEVEL;

330:
331: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.limit_level_code, p_old_LIMITS_rec.limit_level_code)
332: THEN
333: l_index := l_index + 1;
334: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LIMIT_LEVEL;
335: END IF;
336:
337: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.limit_number, p_old_LIMITS_rec.limit_number)
338: THEN

Line 340: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LIMIT_NUMBER;

336:
337: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.limit_number, p_old_LIMITS_rec.limit_number)
338: THEN
339: l_index := l_index + 1;
340: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LIMIT_NUMBER;
341: END IF;
342:
343: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.list_header_id, p_old_LIMITS_rec.list_header_id)
344: THEN

Line 346: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LIST_HEADER;

342:
343: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.list_header_id, p_old_LIMITS_rec.list_header_id)
344: THEN
345: l_index := l_index + 1;
346: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LIST_HEADER;
347: END IF;
348:
349: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.list_line_id, p_old_LIMITS_rec.list_line_id)
350: THEN

Line 352: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LIST_LINE;

348:
349: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.list_line_id, p_old_LIMITS_rec.list_line_id)
350: THEN
351: l_index := l_index + 1;
352: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LIST_LINE;
353: END IF;
354:
355: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.organization_flag, p_old_LIMITS_rec.organization_flag)
356: THEN

Line 358: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ORGANIZATION;

354:
355: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.organization_flag, p_old_LIMITS_rec.organization_flag)
356: THEN
357: l_index := l_index + 1;
358: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ORGANIZATION;
359: END IF;
360:
361: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.program_application_id, p_old_LIMITS_rec.program_application_id)
362: THEN

Line 364: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_PROGRAM_APPLICATION;

360:
361: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.program_application_id, p_old_LIMITS_rec.program_application_id)
362: THEN
363: l_index := l_index + 1;
364: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_PROGRAM_APPLICATION;
365: END IF;
366:
367: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.program_id, p_old_LIMITS_rec.program_id)
368: THEN

Line 370: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_PROGRAM;

366:
367: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.program_id, p_old_LIMITS_rec.program_id)
368: THEN
369: l_index := l_index + 1;
370: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_PROGRAM;
371: END IF;
372:
373: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.program_update_date, p_old_LIMITS_rec.program_update_date)
374: THEN

Line 376: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_PROGRAM_UPDATE_DATE;

372:
373: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.program_update_date, p_old_LIMITS_rec.program_update_date)
374: THEN
375: l_index := l_index + 1;
376: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_PROGRAM_UPDATE_DATE;
377: END IF;
378:
379: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.request_id, p_old_LIMITS_rec.request_id)
380: THEN

Line 382: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_REQUEST;

378:
379: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.request_id, p_old_LIMITS_rec.request_id)
380: THEN
381: l_index := l_index + 1;
382: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_REQUEST;
383: END IF;
384:
385: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.limit_hold_flag, p_old_LIMITS_rec.limit_hold_flag)
386: THEN

Line 388: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LIMIT_HOLD;

384:
385: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.limit_hold_flag, p_old_LIMITS_rec.limit_hold_flag)
386: THEN
387: l_index := l_index + 1;
388: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LIMIT_HOLD;
389: END IF;
390:
391: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr1_type, p_old_LIMITS_rec.multival_attr1_type)
392: THEN

Line 394: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_MULTIVAL_ATTR1_TYPE;

390:
391: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr1_type, p_old_LIMITS_rec.multival_attr1_type)
392: THEN
393: l_index := l_index + 1;
394: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_MULTIVAL_ATTR1_TYPE;
395: END IF;
396:
397: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr1_context, p_old_LIMITS_rec.multival_attr1_context)
398: THEN

Line 400: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_MULTIVAL_ATTR1_CONTEXT;

396:
397: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr1_context, p_old_LIMITS_rec.multival_attr1_context)
398: THEN
399: l_index := l_index + 1;
400: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_MULTIVAL_ATTR1_CONTEXT;
401: END IF;
402:
403: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.multival_attribute1, p_old_LIMITS_rec.multival_attribute1)
404: THEN

Line 406: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_MULTIVAL_ATTRIBUTE1;

402:
403: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.multival_attribute1, p_old_LIMITS_rec.multival_attribute1)
404: THEN
405: l_index := l_index + 1;
406: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_MULTIVAL_ATTRIBUTE1;
407: END IF;
408:
409: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr1_datatype, p_old_LIMITS_rec.multival_attr1_datatype)
410: THEN

Line 412: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_MULTIVAL_ATTR1_DATATYPE;

408:
409: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr1_datatype, p_old_LIMITS_rec.multival_attr1_datatype)
410: THEN
411: l_index := l_index + 1;
412: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_MULTIVAL_ATTR1_DATATYPE;
413: END IF;
414:
415: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr2_type, p_old_LIMITS_rec.multival_attr2_type)
416: THEN

Line 418: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_MULTIVAL_ATTR2_TYPE;

414:
415: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr2_type, p_old_LIMITS_rec.multival_attr2_type)
416: THEN
417: l_index := l_index + 1;
418: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_MULTIVAL_ATTR2_TYPE;
419: END IF;
420:
421: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr2_context, p_old_LIMITS_rec.multival_attr2_context)
422: THEN

Line 424: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_MULTIVAL_ATTR2_CONTEXT;

420:
421: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr2_context, p_old_LIMITS_rec.multival_attr2_context)
422: THEN
423: l_index := l_index + 1;
424: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_MULTIVAL_ATTR2_CONTEXT;
425: END IF;
426:
427: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.multival_attribute2, p_old_LIMITS_rec.multival_attribute2)
428: THEN

Line 430: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_MULTIVAL_ATTRIBUTE2;

426:
427: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.multival_attribute2, p_old_LIMITS_rec.multival_attribute2)
428: THEN
429: l_index := l_index + 1;
430: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_MULTIVAL_ATTRIBUTE2;
431: END IF;
432:
433: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr2_datatype, p_old_LIMITS_rec.multival_attr2_datatype)
434: THEN

Line 436: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_MULTIVAL_ATTR2_DATATYPE;

432:
433: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr2_datatype, p_old_LIMITS_rec.multival_attr2_datatype)
434: THEN
435: l_index := l_index + 1;
436: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_MULTIVAL_ATTR2_DATATYPE;
437: END IF;
438:
439: ELSIF p_attr_id = G_AMOUNT THEN
440: l_index := l_index + 1;

Line 441: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_AMOUNT;

437: END IF;
438:
439: ELSIF p_attr_id = G_AMOUNT THEN
440: l_index := l_index + 1;
441: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_AMOUNT;
442: ELSIF p_attr_id = G_ATTRIBUTE1 THEN
443: l_index := l_index + 1;
444: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE1;
445: ELSIF p_attr_id = G_ATTRIBUTE10 THEN

Line 444: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE1;

440: l_index := l_index + 1;
441: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_AMOUNT;
442: ELSIF p_attr_id = G_ATTRIBUTE1 THEN
443: l_index := l_index + 1;
444: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE1;
445: ELSIF p_attr_id = G_ATTRIBUTE10 THEN
446: l_index := l_index + 1;
447: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE10;
448: ELSIF p_attr_id = G_ATTRIBUTE11 THEN

Line 447: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE10;

443: l_index := l_index + 1;
444: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE1;
445: ELSIF p_attr_id = G_ATTRIBUTE10 THEN
446: l_index := l_index + 1;
447: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE10;
448: ELSIF p_attr_id = G_ATTRIBUTE11 THEN
449: l_index := l_index + 1;
450: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE11;
451: ELSIF p_attr_id = G_ATTRIBUTE12 THEN

Line 450: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE11;

446: l_index := l_index + 1;
447: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE10;
448: ELSIF p_attr_id = G_ATTRIBUTE11 THEN
449: l_index := l_index + 1;
450: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE11;
451: ELSIF p_attr_id = G_ATTRIBUTE12 THEN
452: l_index := l_index + 1;
453: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE12;
454: ELSIF p_attr_id = G_ATTRIBUTE13 THEN

Line 453: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE12;

449: l_index := l_index + 1;
450: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE11;
451: ELSIF p_attr_id = G_ATTRIBUTE12 THEN
452: l_index := l_index + 1;
453: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE12;
454: ELSIF p_attr_id = G_ATTRIBUTE13 THEN
455: l_index := l_index + 1;
456: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE13;
457: ELSIF p_attr_id = G_ATTRIBUTE14 THEN

Line 456: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE13;

452: l_index := l_index + 1;
453: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE12;
454: ELSIF p_attr_id = G_ATTRIBUTE13 THEN
455: l_index := l_index + 1;
456: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE13;
457: ELSIF p_attr_id = G_ATTRIBUTE14 THEN
458: l_index := l_index + 1;
459: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE14;
460: ELSIF p_attr_id = G_ATTRIBUTE15 THEN

Line 459: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE14;

455: l_index := l_index + 1;
456: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE13;
457: ELSIF p_attr_id = G_ATTRIBUTE14 THEN
458: l_index := l_index + 1;
459: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE14;
460: ELSIF p_attr_id = G_ATTRIBUTE15 THEN
461: l_index := l_index + 1;
462: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE15;
463: ELSIF p_attr_id = G_ATTRIBUTE2 THEN

Line 462: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE15;

458: l_index := l_index + 1;
459: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE14;
460: ELSIF p_attr_id = G_ATTRIBUTE15 THEN
461: l_index := l_index + 1;
462: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE15;
463: ELSIF p_attr_id = G_ATTRIBUTE2 THEN
464: l_index := l_index + 1;
465: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE2;
466: ELSIF p_attr_id = G_ATTRIBUTE3 THEN

Line 465: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE2;

461: l_index := l_index + 1;
462: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE15;
463: ELSIF p_attr_id = G_ATTRIBUTE2 THEN
464: l_index := l_index + 1;
465: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE2;
466: ELSIF p_attr_id = G_ATTRIBUTE3 THEN
467: l_index := l_index + 1;
468: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE3;
469: ELSIF p_attr_id = G_ATTRIBUTE4 THEN

Line 468: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE3;

464: l_index := l_index + 1;
465: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE2;
466: ELSIF p_attr_id = G_ATTRIBUTE3 THEN
467: l_index := l_index + 1;
468: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE3;
469: ELSIF p_attr_id = G_ATTRIBUTE4 THEN
470: l_index := l_index + 1;
471: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE4;
472: ELSIF p_attr_id = G_ATTRIBUTE5 THEN

Line 471: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE4;

467: l_index := l_index + 1;
468: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE3;
469: ELSIF p_attr_id = G_ATTRIBUTE4 THEN
470: l_index := l_index + 1;
471: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE4;
472: ELSIF p_attr_id = G_ATTRIBUTE5 THEN
473: l_index := l_index + 1;
474: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE5;
475: ELSIF p_attr_id = G_ATTRIBUTE6 THEN

Line 474: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE5;

470: l_index := l_index + 1;
471: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE4;
472: ELSIF p_attr_id = G_ATTRIBUTE5 THEN
473: l_index := l_index + 1;
474: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE5;
475: ELSIF p_attr_id = G_ATTRIBUTE6 THEN
476: l_index := l_index + 1;
477: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE6;
478: ELSIF p_attr_id = G_ATTRIBUTE7 THEN

Line 477: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE6;

473: l_index := l_index + 1;
474: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE5;
475: ELSIF p_attr_id = G_ATTRIBUTE6 THEN
476: l_index := l_index + 1;
477: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE6;
478: ELSIF p_attr_id = G_ATTRIBUTE7 THEN
479: l_index := l_index + 1;
480: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE7;
481: ELSIF p_attr_id = G_ATTRIBUTE8 THEN

Line 480: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE7;

476: l_index := l_index + 1;
477: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE6;
478: ELSIF p_attr_id = G_ATTRIBUTE7 THEN
479: l_index := l_index + 1;
480: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE7;
481: ELSIF p_attr_id = G_ATTRIBUTE8 THEN
482: l_index := l_index + 1;
483: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE8;
484: ELSIF p_attr_id = G_ATTRIBUTE9 THEN

Line 483: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE8;

479: l_index := l_index + 1;
480: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE7;
481: ELSIF p_attr_id = G_ATTRIBUTE8 THEN
482: l_index := l_index + 1;
483: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE8;
484: ELSIF p_attr_id = G_ATTRIBUTE9 THEN
485: l_index := l_index + 1;
486: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE9;
487: ELSIF p_attr_id = G_BASIS THEN

Line 486: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE9;

482: l_index := l_index + 1;
483: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE8;
484: ELSIF p_attr_id = G_ATTRIBUTE9 THEN
485: l_index := l_index + 1;
486: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE9;
487: ELSIF p_attr_id = G_BASIS THEN
488: l_index := l_index + 1;
489: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_BASIS;
490: ELSIF p_attr_id = G_CONTEXT THEN

Line 489: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_BASIS;

485: l_index := l_index + 1;
486: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE9;
487: ELSIF p_attr_id = G_BASIS THEN
488: l_index := l_index + 1;
489: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_BASIS;
490: ELSIF p_attr_id = G_CONTEXT THEN
491: l_index := l_index + 1;
492: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_CONTEXT;
493: ELSIF p_attr_id = G_CREATED_BY THEN

Line 492: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_CONTEXT;

488: l_index := l_index + 1;
489: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_BASIS;
490: ELSIF p_attr_id = G_CONTEXT THEN
491: l_index := l_index + 1;
492: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_CONTEXT;
493: ELSIF p_attr_id = G_CREATED_BY THEN
494: l_index := l_index + 1;
495: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_CREATED_BY;
496: ELSIF p_attr_id = G_CREATION_DATE THEN

Line 495: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_CREATED_BY;

491: l_index := l_index + 1;
492: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_CONTEXT;
493: ELSIF p_attr_id = G_CREATED_BY THEN
494: l_index := l_index + 1;
495: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_CREATED_BY;
496: ELSIF p_attr_id = G_CREATION_DATE THEN
497: l_index := l_index + 1;
498: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_CREATION_DATE;
499: ELSIF p_attr_id = G_LAST_UPDATED_BY THEN

Line 498: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_CREATION_DATE;

494: l_index := l_index + 1;
495: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_CREATED_BY;
496: ELSIF p_attr_id = G_CREATION_DATE THEN
497: l_index := l_index + 1;
498: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_CREATION_DATE;
499: ELSIF p_attr_id = G_LAST_UPDATED_BY THEN
500: l_index := l_index + 1;
501: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LAST_UPDATED_BY;
502: ELSIF p_attr_id = G_LAST_UPDATE_DATE THEN

Line 501: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LAST_UPDATED_BY;

497: l_index := l_index + 1;
498: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_CREATION_DATE;
499: ELSIF p_attr_id = G_LAST_UPDATED_BY THEN
500: l_index := l_index + 1;
501: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LAST_UPDATED_BY;
502: ELSIF p_attr_id = G_LAST_UPDATE_DATE THEN
503: l_index := l_index + 1;
504: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LAST_UPDATE_DATE;
505: ELSIF p_attr_id = G_LAST_UPDATE_LOGIN THEN

Line 504: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LAST_UPDATE_DATE;

500: l_index := l_index + 1;
501: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LAST_UPDATED_BY;
502: ELSIF p_attr_id = G_LAST_UPDATE_DATE THEN
503: l_index := l_index + 1;
504: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LAST_UPDATE_DATE;
505: ELSIF p_attr_id = G_LAST_UPDATE_LOGIN THEN
506: l_index := l_index + 1;
507: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LAST_UPDATE_LOGIN;
508: ELSIF p_attr_id = G_LIMIT_EXCEED_ACTION THEN

Line 507: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LAST_UPDATE_LOGIN;

503: l_index := l_index + 1;
504: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LAST_UPDATE_DATE;
505: ELSIF p_attr_id = G_LAST_UPDATE_LOGIN THEN
506: l_index := l_index + 1;
507: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LAST_UPDATE_LOGIN;
508: ELSIF p_attr_id = G_LIMIT_EXCEED_ACTION THEN
509: l_index := l_index + 1;
510: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LIMIT_EXCEED_ACTION;
511: ELSIF p_attr_id = G_LIMIT THEN

Line 510: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LIMIT_EXCEED_ACTION;

506: l_index := l_index + 1;
507: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LAST_UPDATE_LOGIN;
508: ELSIF p_attr_id = G_LIMIT_EXCEED_ACTION THEN
509: l_index := l_index + 1;
510: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LIMIT_EXCEED_ACTION;
511: ELSIF p_attr_id = G_LIMIT THEN
512: l_index := l_index + 1;
513: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LIMIT;
514: ELSIF p_attr_id = G_LIMIT_LEVEL THEN

Line 513: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LIMIT;

509: l_index := l_index + 1;
510: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LIMIT_EXCEED_ACTION;
511: ELSIF p_attr_id = G_LIMIT THEN
512: l_index := l_index + 1;
513: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LIMIT;
514: ELSIF p_attr_id = G_LIMIT_LEVEL THEN
515: l_index := l_index + 1;
516: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LIMIT_LEVEL;
517: ELSIF p_attr_id = G_LIMIT_NUMBER THEN

Line 516: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LIMIT_LEVEL;

512: l_index := l_index + 1;
513: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LIMIT;
514: ELSIF p_attr_id = G_LIMIT_LEVEL THEN
515: l_index := l_index + 1;
516: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LIMIT_LEVEL;
517: ELSIF p_attr_id = G_LIMIT_NUMBER THEN
518: l_index := l_index + 1;
519: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LIMIT_NUMBER;
520: ELSIF p_attr_id = G_LIST_HEADER THEN

Line 519: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LIMIT_NUMBER;

515: l_index := l_index + 1;
516: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LIMIT_LEVEL;
517: ELSIF p_attr_id = G_LIMIT_NUMBER THEN
518: l_index := l_index + 1;
519: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LIMIT_NUMBER;
520: ELSIF p_attr_id = G_LIST_HEADER THEN
521: l_index := l_index + 1;
522: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LIST_HEADER;
523: ELSIF p_attr_id = G_LIST_LINE THEN

Line 522: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LIST_HEADER;

518: l_index := l_index + 1;
519: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LIMIT_NUMBER;
520: ELSIF p_attr_id = G_LIST_HEADER THEN
521: l_index := l_index + 1;
522: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LIST_HEADER;
523: ELSIF p_attr_id = G_LIST_LINE THEN
524: l_index := l_index + 1;
525: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LIST_LINE;
526: ELSIF p_attr_id = G_ORGANIZATION THEN

Line 525: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LIST_LINE;

521: l_index := l_index + 1;
522: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LIST_HEADER;
523: ELSIF p_attr_id = G_LIST_LINE THEN
524: l_index := l_index + 1;
525: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LIST_LINE;
526: ELSIF p_attr_id = G_ORGANIZATION THEN
527: l_index := l_index + 1;
528: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ORGANIZATION;
529: ELSIF p_attr_id = G_PROGRAM_APPLICATION THEN

Line 528: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ORGANIZATION;

524: l_index := l_index + 1;
525: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LIST_LINE;
526: ELSIF p_attr_id = G_ORGANIZATION THEN
527: l_index := l_index + 1;
528: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ORGANIZATION;
529: ELSIF p_attr_id = G_PROGRAM_APPLICATION THEN
530: l_index := l_index + 1;
531: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_PROGRAM_APPLICATION;
532: ELSIF p_attr_id = G_PROGRAM THEN

Line 531: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_PROGRAM_APPLICATION;

527: l_index := l_index + 1;
528: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ORGANIZATION;
529: ELSIF p_attr_id = G_PROGRAM_APPLICATION THEN
530: l_index := l_index + 1;
531: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_PROGRAM_APPLICATION;
532: ELSIF p_attr_id = G_PROGRAM THEN
533: l_index := l_index + 1;
534: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_PROGRAM;
535: ELSIF p_attr_id = G_PROGRAM_UPDATE_DATE THEN

Line 534: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_PROGRAM;

530: l_index := l_index + 1;
531: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_PROGRAM_APPLICATION;
532: ELSIF p_attr_id = G_PROGRAM THEN
533: l_index := l_index + 1;
534: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_PROGRAM;
535: ELSIF p_attr_id = G_PROGRAM_UPDATE_DATE THEN
536: l_index := l_index + 1;
537: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_PROGRAM_UPDATE_DATE;
538: ELSIF p_attr_id = G_REQUEST THEN

Line 537: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_PROGRAM_UPDATE_DATE;

533: l_index := l_index + 1;
534: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_PROGRAM;
535: ELSIF p_attr_id = G_PROGRAM_UPDATE_DATE THEN
536: l_index := l_index + 1;
537: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_PROGRAM_UPDATE_DATE;
538: ELSIF p_attr_id = G_REQUEST THEN
539: l_index := l_index + 1;
540: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_REQUEST;
541: ELSIF p_attr_id = G_LIMIT_HOLD THEN

Line 540: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_REQUEST;

536: l_index := l_index + 1;
537: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_PROGRAM_UPDATE_DATE;
538: ELSIF p_attr_id = G_REQUEST THEN
539: l_index := l_index + 1;
540: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_REQUEST;
541: ELSIF p_attr_id = G_LIMIT_HOLD THEN
542: l_index := l_index + 1;
543: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LIMIT_HOLD;
544: ELSIF p_attr_id = G_MULTIVAL_ATTR1_TYPE THEN

Line 543: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LIMIT_HOLD;

539: l_index := l_index + 1;
540: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_REQUEST;
541: ELSIF p_attr_id = G_LIMIT_HOLD THEN
542: l_index := l_index + 1;
543: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LIMIT_HOLD;
544: ELSIF p_attr_id = G_MULTIVAL_ATTR1_TYPE THEN
545: l_index := l_index + 1;
546: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_MULTIVAL_ATTR1_TYPE;
547: ELSIF p_attr_id = G_MULTIVAL_ATTR1_CONTEXT THEN

Line 546: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_MULTIVAL_ATTR1_TYPE;

542: l_index := l_index + 1;
543: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LIMIT_HOLD;
544: ELSIF p_attr_id = G_MULTIVAL_ATTR1_TYPE THEN
545: l_index := l_index + 1;
546: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_MULTIVAL_ATTR1_TYPE;
547: ELSIF p_attr_id = G_MULTIVAL_ATTR1_CONTEXT THEN
548: l_index := l_index + 1;
549: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_MULTIVAL_ATTR1_CONTEXT;
550: ELSIF p_attr_id = G_MULTIVAL_ATTRIBUTE1 THEN

Line 549: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_MULTIVAL_ATTR1_CONTEXT;

545: l_index := l_index + 1;
546: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_MULTIVAL_ATTR1_TYPE;
547: ELSIF p_attr_id = G_MULTIVAL_ATTR1_CONTEXT THEN
548: l_index := l_index + 1;
549: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_MULTIVAL_ATTR1_CONTEXT;
550: ELSIF p_attr_id = G_MULTIVAL_ATTRIBUTE1 THEN
551: l_index := l_index + 1;
552: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_MULTIVAL_ATTRIBUTE1;
553: ELSIF p_attr_id = G_MULTIVAL_ATTR1_DATATYPE THEN

Line 552: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_MULTIVAL_ATTRIBUTE1;

548: l_index := l_index + 1;
549: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_MULTIVAL_ATTR1_CONTEXT;
550: ELSIF p_attr_id = G_MULTIVAL_ATTRIBUTE1 THEN
551: l_index := l_index + 1;
552: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_MULTIVAL_ATTRIBUTE1;
553: ELSIF p_attr_id = G_MULTIVAL_ATTR1_DATATYPE THEN
554: l_index := l_index + 1;
555: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_MULTIVAL_ATTR1_DATATYPE;
556: ELSIF p_attr_id = G_MULTIVAL_ATTR2_TYPE THEN

Line 555: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_MULTIVAL_ATTR1_DATATYPE;

551: l_index := l_index + 1;
552: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_MULTIVAL_ATTRIBUTE1;
553: ELSIF p_attr_id = G_MULTIVAL_ATTR1_DATATYPE THEN
554: l_index := l_index + 1;
555: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_MULTIVAL_ATTR1_DATATYPE;
556: ELSIF p_attr_id = G_MULTIVAL_ATTR2_TYPE THEN
557: l_index := l_index + 1;
558: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_MULTIVAL_ATTR2_TYPE;
559: ELSIF p_attr_id = G_MULTIVAL_ATTR2_CONTEXT THEN

Line 558: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_MULTIVAL_ATTR2_TYPE;

554: l_index := l_index + 1;
555: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_MULTIVAL_ATTR1_DATATYPE;
556: ELSIF p_attr_id = G_MULTIVAL_ATTR2_TYPE THEN
557: l_index := l_index + 1;
558: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_MULTIVAL_ATTR2_TYPE;
559: ELSIF p_attr_id = G_MULTIVAL_ATTR2_CONTEXT THEN
560: l_index := l_index + 1;
561: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_MULTIVAL_ATTR2_CONTEXT;
562: ELSIF p_attr_id = G_MULTIVAL_ATTRIBUTE2 THEN

Line 561: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_MULTIVAL_ATTR2_CONTEXT;

557: l_index := l_index + 1;
558: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_MULTIVAL_ATTR2_TYPE;
559: ELSIF p_attr_id = G_MULTIVAL_ATTR2_CONTEXT THEN
560: l_index := l_index + 1;
561: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_MULTIVAL_ATTR2_CONTEXT;
562: ELSIF p_attr_id = G_MULTIVAL_ATTRIBUTE2 THEN
563: l_index := l_index + 1;
564: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_MULTIVAL_ATTRIBUTE2;
565: ELSIF p_attr_id = G_MULTIVAL_ATTR2_DATATYPE THEN

Line 564: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_MULTIVAL_ATTRIBUTE2;

560: l_index := l_index + 1;
561: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_MULTIVAL_ATTR2_CONTEXT;
562: ELSIF p_attr_id = G_MULTIVAL_ATTRIBUTE2 THEN
563: l_index := l_index + 1;
564: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_MULTIVAL_ATTRIBUTE2;
565: ELSIF p_attr_id = G_MULTIVAL_ATTR2_DATATYPE THEN
566: l_index := l_index + 1;
567: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_MULTIVAL_ATTR2_DATATYPE;
568: END IF;

Line 567: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_MULTIVAL_ATTR2_DATATYPE;

563: l_index := l_index + 1;
564: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_MULTIVAL_ATTRIBUTE2;
565: ELSIF p_attr_id = G_MULTIVAL_ATTR2_DATATYPE THEN
566: l_index := l_index + 1;
567: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_MULTIVAL_ATTR2_DATATYPE;
568: END IF;
569:
570: END Clear_Dependent_Attr;
571:

Line 2214: END QP_Limits_Util;

2210:
2211: END Pre_Write_Process;
2212:
2213:
2214: END QP_Limits_Util;