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 280: l_pgm_rec := ben_cobj_cache.g_pgm_currow;

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

Line 288: l_pl_rec := ben_cobj_cache.g_pl_currow;

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

Line 296: l_oipl_rec := ben_cobj_cache.g_oipl_currow;

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

Line 304: l_plip_rec := ben_cobj_cache.g_plip_currow;

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

Line 312: l_ptip_rec := ben_cobj_cache.g_ptip_currow;

308: if g_debug then
309: hr_utility.set_location('PTIP_ID '||p_ptip_id,20);
310: end if;
311: --
312: l_ptip_rec := ben_cobj_cache.g_ptip_currow;
313: --
314: end if;
315: --
316: if g_debug then

Line 413: l_elig_to_prte_rsn_row := ben_cobj_cache.g_pgmetpr_currow;

409: l_elig_apls_flag := l_pgm_rec.elig_apls_flag;
410:
411: l_all_inelig := l_pgm_rec.all_inelig;
412: --
413: l_elig_to_prte_rsn_row := ben_cobj_cache.g_pgmetpr_currow;
414: --
415: l_elig_inelig_cd := l_elig_to_prte_rsn_row.elig_inelig_cd;
416: --
417: --if the participantion override flag is on then participation override thru date

Line 459: l_elig_to_prte_rsn_row := ben_cobj_cache.g_pletpr_currow;

455: l_elig_apls_flag := l_pl_rec.elig_apls_flag;
456:
457: l_all_inelig := l_pl_rec.all_inelig;
458: --
459: l_elig_to_prte_rsn_row := ben_cobj_cache.g_pletpr_currow;
460: --
461: l_elig_inelig_cd := l_elig_to_prte_rsn_row.elig_inelig_cd;
462: --
463: --if the participantion override flag is on then participation override thru date

Line 507: l_elig_to_prte_rsn_row := ben_cobj_cache.g_plipetpr_currow;

503: --
504:
505: l_all_inelig := l_plip_rec.all_inelig;
506:
507: l_elig_to_prte_rsn_row := ben_cobj_cache.g_plipetpr_currow;
508: --
509: l_elig_inelig_cd := l_elig_to_prte_rsn_row.elig_inelig_cd;
510: --
511: --if the participantion override flag is on then participation override thru date

Line 548: l_elig_to_prte_rsn_row := ben_cobj_cache.g_ptipetpr_currow;

544: l_elig_apls_flag := 'Y';
545:
546: l_all_inelig := l_ptip_rec.all_inelig;
547: --
548: l_elig_to_prte_rsn_row := ben_cobj_cache.g_ptipetpr_currow;
549: --
550: l_elig_inelig_cd := l_elig_to_prte_rsn_row.elig_inelig_cd;
551: --
552: --if the participantion override flag is on then participation override thru date

Line 589: l_elig_to_prte_rsn_row := ben_cobj_cache.g_oipletpr_currow;

585: l_elig_apls_flag := l_oipl_rec.elig_apls_flag;
586:
587: l_all_inelig := l_oipl_rec.all_inelig;
588: --
589: l_elig_to_prte_rsn_row := ben_cobj_cache.g_oipletpr_currow;
590: --
591: l_elig_inelig_cd := l_elig_to_prte_rsn_row.elig_inelig_cd;
592: --
593: --if the participantion override flag is on then participation override thru date

Line 704: l_par_pgm_elig_rec := ben_cobj_cache.g_pgmetpr_currow;

700: --
701: if p_comp_obj_tree_row.par_pgm_id is not null
702: then
703: --
704: l_par_pgm_elig_rec := ben_cobj_cache.g_pgmetpr_currow;
705: --
706: if l_par_pgm_elig_rec.vrfy_fmly_mmbr_cd is not null then
707: l_vrfy_fmly_mmbr_cd := l_par_pgm_elig_rec.vrfy_fmly_mmbr_cd;
708: l_vrfy_fmly_mmbr_rl := l_par_pgm_elig_rec.vrfy_fmly_mmbr_rl;

Line 710: l_par_pgm_rec := ben_cobj_cache.g_pgm_currow;

706: if l_par_pgm_elig_rec.vrfy_fmly_mmbr_cd is not null then
707: l_vrfy_fmly_mmbr_cd := l_par_pgm_elig_rec.vrfy_fmly_mmbr_cd;
708: l_vrfy_fmly_mmbr_rl := l_par_pgm_elig_rec.vrfy_fmly_mmbr_rl;
709: else
710: l_par_pgm_rec := ben_cobj_cache.g_pgm_currow;
711: l_vrfy_fmly_mmbr_cd := l_par_pgm_rec.vrfy_fmly_mmbr_cd;
712: l_vrfy_fmly_mmbr_rl := l_par_pgm_rec.vrfy_fmly_mmbr_rl;
713: end if;
714: --

Line 721: l_par_ptip_elig_rec := ben_cobj_cache.g_ptipetpr_currow;

