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

Line 82: l_pgm_rec ben_cobj_cache.g_pgm_inst_row;

78: --
79: l_terminated per_assignment_status_types.per_system_status%type;
80: l_assignment_id per_all_assignments_f.assignment_id%type;
81: l_found_profile varchar2(1) := 'N';
82: l_pgm_rec ben_cobj_cache.g_pgm_inst_row;
83: l_pl_rec ben_cobj_cache.g_pl_inst_row;
84: l_pl2_rec ben_pl_f%rowtype;
85: l_pl3_rec ben_pl_f%rowtype;
86: l_ptip2_rec ben_ptip_f%rowtype;

Line 83: l_pl_rec ben_cobj_cache.g_pl_inst_row;

79: l_terminated per_assignment_status_types.per_system_status%type;
80: l_assignment_id per_all_assignments_f.assignment_id%type;
81: l_found_profile varchar2(1) := 'N';
82: l_pgm_rec ben_cobj_cache.g_pgm_inst_row;
83: l_pl_rec ben_cobj_cache.g_pl_inst_row;
84: l_pl2_rec ben_pl_f%rowtype;
85: l_pl3_rec ben_pl_f%rowtype;
86: l_ptip2_rec ben_ptip_f%rowtype;
87: l_oipl_rec ben_cobj_cache.g_oipl_inst_row;

Line 87: l_oipl_rec ben_cobj_cache.g_oipl_inst_row;

83: l_pl_rec ben_cobj_cache.g_pl_inst_row;
84: l_pl2_rec ben_pl_f%rowtype;
85: l_pl3_rec ben_pl_f%rowtype;
86: l_ptip2_rec ben_ptip_f%rowtype;
87: l_oipl_rec ben_cobj_cache.g_oipl_inst_row;
88: l_plip_rec ben_cobj_cache.g_plip_inst_row;
89: l_ptip_rec ben_cobj_cache.g_ptip_inst_row;
90: l_elig_to_prte_rsn_row ben_cobj_cache.g_etpr_inst_row;
91: --

Line 88: l_plip_rec ben_cobj_cache.g_plip_inst_row;

84: l_pl2_rec ben_pl_f%rowtype;
85: l_pl3_rec ben_pl_f%rowtype;
86: l_ptip2_rec ben_ptip_f%rowtype;
87: l_oipl_rec ben_cobj_cache.g_oipl_inst_row;
88: l_plip_rec ben_cobj_cache.g_plip_inst_row;
89: l_ptip_rec ben_cobj_cache.g_ptip_inst_row;
90: l_elig_to_prte_rsn_row ben_cobj_cache.g_etpr_inst_row;
91: --
92: -- Task 130 : Variables used for extracting vrfy_fmly_mmbr_cd

Line 89: l_ptip_rec ben_cobj_cache.g_ptip_inst_row;

85: l_pl3_rec ben_pl_f%rowtype;
86: l_ptip2_rec ben_ptip_f%rowtype;
87: l_oipl_rec ben_cobj_cache.g_oipl_inst_row;
88: l_plip_rec ben_cobj_cache.g_plip_inst_row;
89: l_ptip_rec ben_cobj_cache.g_ptip_inst_row;
90: l_elig_to_prte_rsn_row ben_cobj_cache.g_etpr_inst_row;
91: --
92: -- Task 130 : Variables used for extracting vrfy_fmly_mmbr_cd
93: -- Need to look at the heirarchy.

Line 90: l_elig_to_prte_rsn_row ben_cobj_cache.g_etpr_inst_row;

86: l_ptip2_rec ben_ptip_f%rowtype;
87: l_oipl_rec ben_cobj_cache.g_oipl_inst_row;
88: l_plip_rec ben_cobj_cache.g_plip_inst_row;
89: l_ptip_rec ben_cobj_cache.g_ptip_inst_row;
90: l_elig_to_prte_rsn_row ben_cobj_cache.g_etpr_inst_row;
91: --
92: -- Task 130 : Variables used for extracting vrfy_fmly_mmbr_cd
93: -- Need to look at the heirarchy.
94: --

Line 95: l_par_pgm_rec ben_cobj_cache.g_pgm_inst_row;

