[Home] [Help]
18: ,p_effective_date in date
19: ,p_lf_evt_ocrd_dt in date
20: ,p_people_group_id in varchar2) is
21: --
22: l_inst_set ben_rt_prfl_cache.g_pg_inst_tbl;
23: l_inst_count number;
24: l_ok boolean := false;
25: l_rows_found boolean := false;
26: l_seg_ok boolean := true;
44: begin
45: --
46: -- Get the data from the cache.
47: --
48: ben_rt_prfl_cache.get_rt_prfl_cache
49: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
50: ,p_effective_date => p_effective_date
51: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
52: ,p_business_group_id => p_business_group_id
408: ,p_jurisdiction_code in varchar2)
409: is
410: --
411: l_outputs ff_exec.outputs_t;
412: l_inst_set ben_rt_prfl_cache.g_rl_inst_tbl;
413: l_inst_count number;
414: l_ok boolean := false;
415: l_rows_found boolean := false;
416: l_ben_vapro_rul_cond varchar2(30) := 'A' ;
418: begin
419: --
420: -- Get the data from the cache.
421: --
422: ben_rt_prfl_cache.get_rt_prfl_cache
423: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
424: ,p_effective_date => p_effective_date
425: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
426: ,p_business_group_id => p_business_group_id
497: ,p_effective_date in date
498: ,p_lf_evt_ocrd_dt in date
499: ,p_tobacco in varchar2) is
500: --
501: l_inst_set ben_rt_prfl_cache.g_tbco_inst_tbl;
502: l_inst_count number;
503: l_ok boolean := false;
504: l_rows_found boolean := false;
505: --
506: begin
507: --
508: -- Get the data from the cache.
509: --
510: ben_rt_prfl_cache.get_rt_prfl_cache
511: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
512: ,p_effective_date => p_effective_date
513: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
514: ,p_business_group_id => p_business_group_id
574: ,p_effective_date in date
575: ,p_lf_evt_ocrd_dt in date
576: ,p_sex in varchar2) is
577: --
578: l_inst_set ben_rt_prfl_cache.g_gndr_inst_tbl;
579: l_inst_count number;
580: l_ok boolean := false;
581: l_rows_found boolean := false;
582: --
583: begin
584: --
585: -- Get the data from the cache.
586: --
587: ben_rt_prfl_cache.get_rt_prfl_cache
588: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
589: ,p_effective_date => p_effective_date
590: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
591: ,p_business_group_id => p_business_group_id
655: ,p_effective_date in date
656: ,p_lf_evt_ocrd_dt in date
657: ,p_dsbld_cd in varchar2) is
658: --
659: l_inst_set ben_rt_prfl_cache.g_dsbld_inst_tbl;
660: l_inst_count number;
661: l_ok boolean := false;
662: l_rows_found boolean := false;
663: --
664: begin
665: --
666: -- Get the data from the cache.
667: --
668: ben_rt_prfl_cache.get_rt_prfl_cache
669: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
670: ,p_effective_date => p_effective_date
671: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
672: ,p_business_group_id => p_business_group_id
732: ,p_effective_date in date
733: ,p_lf_evt_ocrd_dt in date
734: ,p_bargaining_unit_code in varchar2) is
735: --
736: l_inst_set ben_rt_prfl_cache.g_brgng_inst_tbl;
737: l_inst_count number;
738: l_ok boolean := false;
739: l_rows_found boolean := false;
740: --
741: begin
742: --
743: -- Get the data from the cache.
744: --
745: ben_rt_prfl_cache.get_rt_prfl_cache
746: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
747: ,p_effective_date => p_effective_date
748: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
749: ,p_business_group_id => p_business_group_id
810: ,p_effective_date in date
811: ,p_lf_evt_ocrd_dt in date
812: ,p_benefit_group_id in number) is
813: --
814: l_inst_set ben_rt_prfl_cache.g_bnfgrp_inst_tbl;
815: l_inst_count number;
816: l_ok boolean := false;
817: l_rows_found boolean := false;
818: --
819: begin
820: --
821: -- Get the data from the cache.
822: --
823: ben_rt_prfl_cache.get_rt_prfl_cache
824: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
825: ,p_effective_date => p_effective_date
826: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
827: ,p_business_group_id => p_business_group_id
889: ,p_effective_date in date
890: ,p_lf_evt_ocrd_dt in date
891: ,p_assignment_status_type_id in number) is
892: --
893: l_inst_set ben_rt_prfl_cache.g_eestat_inst_tbl;
894: l_inst_count number;
895: l_ok boolean := false;
896: l_rows_found boolean := false;
897: --
898: begin
899: --
900: -- Get the data from the cache.
901: --
902: ben_rt_prfl_cache.get_rt_prfl_cache
903: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
904: ,p_effective_date => p_effective_date
905: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
906: ,p_business_group_id => p_business_group_id
968: ,p_effective_date in date
969: ,p_lf_evt_ocrd_dt in date
970: ,p_employment_category in varchar2) is
971: --
972: l_inst_set ben_rt_prfl_cache.g_ftpt_inst_tbl;
973: l_inst_count number;
974: l_ok boolean := false;
975: l_rows_found boolean := false;
976: --
977: begin
978: --
979: -- Get the data from the cache.
980: --
981: ben_rt_prfl_cache.get_rt_prfl_cache
982: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
983: ,p_effective_date => p_effective_date
984: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
985: ,p_business_group_id => p_business_group_id
1047: ,p_effective_date in date
1048: ,p_lf_evt_ocrd_dt in date
1049: ,p_grade_id in number) is
1050: --
1051: l_inst_set ben_rt_prfl_cache.g_grd_inst_tbl;
1052: l_inst_count number;
1053: l_ok boolean := false;
1054: l_rows_found boolean := false;
1055: --
1056: begin
1057: --
1058: -- Get the data from the cache.
1059: --
1060: ben_rt_prfl_cache.get_rt_prfl_cache
1061: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
1062: ,p_effective_date => p_effective_date
1063: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
1064: ,p_business_group_id => p_business_group_id
1184: and pil.business_group_id(+)=bep.business_group_id
1185: and (pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT') -- found row condition
1186: or pil.per_in_ler_stat_cd is null); -- outer join condition
1187:
1188: l_inst_set ben_rt_prfl_cache.g_pctft_inst_tbl;
1189: l_inst_count number;
1190: l_rows_found boolean := false;
1191: l_mx_pct_val number ;
1192: --
1224: end if;
1225:
1226: -- Get the rate profile data from the cache.
1227: --
1228: ben_rt_prfl_cache.get_rt_prfl_cache
1229: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
1230: ,p_effective_date => p_effective_date
1231: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
1232: ,p_business_group_id => p_business_group_id
1527: and pil.business_group_id(+)=bep.business_group_id
1528: and (pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT') -- found row condition
1529: or pil.per_in_ler_stat_cd is null); -- outer join condition
1530:
1531: l_inst_set ben_rt_prfl_cache.g_hrswkd_inst_tbl;
1532: l_inst_count number;
1533: l_rows_found boolean := false;
1534: l_mx_hrs_num number ;
1535:
1563:
1564: --
1565: -- Get the rate profile data from the cache.
1566: --
1567: ben_rt_prfl_cache.get_rt_prfl_cache
1568: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
1569: ,p_effective_date => p_effective_date
1570: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
1571: ,p_business_group_id => p_business_group_id
1647: ,p_effective_date in date
1648: ,p_lf_evt_ocrd_dt in date
1649: ,p_labour_union_member_flag in varchar2) is
1650: --
1651: l_inst_set ben_rt_prfl_cache.g_lbrmmbr_inst_tbl;
1652: l_inst_count number;
1653: l_ok boolean := false;
1654: l_rows_found boolean := false;
1655: --
1656: begin
1657: --
1658: -- Get the data from the cache.
1659: --
1660: ben_rt_prfl_cache.get_rt_prfl_cache
1661: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
1662: ,p_effective_date => p_effective_date
1663: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
1664: ,p_business_group_id => p_business_group_id
1725: ,p_effective_date in date
1726: ,p_lf_evt_ocrd_dt in date
1727: ,p_gre_id in varchar2) is
1728: --
1729: l_inst_set ben_rt_prfl_cache.g_lglenty_inst_tbl;
1730: l_inst_count number;
1731: l_ok boolean := false;
1732: l_rows_found boolean := false;
1733: --
1734: begin
1735: --
1736: -- Get the data from the cache.
1737: --
1738: ben_rt_prfl_cache.get_rt_prfl_cache
1739: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
1740: ,p_effective_date => p_effective_date
1741: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
1742: ,p_business_group_id => p_business_group_id
1802: ,p_business_group_id in number
1803: ,p_effective_date in date
1804: ,p_lf_evt_ocrd_dt in date) is
1805: --
1806: l_inst_set ben_rt_prfl_cache.g_loa_inst_tbl;
1807: l_inst_count number;
1808: l_ok boolean := false;
1809: l_rows_found boolean := false;
1810: l_effective_date date;
1828: begin
1829: --
1830: -- Get the data from the cache.
1831: --
1832: ben_rt_prfl_cache.get_rt_prfl_cache
1833: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
1834: ,p_effective_date => p_effective_date
1835: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
1836: ,p_business_group_id => p_business_group_id
1920: ,p_effective_date in date
1921: ,p_lf_evt_ocrd_dt in date
1922: ,p_org_id in number) is
1923: --
1924: l_inst_set ben_rt_prfl_cache.g_org_inst_tbl;
1925: l_inst_count number;
1926: l_ok boolean := false;
1927: l_rows_found boolean := false;
1928: --
1929: begin
1930: --
1931: -- Get the data from the cache.
1932: --
1933: ben_rt_prfl_cache.get_rt_prfl_cache
1934: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
1935: ,p_effective_date => p_effective_date
1936: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
1937: ,p_business_group_id => p_business_group_id
1999: ,p_lf_evt_ocrd_dt in date
2000: ,p_person_type in ben_person_object.
2001: g_cache_typ_table) is
2002: --
2003: l_inst_set ben_rt_prfl_cache.g_pertyp_inst_tbl;
2004: l_inst_count number;
2005: l_ok boolean := false;
2006: l_rows_found boolean := false;
2007: --
2010: -- Get the data from the cache.
2011: --
2012: hr_utility.set_location('p_vrbl_rt_prfl_id -> '||p_vrbl_rt_prfl_id,11);
2013:
2014: ben_rt_prfl_cache.get_rt_prfl_cache
2015: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
2016: ,p_effective_date => p_effective_date
2017: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
2018: ,p_business_group_id => p_business_group_id
2217: ,p_effective_date in date
2218: ,p_lf_evt_ocrd_dt in date
2219: ,p_payroll_id in number) is
2220: --
2221: l_inst_set ben_rt_prfl_cache.g_pyrl_inst_tbl;
2222: l_inst_count number;
2223: l_ok boolean := false;
2224: l_rows_found boolean := false;
2225: --
2226: begin
2227: --
2228: -- Get the data from the cache.
2229: --
2230: ben_rt_prfl_cache.get_rt_prfl_cache
2231: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
2232: ,p_effective_date => p_effective_date
2233: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
2234: ,p_business_group_id => p_business_group_id
2295: ,p_effective_date in date
2296: ,p_lf_evt_ocrd_dt in date
2297: ,p_pay_basis_id in number) is
2298: --
2299: l_inst_set ben_rt_prfl_cache.g_py_bss_inst_tbl;
2300: l_inst_count number;
2301: l_ok boolean := false;
2302: l_rows_found boolean := false;
2303: --
2304: begin
2305: --
2306: -- Get the data from the cache.
2307: --
2308: ben_rt_prfl_cache.get_rt_prfl_cache
2309: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
2310: ,p_effective_date => p_effective_date
2311: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
2312: ,p_business_group_id => p_business_group_id
2385: ,p_ler_id in number
2386: ,p_jurisdiction_code in varchar2
2387: ) is
2388: --
2389: l_inst_set ben_rt_prfl_cache.g_scdhrs_inst_tbl;
2390: l_inst_count number;
2391: l_ok boolean := false;
2392: l_rows_found boolean := false;
2393:
2427: begin
2428: --
2429: -- Get the data from the cache.
2430: --
2431: ben_rt_prfl_cache.get_rt_prfl_cache
2432: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
2433: ,p_effective_date => p_effective_date
2434: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
2435: ,p_business_group_id => p_business_group_id
2663: ,p_effective_date in date
2664: ,p_lf_evt_ocrd_dt in date
2665: ,p_location_id in number) is
2666: --
2667: l_inst_set ben_rt_prfl_cache.g_wkloc_inst_tbl;
2668: l_inst_count number;
2669: l_ok boolean := false;
2670: l_rows_found boolean := false;
2671: --
2670: l_rows_found boolean := false;
2671: --
2672: begin
2673: --
2674: ben_rt_prfl_cache.get_rt_prfl_cache
2675: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
2676: ,p_effective_date => p_effective_date
2677: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
2678: ,p_business_group_id => p_business_group_id
2856: ,p_effective_date in date
2857: ,p_lf_evt_ocrd_dt in date
2858: ,p_hrly_slry in varchar2) is
2859: --
2860: l_inst_set ben_rt_prfl_cache.g_hrlyslrd_inst_tbl;
2861: l_inst_count number;
2862: l_ok boolean := false;
2863: l_rows_found boolean := false;
2864: --
2865: begin
2866: --
2867: -- Get the data from the cache.
2868: --
2869: ben_rt_prfl_cache.get_rt_prfl_cache
2870: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
2871: ,p_effective_date => p_effective_date
2872: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
2873: ,p_business_group_id => p_business_group_id
2966: select epe.pl_id, epe.pgm_id, epe.oipl_id, epe.per_in_ler_id
2967: from ben_elig_per_elctbl_chc epe
2968: where epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id;
2969: --
2970: l_inst_set ben_rt_prfl_cache.g_age_inst_tbl;
2971: l_inst_count number;
2972: l_ok boolean := false;
2973: l_rows_found boolean := false;
2974: --RCHASE
3007: end if;
3008: --
3009: -- Get the data from the cache.
3010: --
3011: ben_rt_prfl_cache.get_rt_prfl_cache
3012: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
3013: ,p_effective_date => p_effective_date
3014: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
3015: ,p_business_group_id => p_business_group_id
3202: from ben_elig_per_elctbl_chc epe
3203: where epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id;
3204: --
3205: l_proc varchar2(80) := g_package||'.check_comp_level';
3206: l_inst_set ben_rt_prfl_cache.g_complvl_inst_tbl;
3207: l_inst_count number;
3208: l_ok boolean := false;
3209: l_rows_found boolean := false;
3210: --
3238: end if;
3239: --
3240: -- Get the data from the cache.
3241: --
3242: ben_rt_prfl_cache.get_rt_prfl_cache
3243: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
3244: ,p_effective_date => p_effective_date
3245: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
3246: ,p_business_group_id => p_business_group_id
3396: select epe.pl_id, epe.pgm_id, epe.oipl_id, epe.per_in_ler_id
3397: from ben_elig_per_elctbl_chc epe
3398: where epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id;
3399: --
3400: l_inst_set ben_rt_prfl_cache.g_los_inst_tbl;
3401: l_inst_count number;
3402: l_ok boolean := false;
3403: l_mx_los_num number ;
3404: --
3442: -- Get the data from the cache.
3443: --
3444: hr_utility.set_location('p_vrbl_rt_prfl_id rate level '||p_vrbl_rt_prfl_id,10);
3445: --
3446: ben_rt_prfl_cache.get_rt_prfl_cache
3447: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
3448: ,p_effective_date => p_effective_date
3449: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
3450: ,p_business_group_id => p_business_group_id
3616: select epe.pl_id, epe.pgm_id, epe.oipl_id, epe.per_in_ler_id
3617: from ben_elig_per_elctbl_chc epe
3618: where epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id;
3619: --
3620: l_inst_set ben_rt_prfl_cache.g_age_los_inst_tbl;
3621: l_inst_count number;
3622: l_ok boolean := false;
3623: l_rows_found boolean := false;
3624: --
3658: end if;
3659: --
3660: -- Get the data from the cache.
3661: --
3662: ben_rt_prfl_cache.get_rt_prfl_cache
3663: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
3664: ,p_effective_date => p_effective_date
3665: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
3666: ,p_business_group_id => p_business_group_id
3787: ,p_pgm_id in number default null
3788: ,p_pl_typ_id in number default null
3789: ,p_ler_id in number default null) is
3790: --
3791: l_inst_set ben_rt_prfl_cache.g_poe_inst_tbl;
3792: l_init_lf_evt_ocrd_dt date;
3793: l_inst_count number;
3794: l_strt_dt date;
3795: l_end_dt date;
3880: begin
3881: --
3882: -- Get the data from the cache.
3883: --
3884: ben_rt_prfl_cache.get_rt_prfl_cache
3885: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
3886: ,p_effective_date => p_effective_date
3887: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
3888: ,p_business_group_id => p_business_group_id
4101: ,p_ttl_prtt in number default null)
4102: is
4103: --
4104: l_proc varchar2(80) := g_package||'.check_ttl_prtt';
4105: l_inst_set ben_rt_prfl_cache.g_ttl_prtt_inst_tbl;
4106: l_inst_count number;
4107: l_profile_match varchar2(1);
4108: --
4109: begin
4111:
4112: --
4113: -- Get the data from the cache.
4114: --
4115: ben_rt_prfl_cache.get_rt_prfl_cache
4116: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
4117: ,p_effective_date => p_effective_date
4118: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
4119: ,p_business_group_id => p_business_group_id
4165: p_lf_evt_ocrd_dt in date,
4166: p_job_id in number) is
4167: --
4168: l_proc varchar2(100) := g_package||'check_job';
4169: l_inst_set ben_rt_prfl_cache.g_job_inst_tbl;
4170: l_inst_count number;
4171: l_ok boolean := false;
4172: l_rows_found boolean := false;
4173: --
4176: hr_utility.set_location('Entering : '||l_proc,10);
4177: --
4178: -- Get the data from the cache.
4179: --
4180: ben_rt_prfl_cache.get_rt_prfl_cache
4181: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
4182: ,p_effective_date => p_effective_date
4183: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
4184: ,p_business_group_id => p_business_group_id
4244: p_lf_evt_ocrd_dt in date,
4245: p_person_id in number) is
4246: --
4247: l_proc varchar2(100) := g_package||'check_optd_for_medicare';
4248: l_inst_set ben_rt_prfl_cache.g_optd_mdcr_inst_tbl;
4249: l_inst_count number;
4250: l_ok boolean := false;
4251: l_rows_found boolean := false;
4252: l_rec per_all_people_f%rowtype;
4256: hr_utility.set_location('Entering : '||l_proc,10);
4257: --
4258: -- Get the data from the cache.
4259: --
4260: ben_rt_prfl_cache.get_rt_prfl_cache
4261: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
4262: ,p_effective_date => p_effective_date
4263: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
4264: ,p_business_group_id => p_business_group_id
4298: p_lf_evt_ocrd_dt in date,
4299: p_person_id in number) is
4300: --
4301: l_proc varchar2(100) := g_package||'check_lvg_rsn';
4302: l_inst_set ben_rt_prfl_cache.g_lvg_rsn_inst_tbl;
4303: l_inst_count number;
4304: l_ok boolean := false;
4305: l_rows_found boolean := false;
4306: l_rec per_periods_of_service%rowtype;
4310: hr_utility.set_location('Entering : '||l_proc,10);
4311: --
4312: -- Get the data from the cache.
4313: --
4314: ben_rt_prfl_cache.get_rt_prfl_cache
4315: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
4316: ,p_effective_date => p_effective_date
4317: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
4318: ,p_business_group_id => p_business_group_id
4369: p_person_id in number,
4370: p_lf_evt_ocrd_dt in date) is
4371: --
4372: l_proc varchar2(100) := g_package||'check_cbr_quald_bnf';
4373: l_inst_set ben_rt_prfl_cache.g_cbr_qual_bnf_inst_tbl;
4374: l_inst_count number;
4375: l_ok boolean := false;
4376: l_rows_found boolean := false;
4377: l_rec per_all_people_f%rowtype;
4403: hr_utility.set_location('Entering : '||l_proc,10);
4404: --
4405: -- Get the data from the cache.
4406: --
4407: ben_rt_prfl_cache.get_rt_prfl_cache
4408: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
4409: ,p_effective_date => p_effective_date
4410: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
4411: ,p_business_group_id => p_business_group_id
4460: p_person_id in number ,
4461: p_lf_evt_ocrd_dt in date) is
4462: --
4463: l_proc varchar2(100) := g_package||'check_dpnt_cvrd_othr_pl';
4464: l_inst_set ben_rt_prfl_cache.g_dpnt_cvrd_othr_pl_inst_tbl;
4465: l_inst_count number;
4466: l_ok boolean := false;
4467: l_rows_found boolean := false;
4468:
4494: hr_utility.set_location('Entering : '||l_proc,10);
4495: --
4496: -- Get the data from the cache.
4497: --
4498: ben_rt_prfl_cache.get_rt_prfl_cache
4499: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
4500: ,p_effective_date => p_effective_date
4501: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
4502: ,p_business_group_id => p_business_group_id
4567: p_person_id in number ,
4568: p_lf_evt_ocrd_dt in date) is
4569: --
4570: l_proc varchar2(100) := g_package||'check_dpnt_cvrd_othr_plip';
4571: l_inst_set ben_rt_prfl_cache.g_dpnt_cvrd_othr_plip_inst_tbl;
4572: l_inst_count number;
4573: l_ok boolean := false;
4574: l_rows_found boolean := false;
4575:
4608: hr_utility.set_location('Entering : '||l_proc,10);
4609: --
4610: -- Get the data from the cache.
4611: --
4612: ben_rt_prfl_cache.get_rt_prfl_cache
4613: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
4614: ,p_effective_date => p_effective_date
4615: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
4616: ,p_business_group_id => p_business_group_id
4681: p_person_id in number,
4682: p_lf_evt_ocrd_dt in date) is
4683: --
4684: l_proc varchar2(100) := g_package||'check_dpnt_cvrd_othr_ptip';
4685: l_inst_set ben_rt_prfl_cache.g_dpnt_cvrd_othr_ptip_inst_tbl;
4686: l_inst_count number;
4687: l_ok boolean := false;
4688: l_rows_found boolean := false;
4689:
4734: hr_utility.set_location('Entering : '||l_proc,10);
4735: --
4736: -- Get the data from the cache.
4737: --
4738: ben_rt_prfl_cache.get_rt_prfl_cache
4739: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
4740: ,p_effective_date => p_effective_date
4741: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
4742: ,p_business_group_id => p_business_group_id
4822: p_person_id in number,
4823: p_lf_evt_ocrd_dt in date) is
4824: --
4825: l_proc varchar2(100) := g_package||'check_dpnt_cvrd_othr_pgm';
4826: l_inst_set ben_rt_prfl_cache.g_dpnt_cvrd_othr_pgm_inst_tbl;
4827: l_inst_count number;
4828: l_ok boolean := false;
4829: l_rows_found boolean := false;
4830:
4857: hr_utility.set_location('Entering : '||l_proc,10);
4858: --
4859: -- Get the data from the cache.
4860: --
4861: ben_rt_prfl_cache.get_rt_prfl_cache
4862: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
4863: ,p_effective_date => p_effective_date
4864: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
4865: ,p_business_group_id => p_business_group_id
4932: p_effective_date in date,
4933: p_lf_evt_ocrd_dt in date) is
4934: --
4935: l_proc varchar2(100) := g_package||'check_prtt_anthr_pl';
4936: l_inst_set ben_rt_prfl_cache.g_prtt_anthr_pl_inst_tbl;
4937: l_inst_count number;
4938: l_ok boolean := false;
4939: l_rows_found boolean := false;
4940:
4962: hr_utility.set_location('Entering : '||l_proc,10);
4963: --
4964: -- Get the data from the cache.
4965: --
4966: ben_rt_prfl_cache.get_rt_prfl_cache
4967: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
4968: ,p_effective_date => p_effective_date
4969: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
4970: ,p_business_group_id => p_business_group_id
5029: is
5030: --
5031: l_proc varchar2(100):='check_othr_ptip';
5032: --
5033: l_inst_set ben_rt_prfl_cache.g_othr_ptip_inst_tbl;
5034: l_inst_count number;
5035: i binary_integer;
5036: l_ok boolean := false;
5037: l_rows_found boolean := false;
5149: hr_utility.set_location('Entering: '||l_proc, 10);
5150: --
5151: -- Getting variable profile compensation level by variable profile
5152: --
5153: ben_rt_prfl_cache.get_rt_prfl_cache
5154: (p_effective_date => nvl(p_lf_evt_ocrd_dt,p_effective_date),
5155: p_business_group_id => p_business_group_id,
5156: p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id,
5157: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
5276: p_effective_date in date,
5277: p_lf_evt_ocrd_dt in date) is
5278: --
5279: l_proc varchar2(100):=g_package||'check_enrld_anthr_pl';
5280: l_inst_set ben_rt_prfl_cache.g_enrld_anthr_pl_inst_tbl;
5281: l_inst_count number;
5282: i binary_integer;
5283: l_ok boolean := false;
5284: l_rows_found boolean := false;
5290: --
5291: hr_utility.set_location('Entering: '||l_proc, 10);
5292:
5293: --
5294: ben_rt_prfl_cache.get_rt_prfl_cache
5295: (p_effective_date => nvl(p_lf_evt_ocrd_dt,p_effective_date),
5296: p_business_group_id => p_business_group_id,
5297: p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id,
5298: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
5388: p_effective_date in date,
5389: p_lf_evt_ocrd_dt in date) is
5390: --
5391: l_proc varchar2(100):=g_package||'check_enrld_anthr_oipl';
5392: l_inst_set ben_rt_prfl_cache.g_enrld_anthr_oipl_inst_tbl;
5393: l_inst_count number;
5394: i binary_integer;
5395: l_ok boolean := false;
5396: l_rows_found boolean := false;
5415: hr_utility.set_location('Entering: '||l_proc, 10);
5416: --
5417: -- Getting variable rate profile compensation level by variable profile
5418: --
5419: ben_rt_prfl_cache.get_rt_prfl_cache
5420: (p_effective_date => nvl(p_lf_evt_ocrd_dt,p_effective_date),
5421: p_business_group_id => p_business_group_id,
5422: p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id,
5423: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
5516: p_lf_evt_ocrd_dt in date) is
5517: --
5518: l_proc varchar2(100):=g_package||'check_enrld_anthr_ptip';
5519: --
5520: l_inst_set ben_rt_prfl_cache.g_enrld_anthr_ptip_inst_tbl;
5521: l_inst_count number;
5522: i binary_integer;
5523: l_ok boolean := false;
5524: l_rows_found boolean := false;
5556: hr_utility.set_location('Entering: '||l_proc, 10);
5557: --
5558: -- Getting variable rate profile compensation level
5559: --
5560: ben_rt_prfl_cache.get_rt_prfl_cache
5561: (p_effective_date => nvl(p_lf_evt_ocrd_dt,p_effective_date),
5562: p_business_group_id => p_business_group_id,
5563: p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id,
5564: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
5696: p_effective_date in date,
5697: p_lf_evt_ocrd_dt in date) is
5698: --
5699: l_proc varchar2(100):=g_package||'check_enrld_anthr_plip';
5700: l_inst_set ben_rt_prfl_cache.g_enrld_anthr_plip_inst_tbl;
5701: l_inst_count number;
5702: i binary_integer;
5703: l_ok boolean := false;
5704: l_rows_found boolean := false;
5729: hr_utility.set_location('Entering: '||l_proc, 10);
5730: --
5731: -- Getting variable profile compensation level by variable profile
5732: --
5733: ben_rt_prfl_cache.get_rt_prfl_cache
5734: (p_effective_date => nvl(p_lf_evt_ocrd_dt,p_effective_date),
5735: p_business_group_id => p_business_group_id,
5736: p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id,
5737: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
5818: ,p_lf_evt_ocrd_dt in date )
5819: is
5820: --
5821: l_proc varchar2(100):=g_package||'check_enrld_anthr_pgm';
5822: l_inst_set ben_rt_prfl_cache.g_enrld_anthr_pgm_inst_tbl;
5823: l_inst_count number;
5824: i binary_integer;
5825: l_ok boolean := false;
5826: l_rows_found boolean := false;
5834: hr_utility.set_location('prfl_id: '||p_vrbl_rt_prfl_id, 10);
5835: --
5836: -- Getting variable profile compensation level
5837: --
5838: ben_rt_prfl_cache.get_rt_prfl_cache
5839: (p_effective_date => nvl(p_lf_evt_ocrd_dt,p_effective_date),
5840: p_business_group_id => p_business_group_id,
5841: p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id,
5842: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
5940: is
5941: --
5942: l_proc varchar2(100):=g_package||'check_dpnt_other_ptip';
5943: --
5944: l_inst_set ben_rt_prfl_cache.g_dpnt_othr_ptip_inst_tbl;
5945: l_inst_count number;
5946: i binary_integer;
5947: l_ok boolean := false;
5948: l_rows_found boolean := false;
6008: hr_utility.set_location('Entering: '||l_proc, 10);
6009: --
6010: -- Getting variable profile compensation level by variable profile
6011: --
6012: ben_rt_prfl_cache.get_rt_prfl_cache
6013: (p_effective_date => nvl(p_lf_evt_ocrd_dt,p_effective_date),
6014: p_business_group_id => p_business_group_id,
6015: p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id,
6016: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
6103: p_effective_date in date,
6104: p_lf_evt_ocrd_dt in date) is
6105: --
6106: l_proc varchar2(100) := g_package||'check_no_othr_cvg';
6107: l_inst_set ben_rt_prfl_cache.g_no_othr_cvg_inst_tbl;
6108: l_inst_count number;
6109: l_ok boolean := false;
6110: l_rows_found boolean := false;
6111: l_dummy varchar2(1);
6118: hr_utility.set_location('Entering : '||l_proc,10);
6119: --
6120: -- Get the data from the cache.
6121: --
6122: ben_rt_prfl_cache.get_rt_prfl_cache
6123: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
6124: ,p_effective_date => p_effective_date
6125: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
6126: ,p_business_group_id => p_business_group_id
6160: p_effective_date in date,
6161: p_lf_evt_ocrd_dt in date) is
6162: --
6163: l_proc varchar2(100) := g_package||'check_pstn';
6164: l_inst_set ben_rt_prfl_cache.g_pstn_inst_tbl;
6165: l_inst_count number;
6166: l_ok boolean := false;
6167: l_rows_found boolean := false;
6168: l_dummy varchar2(1);
6175: hr_utility.set_location('Entering : '||l_proc,10);
6176: --
6177: -- Get the data from the cache.
6178: --
6179: ben_rt_prfl_cache.get_rt_prfl_cache
6180: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
6181: ,p_effective_date => p_effective_date
6182: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
6183: ,p_business_group_id => p_business_group_id
6233: p_effective_date date,
6234: p_lf_evt_ocrd_dt date) is
6235: --
6236: l_proc varchar2(100) := g_package||'check_comptncy';
6237: l_inst_set ben_rt_prfl_cache.g_comptncy_inst_tbl;
6238: l_inst_count number;
6239: l_ok boolean := false;
6240: l_rows_found boolean := false;
6241: l_dummy varchar2(1);
6260: hr_utility.set_location('Entering : '||l_proc,10);
6261: --
6262: -- Get the data from the cache.
6263: --
6264: ben_rt_prfl_cache.get_rt_prfl_cache
6265: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
6266: ,p_effective_date => p_effective_date
6267: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
6268: ,p_business_group_id => p_business_group_id
6328: p_effective_date date,
6329: p_lf_evt_ocrd_dt date) is
6330: --
6331: l_proc varchar2(100) := g_package||'check_qual_titl';
6332: l_inst_set ben_rt_prfl_cache.g_qual_titl_inst_tbl;
6333: l_inst_count number;
6334: l_ok boolean := false;
6335: l_rows_found boolean := false;
6336: l_dummy varchar2(1);
6354: hr_utility.set_location('Entering : '||l_proc,10);
6355: --
6356: -- Get the data from the cache.
6357: --
6358: ben_rt_prfl_cache.get_rt_prfl_cache
6359: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
6360: ,p_effective_date => p_effective_date
6361: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
6362: ,p_business_group_id => p_business_group_id
6425: ,p_ttl_cvg in number default null)
6426: is
6427: --
6428: l_proc varchar2(80) := g_package||'.check_ttl_cvg';
6429: l_inst_set ben_rt_prfl_cache.g_ttl_cvg_inst_tbl;
6430: l_inst_count number;
6431: l_profile_match varchar2(1);
6432: --
6433: begin
6435:
6436: --
6437: -- Get the data from the cache.
6438: --
6439: ben_rt_prfl_cache.get_rt_prfl_cache
6440: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
6441: ,p_effective_date => p_effective_date
6442: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
6443: ,p_business_group_id => p_business_group_id
6491: p_lf_evt_ocrd_dt date,
6492: p_pay_basis_id in number) is
6493: --
6494: l_proc varchar2(100) := g_package||'check_qua_in_gr';
6495: l_inst_set ben_rt_prfl_cache.g_qua_in_gr_inst_tbl;
6496: l_inst_count number;
6497: l_ok boolean := false;
6498: l_rows_found boolean := false;
6499: l_max_val number;
6591: hr_utility.set_location('Entering : '||l_proc,10);
6592: --
6593: -- Get the data from the cache.
6594: --
6595: ben_rt_prfl_cache.get_rt_prfl_cache
6596: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
6597: ,p_effective_date => p_effective_date
6598: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
6599: ,p_business_group_id => p_business_group_id
6714: p_effective_date date,
6715: p_lf_evt_ocrd_dt date) is
6716: --
6717: l_proc varchar2(100) := g_package||'check_perf_rtng';
6718: l_inst_set ben_rt_prfl_cache.g_perf_rtng_inst_tbl;
6719: l_inst_count number;
6720: l_ok boolean := false;
6721: l_rows_found boolean := false;
6722: l_dummy varchar2(1);
6766: hr_utility.set_location('Entering : '||l_proc,10);
6767: --
6768: -- Get the data from the cache.
6769: --
6770: ben_rt_prfl_cache.get_rt_prfl_cache
6771: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
6772: ,p_effective_date => p_effective_date
6773: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
6774: ,p_business_group_id => p_business_group_id