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 1519: l_pl_rec ben_cobj_cache.g_pl_inst_row;

1515: /* End of Changes for WWBUG: 1646442 : added declarations */
1516: --
1517: l_global_epe_rec ben_global_enrt.g_global_epe_rec_type;
1518: l_global_pen_rec ben_prtt_enrt_rslt_f%rowtype;
1519: l_pl_rec ben_cobj_cache.g_pl_inst_row;
1520: l_pgm_rec ben_cobj_cache.g_pgm_inst_row;
1521: l_oipl_rec ben_cobj_cache.g_oipl_inst_row;
1522: --
1523: cursor c_ptip_enrollment_info is

Line 1520: l_pgm_rec ben_cobj_cache.g_pgm_inst_row;

1516: --
1517: l_global_epe_rec ben_global_enrt.g_global_epe_rec_type;
1518: l_global_pen_rec ben_prtt_enrt_rslt_f%rowtype;
1519: l_pl_rec ben_cobj_cache.g_pl_inst_row;
1520: l_pgm_rec ben_cobj_cache.g_pgm_inst_row;
1521: l_oipl_rec ben_cobj_cache.g_oipl_inst_row;
1522: --
1523: cursor c_ptip_enrollment_info is
1524: select pen.prtt_enrt_rslt_id,

Line 1521: l_oipl_rec ben_cobj_cache.g_oipl_inst_row;

1517: l_global_epe_rec ben_global_enrt.g_global_epe_rec_type;
1518: l_global_pen_rec ben_prtt_enrt_rslt_f%rowtype;
1519: l_pl_rec ben_cobj_cache.g_pl_inst_row;
1520: l_pgm_rec ben_cobj_cache.g_pgm_inst_row;
1521: l_oipl_rec ben_cobj_cache.g_oipl_inst_row;
1522: --
1523: cursor c_ptip_enrollment_info is
1524: select pen.prtt_enrt_rslt_id,
1525: pen.pl_id,

Line 1716: ben_cobj_cache.get_pl_dets

1712: ben_global_enrt.get_epe -- choice
1713: (p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id
1714: ,p_global_epe_rec => l_global_epe_rec);
1715:
1716: ben_cobj_cache.get_pl_dets
1717: (p_business_group_id => p_business_group_id
1718: ,p_effective_date => p_effective_date
1719: ,p_pl_id => l_global_epe_rec.pl_id
1720: ,p_inst_row => l_pl_rec);

Line 1723: ben_cobj_cache.get_oipl_dets

1719: ,p_pl_id => l_global_epe_rec.pl_id
1720: ,p_inst_row => l_pl_rec);
1721:
1722: if l_global_epe_rec.oipl_id is not null then
1723: ben_cobj_cache.get_oipl_dets
1724: (p_business_group_id => p_business_group_id
1725: ,p_effective_date => p_effective_date
1726: ,p_oipl_id => l_global_epe_rec.oipl_id
1727: ,p_inst_row => l_oipl_rec);

Line 2169: ben_cobj_cache.get_pgm_dets

2165: l_process_dpnt := true;
2166: else
2167: l_process_dpnt := false;
2168: if l_global_epe_rec.pgm_id is not null then
2169: ben_cobj_cache.get_pgm_dets
2170: (p_business_group_id => p_business_group_id
2171: ,p_effective_date => p_effective_date
2172: ,p_pgm_id => l_global_epe_rec.pgm_id
2173: ,p_inst_row => l_pgm_rec);

Line 2241: ben_cobj_cache.get_pgm_dets

2237: -- different coverage, sooo..
2238: -- handle dependent recycling at ptip level if used to be
2239: -- enrolled in plan type but coverage ended due to eligibility.
2240: --
2241: ben_cobj_cache.get_pgm_dets
2242: (p_business_group_id => p_business_group_id
2243: ,p_effective_date => p_effective_date
2244: ,p_pgm_id => l_global_epe_rec.pgm_id
2245: ,p_inst_row => l_pgm_rec);

Line 2902: l_pl_rec ben_cobj_cache.g_pl_inst_row;

2898: ) is
2899: --
2900: -- Declare cursors and local variables
2901: --
2902: l_pl_rec ben_cobj_cache.g_pl_inst_row;
2903: l_oipl_rec ben_cobj_cache.g_oipl_inst_row;
2904: --
2905: l_global_pen_rec ben_prtt_enrt_rslt_f%rowtype;
2906:

Line 2903: l_oipl_rec ben_cobj_cache.g_oipl_inst_row;

2899: --
2900: -- Declare cursors and local variables
2901: --
2902: l_pl_rec ben_cobj_cache.g_pl_inst_row;
2903: l_oipl_rec ben_cobj_cache.g_oipl_inst_row;
2904: --
2905: l_global_pen_rec ben_prtt_enrt_rslt_f%rowtype;
2906:
2907:

Line 3177: ben_cobj_cache.get_pl_dets

3173: (p_prtt_enrt_rslt_id => p_prtt_enrt_rslt_id
3174: ,p_effective_date => p_effective_date
3175: ,p_global_pen_rec => l_global_pen_rec);
3176: --
3177: ben_cobj_cache.get_pl_dets
3178: (p_business_group_id => p_business_group_id
3179: ,p_effective_date => p_effective_date
3180: ,p_pl_id => l_global_pen_rec.pl_id
3181: ,p_inst_row => l_pl_rec);

Line 3183: ben_cobj_cache.get_oipl_dets