91: --
92: -- Task 130 : Variables used for extracting vrfy_fmly_mmbr_cd
93: -- Need to look at the heirarchy.
94: --
95: l_par_pgm_rec ben_cobj_cache.g_pgm_inst_row;
96: l_par_ptip_rec ben_cobj_cache.g_ptip_inst_row;
97: l_par_plip_rec ben_cobj_cache.g_plip_inst_row;
98: l_par_pl_rec ben_cobj_cache.g_pl_inst_row;
99: l_par_pgm_elig_rec ben_cobj_cache.g_etpr_inst_row;

Line 96: l_par_ptip_rec ben_cobj_cache.g_ptip_inst_row;

92: -- Task 130 : Variables used for extracting vrfy_fmly_mmbr_cd
93: -- Need to look at the heirarchy.
94: --
95: l_par_pgm_rec ben_cobj_cache.g_pgm_inst_row;
96: l_par_ptip_rec ben_cobj_cache.g_ptip_inst_row;
97: l_par_plip_rec ben_cobj_cache.g_plip_inst_row;
98: l_par_pl_rec ben_cobj_cache.g_pl_inst_row;
99: l_par_pgm_elig_rec ben_cobj_cache.g_etpr_inst_row;
100: l_par_ptip_elig_rec ben_cobj_cache.g_etpr_inst_row;

Line 97: l_par_plip_rec ben_cobj_cache.g_plip_inst_row;

93: -- Need to look at the heirarchy.
94: --
95: l_par_pgm_rec ben_cobj_cache.g_pgm_inst_row;
96: l_par_ptip_rec ben_cobj_cache.g_ptip_inst_row;
97: l_par_plip_rec ben_cobj_cache.g_plip_inst_row;
98: l_par_pl_rec ben_cobj_cache.g_pl_inst_row;
99: l_par_pgm_elig_rec ben_cobj_cache.g_etpr_inst_row;
100: l_par_ptip_elig_rec ben_cobj_cache.g_etpr_inst_row;
101: l_par_plip_elig_rec ben_cobj_cache.g_etpr_inst_row;

Line 98: l_par_pl_rec ben_cobj_cache.g_pl_inst_row;

94: --
95: l_par_pgm_rec ben_cobj_cache.g_pgm_inst_row;
96: l_par_ptip_rec ben_cobj_cache.g_ptip_inst_row;
97: l_par_plip_rec ben_cobj_cache.g_plip_inst_row;
98: l_par_pl_rec ben_cobj_cache.g_pl_inst_row;
99: l_par_pgm_elig_rec ben_cobj_cache.g_etpr_inst_row;
100: l_par_ptip_elig_rec ben_cobj_cache.g_etpr_inst_row;
101: l_par_plip_elig_rec ben_cobj_cache.g_etpr_inst_row;
102: l_par_pl_elig_rec ben_cobj_cache.g_etpr_inst_row;

Line 99: l_par_pgm_elig_rec ben_cobj_cache.g_etpr_inst_row;

95: l_par_pgm_rec ben_cobj_cache.g_pgm_inst_row;
96: l_par_ptip_rec ben_cobj_cache.g_ptip_inst_row;
97: l_par_plip_rec ben_cobj_cache.g_plip_inst_row;
98: l_par_pl_rec ben_cobj_cache.g_pl_inst_row;
99: l_par_pgm_elig_rec ben_cobj_cache.g_etpr_inst_row;
100: l_par_ptip_elig_rec ben_cobj_cache.g_etpr_inst_row;
101: l_par_plip_elig_rec ben_cobj_cache.g_etpr_inst_row;
102: l_par_pl_elig_rec ben_cobj_cache.g_etpr_inst_row;
103: --

Line 100: l_par_ptip_elig_rec ben_cobj_cache.g_etpr_inst_row;

96: l_par_ptip_rec ben_cobj_cache.g_ptip_inst_row;
97: l_par_plip_rec ben_cobj_cache.g_plip_inst_row;
98: l_par_pl_rec ben_cobj_cache.g_pl_inst_row;
99: l_par_pgm_elig_rec ben_cobj_cache.g_etpr_inst_row;
100: l_par_ptip_elig_rec ben_cobj_cache.g_etpr_inst_row;
101: l_par_plip_elig_rec ben_cobj_cache.g_etpr_inst_row;
102: l_par_pl_elig_rec ben_cobj_cache.g_etpr_inst_row;
103: --
104: l_inst_set ben_elig_rl_cache.g_elig_rl_inst_tbl;

