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_PRTT_ENRT_RESULT_API dependencies on BEN_COBJ_CACHE

Line 491: ben_cobj_cache.get_pgm_dets for plnip

487: alws_dpnt_dsgn_flag is 'N' # 3175382
488: 115.210 13-Nov-03 ikasire Bug 3256056 We want remove the penid from the enb record
489: while zaping or voiding the pen
490: 115.211 14-Nov-03 mmudigon Bug 3222057. Step 155 Bypass call to
491: ben_cobj_cache.get_pgm_dets for plnip
492: 115.212 15-Nov-03 kmahendr Bug#3260564 - assign rt_end_dt at the time delete_enrollment
493: for 1 prior codes based on new enrollment.
494: 115.213 29-Dec-03 rpgupta Bug#3327224 - Make dpnt cvg end dt independent of prtt cvg end dt
495: 115.214 08-Jan-04 vvprabhu Bug 1620171 - Changes to date format in message 91902

Line 584: proc delete_enrollment modified for same .Also ben_cobj_cache.get_pl_dets/get_oipl_dets

580: 115.262 24-Aug-05 ikasire Indented delete_enrollment procedure to improve productivity
581: in bug resolutions.
582: 115.263 06-Oct-05 bmanyam Bug 4642299 : Added 'LODBEWM','ODBEWM' too for 1 Prior logic.
583: 115.264 07-oct-05 ssarkar Bug 4616225 : Call to pl/oipl cache is set to nvl(life_event_dt/effective_date).
584: proc delete_enrollment modified for same .Also ben_cobj_cache.get_pl_dets/get_oipl_dets
585: are called after ben_global_enrt.get_pil .
586: 115.265 17-Oct-05 vborkar BUG 4663971 : In delete_enrollment, called update_prtt_enrt_result
587: instead of delete_prtt_enrt_result for datetrack mode other than zap.
588: Also if eff date equals PEN start date then called update_prtt_enrt_result

Line 1592: l_pl_rec ben_cobj_cache.g_pl_inst_row;

1588: /* End of Changes for WWBUG: 1646442 : added declarations */
1589: --
1590: l_global_epe_rec ben_global_enrt.g_global_epe_rec_type;
1591: l_global_pen_rec ben_prtt_enrt_rslt_f%rowtype;
1592: l_pl_rec ben_cobj_cache.g_pl_inst_row;
1593: l_pgm_rec ben_cobj_cache.g_pgm_inst_row;
1594: l_oipl_rec ben_cobj_cache.g_oipl_inst_row;
1595: --
1596: cursor c_ptip_enrollment_info is

Line 1593: l_pgm_rec ben_cobj_cache.g_pgm_inst_row;

1589: --
1590: l_global_epe_rec ben_global_enrt.g_global_epe_rec_type;
1591: l_global_pen_rec ben_prtt_enrt_rslt_f%rowtype;
1592: l_pl_rec ben_cobj_cache.g_pl_inst_row;
1593: l_pgm_rec ben_cobj_cache.g_pgm_inst_row;
1594: l_oipl_rec ben_cobj_cache.g_oipl_inst_row;
1595: --
1596: cursor c_ptip_enrollment_info is
1597: select pen.prtt_enrt_rslt_id,

Line 1594: l_oipl_rec ben_cobj_cache.g_oipl_inst_row;

1590: l_global_epe_rec ben_global_enrt.g_global_epe_rec_type;
1591: l_global_pen_rec ben_prtt_enrt_rslt_f%rowtype;
1592: l_pl_rec ben_cobj_cache.g_pl_inst_row;
1593: l_pgm_rec ben_cobj_cache.g_pgm_inst_row;
1594: l_oipl_rec ben_cobj_cache.g_oipl_inst_row;
1595: --
1596: cursor c_ptip_enrollment_info is
1597: select pen.prtt_enrt_rslt_id,
1598: pen.pl_id,

Line 1789: ben_cobj_cache.get_pl_dets

1785: ben_global_enrt.get_epe -- choice
1786: (p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id
1787: ,p_global_epe_rec => l_global_epe_rec);
1788:
1789: ben_cobj_cache.get_pl_dets
1790: (p_business_group_id => p_business_group_id
1791: ,p_effective_date => p_effective_date
1792: ,p_pl_id => l_global_epe_rec.pl_id
1793: ,p_inst_row => l_pl_rec);

Line 1796: ben_cobj_cache.get_oipl_dets