3179: ,p_effective_date => p_effective_date
3180: ,p_pl_id => l_global_pen_rec.pl_id
3181: ,p_inst_row => l_pl_rec);
3182: if l_global_pen_rec.oipl_id is not null then
3183: ben_cobj_cache.get_oipl_dets
3184: (p_business_group_id => p_business_group_id
3185: ,p_effective_date => p_effective_date
3186: ,p_oipl_id => l_global_pen_rec.oipl_id
3187: ,p_inst_row => l_oipl_rec);

Line 5211: l_pl_rec ben_cobj_cache.g_pl_inst_row;

5207: l_cvg_end_cd varchar2(30);
5208: l_cvg_end_rl number(15);
5209: l_step integer;
5210: --
5211: l_pl_rec ben_cobj_cache.g_pl_inst_row;
5212: l_pgm_rec ben_cobj_cache.g_pgm_inst_row;
5213: l_ptip_rec ben_cobj_cache.g_ptip_inst_row;
5214: --
5215: cursor c_epe is

Line 5212: l_pgm_rec ben_cobj_cache.g_pgm_inst_row;

5208: l_cvg_end_rl number(15);
5209: l_step integer;
5210: --
5211: l_pl_rec ben_cobj_cache.g_pl_inst_row;
5212: l_pgm_rec ben_cobj_cache.g_pgm_inst_row;
5213: l_ptip_rec ben_cobj_cache.g_ptip_inst_row;
5214: --
5215: cursor c_epe is
5216: select epe.elig_per_elctbl_chc_id

Line 5213: l_ptip_rec ben_cobj_cache.g_ptip_inst_row;

5209: l_step integer;
5210: --
5211: l_pl_rec ben_cobj_cache.g_pl_inst_row;
5212: l_pgm_rec ben_cobj_cache.g_pgm_inst_row;
5213: l_ptip_rec ben_cobj_cache.g_ptip_inst_row;
5214: --
5215: cursor c_epe is
5216: select epe.elig_per_elctbl_chc_id
5217: ,epe.pgm_id

Line 5308: ben_cobj_cache.get_pl_dets

5304: -- If program Id is specified, then use program Id to retreive dependent
5305: -- designation level. If not, use plan as dependent designation level.
5306: --
5307: if (l_epe.pl_id is not null ) then
5308: ben_cobj_cache.get_pl_dets
5309: (p_business_group_id => p_business_group_id
5310: ,p_effective_date => p_effective_date
5311: ,p_pl_id => l_epe.pl_id
5312: ,p_inst_row => l_pl_rec);

Line 5316: ben_cobj_cache.get_pgm_dets

5312: ,p_inst_row => l_pl_rec);
5313: end if;
5314:
5315: if ( (l_epe.pgm_id is not null)) then
5316: ben_cobj_cache.get_pgm_dets
5317: (p_business_group_id => p_business_group_id
5318: ,p_effective_date => p_effective_date
5319: ,p_pgm_id => l_epe.pgm_id
5320: ,p_inst_row => l_pgm_rec);

Line 5339: ben_cobj_cache.get_ptip_dets

5335: l_level := 'PL';
5336: end if;
5337:
5338: if (l_epe.ptip_id is not null and l_level = 'PTIP') then
5339: ben_cobj_cache.get_ptip_dets
5340: (p_business_group_id => p_business_group_id
5341: ,p_effective_date => p_effective_date
5342: ,p_ptip_id => l_epe.ptip_id
5343: ,p_inst_row => l_ptip_rec);

Line 6752: l_pl_rec ben_cobj_cache.g_pl_inst_row;

6748: l_intm_other_rslt varchar2(30) := 'N';
6749: l_new_enrollment varchar2(1) := 'N' ;
6750: l_object_version_number number ;
6751: --
6752: l_pl_rec ben_cobj_cache.g_pl_inst_row;
6753: l_oipl_rec ben_cobj_cache.g_oipl_inst_row;
6754: l_deenrol_dt date;
6755: l_prv_count number;
6756: l_env_rec ben_env_object.g_global_env_rec_type;

Line 6753: l_oipl_rec ben_cobj_cache.g_oipl_inst_row;

6749: l_new_enrollment varchar2(1) := 'N' ;
6750: l_object_version_number number ;
6751: --
6752: l_pl_rec ben_cobj_cache.g_pl_inst_row;
6753: l_oipl_rec ben_cobj_cache.g_oipl_inst_row;
6754: l_deenrol_dt date;
6755: l_prv_count number;
6756: l_env_rec ben_env_object.g_global_env_rec_type;
6757: l_benmngle_parm_rec benutils.g_batch_param_rec;

Line 6985: ben_cobj_cache.get_pl_dets

6981: -- bug 4616225 : cache built on date,de-enrollment date of a plan,may not have
6982: -- correct comp objects built.So,life event occured date to be considered first .
6983: -- And so both get_pl_dets,get_oipl_dets calls are moved down and are called after
6984: -- ben_global_enrt.get_pil call.
6985: ben_cobj_cache.get_pl_dets
6986: (p_business_group_id => p_business_group_id
6987: ,p_effective_date => nvl(l_global_pil_rec.lf_evt_ocrd_dt,p_effective_date)
6988: ,p_pl_id => l_pen.pl_id
6989: ,p_inst_row => l_pl_rec);

Line 6992: ben_cobj_cache.get_oipl_dets

6988: ,p_pl_id => l_pen.pl_id
6989: ,p_inst_row => l_pl_rec);
6990:
6991: if l_pen.oipl_id is not null then
6992: ben_cobj_cache.get_oipl_dets
6993: (p_business_group_id => p_business_group_id
6994: ,p_effective_date => nvl(l_global_pil_rec.lf_evt_ocrd_dt,p_effective_date) --
6995: ,p_oipl_id => l_pen.oipl_id
6996: ,p_inst_row => l_oipl_rec);