Line 101: l_par_plip_elig_rec ben_cobj_cache.g_etpr_inst_row;

97: l_par_plip_rec ben_cobj_cache.g_plip_inst_row;
98: l_par_pl_rec ben_cobj_cache.g_pl_inst_row;
99: l_par_pgm_elig_rec ben_cobj_cache.g_etpr_inst_row;
100: l_par_ptip_elig_rec ben_cobj_cache.g_etpr_inst_row;
101: l_par_plip_elig_rec ben_cobj_cache.g_etpr_inst_row;
102: l_par_pl_elig_rec ben_cobj_cache.g_etpr_inst_row;
103: --
104: l_inst_set ben_elig_rl_cache.g_elig_rl_inst_tbl;
105: l_elig_rl_cnt number := 0;

Line 102: l_par_pl_elig_rec ben_cobj_cache.g_etpr_inst_row;

98: l_par_pl_rec ben_cobj_cache.g_pl_inst_row;
99: l_par_pgm_elig_rec ben_cobj_cache.g_etpr_inst_row;
100: l_par_ptip_elig_rec ben_cobj_cache.g_etpr_inst_row;
101: l_par_plip_elig_rec ben_cobj_cache.g_etpr_inst_row;
102: l_par_pl_elig_rec ben_cobj_cache.g_etpr_inst_row;
103: --
104: l_inst_set ben_elig_rl_cache.g_elig_rl_inst_tbl;
105: l_elig_rl_cnt number := 0;
106: l_ctr_count number := 0;

Line 276: l_pgm_rec := ben_cobj_cache.g_pgm_currow;

272: if g_debug then
273: hr_utility.set_location('PGM_ID '||p_pgm_id,12);
274: end if;
275: --
276: l_pgm_rec := ben_cobj_cache.g_pgm_currow;
277: --
278: elsif p_pl_id is not null then
279: --
280: if g_debug then

Line 284: l_pl_rec := ben_cobj_cache.g_pl_currow;

280: if g_debug then
281: hr_utility.set_location('PL_ID '||p_pl_id,14);
282: end if;
283: --
284: l_pl_rec := ben_cobj_cache.g_pl_currow;
285: --
286: elsif p_oipl_id is not null then
287: --
288: if g_debug then

Line 292: l_oipl_rec := ben_cobj_cache.g_oipl_currow;

288: if g_debug then
289: hr_utility.set_location('OIPL_ID '||p_oipl_id,16);
290: end if;
291: --
292: l_oipl_rec := ben_cobj_cache.g_oipl_currow;
293: --
294: elsif p_plip_id is not null then
295: --
296: if g_debug then

Line 300: l_plip_rec := ben_cobj_cache.g_plip_currow;

296: if g_debug then
297: hr_utility.set_location('PLIP_ID '||p_plip_id,18);
298: end if;
299: --
300: l_plip_rec := ben_cobj_cache.g_plip_currow;
301: --
302: elsif p_ptip_id is not null then
303: --
304: if g_debug then

Line 308: l_ptip_rec := ben_cobj_cache.g_ptip_currow;

304: if g_debug then
305: hr_utility.set_location('PTIP_ID '||p_ptip_id,20);
306: end if;
307: --
308: l_ptip_rec := ben_cobj_cache.g_ptip_currow;
309: --
310: end if;
311: --
312: if g_debug then

Line 407: l_elig_to_prte_rsn_row := ben_cobj_cache.g_pgmetpr_currow;

403: if p_pgm_id is not null then
404: --
405: l_elig_apls_flag := l_pgm_rec.elig_apls_flag;
406: --
407: l_elig_to_prte_rsn_row := ben_cobj_cache.g_pgmetpr_currow;
408: --
409: l_elig_inelig_cd := l_elig_to_prte_rsn_row.elig_inelig_cd;
410: --
411: --if the participantion override flag is on then participation override thru date

Line 451: l_elig_to_prte_rsn_row := ben_cobj_cache.g_pletpr_currow;