717: if l_vrfy_fmly_mmbr_cd is null and
718: p_comp_obj_tree_row.par_ptip_id is not null
719: then
720: --
721: l_par_ptip_elig_rec := ben_cobj_cache.g_ptipetpr_currow;
722: --
723: if l_par_ptip_elig_rec.vrfy_fmly_mmbr_cd is not null then
724: l_vrfy_fmly_mmbr_cd := l_par_ptip_elig_rec.vrfy_fmly_mmbr_cd;
725: l_vrfy_fmly_mmbr_rl := l_par_ptip_elig_rec.vrfy_fmly_mmbr_rl;

Line 727: l_par_ptip_rec := ben_cobj_cache.g_ptip_currow;

723: if l_par_ptip_elig_rec.vrfy_fmly_mmbr_cd is not null then
724: l_vrfy_fmly_mmbr_cd := l_par_ptip_elig_rec.vrfy_fmly_mmbr_cd;
725: l_vrfy_fmly_mmbr_rl := l_par_ptip_elig_rec.vrfy_fmly_mmbr_rl;
726: else
727: l_par_ptip_rec := ben_cobj_cache.g_ptip_currow;
728: l_vrfy_fmly_mmbr_cd := l_par_ptip_rec.vrfy_fmly_mmbr_cd;
729: l_vrfy_fmly_mmbr_rl := l_par_ptip_rec.vrfy_fmly_mmbr_rl;
730: end if;
731: --

Line 741: l_par_plip_elig_rec := ben_cobj_cache.g_plipetpr_currow;

737: if l_vrfy_fmly_mmbr_cd is null and
738: p_comp_obj_tree_row.par_plip_id is not null
739: then
740: --
741: l_par_plip_elig_rec := ben_cobj_cache.g_plipetpr_currow;
742: --
743: if l_par_plip_elig_rec.vrfy_fmly_mmbr_cd is not null then
744: l_vrfy_fmly_mmbr_cd := l_par_plip_elig_rec.vrfy_fmly_mmbr_cd;
745: l_vrfy_fmly_mmbr_rl := l_par_plip_elig_rec.vrfy_fmly_mmbr_rl;

Line 748: l_par_plip_rec := ben_cobj_cache.g_plip_currow;

744: l_vrfy_fmly_mmbr_cd := l_par_plip_elig_rec.vrfy_fmly_mmbr_cd;
745: l_vrfy_fmly_mmbr_rl := l_par_plip_elig_rec.vrfy_fmly_mmbr_rl;
746: else
747: --
748: l_par_plip_rec := ben_cobj_cache.g_plip_currow;
749: --
750: l_vrfy_fmly_mmbr_cd := l_par_plip_rec.vrfy_fmly_mmbr_cd;
751: l_vrfy_fmly_mmbr_rl := l_par_plip_rec.vrfy_fmly_mmbr_rl;
752: end if;

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

757: if l_vrfy_fmly_mmbr_cd is null and
758: p_comp_obj_tree_row.par_pl_id is not null
759: then
760: --
761: -- BUG 3168805 l_par_pl_elig_rec := ben_cobj_cache.g_pgmetpr_currow;
762: -- looks like typo, we should be looking at plan rec not pgm rec
763: l_par_pl_elig_rec := ben_cobj_cache.g_pletpr_currow;
764: --
765: if l_par_pl_elig_rec.vrfy_fmly_mmbr_cd is not null then

Line 763: l_par_pl_elig_rec := ben_cobj_cache.g_pletpr_currow;

759: then
760: --
761: -- BUG 3168805 l_par_pl_elig_rec := ben_cobj_cache.g_pgmetpr_currow;
762: -- looks like typo, we should be looking at plan rec not pgm rec
763: l_par_pl_elig_rec := ben_cobj_cache.g_pletpr_currow;
764: --
765: if l_par_pl_elig_rec.vrfy_fmly_mmbr_cd is not null then
766: l_vrfy_fmly_mmbr_cd := l_par_pl_elig_rec.vrfy_fmly_mmbr_cd;
767: l_vrfy_fmly_mmbr_rl := l_par_pl_elig_rec.vrfy_fmly_mmbr_rl;

Line 770: l_par_pl_rec := ben_cobj_cache.g_pl_currow;

766: l_vrfy_fmly_mmbr_cd := l_par_pl_elig_rec.vrfy_fmly_mmbr_cd;
767: l_vrfy_fmly_mmbr_rl := l_par_pl_elig_rec.vrfy_fmly_mmbr_rl;
768: else
769: --
770: l_par_pl_rec := ben_cobj_cache.g_pl_currow;
771: --
772: l_vrfy_fmly_mmbr_cd := l_par_pl_rec.vrfy_fmly_mmbr_cd;
773: l_vrfy_fmly_mmbr_rl := l_par_pl_rec.vrfy_fmly_mmbr_rl;
774: end if;