PACKAGE BODY: APPS.HR_EX_EMPLOYEE_BK2

Source

1 package body HR_EX_EMPLOYEE_BK2 as
2 /* $Header: peexeapi.pkb 120.8.12000000.2 2007/08/10 10:44:22 generated ship $ */
3 -- Code generated by the Oracle HRMS API Hook Pre-processor
4 -- Created on 2009/03/30 04:54:02 (YYYY/MM/DD HH24:MI:SS)
5 procedure FINAL_PROCESS_EMP_A
6 (P_PERIOD_OF_SERVICE_ID in NUMBER
7 ,P_OBJECT_VERSION_NUMBER in NUMBER
8 ,P_FINAL_PROCESS_DATE in DATE
9 ,P_ORG_NOW_NO_MANAGER_WARNING in BOOLEAN
10 ,P_ASG_FUTURE_CHANGES_WARNING in BOOLEAN
11 ,P_ENTRIES_CHANGED_WARNING in VARCHAR2
12 )is
13 l_commit_unit_number number;
14 l_legislation_code   varchar2(30);
15 begin
16 hr_utility.set_location('Entering: HR_EX_EMPLOYEE_BK2.FINAL_PROCESS_EMP_A', 10);
17 l_commit_unit_number := hr_api.return_commit_unit;
18 if hr_api.call_leg_hooks then
19 l_legislation_code := PER_PDS_BUS.return_legislation_code(P_PERIOD_OF_SERVICE_ID => P_PERIOD_OF_SERVICE_ID
20 );
21 if l_legislation_code = 'IE' then
22 PER_IE_TERMINATION.FINAL_TERMINATION
23 (P_PERIOD_OF_SERVICE_ID => P_PERIOD_OF_SERVICE_ID
24 ,P_FINAL_PROCESS_DATE => P_FINAL_PROCESS_DATE
25 );
26 elsif l_legislation_code = 'IN' then
27 PER_IN_PERSON_TERM_LEG_HOOK.FINAL_PROCESS_EMP
28 (P_PERIOD_OF_SERVICE_ID => P_PERIOD_OF_SERVICE_ID
29 );
30 elsif l_legislation_code = 'MX' then
31 HR_MX_EXTRA_ASG_RULES.CHK_LEAV_REASON_FOR_DEL_EMP
32 (P_FINAL_PROCESS_DATE => P_FINAL_PROCESS_DATE
33 ,P_PERIOD_OF_SERVICE_ID => P_PERIOD_OF_SERVICE_ID
34 ,P_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER
35 );
36 end if;
37 end if;
38 hr_multi_message.end_validation_set;
39 hr_api.validate_commit_unit(l_commit_unit_number, 'FINAL_PROCESS_EMP', 'AP');
40 hr_utility.set_location(' Leaving: HR_EX_EMPLOYEE_BK2.FINAL_PROCESS_EMP_A', 20);
41 end FINAL_PROCESS_EMP_A;
42 procedure FINAL_PROCESS_EMP_B
43 (P_PERIOD_OF_SERVICE_ID in NUMBER
44 ,P_OBJECT_VERSION_NUMBER in NUMBER
45 ,P_FINAL_PROCESS_DATE in DATE
46 )is
47 l_commit_unit_number number;
48 l_legislation_code   varchar2(30);
49 begin
50 hr_utility.set_location('Entering: HR_EX_EMPLOYEE_BK2.FINAL_PROCESS_EMP_B', 10);
51 l_commit_unit_number := hr_api.return_commit_unit;
52 if hr_api.call_leg_hooks then
53 l_legislation_code := PER_PDS_BUS.return_legislation_code(P_PERIOD_OF_SERVICE_ID => P_PERIOD_OF_SERVICE_ID
54 );
55 if l_legislation_code = 'CA' then
56 PAY_CA_EMP_TAX_INF.DELETE_TAX_RECORD
57 (P_PERIOD_OF_SERVICE_ID => P_PERIOD_OF_SERVICE_ID
58 ,P_FINAL_PROCESS_DATE => P_FINAL_PROCESS_DATE
59 );
60 elsif l_legislation_code = 'US' then
61 PER_US_EXTRA_REHIRE_RULES.DELETE_TAX_RECORD
62 (P_FINAL_PROCESS_DATE => P_FINAL_PROCESS_DATE
63 ,P_PERIOD_OF_SERVICE_ID => P_PERIOD_OF_SERVICE_ID
64 );
65 end if;
66 end if;
67 hr_api.validate_commit_unit(l_commit_unit_number, 'FINAL_PROCESS_EMP', 'BP');
68 hr_utility.set_location(' Leaving: HR_EX_EMPLOYEE_BK2.FINAL_PROCESS_EMP_B', 20);
69 end FINAL_PROCESS_EMP_B;
70 end HR_EX_EMPLOYEE_BK2;