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.BEN_EFC_REPORTING dependencies on HR_API

Line 493: -- in hv calculation for hr_api.g_eot-hr_api.g_sot.

489: p_success_val_set.last
490: loop
491: --
492: -- Note: Assigned to variable to avoid PLSQL error when adding
493: -- in hv calculation for hr_api.g_eot-hr_api.g_sot.
494: --
495: l_enddays := nvl(p_success_val_set(ele_num).eed,hr_api.g_eot)-hr_api.g_sot;
496: --
497: l_hv := mod(p_success_val_set(ele_num).id,ben_hash_utility.get_hash_key)

Line 495: l_enddays := nvl(p_success_val_set(ele_num).eed,hr_api.g_eot)-hr_api.g_sot;

491: --
492: -- Note: Assigned to variable to avoid PLSQL error when adding
493: -- in hv calculation for hr_api.g_eot-hr_api.g_sot.
494: --
495: l_enddays := nvl(p_success_val_set(ele_num).eed,hr_api.g_eot)-hr_api.g_sot;
496: --
497: l_hv := mod(p_success_val_set(ele_num).id,ben_hash_utility.get_hash_key)
498: +nvl(p_success_val_set(ele_num).esd,hr_api.g_eot)-hr_api.g_sot
499: +l_enddays

Line 498: +nvl(p_success_val_set(ele_num).esd,hr_api.g_eot)-hr_api.g_sot

494: --
495: l_enddays := nvl(p_success_val_set(ele_num).eed,hr_api.g_eot)-hr_api.g_sot;
496: --
497: l_hv := mod(p_success_val_set(ele_num).id,ben_hash_utility.get_hash_key)
498: +nvl(p_success_val_set(ele_num).esd,hr_api.g_eot)-hr_api.g_sot
499: +l_enddays
500: ;
501: --
502: if l_hv is null then

Line 510: and nvl(l_dupval_set(l_hv).esd,hr_api.g_eot) = nvl(p_success_val_set(ele_num).esd,hr_api.g_eot)

506: --
507: elsif l_dupval_set.exists(l_hv) then
508: --
509: if (l_dupval_set(l_hv).unqval = p_success_val_set(ele_num).id
510: and nvl(l_dupval_set(l_hv).esd,hr_api.g_eot) = nvl(p_success_val_set(ele_num).esd,hr_api.g_eot)
511: and nvl(l_dupval_set(l_hv).eed,hr_api.g_eot) = nvl(p_success_val_set(ele_num).eed,hr_api.g_eot)
512: )
513: or p_success_val_set(ele_num).id is null
514: then

Line 511: and nvl(l_dupval_set(l_hv).eed,hr_api.g_eot) = nvl(p_success_val_set(ele_num).eed,hr_api.g_eot)

507: elsif l_dupval_set.exists(l_hv) then
508: --
509: if (l_dupval_set(l_hv).unqval = p_success_val_set(ele_num).id
510: and nvl(l_dupval_set(l_hv).esd,hr_api.g_eot) = nvl(p_success_val_set(ele_num).esd,hr_api.g_eot)
511: and nvl(l_dupval_set(l_hv).eed,hr_api.g_eot) = nvl(p_success_val_set(ele_num).eed,hr_api.g_eot)
512: )
513: or p_success_val_set(ele_num).id is null
514: then
515: --

Line 550: l_enddays := nvl(l_fatal_error_val_set(ele_num).eed,hr_api.g_eot)-hr_api.g_sot;

546: for ele_num in l_fatal_error_val_set.first ..
547: l_fatal_error_val_set.last
548: loop
549: --
550: l_enddays := nvl(l_fatal_error_val_set(ele_num).eed,hr_api.g_eot)-hr_api.g_sot;
551: --
552: l_hv := mod(l_fatal_error_val_set(ele_num).id,ben_hash_utility.get_hash_key)
553: +nvl(l_fatal_error_val_set(ele_num).esd,hr_api.g_eot)-hr_api.g_sot
554: +l_enddays

Line 553: +nvl(l_fatal_error_val_set(ele_num).esd,hr_api.g_eot)-hr_api.g_sot

549: --
550: l_enddays := nvl(l_fatal_error_val_set(ele_num).eed,hr_api.g_eot)-hr_api.g_sot;
551: --
552: l_hv := mod(l_fatal_error_val_set(ele_num).id,ben_hash_utility.get_hash_key)
553: +nvl(l_fatal_error_val_set(ele_num).esd,hr_api.g_eot)-hr_api.g_sot
554: +l_enddays
555: ;
556: --
557: if l_hv is null then

Line 565: and nvl(l_dupval_set(l_hv).esd,hr_api.g_eot) = nvl(l_fatal_error_val_set(ele_num).esd,hr_api.g_eot)

561: --
562: elsif l_dupval_set.exists(l_hv) then
563: --
564: if (l_dupval_set(l_hv).unqval = l_fatal_error_val_set(ele_num).id
565: and nvl(l_dupval_set(l_hv).esd,hr_api.g_eot) = nvl(l_fatal_error_val_set(ele_num).esd,hr_api.g_eot)
566: and nvl(l_dupval_set(l_hv).eed,hr_api.g_eot) = nvl(l_fatal_error_val_set(ele_num).eed,hr_api.g_eot)
567: )
568: or l_fatal_error_val_set(ele_num).id is null
569: then

