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_BNFT_PRVDD_LDGR_F

Line 52: BEN_BNFT_PRVDD_LDGR_F

48: BEN_PER_CM_F
49: - BEN_PER_CM_PRVDD_F
50: - BEN_PER_CM_TRGR_F
51: - BEN_PER_CM_USG_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

Line 234: ben_bnft_prvdd_ldgr_f

230: as effective_date
231: 15-May-2001 kmahendr 115.58 - Bug#1653733 - Rate change only event is not cal-
232: culating prtt_rt_val if event is backed out and
233: reprocessed - added delete_routine for the table
234: ben_bnft_prvdd_ldgr_f
235: 06-Jun-2001 pbodla 115.59 - Bug 1814166 : Causing primary key violation.
236: Commented pep, epo backup as data is not used
237: by benleclr.pkb
238: 16-Jul-01 kmahendr 115.60 - Unrestricted life event not be backedout - added

Line 337: c_ben_bnft_prvdd_ldgr_f

333: 29 Jun 2004 ikasire 115.101 Bug3709516 we are zaping ben_prmry_care_prvdr_f
334: commented the delete_routine for this as we
335: need to reinstate them.
336: 15 Jul 2004 kmahendr 115.102 Bug#3702090 - added exists condition for
337: c_ben_bnft_prvdd_ldgr_f
338: 16 Aug 2004 pbodla 115.103 IREC : Avoid backing out contact pils
339: iRec mode p_backout_contact_pils
340: 25 Aug 2004 pbodla 115.104 CFW : 2534391 :NEED TO LEAVE ACTION
341: ITEMS CERTIFICATIONS on subsequent

Line 406: p_routine = 'BEN_BNFT_PRVDD_LDGR_F'

402: fetch future dated LE.
403: 26-Jul-2007 sshetty 115.141 Bug 6216828, Fixed status code
404: issue in enrollment results table
405: 04-Sep-2007 swjain 115.142 Bug 6376239 : Made changes in delete_routine for
406: p_routine = 'BEN_BNFT_PRVDD_LDGR_F'
407: 07-Dec-2007 rtagarra 115.143 Bug 6489602 :Modified the cursor c_BEN_LE_CLSN_N_RSTR_corr.
408: 22-Feb-2008 rtagarra 115.144 6840074
409: 29-feb-2008 bachakra 115.146 Bug 6620291: Modified Cursor get_contacts_pils.
410: 03-mar-2008 bachakra 115.147 Bug 6632568: Modified Cursor c_corr_result_exist

Line 1287: -- BEN_BNFT_PRVDD_LDGR_F (BPL)(join to pil to check status)

1283: -- BEN_PER_IN_LER (PIL)
1284: -- BEN_PRTT_ENRT_RSLT_F (PEN)
1285: -- BEN_PL_BNF_F (PBN) (join to pil to check status)
1286: -- BEN_PRTT_ENRT_ACTN_F (PEA) (join to pil to check status)
1287: -- BEN_BNFT_PRVDD_LDGR_F (BPL)(join to pil to check status)
1288: -- BEN_PRTT_RT_VAL (PRV)
1289: -- BEN_PRTT_REIMBMT_RQST_F
1290: -- BEN_PL_BNF_CTFN_PRVDD_F (PBC)(join to pil to check status)
1291: -- BEN_PRTT_ENRT_CTFN_PRVDD_F (PCS)(join to pil to check status)