1792: ,p_pl_id => l_global_epe_rec.pl_id
1793: ,p_inst_row => l_pl_rec);
1794:
1795: if l_global_epe_rec.oipl_id is not null then
1796: ben_cobj_cache.get_oipl_dets
1797: (p_business_group_id => p_business_group_id
1798: ,p_effective_date => p_effective_date
1799: ,p_oipl_id => l_global_epe_rec.oipl_id
1800: ,p_inst_row => l_oipl_rec);

Line 2251: ben_cobj_cache.get_pgm_dets

2247: l_process_dpnt := true;
2248: else
2249: l_process_dpnt := false;
2250: if l_global_epe_rec.pgm_id is not null then
2251: ben_cobj_cache.get_pgm_dets
2252: (p_business_group_id => p_business_group_id
2253: ,p_effective_date => p_effective_date
2254: ,p_pgm_id => l_global_epe_rec.pgm_id
2255: ,p_inst_row => l_pgm_rec);

Line 2323: ben_cobj_cache.get_pgm_dets

2319: -- different coverage, sooo..
2320: -- handle dependent recycling at ptip level if used to be
2321: -- enrolled in plan type but coverage ended due to eligibility.
2322: --
2323: ben_cobj_cache.get_pgm_dets
2324: (p_business_group_id => p_business_group_id
2325: ,p_effective_date => p_effective_date
2326: ,p_pgm_id => l_global_epe_rec.pgm_id
2327: ,p_inst_row => l_pgm_rec);

Line 3012: l_pl_rec ben_cobj_cache.g_pl_inst_row;

3008: ) is
3009: --
3010: -- Declare cursors and local variables
3011: --
3012: l_pl_rec ben_cobj_cache.g_pl_inst_row;
3013: l_oipl_rec ben_cobj_cache.g_oipl_inst_row;
3014: --
3015: l_global_pen_rec ben_prtt_enrt_rslt_f%rowtype;
3016:

Line 3013: l_oipl_rec ben_cobj_cache.g_oipl_inst_row;

3009: --
3010: -- Declare cursors and local variables
3011: --
3012: l_pl_rec ben_cobj_cache.g_pl_inst_row;
3013: l_oipl_rec ben_cobj_cache.g_oipl_inst_row;
3014: --
3015: l_global_pen_rec ben_prtt_enrt_rslt_f%rowtype;
3016:
3017:

Line 3372: ben_cobj_cache.get_pl_dets

3368: (p_prtt_enrt_rslt_id => p_prtt_enrt_rslt_id
3369: ,p_effective_date => p_effective_date
3370: ,p_global_pen_rec => l_global_pen_rec);
3371: --
3372: ben_cobj_cache.get_pl_dets
3373: (p_business_group_id => p_business_group_id
3374: ,p_effective_date => p_effective_date
3375: ,p_pl_id => l_global_pen_rec.pl_id
3376: ,p_inst_row => l_pl_rec);

Line 3378: ben_cobj_cache.get_oipl_dets

3374: ,p_effective_date => p_effective_date
3375: ,p_pl_id => l_global_pen_rec.pl_id
3376: ,p_inst_row => l_pl_rec);
3377: if l_global_pen_rec.oipl_id is not null then
3378: ben_cobj_cache.get_oipl_dets
3379: (p_business_group_id => p_business_group_id
3380: ,p_effective_date => p_effective_date
3381: ,p_oipl_id => l_global_pen_rec.oipl_id
3382: ,p_inst_row => l_oipl_rec);

Line 5500: l_pl_rec ben_cobj_cache.g_pl_inst_row;

5496: l_cvg_end_cd varchar2(30);
5497: l_cvg_end_rl number(15);
5498: l_step integer;
5499: --
5500: l_pl_rec ben_cobj_cache.g_pl_inst_row;
5501: l_pgm_rec ben_cobj_cache.g_pgm_inst_row;
5502: l_ptip_rec ben_cobj_cache.g_ptip_inst_row;
5503: --
5504: cursor c_epe is

Line 5501: l_pgm_rec ben_cobj_cache.g_pgm_inst_row;

5497: l_cvg_end_rl number(15);
5498: l_step integer;
5499: --
5500: l_pl_rec ben_cobj_cache.g_pl_inst_row;
5501: l_pgm_rec ben_cobj_cache.g_pgm_inst_row;
5502: l_ptip_rec ben_cobj_cache.g_ptip_inst_row;
5503: --
5504: cursor c_epe is
5505: select epe.elig_per_elctbl_chc_id

