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_ELECTION_INFORMATION dependencies on BEN_SSPNDD_ENROLLMENT

Line 4807: -- ben_sspndd_enrollment.g_use_new_result

4803: l_object_version_number number;
4804: l_dummy_number number;
4805: --
4806: -- current result info
4807: -- ben_sspndd_enrollment.g_use_new_result
4808: --
4809: cursor c_current_result_info(v_prtt_enrt_rslt_id number) is
4810: select pen.enrt_cvg_strt_dt,
4811: pen.enrt_cvg_thru_dt,

Line 5826: --IF NVL(ben_sspndd_enrollment.g_cfw_flag,'N') = 'N' THEN

5822: else
5823: --
5824: close c_current_result_info;
5825: --
5826: --IF NVL(ben_sspndd_enrollment.g_cfw_flag,'N') = 'N' THEN
5827: --
5828: -- BUG 5985777 This is the case where action items from the past life event
5829: -- are completed in future.
5830: --

Line 6011: (( ben_sspndd_enrollment.g_use_new_result=false and

6007: --
6008: if ( p_prtt_enrt_rslt_id is not null and
6009: l_global_epe_rec.prtt_enrt_rslt_id is not null and
6010: l_global_epe_rec.prtt_enrt_rslt_id=p_prtt_enrt_rslt_id and
6011: (( ben_sspndd_enrollment.g_use_new_result=false and
6012: nvl(l_old_bnft_val,hr_api.g_number)=
6013: nvl(l_global_enb_rec.val,hr_api.g_number)) or
6014: l_old_sspndd_flag = 'Y')) then
6015: if g_debug then

Line 6098: ben_sspndd_enrollment.g_use_new_result=false and /ENH/

6094: if ( p_prtt_enrt_rslt_id is not null and
6095: l_global_epe_rec.prtt_enrt_rslt_id is not null and
6096: l_global_epe_rec.prtt_enrt_rslt_id=p_prtt_enrt_rslt_id and
6097: -- l_use_new_result=false and
6098: ben_sspndd_enrollment.g_use_new_result=false and /*ENH*/
6099: nvl(l_old_bnft_val,hr_api.g_number)= nvl(l_global_enb_rec.val,hr_api.g_number) and
6100: p_enrt_cvg_thru_dt is null and
6101: l_start_new_result = false ) then
6102: if g_debug then

Line 6658: ben_sspndd_enrollment.g_use_new_result=false and /ENH/

6654: if l_global_epe_rec.crntly_enrd_flag = 'Y' and
6655: l_global_epe_rec.prtt_enrt_rslt_id is not null and
6656: l_crntly_enrd_rslt_exists and
6657: -- l_use_new_result=false and
6658: ben_sspndd_enrollment.g_use_new_result=false and /*ENH*/
6659: nvl(l_crntly_enrd_rslt_rec.bnft_amt,hr_api.g_number)=
6660: nvl(l_global_enb_rec.val,hr_api.g_number) and
6661: /* Bug 4954541 - We also need to check if old coverage was non-null and new coverage is null
6662: nvl(l_crntly_enrd_rslt_rec.bnft_amt,hr_api.g_number)=

Line 7033: ben_sspndd_enrollment.g_use_new_result or

7029: nvl(l_global_enb_rec.val,hr_api.g_number)
7030: -- Bug#1807450 added and condition
7031: and p_prtt_enrt_rslt_id is not null) or
7032: -- Added for Interim Coverage /*ENH*/
7033: ben_sspndd_enrollment.g_use_new_result or
7034: (l_global_epe_rec.crntly_enrd_flag = 'Y' and
7035: p_prtt_enrt_rslt_id is null) or -- bug#5105122-called from backout
7036: l_start_new_result then
7037: l_bnft_amt_changed:= TRUE;

Line 7491: -- ben_sspndd_enrollment.g_use_new_result=false) Bug 2543071 Needs to delete if the interim

7487: end if;
7488: --
7489: if p_prtt_enrt_rslt_id is not null -- and
7490: -- l_use_new_result=false then
7491: -- ben_sspndd_enrollment.g_use_new_result=false) Bug 2543071 Needs to delete if the interim
7492: -- is the old enrollment.We create a new enrollment for interim.
7493: or l_start_new_result then /*ENH*/
7494: --
7495: -- If the old enrollment is now the interim coverage

Line 7498: hr_utility.set_location('ben_sspndd_enrollment.g_sspnded_rslt_id ' || ben_sspndd_enrollment.g_sspnded_rslt_id, 1212);

7494: --
7495: -- If the old enrollment is now the interim coverage
7496: -- then don't end it, leave it be.
7497: --
7498: hr_utility.set_location('ben_sspndd_enrollment.g_sspnded_rslt_id ' || ben_sspndd_enrollment.g_sspnded_rslt_id, 1212);
7499: hr_utility.set_location('l_prtt_enrt_interim_id ' || l_prtt_enrt_interim_id, 1212);
7500: hr_utility.set_location('p_prtt_enrt_rslt_id ' || p_prtt_enrt_rslt_id, 1212);
7501: if (l_prtt_enrt_interim_id is null or
7502: l_prtt_enrt_interim_id <> p_prtt_enrt_rslt_id)

Line 7504: and p_prtt_enrt_rslt_id <> nvl(ben_sspndd_enrollment.g_sspnded_rslt_id,-1)

7500: hr_utility.set_location('p_prtt_enrt_rslt_id ' || p_prtt_enrt_rslt_id, 1212);
7501: if (l_prtt_enrt_interim_id is null or
7502: l_prtt_enrt_interim_id <> p_prtt_enrt_rslt_id)
7503: -- 6337803
7504: and p_prtt_enrt_rslt_id <> nvl(ben_sspndd_enrollment.g_sspnded_rslt_id,-1)
7505: then
7506: --
7507: -- deenrol
7508: --

Line 7560: ben_sspndd_enrollment.g_sspnded_rslt_id := null;

7556: if g_debug then
7557: hr_utility.set_location(l_proc, 110);
7558: end if;
7559: -- 6337803 unsetting the pen id to be suspended
7560: ben_sspndd_enrollment.g_sspnded_rslt_id := null;
7561: --
7562: end if;
7563: --
7564: -- For the create return the new ovn

Line 8048: ben_sspndd_enrollment.g_use_new_result :=false ; -- bug 5653168

8044: -- (Any key or derived arguments must be set to null
8045: -- when validation only mode is being used.)
8046: --
8047: p_prtt_enrt_interim_id:=null;
8048: ben_sspndd_enrollment.g_use_new_result :=false ; -- bug 5653168
8049:
8050: if g_debug then
8051: hr_utility.set_location(' Leaving:'||l_proc, 80);
8052: end if;

Line 8064: ben_sspndd_enrollment.g_use_new_result:=false; -- bug 5653168

8060: --
8061: g_enrt_bnft_id:=null;
8062: g_bnft_val:=null;
8063: g_elig_per_elctbl_chc_id:=null;
8064: ben_sspndd_enrollment.g_use_new_result:=false; -- bug 5653168
8065: --
8066: if p_called_from_sspnd = 'N' then
8067: ROLLBACK TO election_information_savepoint;
8068: else