447: elsif p_pl_id is not null then
448: --
449: l_elig_apls_flag := l_pl_rec.elig_apls_flag;
450: --
451: l_elig_to_prte_rsn_row := ben_cobj_cache.g_pletpr_currow;
452: --
453: l_elig_inelig_cd := l_elig_to_prte_rsn_row.elig_inelig_cd;
454: --
455: --if the participantion override flag is on then participation override thru date

Line 496: l_elig_to_prte_rsn_row := ben_cobj_cache.g_plipetpr_currow;

492: elsif p_plip_id is not null then
493: --
494: l_elig_apls_flag := 'Y';
495: --
496: l_elig_to_prte_rsn_row := ben_cobj_cache.g_plipetpr_currow;
497: --
498: l_elig_inelig_cd := l_elig_to_prte_rsn_row.elig_inelig_cd;
499: --
500: --if the participantion override flag is on then participation override thru date

Line 535: l_elig_to_prte_rsn_row := ben_cobj_cache.g_ptipetpr_currow;

531: elsif p_ptip_id is not null then
532: --
533: l_elig_apls_flag := 'Y';
534: --
535: l_elig_to_prte_rsn_row := ben_cobj_cache.g_ptipetpr_currow;
536: --
537: l_elig_inelig_cd := l_elig_to_prte_rsn_row.elig_inelig_cd;
538: --
539: --if the participantion override flag is on then participation override thru date

Line 574: l_elig_to_prte_rsn_row := ben_cobj_cache.g_oipletpr_currow;

570: elsif p_oipl_id is not null then
571: --
572: l_elig_apls_flag := l_oipl_rec.elig_apls_flag;
573: --
574: l_elig_to_prte_rsn_row := ben_cobj_cache.g_oipletpr_currow;
575: --
576: l_elig_inelig_cd := l_elig_to_prte_rsn_row.elig_inelig_cd;
577: --
578: --if the participantion override flag is on then participation override thru date

Line 679: l_par_pgm_elig_rec := ben_cobj_cache.g_pgmetpr_currow;

675: --
676: if p_comp_obj_tree_row.par_pgm_id is not null
677: then
678: --
679: l_par_pgm_elig_rec := ben_cobj_cache.g_pgmetpr_currow;
680: --
681: if l_par_pgm_elig_rec.vrfy_fmly_mmbr_cd is not null then
682: l_vrfy_fmly_mmbr_cd := l_par_pgm_elig_rec.vrfy_fmly_mmbr_cd;
683: l_vrfy_fmly_mmbr_rl := l_par_pgm_elig_rec.vrfy_fmly_mmbr_rl;

Line 685: l_par_pgm_rec := ben_cobj_cache.g_pgm_currow;

681: if l_par_pgm_elig_rec.vrfy_fmly_mmbr_cd is not null then
682: l_vrfy_fmly_mmbr_cd := l_par_pgm_elig_rec.vrfy_fmly_mmbr_cd;
683: l_vrfy_fmly_mmbr_rl := l_par_pgm_elig_rec.vrfy_fmly_mmbr_rl;
684: else
685: l_par_pgm_rec := ben_cobj_cache.g_pgm_currow;
686: l_vrfy_fmly_mmbr_cd := l_par_pgm_rec.vrfy_fmly_mmbr_cd;
687: l_vrfy_fmly_mmbr_rl := l_par_pgm_rec.vrfy_fmly_mmbr_rl;
688: end if;
689: --

Line 696: l_par_ptip_elig_rec := ben_cobj_cache.g_ptipetpr_currow;

692: if l_vrfy_fmly_mmbr_cd is null and
693: p_comp_obj_tree_row.par_ptip_id is not null
694: then
695: --
696: l_par_ptip_elig_rec := ben_cobj_cache.g_ptipetpr_currow;
697: --
698: if l_par_ptip_elig_rec.vrfy_fmly_mmbr_cd is not null then
699: l_vrfy_fmly_mmbr_cd := l_par_ptip_elig_rec.vrfy_fmly_mmbr_cd;
700: l_vrfy_fmly_mmbr_rl := l_par_ptip_elig_rec.vrfy_fmly_mmbr_rl;

Line 702: l_par_ptip_rec := ben_cobj_cache.g_ptip_currow;

