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_PRMRY_CARE_PRVDR_F

Line 53: BEN_PRMRY_CARE_PRVDR_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
57: BEN_PL_BNF_F

Line 197: c_ben_prmry_care_prvdr_f

193: c_epo_max_esd_of_past_pil,
194: c_ben_elig_per_f,
195: c_ben_prtt_prem_f,
196: c_ben_pl_bnf_f,
197: c_ben_prmry_care_prvdr_f
198: 31-AUG-00 jcarpent 115.50 OraBug# 4988. Added logic to
199: cdaniels skip the call to the delete
200: routine associated with most
201: of the p_routines when

Line 228: 21-MAR-2001 kmahendr 115.57 - Bug 1690358 - for ben_prmry_care_prvdr_f delete

224: rate start date < life event occured date
225:
226: 15-FEB-2001 pbodla 115.56 - Fix in 115.55 is put back in.
227: This is next version of 115.54
228: 21-MAR-2001 kmahendr 115.57 - Bug 1690358 - for ben_prmry_care_prvdr_f delete
229: routine, effective_start_date of the row is sent
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

Line 333: 29 Jun 2004 ikasire 115.101 Bug3709516 we are zaping ben_prmry_care_prvdr_f

329: changes are commented.
330: 21 Jun 2004 kmahendr 115.100 Bug#3702033 - when backed out result is
331: corrected with previous per in ler, the row in
332: ben_le_cl_n_rstr updated
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

Line 1753: delete_routine(p_routine => 'BEN_PRMRY_CARE_PRVDR_F',

1749: -- (404) Until we recognize that pcp's aren't valid if their per-in-ler isn't
1750: -- we need to still delete them. Need to change views? or add per in ler id.
1751: hr_utility.set_location('Effective Date'||p_effective_date,10);
1752:
1753: delete_routine(p_routine => 'BEN_PRMRY_CARE_PRVDR_F',
1754: p_per_in_ler_id => p_per_in_ler_id,
1755: p_business_group_id => p_business_group_id,
1756: p_bckdt_prtt_enrt_rslt_id => p_bckdt_prtt_enrt_rslt_id,
1757: p_copy_only => p_copy_only,

Line 3231: -- START ----> DELETE ROUTINE FOR BEN_PRMRY_CARE_PRVDR_F

3227: --
3228: --
3229: -- END ----> DELETE ROUTINE FOR BEN_PL_BNF_F
3230: --
3231: -- START ----> DELETE ROUTINE FOR BEN_PRMRY_CARE_PRVDR_F
3232: --
3233: -- Source Table
3234: -- BEN_PER_IN_LER
3235: -- Drive Routes

Line 3239: cursor c_ben_prmry_care_prvdr_f is

3235: -- Drive Routes
3236: -- BEN_PRTT_ENRT_RSLT_F
3237: --
3238: --
3239: cursor c_ben_prmry_care_prvdr_f is
3240: select ppr.prmry_care_prvdr_id,
3241: ppr.effective_start_date,
3242: ppr.object_version_number
3243: from ben_prmry_care_prvdr_f ppr,

Line 3243: from ben_prmry_care_prvdr_f ppr,

3239: cursor c_ben_prmry_care_prvdr_f is
3240: select ppr.prmry_care_prvdr_id,
3241: ppr.effective_start_date,
3242: ppr.object_version_number
3243: from ben_prmry_care_prvdr_f ppr,
3244: ben_prtt_enrt_rslt_f pen,
3245: ben_per_in_ler pil
3246: where pil.per_in_ler_id = p_per_in_ler_id
3247: and pil.business_group_id = p_business_group_id

Line 3271: -- END ----> DELETE ROUTINE FOR BEN_PRMRY_CARE_PRVDR_F

3267: or p_bckdt_prtt_enrt_rslt_id = ppr.prtt_enrt_rslt_id
3268: )
3269: order by 1;
3270: --
3271: -- END ----> DELETE ROUTINE FOR BEN_PRMRY_CARE_PRVDR_F
3272: --
3273: -- START ----> DELETE ROUTINE FOR BEN_PRTT_RT_VAL
3274: --
3275: -- Source Table

Line 5535: elsif p_routine = 'BEN_PRMRY_CARE_PRVDR_F' then

5531: l_prev_pk_id := -1;
5532: --
5533:
5534: close c_ben_pl_bnf_f;
5535: elsif p_routine = 'BEN_PRMRY_CARE_PRVDR_F' then
5536: --
5537: l_prev_pk_id := -1; -- like null
5538: --
5539: /* Why are we deleting these records. Bug 3709516

Line 5541: open c_ben_prmry_care_prvdr_f;

5537: l_prev_pk_id := -1; -- like null
5538: --
5539: /* Why are we deleting these records. Bug 3709516
5540: --
5541: open c_ben_prmry_care_prvdr_f;
5542: --
5543: loop
5544: --
5545: fetch c_ben_prmry_care_prvdr_f into l_pk_id,l_effective_date,

Line 5545: fetch c_ben_prmry_care_prvdr_f into l_pk_id,l_effective_date,

5541: open c_ben_prmry_care_prvdr_f;
5542: --
5543: loop
5544: --
5545: fetch c_ben_prmry_care_prvdr_f into l_pk_id,l_effective_date,
5546: l_object_version_number;
5547: exit when c_ben_prmry_care_prvdr_f%notfound;
5548: --
5549: -- Do not process the row as it is already processed(deleted).

Line 5547: exit when c_ben_prmry_care_prvdr_f%notfound;

5543: loop
5544: --
5545: fetch c_ben_prmry_care_prvdr_f into l_pk_id,l_effective_date,
5546: l_object_version_number;
5547: exit when c_ben_prmry_care_prvdr_f%notfound;
5548: --
5549: -- Do not process the row as it is already processed(deleted).
5550: --
5551: if l_prev_pk_id <> l_pk_id and nvl(p_copy_only,'N') <> 'Y' then

Line 5573: close c_ben_prmry_care_prvdr_f;

5569: end loop;
5570: --
5571: l_prev_pk_id := -1;
5572: --
5573: close c_ben_prmry_care_prvdr_f;
5574: */
5575:
5576: elsif p_routine = 'BEN_PRTT_REIMBMT_RQST' then
5577: open c_prc ;

Line 7285: if c_ben_prmry_care_prvdr_f%isopen then

7281: close c_ben_pl_bnf_f;
7282: --
7283: end if;
7284: --
7285: if c_ben_prmry_care_prvdr_f%isopen then
7286: --
7287: close c_ben_prmry_care_prvdr_f;
7288: --
7289: end if;

Line 7287: close c_ben_prmry_care_prvdr_f;

7283: end if;
7284: --
7285: if c_ben_prmry_care_prvdr_f%isopen then
7286: --
7287: close c_ben_prmry_care_prvdr_f;
7288: --
7289: end if;
7290: --
7291: if c_ben_prtt_rt_val%isopen then