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.

[Home] [Help]

APPS.BEN_CARRY_FORWARD_ITEMS dependencies on BEN_LF_EVT_CLPS_RESTORE

Line 1380: l_rdefault_table_cnt := nvl( ben_lf_evt_clps_restore.g_reinstated_defaults.LAST, 0) + 1;

1376: To add the electable choices to pl/sql table that are carry forwarded. This pl/sql
1377: is scanned to check whether the enrollment record is already carry forwarded by the carry foward logic
1378: while defaulting and reinstating the explicit elections from intervening LE */
1379: hr_utility.set_location ('Carry Fwd epe '||l_choice_info.elig_per_elctbl_chc_id,199);
1380: l_rdefault_table_cnt := nvl( ben_lf_evt_clps_restore.g_reinstated_defaults.LAST, 0) + 1;
1381: ben_lf_evt_clps_restore.g_reinstated_defaults(l_rdefault_table_cnt) := l_choice_info.elig_per_elctbl_chc_id;
1382: /* End of Enhancement Bug 8716679*/
1383:
1384: ben_election_information.election_information

Line 1381: ben_lf_evt_clps_restore.g_reinstated_defaults(l_rdefault_table_cnt) := l_choice_info.elig_per_elctbl_chc_id;

1377: is scanned to check whether the enrollment record is already carry forwarded by the carry foward logic
1378: while defaulting and reinstating the explicit elections from intervening LE */
1379: hr_utility.set_location ('Carry Fwd epe '||l_choice_info.elig_per_elctbl_chc_id,199);
1380: l_rdefault_table_cnt := nvl( ben_lf_evt_clps_restore.g_reinstated_defaults.LAST, 0) + 1;
1381: ben_lf_evt_clps_restore.g_reinstated_defaults(l_rdefault_table_cnt) := l_choice_info.elig_per_elctbl_chc_id;
1382: /* End of Enhancement Bug 8716679*/
1383:
1384: ben_election_information.election_information
1385: (p_elig_per_elctbl_chc_id => l_choice_info.elig_per_elctbl_chc_id,

Line 1663: if(ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list.count is not null) then

1659: --
1660: end if;
1661:
1662: /* Bug 8900007:Reinstate the action items and certifications of carry forwarded enrollments*/
1663: if(ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list.count is not null) then
1664: hr_utility.set_location('sspnd list1 ',310);
1665: if(ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list.count > 0 ) then
1666: for i IN ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list.FIRST..ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list.LAST loop
1667: hr_utility.set_location('sspnd list ' || ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list(i).PGM_ID||' '||

Line 1665: if(ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list.count > 0 ) then

1661:
1662: /* Bug 8900007:Reinstate the action items and certifications of carry forwarded enrollments*/
1663: if(ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list.count is not null) then
1664: hr_utility.set_location('sspnd list1 ',310);
1665: if(ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list.count > 0 ) then
1666: for i IN ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list.FIRST..ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list.LAST loop
1667: hr_utility.set_location('sspnd list ' || ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list(i).PGM_ID||' '||
1668: ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list(i).pl_id , 10);
1669: hr_utility.set_location('l_choice_info ' || l_choice_info.pgm_id||' '||l_choice_info.pl_id , 10);

Line 1666: for i IN ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list.FIRST..ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list.LAST loop

1662: /* Bug 8900007:Reinstate the action items and certifications of carry forwarded enrollments*/
1663: if(ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list.count is not null) then
1664: hr_utility.set_location('sspnd list1 ',310);
1665: if(ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list.count > 0 ) then
1666: for i IN ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list.FIRST..ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list.LAST loop
1667: hr_utility.set_location('sspnd list ' || ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list(i).PGM_ID||' '||
1668: ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list(i).pl_id , 10);
1669: hr_utility.set_location('l_choice_info ' || l_choice_info.pgm_id||' '||l_choice_info.pl_id , 10);
1670: if( nvl(ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list(i).PGM_ID,-1) = nvl(l_choice_info.pgm_id,-1)

Line 1667: hr_utility.set_location('sspnd list ' || ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list(i).PGM_ID||' '||

1663: if(ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list.count is not null) then
1664: hr_utility.set_location('sspnd list1 ',310);
1665: if(ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list.count > 0 ) then
1666: for i IN ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list.FIRST..ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list.LAST loop
1667: hr_utility.set_location('sspnd list ' || ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list(i).PGM_ID||' '||
1668: ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list(i).pl_id , 10);
1669: hr_utility.set_location('l_choice_info ' || l_choice_info.pgm_id||' '||l_choice_info.pl_id , 10);
1670: if( nvl(ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list(i).PGM_ID,-1) = nvl(l_choice_info.pgm_id,-1)
1671: and nvl(ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list(i).pl_id,-1) = nvl(l_choice_info.pl_id,-1)

Line 1668: ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list(i).pl_id , 10);

1664: hr_utility.set_location('sspnd list1 ',310);
1665: if(ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list.count > 0 ) then
1666: for i IN ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list.FIRST..ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list.LAST loop
1667: hr_utility.set_location('sspnd list ' || ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list(i).PGM_ID||' '||
1668: ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list(i).pl_id , 10);
1669: hr_utility.set_location('l_choice_info ' || l_choice_info.pgm_id||' '||l_choice_info.pl_id , 10);
1670: if( nvl(ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list(i).PGM_ID,-1) = nvl(l_choice_info.pgm_id,-1)
1671: and nvl(ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list(i).pl_id,-1) = nvl(l_choice_info.pl_id,-1)
1672: and nvl(ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list(i).pl_typ_id,-1) = nvl(l_choice_info.pl_typ_id,-1) ) then

Line 1670: if( nvl(ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list(i).PGM_ID,-1) = nvl(l_choice_info.pgm_id,-1)

1666: for i IN ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list.FIRST..ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list.LAST loop
1667: hr_utility.set_location('sspnd list ' || ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list(i).PGM_ID||' '||
1668: ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list(i).pl_id , 10);
1669: hr_utility.set_location('l_choice_info ' || l_choice_info.pgm_id||' '||l_choice_info.pl_id , 10);
1670: if( nvl(ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list(i).PGM_ID,-1) = nvl(l_choice_info.pgm_id,-1)
1671: and nvl(ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list(i).pl_id,-1) = nvl(l_choice_info.pl_id,-1)
1672: and nvl(ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list(i).pl_typ_id,-1) = nvl(l_choice_info.pl_typ_id,-1) ) then
1673: ben_lf_evt_clps_restore.reinstate_pcs_per_pen(
1674: p_person_id => ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list(i).person_id

Line 1671: and nvl(ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list(i).pl_id,-1) = nvl(l_choice_info.pl_id,-1)

1667: hr_utility.set_location('sspnd list ' || ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list(i).PGM_ID||' '||
1668: ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list(i).pl_id , 10);
1669: hr_utility.set_location('l_choice_info ' || l_choice_info.pgm_id||' '||l_choice_info.pl_id , 10);
1670: if( nvl(ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list(i).PGM_ID,-1) = nvl(l_choice_info.pgm_id,-1)
1671: and nvl(ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list(i).pl_id,-1) = nvl(l_choice_info.pl_id,-1)
1672: and nvl(ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list(i).pl_typ_id,-1) = nvl(l_choice_info.pl_typ_id,-1) ) then
1673: ben_lf_evt_clps_restore.reinstate_pcs_per_pen(
1674: p_person_id => ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list(i).person_id
1675: ,p_bckdt_prtt_enrt_rslt_id => ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list(i).prtt_enrt_rslt_id

Line 1672: and nvl(ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list(i).pl_typ_id,-1) = nvl(l_choice_info.pl_typ_id,-1) ) then

1668: ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list(i).pl_id , 10);
1669: hr_utility.set_location('l_choice_info ' || l_choice_info.pgm_id||' '||l_choice_info.pl_id , 10);
1670: if( nvl(ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list(i).PGM_ID,-1) = nvl(l_choice_info.pgm_id,-1)
1671: and nvl(ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list(i).pl_id,-1) = nvl(l_choice_info.pl_id,-1)
1672: and nvl(ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list(i).pl_typ_id,-1) = nvl(l_choice_info.pl_typ_id,-1) ) then
1673: ben_lf_evt_clps_restore.reinstate_pcs_per_pen(
1674: p_person_id => ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list(i).person_id
1675: ,p_bckdt_prtt_enrt_rslt_id => ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list(i).prtt_enrt_rslt_id
1676: ,p_prtt_enrt_rslt_id => l_prtt_enrt_rslt_id -- pen_ovn_number

Line 1673: ben_lf_evt_clps_restore.reinstate_pcs_per_pen(

1669: hr_utility.set_location('l_choice_info ' || l_choice_info.pgm_id||' '||l_choice_info.pl_id , 10);
1670: if( nvl(ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list(i).PGM_ID,-1) = nvl(l_choice_info.pgm_id,-1)
1671: and nvl(ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list(i).pl_id,-1) = nvl(l_choice_info.pl_id,-1)
1672: and nvl(ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list(i).pl_typ_id,-1) = nvl(l_choice_info.pl_typ_id,-1) ) then
1673: ben_lf_evt_clps_restore.reinstate_pcs_per_pen(
1674: p_person_id => ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list(i).person_id
1675: ,p_bckdt_prtt_enrt_rslt_id => ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list(i).prtt_enrt_rslt_id
1676: ,p_prtt_enrt_rslt_id => l_prtt_enrt_rslt_id -- pen_ovn_number
1677: ,p_rslt_object_version_number => l_object_version_number -- prtt_enrt_rslt_id

Line 1674: p_person_id => ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list(i).person_id

1670: if( nvl(ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list(i).PGM_ID,-1) = nvl(l_choice_info.pgm_id,-1)
1671: and nvl(ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list(i).pl_id,-1) = nvl(l_choice_info.pl_id,-1)
1672: and nvl(ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list(i).pl_typ_id,-1) = nvl(l_choice_info.pl_typ_id,-1) ) then
1673: ben_lf_evt_clps_restore.reinstate_pcs_per_pen(
1674: p_person_id => ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list(i).person_id
1675: ,p_bckdt_prtt_enrt_rslt_id => ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list(i).prtt_enrt_rslt_id
1676: ,p_prtt_enrt_rslt_id => l_prtt_enrt_rslt_id -- pen_ovn_number
1677: ,p_rslt_object_version_number => l_object_version_number -- prtt_enrt_rslt_id
1678: ,p_business_group_id => p_business_group_id

Line 1675: ,p_bckdt_prtt_enrt_rslt_id => ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list(i).prtt_enrt_rslt_id

1671: and nvl(ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list(i).pl_id,-1) = nvl(l_choice_info.pl_id,-1)
1672: and nvl(ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list(i).pl_typ_id,-1) = nvl(l_choice_info.pl_typ_id,-1) ) then
1673: ben_lf_evt_clps_restore.reinstate_pcs_per_pen(
1674: p_person_id => ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list(i).person_id
1675: ,p_bckdt_prtt_enrt_rslt_id => ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list(i).prtt_enrt_rslt_id
1676: ,p_prtt_enrt_rslt_id => l_prtt_enrt_rslt_id -- pen_ovn_number
1677: ,p_rslt_object_version_number => l_object_version_number -- prtt_enrt_rslt_id
1678: ,p_business_group_id => p_business_group_id
1679: ,p_per_in_ler_id => l_per_in_ler_id

Line 1681: ,p_bckdt_per_in_ler_id => ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list(i).PER_IN_LER_ID

1677: ,p_rslt_object_version_number => l_object_version_number -- prtt_enrt_rslt_id
1678: ,p_business_group_id => p_business_group_id
1679: ,p_per_in_ler_id => l_per_in_ler_id
1680: ,p_effective_date => l_effective_start_date
1681: ,p_bckdt_per_in_ler_id => ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list(i).PER_IN_LER_ID
1682: ,p_prtt_enrt_actn_id => null
1683: ,p_bckdt_prtt_enrt_actn_id => null);
1684:
1685: ben_lf_evt_clps_restore.reinstate_pea_per_pen(

Line 1685: ben_lf_evt_clps_restore.reinstate_pea_per_pen(

1681: ,p_bckdt_per_in_ler_id => ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list(i).PER_IN_LER_ID
1682: ,p_prtt_enrt_actn_id => null
1683: ,p_bckdt_prtt_enrt_actn_id => null);
1684:
1685: ben_lf_evt_clps_restore.reinstate_pea_per_pen(
1686: p_person_id => ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list(i).person_id
1687: ,p_bckdt_prtt_enrt_rslt_id => ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list(i).prtt_enrt_rslt_id
1688: ,p_prtt_enrt_rslt_id => l_prtt_enrt_rslt_id -- pen_ovn_number
1689: ,p_rslt_object_version_number => l_object_version_number -- prtt_enrt_rslt_id

Line 1686: p_person_id => ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list(i).person_id

1682: ,p_prtt_enrt_actn_id => null
1683: ,p_bckdt_prtt_enrt_actn_id => null);
1684:
1685: ben_lf_evt_clps_restore.reinstate_pea_per_pen(
1686: p_person_id => ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list(i).person_id
1687: ,p_bckdt_prtt_enrt_rslt_id => ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list(i).prtt_enrt_rslt_id
1688: ,p_prtt_enrt_rslt_id => l_prtt_enrt_rslt_id -- pen_ovn_number
1689: ,p_rslt_object_version_number => l_object_version_number -- prtt_enrt_rslt_id
1690: ,p_business_group_id => p_business_group_id

Line 1687: ,p_bckdt_prtt_enrt_rslt_id => ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list(i).prtt_enrt_rslt_id

1683: ,p_bckdt_prtt_enrt_actn_id => null);
1684:
1685: ben_lf_evt_clps_restore.reinstate_pea_per_pen(
1686: p_person_id => ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list(i).person_id
1687: ,p_bckdt_prtt_enrt_rslt_id => ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list(i).prtt_enrt_rslt_id
1688: ,p_prtt_enrt_rslt_id => l_prtt_enrt_rslt_id -- pen_ovn_number
1689: ,p_rslt_object_version_number => l_object_version_number -- prtt_enrt_rslt_id
1690: ,p_business_group_id => p_business_group_id
1691: ,p_per_in_ler_id => l_per_in_ler_id

Line 1693: ,p_bckdt_per_in_ler_id => ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list(i).PER_IN_LER_ID

1689: ,p_rslt_object_version_number => l_object_version_number -- prtt_enrt_rslt_id
1690: ,p_business_group_id => p_business_group_id
1691: ,p_per_in_ler_id => l_per_in_ler_id
1692: ,p_effective_date => l_effective_start_date
1693: ,p_bckdt_per_in_ler_id => ben_lf_evt_clps_restore.g_bckdt_sspndd_pen_list(i).PER_IN_LER_ID
1694: );
1695: end if;
1696: end loop;
1697: end if;