[Home] [Help]
151: ,p_effective_date in date
152: ,p_period_of_service_id in number
153: ,p_object_version_number in out nocopy number
154: ,p_actual_termination_date in date
155: ,p_last_standard_process_date in out nocopy date
156: ,p_person_type_id in number default hr_api.g_number
157: ,p_assignment_status_type_id in number default hr_api.g_number
158: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
159: ,p_supervisor_warning out nocopy boolean
176: begin
177:
178: hr_utility.set_location('Entering '||l_proc,10);
179:
180: if p_last_standard_process_date is null
181: then
182: /* No LSPD has been passed. To preserve the previous
183: ** behaviour we need to pass g_date to the latest ATE API.
184: */
185: l_last_std_process_date_in := hr_api.g_date;
186: else
187: /* Otherwise pass through the value provided.
188: */
189: l_last_std_process_date_in := p_last_standard_process_date;
190: end if;
191:
192: actual_termination_emp(
193: p_validate => p_validate
194: ,p_effective_date => p_effective_date
195: ,p_period_of_service_id => p_period_of_service_id
196: ,p_object_version_number => p_object_version_number
197: ,p_actual_termination_date => p_actual_termination_date
198: ,p_last_standard_process_date => l_last_std_process_date_in
199: ,p_person_type_id => p_person_type_id
200: ,p_assignment_status_type_id => p_assignment_status_type_id
201: ,p_leaving_reason => p_leaving_reason
202: ,p_last_std_process_date_out => l_last_std_process_date_out
210: ,p_pay_proposal_warning => p_pay_proposal_warning
211: ,p_dod_warning => p_dod_warning
212: ,p_alu_change_warning => l_alu_change_warning);
213:
214: p_last_standard_process_date := l_last_std_process_date_out;
215:
216: hr_utility.set_location('Leaving '||l_proc,40);
217:
218: end actual_termination_emp;
228: ,p_effective_date in date
229: ,p_period_of_service_id in number
230: ,p_object_version_number in out nocopy number
231: ,p_actual_termination_date in date
232: ,p_last_standard_process_date in out nocopy date
233: ,p_person_type_id in number default hr_api.g_number
234: ,p_assignment_status_type_id in number default hr_api.g_number
235: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
236: --
267: begin
268:
269: hr_utility.set_location('Entering '||l_proc,10);
270:
271: if p_last_standard_process_date is null
272: then
273: /* No LSPD has been passed. To preserve the previous
274: ** behaviour we need to pass g_date to the latest ATE API.
275: */
276: l_last_std_process_date_in := hr_api.g_date;
277: else
278: /* Otherwise pass through the value provided.
279: */
280: l_last_std_process_date_in := p_last_standard_process_date;
281: end if;
282:
283: actual_termination_emp(
284: p_validate => p_validate
285: ,p_effective_date => p_effective_date
286: ,p_period_of_service_id => p_period_of_service_id
287: ,p_object_version_number => p_object_version_number
288: ,p_actual_termination_date => p_actual_termination_date
289: ,p_last_standard_process_date => l_last_std_process_date_in
290: ,p_person_type_id => p_person_type_id
291: ,p_assignment_status_type_id => p_assignment_status_type_id
292: ,p_leaving_reason => p_leaving_reason
293: --
317: --
318: -- 120.2 (END)
319: --
320:
321: p_last_standard_process_date := l_last_std_process_date_out;
322:
323: hr_utility.set_location('Leaving '||l_proc,40);
324:
325: end actual_termination_emp;
336: ,p_effective_date in date
337: ,p_period_of_service_id in number
338: ,p_object_version_number in out nocopy number
339: ,p_actual_termination_date in date
340: ,p_last_standard_process_date in date default hr_api.g_date
341: ,p_person_type_id in number default hr_api.g_number
342: ,p_assignment_status_type_id in number default hr_api.g_number
343: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
344: ,p_attribute_category in varchar2 default hr_api.g_varchar2
414: ,p_effective_date => p_effective_date
415: ,p_period_of_service_id => p_period_of_service_id
416: ,p_object_version_number => p_object_version_number
417: ,p_actual_termination_date => p_actual_termination_date
418: ,p_last_standard_process_date => p_last_standard_process_date
419: ,p_person_type_id => p_person_type_id
420: ,p_assignment_status_type_id => p_assignment_status_type_id
421: ,p_leaving_reason => p_leaving_reason
422: ,p_attribute_category => p_attribute_category
501: ,p_effective_date in date
502: ,p_period_of_service_id in number
503: ,p_object_version_number in out nocopy number
504: ,p_actual_termination_date in date
505: ,p_last_standard_process_date in date default hr_api.g_date
506: ,p_person_type_id in number default hr_api.g_number
507: ,p_assignment_status_type_id in number default hr_api.g_number
508: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
509: --
592: l_asg_future_changes_warning boolean := FALSE;
593: l_entries_changed_warning varchar2(1) := 'N';
594: l_event_warning boolean := FALSE;
595: l_interview_warning boolean := FALSE;
596: l_last_standard_process_date per_periods_of_service.last_standard_process_date%TYPE;
597: l_last_std_process_date_in per_periods_of_service.last_standard_process_date%TYPE;
598: l_pds_object_version_number per_assignments_f.object_version_number%TYPE;
599: l_ovn per_assignments_f.object_version_number%TYPE := p_object_version_number;
600: l_recruiter_warning boolean := FALSE;
593: l_entries_changed_warning varchar2(1) := 'N';
594: l_event_warning boolean := FALSE;
595: l_interview_warning boolean := FALSE;
596: l_last_standard_process_date per_periods_of_service.last_standard_process_date%TYPE;
597: l_last_std_process_date_in per_periods_of_service.last_standard_process_date%TYPE;
598: l_pds_object_version_number per_assignments_f.object_version_number%TYPE;
599: l_ovn per_assignments_f.object_version_number%TYPE := p_object_version_number;
600: l_recruiter_warning boolean := FALSE;
601: l_review_warning boolean := FALSE;
652: l_person_type_usage_id per_person_type_usages_f.person_type_usage_id%TYPE;
653: l_action_chk VARCHAR2(1) := 'N';
654:
655: l_saved_atd per_periods_of_service.actual_termination_date%TYPE;
656: l_saved_lspd per_periods_of_service.last_standard_process_date%TYPE;
657: --
658:
659: cursor csr_future_per_changes is
660: select null
680: , per.object_version_number
681: , pet.system_person_type
682: , per.npw_number
683: , pds.actual_termination_date
684: , pds.last_standard_process_date
685: from per_all_people_f per
686: , per_business_groups bus
687: , per_periods_of_service pds
688: , per_person_types pet
769: --
770: -- Initialise local varaibles
771: --
772: l_assignment_status_type_id := p_assignment_status_type_id;
773: l_last_standard_process_date := trunc(p_last_standard_process_date);
774: l_last_std_process_date_in := l_last_standard_process_date;
775: l_pds_object_version_number := p_object_version_number;
776: l_person_type_id := p_person_type_id;
777: l_actual_termination_date := trunc(p_actual_termination_date);
770: -- Initialise local varaibles
771: --
772: l_assignment_status_type_id := p_assignment_status_type_id;
773: l_last_standard_process_date := trunc(p_last_standard_process_date);
774: l_last_std_process_date_in := l_last_standard_process_date;
775: l_pds_object_version_number := p_object_version_number;
776: l_person_type_id := p_person_type_id;
777: l_actual_termination_date := trunc(p_actual_termination_date);
778: l_effective_date := trunc(p_effective_date);
896: (p_effective_date => l_effective_date
897: ,p_period_of_service_id => p_period_of_service_id
898: ,p_object_version_number => p_object_version_number
899: ,p_actual_termination_date => l_actual_termination_date
900: ,p_last_standard_process_date => l_last_standard_process_date
901: ,p_person_type_id => p_person_type_id
902: ,p_assignment_status_type_id => p_assignment_status_type_id
903: ,p_business_group_id => l_business_group_id
904: ,p_attribute_category => p_attribute_category
966: --
967: hr_utility.set_location(l_proc, 50);
968: hr_utility.set_location('Saved ATD: '||l_saved_atd, 51);
969: hr_utility.set_location('Saved LSPD: '||l_saved_lspd, 51);
970: hr_utility.set_location('Passed LSPD: '||l_last_standard_process_date, 51);
971: --
972: -- Determine if we are setting LSPD as a separate call to the API. i.e. ATD
973: -- has already been saved with a null LSPD,
974: --
973: -- has already been saved with a null LSPD,
974: --
975: if l_saved_atd is not null and
976: l_saved_lspd is null and
977: l_last_standard_process_date is not null then
978: --
979: -- We are processing a save to LSPD as a separate call to this API.
980: --
981: if p_last_standard_process_date = hr_api.g_date
977: l_last_standard_process_date is not null then
978: --
979: -- We are processing a save to LSPD as a separate call to this API.
980: --
981: if p_last_standard_process_date = hr_api.g_date
982: then
983: hr_utility.set_location(l_proc, 60);
984: --
985: -- Last standard process date is the default value i.e.
981: if p_last_standard_process_date = hr_api.g_date
982: then
983: hr_utility.set_location(l_proc, 60);
984: --
985: -- Last standard process date is the default value i.e.
986: -- it was not passed to the API => derive it.
987: --
988: -- Find the max tpe end date of any payrolls that are assigned.
989: --
1015: then
1016: --
1017: hr_utility.set_location(l_proc, 90);
1018: --
1019: -- A time period end date has been found, so set the last standard
1020: -- process date to that.
1021: --
1022: l_last_standard_process_date := l_max_tpe_end_date;
1023: else
1018: --
1019: -- A time period end date has been found, so set the last standard
1020: -- process date to that.
1021: --
1022: l_last_standard_process_date := l_max_tpe_end_date;
1023: else
1024: --
1025: hr_utility.set_location(l_proc, 100);
1026: --
1028: -- there was no time period for that payroll as of the actual
1029: -- termination date. It doesn't matter which as we will default
1030: -- the LSPD to the ATD.
1031: --
1032: l_last_standard_process_date := l_actual_termination_date;
1033: end if;
1034:
1035: end if;
1036: --
1037: -- Save PDS update
1038: --
1039: per_pds_upd.upd
1040: (p_period_of_service_id => p_period_of_service_id
1041: ,p_last_standard_process_date => l_last_standard_process_date
1042: ,p_object_version_number => l_pds_object_version_number
1043: ,p_effective_date => l_last_standard_process_date + 1
1044: ,p_validate => p_validate
1045: ,p_attribute_category => p_attribute_category
1039: per_pds_upd.upd
1040: (p_period_of_service_id => p_period_of_service_id
1041: ,p_last_standard_process_date => l_last_standard_process_date
1042: ,p_object_version_number => l_pds_object_version_number
1043: ,p_effective_date => l_last_standard_process_date + 1
1044: ,p_validate => p_validate
1045: ,p_attribute_category => p_attribute_category
1046: ,p_attribute1 => p_attribute1
1047: ,p_attribute2 => p_attribute2
1103:
1104: hrempter.terminate_entries_and_alus
1105: (p_assignment_id => csr_rec.assignment_id
1106: ,p_actual_term_date => l_saved_atd
1107: ,p_last_standard_date => l_last_standard_process_date
1108: ,p_final_process_date => null
1109: ,p_legislation_code => l_legislation_code
1110: ,p_entries_changed_warning => l_cr_entries_changed_warn
1111: --
1224: );
1225: --
1226: hr_utility.set_location(l_proc, 190);
1227: --
1228: -- Validate/derive the last standard process date.
1229: --
1230: --
1231: hr_utility.set_location(l_proc, 200);
1232: --
1230: --
1231: hr_utility.set_location(l_proc, 200);
1232: --
1233: -- At the end of the following code we will either have a valid date
1234: -- for l_last_standard_process_date or it will be NULL. It can only be
1235: -- NULL if explicitly passed as such to the API.
1236: --
1237: if l_last_standard_process_date is not null and
1238: l_last_standard_process_date <> hr_api.g_date
1233: -- At the end of the following code we will either have a valid date
1234: -- for l_last_standard_process_date or it will be NULL. It can only be
1235: -- NULL if explicitly passed as such to the API.
1236: --
1237: if l_last_standard_process_date is not null and
1238: l_last_standard_process_date <> hr_api.g_date
1239: then
1240: --
1241: hr_utility.set_location(l_proc, 210);
1234: -- for l_last_standard_process_date or it will be NULL. It can only be
1235: -- NULL if explicitly passed as such to the API.
1236: --
1237: if l_last_standard_process_date is not null and
1238: l_last_standard_process_date <> hr_api.g_date
1239: then
1240: --
1241: hr_utility.set_location(l_proc, 210);
1242: --
1239: then
1240: --
1241: hr_utility.set_location(l_proc, 210);
1242: --
1243: -- Check that the last standard process date is on or after the actual
1244: -- termination date.
1245: --
1246: if not l_last_standard_process_date >= l_actual_termination_date
1247: then
1242: --
1243: -- Check that the last standard process date is on or after the actual
1244: -- termination date.
1245: --
1246: if not l_last_standard_process_date >= l_actual_termination_date
1247: then
1248: --
1249: hr_utility.set_location(l_proc, 220);
1250: --
1250: --
1251: hr_utility.set_message(801,'HR_7505_PDS_INV_LSP_ATT_DT');
1252: hr_utility.raise_error;
1253: end if;
1254: elsif l_last_standard_process_date = hr_api.g_date then
1255: --
1256: hr_utility.set_location(l_proc, 230);
1257: --
1258: -- Last standard process date is the default value i.e.
1254: elsif l_last_standard_process_date = hr_api.g_date then
1255: --
1256: hr_utility.set_location(l_proc, 230);
1257: --
1258: -- Last standard process date is the default value i.e.
1259: -- it was not passed to the API => derive it.
1260: --
1261: -- Find the max tpe end date of any payrolls that are assigned.
1262: --
1288: then
1289: --
1290: hr_utility.set_location(l_proc, 260);
1291: --
1292: -- A time period end date has been found, so set the last standard
1293: -- process date to that.
1294: --
1295: l_last_standard_process_date := l_max_tpe_end_date;
1296: else
1291: --
1292: -- A time period end date has been found, so set the last standard
1293: -- process date to that.
1294: --
1295: l_last_standard_process_date := l_max_tpe_end_date;
1296: else
1297: --
1298: hr_utility.set_location(l_proc, 270);
1299: --
1301: -- there was no time period for that payroll as of the actual
1302: -- termination date. It doesn't matter which as we will default
1303: -- the LSPD to the ATD.
1304: --
1305: l_last_standard_process_date := l_actual_termination_date;
1306: end if;
1307: end if;
1308: --
1309: --2478758 implement check for payroll actions
1310: --
1311: l_action_chk := hr_ex_employee_api.check_for_compl_actions
1312: (p_person_id => l_person_id
1313: ,p_act_date => l_actual_termination_date
1314: ,p_lsp_date => l_last_standard_process_date
1315: ,p_fpr_date => null --not known to this API
1316: );
1317: --
1318: -- Bug# 2958006 Start Here
1353: );
1354:
1355: hr_utility.set_location(l_proc, 290);
1356: --
1357: -- Update actual termination date and last standard process date in
1358: -- periods of service table.
1359:
1360: per_pds_upd.upd
1361: (p_period_of_service_id => p_period_of_service_id
1359:
1360: per_pds_upd.upd
1361: (p_period_of_service_id => p_period_of_service_id
1362: ,p_actual_termination_date => l_actual_termination_date
1363: ,p_last_standard_process_date => l_last_standard_process_date
1364: ,p_leaving_reason => p_leaving_reason
1365: ,p_object_version_number => l_pds_object_version_number
1366: ,p_effective_date => p_actual_termination_date + 1
1367: ,p_attribute_category => p_attribute_category
1508: hr_assignment_internal.actual_term_emp_asg_sup
1509: (p_assignment_id => csr_rec.assignment_id
1510: ,p_object_version_number => csr_rec.object_version_number
1511: ,p_actual_termination_date => l_actual_termination_date
1512: ,p_last_standard_process_date => l_last_standard_process_date
1513: ,p_assignment_status_type_id => l_assignment_status_type_id
1514: ,p_effective_start_date => l_effective_start_date
1515: ,p_effective_end_date => l_effective_end_date
1516: ,p_asg_future_changes_warning => l_cr_asg_future_changes_warn
1694: (p_effective_date => l_effective_date
1695: ,p_period_of_service_id => p_period_of_service_id
1696: ,p_object_version_number => l_pds_object_version_number
1697: ,p_actual_termination_date => l_actual_termination_date
1698: ,p_last_standard_process_date => l_last_std_process_date_in
1699: ,p_person_type_id => p_person_type_id
1700: ,p_assignment_status_type_id => p_assignment_status_type_id
1701: ,p_attribute_category => p_attribute_category
1702: ,p_attribute1 => p_attribute1
1749: ,p_pds_information27 => p_pds_information27
1750: ,p_pds_information28 => p_pds_information28
1751: ,p_pds_information29 => p_pds_information29
1752: ,p_pds_information30 => p_pds_information30
1753: ,p_last_std_process_date_out => l_last_standard_process_date
1754: ,p_supervisor_warning => l_supervisor_warning
1755: ,p_event_warning => l_event_warning
1756: ,p_interview_warning => l_interview_warning
1757: ,p_review_warning => l_review_warning
1791: p_alu_change_warning := l_alu_change_warning;
1792: --
1793: -- 120.2 (END)
1794: --
1795: p_last_std_process_date_out := l_last_standard_process_date;
1796: p_object_version_number := l_pds_object_version_number;
1797: --
1798: --
1799: hr_utility.set_location(' Leaving:'||l_proc, 440);
1813: p_entries_changed_warning := l_entries_changed_warning;
1814: p_pay_proposal_warning := l_pay_proposal_warn;
1815: p_dod_warning := l_dod_warning;
1816: --
1817: -- p_object_version_number and p_last_standard_process_date
1818: -- should return their IN values, they still hold their IN values
1819: -- so do nothing here.
1820: --
1821: --
1882: l_cr_org_now_no_manager_warn boolean := FALSE;
1883: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
1884: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
1885: l_exists varchar2(1);
1886: l_last_standard_process_date per_periods_of_service.last_standard_process_date%TYPE;
1887: l_legislation_code per_business_groups.legislation_code%TYPE;
1888: l_object_version_number per_periods_of_service.object_version_number%TYPE;
1889: l_person_id per_all_people_f.person_id%TYPE;
1890: l_proc varchar2(72) := g_package || 'final_process_emp';
1893: --
1894: cursor csr_get_derived_details is
1895: select bus.legislation_code
1896: , pds.actual_termination_date
1897: , pds.last_standard_process_date
1898: , pds.person_id
1899: , pds.object_version_number
1900: from per_business_groups bus
1901: , per_periods_of_service pds
1994: open csr_get_derived_details;
1995: fetch csr_get_derived_details
1996: into l_legislation_code
1997: ,l_actual_termination_date
1998: ,l_last_standard_process_date
1999: ,l_person_id
2000: ,l_object_version_number;
2001: --
2002: if csr_get_derived_details%NOTFOUND
2043: -- Default the FPD to the LSPD
2044: --
2045: l_final_process_date := l_actual_termination_date;
2046: --
2047: -- Add one day to the last standard process date to get the
2048: -- validation date
2049: --
2050: -- Set the EX Employee effective date to the FPD + 1
2051: --
2058: then
2059: --
2060: -- Default the FPD to the LSPD
2061: --
2062: l_final_process_date := l_last_standard_process_date;
2063: --
2064: -- Add one day to the last standard process date to get the
2065: -- validation date
2066: --
2060: -- Default the FPD to the LSPD
2061: --
2062: l_final_process_date := l_last_standard_process_date;
2063: --
2064: -- Add one day to the last standard process date to get the
2065: -- validation date
2066: --
2067: -- Set the EX Employee effective date to the FPD + 1
2068: --
2118: --
2119: l_action_chk := hr_ex_employee_api.check_for_compl_actions
2120: (p_person_id => l_person_id
2121: ,p_act_date => l_actual_termination_date
2122: ,p_lsp_date => l_last_standard_process_date
2123: ,p_fpr_date => l_final_process_date
2124: );
2125: --
2126: IF l_action_chk = 'N' THEN