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_BACK_OUT_LIFE_EVENT dependencies on BEN_ELIG_CVRD_DPNT_F

Line 56: BEN_ELIG_CVRD_DPNT_F

52: BEN_BNFT_PRVDD_LDGR_F
53: BEN_PRMRY_CARE_PRVDR_F
54: Delete logic changed for
55: BEN_PRTT_ENRT_RSLT_F
56: BEN_ELIG_CVRD_DPNT_F
57: BEN_PL_BNF_F
58: BEN_PRTT_RT_VAL and
59: communication tables
60: to use datetrack mode as future

Line 94: ben_elig_cvrd_dpnt_f, ben_pil_elctbl_chc_popl,

90: pl_bnf_ctfn_prvdd,all per_cm% tables.
91: Removed because of per_in_ler status checks
92: 08-jul-99 pbodla 115.17 Code to backup data from ben_pl_bnf_f, BEN_PRTT_RT_VAL,
93: ben_prtt_prem, ben_elig_per, ben_elig_per_opt
94: ben_elig_cvrd_dpnt_f, ben_pil_elctbl_chc_popl,
95: ben_prtt_enrt_rslt_f added.
96: 09-jul-99 shdas 115.18 Moved unprocess_ptnl_ler proc here from benptnle.
97: 15-jul-99 jcarpent 115.19 Added calls to ben_ext_chlg.log_benefit_chg
98: 24-Aug-99 maagrawa 115.20 Dependents table changes.

Line 205: BEN_ELIG_CVRD_DPNT_F

201: of the p_routines when
202: l_effective_date passed is
203: not EOT.
204: Affect p_routines:
205: BEN_ELIG_CVRD_DPNT_F
206: BEN_ELIG_PER_F
207: BEN_ELIG_PER_OPT_F
208: BEN_PRTT_PREM_F
209: BEN_PL_BNF_F

Line 1644: -- BEN_ELIG_CVRD_DPNT_F (PDP)

1640: -- BEN_ELIG_PER_ELCTBL_CHC (EPE) (not deleted, join to pil to check status)
1641: -- BEN_ENRT_BNFT (ENB) (cascade delete in epe api, but epe not deleted)
1642: -- BEN_ENRT_RT (ECR) (cascade delete in epe api, but epe not deleted)
1643: -- BEN_ENRT_CVG_N_RT_CTFN (ECC) (cascade delete in epe api, but epe not deleted)
1644: -- BEN_ELIG_CVRD_DPNT_F (PDP)
1645: -- BEN_ELIG_PER_F (PEP)
1646: -- BEN_ELIG_PER_OPT_F (EPO)
1647: -- BEN_CVRD_DPNT_CTFN_PRVDD_F (CCP)
1648: -- BEN_PER_CM_F (PCM) (join to pil to check status)

