DBA Data[Home] [Help]

APPS.CN_SRP_PMT_PLANS_PKG dependencies on FND_API

Line 383: fnd_api.g_miss_num, oldrow.pmt_plan_id,

379: -- END IF;
380:
381: SELECT
382: decode(x_pmt_plan_id,
383: fnd_api.g_miss_num, oldrow.pmt_plan_id,
384: x_pmt_plan_id),
385: decode(x_salesrep_id,
386: fnd_api.g_miss_num, oldrow.salesrep_id,
387: x_salesrep_id),

Line 386: fnd_api.g_miss_num, oldrow.salesrep_id,

382: decode(x_pmt_plan_id,
383: fnd_api.g_miss_num, oldrow.pmt_plan_id,
384: x_pmt_plan_id),
385: decode(x_salesrep_id,
386: fnd_api.g_miss_num, oldrow.salesrep_id,
387: x_salesrep_id),
388: decode(x_org_id,
389: fnd_api.g_miss_num, oldrow.org_id,
390: x_org_id),

Line 389: fnd_api.g_miss_num, oldrow.org_id,

385: decode(x_salesrep_id,
386: fnd_api.g_miss_num, oldrow.salesrep_id,
387: x_salesrep_id),
388: decode(x_org_id,
389: fnd_api.g_miss_num, oldrow.org_id,
390: x_org_id),
391: decode(x_role_id,
392: fnd_api.g_miss_num, oldrow.role_id,
393: x_role_id),

Line 392: fnd_api.g_miss_num, oldrow.role_id,

388: decode(x_org_id,
389: fnd_api.g_miss_num, oldrow.org_id,
390: x_org_id),
391: decode(x_role_id,
392: fnd_api.g_miss_num, oldrow.role_id,
393: x_role_id),
394: decode(x_credit_type_id,
395: fnd_api.g_miss_num, oldrow.credit_type_id ,
396: x_credit_type_id),

Line 395: fnd_api.g_miss_num, oldrow.credit_type_id ,

391: decode(x_role_id,
392: fnd_api.g_miss_num, oldrow.role_id,
393: x_role_id),
394: decode(x_credit_type_id,
395: fnd_api.g_miss_num, oldrow.credit_type_id ,
396: x_credit_type_id),
397: decode(x_start_date,
398: fnd_api.g_miss_date, oldrow.start_date,
399: x_start_date),

Line 398: fnd_api.g_miss_date, oldrow.start_date,

394: decode(x_credit_type_id,
395: fnd_api.g_miss_num, oldrow.credit_type_id ,
396: x_credit_type_id),
397: decode(x_start_date,
398: fnd_api.g_miss_date, oldrow.start_date,
399: x_start_date),
400: decode(x_end_date,
401: fnd_api.g_miss_date, oldrow.end_date,
402: x_end_date),

Line 401: fnd_api.g_miss_date, oldrow.end_date,

397: decode(x_start_date,
398: fnd_api.g_miss_date, oldrow.start_date,
399: x_start_date),
400: decode(x_end_date,
401: fnd_api.g_miss_date, oldrow.end_date,
402: x_end_date),
403: decode(x_minimum_amount,
404: fnd_api.g_miss_num, oldrow.minimum_amount,
405: x_minimum_amount),

Line 404: fnd_api.g_miss_num, oldrow.minimum_amount,

400: decode(x_end_date,
401: fnd_api.g_miss_date, oldrow.end_date,
402: x_end_date),
403: decode(x_minimum_amount,
404: fnd_api.g_miss_num, oldrow.minimum_amount,
405: x_minimum_amount),
406: decode(x_maximum_amount,
407: fnd_api.g_miss_num, oldrow.maximum_amount,
408: x_maximum_amount),

Line 407: fnd_api.g_miss_num, oldrow.maximum_amount,

403: decode(x_minimum_amount,
404: fnd_api.g_miss_num, oldrow.minimum_amount,
405: x_minimum_amount),
406: decode(x_maximum_amount,
407: fnd_api.g_miss_num, oldrow.maximum_amount,
408: x_maximum_amount),
409: decode(x_max_recovery_amount,
410: fnd_api.g_miss_num, oldrow.max_recovery_amount,
411: x_max_recovery_amount),