Line 1431: delete_routine(p_routine => 'BEN_BNFT_PRVDD_LDGR_F',

1427: p_copy_only => p_copy_only,
1428: p_effective_date => p_effective_date);
1429:
1430: -- delete credit ledger rows
1431: delete_routine(p_routine => 'BEN_BNFT_PRVDD_LDGR_F',
1432: p_per_in_ler_id => p_per_in_ler_id,
1433: p_business_group_id => p_business_group_id,
1434: p_bckdt_prtt_enrt_rslt_id => p_bckdt_prtt_enrt_rslt_id,
1435: p_copy_only => p_copy_only,

Line 3275: -- START ----> DELETE ROUTINE FOR BEN_BNFT_PRVDD_LDGR_F

3271: --
3272: -- END ----> DELETE ROUTINE FOR BEN_PRTT_ENRT_RSLT_F
3273: --
3274: --
3275: -- START ----> DELETE ROUTINE FOR BEN_BNFT_PRVDD_LDGR_F
3276: cursor c_ben_bnft_prvdd_ldgr_f(p_bnft_prvdd_ldgr_id number) is
3277: select bpl.bnft_prvdd_ldgr_id,
3278: bpl.object_version_number,
3279: bpl.acty_base_rt_id,

Line 3276: cursor c_ben_bnft_prvdd_ldgr_f(p_bnft_prvdd_ldgr_id number) is

3272: -- END ----> DELETE ROUTINE FOR BEN_PRTT_ENRT_RSLT_F
3273: --
3274: --
3275: -- START ----> DELETE ROUTINE FOR BEN_BNFT_PRVDD_LDGR_F
3276: cursor c_ben_bnft_prvdd_ldgr_f(p_bnft_prvdd_ldgr_id number) is
3277: select bpl.bnft_prvdd_ldgr_id,
3278: bpl.object_version_number,
3279: bpl.acty_base_rt_id,
3280: bpl.effective_end_date,

Line 3283: from ben_bnft_prvdd_ldgr_f bpl,

3279: bpl.acty_base_rt_id,
3280: bpl.effective_end_date,
3281: bpl.effective_start_date,
3282: bpl.per_in_ler_id
3283: from ben_bnft_prvdd_ldgr_f bpl,
3284: ben_per_in_ler pil
3285: where pil.per_in_ler_id = p_per_in_ler_id
3286: and pil.business_group_id = p_business_group_id
3287: and bpl.per_in_ler_id = pil.per_in_ler_id

Line 3299: l_bpl c_ben_bnft_prvdd_ldgr_f%rowtype;

3295: and exists (select null from ben_prtt_enrt_rslt_f pen
3296: where pen.prtt_enrt_rslt_id = bpl.prtt_enrt_rslt_id)
3297: order by 1;
3298: --
3299: l_bpl c_ben_bnft_prvdd_ldgr_f%rowtype;
3300: --
3301: -- Bug 6376239
3302: cursor c_bpl_from_pen is
3303: select bpl.bnft_prvdd_ldgr_id

Line 3304: from ben_bnft_prvdd_ldgr_f bpl, ben_prtt_rt_val prv

3300: --
3301: -- Bug 6376239
3302: cursor c_bpl_from_pen is
3303: select bpl.bnft_prvdd_ldgr_id
3304: from ben_bnft_prvdd_ldgr_f bpl, ben_prtt_rt_val prv
3305: where prv.prtt_enrt_rslt_id = p_bckdt_prtt_enrt_rslt_id
3306: and prv.acty_base_rt_id = bpl.acty_base_rt_id
3307: and bpl.per_in_ler_id = p_per_in_ler_id
3308: and prv.per_in_ler_id = bpl.per_in_ler_id

Line 3320: WHERE bkup_tbl_typ_cd = 'BEN_BNFT_PRVDD_LDGR_F'

3316: CURSOR c_bpl_from_backup
3317: IS
3318: SELECT bpl.*
3319: FROM ben_le_clsn_n_rstr bpl
3320: WHERE bkup_tbl_typ_cd = 'BEN_BNFT_PRVDD_LDGR_F'
3321: AND per_in_ler_id = p_per_in_ler_id
3322: AND effective_end_date = hr_api.g_eot;
3323: --
3324: l_bpl_from_backup c_bpl_from_backup%ROWTYPE;

Line 3332: from ben_bnft_prvdd_ldgr_f bpl,

3328: -- Bug#2592783 - per_in_ler_stat_cd is checked
3329: -- Bug#2646851 - cursor modified with order by clause and max function removed
3330: cursor c_bpl_max_esd_of_past_pil(v_bnft_prvdd_ldgr_id in number) is
3331: select bpl.effective_end_date, bpl.object_version_number
3332: from ben_bnft_prvdd_ldgr_f bpl,
3333: ben_per_in_ler pil
3334: where bpl.bnft_prvdd_ldgr_id = v_bnft_prvdd_ldgr_id
3335: and nvl(bpl.per_in_ler_id , -1) <> p_per_in_ler_id
3336: and bpl.business_group_id = p_business_group_id

Line 3340: -- END ---> DELETE ROUTINE FOR BEN_BNFT_PRVDD_LDGR_F

3336: and bpl.business_group_id = p_business_group_id
3337: and bpl.per_in_ler_id = pil.per_in_ler_id
3338: and pil.per_in_ler_stat_cd not in ('BCKDT','VOIDD')
3339: order by bpl.effective_end_date desc;
3340: -- END ---> DELETE ROUTINE FOR BEN_BNFT_PRVDD_LDGR_F
3341:
3342: -- START ----> DELETE ROUTINE FOR BEN_PIL_ELCTBL_CHC_POPL
3343: -- -- Source Table -- BEN_PER_IN_LER --
3344: cursor c_ben_pil_elctbl_chc_popl is

Line 6365: elsif p_routine = 'BEN_BNFT_PRVDD_LDGR_F' then

6361: close c_prtt_enrt_rslt_adj;
6362: --
6363: -- End bug 7206471
6364:
6365: elsif p_routine = 'BEN_BNFT_PRVDD_LDGR_F' then
6366: --
6367: -- Bug 5500864
6368: -- This part of code has been added to take care of reinstatements of BPLs that have been END-DATED
6369: -- Such BPL Records have been backed up in BEN_LE_CLSN_N_RSTR. See BEN_BPL_DEL.POST_DELETE

Line 6370: -- The part of the code below (which queries cursor c_ben_bnft_prvdd_ldgr_f) takes care of rest

6366: --
6367: -- Bug 5500864
6368: -- This part of code has been added to take care of reinstatements of BPLs that have been END-DATED
6369: -- Such BPL Records have been backed up in BEN_LE_CLSN_N_RSTR. See BEN_BPL_DEL.POST_DELETE
6370: -- The part of the code below (which queries cursor c_ben_bnft_prvdd_ldgr_f) takes care of rest
6371: -- of the scenarios and voiding of BPL associated with the life-event being backed out.
6372: --
6373: hr_utility.set_location('ACE p_per_in_ler_id = ' || p_per_in_ler_id, 9999);
6374: --

Line 6397: and cls.bkup_tbl_typ_cd = 'BEN_BNFT_PRVDD_LDGR_F'

6393: --
6394: delete from ben_le_clsn_n_rstr cls
6395: where cls.per_in_ler_id = l_bpl_from_backup.per_in_ler_id
6396: and cls.bkup_tbl_id = l_bpl_from_backup.bkup_tbl_id
6397: and cls.bkup_tbl_typ_cd = 'BEN_BNFT_PRVDD_LDGR_F'
6398: and effective_start_date = l_bpl_from_backup.effective_start_date
6399: and effective_end_date = hr_api.g_eot;
6400: --
6401: -- End Bug 6376239

Line 6419: open c_ben_bnft_prvdd_ldgr_f(prev_bnft_prvdd_ldgr_id);

6415: end if;
6416: --
6417: -- End Bug 6376239
6418: --
6419: open c_ben_bnft_prvdd_ldgr_f(prev_bnft_prvdd_ldgr_id);
6420: loop
6421: l_effective_date := null;
6422: fetch c_ben_bnft_prvdd_ldgr_f into l_bpl;
6423: exit when c_ben_bnft_prvdd_ldgr_f%notfound;

Line 6422: fetch c_ben_bnft_prvdd_ldgr_f into l_bpl;

6418: --
6419: open c_ben_bnft_prvdd_ldgr_f(prev_bnft_prvdd_ldgr_id);
6420: loop
6421: l_effective_date := null;
6422: fetch c_ben_bnft_prvdd_ldgr_f into l_bpl;
6423: exit when c_ben_bnft_prvdd_ldgr_f%notfound;
6424: l_pk_id := l_bpl.bnft_prvdd_ldgr_id;
6425: open c_bpl_max_esd_of_past_pil(l_pk_id);
6426: fetch c_bpl_max_esd_of_past_pil into l_effective_date,

Line 6423: exit when c_ben_bnft_prvdd_ldgr_f%notfound;

6419: open c_ben_bnft_prvdd_ldgr_f(prev_bnft_prvdd_ldgr_id);
6420: loop
6421: l_effective_date := null;
6422: fetch c_ben_bnft_prvdd_ldgr_f into l_bpl;
6423: exit when c_ben_bnft_prvdd_ldgr_f%notfound;
6424: l_pk_id := l_bpl.bnft_prvdd_ldgr_id;
6425: open c_bpl_max_esd_of_past_pil(l_pk_id);
6426: fetch c_bpl_max_esd_of_past_pil into l_effective_date,
6427: l_max_object_version_number;

Line 6477: close c_ben_bnft_prvdd_ldgr_f;

6473: end if;
6474: end if;
6475: end loop;
6476: --
6477: close c_ben_bnft_prvdd_ldgr_f;
6478: --
6479: elsif p_routine = 'BEN_PIL_ELCTBL_CHC_POPL' then
6480:
6481: -- pil popl's are updated to 'backed out'