[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
3204: from ben_elig_per_elctbl_chc epe
3205: where epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id;
3206: --
3207: l_proc varchar2(80) := g_package||'.check_comp_level';
3208: l_inst_set ben_rt_prfl_cache.g_complvl_inst_tbl;
3209: l_inst_count number;
3210: l_ok boolean := false;
3211: l_rows_found boolean := false;
3212: --
3240: end if;
3241: --
3242: -- Get the data from the cache.
3243: --
3244: ben_rt_prfl_cache.get_rt_prfl_cache
3245: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
3246: ,p_effective_date => p_effective_date
3247: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
3248: ,p_business_group_id => p_business_group_id
3398: select epe.pl_id, epe.pgm_id, epe.oipl_id, epe.per_in_ler_id
3399: from ben_elig_per_elctbl_chc epe
3400: where epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id;
3401: --
3402: l_inst_set ben_rt_prfl_cache.g_los_inst_tbl;
3403: l_inst_count number;
3404: l_ok boolean := false;
3405: l_mx_los_num number ;
3406: --
3444: -- Get the data from the cache.
3445: --
3446: hr_utility.set_location('p_vrbl_rt_prfl_id rate level '||p_vrbl_rt_prfl_id,10);
3447: --
3448: ben_rt_prfl_cache.get_rt_prfl_cache
3449: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
3450: ,p_effective_date => p_effective_date
3451: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
3452: ,p_business_group_id => p_business_group_id
3620: select epe.pl_id, epe.pgm_id, epe.oipl_id, epe.per_in_ler_id
3621: from ben_elig_per_elctbl_chc epe
3622: where epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id;
3623: --
3624: l_inst_set ben_rt_prfl_cache.g_age_los_inst_tbl;
3625: l_inst_count number;
3626: l_ok boolean := false;
3627: l_rows_found boolean := false;
3628: --
3662: end if;
3663: --
3664: -- Get the data from the cache.
3665: --
3666: ben_rt_prfl_cache.get_rt_prfl_cache
3667: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
3668: ,p_effective_date => p_effective_date
3669: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
3670: ,p_business_group_id => p_business_group_id
3793: ,p_pgm_id in number default null
3794: ,p_pl_typ_id in number default null
3795: ,p_ler_id in number default null) is
3796: --
3797: l_inst_set ben_rt_prfl_cache.g_poe_inst_tbl;
3798: l_init_lf_evt_ocrd_dt date;
3799: l_inst_count number;
3800: l_strt_dt date;
3801: l_end_dt date;
3906: begin
3907: --
3908: -- Get the data from the cache.
3909: --
3910: ben_rt_prfl_cache.get_rt_prfl_cache
3911: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
3912: ,p_effective_date => p_effective_date
3913: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
3914: ,p_business_group_id => p_business_group_id
4154: ,p_ttl_prtt in number default null)
4155: is
4156: --
4157: l_proc varchar2(80) := g_package||'.check_ttl_prtt';
4158: l_inst_set ben_rt_prfl_cache.g_ttl_prtt_inst_tbl;
4159: l_inst_count number;
4160: l_profile_match varchar2(1);
4161: --
4162: begin
4164:
4165: --
4166: -- Get the data from the cache.
4167: --
4168: ben_rt_prfl_cache.get_rt_prfl_cache
4169: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
4170: ,p_effective_date => p_effective_date
4171: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
4172: ,p_business_group_id => p_business_group_id
4218: p_lf_evt_ocrd_dt in date,
4219: p_job_id in number) is
4220: --
4221: l_proc varchar2(100) := g_package||'check_job';
4222: l_inst_set ben_rt_prfl_cache.g_job_inst_tbl;
4223: l_inst_count number;
4224: l_ok boolean := false;
4225: l_rows_found boolean := false;
4226: --
4229: hr_utility.set_location('Entering : '||l_proc,10);
4230: --
4231: -- Get the data from the cache.
4232: --
4233: ben_rt_prfl_cache.get_rt_prfl_cache
4234: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
4235: ,p_effective_date => p_effective_date
4236: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
4237: ,p_business_group_id => p_business_group_id
4297: p_lf_evt_ocrd_dt in date,
4298: p_person_id in number) is
4299: --
4300: l_proc varchar2(100) := g_package||'check_optd_for_medicare';
4301: l_inst_set ben_rt_prfl_cache.g_optd_mdcr_inst_tbl;
4302: l_inst_count number;
4303: l_ok boolean := false;
4304: l_rows_found boolean := false;
4305: l_rec per_all_people_f%rowtype;
4309: hr_utility.set_location('Entering : '||l_proc,10);
4310: --
4311: -- Get the data from the cache.
4312: --
4313: ben_rt_prfl_cache.get_rt_prfl_cache
4314: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
4315: ,p_effective_date => p_effective_date
4316: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
4317: ,p_business_group_id => p_business_group_id
4351: p_lf_evt_ocrd_dt in date,
4352: p_person_id in number) is
4353: --
4354: l_proc varchar2(100) := g_package||'check_lvg_rsn';
4355: l_inst_set ben_rt_prfl_cache.g_lvg_rsn_inst_tbl;
4356: l_inst_count number;
4357: l_ok boolean := false;
4358: l_rows_found boolean := false;
4359: l_rec per_periods_of_service%rowtype;
4363: hr_utility.set_location('Entering : '||l_proc,10);
4364: --
4365: -- Get the data from the cache.
4366: --
4367: ben_rt_prfl_cache.get_rt_prfl_cache
4368: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
4369: ,p_effective_date => p_effective_date
4370: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
4371: ,p_business_group_id => p_business_group_id
4422: p_person_id in number,
4423: p_lf_evt_ocrd_dt in date) is
4424: --
4425: l_proc varchar2(100) := g_package||'check_cbr_quald_bnf';
4426: l_inst_set ben_rt_prfl_cache.g_cbr_qual_bnf_inst_tbl;
4427: l_inst_count number;
4428: l_ok boolean := false;
4429: l_rows_found boolean := false;
4430: l_rec per_all_people_f%rowtype;
4456: hr_utility.set_location('Entering : '||l_proc,10);
4457: --
4458: -- Get the data from the cache.
4459: --
4460: ben_rt_prfl_cache.get_rt_prfl_cache
4461: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
4462: ,p_effective_date => p_effective_date
4463: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
4464: ,p_business_group_id => p_business_group_id
4513: p_person_id in number ,
4514: p_lf_evt_ocrd_dt in date) is
4515: --
4516: l_proc varchar2(100) := g_package||'check_dpnt_cvrd_othr_pl';
4517: l_inst_set ben_rt_prfl_cache.g_dpnt_cvrd_othr_pl_inst_tbl;
4518: l_inst_count number;
4519: l_ok boolean := false;
4520: l_rows_found boolean := false;
4521:
4547: hr_utility.set_location('Entering : '||l_proc,10);
4548: --
4549: -- Get the data from the cache.
4550: --
4551: ben_rt_prfl_cache.get_rt_prfl_cache
4552: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
4553: ,p_effective_date => p_effective_date
4554: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
4555: ,p_business_group_id => p_business_group_id
4620: p_person_id in number ,
4621: p_lf_evt_ocrd_dt in date) is
4622: --
4623: l_proc varchar2(100) := g_package||'check_dpnt_cvrd_othr_plip';
4624: l_inst_set ben_rt_prfl_cache.g_dpnt_cvrd_othr_plip_inst_tbl;
4625: l_inst_count number;
4626: l_ok boolean := false;
4627: l_rows_found boolean := false;
4628:
4661: hr_utility.set_location('Entering : '||l_proc,10);
4662: --
4663: -- Get the data from the cache.
4664: --
4665: ben_rt_prfl_cache.get_rt_prfl_cache
4666: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
4667: ,p_effective_date => p_effective_date
4668: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
4669: ,p_business_group_id => p_business_group_id
4734: p_person_id in number,
4735: p_lf_evt_ocrd_dt in date) is
4736: --
4737: l_proc varchar2(100) := g_package||'check_dpnt_cvrd_othr_ptip';
4738: l_inst_set ben_rt_prfl_cache.g_dpnt_cvrd_othr_ptip_inst_tbl;
4739: l_inst_count number;
4740: l_ok boolean := false;
4741: l_rows_found boolean := false;
4742:
4787: hr_utility.set_location('Entering : '||l_proc,10);
4788: --
4789: -- Get the data from the cache.
4790: --
4791: ben_rt_prfl_cache.get_rt_prfl_cache
4792: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
4793: ,p_effective_date => p_effective_date
4794: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
4795: ,p_business_group_id => p_business_group_id
4875: p_person_id in number,
4876: p_lf_evt_ocrd_dt in date) is
4877: --
4878: l_proc varchar2(100) := g_package||'check_dpnt_cvrd_othr_pgm';
4879: l_inst_set ben_rt_prfl_cache.g_dpnt_cvrd_othr_pgm_inst_tbl;
4880: l_inst_count number;
4881: l_ok boolean := false;
4882: l_rows_found boolean := false;
4883:
4910: hr_utility.set_location('Entering : '||l_proc,10);
4911: --
4912: -- Get the data from the cache.
4913: --
4914: ben_rt_prfl_cache.get_rt_prfl_cache
4915: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
4916: ,p_effective_date => p_effective_date
4917: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
4918: ,p_business_group_id => p_business_group_id
4985: p_effective_date in date,
4986: p_lf_evt_ocrd_dt in date) is
4987: --
4988: l_proc varchar2(100) := g_package||'check_prtt_anthr_pl';
4989: l_inst_set ben_rt_prfl_cache.g_prtt_anthr_pl_inst_tbl;
4990: l_inst_count number;
4991: l_ok boolean := false;
4992: l_rows_found boolean := false;
4993:
5019: hr_utility.set_location('Entering : '||l_proc,10);
5020: --
5021: -- Get the data from the cache.
5022: --
5023: ben_rt_prfl_cache.get_rt_prfl_cache
5024: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
5025: ,p_effective_date => p_effective_date
5026: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
5027: ,p_business_group_id => p_business_group_id
5086: is
5087: --
5088: l_proc varchar2(100):='check_othr_ptip';
5089: --
5090: l_inst_set ben_rt_prfl_cache.g_othr_ptip_inst_tbl;
5091: l_inst_count number;
5092: i binary_integer;
5093: l_ok boolean := false;
5094: l_rows_found boolean := false;
5206: hr_utility.set_location('Entering: '||l_proc, 10);
5207: --
5208: -- Getting variable profile compensation level by variable profile
5209: --
5210: ben_rt_prfl_cache.get_rt_prfl_cache
5211: (p_effective_date => nvl(p_lf_evt_ocrd_dt,p_effective_date),
5212: p_business_group_id => p_business_group_id,
5213: p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id,
5214: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
5333: p_effective_date in date,
5334: p_lf_evt_ocrd_dt in date) is
5335: --
5336: l_proc varchar2(100):=g_package||'check_enrld_anthr_pl';
5337: l_inst_set ben_rt_prfl_cache.g_enrld_anthr_pl_inst_tbl;
5338: l_inst_count number;
5339: i binary_integer;
5340: l_ok boolean := false;
5341: l_rows_found boolean := false;
5347: --
5348: hr_utility.set_location('Entering: '||l_proc, 10);
5349:
5350: --
5351: ben_rt_prfl_cache.get_rt_prfl_cache
5352: (p_effective_date => nvl(p_lf_evt_ocrd_dt,p_effective_date),
5353: p_business_group_id => p_business_group_id,
5354: p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id,
5355: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
5445: p_effective_date in date,
5446: p_lf_evt_ocrd_dt in date) is
5447: --
5448: l_proc varchar2(100):=g_package||'check_enrld_anthr_oipl';
5449: l_inst_set ben_rt_prfl_cache.g_enrld_anthr_oipl_inst_tbl;
5450: l_inst_count number;
5451: i binary_integer;
5452: l_ok boolean := false;
5453: l_rows_found boolean := false;
5472: hr_utility.set_location('Entering: '||l_proc, 10);
5473: --
5474: -- Getting variable rate profile compensation level by variable profile
5475: --
5476: ben_rt_prfl_cache.get_rt_prfl_cache
5477: (p_effective_date => nvl(p_lf_evt_ocrd_dt,p_effective_date),
5478: p_business_group_id => p_business_group_id,
5479: p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id,
5480: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
5573: p_lf_evt_ocrd_dt in date) is
5574: --
5575: l_proc varchar2(100):=g_package||'check_enrld_anthr_ptip';
5576: --
5577: l_inst_set ben_rt_prfl_cache.g_enrld_anthr_ptip_inst_tbl;
5578: l_inst_count number;
5579: i binary_integer;
5580: l_ok boolean := false;
5581: l_rows_found boolean := false;
5613: hr_utility.set_location('Entering: '||l_proc, 10);
5614: --
5615: -- Getting variable rate profile compensation level
5616: --
5617: ben_rt_prfl_cache.get_rt_prfl_cache
5618: (p_effective_date => nvl(p_lf_evt_ocrd_dt,p_effective_date),
5619: p_business_group_id => p_business_group_id,
5620: p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id,
5621: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
5753: p_effective_date in date,
5754: p_lf_evt_ocrd_dt in date) is
5755: --
5756: l_proc varchar2(100):=g_package||'check_enrld_anthr_plip';
5757: l_inst_set ben_rt_prfl_cache.g_enrld_anthr_plip_inst_tbl;
5758: l_inst_count number;
5759: i binary_integer;
5760: l_ok boolean := false;
5761: l_rows_found boolean := false;
5786: hr_utility.set_location('Entering: '||l_proc, 10);
5787: --
5788: -- Getting variable profile compensation level by variable profile
5789: --
5790: ben_rt_prfl_cache.get_rt_prfl_cache
5791: (p_effective_date => nvl(p_lf_evt_ocrd_dt,p_effective_date),
5792: p_business_group_id => p_business_group_id,
5793: p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id,
5794: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
5875: ,p_lf_evt_ocrd_dt in date )
5876: is
5877: --
5878: l_proc varchar2(100):=g_package||'check_enrld_anthr_pgm';
5879: l_inst_set ben_rt_prfl_cache.g_enrld_anthr_pgm_inst_tbl;
5880: l_inst_count number;
5881: i binary_integer;
5882: l_ok boolean := false;
5883: l_rows_found boolean := false;
5891: hr_utility.set_location('prfl_id: '||p_vrbl_rt_prfl_id, 10);
5892: --
5893: -- Getting variable profile compensation level
5894: --
5895: ben_rt_prfl_cache.get_rt_prfl_cache
5896: (p_effective_date => nvl(p_lf_evt_ocrd_dt,p_effective_date),
5897: p_business_group_id => p_business_group_id,
5898: p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id,
5899: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
5997: is
5998: --
5999: l_proc varchar2(100):=g_package||'check_dpnt_other_ptip';
6000: --
6001: l_inst_set ben_rt_prfl_cache.g_dpnt_othr_ptip_inst_tbl;
6002: l_inst_count number;
6003: i binary_integer;
6004: l_ok boolean := false;
6005: l_rows_found boolean := false;
6065: hr_utility.set_location('Entering: '||l_proc, 10);
6066: --
6067: -- Getting variable profile compensation level by variable profile
6068: --
6069: ben_rt_prfl_cache.get_rt_prfl_cache
6070: (p_effective_date => nvl(p_lf_evt_ocrd_dt,p_effective_date),
6071: p_business_group_id => p_business_group_id,
6072: p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id,
6073: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
6160: p_effective_date in date,
6161: p_lf_evt_ocrd_dt in date) is
6162: --
6163: l_proc varchar2(100) := g_package||'check_no_othr_cvg';
6164: l_inst_set ben_rt_prfl_cache.g_no_othr_cvg_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
6217: p_effective_date in date,
6218: p_lf_evt_ocrd_dt in date) is
6219: --
6220: l_proc varchar2(100) := g_package||'check_pstn';
6221: l_inst_set ben_rt_prfl_cache.g_pstn_inst_tbl;
6222: l_inst_count number;
6223: l_ok boolean := false;
6224: l_rows_found boolean := false;
6225: l_dummy varchar2(1);
6232: hr_utility.set_location('Entering : '||l_proc,10);
6233: --
6234: -- Get the data from the cache.
6235: --
6236: ben_rt_prfl_cache.get_rt_prfl_cache
6237: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
6238: ,p_effective_date => p_effective_date
6239: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
6240: ,p_business_group_id => p_business_group_id
6290: p_effective_date date,
6291: p_lf_evt_ocrd_dt date) is
6292: --
6293: l_proc varchar2(100) := g_package||'check_comptncy';
6294: l_inst_set ben_rt_prfl_cache.g_comptncy_inst_tbl;
6295: l_inst_count number;
6296: l_ok boolean := false;
6297: l_rows_found boolean := false;
6298: l_dummy varchar2(1);
6317: hr_utility.set_location('Entering : '||l_proc,10);
6318: --
6319: -- Get the data from the cache.
6320: --
6321: ben_rt_prfl_cache.get_rt_prfl_cache
6322: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
6323: ,p_effective_date => p_effective_date
6324: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
6325: ,p_business_group_id => p_business_group_id
6385: p_effective_date date,
6386: p_lf_evt_ocrd_dt date) is
6387: --
6388: l_proc varchar2(100) := g_package||'check_qual_titl';
6389: l_inst_set ben_rt_prfl_cache.g_qual_titl_inst_tbl;
6390: l_inst_count number;
6391: l_ok boolean := false;
6392: l_rows_found boolean := false;
6393: l_dummy varchar2(1);
6411: hr_utility.set_location('Entering : '||l_proc,10);
6412: --
6413: -- Get the data from the cache.
6414: --
6415: ben_rt_prfl_cache.get_rt_prfl_cache
6416: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
6417: ,p_effective_date => p_effective_date
6418: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
6419: ,p_business_group_id => p_business_group_id
6482: ,p_ttl_cvg in number default null)
6483: is
6484: --
6485: l_proc varchar2(80) := g_package||'.check_ttl_cvg';
6486: l_inst_set ben_rt_prfl_cache.g_ttl_cvg_inst_tbl;
6487: l_inst_count number;
6488: l_profile_match varchar2(1);
6489: --
6490: begin
6492:
6493: --
6494: -- Get the data from the cache.
6495: --
6496: ben_rt_prfl_cache.get_rt_prfl_cache
6497: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
6498: ,p_effective_date => p_effective_date
6499: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
6500: ,p_business_group_id => p_business_group_id
6548: p_lf_evt_ocrd_dt date,
6549: p_pay_basis_id in number) is
6550: --
6551: l_proc varchar2(100) := g_package||'check_qua_in_gr';
6552: l_inst_set ben_rt_prfl_cache.g_qua_in_gr_inst_tbl;
6553: l_inst_count number;
6554: l_ok boolean := false;
6555: l_rows_found boolean := false;
6556: l_max_val number;
6648: hr_utility.set_location('Entering : '||l_proc,10);
6649: --
6650: -- Get the data from the cache.
6651: --
6652: ben_rt_prfl_cache.get_rt_prfl_cache
6653: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
6654: ,p_effective_date => p_effective_date
6655: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
6656: ,p_business_group_id => p_business_group_id
6771: p_effective_date date,
6772: p_lf_evt_ocrd_dt date) is
6773: --
6774: l_proc varchar2(100) := g_package||'check_perf_rtng';
6775: l_inst_set ben_rt_prfl_cache.g_perf_rtng_inst_tbl;
6776: l_inst_count number;
6777: l_ok boolean := false;
6778: l_rows_found boolean := false;
6779: l_dummy varchar2(1);
6823: hr_utility.set_location('Entering : '||l_proc,10);
6824: --
6825: -- Get the data from the cache.
6826: --
6827: ben_rt_prfl_cache.get_rt_prfl_cache
6828: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
6829: ,p_effective_date => p_effective_date
6830: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
6831: ,p_business_group_id => p_business_group_id