Line 410: fnd_api.g_miss_num, oldrow.max_recovery_amount,

406: decode(x_maximum_amount,
407: fnd_api.g_miss_num, oldrow.maximum_amount,
408: x_maximum_amount),
409: decode(x_max_recovery_amount,
410: fnd_api.g_miss_num, oldrow.max_recovery_amount,
411: x_max_recovery_amount),
412: decode(x_attribute_category,
413: fnd_api.g_miss_char, oldrow.attribute_category,
414: x_attribute_category),

Line 413: fnd_api.g_miss_char, oldrow.attribute_category,

409: decode(x_max_recovery_amount,
410: fnd_api.g_miss_num, oldrow.max_recovery_amount,
411: x_max_recovery_amount),
412: decode(x_attribute_category,
413: fnd_api.g_miss_char, oldrow.attribute_category,
414: x_attribute_category),
415: decode(x_attribute1,
416: fnd_api.g_miss_char, oldrow.attribute1,
417: x_attribute1),

Line 416: fnd_api.g_miss_char, oldrow.attribute1,

412: decode(x_attribute_category,
413: fnd_api.g_miss_char, oldrow.attribute_category,
414: x_attribute_category),
415: decode(x_attribute1,
416: fnd_api.g_miss_char, oldrow.attribute1,
417: x_attribute1),
418: decode(x_attribute2,
419: fnd_api.g_miss_char, oldrow.attribute2,
420: x_attribute2),

Line 419: fnd_api.g_miss_char, oldrow.attribute2,

415: decode(x_attribute1,
416: fnd_api.g_miss_char, oldrow.attribute1,
417: x_attribute1),
418: decode(x_attribute2,
419: fnd_api.g_miss_char, oldrow.attribute2,
420: x_attribute2),
421: decode(x_attribute3,
422: fnd_api.g_miss_char, oldrow.attribute3,
423: x_attribute3),

Line 422: fnd_api.g_miss_char, oldrow.attribute3,

418: decode(x_attribute2,
419: fnd_api.g_miss_char, oldrow.attribute2,
420: x_attribute2),
421: decode(x_attribute3,
422: fnd_api.g_miss_char, oldrow.attribute3,
423: x_attribute3),
424: decode(x_attribute4,
425: fnd_api.g_miss_char, oldrow.attribute4,
426: x_attribute4),

Line 425: fnd_api.g_miss_char, oldrow.attribute4,

421: decode(x_attribute3,
422: fnd_api.g_miss_char, oldrow.attribute3,
423: x_attribute3),
424: decode(x_attribute4,
425: fnd_api.g_miss_char, oldrow.attribute4,
426: x_attribute4),
427: decode(x_attribute5,
428: fnd_api.g_miss_char, oldrow.attribute5,
429: x_attribute5),

Line 428: fnd_api.g_miss_char, oldrow.attribute5,

424: decode(x_attribute4,
425: fnd_api.g_miss_char, oldrow.attribute4,
426: x_attribute4),
427: decode(x_attribute5,
428: fnd_api.g_miss_char, oldrow.attribute5,
429: x_attribute5),
430: decode(x_attribute6,
431: fnd_api.g_miss_char, oldrow.attribute6,
432: x_attribute6),

Line 431: fnd_api.g_miss_char, oldrow.attribute6,

427: decode(x_attribute5,
428: fnd_api.g_miss_char, oldrow.attribute5,
429: x_attribute5),
430: decode(x_attribute6,
431: fnd_api.g_miss_char, oldrow.attribute6,
432: x_attribute6),
433: decode(x_attribute7,
434: fnd_api.g_miss_char, oldrow.attribute7,
435: x_attribute7),

Line 434: fnd_api.g_miss_char, oldrow.attribute7,

430: decode(x_attribute6,
431: fnd_api.g_miss_char, oldrow.attribute6,
432: x_attribute6),
433: decode(x_attribute7,
434: fnd_api.g_miss_char, oldrow.attribute7,
435: x_attribute7),
436: decode(x_attribute8,
437: fnd_api.g_miss_char, oldrow.attribute8,
438: x_attribute8),

