[Home] [Help]
5: -- ----------------------------------------------------------------------------
6: -- | Private Global Definitions |
7: -- ----------------------------------------------------------------------------
8: --
9: g_debug boolean := hr_utility.debug_enabled;
10: --
11: -----------------------------------------------------------------------------
12: -------------------------< initailize_all_cache_area >-----------------------
13: -----------------------------------------------------------------------------
21: Begin
22: --
23: if g_debug then
24: l_proc := g_package||'initialize_all_cache_area';
25: hr_utility.set_location('Entering:'||l_proc, 5);
26: end if;
27: --
28: g_person_id_incl_rqd := 'N';
29: g_postal_code_incl_rqd := 'N';
710:
711: -- end of initialization of global lists
712: --
713: if g_debug then
714: hr_utility.set_location(' Exiting:'||l_proc, 15);
715: end if;
716: --
717: end initialize_all_cache_area;
718: -----------------------------------------------------------------------------
743: Begin
744: --
745: if g_debug then
746: l_proc := g_package||'result';
747: hr_utility.set_location('Entering:'||l_proc, 5);
748: end if;
749: --
750: l_success := 'N';
751: --
831: p_result := l_success;
832: --
833: --
834: if g_debug then
835: hr_utility.set_location('Exiting:'||l_proc, 15);
836: end if;
837: --
838: End;
839: --
861: Begin
862: --
863: if g_debug then
864: l_proc := g_package||'get_incl_crit_values';
865: hr_utility.set_location('Entering:'||l_proc||'num', 5);
866: end if;
867: --
868: open get_values;
869: loop
877: end if;
878: close get_values;
879: --
880: if g_debug then
881: hr_utility.set_location(' Exiting:'||l_proc || p_incl_rqd , 15);
882: end if;
883: --
884: End get_incl_crit_values;
885: --
908: Begin
909: --
910: if g_debug then
911: l_proc := g_package||'get_incl_crit_values';
912: hr_utility.set_location('Entering:'||l_proc || 'char', 5);
913: end if;
914: --
915: open get_values;
916: loop
924: end if;
925: close get_values;
926: --
927: if g_debug then
928: hr_utility.set_location(' Exiting:'||l_proc, 15);
929: end if;
930: --
931: End get_incl_crit_values;
932: --
953: Begin
954: --
955: if g_debug then
956: l_proc := g_package||'get_incl_crit_values';
957: hr_utility.set_location('Entering:'||l_proc, 5);
958: end if;
959: --
960: open get_values;
961: loop
970: end if;
971: close get_values;
972: --
973: if g_debug then
974: hr_utility.set_location(' Exiting:'||l_proc, 15);
975: end if;
976: --
977: End get_incl_crit_values;
978: --
1000: Begin
1001: --
1002: if g_debug then
1003: l_proc := g_package||'get_incl_crit_values';
1004: hr_utility.set_location('Entering:'||l_proc, 5);
1005: end if;
1006: --
1007: open get_values;
1008: loop
1017: end if;
1018: close get_values;
1019: --
1020: if g_debug then
1021: hr_utility.set_location(' Exiting:'||l_proc, 15);
1022: end if;
1023: --
1024: End get_incl_crit_values;
1025: --
1062: Begin
1063: --
1064: if g_debug then
1065: l_proc := g_package||'get_incl_crit_values';
1066: hr_utility.set_location('Entering:'||l_proc, 5);
1067: end if;
1068: --
1069: open get_values;
1070: loop
1089: end if;
1090: close get_values;
1091: --
1092: if g_debug then
1093: hr_utility.set_location(' Exiting:'||l_proc, 15);
1094: end if;
1095: --
1096: End get_incl_crit_values;
1097: --
1122: Begin
1123: --
1124: if g_debug then
1125: l_proc := g_package||'get_incl_crit_values_rg';
1126: hr_utility.set_location('Entering:'||l_proc, 5);
1127: end if;
1128: --
1129: open get_values;
1130: loop
1138: end if;
1139: close get_values;
1140: --
1141: if g_debug then
1142: hr_utility.set_location(' Exiting:'||l_proc, 15);
1143: end if;
1144: --
1145: End get_incl_crit_values_rg;
1146: --
1166: --
1167: l_excld_flag varchar2(1);
1168: --
1169: Begin
1170: g_debug := hr_utility.debug_enabled;
1171: if g_debug then
1172: l_proc := g_package||'determine_incl_crit_to_check';
1173: hr_utility.set_location('Entering:'||l_proc, 5);
1174: end if;
1169: Begin
1170: g_debug := hr_utility.debug_enabled;
1171: if g_debug then
1172: l_proc := g_package||'determine_incl_crit_to_check';
1173: hr_utility.set_location('Entering:'||l_proc, 5);
1174: end if;
1175:
1176:
1177:
1183: fetch get_incldd_incl_crit into l_crit_typ_id, l_crit_typ_cd, l_excld_flag;
1184: exit when get_incldd_incl_crit%notfound;
1185:
1186: if g_debug then
1187: hr_utility.set_location('crit_typ_cd:'|| l_crit_typ_cd, 5);
1188: end if;
1189:
1190: if l_crit_typ_cd = 'PID' then -- specific person
1191: g_person_id_excld_flag := l_excld_flag;
1519: g_val1_list,
1520: g_val2_list);
1521: elsif l_crit_typ_cd = 'EPLDT' then -- premium last update date
1522: if g_debug then
1523: hr_utility.set_location('crit_type ' ||'EPLDT',16);
1524: end if;
1525: g_prem_last_updt_dt_excld_flag := l_excld_flag;
1526: Get_Incl_Crit_Values(l_crit_typ_id,
1527: g_prem_last_updt_dt_rqd ,
1530:
1531: elsif l_crit_typ_cd = 'EPMNYR' then -- premium month and year
1532: g_prem_month_year_excld_flag := l_excld_flag;
1533: if g_debug then
1534: hr_utility.set_location('crit_type ' ||'EPMNYR',16);
1535: end if;
1536: Get_Incl_Crit_Values(l_crit_typ_id,
1537: g_prem_month_year_rqd,
1538: g_prem_month_year_dt_list1,
1540:
1541: elsif l_crit_typ_cd = 'RPPEDT' then -- pay period end date
1542: g_payroll_last_Date_excld_flag := l_excld_flag;
1543: if g_debug then
1544: hr_utility.set_location('crit_type ' ||'EPMNYR',16);
1545: end if;
1546: Get_Incl_Crit_Values(l_crit_typ_id,
1547: g_payroll_last_date_incl_rqd,
1548: g_payroll_last_dt_list1,
1669: --
1670: close get_incldd_incl_crit;
1671: --
1672: if g_debug then
1673: hr_utility.set_location(' Exiting:'||l_proc, 15);
1674: end if;
1675: --
1676: end determine_incl_crit_to_check;
1677: --
1695: Begin
1696: --
1697: if g_debug then
1698: l_proc := g_package||'chk_person_id_incl';
1699: hr_utility.set_location(' Entering:'||l_proc, 5);
1700: end if;
1701: --
1702: for i in 1..g_person_id_list.count
1703: loop
1714: raise g_include;
1715: end if;
1716: --
1717: if g_debug then
1718: hr_utility.set_location(' Exiting:'||l_proc, 15);
1719: end if;
1720: --
1721: raise g_not_include;
1722: --
1756: Begin
1757: --
1758: if g_debug then
1759: l_proc := g_package||'chk_postal_code_incl';
1760: hr_utility.set_location(' Entering:'||l_proc, 5);
1761: end if;
1762: --
1763: if p_postal_code is null then
1764: open get_postal_code;
1785: raise g_include;
1786: end if;
1787: --
1788: if g_debug then
1789: hr_utility.set_location(' Exiting:'||l_proc, 15);
1790: end if;
1791: --
1792: --
1793: raise g_not_include;
1829: Begin
1830: --
1831: if g_debug then
1832: l_proc := g_package||'chk_org_id_incl';
1833: hr_utility.set_location(' Entering:'||l_proc, 5);
1834: end if;
1835: --
1836: if p_org_id is null then
1837: open get_org_id;
1855: raise g_include;
1856: end if;
1857: --
1858: if g_debug then
1859: hr_utility.set_location(' Exiting:'||l_proc, 15);
1860: end if;
1861: --
1862: --
1863: raise g_not_include;
1899: Begin
1900: --
1901: if g_debug then
1902: l_proc := g_package||'chk_loc_id_incl';
1903: hr_utility.set_location(' Entering:'||l_proc, 5);
1904: end if;
1905: --
1906: if p_loc_id is null then
1907: open get_loc_id;
1925: raise g_include;
1926: end if;
1927: --
1928: if g_debug then
1929: hr_utility.set_location(' Exiting:'||l_proc, 15);
1930: end if;
1931: --
1932: raise g_not_include;
1933: --
1971: Begin
1972: --
1973: if g_debug then
1974: l_proc := g_package||'chk_gre_incl';
1975: hr_utility.set_location(' Entering:'||l_proc, 5);
1976: end if;
1977: --
1978: if p_gre is null then
1979: open get_gre;
1997: raise g_include;
1998: end if;
1999: --
2000: if g_debug then
2001: hr_utility.set_location(' Exiting:'||l_proc, 15);
2002: end if;
2003: --
2004: raise g_not_include;
2005: --
2042: Begin
2043: --
2044: if g_debug then
2045: l_proc := g_package||'chk_state_incl';
2046: hr_utility.set_location(' Entering:'||l_proc, 5);
2047: end if;
2048: --
2049: if p_state is null then
2050: open get_state;
2068: raise g_include;
2069: end if;
2070: --
2071: if g_debug then
2072: hr_utility.set_location(' Exiting:'||l_proc, 15);
2073: end if;
2074: --
2075: raise g_not_include;
2076: --
2109: Begin
2110: --
2111: if g_debug then
2112: l_proc := g_package||'chk_bnft_grp_incl';
2113: hr_utility.set_location(' Entering:'||l_proc, 5);
2114: end if;
2115: --
2116: if p_bnft_grp is null then
2117: open get_bnft_grp;
2135: raise g_include;
2136: end if;
2137: --
2138: if g_debug then
2139: hr_utility.set_location(' Exiting:'||l_proc, 15);
2140: end if;
2141: --
2142: raise g_not_include;
2143: --
2177: Begin
2178: --
2179: if g_debug then
2180: l_proc := g_package||'chk_ee_status_incl';
2181: hr_utility.set_location(' Entering:'||l_proc, 5);
2182: end if;
2183: --
2184: if p_ee_status is null then
2185: open get_ee_status;
2203: raise g_include;
2204: end if;
2205: --
2206: if g_debug then
2207: hr_utility.set_location(' Exiting:'||l_proc, 15);
2208: end if;
2209: --
2210: raise g_not_include;
2211: --
2245: Begin
2246: --
2247: if g_debug then
2248: l_proc := g_package||'chk_payroll_id_incl';
2249: hr_utility.set_location(' Entering:'||l_proc, 5);
2250: end if;
2251: --
2252: if p_payroll_id is null then
2253: open c_pay;
2271: raise g_include;
2272: end if;
2273: --
2274: if g_debug then
2275: hr_utility.set_location(' Exiting:'||l_proc, 15);
2276: end if;
2277: --
2278: raise g_not_include;
2279: --
2315: Begin
2316: --
2317: if g_debug then
2318: l_proc := g_package||'chk_person_rule_incl';
2319: hr_utility.set_location(' Entering:'||l_proc, 5);
2320: end if;
2321: --
2322: open c_asg;
2323: fetch c_asg into l_asg;
2353: raise g_include;
2354: end if;
2355: --
2356: if g_debug then
2357: hr_utility.set_location(' Exiting:'||l_proc, 15);
2358: end if;
2359: --
2360: raise g_not_include;
2361: --
2392: Begin
2393: --
2394: if g_debug then
2395: l_proc := g_package||'chk_per_ler_incl';
2396: hr_utility.set_location(' Entering:'||l_proc, 5);
2397: end if;
2398: --
2399: open get_per_ler;
2400: loop
2417: raise g_include;
2418: end if;
2419: --
2420: if g_debug then
2421: hr_utility.set_location(' Exiting:'||l_proc, 15);
2422: end if;
2423: --
2424: raise g_not_include;
2425: --
2457: Begin
2458: --
2459: if g_debug then
2460: l_proc := g_package||'chk_person_type_incl';
2461: hr_utility.set_location(' Entering:'||l_proc, 5);
2462: end if;
2463: --
2464: open get_person_type;
2465: loop
2478: end loop;
2479: close get_person_type;
2480: --
2481: if g_debug then
2482: hr_utility.set_location(' Exiting:'||l_proc, 15);
2483: end if;
2484: --
2485: if p_excld_flag = 'Y' then
2486: raise g_include;
2521: Begin
2522: --
2523: if g_debug then
2524: l_proc := g_package||'chk_cmbn_incl';
2525: hr_utility.set_location(' Entering:'||l_proc, 5);
2526: end if;
2527: --
2528: l_success := 'N';
2529: l_current_success := 'N';
2569: end if;
2570: end loop;
2571: --
2572: if g_debug then
2573: hr_utility.set_location(' Exiting:'||l_proc, 15);
2574: end if;
2575: --
2576: if l_current_success = 'Y' then
2577: raise g_include;
2605: Begin
2606: --
2607: if g_debug then
2608: l_proc := g_package||'chk_enrt_opt_incl';
2609: hr_utility.set_location(' Entering:'||l_proc, 5);
2610: end if;
2611: --
2612: -- if p_opt_id is null then error, it must be passed in!
2613: --
2626: raise g_include;
2627: end if;
2628: --
2629: if g_debug then
2630: hr_utility.set_location(' Exiting:'||l_proc, 15);
2631: end if;
2632: --
2633: raise g_not_include;
2634: --
2658: Begin
2659: --
2660: if g_debug then
2661: l_proc := g_package||'chk_enrt_plan_incl';
2662: hr_utility.set_location(' Entering:'||l_proc, 5);
2663: end if;
2664: --
2665: -- if p_pl_id is null then error, it must be passed in!
2666: --
2679: raise g_include;
2680: end if;
2681: --
2682: if g_debug then
2683: hr_utility.set_location(' Exiting:'||l_proc, 15);
2684: end if;
2685: --
2686: raise g_not_include;
2687: --
2710: Begin
2711: --
2712: if g_debug then
2713: l_proc := g_package||'chk_enrt_rg_plan_incl';
2714: hr_utility.set_location(' Entering:'||l_proc, 5);
2715: end if;
2716: --
2717: -- if p_pl_id is null then error, it must be passed in!
2718: --
2731: raise g_include;
2732: end if;
2733: --
2734: if g_debug then
2735: hr_utility.set_location(' Exiting:'||l_proc, 15);
2736: end if;
2737: --
2738: raise g_not_include;
2739: --
2762: Begin
2763: --
2764: if g_debug then
2765: l_proc := g_package||'chk_enrt_sspndd_incl';
2766: hr_utility.set_location(' Entering:'||l_proc, 5);
2767: end if;
2768: --
2769: if p_sspndd_flag is null then -- sspndd_flag will always be null for eligiblity.
2770: raise g_include;
2785: raise g_include;
2786: end if;
2787: --
2788: if g_debug then
2789: hr_utility.set_location(' Exiting:'||l_proc, 15);
2790: end if;
2791: --
2792: raise g_not_include;
2793: --
2820: Begin
2821: --
2822: if g_debug then
2823: l_proc := g_package||'chk_enrt_cvg_strt_dt_incl';
2824: hr_utility.set_location(' Entering:'||l_proc, 5);
2825: end if;
2826: --
2827: for i in 1..g_enrt_cvg_strt_dt_list1.count
2828: loop
2850: raise g_include;
2851: end if;
2852: --
2853: if g_debug then
2854: hr_utility.set_location(' Exiting:'||l_proc, 15);
2855: end if;
2856: --
2857: raise g_not_include;
2858: --
2887: Begin
2888: --
2889: if g_debug then
2890: l_proc := g_package||'chk_enrt_cvg_drng_perd_incl';
2891: hr_utility.set_location(' Entering:'||l_proc, 5);
2892: end if;
2893: --
2894: for i in 1..g_enrt_cvg_drng_perd_list1.count
2895: loop
2922: raise g_include;
2923: end if;
2924: --
2925: if g_debug then
2926: hr_utility.set_location(' Exiting:'||l_proc, 15);
2927: end if;
2928: --
2929: raise g_not_include;
2930: --
2953: Begin
2954: --
2955: if g_debug then
2956: l_proc := g_package||'chk_enrt_stat_incl';
2957: hr_utility.set_location(' Entering:'||l_proc, 5);
2958: end if;
2959: --
2960: if p_prtt_enrt_rslt_stat_cd is null then
2961: raise g_include;
2976: raise g_include;
2977: end if;
2978: --
2979: if g_debug then
2980: hr_utility.set_location(' Exiting:'||l_proc, 15);
2981: end if;
2982: --
2983: raise g_not_include;
2984: --
3007: Begin
3008: --
3009: if g_debug then
3010: l_proc := g_package||'chk_enrt_mthd_incl';
3011: hr_utility.set_location(' Entering:'||l_proc, 5);
3012: end if;
3013: --
3014: if p_enrt_mthd_cd is null then
3015: raise g_include;
3030: raise g_include;
3031: end if;
3032: --
3033: if g_debug then
3034: hr_utility.set_location(' Exiting:'||l_proc, 15);
3035: end if;
3036: --
3037: raise g_not_include;
3038: --
3061: Begin
3062: --
3063: if g_debug then
3064: l_proc := g_package||'chk_enrt_pgm_incl';
3065: hr_utility.set_location(' Entering:'||l_proc, 5);
3066: end if;
3067: --
3068: for i in 1..g_enrt_pgm_list.count
3069: loop
3080: raise g_include;
3081: end if;
3082: --
3083: if g_debug then
3084: hr_utility.set_location(' Exiting:'||l_proc, 15);
3085: end if;
3086: --
3087: raise g_not_include;
3088: --
3111: Begin
3112: --
3113: if g_debug then
3114: l_proc := g_package||'chk_enrt_pl_typ_incl';
3115: hr_utility.set_location(' Entering:'||l_proc, 5);
3116: end if;
3117: --
3118: for i in 1..g_enrt_pl_typ_list.count
3119: loop
3130: raise g_include;
3131: end if;
3132: --
3133: if g_debug then
3134: hr_utility.set_location(' Exiting:'||l_proc, 15);
3135: end if;
3136: --
3137: raise g_not_include;
3138: --
3165: Begin
3166: --
3167: if g_debug then
3168: l_proc := g_package||'chk_enrt_last_upd_dt_incl';
3169: hr_utility.set_location(' Entering:'||l_proc, 5);
3170: end if;
3171: --
3172: for i in 1..g_enrt_last_upd_dt_list1.count
3173: loop
3196: raise g_include;
3197: end if;
3198: --
3199: if g_debug then
3200: hr_utility.set_location(' Exiting:'||l_proc, 15);
3201: end if;
3202: --
3203: raise g_not_include;
3204: --
3227: Begin
3228: --
3229: if g_debug then
3230: l_proc := g_package||'chk_enrt_ler_name_incl';
3231: hr_utility.set_location(' Entering:'||l_proc, 5);
3232: end if;
3233: --
3234: for i in 1..g_enrt_ler_name_list.count
3235: loop
3246: raise g_include;
3247: end if;
3248: --
3249: if g_debug then
3250: hr_utility.set_location(' Exiting:'||l_proc, 15);
3251: end if;
3252: --
3253: raise g_not_include;
3254: --
3277: Begin
3278: --
3279: if g_debug then
3280: l_proc := g_package||'chk_enrt_ler_stat_incl';
3281: hr_utility.set_location(' Entering:'||l_proc, 5);
3282: end if;
3283: --
3284: for i in 1..g_enrt_ler_stat_list.count
3285: loop
3296: raise g_include;
3297: end if;
3298: --
3299: if g_debug then
3300: hr_utility.set_location(' Exiting:'||l_proc, 15);
3301: end if;
3302: --
3303: raise g_not_include;
3304: --
3331: Begin
3332: --
3333: if g_debug then
3334: l_proc := g_package||'chk_enrt_ler_ocrd_dt_incl';
3335: hr_utility.set_location(' Entering:'||l_proc, 5);
3336: end if;
3337: --
3338: for i in 1..g_enrt_ler_ocrd_dt_list1.count
3339: loop
3360: raise g_include;
3361: end if;
3362: --
3363: if g_debug then
3364: hr_utility.set_location(' Exiting:'||l_proc, 15);
3365: end if;
3366: --
3367: raise g_not_include;
3368: --
3395: Begin
3396: --
3397: if g_debug then
3398: l_proc := g_package||'chk_enrt_ler_ntfn_dt_incl';
3399: hr_utility.set_location(' Entering:'||l_proc, 5);
3400: end if;
3401: --
3402: for i in 1..g_enrt_ler_ntfn_dt_list1.count
3403: loop
3423: raise g_include;
3424: end if;
3425: --
3426: if g_debug then
3427: hr_utility.set_location(' Exiting:'||l_proc, 15);
3428: end if;
3429: --
3430: raise g_not_include;
3431: --
3459:
3460: begin
3461: if g_debug then
3462: l_proc := g_package||'chk_enrt_dpnt_rltn_incl';
3463: hr_utility.set_location(' Entering:'||l_proc, 5);
3464: end if;
3465:
3466: --link the entrolled dependent with change even dependent
3467: if p_dpnt_person_id = nvl(ben_ext_person.g_chg_prmtr_06,'-1') then
3472: end if;
3473: end if;
3474:
3475: if g_debug then
3476: hr_utility.set_location(' Exiting:'||l_proc, 15);
3477: end if;
3478: if p_excld_flag = 'Y' then
3479: raise g_include;
3480: end if;
3532: Begin
3533: --
3534: if g_debug then
3535: l_proc := g_package||'chk_enrt_rltn_incl';
3536: hr_utility.set_location(' Entering:'||l_proc, 5);
3537: end if;
3538: --
3539: for i in 1..g_enrt_rltn_list.count
3540: loop
3580: raise g_include;
3581: end if;
3582: --
3583: if g_debug then
3584: hr_utility.set_location(' Exiting:'||l_proc, 15);
3585: end if;
3586: --
3587: raise g_not_include;
3588: --
3612: Begin
3613: --
3614: if g_debug then
3615: l_proc := g_package||'chk_elct_opt_incl';
3616: hr_utility.set_location(' Entering:'||l_proc, 5);
3617: end if;
3618: --
3619: -- if p_pl_id is null then error, it must be passed in!
3620: --
3620: --
3621: for i in 1..g_elct_opt_list.count
3622: loop
3623: if g_debug then
3624: hr_utility.set_location(' option id '|| p_opt_id || ':'||g_elct_opt_list(i), 5);
3625: end if;
3626:
3627: if p_opt_id = g_elct_opt_list(i) then
3628: if p_excld_flag = 'N' then
3625: end if;
3626:
3627: if p_opt_id = g_elct_opt_list(i) then
3628: if p_excld_flag = 'N' then
3629: hr_utility.set_location(' rise incl ', 5);
3630: raise g_include;
3631: else
3632: hr_utility.set_location(' rise excl ', 5);
3633: raise g_not_include;
3628: if p_excld_flag = 'N' then
3629: hr_utility.set_location(' rise incl ', 5);
3630: raise g_include;
3631: else
3632: hr_utility.set_location(' rise excl ', 5);
3633: raise g_not_include;
3634: end if;
3635: end if;
3636: end loop;
3639: raise g_include;
3640: end if;
3641: --
3642: if g_debug then
3643: hr_utility.set_location(' Exiting:'||l_proc, 15);
3644: end if;
3645: --
3646: raise g_not_include;
3647: --
3648: Exception
3649: --
3650: when g_include then
3651: if g_debug then
3652: hr_utility.set_location(' option id include ', 5);
3653: end if;
3654:
3655: null;
3656: --
3678: Begin
3679: --
3680: if g_debug then
3681: l_proc := g_package||'chk_elct_plan_incl';
3682: hr_utility.set_location(' Entering:'||l_proc, 5);
3683: end if;
3684: --
3685: -- if p_pl_id is null then error, it must be passed in!
3686: --
3699: raise g_include;
3700: end if;
3701: --
3702: if g_debug then
3703: hr_utility.set_location(' Exiting:'||l_proc, 15);
3704: end if;
3705: --
3706: raise g_not_include;
3707: --
3731: Begin
3732: --
3733: if g_debug then
3734: l_proc := g_package||'chk_elct_rg_plan_incl';
3735: hr_utility.set_location(' Entering:'||l_proc, 5);
3736: end if;
3737: --
3738: -- if p_pl_id is null then error, it must be passed in!
3739: --
3752: raise g_include;
3753: end if;
3754: --
3755: if g_debug then
3756: hr_utility.set_location(' Exiting:'||l_proc, 15);
3757: end if;
3758: --
3759: raise g_not_include;
3760: --
3787: Begin
3788: --
3789: if g_debug then
3790: l_proc := g_package||'chk_elct_enrt_strt_dt_incl';
3791: hr_utility.set_location(' Entering:'||l_proc, 5);
3792: end if;
3793: --
3794: for i in 1..g_elct_enrt_strt_dt_list1.count
3795: loop
3816: raise g_include;
3817: end if;
3818: --
3819: if g_debug then
3820: hr_utility.set_location(' Exiting:'||l_proc, 15);
3821: end if;
3822: --
3823: raise g_not_include;
3824: --
3847: Begin
3848: --
3849: if g_debug then
3850: l_proc := g_package||'chk_elct_pgm_incl';
3851: hr_utility.set_location(' Entering:'||l_proc, 5);
3852: end if;
3853: --
3854: for i in 1..g_elct_pgm_list.count
3855: loop
3866: raise g_include;
3867: end if;
3868: --
3869: if g_debug then
3870: hr_utility.set_location(' Exiting:'||l_proc, 15);
3871: end if;
3872: --
3873: raise g_not_include;
3874: --
3898: Begin
3899: --
3900: if g_debug then
3901: l_proc := g_package||'chk_elct_pl_typ_incl';
3902: hr_utility.set_location(' Entering:'||l_proc, 5);
3903: end if;
3904: --
3905: for i in 1..g_elct_pl_typ_list.count
3906: loop
3917: raise g_include;
3918: end if;
3919: --
3920: if g_debug then
3921: hr_utility.set_location(' Exiting:'||l_proc, 15);
3922: end if;
3923: --
3924: raise g_not_include;
3925: --
3953: Begin
3954: --
3955: if g_debug then
3956: l_proc := g_package||'chk_elct_last_upd_dt_incl';
3957: hr_utility.set_location(' Entering:'||l_proc, 5);
3958: end if;
3959: --
3960: for i in 1..g_elct_last_upd_dt_list1.count
3961: loop
3982: raise g_include;
3983: end if;
3984: --
3985: if g_debug then
3986: hr_utility.set_location(' Exiting:'||l_proc, 15);
3987: end if;
3988: --
3989: raise g_not_include;
3990: --
4014: Begin
4015: --
4016: if g_debug then
4017: l_proc := g_package||'chk_elct_ler_name_incl';
4018: hr_utility.set_location(' Entering:'||l_proc, 5);
4019: end if;
4020: --
4021: for i in 1..g_elct_ler_name_list.count
4022: loop
4033: raise g_include;
4034: end if;
4035: --
4036: if g_debug then
4037: hr_utility.set_location(' Exiting:'||l_proc, 15);
4038: end if;
4039: --
4040: raise g_not_include;
4041: --
4065: Begin
4066: --
4067: if g_debug then
4068: l_proc := g_package||'chk_elct_ler_stat_incl';
4069: hr_utility.set_location(' Entering:'||l_proc, 5);
4070: end if;
4071: --
4072: for i in 1..g_elct_ler_stat_list.count
4073: loop
4084: raise g_include;
4085: end if;
4086: --
4087: if g_debug then
4088: hr_utility.set_location(' Exiting:'||l_proc, 15);
4089: end if;
4090: --
4091: raise g_not_include;
4092: --
4116: Begin
4117: --
4118: if g_debug then
4119: l_proc := g_package||'chk_elct_yrprd_incl';
4120: hr_utility.set_location(' Entering:'||l_proc, 5);
4121: end if;
4122: --
4123: for i in 1..g_elct_yrprd_list.count
4124: loop
4135: raise g_include;
4136: end if;
4137: --
4138: if g_debug then
4139: hr_utility.set_location(' Exiting:'||l_proc, 15);
4140: end if;
4141: --
4142: raise g_not_include;
4143: --
4170: Begin
4171: --
4172: if g_debug then
4173: l_proc := g_package||'chk_elct_ler_ocrd_dt_incl';
4174: hr_utility.set_location(' Entering:'||l_proc, 5);
4175: end if;
4176: --
4177: for i in 1..g_elct_ler_ocrd_dt_list1.count
4178: loop
4199: raise g_include;
4200: end if;
4201: --
4202: if g_debug then
4203: hr_utility.set_location(' Exiting:'||l_proc, 15);
4204: end if;
4205: --
4206: raise g_not_include;
4207: --
4235: Begin
4236: --
4237: if g_debug then
4238: l_proc := g_package||'chk_elct_ler_ntfn_dt_incl';
4239: hr_utility.set_location(' Entering:'||l_proc, 5);
4240: end if;
4241: --
4242: for i in 1..g_elct_ler_ntfn_dt_list1.count
4243: loop
4264: raise g_include;
4265: end if;
4266: --
4267: if g_debug then
4268: hr_utility.set_location(' Exiting:'||l_proc, 15);
4269: end if;
4270: --
4271: raise g_not_include;
4272: --
4298: Begin
4299: --
4300: if g_debug then
4301: l_proc := g_package||'chk_elct_rltn_incl';
4302: hr_utility.set_location(' Entering:'||l_proc, 5);
4303: end if;
4304: --
4305: for i in 1..g_elct_rltn_list.count
4306: loop
4322: raise g_include;
4323: end if;
4324: --
4325: if g_debug then
4326: hr_utility.set_location(' Exiting:'||l_proc, 15);
4327: end if;
4328: --
4329: raise g_not_include;
4330: --
4354: Begin
4355: --
4356: if g_debug then
4357: l_proc := g_package||'chk_chg_evt_cd_incl';
4358: hr_utility.set_location(' Entering:'||l_proc, 5);
4359: end if;
4360: --
4361: if p_chg_evt_source is null or p_chg_evt_source = 'BEN' then
4362: for i in 1..g_chg_evt_list.count
4389: raise g_include;
4390: end if;
4391: --
4392: if g_debug then
4393: hr_utility.set_location(' Exiting:'||l_proc, 15);
4394: end if;
4395: --
4396: raise g_not_include;
4397: --
4423: Begin
4424: --
4425: if g_debug then
4426: l_proc := g_package||'chk_chg_eff_dt_incl';
4427: hr_utility.set_location(' Entering:'||l_proc, 5);
4428: end if;
4429: --
4430: for i in 1..g_chg_eff_dt_list1.count
4431: loop
4432: --- if the concurrent manager param is passed in then use that
4433: if ben_ext_thread.g_effective_start_date is not null then
4434: l_low_date := ben_ext_thread.g_effective_start_date ;
4435: l_high_date := ben_ext_thread.g_effective_end_date ;
4436: hr_utility.set_location( ' param chg eff date ' || l_low_date || ' /' || l_high_date, 99 );
4437: else
4438: l_low_date := ben_ext_util.calc_ext_date
4439: (p_ext_date_cd => g_chg_eff_dt_list1(i),
4440: p_abs_date => p_effective_date,
4458: raise g_include;
4459: end if;
4460: --
4461: if g_debug then
4462: hr_utility.set_location(' Exiting:'||l_proc, 15);
4463: end if;
4464: --
4465: raise g_not_include;
4466: --
4493: Begin
4494: --
4495: if g_debug then
4496: l_proc := g_package||'chk_chg_actl_dt_incl';
4497: hr_utility.set_location(' Entering:'||l_proc, 5);
4498: end if;
4499: --
4500: for i in 1..g_chg_actl_dt_list1.count
4501: loop
4502: --- when the date passed from param use the param date
4503: if ben_ext_thread.g_actual_start_date is not null then
4504: l_low_date := ben_ext_thread.g_actual_start_date ;
4505: l_high_date := ben_ext_thread.g_actual_end_date ;
4506: hr_utility.set_location( ' param chg act date ' || l_low_date || ' /' || l_high_date, 99 );
4507: else
4508: l_low_date := ben_ext_util.calc_ext_date
4509: (p_ext_date_cd => g_chg_actl_dt_list1(i),
4510: p_abs_date => p_effective_date,
4527: raise g_include;
4528: end if;
4529: --
4530: if g_debug then
4531: hr_utility.set_location(' Exiting:'||l_proc, 15);
4532: end if;
4533: --
4534: raise g_not_include;
4535: --
4558: Begin
4559: --
4560: if g_debug then
4561: l_proc := g_package||'chk_chg_login_incl';
4562: hr_utility.set_location(' Entering:'||l_proc, 5);
4563: end if;
4564: --
4565: for i in 1..g_chg_login_list.count
4566: loop
4577: raise g_include;
4578: end if;
4579: --
4580: if g_debug then
4581: hr_utility.set_location(' Exiting:'||l_proc, 15);
4582: end if;
4583: --
4584: raise g_not_include;
4585: --
4608: Begin
4609: --
4610: if g_debug then
4611: l_proc := g_package||'chk_cm_typ_incl';
4612: hr_utility.set_location(' Entering:'||l_proc, 5);
4613: end if;
4614: --
4615: for i in 1..g_cm_typ_list.count
4616: loop
4627: raise g_include;
4628: end if;
4629: --
4630: if g_debug then
4631: hr_utility.set_location(' Exiting:'||l_proc, 15);
4632: end if;
4633: --
4634: raise g_not_include;
4635: --
4661: Begin
4662: --
4663: if g_debug then
4664: l_proc := g_package||'chk_cm_last_upd_dt_incl';
4665: hr_utility.set_location(' Entering:'||l_proc, 5);
4666: end if;
4667: --
4668: for i in 1..g_cm_last_upd_dt_list1.count
4669: loop
4688: raise g_include;
4689: end if;
4690: --
4691: if g_debug then
4692: hr_utility.set_location(' Exiting:'||l_proc, 15);
4693: end if;
4694: --
4695: raise g_not_include;
4696: --
4722: Begin
4723: --
4724: if g_debug then
4725: l_proc := g_package||'chk_cm_pr_last_upd_dt_incl';
4726: hr_utility.set_location(' Entering:'||l_proc, 5);
4727: end if;
4728: --
4729: for i in 1..g_cm_pr_last_upd_dt_list1.count
4730: loop
4749: raise g_include;
4750: end if;
4751: --
4752: if g_debug then
4753: hr_utility.set_location(' Exiting:'||l_proc, 15);
4754: end if;
4755: --
4756: raise g_not_include;
4757: --
4784: Begin
4785: --
4786: if g_debug then
4787: l_proc := g_package||'chk_payroll_end_date_incl';
4788: hr_utility.set_location(' Entering:'||l_proc, 5);
4789: end if;
4790: --
4791: for i in 1..g_payroll_last_dt_list1.count
4792: loop
4800: (p_ext_date_cd => g_payroll_last_dt_list2(i),
4801: p_abs_date => p_effective_date,
4802: p_ext_dfn_id => ben_extract.g_ext_dfn_id);
4803: if g_debug then
4804: hr_utility.set_location(' hight date '|| l_high_date,51);
4805: hr_utility.set_location(' low date ' || l_low_date,51);
4806: end if;
4807:
4808: if p_pay_end_date between l_low_date and nvl(l_high_date,l_low_date) then
4801: p_abs_date => p_effective_date,
4802: p_ext_dfn_id => ben_extract.g_ext_dfn_id);
4803: if g_debug then
4804: hr_utility.set_location(' hight date '|| l_high_date,51);
4805: hr_utility.set_location(' low date ' || l_low_date,51);
4806: end if;
4807:
4808: if p_pay_end_date between l_low_date and nvl(l_high_date,l_low_date) then
4809: if p_excld_flag = 'N' then
4807:
4808: if p_pay_end_date between l_low_date and nvl(l_high_date,l_low_date) then
4809: if p_excld_flag = 'N' then
4810: if g_debug then
4811: hr_utility.set_location('Y Exiting:'||l_proc, 51);
4812: end if;
4813: raise g_include;
4814: else
4815: if g_debug then
4812: end if;
4813: raise g_include;
4814: else
4815: if g_debug then
4816: hr_utility.set_location('N Exiting:'||l_proc, 51);
4817: end if;
4818: raise g_not_include;
4819: end if;
4820: end if;
4821: end loop;
4822: ---
4823: if p_excld_flag = 'Y' then
4824: if g_debug then
4825: hr_utility.set_location('Y Exiting:'||l_proc, 15);
4826: end if;
4827: raise g_include;
4828: end if;
4829: --
4827: raise g_include;
4828: end if;
4829: --
4830: if g_debug then
4831: hr_utility.set_location(' Y Exiting:'||l_proc, 15);
4832: end if;
4833: --
4834: raise g_not_include;
4835: --
4865: Begin
4866: --
4867: if g_debug then
4868: l_proc := g_package||'chk_prem_last_upd_dt_incl';
4869: hr_utility.set_location(' Entering:'||l_proc, 5);
4870: end if;
4871: --
4872: for i in 1..g_prem_last_upd_dt_list1.count
4873: loop
4879: (p_ext_date_cd => g_prem_last_upd_dt_list2(i),
4880: p_abs_date => p_effective_date,
4881: p_ext_dfn_id => ben_extract.g_ext_dfn_id);
4882: if g_debug then
4883: hr_utility.set_location(' hight date '|| l_high_date,16);
4884: hr_utility.set_location(' low date ' || l_low_date,16);
4885: hr_utility.set_location(' update dte '|| p_last_update_date,16);
4886: end if;
4887: if p_last_update_date between l_low_date and nvl(l_high_date,l_low_date) then
4880: p_abs_date => p_effective_date,
4881: p_ext_dfn_id => ben_extract.g_ext_dfn_id);
4882: if g_debug then
4883: hr_utility.set_location(' hight date '|| l_high_date,16);
4884: hr_utility.set_location(' low date ' || l_low_date,16);
4885: hr_utility.set_location(' update dte '|| p_last_update_date,16);
4886: end if;
4887: if p_last_update_date between l_low_date and nvl(l_high_date,l_low_date) then
4888: if p_excld_flag = 'N' then
4881: p_ext_dfn_id => ben_extract.g_ext_dfn_id);
4882: if g_debug then
4883: hr_utility.set_location(' hight date '|| l_high_date,16);
4884: hr_utility.set_location(' low date ' || l_low_date,16);
4885: hr_utility.set_location(' update dte '|| p_last_update_date,16);
4886: end if;
4887: if p_last_update_date between l_low_date and nvl(l_high_date,l_low_date) then
4888: if p_excld_flag = 'N' then
4889: if g_debug then
4886: end if;
4887: if p_last_update_date between l_low_date and nvl(l_high_date,l_low_date) then
4888: if p_excld_flag = 'N' then
4889: if g_debug then
4890: hr_utility.set_location('Y Exiting:'||l_proc, 15);
4891: end if;
4892: raise g_include;
4893: else
4894: if g_debug then
4891: end if;
4892: raise g_include;
4893: else
4894: if g_debug then
4895: hr_utility.set_location('N Exiting:'||l_proc, 15);
4896: end if;
4897: raise g_not_include;
4898: end if;
4899: end if;
4900: end loop;
4901: ---
4902: if p_excld_flag = 'Y' then
4903: if g_debug then
4904: hr_utility.set_location('Y Exiting:'||l_proc, 15);
4905: end if;
4906: raise g_include;
4907: end if;
4908: --
4906: raise g_include;
4907: end if;
4908: --
4909: if g_debug then
4910: hr_utility.set_location(' Y Exiting:'||l_proc, 15);
4911: end if;
4912: --
4913: raise g_not_include;
4914: --
4947: Begin
4948: --
4949: if g_debug then
4950: l_proc := g_package||'chk_prem_month_year_no_incl';
4951: hr_utility.set_location(' Entering:'||l_proc, 5);
4952: end if;
4953: --
4954: for i in 1..g_prem_month_year_dt_list1.count
4955: loop
4968: l_high_mo_no := to_number(to_char(l_high_date,'MM')) ;
4969: l_high_yr_no := to_number(to_char(l_high_date,'RRRR')) ;
4970:
4971: if g_debug then
4972: hr_utility.set_location(' hight month ' || l_low_mo_no ,161);
4973: hr_utility.set_location(' low month ' || l_high_mo_no,161);
4974: hr_utility.set_location(' hight year ' || l_low_yr_no ,161);
4975: hr_utility.set_location(' low year ' || l_high_yr_no,161);
4976: hr_utility.set_location(' month ' || p_mo_num,161);
4969: l_high_yr_no := to_number(to_char(l_high_date,'RRRR')) ;
4970:
4971: if g_debug then
4972: hr_utility.set_location(' hight month ' || l_low_mo_no ,161);
4973: hr_utility.set_location(' low month ' || l_high_mo_no,161);
4974: hr_utility.set_location(' hight year ' || l_low_yr_no ,161);
4975: hr_utility.set_location(' low year ' || l_high_yr_no,161);
4976: hr_utility.set_location(' month ' || p_mo_num,161);
4977: hr_utility.set_location(' year ' || p_yr_num,161);
4970:
4971: if g_debug then
4972: hr_utility.set_location(' hight month ' || l_low_mo_no ,161);
4973: hr_utility.set_location(' low month ' || l_high_mo_no,161);
4974: hr_utility.set_location(' hight year ' || l_low_yr_no ,161);
4975: hr_utility.set_location(' low year ' || l_high_yr_no,161);
4976: hr_utility.set_location(' month ' || p_mo_num,161);
4977: hr_utility.set_location(' year ' || p_yr_num,161);
4978: end if;
4971: if g_debug then
4972: hr_utility.set_location(' hight month ' || l_low_mo_no ,161);
4973: hr_utility.set_location(' low month ' || l_high_mo_no,161);
4974: hr_utility.set_location(' hight year ' || l_low_yr_no ,161);
4975: hr_utility.set_location(' low year ' || l_high_yr_no,161);
4976: hr_utility.set_location(' month ' || p_mo_num,161);
4977: hr_utility.set_location(' year ' || p_yr_num,161);
4978: end if;
4979: ---validate month year no
4972: hr_utility.set_location(' hight month ' || l_low_mo_no ,161);
4973: hr_utility.set_location(' low month ' || l_high_mo_no,161);
4974: hr_utility.set_location(' hight year ' || l_low_yr_no ,161);
4975: hr_utility.set_location(' low year ' || l_high_yr_no,161);
4976: hr_utility.set_location(' month ' || p_mo_num,161);
4977: hr_utility.set_location(' year ' || p_yr_num,161);
4978: end if;
4979: ---validate month year no
4980: if p_mo_num between l_low_mo_no and nvl(l_high_mo_no,l_low_mo_no) and
4973: hr_utility.set_location(' low month ' || l_high_mo_no,161);
4974: hr_utility.set_location(' hight year ' || l_low_yr_no ,161);
4975: hr_utility.set_location(' low year ' || l_high_yr_no,161);
4976: hr_utility.set_location(' month ' || p_mo_num,161);
4977: hr_utility.set_location(' year ' || p_yr_num,161);
4978: end if;
4979: ---validate month year no
4980: if p_mo_num between l_low_mo_no and nvl(l_high_mo_no,l_low_mo_no) and
4981: p_yr_num between l_low_yr_no and nvl(l_high_yr_no,l_low_yr_no) then
4992: raise g_include;
4993: end if;
4994: --
4995: if g_debug then
4996: hr_utility.set_location(' Exiting:'||l_proc, 15);
4997: end if;
4998: --
4999: raise g_not_include;
5000: --
5028: Begin
5029: --
5030: if g_debug then
5031: l_proc := g_package||'chk_cm_sent_dt_incl';
5032: hr_utility.set_location(' Entering:'||l_proc, 5);
5033: end if;
5034: --
5035: for i in 1..g_cm_sent_dt_list1.count
5036: loop
5055: raise g_include;
5056: end if;
5057: --
5058: if g_debug then
5059: hr_utility.set_location(' Exiting:'||l_proc, 15);
5060: end if;
5061: --
5062: raise g_not_include;
5063: --
5089: Begin
5090: --
5091: if g_debug then
5092: l_proc := g_package||'chk_cm_to_be_sent_dt_incl';
5093: hr_utility.set_location(' Entering:'||l_proc, 5);
5094: end if;
5095: --
5096: for i in 1..g_cm_to_be_sent_dt_list1.count
5097: loop
5116: raise g_include;
5117: end if;
5118: --
5119: if g_debug then
5120: hr_utility.set_location(' Exiting:'||l_proc, 15);
5121: end if;
5122: --
5123: raise g_not_include;
5124: --
5148: Begin
5149: --
5150: if g_debug then
5151: l_proc := g_package||'chk_actn_name_incl';
5152: hr_utility.set_location(' Entering:'||l_proc, 5);
5153: end if;
5154: --
5155: for i in 1..g_actn_name_list.count
5156: loop
5167: raise g_include;
5168: end if;
5169: --
5170: if g_debug then
5171: hr_utility.set_location(' Exiting:'||l_proc, 15);
5172: end if;
5173: --
5174: raise g_not_include;
5175: --
5199: Begin
5200: --
5201: if g_debug then
5202: l_proc := g_package||'chk_actn_item_rltn_incl';
5203: hr_utility.set_location(' Entering:'||l_proc, 5);
5204: end if;
5205: --
5206: for i in 1..g_actn_item_rltn_list.count
5207: loop
5223: raise g_include;
5224: end if;
5225: --
5226: if g_debug then
5227: hr_utility.set_location(' Exiting:'||l_proc, 15);
5228: end if;
5229: --
5230: raise g_not_include;
5231: --
5259: Begin
5260: --
5261: if g_debug then
5262: l_proc := g_package||'chk_tc_status_incl';
5263: hr_utility.set_location(' Entering:'||l_proc, 5);
5264: end if;
5265: --
5266: -- if p_tc_status_id is null then error, it must be passed in!
5267: --
5280: raise g_include;
5281: end if;
5282: --
5283: if g_debug then
5284: hr_utility.set_location(' Exiting:'||l_proc, 15);
5285: end if;
5286: --
5287: raise g_not_include;
5288: --
5313: Begin
5314: --
5315: if g_debug then
5316: l_proc := g_package||'chk_tc_deleted_incl';
5317: hr_utility.set_location(' Entering:'||l_proc, 5);
5318: end if;
5319: --
5320: -- if p_tc_deleted is null then error, it must be passed in!
5321: --
5334: raise g_include;
5335: end if;
5336: --
5337: if g_debug then
5338: hr_utility.set_location(' Exiting:'||l_proc, 15);
5339: end if;
5340: --
5341: raise g_not_include;
5342: --
5367: Begin
5368: --
5369: if g_debug then
5370: l_proc := g_package||'chk_project_id_incl';
5371: hr_utility.set_location(' Entering:'||l_proc, 5);
5372: end if;
5373: --
5374: -- if p_project_id is null then error, it must be passed in!
5375: --
5388: raise g_include;
5389: end if;
5390: --
5391: if g_debug then
5392: hr_utility.set_location(' Exiting:'||l_proc, 15);
5393: end if;
5394: --
5395: raise g_not_include;
5396: --
5421: Begin
5422: --
5423: if g_debug then
5424: l_proc := g_package||'chk_task_id_incl';
5425: hr_utility.set_location(' Entering:'||l_proc, 5);
5426: end if;
5427: --
5428: -- if p_task_id is null then error, it must be passed in!
5429: --
5442: raise g_include;
5443: end if;
5444: --
5445: if g_debug then
5446: hr_utility.set_location(' Exiting:'||l_proc, 15);
5447: end if;
5448: --
5449: raise g_not_include;
5450: --
5475: Begin
5476: --
5477: if g_debug then
5478: l_proc := g_package||'chk_exp_typ_id_incl';
5479: hr_utility.set_location(' Entering:'||l_proc, 5);
5480: end if;
5481: --
5482: -- if p_exp_typ_id is null then error, it must be passed in!
5483: --
5496: raise g_include;
5497: end if;
5498: --
5499: if g_debug then
5500: hr_utility.set_location(' Exiting:'||l_proc, 15);
5501: end if;
5502: --
5503: raise g_not_include;
5504: --
5529: Begin
5530: --
5531: if g_debug then
5532: l_proc := g_package||'chk_element_type_id_incl';
5533: hr_utility.set_location(' Entering:'||l_proc, 5);
5534: end if;
5535: --
5536: -- if p_element_type_id is null then error, it must be passed in!
5537: --
5550: raise g_include;
5551: end if;
5552: --
5553: if g_debug then
5554: hr_utility.set_location(' Exiting:'||l_proc, 15);
5555: end if;
5556: --
5557: raise g_not_include;
5558: --
5583: Begin
5584: --
5585: if g_debug then
5586: l_proc := g_package||'chk_po_num_incl';
5587: hr_utility.set_location(' Entering:'||l_proc, 5);
5588: end if;
5589: --
5590: -- if p_po_num is null then error, it must be passed in!
5591: --
5604: raise g_include;
5605: end if;
5606: --
5607: if g_debug then
5608: hr_utility.set_location(' Exiting:'||l_proc, 15);
5609: end if;
5610: --
5611: raise g_not_include;
5612: --
5641: Begin
5642: --
5643: if g_debug then
5644: l_proc := g_package||'chk_cwb_pl_prd_incl';
5645: hr_utility.set_location(' Entering:'||l_proc, 5);
5646: end if;
5647: --
5648: for i in 1..g_cwb_pl_list.count
5649: loop
5665: raise g_include;
5666: end if;
5667: --
5668: if g_debug then
5669: hr_utility.set_location(' Exiting:'||l_proc, 15);
5670: end if;
5671: --
5672: --
5673: raise g_not_include;
5698: Begin
5699: --
5700: if g_debug then
5701: l_proc := g_package||'chk_subhead_pos_incl';
5702: hr_utility.set_location(' Entering:'||l_proc, 5);
5703: end if;
5704: -- if p_position_id is null then error, it must be passed in!
5705: --
5706: for i in 1..g_subhead_pos_list.count
5716: if p_excld_flag = 'Y' then
5717: raise g_include;
5718: end if;
5719: if g_debug then
5720: hr_utility.set_location(' Exiting:'||l_proc, 15);
5721: end if;
5722: raise g_not_include;
5723: --
5724: Exception
5738: Begin
5739: --
5740: if g_debug then
5741: l_proc := g_package||'chk_subhead_job_incl';
5742: hr_utility.set_location(' Entering:'||l_proc, 5);
5743: end if;
5744: for i in 1..g_subhead_job_list.count
5745: loop
5746: if p_job_id = g_subhead_job_list(i) then
5754: if p_excld_flag = 'Y' then
5755: raise g_include;
5756: end if;
5757: if g_debug then
5758: hr_utility.set_location(' Exiting:'||l_proc, 15);
5759: end if;
5760: raise g_not_include;
5761: --
5762: Exception
5777: Begin
5778: --
5779: if g_debug then
5780: l_proc := g_package||'chk_subhead_loc_incl';
5781: hr_utility.set_location(' Entering:'||l_proc, 5);
5782: end if;
5783: for i in 1..g_subhead_loc_list.count
5784: loop
5785: if p_location_id = g_subhead_loc_list(i) then
5793: if p_excld_flag = 'Y' then
5794: raise g_include;
5795: end if;
5796: if g_debug then
5797: hr_utility.set_location(' Exiting:'||l_proc, 15);
5798: end if;
5799: raise g_not_include;
5800: --
5801: Exception
5815: Begin
5816: --
5817: if g_debug then
5818: l_proc := g_package||'chk_subhead_pay_incl';
5819: hr_utility.set_location(' Entering:'||l_proc, 5);
5820: end if;
5821: for i in 1..g_subhead_pay_list.count
5822: loop
5823: if p_payroll_id = g_subhead_pay_list(i) then
5831: if p_excld_flag = 'Y' then
5832: raise g_include;
5833: end if;
5834: if g_debug then
5835: hr_utility.set_location(' Exiting:'||l_proc, 15);
5836: end if;
5837: raise g_not_include;
5838: --
5839: Exception
5853: Begin
5854: --
5855: if g_debug then
5856: l_proc := g_package||'chk_subhead_org_incl';
5857: hr_utility.set_location(' Entering:'||l_proc, 5);
5858: end if;
5859: for i in 1..g_subhead_org_list.count
5860: loop
5861: if p_organization_id = g_subhead_org_list(i) then
5869: if p_excld_flag = 'Y' then
5870: raise g_include;
5871: end if;
5872: if g_debug then
5873: hr_utility.set_location(' Exiting:'||l_proc, 15);
5874: end if;
5875: raise g_not_include;
5876: --
5877: Exception
5891: Begin
5892: --
5893: if g_debug then
5894: l_proc := g_package||'chk_subhead_bg_incl';
5895: hr_utility.set_location(' Entering:'||l_proc, 5);
5896: end if;
5897: for i in 1..g_subhead_bg_list.count
5898: loop
5899: if p_business_group_id = g_subhead_bg_list(i) then
5907: if p_excld_flag = 'Y' then
5908: raise g_include;
5909: end if;
5910: if g_debug then
5911: hr_utility.set_location(' Exiting:'||l_proc, 15);
5912: end if;
5913: raise g_not_include;
5914: --
5915: Exception
5929: Begin
5930: --
5931: if g_debug then
5932: l_proc := g_package||'chk_subhead_grd_incl';
5933: hr_utility.set_location(' Entering:'||l_proc, 5);
5934: end if;
5935: --
5936: for i in 1..g_subhead_grd_list.count
5937: loop
5946: if p_excld_flag = 'Y' then
5947: raise g_include;
5948: end if;
5949: if g_debug then
5950: hr_utility.set_location(' Exiting:'||l_proc, 15);
5951: end if;
5952: raise g_not_include;
5953: --
5954: Exception
5979: Begin
5980: --
5981: if g_debug then
5982: l_proc := g_package||'chk_subhead_rule_incl';
5983: hr_utility.set_location(' Entering:'||l_proc, 5);
5984: end if;
5985: --
5986: hr_utility.set_location( p_param_2 || ' ' || p_param_val_2 , 5);
5987: for i in 1..g_subhead_rule_list.count
5982: l_proc := g_package||'chk_subhead_rule_incl';
5983: hr_utility.set_location(' Entering:'||l_proc, 5);
5984: end if;
5985: --
5986: hr_utility.set_location( p_param_2 || ' ' || p_param_val_2 , 5);
5987: for i in 1..g_subhead_rule_list.count
5988: loop
5989:
5990: hr_utility.set_location( 'formula id ' || g_subhead_rule_list(i) , 5);
5986: hr_utility.set_location( p_param_2 || ' ' || p_param_val_2 , 5);
5987: for i in 1..g_subhead_rule_list.count
5988: loop
5989:
5990: hr_utility.set_location( 'formula id ' || g_subhead_rule_list(i) , 5);
5991: l_outputs := benutils.formula
5992: (p_formula_id => g_subhead_rule_list(i)
5993: ,p_effective_date => p_effective_date
5994: ,p_business_group_id => p_business_group_id
6002: ,p_param4_value => p_param_val_2
6003: ,p_param5 => 'EXT_PROCESS_BUSINESS_GROUP'
6004: ,p_param5_value => to_char(ben_extract.g_proc_business_group_id)
6005: );
6006: hr_utility.set_location(' out of rl :'||l_outputs(l_outputs.first).value , 5);
6007: if l_outputs(l_outputs.first).value = 'Y' then
6008: if p_excld_flag = 'N' then
6009: raise g_include;
6010: else
6017: raise g_include;
6018: end if;
6019: --
6020: if g_debug then
6021: hr_utility.set_location(' Exiting:'||l_proc, 15);
6022: end if;
6023: --
6024: raise g_not_include;
6025: --
6069: Begin
6070: --
6071: if g_debug then
6072: l_proc := g_package||'chk_payroll_rule_incl';
6073: hr_utility.set_location(' Entering:'||l_proc, 5);
6074: end if;
6075:
6076: --
6077: open c_asg;
6083: for i in 1..g_payroll_rl_list.count
6084: loop
6085:
6086:
6087: hr_utility.set_location( 'formula id ' || g_payroll_rl_list(i) , 5);
6088: hr_utility.set_location( 'asg id ' || l_asg.assignment_id , 5);
6089: hr_utility.set_location( 'bg id ' || p_business_group_id , 5);
6090:
6091: l_outputs := benutils.formula
6084: loop
6085:
6086:
6087: hr_utility.set_location( 'formula id ' || g_payroll_rl_list(i) , 5);
6088: hr_utility.set_location( 'asg id ' || l_asg.assignment_id , 5);
6089: hr_utility.set_location( 'bg id ' || p_business_group_id , 5);
6090:
6091: l_outputs := benutils.formula
6092: (p_formula_id => g_payroll_rl_list(i)
6085:
6086:
6087: hr_utility.set_location( 'formula id ' || g_payroll_rl_list(i) , 5);
6088: hr_utility.set_location( 'asg id ' || l_asg.assignment_id , 5);
6089: hr_utility.set_location( 'bg id ' || p_business_group_id , 5);
6090:
6091: l_outputs := benutils.formula
6092: (p_formula_id => g_payroll_rl_list(i)
6093: ,p_effective_date => p_effective_date
6111: ,p_param8_value => to_char(p_element_entry_id )
6112: ,p_param9 => 'EXT_PROCESS_BUSINESS_GROUP'
6113: ,p_param9_value => to_char(ben_extract.g_proc_business_group_id)
6114: );
6115: hr_utility.set_location(' out of rl :'||l_outputs(l_outputs.first).value , 5);
6116: if l_outputs(l_outputs.first).value = 'Y' then
6117: if p_excld_flag = 'N' then
6118: raise g_include;
6119: else
6126: raise g_include;
6127: end if;
6128: --
6129: if g_debug then
6130: hr_utility.set_location(' Exiting:'||l_proc, 15);
6131: end if;
6132: --
6133: --
6134: raise g_not_include;
6175: l_proc varchar2(72);
6176: --
6177: Begin
6178: --
6179: g_debug := hr_utility.debug_enabled;
6180: if g_debug then
6181: l_proc := g_package||'evaluate_person_incl';
6182: hr_utility.set_location(' Entering:'||l_proc, 5);
6183: end if;
6178: --
6179: g_debug := hr_utility.debug_enabled;
6180: if g_debug then
6181: l_proc := g_package||'evaluate_person_incl';
6182: hr_utility.set_location(' Entering:'||l_proc, 5);
6183: end if;
6184: --
6185: p_include := 'Y';
6186: --
6298: p_actl_date => p_actl_date);
6299: end if;
6300: --
6301: if g_debug then
6302: hr_utility.set_location(' Exiting:'||l_proc, 15);
6303: end if;
6304: --
6305: Exception
6306: --
6340: l_proc varchar2(72);
6341: --
6342: Begin
6343: --
6344: g_debug := hr_utility.debug_enabled;
6345: if g_debug then
6346: l_proc := g_package||'evaluate_benefit_incl';
6347: hr_utility.set_location(' Entering:'||l_proc, 5);
6348: end if;
6343: --
6344: g_debug := hr_utility.debug_enabled;
6345: if g_debug then
6346: l_proc := g_package||'evaluate_benefit_incl';
6347: hr_utility.set_location(' Entering:'||l_proc, 5);
6348: end if;
6349: --
6350: p_include := 'Y';
6351: --
6457: p_excld_flag => g_enrt_dpnt_rltn_excld_flag);
6458: end if;
6459:
6460: if g_debug then
6461: hr_utility.set_location(' Exiting:'||l_proc, 15);
6462: end if;
6463: --
6464: Exception
6465: --
6496: l_proc varchar2(72);
6497: --
6498: Begin
6499: --
6500: g_debug := hr_utility.debug_enabled;
6501: if g_debug then
6502: l_proc := g_package||'evaluate_eligibility_incl';
6503: hr_utility.set_location(' Entering:'||l_proc, 5);
6504: end if;
6499: --
6500: g_debug := hr_utility.debug_enabled;
6501: if g_debug then
6502: l_proc := g_package||'evaluate_eligibility_incl';
6503: hr_utility.set_location(' Entering:'||l_proc, 5);
6504: end if;
6505: --
6506: p_include := 'Y';
6507: --
6512: end if;
6513:
6514: --
6515: if g_debug then
6516: hr_utility.set_location(' opt incl :'||g_elct_opt_excld_flag || p_elct_opt_id, 5);
6517: end if;
6518:
6519: if g_elct_opt_incl_rqd = 'Y' then
6520: chk_elct_opt_incl
6521: (p_opt_id => p_elct_opt_id,
6522: p_excld_flag => g_elct_opt_excld_flag);
6523: end if;
6524: if g_debug then
6525: hr_utility.set_location(' opt incl :'||g_elct_opt_incl_rqd, 6);
6526: end if;
6527:
6528: if g_elct_rg_plan_incl_rqd = 'Y' then
6529: chk_elct_rg_plan_incl
6590: p_excld_flag => g_elct_rltn_excld_flag);
6591: end if;
6592: --
6593: if g_debug then
6594: hr_utility.set_location(' Exiting:'||l_proc, 15);
6595: end if;
6596: --
6597: Exception
6598: --
6620: l_proc varchar2(72);
6621: --
6622: Begin
6623: --
6624: g_debug := hr_utility.debug_enabled;
6625: if g_debug then
6626: l_proc := g_package||'evaluate_change_log_incl';
6627: hr_utility.set_location(' Entering:'||l_proc, 5);
6628: end if;
6623: --
6624: g_debug := hr_utility.debug_enabled;
6625: if g_debug then
6626: l_proc := g_package||'evaluate_change_log_incl';
6627: hr_utility.set_location(' Entering:'||l_proc, 5);
6628: end if;
6629: --
6630: p_include := 'Y';
6631: --
6655: p_excld_flag => g_chg_login_excld_flag);
6656: end if;
6657: --
6658: if g_debug then
6659: hr_utility.set_location(' Exiting:'||l_proc, 15);
6660: end if;
6661: --
6662: Exception
6663: --
6685: l_proc varchar2(72);
6686: --
6687: Begin
6688: --
6689: g_debug := hr_utility.debug_enabled;
6690: if g_debug then
6691: l_proc := g_package||'evaluate_comm_incl';
6692: hr_utility.set_location(' Entering:'||l_proc, 5);
6693: end if;
6688: --
6689: g_debug := hr_utility.debug_enabled;
6690: if g_debug then
6691: l_proc := g_package||'evaluate_comm_incl';
6692: hr_utility.set_location(' Entering:'||l_proc, 5);
6693: end if;
6694: --
6695: p_include := 'Y';
6696: --
6724: p_excld_flag => g_cm_to_be_sent_dt_excld_flag);
6725: end if;
6726: --
6727: if g_debug then
6728: hr_utility.set_location(' Exiting:'||l_proc, 15);
6729: end if;
6730: --
6731: Exception
6732: --
6756: l_proc varchar2(72);
6757: --
6758: Begin
6759: --
6760: g_debug := hr_utility.debug_enabled;
6761: if g_debug then
6762: l_proc := g_package||'evaluate_prem_incl';
6763: hr_utility.set_location(' Entering:'||l_proc, 5);
6764: end if;
6759: --
6760: g_debug := hr_utility.debug_enabled;
6761: if g_debug then
6762: l_proc := g_package||'evaluate_prem_incl';
6763: hr_utility.set_location(' Entering:'||l_proc, 5);
6764: end if;
6765: --
6766: p_include := 'Y';
6767: --
6780: p_excld_flag => g_prem_month_year_excld_flag) ;
6781: end if;
6782: --
6783: if g_debug then
6784: hr_utility.set_location(' Exiting:'||l_proc, 15);
6785: end if;
6786: --
6787: Exception
6788: --
6818: l_proc varchar2(72);
6819: --
6820: Begin
6821: --
6822: g_debug := hr_utility.debug_enabled;
6823: if g_debug then
6824: l_proc := g_package||'evaluate_elm_entry_incl';
6825: hr_utility.set_location(' Entering:'||l_proc, 5);
6826: end if;
6821: --
6822: g_debug := hr_utility.debug_enabled;
6823: if g_debug then
6824: l_proc := g_package||'evaluate_elm_entry_incl';
6825: hr_utility.set_location(' Entering:'||l_proc, 5);
6826: end if;
6827: --
6828: p_include := 'Y';
6829:
6832: -- the pay period date is not sent as parameter
6833: -- validated only for run result
6834: if p_pay_period_date is not null then
6835: if g_debug then
6836: hr_utility.set_location(' calling chk_payroll_end_date_incl '||p_pay_period_date, 51);
6837: hr_utility.set_location(' effective date '||p_effective_date, 51);
6838: end if;
6839: chk_payroll_end_date_incl
6840: (p_pay_end_date => p_pay_period_date,
6833: -- validated only for run result
6834: if p_pay_period_date is not null then
6835: if g_debug then
6836: hr_utility.set_location(' calling chk_payroll_end_date_incl '||p_pay_period_date, 51);
6837: hr_utility.set_location(' effective date '||p_effective_date, 51);
6838: end if;
6839: chk_payroll_end_date_incl
6840: (p_pay_end_date => p_pay_period_date,
6841: p_effective_date => p_effective_date,
6874: end if;
6875: end loop;
6876: --
6877: if g_debug then
6878: hr_utility.set_location(' Exiting:'||l_proc, 15);
6879: end if;
6880: --
6881: if g_ele_input_excld_flag = 'Y' then
6882: raise g_include;
6886: --
6887: end if;
6888:
6889: if g_debug then
6890: hr_utility.set_location(' Exiting:'||l_proc, 15);
6891: end if;
6892: --
6893:
6894: --
6917: l_proc varchar2(72);
6918: --
6919: Begin
6920: --
6921: g_debug := hr_utility.debug_enabled;
6922: if g_debug then
6923: l_proc := g_package||'evaluate_action_item_incl';
6924: hr_utility.set_location(' Entering:'||l_proc, 5);
6925: end if;
6920: --
6921: g_debug := hr_utility.debug_enabled;
6922: if g_debug then
6923: l_proc := g_package||'evaluate_action_item_incl';
6924: hr_utility.set_location(' Entering:'||l_proc, 5);
6925: end if;
6926: --
6927: p_include := 'Y';
6928: --
6937: p_excld_flag => g_actn_item_rltn_excld_flag);
6938: end if;
6939: --
6940: if g_debug then
6941: hr_utility.set_location(' Exiting:'||l_proc, 15);
6942: end if;
6943: --
6944: Exception
6945: --
6962:
6963: begin
6964:
6965:
6966: g_debug := hr_utility.debug_enabled;
6967: if g_debug then
6968: l_proc := g_package||'Evaluate_cwb_incl';
6969: hr_utility.set_location(' Entering:'||l_proc, 5);
6970: end if;
6965:
6966: g_debug := hr_utility.debug_enabled;
6967: if g_debug then
6968: l_proc := g_package||'Evaluate_cwb_incl';
6969: hr_utility.set_location(' Entering:'||l_proc, 5);
6970: end if;
6971:
6972: p_include := 'Y';
6973: if g_cwb_pl_prd_rqd = 'Y' then
6980: end if ;
6981:
6982: --
6983: if g_debug then
6984: hr_utility.set_location(' Exiting:'||l_proc, 15);
6985: end if;
6986: --
6987: Exception
6988: --
7018: l_rl_param2 varchar2(100) ;
7019: l_rl_param2_value varchar2(100) ;
7020: begin
7021:
7022: g_debug := hr_utility.debug_enabled;
7023: if g_debug then
7024: l_proc := g_package||'Evaluate_subhead_incl';
7025: hr_utility.set_location(' Entering:'||l_proc, 5);
7026: end if;
7021:
7022: g_debug := hr_utility.debug_enabled;
7023: if g_debug then
7024: l_proc := g_package||'Evaluate_subhead_incl';
7025: hr_utility.set_location(' Entering:'||l_proc, 5);
7026: end if;
7027:
7028: p_include := 'Y';
7029:
7122:
7123:
7124:
7125: if g_debug then
7126: hr_utility.set_location(' Exiting:'||l_proc, 15);
7127: end if;
7128:
7129: Exception
7130: --
7130: --
7131: when g_not_include then
7132: p_include := 'N';
7133: if g_debug then
7134: hr_utility.set_location(' Exiting:'||l_proc, 5);
7135: end if ;
7136: --
7137:
7138: end ;
7160: l_proc varchar2(72);
7161: --
7162: Begin
7163: --
7164: g_debug := hr_utility.debug_enabled;
7165: if g_debug then
7166: l_proc := g_package||'evaluate_timecard_incl';
7167: hr_utility.set_location(' Entering:'||l_proc, 5);
7168: end if;
7163: --
7164: g_debug := hr_utility.debug_enabled;
7165: if g_debug then
7166: l_proc := g_package||'evaluate_timecard_incl';
7167: hr_utility.set_location(' Entering:'||l_proc, 5);
7168: end if;
7169:
7170: p_include := 'Y';
7171:
7233: END IF; -- p_otl_lvl
7234:
7235:
7236: if g_debug then
7237: hr_utility.set_location(' Exiting:'||l_proc, 15);
7238: end if;
7239: --
7240: Exception
7241: --