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 1405: delete_routine(p_routine => 'BEN_PRMRY_CARE_PRVDR_F',

1401: -- (404) Until we recognize that pcp's aren't valid if their per-in-ler isn't
1402: -- we need to still delete them. Need to change views? or add per in ler id.
1403: hr_utility.set_location('Effective Date'||p_effective_date,10);
1404:
1405: delete_routine(p_routine => 'BEN_PRMRY_CARE_PRVDR_F',
1406: p_per_in_ler_id => p_per_in_ler_id,
1407: p_business_group_id => p_business_group_id,
1408: p_bckdt_prtt_enrt_rslt_id => p_bckdt_prtt_enrt_rslt_id,
1409: p_copy_only => p_copy_only,

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

2821: --
2822: --
2823: -- END ----> DELETE ROUTINE FOR BEN_PL_BNF_F
2824: --
2825: -- START ----> DELETE ROUTINE FOR BEN_PRMRY_CARE_PRVDR_F
2826: --
2827: -- Source Table
2828: -- BEN_PER_IN_LER
2829: -- Drive Routes

Line 2833: cursor c_ben_prmry_care_prvdr_f is

2829: -- Drive Routes
2830: -- BEN_PRTT_ENRT_RSLT_F
2831: --
2832: --
2833: cursor c_ben_prmry_care_prvdr_f is
2834: select ppr.prmry_care_prvdr_id,
2835: ppr.effective_start_date,
2836: ppr.object_version_number
2837: from ben_prmry_care_prvdr_f ppr,

Line 2837: from ben_prmry_care_prvdr_f ppr,

2833: cursor c_ben_prmry_care_prvdr_f is
2834: select ppr.prmry_care_prvdr_id,
2835: ppr.effective_start_date,
2836: ppr.object_version_number
2837: from ben_prmry_care_prvdr_f ppr,
2838: ben_prtt_enrt_rslt_f pen,
2839: ben_per_in_ler pil
2840: where pil.per_in_ler_id = p_per_in_ler_id
2841: and pil.business_group_id = p_business_group_id

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

2861: or p_bckdt_prtt_enrt_rslt_id = ppr.prtt_enrt_rslt_id
2862: )
2863: order by 1;
2864: --
2865: -- END ----> DELETE ROUTINE FOR BEN_PRMRY_CARE_PRVDR_F
2866: --
2867: -- START ----> DELETE ROUTINE FOR BEN_PRTT_RT_VAL
2868: --
2869: -- Source Table

Line 5053: elsif p_routine = 'BEN_PRMRY_CARE_PRVDR_F' then

5049: l_prev_pk_id := -1;
5050: --
5051:
5052: close c_ben_pl_bnf_f;
5053: elsif p_routine = 'BEN_PRMRY_CARE_PRVDR_F' then
5054: --
5055: l_prev_pk_id := -1; -- like null
5056: --
5057: /* Why are we deleting these records. Bug 3709516

Line 5059: open c_ben_prmry_care_prvdr_f;

5055: l_prev_pk_id := -1; -- like null
5056: --
5057: /* Why are we deleting these records. Bug 3709516
5058: --
5059: open c_ben_prmry_care_prvdr_f;
5060: --
5061: loop
5062: --
5063: fetch c_ben_prmry_care_prvdr_f into l_pk_id,l_effective_date,

Line 5063: fetch c_ben_prmry_care_prvdr_f into l_pk_id,l_effective_date,

5059: open c_ben_prmry_care_prvdr_f;
5060: --
5061: loop
5062: --
5063: fetch c_ben_prmry_care_prvdr_f into l_pk_id,l_effective_date,
5064: l_object_version_number;
5065: exit when c_ben_prmry_care_prvdr_f%notfound;
5066: --
5067: -- Do not process the row as it is already processed(deleted).

Line 5065: exit when c_ben_prmry_care_prvdr_f%notfound;

5061: loop
5062: --
5063: fetch c_ben_prmry_care_prvdr_f into l_pk_id,l_effective_date,
5064: l_object_version_number;
5065: exit when c_ben_prmry_care_prvdr_f%notfound;
5066: --
5067: -- Do not process the row as it is already processed(deleted).
5068: --
5069: if l_prev_pk_id <> l_pk_id and nvl(p_copy_only,'N') <> 'Y' then

Line 5091: close c_ben_prmry_care_prvdr_f;

5087: end loop;
5088: --
5089: l_prev_pk_id := -1;
5090: --
5091: close c_ben_prmry_care_prvdr_f;
5092: */
5093:
5094: elsif p_routine = 'BEN_PRTT_REIMBMT_RQST' then
5095: open c_prc ;

Line 6633: if c_ben_prmry_care_prvdr_f%isopen then

6629: close c_ben_pl_bnf_f;
6630: --
6631: end if;
6632: --
6633: if c_ben_prmry_care_prvdr_f%isopen then
6634: --
6635: close c_ben_prmry_care_prvdr_f;
6636: --
6637: end if;

Line 6635: close c_ben_prmry_care_prvdr_f;

6631: end if;
6632: --
6633: if c_ben_prmry_care_prvdr_f%isopen then
6634: --
6635: close c_ben_prmry_care_prvdr_f;
6636: --
6637: end if;
6638: --
6639: if c_ben_prtt_rt_val%isopen then