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.CN_SRP_PLAN_ASSIGNS_PKG dependencies on FND_API

Line 378: fnd_api.g_miss_num, oldrow.srp_role_id,

374: END IF;
375: CLOSE C;
376: SELECT
377: decode(x_srp_role_id,
378: fnd_api.g_miss_num, oldrow.srp_role_id,
379: x_srp_role_id),
380: decode(x_role_plan_id,
381: fnd_api.g_miss_num, oldrow.role_plan_id,
382: x_role_plan_id),

Line 381: fnd_api.g_miss_num, oldrow.role_plan_id,

377: decode(x_srp_role_id,
378: fnd_api.g_miss_num, oldrow.srp_role_id,
379: x_srp_role_id),
380: decode(x_role_plan_id,
381: fnd_api.g_miss_num, oldrow.role_plan_id,
382: x_role_plan_id),
383: decode(x_salesrep_id,
384: fnd_api.g_miss_num, oldrow.salesrep_id,
385: x_salesrep_id),

Line 384: fnd_api.g_miss_num, oldrow.salesrep_id,

380: decode(x_role_plan_id,
381: fnd_api.g_miss_num, oldrow.role_plan_id,
382: x_role_plan_id),
383: decode(x_salesrep_id,
384: fnd_api.g_miss_num, oldrow.salesrep_id,
385: x_salesrep_id),
386: decode(x_role_id,
387: fnd_api.g_miss_num, oldrow.role_id,
388: x_role_id),

Line 387: fnd_api.g_miss_num, oldrow.role_id,

383: decode(x_salesrep_id,
384: fnd_api.g_miss_num, oldrow.salesrep_id,
385: x_salesrep_id),
386: decode(x_role_id,
387: fnd_api.g_miss_num, oldrow.role_id,
388: x_role_id),
389: decode(x_comp_plan_id,
390: fnd_api.g_miss_num, oldrow.comp_plan_id,
391: x_comp_plan_id),

Line 390: fnd_api.g_miss_num, oldrow.comp_plan_id,

386: decode(x_role_id,
387: fnd_api.g_miss_num, oldrow.role_id,
388: x_role_id),
389: decode(x_comp_plan_id,
390: fnd_api.g_miss_num, oldrow.comp_plan_id,
391: x_comp_plan_id),
392: decode(x_start_date,
393: fnd_api.g_miss_date, oldrow.start_date,
394: x_start_date),

Line 393: fnd_api.g_miss_date, oldrow.start_date,

389: decode(x_comp_plan_id,
390: fnd_api.g_miss_num, oldrow.comp_plan_id,
391: x_comp_plan_id),
392: decode(x_start_date,
393: fnd_api.g_miss_date, oldrow.start_date,
394: x_start_date),
395: decode(x_end_date,
396: fnd_api.g_miss_date, oldrow.end_date,
397: x_end_date),

Line 396: fnd_api.g_miss_date, oldrow.end_date,

392: decode(x_start_date,
393: fnd_api.g_miss_date, oldrow.start_date,
394: x_start_date),
395: decode(x_end_date,
396: fnd_api.g_miss_date, oldrow.end_date,
397: x_end_date),
398: decode(x_attribute_category,
399: fnd_api.g_miss_char, oldrow.attribute_category,
400: x_attribute_category),

Line 399: fnd_api.g_miss_char, oldrow.attribute_category,

395: decode(x_end_date,
396: fnd_api.g_miss_date, oldrow.end_date,
397: x_end_date),
398: decode(x_attribute_category,
399: fnd_api.g_miss_char, oldrow.attribute_category,
400: x_attribute_category),
401: decode(x_attribute1,
402: fnd_api.g_miss_char, oldrow.attribute1,
403: x_attribute1),

Line 402: fnd_api.g_miss_char, oldrow.attribute1,

398: decode(x_attribute_category,
399: fnd_api.g_miss_char, oldrow.attribute_category,
400: x_attribute_category),
401: decode(x_attribute1,
402: fnd_api.g_miss_char, oldrow.attribute1,
403: x_attribute1),
404: decode(x_attribute2,
405: fnd_api.g_miss_char, oldrow.attribute2,
406: x_attribute2),

Line 405: fnd_api.g_miss_char, oldrow.attribute2,

401: decode(x_attribute1,
402: fnd_api.g_miss_char, oldrow.attribute1,
403: x_attribute1),
404: decode(x_attribute2,
405: fnd_api.g_miss_char, oldrow.attribute2,
406: x_attribute2),
407: decode(x_attribute3,
408: fnd_api.g_miss_char, oldrow.attribute3,
409: x_attribute3),

Line 408: fnd_api.g_miss_char, oldrow.attribute3,

404: decode(x_attribute2,
405: fnd_api.g_miss_char, oldrow.attribute2,
406: x_attribute2),
407: decode(x_attribute3,
408: fnd_api.g_miss_char, oldrow.attribute3,
409: x_attribute3),
410: decode(x_attribute4,
411: fnd_api.g_miss_char, oldrow.attribute4,
412: x_attribute4),

Line 411: fnd_api.g_miss_char, oldrow.attribute4,

407: decode(x_attribute3,
408: fnd_api.g_miss_char, oldrow.attribute3,
409: x_attribute3),
410: decode(x_attribute4,
411: fnd_api.g_miss_char, oldrow.attribute4,
412: x_attribute4),
413: decode(x_attribute5,
414: fnd_api.g_miss_char, oldrow.attribute5,
415: x_attribute5),

Line 414: fnd_api.g_miss_char, oldrow.attribute5,

410: decode(x_attribute4,
411: fnd_api.g_miss_char, oldrow.attribute4,
412: x_attribute4),
413: decode(x_attribute5,
414: fnd_api.g_miss_char, oldrow.attribute5,
415: x_attribute5),
416: decode(x_attribute6,
417: fnd_api.g_miss_char, oldrow.attribute6,
418: x_attribute6),

