DBA Data[Home] [Help]

APPS.BEN_CAGR_CHECK_ELIGIBILITY dependencies on BEN_CAGRELP_CACHE

Line 18: l_inst_set ben_cagrelp_cache.g_elp_cache := ben_cagrelp_cache.g_elp_cache();

14: is
15: --
16: l_proc varchar2(100) := g_package||'check_gndr_elig';
17: --
18: l_inst_set ben_cagrelp_cache.g_elp_cache := ben_cagrelp_cache.g_elp_cache();
19: --
20: l_ok boolean := false;
21: l_rows_found boolean := false;
22: --

Line 31: ben_cagrelp_cache.elpegn_getdets

27: begin
28: --
29: hr_utility.set_location('Entering : '||l_proc,10);
30: --
31: ben_cagrelp_cache.elpegn_getdets
32: (p_effective_date => p_effective_date
33: ,p_eligy_prfl_id => p_eligy_prfl_id
34: --
35: ,p_inst_set => l_inst_set

Line 127: l_inst_set ben_cagrelp_cache.g_elp_cache := ben_cagrelp_cache.g_elp_cache();

123: is
124: --
125: l_proc varchar2(100) := g_package||'check_mrtl_sts_elig';
126: --
127: l_inst_set ben_cagrelp_cache.g_elp_cache := ben_cagrelp_cache.g_elp_cache();
128: --
129: l_ok boolean := false;
130: l_rows_found boolean := false;
131: --

Line 140: ben_cagrelp_cache.elpemp_getdets

136: begin
137: --
138: hr_utility.set_location('Entering : '||l_proc,10);
139: --
140: ben_cagrelp_cache.elpemp_getdets
141: (p_effective_date => p_effective_date
142: ,p_eligy_prfl_id => p_eligy_prfl_id
143: --
144: ,p_inst_set => l_inst_set

Line 236: l_inst_set ben_cagrelp_cache.g_elp_cache := ben_cagrelp_cache.g_elp_cache();

232: is
233: --
234: l_proc varchar2(100) := g_package||'check_dsblty_ctg_elig';
235: --
236: l_inst_set ben_cagrelp_cache.g_elp_cache := ben_cagrelp_cache.g_elp_cache();
237: --
238: l_ok boolean := false;
239: l_rows_found boolean := false;
240: --

Line 249: ben_cagrelp_cache.elpect_getdets

245: begin
246: --
247: hr_utility.set_location('Entering : '||l_proc,10);
248: --
249: ben_cagrelp_cache.elpect_getdets
250: (p_effective_date => p_effective_date
251: ,p_eligy_prfl_id => p_eligy_prfl_id
252: --
253: ,p_inst_set => l_inst_set

Line 345: l_inst_set ben_cagrelp_cache.g_elp_cache := ben_cagrelp_cache.g_elp_cache();

341: is
342: --
343: l_proc varchar2(100) := g_package||'check_dsblty_rsn_elig';
344: --
345: l_inst_set ben_cagrelp_cache.g_elp_cache := ben_cagrelp_cache.g_elp_cache();
346: --
347: l_ok boolean := false;
348: l_rows_found boolean := false;
349: --

Line 358: ben_cagrelp_cache.elpedr_getdets

354: begin
355: --
356: hr_utility.set_location('Entering : '||l_proc,10);
357: --
358: ben_cagrelp_cache.elpedr_getdets
359: (p_effective_date => p_effective_date
360: ,p_eligy_prfl_id => p_eligy_prfl_id
361: --
362: ,p_inst_set => l_inst_set

Line 454: l_inst_set ben_cagrelp_cache.g_elp_cache := ben_cagrelp_cache.g_elp_cache();

450: is
451: --
452: l_proc varchar2(100) := g_package||'check_dsblty_dgr_elig';
453: --
454: l_inst_set ben_cagrelp_cache.g_elp_cache := ben_cagrelp_cache.g_elp_cache();
455: --
456: l_ok boolean := false;
457: l_rows_found boolean := false;
458: --

Line 467: ben_cagrelp_cache.elpedd_getdets

463: begin
464: --
465: hr_utility.set_location('Entering : '||l_proc,10);
466: --
467: ben_cagrelp_cache.elpedd_getdets
468: (p_effective_date => p_effective_date
469: ,p_eligy_prfl_id => p_eligy_prfl_id
470: --
471: ,p_inst_set => l_inst_set

Line 564: l_inst_set ben_cagrelp_cache.g_elp_cache := ben_cagrelp_cache.g_elp_cache();

560: is
561: --
562: l_proc varchar2(100) := g_package||'check_suppl_role_elig';
563: --
564: l_inst_set ben_cagrelp_cache.g_elp_cache := ben_cagrelp_cache.g_elp_cache();
565: --
566: l_ok boolean := false;
567: l_rows_found boolean := false;
568: --

Line 577: ben_cagrelp_cache.elpest_getdets

573: begin
574: --
575: hr_utility.set_location('Entering : '||l_proc,10);
576: --
577: ben_cagrelp_cache.elpest_getdets
578: (p_effective_date => p_effective_date
579: ,p_eligy_prfl_id => p_eligy_prfl_id
580: --
581: ,p_inst_set => l_inst_set

Line 675: l_inst_set ben_cagrelp_cache.g_elp_cache := ben_cagrelp_cache.g_elp_cache();

671: is
672: --
673: l_proc varchar2(100) := g_package||'check_qual_titl_elig';
674: --
675: l_inst_set ben_cagrelp_cache.g_elp_cache := ben_cagrelp_cache.g_elp_cache();
676: --
677: l_ok boolean := false;
678: l_rows_found boolean := false;
679: --

Line 688: ben_cagrelp_cache.elpeqt_getdets

684: begin
685: --
686: hr_utility.set_location('Entering : '||l_proc,10);
687: --
688: ben_cagrelp_cache.elpeqt_getdets
689: (p_effective_date => p_effective_date
690: ,p_eligy_prfl_id => p_eligy_prfl_id
691: --
692: ,p_inst_set => l_inst_set

Line 790: l_inst_set ben_cagrelp_cache.g_elp_cache := ben_cagrelp_cache.g_elp_cache();

786: is
787: --
788: l_proc varchar2(100) := g_package||'check_pstn_elig';
789: --
790: l_inst_set ben_cagrelp_cache.g_elp_cache := ben_cagrelp_cache.g_elp_cache();
791: --
792: l_ok boolean := false;
793: l_rows_found boolean := false;
794: --

Line 803: ben_cagrelp_cache.elpeps_getdets

799: begin
800: --
801: hr_utility.set_location('Entering : '||l_proc,10);
802: --
803: ben_cagrelp_cache.elpeps_getdets
804: (p_effective_date => p_effective_date
805: ,p_eligy_prfl_id => p_eligy_prfl_id
806: --
807: ,p_inst_set => l_inst_set

Line 900: l_inst_set ben_cagrelp_cache.g_elp_cache := ben_cagrelp_cache.g_elp_cache();

896: is
897: --
898: l_proc varchar2(100) := g_package||'check_prbtn_perd_elig';
899: --
900: l_inst_set ben_cagrelp_cache.g_elp_cache := ben_cagrelp_cache.g_elp_cache();
901: --
902: l_ok boolean := false;
903: l_rows_found boolean := false;
904: --

Line 911: ben_cagrelp_cache.elpepn_getdets

907: l_crit_passed boolean;
908: l_score_tab ben_evaluate_elig_profiles.scoreTab;
909: begin
910: --
911: ben_cagrelp_cache.elpepn_getdets
912: (p_effective_date => p_effective_date
913: ,p_eligy_prfl_id => p_eligy_prfl_id
914: --
915: ,p_inst_set => l_inst_set

Line 1008: l_inst_set ben_cagrelp_cache.g_elp_cache := ben_cagrelp_cache.g_elp_cache();

1004: is
1005: --
1006: l_proc varchar2(100) := g_package||'check_sp_clng_prg_elig';
1007: --
1008: l_inst_set ben_cagrelp_cache.g_elp_cache := ben_cagrelp_cache.g_elp_cache();
1009: --
1010: l_ok boolean := false;
1011: l_rows_found boolean := false;
1012: --

Line 1021: ben_cagrelp_cache.elpesp_getdets

1017: begin
1018: --
1019: hr_utility.set_location('Entering : '||l_proc,10);
1020: --
1021: ben_cagrelp_cache.elpesp_getdets
1022: (p_effective_date => p_effective_date
1023: ,p_eligy_prfl_id => p_eligy_prfl_id
1024: --
1025: ,p_inst_set => l_inst_set