Line 437: fnd_api.g_miss_char, oldrow.attribute8,

433: decode(x_attribute7,
434: fnd_api.g_miss_char, oldrow.attribute7,
435: x_attribute7),
436: decode(x_attribute8,
437: fnd_api.g_miss_char, oldrow.attribute8,
438: x_attribute8),
439: decode(x_attribute9,
440: fnd_api.g_miss_char, oldrow.attribute9,
441: x_attribute9),

Line 440: fnd_api.g_miss_char, oldrow.attribute9,

436: decode(x_attribute8,
437: fnd_api.g_miss_char, oldrow.attribute8,
438: x_attribute8),
439: decode(x_attribute9,
440: fnd_api.g_miss_char, oldrow.attribute9,
441: x_attribute9),
442: decode(x_attribute10,
443: fnd_api.g_miss_char, oldrow.attribute10,
444: x_attribute10),

Line 443: fnd_api.g_miss_char, oldrow.attribute10,

439: decode(x_attribute9,
440: fnd_api.g_miss_char, oldrow.attribute9,
441: x_attribute9),
442: decode(x_attribute10,
443: fnd_api.g_miss_char, oldrow.attribute10,
444: x_attribute10),
445: decode(x_attribute11,
446: fnd_api.g_miss_char, oldrow.attribute11,
447: x_attribute11),

Line 446: fnd_api.g_miss_char, oldrow.attribute11,

442: decode(x_attribute10,
443: fnd_api.g_miss_char, oldrow.attribute10,
444: x_attribute10),
445: decode(x_attribute11,
446: fnd_api.g_miss_char, oldrow.attribute11,
447: x_attribute11),
448: decode(x_attribute12,
449: fnd_api.g_miss_char, oldrow.attribute12,
450: x_attribute12),

Line 449: fnd_api.g_miss_char, oldrow.attribute12,

445: decode(x_attribute11,
446: fnd_api.g_miss_char, oldrow.attribute11,
447: x_attribute11),
448: decode(x_attribute12,
449: fnd_api.g_miss_char, oldrow.attribute12,
450: x_attribute12),
451: decode(x_attribute13,
452: fnd_api.g_miss_char, oldrow.attribute13,
453: x_attribute13),

Line 452: fnd_api.g_miss_char, oldrow.attribute13,

448: decode(x_attribute12,
449: fnd_api.g_miss_char, oldrow.attribute12,
450: x_attribute12),
451: decode(x_attribute13,
452: fnd_api.g_miss_char, oldrow.attribute13,
453: x_attribute13),
454: decode(x_attribute14,
455: fnd_api.g_miss_char, oldrow.attribute14,
456: x_attribute14),

Line 455: fnd_api.g_miss_char, oldrow.attribute14,

451: decode(x_attribute13,
452: fnd_api.g_miss_char, oldrow.attribute13,
453: x_attribute13),
454: decode(x_attribute14,
455: fnd_api.g_miss_char, oldrow.attribute14,
456: x_attribute14),
457: decode(x_attribute15,
458: fnd_api.g_miss_char, oldrow.attribute15,
459: x_attribute15),

Line 458: fnd_api.g_miss_char, oldrow.attribute15,

454: decode(x_attribute14,
455: fnd_api.g_miss_char, oldrow.attribute14,
456: x_attribute14),
457: decode(x_attribute15,
458: fnd_api.g_miss_char, oldrow.attribute15,
459: x_attribute15),
460: decode(x_lock_flag,
461: fnd_api.g_miss_char, oldrow.lock_flag,
462: x_lock_flag)

Line 461: fnd_api.g_miss_char, oldrow.lock_flag,

457: decode(x_attribute15,
458: fnd_api.g_miss_char, oldrow.attribute15,
459: x_attribute15),
460: decode(x_lock_flag,
461: fnd_api.g_miss_char, oldrow.lock_flag,
462: x_lock_flag)
463: INTO
464: l_pmt_plan_id,
465: l_salesrep_id,