Line 566: and nvl(l_dupval_set(l_hv).eed,hr_api.g_eot) = nvl(l_fatal_error_val_set(ele_num).eed,hr_api.g_eot)

562: elsif l_dupval_set.exists(l_hv) then
563: --
564: if (l_dupval_set(l_hv).unqval = l_fatal_error_val_set(ele_num).id
565: and nvl(l_dupval_set(l_hv).esd,hr_api.g_eot) = nvl(l_fatal_error_val_set(ele_num).esd,hr_api.g_eot)
566: and nvl(l_dupval_set(l_hv).eed,hr_api.g_eot) = nvl(l_fatal_error_val_set(ele_num).eed,hr_api.g_eot)
567: )
568: or l_fatal_error_val_set(ele_num).id is null
569: then
570: --

Line 790: if nvl(l_fatal_error_val_set(errele_num).credt,hr_api.g_sot)

786: l_unqval_set(unqrow).count := l_unqval_set(unqrow).count+1;
787: --
788: -- Check for more recent creation date
789: --
790: if nvl(l_fatal_error_val_set(errele_num).credt,hr_api.g_sot)
791: > nvl(l_unqval_set(unqrow).mxcredt,hr_api.g_sot)
792: then
793: --
794: l_unqval_set(unqrow).mxcredt := l_fatal_error_val_set(errele_num).credt;

Line 791: > nvl(l_unqval_set(unqrow).mxcredt,hr_api.g_sot)

787: --
788: -- Check for more recent creation date
789: --
790: if nvl(l_fatal_error_val_set(errele_num).credt,hr_api.g_sot)
791: > nvl(l_unqval_set(unqrow).mxcredt,hr_api.g_sot)
792: then
793: --
794: l_unqval_set(unqrow).mxcredt := l_fatal_error_val_set(errele_num).credt;
795: --

Line 800: if nvl(l_fatal_error_val_set(errele_num).credt,hr_api.g_sot)

796: end if;
797: --
798: -- Check for more oldest creation date
799: --
800: if nvl(l_fatal_error_val_set(errele_num).credt,hr_api.g_sot)
801: < nvl(l_unqval_set(unqrow).mncredt,hr_api.g_sot)
802: then
803: --
804: l_unqval_set(unqrow).mncredt := l_fatal_error_val_set(errele_num).credt;

Line 801: < nvl(l_unqval_set(unqrow).mncredt,hr_api.g_sot)

797: --
798: -- Check for more oldest creation date
799: --
800: if nvl(l_fatal_error_val_set(errele_num).credt,hr_api.g_sot)
801: < nvl(l_unqval_set(unqrow).mncredt,hr_api.g_sot)
802: then
803: --
804: l_unqval_set(unqrow).mncredt := l_fatal_error_val_set(errele_num).credt;
805: --

Line 878: if nvl(l_unqval_set(errele_num).mxcredt,hr_api.g_sot)

874: l_unqtype_set(unqrow).percentage := l_unqtype_set(unqrow).percentage+l_unqval_set(errele_num).percentage;
875: --
876: -- Check for more recent creation date
877: --
878: if nvl(l_unqval_set(errele_num).mxcredt,hr_api.g_sot)
879: > nvl(l_unqtype_set(unqrow).mxcredt,hr_api.g_sot)
880: then
881: --
882: l_unqtype_set(unqrow).mxcredt := l_unqval_set(errele_num).mxcredt;

Line 879: > nvl(l_unqtype_set(unqrow).mxcredt,hr_api.g_sot)

875: --
876: -- Check for more recent creation date
877: --
878: if nvl(l_unqval_set(errele_num).mxcredt,hr_api.g_sot)
879: > nvl(l_unqtype_set(unqrow).mxcredt,hr_api.g_sot)
880: then
881: --
882: l_unqtype_set(unqrow).mxcredt := l_unqval_set(errele_num).mxcredt;
883: --

Line 888: if nvl(l_unqval_set(errele_num).mncredt,hr_api.g_sot)

884: end if;
885: --
886: -- Check for more recent creation date
887: --
888: if nvl(l_unqval_set(errele_num).mncredt,hr_api.g_sot)
889: < nvl(l_unqtype_set(unqrow).mncredt,hr_api.g_sot)
890: then
891: --
892: l_unqtype_set(unqrow).mncredt := l_unqval_set(errele_num).mncredt;

Line 889: < nvl(l_unqtype_set(unqrow).mncredt,hr_api.g_sot)

885: --
886: -- Check for more recent creation date
887: --
888: if nvl(l_unqval_set(errele_num).mncredt,hr_api.g_sot)
889: < nvl(l_unqtype_set(unqrow).mncredt,hr_api.g_sot)
890: then
891: --
892: l_unqtype_set(unqrow).mncredt := l_unqval_set(errele_num).mncredt;
893: --