eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE BODY: APPS.HR_ASSIGNMENT_BK3

Source


1 package body HR_ASSIGNMENT_BK3 as
2 /* $Header: peasgapi.pkb 120.20.12010000.4 2008/09/29 13:00:03 generated ship $ */
3 -- Code generated by the Oracle HRMS API Hook Pre-processor
4 -- Created on 2009/03/30 04:54:01 (YYYY/MM/DD HH24:MI:SS)
5 procedure UPDATE_EMP_ASG_CRITERIA_A
6 (P_EFFECTIVE_DATE in DATE
7 ,P_DATETRACK_UPDATE_MODE in VARCHAR2
8 ,P_ASSIGNMENT_ID in NUMBER
9 ,P_OBJECT_VERSION_NUMBER in NUMBER
10 ,P_GRADE_ID in NUMBER
11 ,P_POSITION_ID in NUMBER
12 ,P_JOB_ID in NUMBER
13 ,P_PAYROLL_ID in NUMBER
14 ,P_LOCATION_ID in NUMBER
15 ,P_SPECIAL_CEILING_STEP_ID in NUMBER
16 ,P_ORGANIZATION_ID in NUMBER
17 ,P_PAY_BASIS_ID in NUMBER
18 ,P_SEGMENT1 in VARCHAR2
19 ,P_SEGMENT2 in VARCHAR2
20 ,P_SEGMENT3 in VARCHAR2
21 ,P_SEGMENT4 in VARCHAR2
22 ,P_SEGMENT5 in VARCHAR2
23 ,P_SEGMENT6 in VARCHAR2
24 ,P_SEGMENT7 in VARCHAR2
25 ,P_SEGMENT8 in VARCHAR2
26 ,P_SEGMENT9 in VARCHAR2
27 ,P_SEGMENT10 in VARCHAR2
28 ,P_SEGMENT11 in VARCHAR2
29 ,P_SEGMENT12 in VARCHAR2
30 ,P_SEGMENT13 in VARCHAR2
31 ,P_SEGMENT14 in VARCHAR2
32 ,P_SEGMENT15 in VARCHAR2
33 ,P_SEGMENT16 in VARCHAR2
34 ,P_SEGMENT17 in VARCHAR2
35 ,P_SEGMENT18 in VARCHAR2
36 ,P_SEGMENT19 in VARCHAR2
37 ,P_SEGMENT20 in VARCHAR2
38 ,P_SEGMENT21 in VARCHAR2
39 ,P_SEGMENT22 in VARCHAR2
40 ,P_SEGMENT23 in VARCHAR2
41 ,P_SEGMENT24 in VARCHAR2
42 ,P_SEGMENT25 in VARCHAR2
43 ,P_SEGMENT26 in VARCHAR2
44 ,P_SEGMENT27 in VARCHAR2
45 ,P_SEGMENT28 in VARCHAR2
46 ,P_SEGMENT29 in VARCHAR2
47 ,P_SEGMENT30 in VARCHAR2
48 ,P_GROUP_NAME in VARCHAR2
49 ,P_EMPLOYMENT_CATEGORY in VARCHAR2
50 ,P_EFFECTIVE_START_DATE in DATE
51 ,P_EFFECTIVE_END_DATE in DATE
52 ,P_PEOPLE_GROUP_ID in NUMBER
53 ,P_ORG_NOW_NO_MANAGER_WARNING in BOOLEAN
54 ,P_OTHER_MANAGER_WARNING in BOOLEAN
55 ,P_SPP_DELETE_WARNING in BOOLEAN
56 ,P_ENTRIES_CHANGED_WARNING in VARCHAR2
57 ,P_TAX_DISTRICT_CHANGED_WARNING in BOOLEAN
58 ,P_CONCAT_SEGMENTS in VARCHAR2
59 ,P_CONTRACT_ID in NUMBER
60 ,P_ESTABLISHMENT_ID in NUMBER
61 ,P_CONCATENATED_SEGMENTS in VARCHAR2
62 ,P_SOFT_CODING_KEYFLEX_ID in NUMBER
63 ,P_SCL_SEGMENT1 in VARCHAR2
64 )is
65 l_commit_unit_number number;
66 l_legislation_code   varchar2(30);
67 begin
68 hr_utility.set_location('Entering: HR_ASSIGNMENT_BK3.UPDATE_EMP_ASG_CRITERIA_A', 10);
69 l_commit_unit_number := hr_api.return_commit_unit;
70 if hr_api.call_app_hooks then
71 hr_assignment_be3.UPDATE_EMP_ASG_CRITERIA_A
72 (P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
73 ,P_DATETRACK_UPDATE_MODE => P_DATETRACK_UPDATE_MODE
74 ,P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
75 ,P_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER
76 ,P_GRADE_ID => P_GRADE_ID
77 ,P_POSITION_ID => P_POSITION_ID
78 ,P_JOB_ID => P_JOB_ID
79 ,P_PAYROLL_ID => P_PAYROLL_ID
80 ,P_LOCATION_ID => P_LOCATION_ID
81 ,P_SPECIAL_CEILING_STEP_ID => P_SPECIAL_CEILING_STEP_ID
82 ,P_ORGANIZATION_ID => P_ORGANIZATION_ID
83 ,P_PAY_BASIS_ID => P_PAY_BASIS_ID
84 ,P_SEGMENT1 => P_SEGMENT1
85 ,P_SEGMENT2 => P_SEGMENT2
86 ,P_SEGMENT3 => P_SEGMENT3
87 ,P_SEGMENT4 => P_SEGMENT4
88 ,P_SEGMENT5 => P_SEGMENT5
89 ,P_SEGMENT6 => P_SEGMENT6
90 ,P_SEGMENT7 => P_SEGMENT7
91 ,P_SEGMENT8 => P_SEGMENT8
92 ,P_SEGMENT9 => P_SEGMENT9
93 ,P_SEGMENT10 => P_SEGMENT10
94 ,P_SEGMENT11 => P_SEGMENT11
95 ,P_SEGMENT12 => P_SEGMENT12
96 ,P_SEGMENT13 => P_SEGMENT13
97 ,P_SEGMENT14 => P_SEGMENT14
98 ,P_SEGMENT15 => P_SEGMENT15
99 ,P_SEGMENT16 => P_SEGMENT16
100 ,P_SEGMENT17 => P_SEGMENT17
101 ,P_SEGMENT18 => P_SEGMENT18
102 ,P_SEGMENT19 => P_SEGMENT19
103 ,P_SEGMENT20 => P_SEGMENT20
104 ,P_SEGMENT21 => P_SEGMENT21
105 ,P_SEGMENT22 => P_SEGMENT22
106 ,P_SEGMENT23 => P_SEGMENT23
107 ,P_SEGMENT24 => P_SEGMENT24
108 ,P_SEGMENT25 => P_SEGMENT25
109 ,P_SEGMENT26 => P_SEGMENT26
110 ,P_SEGMENT27 => P_SEGMENT27
111 ,P_SEGMENT28 => P_SEGMENT28
112 ,P_SEGMENT29 => P_SEGMENT29
113 ,P_SEGMENT30 => P_SEGMENT30
114 ,P_GROUP_NAME => P_GROUP_NAME
115 ,P_EMPLOYMENT_CATEGORY => P_EMPLOYMENT_CATEGORY
116 ,P_EFFECTIVE_START_DATE => P_EFFECTIVE_START_DATE
117 ,P_EFFECTIVE_END_DATE => P_EFFECTIVE_END_DATE
118 ,P_PEOPLE_GROUP_ID => P_PEOPLE_GROUP_ID
119 ,P_ORG_NOW_NO_MANAGER_WARNING => P_ORG_NOW_NO_MANAGER_WARNING
120 ,P_OTHER_MANAGER_WARNING => P_OTHER_MANAGER_WARNING
121 ,P_SPP_DELETE_WARNING => P_SPP_DELETE_WARNING
122 ,P_ENTRIES_CHANGED_WARNING => P_ENTRIES_CHANGED_WARNING
123 ,P_TAX_DISTRICT_CHANGED_WARNING => P_TAX_DISTRICT_CHANGED_WARNING
124 ,P_CONCAT_SEGMENTS => P_CONCAT_SEGMENTS
125 ,P_CONTRACT_ID => P_CONTRACT_ID
126 ,P_ESTABLISHMENT_ID => P_ESTABLISHMENT_ID
127 ,P_CONCATENATED_SEGMENTS => P_CONCATENATED_SEGMENTS
128 ,P_SOFT_CODING_KEYFLEX_ID => P_SOFT_CODING_KEYFLEX_ID
129 ,P_SCL_SEGMENT1 => P_SCL_SEGMENT1
130 );
131 end if;
132 if hr_api.call_leg_hooks then
133 l_legislation_code := PER_ASG_BUS1.return_legislation_code(P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
134 );
135 if l_legislation_code = 'MX' then
136 HR_MX_EXTRA_ASG_RULES.CHK_LOC_GRE_FOR_LEAV_REASON
137 (P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
138 ,P_DATETRACK_UPDATE_MODE => P_DATETRACK_UPDATE_MODE
139 ,P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
140 ,P_LOCATION_ID => P_LOCATION_ID
141 ,P_SCL_SEGMENT1 => P_SCL_SEGMENT1
142 );
143 elsif l_legislation_code = 'US' then
144 PER_US_EXTRA_ASSIGNMENT_RULES.UPDATE_TAX_RECORD
145 (P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
146 ,P_DATETRACK_UPDATE_MODE => P_DATETRACK_UPDATE_MODE
147 ,P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
148 ,P_LOCATION_ID => P_LOCATION_ID
149 );
150 end if;
151 end if;
152 hr_multi_message.end_validation_set;
153 hr_api.validate_commit_unit(l_commit_unit_number, 'UPDATE_EMP_ASG_CRITERIA', 'AP');
154 hr_utility.set_location(' Leaving: HR_ASSIGNMENT_BK3.UPDATE_EMP_ASG_CRITERIA_A', 20);
155 end UPDATE_EMP_ASG_CRITERIA_A;
156 procedure UPDATE_EMP_ASG_CRITERIA_B
157 (P_EFFECTIVE_DATE in DATE
158 ,P_DATETRACK_UPDATE_MODE in VARCHAR2
159 ,P_ASSIGNMENT_ID in NUMBER
160 ,P_OBJECT_VERSION_NUMBER in NUMBER
161 ,P_GRADE_ID in NUMBER
162 ,P_POSITION_ID in NUMBER
163 ,P_JOB_ID in NUMBER
164 ,P_PAYROLL_ID in NUMBER
165 ,P_LOCATION_ID in NUMBER
166 ,P_SPECIAL_CEILING_STEP_ID in NUMBER
167 ,P_ORGANIZATION_ID in NUMBER
168 ,P_PAY_BASIS_ID in NUMBER
169 ,P_SEGMENT1 in VARCHAR2
170 ,P_SEGMENT2 in VARCHAR2
171 ,P_SEGMENT3 in VARCHAR2
172 ,P_SEGMENT4 in VARCHAR2
173 ,P_SEGMENT5 in VARCHAR2
174 ,P_SEGMENT6 in VARCHAR2
175 ,P_SEGMENT7 in VARCHAR2
176 ,P_SEGMENT8 in VARCHAR2
177 ,P_SEGMENT9 in VARCHAR2
178 ,P_SEGMENT10 in VARCHAR2
179 ,P_SEGMENT11 in VARCHAR2
180 ,P_SEGMENT12 in VARCHAR2
181 ,P_SEGMENT13 in VARCHAR2
182 ,P_SEGMENT14 in VARCHAR2
183 ,P_SEGMENT15 in VARCHAR2
184 ,P_SEGMENT16 in VARCHAR2
185 ,P_SEGMENT17 in VARCHAR2
186 ,P_SEGMENT18 in VARCHAR2
187 ,P_SEGMENT19 in VARCHAR2
188 ,P_SEGMENT20 in VARCHAR2
189 ,P_SEGMENT21 in VARCHAR2
190 ,P_SEGMENT22 in VARCHAR2
191 ,P_SEGMENT23 in VARCHAR2
192 ,P_SEGMENT24 in VARCHAR2
193 ,P_SEGMENT25 in VARCHAR2
194 ,P_SEGMENT26 in VARCHAR2
195 ,P_SEGMENT27 in VARCHAR2
196 ,P_SEGMENT28 in VARCHAR2
197 ,P_SEGMENT29 in VARCHAR2
198 ,P_SEGMENT30 in VARCHAR2
199 ,P_CONCAT_SEGMENTS in VARCHAR2
200 ,P_EMPLOYMENT_CATEGORY in VARCHAR2
201 ,P_CONTRACT_ID in NUMBER
202 ,P_ESTABLISHMENT_ID in NUMBER
203 )is
204 l_commit_unit_number number;
205 l_legislation_code   varchar2(30);
206 begin
207 hr_utility.set_location('Entering: HR_ASSIGNMENT_BK3.UPDATE_EMP_ASG_CRITERIA_B', 10);
208 l_commit_unit_number := hr_api.return_commit_unit;
209 if hr_api.call_leg_hooks then
210 l_legislation_code := PER_ASG_BUS1.return_legislation_code(P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
211 );
212 if l_legislation_code = 'IE' then
213 PER_IE_ORG_INFO.UPDATE_IE_ASG_INFO
214 (P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
215 ,P_PAYROLL_ID => P_PAYROLL_ID
216 ,P_ORGANIZATION_ID => P_ORGANIZATION_ID
217 ,P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
218 );
219 elsif l_legislation_code = 'IT' then
220 HR_IT_EXTRA_ASSGT_RULES.EXTRA_ASSIGNMENT_CHECKS
221 (P_EMPLOYMENT_CATEGORY => P_EMPLOYMENT_CATEGORY
222 );
223 elsif l_legislation_code = 'MX' then
224 HR_MX_EXTRA_ASG_RULES.GET_GRE_LOC
225 (P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
226 ,P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
227 );
228 elsif l_legislation_code = 'PL' then
229 PER_PL_ASSIGNMENT.UPDATE_PL_EMP_ASG_CRITERIA
230 (P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
231 ,P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
232 ,P_PAYROLL_ID => P_PAYROLL_ID
233 ,P_EMPLOYMENT_CATEGORY => P_EMPLOYMENT_CATEGORY
234 );
235 elsif l_legislation_code = 'US' then
236 PER_US_EXTRA_ASSIGNMENT_RULES.GET_CURR_ASS_LOCATION_ID
237 (P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
238 ,P_DATETRACK_UPDATE_MODE => P_DATETRACK_UPDATE_MODE
239 ,P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
240 );
241 end if;
242 end if;
243 hr_api.validate_commit_unit(l_commit_unit_number, 'UPDATE_EMP_ASG_CRITERIA', 'BP');
244 hr_utility.set_location(' Leaving: HR_ASSIGNMENT_BK3.UPDATE_EMP_ASG_CRITERIA_B', 20);
245 end UPDATE_EMP_ASG_CRITERIA_B;
246 end HR_ASSIGNMENT_BK3;