Line 1742: delete_routine(p_routine => 'BEN_ELIG_CVRD_DPNT_F',

1738: p_benefit_action_id => NULL);
1739: --
1740: END IF ;
1741: -- CFW
1742: delete_routine(p_routine => 'BEN_ELIG_CVRD_DPNT_F',
1743: p_per_in_ler_id => p_per_in_ler_id,
1744: p_business_group_id => p_business_group_id,
1745: p_bckdt_prtt_enrt_rslt_id => p_bckdt_prtt_enrt_rslt_id,
1746: p_copy_only => p_copy_only,

Line 3093: -- START ----> DELETE ROUTINE FOR BEN_ELIG_CVRD_DPNT_F

3089:
3090: --
3091: -- END ----> DELETE ROUTINE FOR BEN_PRTT_PREM_F
3092: --
3093: -- START ----> DELETE ROUTINE FOR BEN_ELIG_CVRD_DPNT_F
3094: --
3095: -- Source Table
3096: -- BEN_PER_IN_LER
3097: --

Line 3101: cursor c_ben_elig_cvrd_dpnt_f is

3097: --
3098: -- Bug 5222 : Removed the effective date check.
3099: -- See comments at c_ben_prtt_enrt_rslt_f cursor.
3100: --
3101: cursor c_ben_elig_cvrd_dpnt_f is
3102: select pdp.elig_cvrd_dpnt_id,
3103: pdp.object_version_number,
3104: -- bug 5668052
3105: pdp.effective_start_date

Line 3106: from ben_elig_cvrd_dpnt_f pdp,

3102: select pdp.elig_cvrd_dpnt_id,
3103: pdp.object_version_number,
3104: -- bug 5668052
3105: pdp.effective_start_date
3106: from ben_elig_cvrd_dpnt_f pdp,
3107: ben_per_in_ler pil
3108: where pil.per_in_ler_id = p_per_in_ler_id
3109: and pil.business_group_id = p_business_group_id
3110: and pdp.per_in_ler_id = pil.per_in_ler_id

Line 3126: from ben_elig_cvrd_dpnt_f

3122: --
3123: /*
3124: cursor c_pdp_max_esd_of_past_pil(v_elig_cvrd_dpnt_id in number) is
3125: select max(effective_end_date), max(object_version_number)
3126: from ben_elig_cvrd_dpnt_f
3127: where elig_cvrd_dpnt_id = v_elig_cvrd_dpnt_id
3128: and nvl(per_in_ler_id , -1) <> p_per_in_ler_id
3129: and business_group_id = p_business_group_id;
3130: -- and effective_end_date < p_effective_date;

Line 3134: from ben_elig_cvrd_dpnt_f pdp,

3130: -- and effective_end_date < p_effective_date;
3131: */
3132: cursor c_pdp_max_esd_of_past_pil(v_elig_cvrd_dpnt_id in number) is
3133: select pdp.effective_end_date, pdp.object_version_number
3134: from ben_elig_cvrd_dpnt_f pdp,
3135: ben_per_in_ler pil
3136: where pdp.elig_cvrd_dpnt_id = v_elig_cvrd_dpnt_id
3137: and nvl(pdp.per_in_ler_id , -1) <> p_per_in_ler_id
3138: and pdp.business_group_id = p_business_group_id

Line 3149: from ben_elig_cvrd_dpnt_f

3145: --
3146: cursor c_deleted_pdp(v_elig_cvrd_dpnt_id in number,
3147: v_effective_date in date) is
3148: select *
3149: from ben_elig_cvrd_dpnt_f
3150: where elig_cvrd_dpnt_id = v_elig_cvrd_dpnt_id
3151: and nvl(per_in_ler_id , -1) = p_per_in_ler_id
3152: and business_group_id = p_business_group_id
3153: and effective_end_date > v_effective_date;

Line 3156: -- END ----> DELETE ROUTINE FOR BEN_ELIG_CVRD_DPNT_F

3152: and business_group_id = p_business_group_id
3153: and effective_end_date > v_effective_date;
3154:
3155: --
3156: -- END ----> DELETE ROUTINE FOR BEN_ELIG_CVRD_DPNT_F
3157: --
3158: -- START ----> DELETE ROUTINE FOR BEN_PL_BNF_F
3159: --
3160: -- Source Table

Line 3641: ben_elig_cvrd_dpnt_f pdp

3637: lcnr.effective_end_date bkp_effective_end_date, -- 7197868
3638: pdp.object_version_number,
3639: pdp.elig_cvrd_dpnt_id
3640: from BEN_LE_CLSN_N_RSTR lcnr,
3641: ben_elig_cvrd_dpnt_f pdp
3642: where lcnr.BKUP_TBL_TYP_CD = 'BEN_PRTT_ENRT_RSLT_F_CORR'
3643: and lcnr.Per_in_ler_ended_id = c_pil_id
3644: and pdp.prtt_enrt_rslt_id = lcnr.bkup_tbl_id
3645: and (pdp.per_in_ler_id = lcnr.per_in_ler_ended_id

Line 3895: from ben_elig_cvrd_dpnt_f pdp

3891: cursor c_futur_del_dpnt (v_prtt_enrt_rslt_id number) is
3892: select pdp.elig_cvrd_dpnt_id,
3893: pdp.object_version_number,
3894: pdp.effective_end_date
3895: from ben_elig_cvrd_dpnt_f pdp
3896: where pdp.effective_end_date <> hr_api.g_eot
3897: and pdp.prtt_enrt_rslt_id = v_prtt_enrt_rslt_id
3898: and pdp.business_group_id = p_business_group_id
3899: order by 1;

Line 3975: if p_routine = 'BEN_ELIG_CVRD_DPNT_F' then

3971: hr_utility.set_location ('Start of '||p_routine,10);
3972: --
3973: -- check which routine we are calling
3974: --
3975: if p_routine = 'BEN_ELIG_CVRD_DPNT_F' then
3976:
3977: -- For dependents, we want to 'un-end' any dpnt records that were ENDED
3978: -- due to the per-in-ler. The 'future-change' date track mode will do that
3979: -- for us.

Line 3986: open c_ben_elig_cvrd_dpnt_f;

3982:
3983: l_prev_pk_id := -1; -- like null
3984:
3985: --
3986: open c_ben_elig_cvrd_dpnt_f;
3987: --
3988: loop
3989: --
3990: fetch c_ben_elig_cvrd_dpnt_f into l_pk_id,

Line 3990: fetch c_ben_elig_cvrd_dpnt_f into l_pk_id,

3986: open c_ben_elig_cvrd_dpnt_f;
3987: --
3988: loop
3989: --
3990: fetch c_ben_elig_cvrd_dpnt_f into l_pk_id,
3991: l_object_version_number,
3992: -- bug 5668052
3993: l_dpnt_eff_start_date;
3994: exit when c_ben_elig_cvrd_dpnt_f%notfound;

Line 3994: exit when c_ben_elig_cvrd_dpnt_f%notfound;

3990: fetch c_ben_elig_cvrd_dpnt_f into l_pk_id,
3991: l_object_version_number,
3992: -- bug 5668052
3993: l_dpnt_eff_start_date;
3994: exit when c_ben_elig_cvrd_dpnt_f%notfound;
3995: --
3996: -- Get the maximum of effective end date for the dependents
3997: -- with past per_in_ler 's.
3998: --

Line 4025: open c_bkp_row('BEN_ELIG_CVRD_DPNT_F',

4021: --
4022: for l_deleted_pdp_rec in c_deleted_pdp(l_pk_id, l_effective_date)
4023: loop
4024: --
4025: open c_bkp_row('BEN_ELIG_CVRD_DPNT_F',
4026: l_deleted_pdp_rec.per_in_ler_id,
4027: l_deleted_pdp_rec.ELIG_CVRD_DPNT_ID,
4028: l_deleted_pdp_rec.object_version_number);
4029: fetch c_bkp_row into l_row_id;

Line 4093: 'BEN_ELIG_CVRD_DPNT_F',

4089: BKUP_TBL_ID,
4090: EFFECTIVE_START_DATE,
4091: EFFECTIVE_END_DATE)
4092: values (
4093: 'BEN_ELIG_CVRD_DPNT_F',
4094: l_deleted_pdp_rec.CVG_STRT_DT,
4095: l_deleted_pdp_rec.CVG_THRU_DT,
4096: l_deleted_pdp_rec.CVG_PNDG_FLAG,
4097: l_deleted_pdp_rec.OVRDN_FLAG,

Line 4154: -- BKUP_TBL_TYP_CD = 'BEN_ELIG_CVRD_DPNT_F'

4150: --
4151: close c_bkp_row;
4152: --
4153: update BEN_LE_CLSN_N_RSTR set
4154: -- BKUP_TBL_TYP_CD = 'BEN_ELIG_CVRD_DPNT_F'
4155: CVG_STRT_DT = l_deleted_pdp_rec.CVG_STRT_DT,
4156: CVG_THRU_DT = l_deleted_pdp_rec.CVG_THRU_DT,
4157: CVG_PNDG_FLAG = l_deleted_pdp_rec.CVG_PNDG_FLAG,
4158: OVRDN_FLAG = l_deleted_pdp_rec.OVRDN_FLAG,

Line 4353: close c_ben_elig_cvrd_dpnt_f;

4349:
4350: l_prev_pk_id := -1;
4351: --
4352:
4353: close c_ben_elig_cvrd_dpnt_f;
4354: --
4355: elsif p_routine = 'BEN_ELIG_PER_F' then
4356:
4357: -- For elig_per, we want to 'un-end' any records that were ENDED

Line 7255: if c_ben_elig_cvrd_dpnt_f%isopen then

7251: g_bolfe_effective_date:=null;
7252: --
7253: -- Handle closing of cursors in case of exception in delete routines
7254: --
7255: if c_ben_elig_cvrd_dpnt_f%isopen then
7256: --
7257: close c_ben_elig_cvrd_dpnt_f;
7258: --
7259: end if;

Line 7257: close c_ben_elig_cvrd_dpnt_f;

7253: -- Handle closing of cursors in case of exception in delete routines
7254: --
7255: if c_ben_elig_cvrd_dpnt_f%isopen then
7256: --
7257: close c_ben_elig_cvrd_dpnt_f;
7258: --
7259: end if;
7260: --
7261: if c_ben_elig_per_f%isopen then