Line 5502: l_ptip_rec ben_cobj_cache.g_ptip_inst_row;

5498: l_step integer;
5499: --
5500: l_pl_rec ben_cobj_cache.g_pl_inst_row;
5501: l_pgm_rec ben_cobj_cache.g_pgm_inst_row;
5502: l_ptip_rec ben_cobj_cache.g_ptip_inst_row;
5503: --
5504: cursor c_epe is
5505: select epe.elig_per_elctbl_chc_id
5506: ,epe.pgm_id

Line 5597: ben_cobj_cache.get_pl_dets

5593: -- If program Id is specified, then use program Id to retreive dependent
5594: -- designation level. If not, use plan as dependent designation level.
5595: --
5596: if (l_epe.pl_id is not null ) then
5597: ben_cobj_cache.get_pl_dets
5598: (p_business_group_id => p_business_group_id
5599: ,p_effective_date => p_effective_date
5600: ,p_pl_id => l_epe.pl_id
5601: ,p_inst_row => l_pl_rec);

Line 5605: ben_cobj_cache.get_pgm_dets

5601: ,p_inst_row => l_pl_rec);
5602: end if;
5603:
5604: if ( (l_epe.pgm_id is not null)) then
5605: ben_cobj_cache.get_pgm_dets
5606: (p_business_group_id => p_business_group_id
5607: ,p_effective_date => p_effective_date
5608: ,p_pgm_id => l_epe.pgm_id
5609: ,p_inst_row => l_pgm_rec);

Line 5628: ben_cobj_cache.get_ptip_dets

5624: l_level := 'PL';
5625: end if;
5626:
5627: if (l_epe.ptip_id is not null and l_level = 'PTIP') then
5628: ben_cobj_cache.get_ptip_dets
5629: (p_business_group_id => p_business_group_id
5630: ,p_effective_date => p_effective_date
5631: ,p_ptip_id => l_epe.ptip_id
5632: ,p_inst_row => l_ptip_rec);

Line 7131: l_pl_rec ben_cobj_cache.g_pl_inst_row;

7127: l_intm_other_rslt varchar2(30) := 'N';
7128: l_new_enrollment varchar2(1) := 'N' ;
7129: l_object_version_number number ;
7130: --
7131: l_pl_rec ben_cobj_cache.g_pl_inst_row;
7132: l_oipl_rec ben_cobj_cache.g_oipl_inst_row;
7133: l_deenrol_dt date;
7134: l_prv_count number;
7135: l_env_rec ben_env_object.g_global_env_rec_type;

Line 7132: l_oipl_rec ben_cobj_cache.g_oipl_inst_row;

7128: l_new_enrollment varchar2(1) := 'N' ;
7129: l_object_version_number number ;
7130: --
7131: l_pl_rec ben_cobj_cache.g_pl_inst_row;
7132: l_oipl_rec ben_cobj_cache.g_oipl_inst_row;
7133: l_deenrol_dt date;
7134: l_prv_count number;
7135: l_env_rec ben_env_object.g_global_env_rec_type;
7136: l_benmngle_parm_rec benutils.g_batch_param_rec;

Line 7628: ben_cobj_cache.get_pl_dets

7624: -- bug 4616225 : cache built on date,de-enrollment date of a plan,may not have
7625: -- correct comp objects built.So,life event occured date to be considered first .
7626: -- And so both get_pl_dets,get_oipl_dets calls are moved down and are called after
7627: -- ben_global_enrt.get_pil call.
7628: ben_cobj_cache.get_pl_dets
7629: (p_business_group_id => p_business_group_id
7630: ,p_effective_date => nvl(l_global_pil_rec.lf_evt_ocrd_dt,p_effective_date)
7631: ,p_pl_id => l_pen.pl_id
7632: ,p_inst_row => l_pl_rec);

Line 7635: ben_cobj_cache.get_oipl_dets

7631: ,p_pl_id => l_pen.pl_id
7632: ,p_inst_row => l_pl_rec);
7633:
7634: if l_pen.oipl_id is not null then
7635: ben_cobj_cache.get_oipl_dets
7636: (p_business_group_id => p_business_group_id
7637: ,p_effective_date => nvl(l_global_pil_rec.lf_evt_ocrd_dt,p_effective_date) --
7638: ,p_oipl_id => l_pen.oipl_id
7639: ,p_inst_row => l_oipl_rec);