Line 417: fnd_api.g_miss_char, oldrow.attribute6,

413: decode(x_attribute5,
414: fnd_api.g_miss_char, oldrow.attribute5,
415: x_attribute5),
416: decode(x_attribute6,
417: fnd_api.g_miss_char, oldrow.attribute6,
418: x_attribute6),
419: decode(x_attribute7,
420: fnd_api.g_miss_char, oldrow.attribute7,
421: x_attribute7),

Line 420: fnd_api.g_miss_char, oldrow.attribute7,

416: decode(x_attribute6,
417: fnd_api.g_miss_char, oldrow.attribute6,
418: x_attribute6),
419: decode(x_attribute7,
420: fnd_api.g_miss_char, oldrow.attribute7,
421: x_attribute7),
422: decode(x_attribute8,
423: fnd_api.g_miss_char, oldrow.attribute8,
424: x_attribute8),

Line 423: fnd_api.g_miss_char, oldrow.attribute8,

419: decode(x_attribute7,
420: fnd_api.g_miss_char, oldrow.attribute7,
421: x_attribute7),
422: decode(x_attribute8,
423: fnd_api.g_miss_char, oldrow.attribute8,
424: x_attribute8),
425: decode(x_attribute9,
426: fnd_api.g_miss_char, oldrow.attribute9,
427: x_attribute9),

Line 426: fnd_api.g_miss_char, oldrow.attribute9,

422: decode(x_attribute8,
423: fnd_api.g_miss_char, oldrow.attribute8,
424: x_attribute8),
425: decode(x_attribute9,
426: fnd_api.g_miss_char, oldrow.attribute9,
427: x_attribute9),
428: decode(x_attribute10,
429: fnd_api.g_miss_char, oldrow.attribute10,
430: x_attribute10),

Line 429: fnd_api.g_miss_char, oldrow.attribute10,

425: decode(x_attribute9,
426: fnd_api.g_miss_char, oldrow.attribute9,
427: x_attribute9),
428: decode(x_attribute10,
429: fnd_api.g_miss_char, oldrow.attribute10,
430: x_attribute10),
431: decode(x_attribute11,
432: fnd_api.g_miss_char, oldrow.attribute11,
433: x_attribute11),

Line 432: fnd_api.g_miss_char, oldrow.attribute11,

428: decode(x_attribute10,
429: fnd_api.g_miss_char, oldrow.attribute10,
430: x_attribute10),
431: decode(x_attribute11,
432: fnd_api.g_miss_char, oldrow.attribute11,
433: x_attribute11),
434: decode(x_attribute12,
435: fnd_api.g_miss_char, oldrow.attribute12,
436: x_attribute12),

Line 435: fnd_api.g_miss_char, oldrow.attribute12,

431: decode(x_attribute11,
432: fnd_api.g_miss_char, oldrow.attribute11,
433: x_attribute11),
434: decode(x_attribute12,
435: fnd_api.g_miss_char, oldrow.attribute12,
436: x_attribute12),
437: decode(x_attribute13,
438: fnd_api.g_miss_char, oldrow.attribute13,
439: x_attribute13),

Line 438: fnd_api.g_miss_char, oldrow.attribute13,

434: decode(x_attribute12,
435: fnd_api.g_miss_char, oldrow.attribute12,
436: x_attribute12),
437: decode(x_attribute13,
438: fnd_api.g_miss_char, oldrow.attribute13,
439: x_attribute13),
440: decode(x_attribute14,
441: fnd_api.g_miss_char, oldrow.attribute14,
442: x_attribute14),

Line 441: fnd_api.g_miss_char, oldrow.attribute14,

437: decode(x_attribute13,
438: fnd_api.g_miss_char, oldrow.attribute13,
439: x_attribute13),
440: decode(x_attribute14,
441: fnd_api.g_miss_char, oldrow.attribute14,
442: x_attribute14),
443: decode(x_attribute15,
444: fnd_api.g_miss_char, oldrow.attribute15,
445: x_attribute15)

Line 444: fnd_api.g_miss_char, oldrow.attribute15,

440: decode(x_attribute14,
441: fnd_api.g_miss_char, oldrow.attribute14,
442: x_attribute14),
443: decode(x_attribute15,
444: fnd_api.g_miss_char, oldrow.attribute15,
445: x_attribute15)
446: INTO
447: l_srp_role_id,
448: l_role_plan_id,

Line 509: (Nvl(x_end_date,fnd_api.g_miss_date) <>

505:
506: -- The periods have changed we need maintain the period dependent
507: -- information. do not need to do srp_quotas and srp_rate_assigns
508: IF (x_start_date <> oldrow.start_date) OR
509: (Nvl(x_end_date,fnd_api.g_miss_date) <>
510: Nvl(oldrow.end_date,fnd_api.g_miss_date)) THEN
511: -- start_date remanin unchanged
512: IF x_start_date = oldrow.start_date THEN
513: IF x_end_date IS NULL THEN

Line 510: Nvl(oldrow.end_date,fnd_api.g_miss_date)) THEN

506: -- The periods have changed we need maintain the period dependent
507: -- information. do not need to do srp_quotas and srp_rate_assigns
508: IF (x_start_date <> oldrow.start_date) OR
509: (Nvl(x_end_date,fnd_api.g_miss_date) <>
510: Nvl(oldrow.end_date,fnd_api.g_miss_date)) THEN
511: -- start_date remanin unchanged
512: IF x_start_date = oldrow.start_date THEN
513: IF x_end_date IS NULL THEN
514: -- oldrow.end_date is not null,extend end_date