698: if l_par_ptip_elig_rec.vrfy_fmly_mmbr_cd is not null then
699: l_vrfy_fmly_mmbr_cd := l_par_ptip_elig_rec.vrfy_fmly_mmbr_cd;
700: l_vrfy_fmly_mmbr_rl := l_par_ptip_elig_rec.vrfy_fmly_mmbr_rl;
701: else
702: l_par_ptip_rec := ben_cobj_cache.g_ptip_currow;
703: l_vrfy_fmly_mmbr_cd := l_par_ptip_rec.vrfy_fmly_mmbr_cd;
704: l_vrfy_fmly_mmbr_rl := l_par_ptip_rec.vrfy_fmly_mmbr_rl;
705: end if;
706: --

Line 716: l_par_plip_elig_rec := ben_cobj_cache.g_plipetpr_currow;

712: if l_vrfy_fmly_mmbr_cd is null and
713: p_comp_obj_tree_row.par_plip_id is not null
714: then
715: --
716: l_par_plip_elig_rec := ben_cobj_cache.g_plipetpr_currow;
717: --
718: if l_par_plip_elig_rec.vrfy_fmly_mmbr_cd is not null then
719: l_vrfy_fmly_mmbr_cd := l_par_plip_elig_rec.vrfy_fmly_mmbr_cd;
720: l_vrfy_fmly_mmbr_rl := l_par_plip_elig_rec.vrfy_fmly_mmbr_rl;

Line 723: l_par_plip_rec := ben_cobj_cache.g_plip_currow;

719: l_vrfy_fmly_mmbr_cd := l_par_plip_elig_rec.vrfy_fmly_mmbr_cd;
720: l_vrfy_fmly_mmbr_rl := l_par_plip_elig_rec.vrfy_fmly_mmbr_rl;
721: else
722: --
723: l_par_plip_rec := ben_cobj_cache.g_plip_currow;
724: --
725: l_vrfy_fmly_mmbr_cd := l_par_plip_rec.vrfy_fmly_mmbr_cd;
726: l_vrfy_fmly_mmbr_rl := l_par_plip_rec.vrfy_fmly_mmbr_rl;
727: end if;

Line 736: -- BUG 3168805 l_par_pl_elig_rec := ben_cobj_cache.g_pgmetpr_currow;

732: if l_vrfy_fmly_mmbr_cd is null and
733: p_comp_obj_tree_row.par_pl_id is not null
734: then
735: --
736: -- BUG 3168805 l_par_pl_elig_rec := ben_cobj_cache.g_pgmetpr_currow;
737: -- looks like typo, we should be looking at plan rec not pgm rec
738: l_par_pl_elig_rec := ben_cobj_cache.g_pletpr_currow;
739: --
740: if l_par_pl_elig_rec.vrfy_fmly_mmbr_cd is not null then

Line 738: l_par_pl_elig_rec := ben_cobj_cache.g_pletpr_currow;

734: then
735: --
736: -- BUG 3168805 l_par_pl_elig_rec := ben_cobj_cache.g_pgmetpr_currow;
737: -- looks like typo, we should be looking at plan rec not pgm rec
738: l_par_pl_elig_rec := ben_cobj_cache.g_pletpr_currow;
739: --
740: if l_par_pl_elig_rec.vrfy_fmly_mmbr_cd is not null then
741: l_vrfy_fmly_mmbr_cd := l_par_pl_elig_rec.vrfy_fmly_mmbr_cd;
742: l_vrfy_fmly_mmbr_rl := l_par_pl_elig_rec.vrfy_fmly_mmbr_rl;

Line 745: l_par_pl_rec := ben_cobj_cache.g_pl_currow;

741: l_vrfy_fmly_mmbr_cd := l_par_pl_elig_rec.vrfy_fmly_mmbr_cd;
742: l_vrfy_fmly_mmbr_rl := l_par_pl_elig_rec.vrfy_fmly_mmbr_rl;
743: else
744: --
745: l_par_pl_rec := ben_cobj_cache.g_pl_currow;
746: --
747: l_vrfy_fmly_mmbr_cd := l_par_pl_rec.vrfy_fmly_mmbr_cd;
748: l_vrfy_fmly_mmbr_rl := l_par_pl_rec.vrfy_fmly_mmbr_rl;
749: end if;