29: and p_effective_date between per.EFFECTIVE_START_DATE and per.EFFECTIVE_END_DATE;
30: --
31: Begin
32: --
33: hr_utility.set_location('Entering:'||l_proc, 5);
34: --
35: open c_person;
36: fetch c_person into l_person_name;
37: close c_person;
37: close c_person;
38: --
39: p_person_name := l_person_name;
40: --
41: hr_utility.set_location('Leaving:'||l_proc, 10);
42: --
43: End person_details;
44: --
45:
90: l_person_name per_all_people_f.full_name%type;
91: --
92: Begin
93: --
94: hr_utility.set_location('Entering:'||l_proc, 5);
95: hr_utility.set_location('p_val: '||p_val, 5);
96: hr_utility.set_location('p_iss_val: '||p_iss_val, 5);
97: hr_utility.set_location('p_mx_elcn_val:'||p_mx_elcn_val, 5);
98: hr_utility.set_location('p_mn_elcn_val:'||p_mn_elcn_val, 5);
91: --
92: Begin
93: --
94: hr_utility.set_location('Entering:'||l_proc, 5);
95: hr_utility.set_location('p_val: '||p_val, 5);
96: hr_utility.set_location('p_iss_val: '||p_iss_val, 5);
97: hr_utility.set_location('p_mx_elcn_val:'||p_mx_elcn_val, 5);
98: hr_utility.set_location('p_mn_elcn_val:'||p_mn_elcn_val, 5);
99: hr_utility.set_location('p_incrmt_elcn_val:'||p_incrmt_elcn_val, 5);
92: Begin
93: --
94: hr_utility.set_location('Entering:'||l_proc, 5);
95: hr_utility.set_location('p_val: '||p_val, 5);
96: hr_utility.set_location('p_iss_val: '||p_iss_val, 5);
97: hr_utility.set_location('p_mx_elcn_val:'||p_mx_elcn_val, 5);
98: hr_utility.set_location('p_mn_elcn_val:'||p_mn_elcn_val, 5);
99: hr_utility.set_location('p_incrmt_elcn_val:'||p_incrmt_elcn_val, 5);
100: hr_utility.set_location('l_person_name:'||l_person_name, 5);
93: --
94: hr_utility.set_location('Entering:'||l_proc, 5);
95: hr_utility.set_location('p_val: '||p_val, 5);
96: hr_utility.set_location('p_iss_val: '||p_iss_val, 5);
97: hr_utility.set_location('p_mx_elcn_val:'||p_mx_elcn_val, 5);
98: hr_utility.set_location('p_mn_elcn_val:'||p_mn_elcn_val, 5);
99: hr_utility.set_location('p_incrmt_elcn_val:'||p_incrmt_elcn_val, 5);
100: hr_utility.set_location('l_person_name:'||l_person_name, 5);
101: --
94: hr_utility.set_location('Entering:'||l_proc, 5);
95: hr_utility.set_location('p_val: '||p_val, 5);
96: hr_utility.set_location('p_iss_val: '||p_iss_val, 5);
97: hr_utility.set_location('p_mx_elcn_val:'||p_mx_elcn_val, 5);
98: hr_utility.set_location('p_mn_elcn_val:'||p_mn_elcn_val, 5);
99: hr_utility.set_location('p_incrmt_elcn_val:'||p_incrmt_elcn_val, 5);
100: hr_utility.set_location('l_person_name:'||l_person_name, 5);
101: --
102: person_details(p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id
95: hr_utility.set_location('p_val: '||p_val, 5);
96: hr_utility.set_location('p_iss_val: '||p_iss_val, 5);
97: hr_utility.set_location('p_mx_elcn_val:'||p_mx_elcn_val, 5);
98: hr_utility.set_location('p_mn_elcn_val:'||p_mn_elcn_val, 5);
99: hr_utility.set_location('p_incrmt_elcn_val:'||p_incrmt_elcn_val, 5);
100: hr_utility.set_location('l_person_name:'||l_person_name, 5);
101: --
102: person_details(p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id
103: ,p_effective_date => p_effective_date
96: hr_utility.set_location('p_iss_val: '||p_iss_val, 5);
97: hr_utility.set_location('p_mx_elcn_val:'||p_mx_elcn_val, 5);
98: hr_utility.set_location('p_mn_elcn_val:'||p_mn_elcn_val, 5);
99: hr_utility.set_location('p_incrmt_elcn_val:'||p_incrmt_elcn_val, 5);
100: hr_utility.set_location('l_person_name:'||l_person_name, 5);
101: --
102: person_details(p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id
103: ,p_effective_date => p_effective_date
104: ,p_person_name => l_person_name);
102: person_details(p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id
103: ,p_effective_date => p_effective_date
104: ,p_person_name => l_person_name);
105:
106: hr_utility.set_location('l_person_name:'||l_person_name, 5);
107: --
108: if (p_val is not null and p_val <> hr_api.g_number)and
109: (p_mx_elcn_val is not null and p_mx_elcn_val <> hr_api.g_number)
110: then
208: end if;
209: --
210: end if;
211: --
212: hr_utility.set_location('Leaving:'||l_proc, 10);
213: --
214: End chk_perf_min_max;
215: --
216: -- ----------------------------------------------------------------------------
321: l_object_version_number ben_enrt_rt.object_version_number%TYPE;
322: --
323: begin
324: --
325: hr_utility.set_location('Entering:'|| l_proc, 10);
326: --
327: -- Issue a savepoint if operating in validation only mode
328: --
329: savepoint create_Enrollment_Rate;
327: -- Issue a savepoint if operating in validation only mode
328: --
329: savepoint create_Enrollment_Rate;
330: --
331: hr_utility.set_location(l_proc, 20);
332: --
333: -- Process Logic
334: --
335: begin
645: -- End of API User Hook for the after hook of create_Enrollment_Rate
646: --
647: end;
648: --
649: hr_utility.set_location(l_proc, 60);
650: --
651: -- When in validation only mode raise the Validate_Enabled exception
652: --
653: if p_validate then
658: --
659: p_enrt_rt_id := l_enrt_rt_id;
660: p_object_version_number := l_object_version_number;
661: --
662: hr_utility.set_location(' Leaving:'||l_proc, 70);
663: --
664: exception
665: --
666: when hr_api.validate_enabled then
675: -- when validation only mode is being used.)
676: --
677: p_enrt_rt_id := null;
678: p_object_version_number := null;
679: hr_utility.set_location(' Leaving:'||l_proc, 80);
680: --
681: when others then
682: --
683: -- A validation or unexpected error has occured
685: ROLLBACK TO create_Enrollment_Rate;
686: --
687: p_enrt_rt_id := null;
688: p_object_version_number := null;
689: hr_utility.set_location(' Leaving:'||l_proc, 80);
690: --
691: raise;
692: --
693: end create_Enrollment_Rate;
812: l_minmax_rec ben_batch_dt_api.gtyp_dtsum_row;
813: --
814: begin
815: --
816: hr_utility.set_location('Entering:'|| l_proc, 10);
817: --
818: -- Issue a savepoint if operating in validation only mode
819: --
820: savepoint create_perf_Enrollment_Rate;
828: ben_ecr_shd.g_api_dml := true; -- Set the api dml status
829: --
830: -- Select the next sequence number
831: --
832: hr_utility.set_location('Insert ECR: '||l_proc, 5);
833: insert into ben_enrt_rt
834: (enrt_rt_id
835: ,ordr_num
836: ,acty_typ_cd
1023: ,p_program_id
1024: ,p_program_update_date
1025: ,l_object_version_number
1026: ) RETURNING enrt_rt_id into l_enrt_rt_id;
1027: hr_utility.set_location('Dn Insert: '||l_proc, 5);
1028: --
1029: ben_ecr_shd.g_api_dml := false; -- Unset the api dml status
1030: --
1031: -- When in validation only mode raise the Validate_Enabled exception
1038: --
1039: p_enrt_rt_id := l_enrt_rt_id;
1040: p_object_version_number := l_object_version_number;
1041: --
1042: hr_utility.set_location(' Leaving:'||l_proc, 70);
1043: --
1044: exception
1045: --
1046: when hr_api.validate_enabled then
1055: -- when validation only mode is being used.)
1056: --
1057: p_enrt_rt_id := null;
1058: p_object_version_number := null;
1059: hr_utility.set_location(' Leaving:'||l_proc, 80);
1060: --
1061: when others then
1062: --
1063: -- A validation or unexpected error has occured
1065: ROLLBACK TO create_perf_Enrollment_Rate;
1066: --
1067: p_enrt_rt_id := null;
1068: p_object_version_number := null;
1069: hr_utility.set_location(' Leaving:'||l_proc, 80);
1070: --
1071: raise;
1072: --
1073: end create_perf_Enrollment_Rate;
1261: open c_abr(p_acty_base_rt_id) ;
1262: fetch c_abr into l_rate_periodization_rl ;
1263: close c_abr;
1264: --
1265: hr_utility.set_location(' p_val '||p_val ,99);
1266: hr_utility.set_location(' p_old_val'||p_old_val ,99);
1267: hr_utility.set_location(' p_ann_val '||p_ann_val ,99);
1268: hr_utility.set_location(' p_old_ann_val '||p_old_ann_val ,99);
1269: hr_utility.set_location(' p_cmcd_val '||p_cmcd_val ,99);
1262: fetch c_abr into l_rate_periodization_rl ;
1263: close c_abr;
1264: --
1265: hr_utility.set_location(' p_val '||p_val ,99);
1266: hr_utility.set_location(' p_old_val'||p_old_val ,99);
1267: hr_utility.set_location(' p_ann_val '||p_ann_val ,99);
1268: hr_utility.set_location(' p_old_ann_val '||p_old_ann_val ,99);
1269: hr_utility.set_location(' p_cmcd_val '||p_cmcd_val ,99);
1270: --
1263: close c_abr;
1264: --
1265: hr_utility.set_location(' p_val '||p_val ,99);
1266: hr_utility.set_location(' p_old_val'||p_old_val ,99);
1267: hr_utility.set_location(' p_ann_val '||p_ann_val ,99);
1268: hr_utility.set_location(' p_old_ann_val '||p_old_ann_val ,99);
1269: hr_utility.set_location(' p_cmcd_val '||p_cmcd_val ,99);
1270: --
1271: IF p_rt_typ_cd = 'PCT' then
1264: --
1265: hr_utility.set_location(' p_val '||p_val ,99);
1266: hr_utility.set_location(' p_old_val'||p_old_val ,99);
1267: hr_utility.set_location(' p_ann_val '||p_ann_val ,99);
1268: hr_utility.set_location(' p_old_ann_val '||p_old_ann_val ,99);
1269: hr_utility.set_location(' p_cmcd_val '||p_cmcd_val ,99);
1270: --
1271: IF p_rt_typ_cd = 'PCT' then
1272: --
1265: hr_utility.set_location(' p_val '||p_val ,99);
1266: hr_utility.set_location(' p_old_val'||p_old_val ,99);
1267: hr_utility.set_location(' p_ann_val '||p_ann_val ,99);
1268: hr_utility.set_location(' p_old_ann_val '||p_old_ann_val ,99);
1269: hr_utility.set_location(' p_cmcd_val '||p_cmcd_val ,99);
1270: --
1271: IF p_rt_typ_cd = 'PCT' then
1272: --
1273: if p_entr_ann_val_flag = 'Y' then
1300: --
1301: if p_ann_val <> p_old_ann_val then
1302: --
1303: -- use ann_val to drive other values
1304: hr_utility.set_location( 'Annula Flag = Y ' ,99);
1305: --
1306: l_ann_val := p_ann_val ;
1307: --GEVITY
1308: IF l_rate_periodization_rl IS NOT NULL THEN
1355: -- p_complete_year_flag => 'Y',
1356: p_payroll_id => l_payroll_id);
1357: --
1358: END IF; --GEVITY
1359: hr_utility.set_location('l_calc_ann_val '||to_char(l_calc_ann_val), 319);
1360: hr_utility.set_location('p_cmcd_acty_ref_perd_cd '||p_cmcd_acty_ref_perd_cd, 319);
1361: hr_utility.set_location('l_cmcd_val '||l_cmcd_val , 319);
1362: --
1363: end if;
1356: p_payroll_id => l_payroll_id);
1357: --
1358: END IF; --GEVITY
1359: hr_utility.set_location('l_calc_ann_val '||to_char(l_calc_ann_val), 319);
1360: hr_utility.set_location('p_cmcd_acty_ref_perd_cd '||p_cmcd_acty_ref_perd_cd, 319);
1361: hr_utility.set_location('l_cmcd_val '||l_cmcd_val , 319);
1362: --
1363: end if;
1364: --
1357: --
1358: END IF; --GEVITY
1359: hr_utility.set_location('l_calc_ann_val '||to_char(l_calc_ann_val), 319);
1360: hr_utility.set_location('p_cmcd_acty_ref_perd_cd '||p_cmcd_acty_ref_perd_cd, 319);
1361: hr_utility.set_location('l_cmcd_val '||l_cmcd_val , 319);
1362: --
1363: end if;
1364: --
1365: else
1399: p_complete_year_flag => 'Y',
1400: p_payroll_id => l_payroll_id);
1401:
1402: --
1403: hr_utility.set_location( ' l_ann_val '||l_ann_val,99);
1404: hr_utility.set_location( ' l_payroll_id '||l_payroll_id,99);
1405: hr_utility.set_location( ' p_effective_date '||p_effective_date ,99);
1406: hr_utility.set_location( ' p_elig_per_elctbl_chc_id '||p_elig_per_elctbl_chc_id,99);
1407: --
1400: p_payroll_id => l_payroll_id);
1401:
1402: --
1403: hr_utility.set_location( ' l_ann_val '||l_ann_val,99);
1404: hr_utility.set_location( ' l_payroll_id '||l_payroll_id,99);
1405: hr_utility.set_location( ' p_effective_date '||p_effective_date ,99);
1406: hr_utility.set_location( ' p_elig_per_elctbl_chc_id '||p_elig_per_elctbl_chc_id,99);
1407: --
1408: l_cmcd_val := ben_distribute_rates.annual_to_period
1401:
1402: --
1403: hr_utility.set_location( ' l_ann_val '||l_ann_val,99);
1404: hr_utility.set_location( ' l_payroll_id '||l_payroll_id,99);
1405: hr_utility.set_location( ' p_effective_date '||p_effective_date ,99);
1406: hr_utility.set_location( ' p_elig_per_elctbl_chc_id '||p_elig_per_elctbl_chc_id,99);
1407: --
1408: l_cmcd_val := ben_distribute_rates.annual_to_period
1409: (p_amount => l_ann_val,
1402: --
1403: hr_utility.set_location( ' l_ann_val '||l_ann_val,99);
1404: hr_utility.set_location( ' l_payroll_id '||l_payroll_id,99);
1405: hr_utility.set_location( ' p_effective_date '||p_effective_date ,99);
1406: hr_utility.set_location( ' p_elig_per_elctbl_chc_id '||p_elig_per_elctbl_chc_id,99);
1407: --
1408: l_cmcd_val := ben_distribute_rates.annual_to_period
1409: (p_amount => l_ann_val,
1410: p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
1422: --
1423: end if; -- PCT
1424: --
1425: --
1426: hr_utility.set_location(' l_val '||l_val ,99);
1427: hr_utility.set_location(' l_old_val'||p_old_val ,99);
1428: hr_utility.set_location(' l_ann_val '||l_ann_val ,99);
1429: hr_utility.set_location(' l_old_ann_val '||p_old_ann_val ,99);
1430: hr_utility.set_location(' l_cmcd_val '||l_cmcd_val ,99);
1423: end if; -- PCT
1424: --
1425: --
1426: hr_utility.set_location(' l_val '||l_val ,99);
1427: hr_utility.set_location(' l_old_val'||p_old_val ,99);
1428: hr_utility.set_location(' l_ann_val '||l_ann_val ,99);
1429: hr_utility.set_location(' l_old_ann_val '||p_old_ann_val ,99);
1430: hr_utility.set_location(' l_cmcd_val '||l_cmcd_val ,99);
1431: --
1424: --
1425: --
1426: hr_utility.set_location(' l_val '||l_val ,99);
1427: hr_utility.set_location(' l_old_val'||p_old_val ,99);
1428: hr_utility.set_location(' l_ann_val '||l_ann_val ,99);
1429: hr_utility.set_location(' l_old_ann_val '||p_old_ann_val ,99);
1430: hr_utility.set_location(' l_cmcd_val '||l_cmcd_val ,99);
1431: --
1432:
1425: --
1426: hr_utility.set_location(' l_val '||l_val ,99);
1427: hr_utility.set_location(' l_old_val'||p_old_val ,99);
1428: hr_utility.set_location(' l_ann_val '||l_ann_val ,99);
1429: hr_utility.set_location(' l_old_ann_val '||p_old_ann_val ,99);
1430: hr_utility.set_location(' l_cmcd_val '||l_cmcd_val ,99);
1431: --
1432:
1433: ben_Enrollment_Rate_api.update_Enrollment_Rate
1426: hr_utility.set_location(' l_val '||l_val ,99);
1427: hr_utility.set_location(' l_old_val'||p_old_val ,99);
1428: hr_utility.set_location(' l_ann_val '||l_ann_val ,99);
1429: hr_utility.set_location(' l_old_ann_val '||p_old_ann_val ,99);
1430: hr_utility.set_location(' l_cmcd_val '||l_cmcd_val ,99);
1431: --
1432:
1433: ben_Enrollment_Rate_api.update_Enrollment_Rate
1434: (
1645: l_object_version_number ben_enrt_rt.object_version_number%TYPE;
1646: --
1647: begin
1648: --
1649: hr_utility.set_location('Entering:'|| l_proc, 10);
1650: --
1651: -- Issue a savepoint if operating in validation only mode
1652: --
1653: savepoint update_Enrollment_Rate;
1651: -- Issue a savepoint if operating in validation only mode
1652: --
1653: savepoint update_Enrollment_Rate;
1654: --
1655: hr_utility.set_location(l_proc, 20);
1656: --
1657: -- Process Logic
1658: --
1659: l_object_version_number := p_object_version_number;
2005: -- End of API User Hook for the after hook of update_Enrollment_Rate
2006: --
2007: end;
2008: --
2009: hr_utility.set_location(l_proc, 60);
2010: --
2011: -- When in validation only mode raise the Validate_Enabled exception
2012: --
2013: if p_validate then
2017: -- Set all output arguments
2018: --
2019: -- p_object_version_number := l_object_version_number;
2020: --
2021: hr_utility.set_location(' Leaving:'||l_proc, 70);
2022: --
2023: exception
2024: --
2025: when hr_api.validate_enabled then
2032: -- Only set output warning arguments
2033: -- (Any key or derived arguments must be set to null
2034: -- when validation only mode is being used.)
2035: --
2036: hr_utility.set_location(' Leaving:'||l_proc, 80);
2037: --
2038: when others then
2039: --
2040: -- A validation or unexpected error has occured
2041: --
2042: ROLLBACK TO update_Enrollment_Rate;
2043: --
2044: p_object_version_number := l_object_version_number;
2045: hr_utility.set_location(' Leaving:'||l_proc, 80);
2046: --
2047: raise;
2048: --
2049: end update_Enrollment_Rate;
2064: l_object_version_number ben_enrt_rt.object_version_number%TYPE;
2065: --
2066: begin
2067: --
2068: hr_utility.set_location('Entering:'|| l_proc, 10);
2069: --
2070: -- Issue a savepoint if operating in validation only mode
2071: --
2072: savepoint delete_Enrollment_Rate;
2070: -- Issue a savepoint if operating in validation only mode
2071: --
2072: savepoint delete_Enrollment_Rate;
2073: --
2074: hr_utility.set_location(l_proc, 20);
2075: --
2076: -- Process Logic
2077: --
2078: l_object_version_number := p_object_version_number;
2126: -- End of API User Hook for the after hook of delete_Enrollment_Rate
2127: --
2128: end;
2129: --
2130: hr_utility.set_location(l_proc, 60);
2131: --
2132: -- When in validation only mode raise the Validate_Enabled exception
2133: --
2134: if p_validate then
2134: if p_validate then
2135: raise hr_api.validate_enabled;
2136: end if;
2137: --
2138: hr_utility.set_location(' Leaving:'||l_proc, 70);
2139: --
2140: exception
2141: --
2142: when hr_api.validate_enabled then
2157: --
2158: ROLLBACK TO delete_Enrollment_Rate;
2159: --
2160: p_object_version_number := l_object_version_number;
2161: hr_utility.set_location(' Leaving:'||l_proc, 80);
2162: --
2163: raise;
2164: --
2165: end delete_Enrollment_Rate;
2180: l_proc varchar2(72) := g_package||'lck';
2181: --
2182: begin
2183: --
2184: hr_utility.set_location('Entering:'|| l_proc, 10);
2185: --
2186: ben_ecr_shd.lck
2187: (
2188: p_enrt_rt_id => p_enrt_rt_id
2188: p_enrt_rt_id => p_enrt_rt_id
2189: ,p_object_version_number => p_object_version_number
2190: );
2191: --
2192: hr_utility.set_location(' Leaving:'||l_proc, 70);
2193: --
2194: end lck;
2195: --
2196: end ben_Enrollment_Rate_api;