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 1296: -- BEN_ELIG_CVRD_DPNT_F (PDP)

1292: -- BEN_ELIG_PER_ELCTBL_CHC (EPE) (not deleted, join to pil to check status)
1293: -- BEN_ENRT_BNFT (ENB) (cascade delete in epe api, but epe not deleted)
1294: -- BEN_ENRT_RT (ECR) (cascade delete in epe api, but epe not deleted)
1295: -- BEN_ENRT_CVG_N_RT_CTFN (ECC) (cascade delete in epe api, but epe not deleted)
1296: -- BEN_ELIG_CVRD_DPNT_F (PDP)
1297: -- BEN_ELIG_PER_F (PEP)
1298: -- BEN_ELIG_PER_OPT_F (EPO)
1299: -- BEN_CVRD_DPNT_CTFN_PRVDD_F (CCP)
1300: -- BEN_PER_CM_F (PCM) (join to pil to check status)

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

1390: p_benefit_action_id => NULL);
1391: --
1392: END IF ;
1393: -- CFW
1394: delete_routine(p_routine => 'BEN_ELIG_CVRD_DPNT_F',
1395: p_per_in_ler_id => p_per_in_ler_id,
1396: p_business_group_id => p_business_group_id,
1397: p_bckdt_prtt_enrt_rslt_id => p_bckdt_prtt_enrt_rslt_id,
1398: p_copy_only => p_copy_only,

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

2683:
2684: --
2685: -- END ----> DELETE ROUTINE FOR BEN_PRTT_PREM_F
2686: --
2687: -- START ----> DELETE ROUTINE FOR BEN_ELIG_CVRD_DPNT_F
2688: --
2689: -- Source Table
2690: -- BEN_PER_IN_LER
2691: --

Line 2695: cursor c_ben_elig_cvrd_dpnt_f is

2691: --
2692: -- Bug 5222 : Removed the effective date check.
2693: -- See comments at c_ben_prtt_enrt_rslt_f cursor.
2694: --
2695: cursor c_ben_elig_cvrd_dpnt_f is
2696: select pdp.elig_cvrd_dpnt_id,
2697: pdp.object_version_number,
2698: -- bug 5668052
2699: pdp.effective_start_date

Line 2700: from ben_elig_cvrd_dpnt_f pdp,

2696: select pdp.elig_cvrd_dpnt_id,
2697: pdp.object_version_number,
2698: -- bug 5668052
2699: pdp.effective_start_date
2700: from ben_elig_cvrd_dpnt_f pdp,
2701: ben_per_in_ler pil
2702: where pil.per_in_ler_id = p_per_in_ler_id
2703: and pil.business_group_id = p_business_group_id
2704: and pdp.per_in_ler_id = pil.per_in_ler_id

Line 2720: from ben_elig_cvrd_dpnt_f

2716: --
2717: /*
2718: cursor c_pdp_max_esd_of_past_pil(v_elig_cvrd_dpnt_id in number) is
2719: select max(effective_end_date), max(object_version_number)
2720: from ben_elig_cvrd_dpnt_f
2721: where elig_cvrd_dpnt_id = v_elig_cvrd_dpnt_id
2722: and nvl(per_in_ler_id , -1) <> p_per_in_ler_id
2723: and business_group_id = p_business_group_id;
2724: -- and effective_end_date < p_effective_date;

Line 2728: from ben_elig_cvrd_dpnt_f pdp,

2724: -- and effective_end_date < p_effective_date;
2725: */
2726: cursor c_pdp_max_esd_of_past_pil(v_elig_cvrd_dpnt_id in number) is
2727: select pdp.effective_end_date, pdp.object_version_number
2728: from ben_elig_cvrd_dpnt_f pdp,
2729: ben_per_in_ler pil
2730: where pdp.elig_cvrd_dpnt_id = v_elig_cvrd_dpnt_id
2731: and nvl(pdp.per_in_ler_id , -1) <> p_per_in_ler_id
2732: and pdp.business_group_id = p_business_group_id

Line 2743: from ben_elig_cvrd_dpnt_f

2739: --
2740: cursor c_deleted_pdp(v_elig_cvrd_dpnt_id in number,
2741: v_effective_date in date) is
2742: select *
2743: from ben_elig_cvrd_dpnt_f
2744: where elig_cvrd_dpnt_id = v_elig_cvrd_dpnt_id
2745: and nvl(per_in_ler_id , -1) = p_per_in_ler_id
2746: and business_group_id = p_business_group_id
2747: and effective_end_date > v_effective_date;

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

2746: and business_group_id = p_business_group_id
2747: and effective_end_date > v_effective_date;
2748:
2749: --
2750: -- END ----> DELETE ROUTINE FOR BEN_ELIG_CVRD_DPNT_F
2751: --
2752: -- START ----> DELETE ROUTINE FOR BEN_PL_BNF_F
2753: --
2754: -- Source Table

Line 3189: ben_elig_cvrd_dpnt_f pdp

3185: lcnr.effective_end_date bkp_effective_end_date, -- 7197868
3186: pdp.object_version_number,
3187: pdp.elig_cvrd_dpnt_id
3188: from BEN_LE_CLSN_N_RSTR lcnr,
3189: ben_elig_cvrd_dpnt_f pdp
3190: where lcnr.BKUP_TBL_TYP_CD = 'BEN_PRTT_ENRT_RSLT_F_CORR'
3191: and lcnr.Per_in_ler_ended_id = c_pil_id
3192: and pdp.prtt_enrt_rslt_id = lcnr.bkup_tbl_id
3193: and (pdp.per_in_ler_id = lcnr.per_in_ler_ended_id

Line 3419: from ben_elig_cvrd_dpnt_f pdp

3415: cursor c_futur_del_dpnt (v_prtt_enrt_rslt_id number) is
3416: select pdp.elig_cvrd_dpnt_id,
3417: pdp.object_version_number,
3418: pdp.effective_end_date
3419: from ben_elig_cvrd_dpnt_f pdp
3420: where pdp.effective_end_date <> hr_api.g_eot
3421: and pdp.prtt_enrt_rslt_id = v_prtt_enrt_rslt_id
3422: and pdp.business_group_id = p_business_group_id
3423: order by 1;

Line 3497: if p_routine = 'BEN_ELIG_CVRD_DPNT_F' then

3493: hr_utility.set_location ('Start of '||p_routine,10);
3494: --
3495: -- check which routine we are calling
3496: --
3497: if p_routine = 'BEN_ELIG_CVRD_DPNT_F' then
3498:
3499: -- For dependents, we want to 'un-end' any dpnt records that were ENDED
3500: -- due to the per-in-ler. The 'future-change' date track mode will do that
3501: -- for us.

Line 3508: open c_ben_elig_cvrd_dpnt_f;

3504:
3505: l_prev_pk_id := -1; -- like null
3506:
3507: --
3508: open c_ben_elig_cvrd_dpnt_f;
3509: --
3510: loop
3511: --
3512: fetch c_ben_elig_cvrd_dpnt_f into l_pk_id,

Line 3512: fetch c_ben_elig_cvrd_dpnt_f into l_pk_id,

3508: open c_ben_elig_cvrd_dpnt_f;
3509: --
3510: loop
3511: --
3512: fetch c_ben_elig_cvrd_dpnt_f into l_pk_id,
3513: l_object_version_number,
3514: -- bug 5668052
3515: l_dpnt_eff_start_date;
3516: exit when c_ben_elig_cvrd_dpnt_f%notfound;

Line 3516: exit when c_ben_elig_cvrd_dpnt_f%notfound;

3512: fetch c_ben_elig_cvrd_dpnt_f into l_pk_id,
3513: l_object_version_number,
3514: -- bug 5668052
3515: l_dpnt_eff_start_date;
3516: exit when c_ben_elig_cvrd_dpnt_f%notfound;
3517: --
3518: -- Get the maximum of effective end date for the dependents
3519: -- with past per_in_ler 's.
3520: --

Line 3547: open c_bkp_row('BEN_ELIG_CVRD_DPNT_F',

3543: --
3544: for l_deleted_pdp_rec in c_deleted_pdp(l_pk_id, l_effective_date)
3545: loop
3546: --
3547: open c_bkp_row('BEN_ELIG_CVRD_DPNT_F',
3548: l_deleted_pdp_rec.per_in_ler_id,
3549: l_deleted_pdp_rec.ELIG_CVRD_DPNT_ID,
3550: l_deleted_pdp_rec.object_version_number);
3551: fetch c_bkp_row into l_row_id;

Line 3615: 'BEN_ELIG_CVRD_DPNT_F',

3611: BKUP_TBL_ID,
3612: EFFECTIVE_START_DATE,
3613: EFFECTIVE_END_DATE)
3614: values (
3615: 'BEN_ELIG_CVRD_DPNT_F',
3616: l_deleted_pdp_rec.CVG_STRT_DT,
3617: l_deleted_pdp_rec.CVG_THRU_DT,
3618: l_deleted_pdp_rec.CVG_PNDG_FLAG,
3619: l_deleted_pdp_rec.OVRDN_FLAG,

Line 3676: -- BKUP_TBL_TYP_CD = 'BEN_ELIG_CVRD_DPNT_F'

3672: --
3673: close c_bkp_row;
3674: --
3675: update BEN_LE_CLSN_N_RSTR set
3676: -- BKUP_TBL_TYP_CD = 'BEN_ELIG_CVRD_DPNT_F'
3677: CVG_STRT_DT = l_deleted_pdp_rec.CVG_STRT_DT,
3678: CVG_THRU_DT = l_deleted_pdp_rec.CVG_THRU_DT,
3679: CVG_PNDG_FLAG = l_deleted_pdp_rec.CVG_PNDG_FLAG,
3680: OVRDN_FLAG = l_deleted_pdp_rec.OVRDN_FLAG,

Line 3875: close c_ben_elig_cvrd_dpnt_f;

3871:
3872: l_prev_pk_id := -1;
3873: --
3874:
3875: close c_ben_elig_cvrd_dpnt_f;
3876: --
3877: elsif p_routine = 'BEN_ELIG_PER_F' then
3878:
3879: -- For elig_per, we want to 'un-end' any records that were ENDED

Line 6603: if c_ben_elig_cvrd_dpnt_f%isopen then

6599: g_bolfe_effective_date:=null;
6600: --
6601: -- Handle closing of cursors in case of exception in delete routines
6602: --
6603: if c_ben_elig_cvrd_dpnt_f%isopen then
6604: --
6605: close c_ben_elig_cvrd_dpnt_f;
6606: --
6607: end if;

Line 6605: close c_ben_elig_cvrd_dpnt_f;

6601: -- Handle closing of cursors in case of exception in delete routines
6602: --
6603: if c_ben_elig_cvrd_dpnt_f%isopen then
6604: --
6605: close c_ben_elig_cvrd_dpnt_f;
6606: --
6607: end if;
6608: --
6609: if c_ben_elig_per_f%isopen then