[Home] [Help]
396: p_plip_id in number default null,
397: p_opt_id in number default null) is
398: --
399: l_proc varchar2(100):= g_package||'check_los_elig';
400: l_inst_dets ben_elp_cache.g_cache_elpels_instor;
401: l_inst_count number;
402: l_insttorrw_num binary_integer;
403: l_ok boolean := false;
404: l_rows_found boolean := false;
419: hr_utility.set_location('Entering: '||l_proc,10);
420: --
421: -- Getting eligibility profile length of service by eligibility profile
422: --
423: ben_elp_cache.elpels_getcacdets
424: (p_effective_date => nvl(l_fonm_cvg_strt_dt,p_effective_date)
425: ,p_business_group_id => p_business_group_id
426: ,p_eligy_prfl_id => p_eligy_prfl_id
427: ,p_inst_set => l_inst_dets
614: l_dummy_date date;
615: l_prtn_ovridn_flag varchar2(30);
616: l_prtn_ovridn_thru_dt date;
617: l_epo_row ben_derive_part_and_rate_facts.g_cache_structure;
618: l_inst_dets ben_elp_cache.g_cache_elpeap_instor;
619: l_inst_count number;
620: l_insttorrw_num binary_integer;
621: l_crit_passed boolean;
622: l_score_tab scoreTab;
626: hr_utility.set_location('Entering :'||l_proc, 10);
627: --
628: -- Getting eligibility profile age details by eligibility profile
629: --
630: ben_elp_cache.elpeap_getcacdets
631: (p_effective_date => nvl(l_fonm_cvg_strt_dt,p_effective_date)
632: ,p_business_group_id => p_business_group_id
633: ,p_eligy_prfl_id => p_eligy_prfl_id
634: ,p_inst_set => l_inst_dets
808: p_plip_id in number default null,
809: p_opt_id in number default null) is
810: --
811: l_proc varchar2(100):= g_package||'check_age_los_elig';
812: l_inst_dets ben_elp_cache.g_cache_elpecp_instor;
813: l_inst_count number;
814: l_insttorrw_num binary_integer;
815: l_ok boolean := false;
816: l_rows_found boolean := false;
838: hr_utility.set_location('Entering :'||l_proc,10);
839: --
840: -- Getting eligibility profile age/los combination by eligibility profile
841: --
842: ben_elp_cache.elpecp_getcacdets
843: (p_effective_date => nvl(l_fonm_cvg_strt_dt,p_effective_date)
844: ,p_business_group_id => p_business_group_id
845: ,p_eligy_prfl_id => p_eligy_prfl_id
846: ,p_inst_set => l_inst_dets
1101: p_plip_id in number default null,
1102: p_opt_id in number default null) is
1103: --
1104: l_proc varchar2(100):=g_package||'check_comp_level_rl_elig';
1105: l_inst_dets ben_elp_cache.g_cache_elpecl_instor;
1106: l_inst_count number;
1107: l_insttorrw_num binary_integer;
1108: l_ok boolean := false;
1109: l_rows_found boolean := false;
1120: hr_utility.set_location('Entering: '||l_proc, 10);
1121: --
1122: -- Getting eligibility profile compensation level by eligibility profile
1123: --
1124: ben_elp_cache.elpecl_getcacdets
1125: (p_effective_date => nvl(l_fonm_cvg_strt_dt,p_effective_date)
1126: ,p_business_group_id => p_business_group_id
1127: ,p_comp_src_cd => 'RL'
1128: ,p_eligy_prfl_id => p_eligy_prfl_id
1253: p_person_id in number,
1254: p_per_comp_val in number) is
1255: --
1256: l_proc varchar2(100):=g_package||'check_comp_level_elig';
1257: l_inst_dets ben_elp_cache.g_cache_elpecl_instor;
1258: l_inst_count number;
1259: l_insttorrw_num binary_integer;
1260: l_ok boolean := false;
1261: l_rows_found boolean := false;
1268: hr_utility.set_location('Entering: '||l_proc, 10);
1269: --
1270: -- Getting eligibility profile compensation level by eligibility profile
1271: --
1272: ben_elp_cache.elpecl_getcacdets
1273: (p_effective_date => nvl(l_fonm_cvg_strt_dt,p_effective_date)
1274: ,p_business_group_id => p_business_group_id
1275: ,p_comp_src_cd => 'STTDCOMP'
1276: ,p_eligy_prfl_id => p_eligy_prfl_id
1404: p_effective_date in date,
1405: p_per_hrs_wkd in number) is
1406: --
1407: l_proc varchar2(100):= g_package||'check_hrs_wkd_ben_bal';
1408: l_inst_dets ben_elp_cache.g_cache_elpehw_instor;
1409: l_inst_count number;
1410: l_insttorrw_num binary_integer;
1411: l_ok boolean := false;
1412: l_rows_found boolean := false;
1431: end if;
1432: --
1433: -- Getting hours worked profile information
1434: --
1435: ben_elp_cache.elpehw_getcacdets
1436: (p_effective_date => p_effective_date
1437: ,p_business_group_id => p_business_group_id
1438: ,p_hrs_src_cd => 'BNFTBALTYP'
1439: ,p_eligy_prfl_id => p_eligy_prfl_id
1568: p_effective_date in date,
1569: p_per_hrs_wkd in number) is
1570: --
1571: l_proc varchar2(100):= g_package||'check_hrs_wkd_balance';
1572: l_inst_dets ben_elp_cache.g_cache_elpehw_instor;
1573: l_inst_count number;
1574: l_insttorrw_num binary_integer;
1575: l_ok boolean := false;
1576: l_rows_found boolean := false;
1590: end if;
1591: --
1592: -- Getting hours worked profile information
1593: --
1594: ben_elp_cache.elpehw_getcacdets
1595: (p_effective_date => p_effective_date
1596: ,p_business_group_id => p_business_group_id
1597: ,p_hrs_src_cd => 'RL'
1598: ,p_eligy_prfl_id => p_eligy_prfl_id
1723: p_effective_date in date,
1724: p_per_hrs_wkd in number) is
1725: --
1726: l_proc varchar2(100):= g_package||'check_hrs_wkd_balance';
1727: l_inst_dets ben_elp_cache.g_cache_elpehw_instor;
1728: l_inst_count number;
1729: l_insttorrw_num binary_integer;
1730: l_ok boolean := false;
1731: l_rows_found boolean := false;
1745: end if;
1746: --
1747: -- Getting hours worked profile information
1748: --
1749: ben_elp_cache.elpehw_getcacdets
1750: (p_effective_date => p_effective_date
1751: ,p_business_group_id => p_business_group_id
1752: ,p_hrs_src_cd => 'BALTYP'
1753: ,p_eligy_prfl_id => p_eligy_prfl_id
1876: p_effective_date in date,
1877: p_per_pct_ft_val in number) is
1878: --
1879: l_proc varchar2(100):=g_package||'check_pct_fltm_elig';
1880: l_inst_dets ben_elp_cache.g_cache_elpepf_instor;
1881: l_inst_count number;
1882: l_insttorrw_num binary_integer;
1883: l_ok boolean := false;
1884: l_rows_found boolean := false;
1891: hr_utility.set_location('Entering :'||l_proc,10);
1892: --
1893: -- Getting eligibility profile full time by eligibility profile
1894: --
1895: ben_elp_cache.elpepf_getcacdets
1896: (p_effective_date => p_effective_date
1897: ,p_business_group_id => p_business_group_id
1898: ,p_eligy_prfl_id => p_eligy_prfl_id
1899: ,p_inst_set => l_inst_dets
2012: p_effective_date in date,
2013: p_grade_id in number) is
2014: --
2015: l_proc varchar2(100) := g_package||'check_grade_elig';
2016: l_inst_dets ben_elp_cache.g_cache_elpegr_instor;
2017: l_inst_count number;
2018: l_insttorrw_num binary_integer;
2019: l_ok boolean := false;
2020: l_rows_found boolean := false;
2026: hr_utility.set_location('Entering : '||l_proc,10);
2027: --
2028: -- Getting eligibility profile grade by eligibility profile
2029: --
2030: ben_elp_cache.elpegr_getcacdets
2031: (p_effective_date => p_effective_date
2032: ,p_business_group_id => p_business_group_id
2033: ,p_eligy_prfl_id => p_eligy_prfl_id
2034: ,p_inst_set => l_inst_dets
2125: p_effective_date in date,
2126: p_sex in varchar2) is
2127: --
2128: l_proc varchar2(100) := g_package||'check_gender_elig';
2129: l_inst_dets ben_elp_cache.g_cache_elpegn_instor;
2130: l_inst_count number;
2131: l_insttorrw_num binary_integer;
2132: l_ok boolean := false;
2133: l_rows_found boolean := false;
2139: hr_utility.set_location('Entering : '||l_proc,10);
2140: --
2141: -- Getting eligibility profile sex by eligibility profile
2142: --
2143: ben_elp_cache.elpegn_getcacdets
2144: (p_effective_date => p_effective_date
2145: ,p_business_group_id => p_business_group_id
2146: ,p_eligy_prfl_id => p_eligy_prfl_id
2147: ,p_inst_set => l_inst_dets
2252: and ITEM_NAME = 'ASSIGNMENT_ID'
2253: and usage = 'U';
2254: --
2255: l_proc varchar2(100) := g_package||'check_rule_elig';
2256: l_inst_dets ben_elp_cache.g_cache_elperl_instor;
2257: l_inst_count number;
2258: l_insttorrw_num binary_integer;
2259: l_ok boolean := false;
2260: l_rows_found boolean := false;
2272: --
2273: -- Getting eligibility profile rule by eligibility profile
2274: --
2275:
2276: ben_elp_cache.elperl_getcacdets
2277: (p_effective_date => p_effective_date
2278: ,p_business_group_id => p_business_group_id
2279: ,p_eligy_prfl_id => p_eligy_prfl_id
2280: ,p_inst_set => l_inst_dets
2446: p_effective_date in date,
2447: p_job_id in number) is
2448: --
2449: l_proc varchar2(100) := g_package||'check_job_elig';
2450: l_inst_dets ben_elp_cache.g_cache_elpejp_instor;
2451: l_inst_count number;
2452: l_insttorrw_num binary_integer;
2453: l_ok boolean := false;
2454: l_rows_found boolean := false;
2460: hr_utility.set_location('Entering : '||l_proc,10);
2461: --
2462: -- Getting eligibility profile job by eligibility profile
2463: --
2464: ben_elp_cache.elpejp_getcacdets
2465: (p_effective_date => p_effective_date
2466: ,p_business_group_id => p_business_group_id
2467: ,p_eligy_prfl_id => p_eligy_prfl_id
2468: ,p_inst_set => l_inst_dets
2558: g_cache_typ_table) is
2559: --
2560: l_proc varchar2(100) := g_package||'check_per_typ_elig';
2561: --
2562: l_inst_dets ben_elp_cache.g_cache_elpept_instor;
2563: l_inst_count number;
2564: l_insttorrw_num binary_integer;
2565: --
2566: l_rows_found boolean := false;
2571: begin
2572: --
2573: hr_utility.set_location('Entering :'||l_proc,10);
2574: --
2575: ben_elp_cache.elpept_getcacdets
2576: (p_effective_date => p_effective_date
2577: ,p_business_group_id => p_business_group_id
2578: ,p_eligy_prfl_id => p_eligy_prfl_id
2579: ,p_inst_set => l_inst_dets
2684: p_effective_date in date,
2685: p_pay_basis_id in number) is
2686: --
2687: l_proc varchar2(100) := g_package||'check_py_bss_elig';
2688: l_inst_dets ben_elp_cache.g_cache_elpepb_instor;
2689: l_inst_count number;
2690: l_insttorrw_num binary_integer;
2691: l_ok boolean := false;
2692: l_rows_found boolean := false;
2698: hr_utility.set_location('Entering : '||l_proc,10);
2699: --
2700: -- Getting eligibility profile pay basis by eligibility profile
2701: --
2702: ben_elp_cache.elpepb_getcacdets
2703: (p_effective_date => p_effective_date
2704: ,p_business_group_id => p_business_group_id
2705: ,p_eligy_prfl_id => p_eligy_prfl_id
2706: ,p_inst_set => l_inst_dets
2824: p_effective_date in date,
2825: p_payroll_id in number) is
2826: --
2827: l_proc varchar2(100) := g_package||'check_pyrl_elig';
2828: l_inst_dets ben_elp_cache.g_cache_elpepy_instor;
2829: l_inst_count number;
2830: l_insttorrw_num binary_integer;
2831: l_ok boolean := false;
2832: l_rows_found boolean := false;
2839: hr_utility.set_location('payroll id : '||p_payroll_id,10);
2840: --
2841: -- Getting eligibility profile payroll by eligibility profile
2842: --
2843: ben_elp_cache.elpepy_getcacdets
2844: (p_effective_date => p_effective_date
2845: ,p_business_group_id => p_business_group_id
2846: ,p_eligy_prfl_id => p_eligy_prfl_id
2847: ,p_inst_set => l_inst_dets
2935: p_effective_date in date,
2936: p_benefit_group_id in number) is
2937: --
2938: l_proc varchar2(100) := g_package||'check_benefits_grp_elig';
2939: l_inst_dets ben_elp_cache.g_cache_elpebn_instor;
2940: l_inst_count number;
2941: l_insttorrw_num binary_integer;
2942: l_ok boolean := false;
2943: l_rows_found boolean := false;
2949: hr_utility.set_location('Entering : '||l_proc,10);
2950: --
2951: -- Getting eligibility profile benefits group by eligibility profile
2952: --
2953: ben_elp_cache.elpebn_getcacdets
2954: (p_effective_date => p_effective_date
2955: ,p_business_group_id => p_business_group_id
2956: ,p_eligy_prfl_id => p_eligy_prfl_id
2957: ,p_inst_set => l_inst_dets
3045: p_effective_date in date,
3046: p_location_id in number) is
3047: --
3048: l_proc varchar2(100) := g_package||'check_wk_location_elig';
3049: l_inst_dets ben_elp_cache.g_cache_elpewl_instor;
3050: l_inst_count number;
3051: l_insttorrw_num binary_integer;
3052: l_ok boolean := false;
3053: l_rows_found boolean := false;
3059: hr_utility.set_location('Entering : '||l_proc,10);
3060: --
3061: -- Getting eligibility profile location by eligibility profile
3062: --
3063: ben_elp_cache.elpewl_getcacdets
3064: (p_effective_date => p_effective_date
3065: ,p_business_group_id => p_business_group_id
3066: ,p_eligy_prfl_id => p_eligy_prfl_id
3067: ,p_inst_set => l_inst_dets
3153: p_effective_date in date,
3154: p_people_group_id in number) is
3155: --
3156: l_proc varchar2(100) := g_package||'check_people_group_elig';
3157: l_inst_dets ben_elp_cache.g_cache_elpepg_instor;
3158: l_inst_count number;
3159: l_insttorrw_num binary_integer;
3160: l_ok boolean := false;
3161: l_rows_found boolean := false;
3208: hr_utility.set_location('Entering : '||l_proc,10);
3209: --
3210: -- Getting eligibility profile organization by eligibility profile
3211: --
3212: ben_elp_cache.elpepg_getcacdets
3213: (p_effective_date => p_effective_date
3214: ,p_business_group_id => p_business_group_id
3215: ,p_eligy_prfl_id => p_eligy_prfl_id
3216: ,p_inst_set => l_inst_dets
3585: p_effective_date in date,
3586: p_organization_id in number) is
3587: --
3588: l_proc varchar2(100) := g_package||'check_org_unit_elig';
3589: l_inst_dets ben_elp_cache.g_cache_elpeou_instor;
3590: l_inst_count number;
3591: l_insttorrw_num binary_integer;
3592: l_ok boolean := false;
3593: l_rows_found boolean := false;
3599: hr_utility.set_location('Entering : '||l_proc,10);
3600: --
3601: -- Getting eligibility profile organization by eligibility profile
3602: --
3603: ben_elp_cache.elpeou_getcacdets
3604: (p_effective_date => p_effective_date
3605: ,p_business_group_id => p_business_group_id
3606: ,p_eligy_prfl_id => p_eligy_prfl_id
3607: ,p_inst_set => l_inst_dets
3693: p_effective_date in date,
3694: p_hourly_salaried_code in varchar2) is
3695: --
3696: l_proc varchar2(100) := g_package||'check_py_freq_elig';
3697: l_inst_dets ben_elp_cache.g_cache_elpehs_instor;
3698: l_inst_count number;
3699: l_insttorrw_num binary_integer;
3700: l_ok boolean := false;
3701: l_rows_found boolean := false;
3707: hr_utility.set_location('Entering : '||l_proc,10);
3708: --
3709: -- Getting eligibility profile pay frequency by eligibility profile
3710: --
3711: ben_elp_cache.elpehs_getcacdets
3712: (p_effective_date => p_effective_date
3713: ,p_business_group_id => p_business_group_id
3714: ,p_eligy_prfl_id => p_eligy_prfl_id
3715: ,p_inst_set => l_inst_dets
3807: is
3808: --
3809: l_proc varchar2(100) := g_package||'check_service_area_elig';
3810: /*
3811: l_inst_dets ben_elp_cache.g_cache_elpesa_instor;
3812: */
3813: l_rows_found boolean := false;
3814: l_pad_rec per_addresses%rowtype;
3815: l_svc_area_id number(15);
4118: l_proc varchar2(100) := g_package||'check_sched_hrs_elig';
4119: l_ok boolean := false;
4120: l_rows_found boolean := false;
4121: --
4122: l_inst_dets ben_elp_cache.g_cache_elpesh_instor;
4123: l_inst_count number;
4124: l_insttorrw_num binary_integer;
4125: --
4126: l_sched_effective_date date;
4163:
4164: -- Getting eligibility profile scheduled hours by eligibility profile
4165: --
4166:
4167: ben_elp_cache.elpesh_getcacdets
4168: (p_effective_date => nvl(l_fonm_cvg_strt_dt, p_effective_date)
4169: ,p_business_group_id => p_business_group_id
4170: ,p_eligy_prfl_id => p_eligy_prfl_id
4171: ,p_inst_set => l_inst_dets
4478: p_effective_date in date,
4479: p_bargaining_unit_code in varchar2) is
4480: --
4481: l_proc varchar2(100) := g_package||'check_brg_unit_elig';
4482: l_inst_dets ben_elp_cache.g_cache_elpebu_instor;
4483: l_inst_count number;
4484: l_insttorrw_num binary_integer;
4485: l_ok boolean := false;
4486: l_rows_found boolean := false;
4492: hr_utility.set_location('Entering : '||l_proc,10);
4493: --
4494: -- Getting eligibility profile bargaining unit by eligibility profile
4495: --
4496: ben_elp_cache.elpebu_getcacdets
4497: (p_effective_date => p_effective_date
4498: ,p_business_group_id => p_business_group_id
4499: ,p_eligy_prfl_id => p_eligy_prfl_id
4500: ,p_inst_set => l_inst_dets
4586: p_effective_date in date,
4587: p_labour_union_member_flag in varchar2) is
4588: --
4589: l_proc varchar2(100) := g_package||'check_lbr_union_elig';
4590: l_inst_dets ben_elp_cache.g_cache_elpelu_instor;
4591: l_inst_count number;
4592: l_insttorrw_num binary_integer;
4593: l_ok boolean := false;
4594: l_rows_found boolean := false;
4600: hr_utility.set_location('Entering : '||l_proc,10);
4601: --
4602: -- Getting eligibility profile labour union membership by eligibility profile
4603: --
4604: ben_elp_cache.elpelu_getcacdets
4605: (p_effective_date => p_effective_date
4606: ,p_business_group_id => p_business_group_id
4607: ,p_eligy_prfl_id => p_eligy_prfl_id
4608: ,p_inst_set => l_inst_dets
4695: p_assignment_status_type_id in number) is
4696: --
4697: l_proc varchar2(100) := g_package||'check_ee_stat_elig';
4698: --
4699: l_inst_dets ben_elp_cache.g_cache_elpees_instor;
4700: l_inst_count number;
4701: l_insttorrw_num binary_integer;
4702: --
4703: l_ok boolean := false;
4710: hr_utility.set_location('Entering : '||l_proc,10);
4711: --
4712: -- Getting eligibility profile assignment status type by eligibility profile
4713: --
4714: ben_elp_cache.elpees_getcacdets
4715: (p_effective_date => p_effective_date
4716: ,p_business_group_id => p_business_group_id
4717: ,p_eligy_prfl_id => p_eligy_prfl_id
4718: ,p_inst_set => l_inst_dets
4810: p_abs_attd_reason_id in varchar2 default null,
4811: p_effective_date in date) is
4812: --
4813: l_proc varchar2(100) := g_package||'check_loa_rsn_elig';
4814: l_inst_dets ben_elp_cache.g_cache_elpelr_instor;
4815: l_inst_count number;
4816: l_insttorrw_num binary_integer;
4817: l_ok boolean := false;
4818: l_ok1 boolean := false;
4842: hr_utility.set_location('Entering : '||l_proc,10);
4843: --
4844: -- Getting eligibility profile leave of absence reason by eligibility profile
4845: --
4846: ben_elp_cache.elpelr_getcacdets
4847: (p_effective_date => p_effective_date
4848: ,p_business_group_id => p_business_group_id
4849: ,p_eligy_prfl_id => p_eligy_prfl_id
4850: ,p_inst_set => l_inst_dets
5055: p_effective_date in date,
5056: p_gre_name in varchar2) is
5057: --
5058: l_proc varchar2(100) := g_package||'check_lgl_ent_elig';
5059: l_inst_dets ben_elp_cache.g_cache_elpeln_instor;
5060: l_inst_count number;
5061: l_insttorrw_num binary_integer;
5062: l_ok boolean := false;
5063: l_rows_found boolean := false;
5069: hr_utility.set_location('Entering : '||l_proc,10);
5070: --
5071: -- Getting eligibility profile legal entity by eligibility profile
5072: --
5073: ben_elp_cache.elpeln_getcacdets
5074: (p_effective_date => p_effective_date
5075: ,p_business_group_id => p_business_group_id
5076: ,p_eligy_prfl_id => p_eligy_prfl_id
5077: ,p_inst_set => l_inst_dets
5169: p_lf_evt_ocrd_dt in date) is
5170: --
5171: l_proc varchar2(100) := g_package||
5172: 'check_prtt_in_anthr_pl_elig';
5173: l_inst_dets ben_elp_cache.g_cache_elpepp_instor;
5174: l_inst_count number;
5175: l_insttorrw_num binary_integer;
5176: l_ok boolean := false;
5177: l_rows_found boolean := false;
5205: hr_utility.set_location('Entering : '||l_proc,10);
5206: --
5207: -- Getting eligibility profile other plan by eligibility profile
5208: --
5209: ben_elp_cache.elpepp_getcacdets
5210: (p_effective_date => nvl(p_lf_evt_ocrd_dt,p_effective_date)
5211: ,p_business_group_id => p_business_group_id
5212: ,p_eligy_prfl_id => p_eligy_prfl_id
5213: ,p_inst_set => l_inst_dets
5273: p_effective_date in date,
5274: p_employment_category in varchar2) is
5275: --
5276: l_proc varchar2(100) := g_package||'check_fl_tm_pt_elig';
5277: l_inst_dets ben_elp_cache.g_cache_elpefp_instor;
5278: l_inst_count number;
5279: l_insttorrw_num binary_integer;
5280: l_rows_found boolean := false;
5281: l_ok boolean := false;
5287: hr_utility.set_location('Entering : '||l_proc,10);
5288: --
5289: -- Getting eligibility profile full/part time by eligibility profile
5290: --
5291: ben_elp_cache.elpefp_getcacdets
5292: (p_effective_date => p_effective_date
5293: ,p_business_group_id => p_business_group_id
5294: ,p_eligy_prfl_id => p_eligy_prfl_id
5295: ,p_inst_set => l_inst_dets
5394: p_plip_id in number default null,
5395: p_opt_id in number default null) is
5396: --
5397: l_proc varchar2(100):=g_package||'check_person_ben_bal';
5398: l_inst_dets ben_elp_cache.g_cache_elpecl_instor;
5399: l_inst_count number;
5400: l_insttorrw_num binary_integer;
5401: l_ok boolean := false;
5402: l_rows_found boolean := false;
5409: hr_utility.set_location('Entering: '||l_proc, 10);
5410: --
5411: -- Getting eligibility profile compensation level by eligibility profile
5412: --
5413: ben_elp_cache.elpecl_getcacdets
5414: (p_effective_date => nvl(l_fonm_cvg_strt_dt,p_effective_date)
5415: ,p_business_group_id => p_business_group_id
5416: ,p_comp_src_cd => 'BNFTBALTYP'
5417: ,p_eligy_prfl_id => p_eligy_prfl_id
5542: p_person_id in number,
5543: p_effective_date in date) is
5544: --
5545: l_proc varchar2(100):=g_package||'check_asnt_set';
5546: l_inst_dets ben_elp_cache.g_cache_elpean_instor;
5547: l_inst_count number;
5548: l_insttorrw_num binary_integer;
5549: l_ok boolean := false;
5550: l_rows_found boolean := false;
5559: hr_utility.set_location('Entering: '||l_proc, 10);
5560: --
5561: -- Getting eligibility profile compensation level by eligibility profile
5562: --
5563: ben_elp_cache.elpean_getcacdets
5564: (p_effective_date => p_effective_date
5565: ,p_business_group_id => p_business_group_id
5566: ,p_eligy_prfl_id => p_eligy_prfl_id
5567: ,p_inst_set => l_inst_dets
5724: p_plip_id in number default null,
5725: p_opt_id in number default null) is
5726: --
5727: l_proc varchar2(100):=g_package||'check_person_balance';
5728: l_inst_dets ben_elp_cache.g_cache_elpecl_instor;
5729: l_inst_count number;
5730: l_insttorrw_num binary_integer;
5731: l_ok boolean := false;
5732: l_rows_found boolean := false;
5739: hr_utility.set_location('Entering: '||l_proc, 10);
5740: --
5741: -- Getting eligibility profile compensation level by eligibility profile
5742: --
5743: ben_elp_cache.elpecl_getcacdets
5744: (p_effective_date => nvl(l_fonm_cvg_strt_dt,p_effective_date)
5745: ,p_business_group_id => p_business_group_id
5746: ,p_comp_src_cd => 'BALTYP'
5747: ,p_eligy_prfl_id => p_eligy_prfl_id
5870: p_business_group_id in number,
5871: p_effective_date in date) is
5872: --
5873: l_proc varchar2(100):=g_package||'check_elig_no_othr_cvg_prte';
5874: l_inst_dets ben_elp_cache.g_cache_elpeno_instor;
5875: l_inst_count number;
5876: l_insttorrw_num binary_integer;
5877: l_ok boolean := false;
5878: l_rows_found boolean := false;
5883: hr_utility.set_location('Entering: '||l_proc, 10);
5884: --
5885: -- Getting eligibility profile compensation level by eligibility profile
5886: --
5887: ben_elp_cache.elpeno_getcacdets
5888: (p_effective_date => p_effective_date,
5889: p_business_group_id => p_business_group_id,
5890: p_eligy_prfl_id => p_eligy_prfl_id,
5891: p_inst_set => l_inst_dets,
5941: p_leaving_reason in varchar2 default null,
5942: p_effective_date in date) is
5943: --
5944: l_proc varchar2(100):=g_package||'check_elig_lvg_rsn_prte';
5945: l_inst_dets ben_elp_cache.g_cache_elpelv_instor;
5946: l_inst_count number;
5947: l_insttorrw_num binary_integer;
5948: l_ok boolean := false;
5949: l_rows_found boolean := false;
5956: hr_utility.set_location('Entering: '||l_proc, 10);
5957: --
5958: -- Getting eligibility profile compensation level by eligibility profile
5959: --
5960: ben_elp_cache.elpelv_getcacdets
5961: (p_effective_date => p_effective_date,
5962: p_business_group_id => p_business_group_id,
5963: p_eligy_prfl_id => p_eligy_prfl_id,
5964: p_inst_set => l_inst_dets,
6061: p_business_group_id in number,
6062: p_effective_date in date) is
6063: --
6064: l_proc varchar2(100):=g_package||'check_elig_optd_mdcr_prte';
6065: l_inst_dets ben_elp_cache.g_cache_elpeom_instor;
6066: l_inst_count number;
6067: l_insttorrw_num binary_integer;
6068: l_ok boolean := false;
6069: l_rows_found boolean := false;
6074: hr_utility.set_location('Entering: '||l_proc, 10);
6075: --
6076: -- Getting eligibility profile compensation level by eligibility profile
6077: --
6078: ben_elp_cache.elpeom_getcacdets
6079: (p_effective_date => p_effective_date,
6080: p_business_group_id => p_business_group_id,
6081: p_eligy_prfl_id => p_eligy_prfl_id,
6082: p_inst_set => l_inst_dets,
6133: p_effective_date in date,
6134: p_lf_evt_ocrd_dt in date) is
6135: --
6136: l_proc varchar2(100):=g_package||'check_elig_enrld_anthr_pl';
6137: l_inst_dets ben_elp_cache.g_cache_elpeep_instor;
6138: l_inst_count number;
6139: l_insttorrw_num binary_integer;
6140: l_ok boolean := false;
6141: l_rows_found boolean := false;
6148: hr_utility.set_location('Entering: '||l_proc, 10);
6149: --
6150: -- Getting eligibility profile enrld in another plan by eligibility profile
6151: --
6152: ben_elp_cache.elpeep_getcacdets
6153: (p_effective_date => nvl(p_lf_evt_ocrd_dt,p_effective_date),
6154: p_business_group_id => p_business_group_id,
6155: p_eligy_prfl_id => p_eligy_prfl_id,
6156: p_inst_set => l_inst_dets,
6249: p_effective_date in date,
6250: p_lf_evt_ocrd_dt in date) is
6251: --
6252: l_proc varchar2(100):=g_package||'check_elig_enrld_anthr_oipl';
6253: l_inst_dets ben_elp_cache.g_cache_elpeei_instor;
6254: l_inst_count number;
6255: l_insttorrw_num binary_integer;
6256: l_ok boolean := false;
6257: l_rows_found boolean := false;
6276: hr_utility.set_location('Entering: '||l_proc, 10);
6277: --
6278: -- Getting eligibility profile compensation level by eligibility profile
6279: --
6280: ben_elp_cache.elpeei_getcacdets
6281: (p_effective_date => nvl(l_fonm_cvg_strt_dt,nvl(p_lf_evt_ocrd_dt,p_effective_date)),
6282: p_business_group_id => p_business_group_id,
6283: p_eligy_prfl_id => p_eligy_prfl_id,
6284: p_inst_set => l_inst_dets,
6382: )
6383: is
6384: --
6385: l_proc varchar2(100):=g_package||'check_elig_enrld_anthr_pgm';
6386: l_inst_dets ben_elp_cache.g_cache_elpeeg_instor;
6387: l_inst_count number;
6388: l_insttorrw_num binary_integer;
6389: l_ok boolean := false;
6390: l_rows_found boolean := false;
6398: hr_utility.set_location('prfl_id: '||p_eligy_prfl_id, 10);
6399: --
6400: -- Getting eligibility profile compensation level by eligibility profile
6401: --
6402: ben_elp_cache.elpeeg_getcacdets
6403: (p_effective_date => nvl(l_fonm_cvg_strt_dt,nvl(p_lf_evt_ocrd_dt,p_effective_date)),
6404: p_business_group_id => p_business_group_id,
6405: p_eligy_prfl_id => p_eligy_prfl_id,
6406: p_inst_set => l_inst_dets,
6502: p_effective_date in date,
6503: p_lf_evt_ocrd_dt in date) is
6504: --
6505: l_proc varchar2(100):=g_package||'check_elig_dpnt_cvrd_othr_pl';
6506: l_inst_dets ben_elp_cache.g_cache_elpedp_instor;
6507: l_inst_count number;
6508: l_insttorrw_num binary_integer;
6509: l_ok boolean := false;
6510: l_rows_found boolean := false;
6536: hr_utility.set_location('Entering: '||l_proc, 10);
6537: --
6538: -- Getting eligibility profile compensation level by eligibility profile
6539: --
6540: ben_elp_cache.elpedp_getcacdets
6541: (p_effective_date => nvl(p_lf_evt_ocrd_dt,p_effective_date),
6542: p_business_group_id => p_business_group_id,
6543: p_eligy_prfl_id => p_eligy_prfl_id,
6544: p_inst_set => l_inst_dets,
6621: p_effective_date in date,
6622: p_lf_evt_ocrd_dt in date) is
6623: --
6624: l_proc varchar2(100):=g_package||'check_elig_enrld_anthr_plip';
6625: l_inst_dets ben_elp_cache.g_cache_elpeai_instor;
6626: l_inst_count number;
6627: l_insttorrw_num binary_integer;
6628: l_ok boolean := false;
6629: l_rows_found boolean := false;
6654: hr_utility.set_location('Entering: '||l_proc, 10);
6655: --
6656: -- Getting eligibility profile compensation level by eligibility profile
6657: --
6658: ben_elp_cache.elpeai_getcacdets
6659: (p_effective_date => nvl(l_fonm_cvg_strt_dt,nvl(p_lf_evt_ocrd_dt,p_effective_date)),
6660: p_business_group_id => p_business_group_id,
6661: p_eligy_prfl_id => p_eligy_prfl_id,
6662: p_inst_set => l_inst_dets,
6741: p_effective_date in date,
6742: p_lf_evt_ocrd_dt in date) is
6743: --
6744: l_proc varchar2(100):=g_package||'check_elig_dpnt_cvrd_othr_plip';
6745: l_inst_dets ben_elp_cache.g_cache_elpedi_instor;
6746: l_inst_count number;
6747: l_insttorrw_num binary_integer;
6748: l_ok boolean := false;
6749: l_rows_found boolean := false;
6783: hr_utility.set_location('Entering: '||l_proc, 10);
6784: --
6785: -- Getting eligibility profile compensation level by eligibility profile
6786: --
6787: ben_elp_cache.elpedi_getcacdets
6788: (p_effective_date => nvl(l_fonm_cvg_strt_dt,nvl(p_lf_evt_ocrd_dt,p_effective_date)),
6789: p_business_group_id => p_business_group_id,
6790: p_eligy_prfl_id => p_eligy_prfl_id,
6791: p_inst_set => l_inst_dets,
6870: p_lf_evt_ocrd_dt in date) is
6871: --
6872: l_proc varchar2(100):=g_package||'check_elig_enrld_anthr_ptip';
6873: --
6874: l_inst_dets ben_elp_cache.g_cache_elpeet_instor;
6875: l_inst_count number;
6876: l_insttorrw_num binary_integer;
6877: l_ok boolean := false;
6878: l_rows_found boolean := false;
6911: hr_utility.set_location('l_fonm_cvg_strt_dt: '||l_fonm_cvg_strt_dt, 10);
6912: --
6913: -- Getting eligibility profile compensation level by eligibility profile
6914: --
6915: ben_elp_cache.elpeet_getcacdets
6916: (p_effective_date => nvl(l_fonm_cvg_strt_dt,nvl(p_lf_evt_ocrd_dt,p_effective_date)),
6917: p_business_group_id => p_business_group_id,
6918: p_eligy_prfl_id => p_eligy_prfl_id,
6919: p_inst_set => l_inst_dets,
7061: p_effective_date in date,
7062: p_lf_evt_ocrd_dt in date) is
7063: --
7064: l_proc varchar2(100):=g_package||'check_elig_dpnt_cvrd_othr_ptip';
7065: l_inst_dets ben_elp_cache.g_cache_elpedt_instor;
7066: l_inst_count number;
7067: l_insttorrw_num binary_integer;
7068: l_ok boolean := false;
7069: l_rows_found boolean := false;
7114: hr_utility.set_location('Entering: '||l_proc, 10);
7115: --
7116: -- Getting eligibility profile compensation level by eligibility profile
7117: --
7118: ben_elp_cache.elpedt_getcacdets
7119: (p_effective_date => nvl(l_fonm_cvg_strt_dt,
7120: nvl(p_lf_evt_ocrd_dt,p_effective_date)),
7121: p_business_group_id => p_business_group_id,
7122: p_eligy_prfl_id => p_eligy_prfl_id,
7216: p_effective_date in date,
7217: p_lf_evt_ocrd_dt in date) is
7218: --
7219: l_proc varchar2(100):=g_package||'check_elig_dpnt_cvrd_othr_pgm';
7220: l_inst_dets ben_elp_cache.g_cache_elpedg_instor;
7221: l_inst_count number;
7222: l_insttorrw_num binary_integer;
7223: l_ok boolean := false;
7224: l_rows_found boolean := false;
7250: hr_utility.set_location('Entering: '||l_proc, 10);
7251: --
7252: -- Getting eligibility profile compensation level by eligibility profile
7253: --
7254: ben_elp_cache.elpedg_getcacdets
7255: (p_effective_date => nvl(l_fonm_cvg_strt_dt,nvl(p_lf_evt_ocrd_dt,p_effective_date)),
7256: p_business_group_id => p_business_group_id,
7257: p_eligy_prfl_id => p_eligy_prfl_id,
7258: p_inst_set => l_inst_dets,
7336: p_lf_evt_ocrd_dt in date,
7337: p_effective_date in date) is
7338: --
7339: l_proc varchar2(100):=g_package||'check_elig_cbr_quald_bnf';
7340: l_inst_dets ben_elp_cache.g_cache_elpecq_instor;
7341: l_quald_bnf_flag ben_cbr_quald_bnf.quald_bnf_flag%type;
7342: l_cbr_elig_perd_strt_dt ben_cbr_quald_bnf.cbr_elig_perd_strt_dt%type;
7343:
7344: l_inst_count number;
7379: hr_utility.set_location('Entering: '||l_proc, 10);
7380: --
7381: -- Getting eligibility profile compensation level by eligibility profile
7382: --
7383: ben_elp_cache.elpecq_getcacdets
7384: (p_effective_date => nvl(p_lf_evt_ocrd_dt,p_effective_date),
7385: p_business_group_id => p_business_group_id,
7386: p_eligy_prfl_id => p_eligy_prfl_id,
7387: p_inst_set => l_inst_dets,
7446: is
7447: --
7448: l_proc varchar2(100) := g_package||'check_dsbld_elig';
7449: --
7450: l_inst_set ben_elp_cache.g_elp_cache := ben_elp_cache.g_elp_cache();
7451: l_ok boolean := false;
7452: l_rows_found boolean := false;
7453: l_ele_num pls_integer;
7454: l_crit_passed boolean;
7457: begin
7458: --
7459: hr_utility.set_location('Entering : '||l_proc,10);
7460: --
7461: ben_elp_cache.elpeds_getdets
7462: (p_effective_date => p_effective_date
7463: ,p_eligy_prfl_id => p_eligy_prfl_id
7464: --
7465: ,p_inst_set => l_inst_set
7558: is
7559: --
7560: l_proc varchar2(100) := g_package||'check_tbco_use_elig';
7561: --
7562: l_inst_set ben_elp_cache.g_elp_cache := ben_elp_cache.g_elp_cache();
7563: l_ok boolean := false;
7564: l_rows_found boolean := false;
7565: l_ele_num pls_integer;
7566: l_crit_passed boolean;
7569: begin
7570: --
7571: hr_utility.set_location('Entering : '||l_proc,10);
7572: --
7573: ben_elp_cache.elpetu_getdets
7574: (p_effective_date => p_effective_date
7575: ,p_eligy_prfl_id => p_eligy_prfl_id
7576: --
7577: ,p_inst_set => l_inst_set
7669: p_effective_date in date) is
7670: --
7671: l_proc varchar2(100):=g_package||'.check_ttl_cvg_vol_elig';
7672: --
7673: l_inst_set ben_elp_cache.g_elp_cache := ben_elp_cache.g_elp_cache();
7674: l_ok boolean := false;
7675: l_rows_found boolean := false;
7676: l_ele_num pls_integer;
7677: --
7709: begin
7710: --
7711: hr_utility.set_location('Entering: '||l_proc, 10);
7712: --
7713: ben_elp_cache.elpetc_getdets
7714: (p_effective_date => nvl(l_fonm_cvg_strt_dt,p_effective_date)
7715: ,p_eligy_prfl_id => p_eligy_prfl_id
7716: --
7717: ,p_inst_set => l_inst_set
7806: p_effective_date in date) is
7807: --
7808: l_proc varchar2(100):=g_package||'.check_ttl_prtt_elig';
7809: --
7810: l_inst_set ben_elp_cache.g_elp_cache := ben_elp_cache.g_elp_cache();
7811: l_ok boolean := false;
7812: l_rows_found boolean := false;
7813: l_ele_num pls_integer;
7814: --
7846: begin
7847: --
7848: hr_utility.set_location('Entering: '||l_proc, 10);
7849: --
7850: ben_elp_cache.elpetp_getdets
7851: (p_effective_date => nvl(l_fonm_cvg_strt_dt,p_effective_date)
7852: ,p_eligy_prfl_id => p_eligy_prfl_id
7853: --
7854: ,p_inst_set => l_inst_set
7942: p_effective_date in date) is
7943: --
7944: l_proc varchar2(100):=g_package||'.check_anthr_pl_elig';
7945: --
7946: l_inst_set ben_elp_cache.g_elp_cache := ben_elp_cache.g_elp_cache();
7947: l_ok boolean := false;
7948: l_rows_found boolean := false;
7949: l_ele_num pls_integer;
7950: --
7971: begin
7972: --
7973: hr_utility.set_location('Entering: '||l_proc, 10);
7974: --
7975: ben_elp_cache.elpeop_getdets
7976: (p_effective_date => p_effective_date
7977: ,p_eligy_prfl_id => p_eligy_prfl_id
7978: --
7979: ,p_inst_set => l_inst_set
8052: p_effective_date in date) is
8053: --
8054: l_proc varchar2(100):=g_package||'.check_hlth_cvg_elig';
8055: --
8056: l_inst_set ben_elp_cache.g_elp_cache := ben_elp_cache.g_elp_cache();
8057: l_ok boolean := false;
8058: l_rows_found boolean := false;
8059: l_ele_num pls_integer;
8060: --
8089: begin
8090: --
8091: hr_utility.set_location('Entering: '||l_proc, 10);
8092: --
8093: ben_elp_cache.elpehc_getdets
8094: (p_effective_date => nvl(l_fonm_cvg_strt_dt,p_effective_date)
8095: ,p_eligy_prfl_id => p_eligy_prfl_id
8096: --
8097: ,p_inst_set => l_inst_set
8175: p_effective_date in date) is
8176: --
8177: l_proc varchar2(100):=g_package||'.check_comptncy_elig';
8178: --
8179: l_inst_set ben_elp_cache.g_elp_cache := ben_elp_cache.g_elp_cache();
8180: l_ok boolean := false;
8181: l_rows_found boolean := false;
8182: l_ele_num pls_integer;
8183: l_effective_date date;
8205: begin
8206: --
8207: hr_utility.set_location('Entering: '||l_proc, 10);
8208: --
8209: ben_elp_cache.elpecy_getdets
8210: (p_effective_date => nvl(l_fonm_cvg_strt_dt,p_effective_date)
8211: ,p_eligy_prfl_id => p_eligy_prfl_id
8212: --
8213: ,p_inst_set => l_inst_set
8329: --
8330:
8331: l_proc varchar2(100):=g_package||'.check_perf_rtng_elig';
8332: --
8333: l_inst_set ben_elp_cache.g_elp_cache := ben_elp_cache.g_elp_cache();
8334: l_ok boolean := false;
8335: l_rows_found boolean := false;
8336: l_ele_num pls_integer;
8337: l_crit_passed boolean;
8393: --
8394: hr_utility.set_location('Entering: '||l_proc, 10);
8395: --
8396: if p_perf_rtng_cd is null then
8397: ben_elp_cache.elpepr_getdets
8398: (p_effective_date => p_effective_date
8399: ,p_eligy_prfl_id => p_eligy_prfl_id
8400: --
8401: ,p_inst_set => l_inst_set
8573: p_lf_evt_ocrd_dt date,
8574: p_pay_basis_id number) is
8575: --
8576: l_proc varchar2(100) := g_package||' check_qua_in_gr_elig';
8577: l_inst_set ben_elp_cache.g_elp_cache := ben_elp_cache.g_elp_cache();
8578: l_ele_num pls_integer;
8579: --
8580: l_dummy varchar2(10) ;
8581: --
8675: begin
8676: --
8677: hr_utility.set_location('Entering: '||l_proc, 10);
8678: --
8679: ben_elp_cache.elpeqg_getdets
8680: (p_effective_date => nvl(l_fonm_cvg_strt_dt,p_effective_date)
8681: ,p_eligy_prfl_id => p_eligy_prfl_id
8682: --
8683: ,p_inst_set => l_inst_set