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_ORGANIZATION_BK2

Source


1 package body HR_ORGANIZATION_BK2 as
2 /* $Header: hrorgapi.pkb 120.18 2009/11/05 10:25:16 generated noship $ */
3 -- Code generated by the Oracle HRMS API Hook Pre-processor
4 -- Created on 2013/08/13 18:46:39 (YYYY/MM/DD HH24:MI:SS)
5 procedure UPDATE_ORG_INFORMATION_A
6 (P_EFFECTIVE_DATE in DATE
7 ,P_ORG_INFO_TYPE_CODE in VARCHAR2
8 ,P_ORG_INFORMATION1 in VARCHAR2
9 ,P_ORG_INFORMATION2 in VARCHAR2
10 ,P_ORG_INFORMATION3 in VARCHAR2
11 ,P_ORG_INFORMATION4 in VARCHAR2
12 ,P_ORG_INFORMATION5 in VARCHAR2
13 ,P_ORG_INFORMATION6 in VARCHAR2
14 ,P_ORG_INFORMATION7 in VARCHAR2
15 ,P_ORG_INFORMATION8 in VARCHAR2
16 ,P_ORG_INFORMATION9 in VARCHAR2
17 ,P_ORG_INFORMATION10 in VARCHAR2
18 ,P_ORG_INFORMATION11 in VARCHAR2
19 ,P_ORG_INFORMATION12 in VARCHAR2
20 ,P_ORG_INFORMATION13 in VARCHAR2
21 ,P_ORG_INFORMATION14 in VARCHAR2
22 ,P_ORG_INFORMATION15 in VARCHAR2
23 ,P_ORG_INFORMATION16 in VARCHAR2
24 ,P_ORG_INFORMATION17 in VARCHAR2
25 ,P_ORG_INFORMATION18 in VARCHAR2
26 ,P_ORG_INFORMATION19 in VARCHAR2
27 ,P_ORG_INFORMATION20 in VARCHAR2
28 ,P_ORG_INFORMATION_ID in NUMBER
29 ,P_ATTRIBUTE_CATEGORY in VARCHAR2
30 ,P_ATTRIBUTE1 in VARCHAR2
31 ,P_ATTRIBUTE2 in VARCHAR2
32 ,P_ATTRIBUTE3 in VARCHAR2
33 ,P_ATTRIBUTE4 in VARCHAR2
34 ,P_ATTRIBUTE5 in VARCHAR2
35 ,P_ATTRIBUTE6 in VARCHAR2
36 ,P_ATTRIBUTE7 in VARCHAR2
37 ,P_ATTRIBUTE8 in VARCHAR2
38 ,P_ATTRIBUTE9 in VARCHAR2
39 ,P_ATTRIBUTE10 in VARCHAR2
40 ,P_ATTRIBUTE11 in VARCHAR2
41 ,P_ATTRIBUTE12 in VARCHAR2
42 ,P_ATTRIBUTE13 in VARCHAR2
43 ,P_ATTRIBUTE14 in VARCHAR2
44 ,P_ATTRIBUTE15 in VARCHAR2
45 ,P_ATTRIBUTE16 in VARCHAR2
46 ,P_ATTRIBUTE17 in VARCHAR2
47 ,P_ATTRIBUTE18 in VARCHAR2
48 ,P_ATTRIBUTE19 in VARCHAR2
49 ,P_ATTRIBUTE20 in VARCHAR2
50 ,P_OBJECT_VERSION_NUMBER in NUMBER
51 )is
52 l_commit_unit_number number;
53 l_legislation_code   varchar2(30);
54 begin
55 hr_utility.set_location('Entering: HR_ORGANIZATION_BK2.UPDATE_ORG_INFORMATION_A', 10);
56 l_commit_unit_number := hr_api.return_commit_unit;
57 if hr_api.call_app_hooks then
58 hr_organization_be2.UPDATE_ORG_INFORMATION_A
59 (P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
60 ,P_ORG_INFO_TYPE_CODE => P_ORG_INFO_TYPE_CODE
61 ,P_ORG_INFORMATION1 => P_ORG_INFORMATION1
62 ,P_ORG_INFORMATION2 => P_ORG_INFORMATION2
63 ,P_ORG_INFORMATION3 => P_ORG_INFORMATION3
64 ,P_ORG_INFORMATION4 => P_ORG_INFORMATION4
65 ,P_ORG_INFORMATION5 => P_ORG_INFORMATION5
66 ,P_ORG_INFORMATION6 => P_ORG_INFORMATION6
67 ,P_ORG_INFORMATION7 => P_ORG_INFORMATION7
68 ,P_ORG_INFORMATION8 => P_ORG_INFORMATION8
69 ,P_ORG_INFORMATION9 => P_ORG_INFORMATION9
70 ,P_ORG_INFORMATION10 => P_ORG_INFORMATION10
71 ,P_ORG_INFORMATION11 => P_ORG_INFORMATION11
72 ,P_ORG_INFORMATION12 => P_ORG_INFORMATION12
73 ,P_ORG_INFORMATION13 => P_ORG_INFORMATION13
74 ,P_ORG_INFORMATION14 => P_ORG_INFORMATION14
75 ,P_ORG_INFORMATION15 => P_ORG_INFORMATION15
76 ,P_ORG_INFORMATION16 => P_ORG_INFORMATION16
77 ,P_ORG_INFORMATION17 => P_ORG_INFORMATION17
78 ,P_ORG_INFORMATION18 => P_ORG_INFORMATION18
79 ,P_ORG_INFORMATION19 => P_ORG_INFORMATION19
80 ,P_ORG_INFORMATION20 => P_ORG_INFORMATION20
81 ,P_ORG_INFORMATION_ID => P_ORG_INFORMATION_ID
82 ,P_ATTRIBUTE_CATEGORY => P_ATTRIBUTE_CATEGORY
83 ,P_ATTRIBUTE1 => P_ATTRIBUTE1
84 ,P_ATTRIBUTE2 => P_ATTRIBUTE2
85 ,P_ATTRIBUTE3 => P_ATTRIBUTE3
86 ,P_ATTRIBUTE4 => P_ATTRIBUTE4
87 ,P_ATTRIBUTE5 => P_ATTRIBUTE5
88 ,P_ATTRIBUTE6 => P_ATTRIBUTE6
89 ,P_ATTRIBUTE7 => P_ATTRIBUTE7
90 ,P_ATTRIBUTE8 => P_ATTRIBUTE8
91 ,P_ATTRIBUTE9 => P_ATTRIBUTE9
92 ,P_ATTRIBUTE10 => P_ATTRIBUTE10
93 ,P_ATTRIBUTE11 => P_ATTRIBUTE11
94 ,P_ATTRIBUTE12 => P_ATTRIBUTE12
95 ,P_ATTRIBUTE13 => P_ATTRIBUTE13
96 ,P_ATTRIBUTE14 => P_ATTRIBUTE14
97 ,P_ATTRIBUTE15 => P_ATTRIBUTE15
98 ,P_ATTRIBUTE16 => P_ATTRIBUTE16
99 ,P_ATTRIBUTE17 => P_ATTRIBUTE17
100 ,P_ATTRIBUTE18 => P_ATTRIBUTE18
101 ,P_ATTRIBUTE19 => P_ATTRIBUTE19
102 ,P_ATTRIBUTE20 => P_ATTRIBUTE20
103 ,P_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER
104 );
105 end if;
106 hr_multi_message.end_validation_set;
107 hr_api.validate_commit_unit(l_commit_unit_number, 'UPDATE_ORG_INFORMATION', 'AP');
108 hr_utility.set_location(' Leaving: HR_ORGANIZATION_BK2.UPDATE_ORG_INFORMATION_A', 20);
109 end UPDATE_ORG_INFORMATION_A;
110 procedure UPDATE_ORG_INFORMATION_B
111 (P_EFFECTIVE_DATE in DATE
112 ,P_ORG_INFO_TYPE_CODE in VARCHAR2
113 ,P_ORG_INFORMATION1 in VARCHAR2
114 ,P_ORG_INFORMATION2 in VARCHAR2
115 ,P_ORG_INFORMATION3 in VARCHAR2
116 ,P_ORG_INFORMATION4 in VARCHAR2
117 ,P_ORG_INFORMATION5 in VARCHAR2
118 ,P_ORG_INFORMATION6 in VARCHAR2
119 ,P_ORG_INFORMATION7 in VARCHAR2
120 ,P_ORG_INFORMATION8 in VARCHAR2
121 ,P_ORG_INFORMATION9 in VARCHAR2
122 ,P_ORG_INFORMATION10 in VARCHAR2
123 ,P_ORG_INFORMATION11 in VARCHAR2
124 ,P_ORG_INFORMATION12 in VARCHAR2
125 ,P_ORG_INFORMATION13 in VARCHAR2
126 ,P_ORG_INFORMATION14 in VARCHAR2
127 ,P_ORG_INFORMATION15 in VARCHAR2
128 ,P_ORG_INFORMATION16 in VARCHAR2
129 ,P_ORG_INFORMATION17 in VARCHAR2
130 ,P_ORG_INFORMATION18 in VARCHAR2
131 ,P_ORG_INFORMATION19 in VARCHAR2
132 ,P_ORG_INFORMATION20 in VARCHAR2
133 ,P_ORG_INFORMATION_ID in NUMBER
134 ,P_ATTRIBUTE_CATEGORY in VARCHAR2
135 ,P_ATTRIBUTE1 in VARCHAR2
136 ,P_ATTRIBUTE2 in VARCHAR2
137 ,P_ATTRIBUTE3 in VARCHAR2
138 ,P_ATTRIBUTE4 in VARCHAR2
139 ,P_ATTRIBUTE5 in VARCHAR2
140 ,P_ATTRIBUTE6 in VARCHAR2
141 ,P_ATTRIBUTE7 in VARCHAR2
142 ,P_ATTRIBUTE8 in VARCHAR2
143 ,P_ATTRIBUTE9 in VARCHAR2
144 ,P_ATTRIBUTE10 in VARCHAR2
145 ,P_ATTRIBUTE11 in VARCHAR2
146 ,P_ATTRIBUTE12 in VARCHAR2
147 ,P_ATTRIBUTE13 in VARCHAR2
148 ,P_ATTRIBUTE14 in VARCHAR2
149 ,P_ATTRIBUTE15 in VARCHAR2
150 ,P_ATTRIBUTE16 in VARCHAR2
151 ,P_ATTRIBUTE17 in VARCHAR2
152 ,P_ATTRIBUTE18 in VARCHAR2
153 ,P_ATTRIBUTE19 in VARCHAR2
154 ,P_ATTRIBUTE20 in VARCHAR2
155 ,P_OBJECT_VERSION_NUMBER in NUMBER
156 )is
157 l_commit_unit_number number;
158 l_legislation_code   varchar2(30);
159 begin
160 hr_utility.set_location('Entering: HR_ORGANIZATION_BK2.UPDATE_ORG_INFORMATION_B', 10);
161 l_commit_unit_number := hr_api.return_commit_unit;
162 if hr_api.call_leg_hooks then
163 l_legislation_code := HR_ORI_BUS.RETURN_LEGISLATION_CODE(P_ORG_INFORMATION_ID => P_ORG_INFORMATION_ID
164 );
165 if l_legislation_code = 'AE' then
166 HR_AE_VALIDATE_PKG.VALIDATE_UPDATE_ORG_INF
167 (P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
168 ,P_ORG_INFORMATION_ID => P_ORG_INFORMATION_ID
169 ,P_ORG_INFO_TYPE_CODE => P_ORG_INFO_TYPE_CODE
170 ,P_ORG_INFORMATION1 => P_ORG_INFORMATION1
171 ,P_ORG_INFORMATION2 => P_ORG_INFORMATION2
172 ,P_ORG_INFORMATION3 => P_ORG_INFORMATION3
173 ,P_ORG_INFORMATION4 => P_ORG_INFORMATION4
174 ,P_ORG_INFORMATION5 => P_ORG_INFORMATION5
175 ,P_ORG_INFORMATION6 => P_ORG_INFORMATION6
176 ,P_ORG_INFORMATION7 => P_ORG_INFORMATION7
177 ,P_ORG_INFORMATION8 => P_ORG_INFORMATION8
178 ,P_ORG_INFORMATION9 => P_ORG_INFORMATION9
179 ,P_ORG_INFORMATION10 => P_ORG_INFORMATION10
180 );
181 elsif l_legislation_code = 'CN' then
182 PER_CN_ORG_INFO_LEG_HOOK.CHECK_CN_ORG_INFO_TYPE_UPDATE
183 (P_ORG_INFO_TYPE_CODE => P_ORG_INFO_TYPE_CODE
184 ,P_ORG_INFORMATION_ID => P_ORG_INFORMATION_ID
185 ,P_ORG_INFORMATION1 => P_ORG_INFORMATION1
186 ,P_ORG_INFORMATION2 => P_ORG_INFORMATION2
187 ,P_ORG_INFORMATION3 => P_ORG_INFORMATION3
188 ,P_ORG_INFORMATION4 => P_ORG_INFORMATION4
189 ,P_ORG_INFORMATION5 => P_ORG_INFORMATION5
190 ,P_ORG_INFORMATION6 => P_ORG_INFORMATION6
191 ,P_ORG_INFORMATION7 => P_ORG_INFORMATION7
192 ,P_ORG_INFORMATION8 => P_ORG_INFORMATION8
193 ,P_ORG_INFORMATION9 => P_ORG_INFORMATION9
194 ,P_ORG_INFORMATION10 => P_ORG_INFORMATION10
195 ,P_ORG_INFORMATION11 => P_ORG_INFORMATION11
196 ,P_ORG_INFORMATION12 => P_ORG_INFORMATION12
197 ,P_ORG_INFORMATION13 => P_ORG_INFORMATION13
198 ,P_ORG_INFORMATION14 => P_ORG_INFORMATION14
199 ,P_ORG_INFORMATION15 => P_ORG_INFORMATION15
200 ,P_ORG_INFORMATION16 => P_ORG_INFORMATION16
201 ,P_ORG_INFORMATION17 => P_ORG_INFORMATION17
202 ,P_ORG_INFORMATION18 => P_ORG_INFORMATION18
203 ,P_ORG_INFORMATION19 => P_ORG_INFORMATION19
204 ,P_ORG_INFORMATION20 => P_ORG_INFORMATION20
205 );
206 elsif l_legislation_code = 'DE' then
207 HR_DE_EXTRA_ORG_CHECKS.ORG_INFORMATION_CHECKS
208 (P_ORG_INFO_TYPE_CODE => P_ORG_INFO_TYPE_CODE
209 ,P_ORG_INFORMATION1 => P_ORG_INFORMATION1
210 ,P_ORG_INFORMATION2 => P_ORG_INFORMATION2
211 );
212 elsif l_legislation_code = 'DK' then
213 HR_DK_VALIDATE_PKG.VALIDATE_UPDATE_ORG_INF
214 (P_ORG_INFO_TYPE_CODE => P_ORG_INFO_TYPE_CODE
215 ,P_ORG_INFORMATION_ID => P_ORG_INFORMATION_ID
216 ,P_ORG_INFORMATION1 => P_ORG_INFORMATION1
217 ,P_ORG_INFORMATION2 => P_ORG_INFORMATION2
218 ,P_ORG_INFORMATION3 => P_ORG_INFORMATION3
219 );
220 elsif l_legislation_code = 'ES' then
221 PER_ES_ORG_INFO.UPDATE_ES_ORG_INFO
222 (P_ORG_INFO_TYPE_CODE => P_ORG_INFO_TYPE_CODE
223 ,P_ORG_INFORMATION1 => P_ORG_INFORMATION1
224 ,P_ORG_INFORMATION2 => P_ORG_INFORMATION2
225 ,P_ORG_INFORMATION3 => P_ORG_INFORMATION3
226 ,P_ORG_INFORMATION4 => P_ORG_INFORMATION4
227 ,P_ORG_INFORMATION5 => P_ORG_INFORMATION5
228 ,P_ORG_INFORMATION6 => P_ORG_INFORMATION6
229 ,P_ORG_INFORMATION7 => P_ORG_INFORMATION7
230 ,P_ORG_INFORMATION8 => P_ORG_INFORMATION8
231 ,P_ORG_INFORMATION_ID => P_ORG_INFORMATION_ID
232 ,P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
233 );
234 elsif l_legislation_code = 'FI' then
235 HR_FI_VALIDATE_PKG.VALIDATE_UPDATE_ORG_INF
236 (P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
237 ,P_ORG_INFO_TYPE_CODE => P_ORG_INFO_TYPE_CODE
238 ,P_ORG_INFORMATION_ID => P_ORG_INFORMATION_ID
239 ,P_ORG_INFORMATION1 => P_ORG_INFORMATION1
240 ,P_ORG_INFORMATION2 => P_ORG_INFORMATION2
241 ,P_ORG_INFORMATION3 => P_ORG_INFORMATION3
242 ,P_ORG_INFORMATION4 => P_ORG_INFORMATION4
243 ,P_ORG_INFORMATION5 => P_ORG_INFORMATION5
244 ,P_ORG_INFORMATION6 => P_ORG_INFORMATION6
245 ,P_ORG_INFORMATION7 => P_ORG_INFORMATION7
246 ,P_ORG_INFORMATION8 => P_ORG_INFORMATION8
247 ,P_ORG_INFORMATION9 => P_ORG_INFORMATION9
248 );
249 elsif l_legislation_code = 'FR' then
250 PE_FR_ADDITIONAL_ORG_RULES.FR_VALIDATE_ORG_INFO_UPD
251 (P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
252 ,P_ORG_INFO_TYPE_CODE => P_ORG_INFO_TYPE_CODE
253 ,P_ORG_INFORMATION1 => P_ORG_INFORMATION1
254 ,P_ORG_INFORMATION2 => P_ORG_INFORMATION2
255 ,P_ORG_INFORMATION3 => P_ORG_INFORMATION3
256 ,P_ORG_INFORMATION4 => P_ORG_INFORMATION4
257 ,P_ORG_INFORMATION5 => P_ORG_INFORMATION5
258 ,P_ORG_INFORMATION6 => P_ORG_INFORMATION6
259 ,P_ORG_INFORMATION7 => P_ORG_INFORMATION7
260 ,P_ORG_INFORMATION8 => P_ORG_INFORMATION8
261 ,P_ORG_INFORMATION9 => P_ORG_INFORMATION9
262 ,P_ORG_INFORMATION10 => P_ORG_INFORMATION10
263 ,P_ORG_INFORMATION11 => P_ORG_INFORMATION11
264 ,P_ORG_INFORMATION12 => P_ORG_INFORMATION12
265 ,P_ORG_INFORMATION13 => P_ORG_INFORMATION13
266 ,P_ORG_INFORMATION14 => P_ORG_INFORMATION14
267 ,P_ORG_INFORMATION15 => P_ORG_INFORMATION15
268 ,P_ORG_INFORMATION16 => P_ORG_INFORMATION16
269 ,P_ORG_INFORMATION17 => P_ORG_INFORMATION17
270 ,P_ORG_INFORMATION18 => P_ORG_INFORMATION18
271 ,P_ORG_INFORMATION19 => P_ORG_INFORMATION19
272 ,P_ORG_INFORMATION20 => P_ORG_INFORMATION20
273 ,P_ORG_INFORMATION_ID => P_ORG_INFORMATION_ID
274 ,P_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER
275 );
276 elsif l_legislation_code = 'GB' then
277 PER_GB_ORG_INFO.UPDATE_GB_ORG_INFO
278 (P_ORG_INFO_TYPE_CODE => P_ORG_INFO_TYPE_CODE
279 ,P_ORG_INFORMATION1 => P_ORG_INFORMATION1
280 ,P_ORG_INFORMATION3 => P_ORG_INFORMATION3
281 ,P_ORG_INFORMATION10 => P_ORG_INFORMATION10
282 ,P_ORG_INFORMATION6 => P_ORG_INFORMATION6
283 ,P_ORG_INFORMATION20 => P_ORG_INFORMATION20
284 ,P_ORG_INFORMATION_ID => P_ORG_INFORMATION_ID
285 );
286 elsif l_legislation_code = 'HU' then
287 PER_HU_ORG_INFO.UPDATE_HU_ORG_INFO
288 (P_ORG_INFORMATION_ID => P_ORG_INFORMATION_ID
289 ,P_ORG_INFO_TYPE_CODE => P_ORG_INFO_TYPE_CODE
290 ,P_ORG_INFORMATION3 => P_ORG_INFORMATION3
291 ,P_ORG_INFORMATION4 => P_ORG_INFORMATION4
292 ,P_ORG_INFORMATION5 => P_ORG_INFORMATION5
293 );
294 elsif l_legislation_code = 'IE' then
295 PER_IE_ORG_INFO.UPDATE_IE_ORG_INFO
296 (P_ORG_INFO_TYPE_CODE => P_ORG_INFO_TYPE_CODE
297 ,P_ORG_INFORMATION2 => P_ORG_INFORMATION2
298 ,P_ORG_INFORMATION3 => P_ORG_INFORMATION3
299 ,P_ORG_INFORMATION_ID => P_ORG_INFORMATION_ID
300 ,P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
301 );
302 elsif l_legislation_code = 'IN' then
303 PER_IN_ORG_INFO_LEG_HOOK.CHECK_ORG_INFO_UPDATE
304 (P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
305 ,P_ORG_INFORMATION_ID => P_ORG_INFORMATION_ID
306 ,P_ORG_INFO_TYPE_CODE => P_ORG_INFO_TYPE_CODE
307 ,P_ORG_INFORMATION1 => P_ORG_INFORMATION1
308 ,P_ORG_INFORMATION2 => P_ORG_INFORMATION2
309 ,P_ORG_INFORMATION3 => P_ORG_INFORMATION3
310 ,P_ORG_INFORMATION4 => P_ORG_INFORMATION4
311 ,P_ORG_INFORMATION5 => P_ORG_INFORMATION5
312 ,P_ORG_INFORMATION6 => P_ORG_INFORMATION6
313 ,P_ORG_INFORMATION7 => P_ORG_INFORMATION7
314 ,P_ORG_INFORMATION8 => P_ORG_INFORMATION8
315 ,P_ORG_INFORMATION9 => P_ORG_INFORMATION9
316 ,P_ORG_INFORMATION10 => P_ORG_INFORMATION10
317 ,P_ORG_INFORMATION11 => P_ORG_INFORMATION11
318 ,P_ORG_INFORMATION12 => P_ORG_INFORMATION12
319 ,P_ORG_INFORMATION13 => P_ORG_INFORMATION13
320 ,P_ORG_INFORMATION14 => P_ORG_INFORMATION14
321 ,P_ORG_INFORMATION15 => P_ORG_INFORMATION15
322 ,P_ORG_INFORMATION16 => P_ORG_INFORMATION16
323 ,P_ORG_INFORMATION17 => P_ORG_INFORMATION17
324 ,P_ORG_INFORMATION18 => P_ORG_INFORMATION18
325 ,P_ORG_INFORMATION19 => P_ORG_INFORMATION19
326 ,P_ORG_INFORMATION20 => P_ORG_INFORMATION20
327 );
328 elsif l_legislation_code = 'KW' then
329 HR_KW_VALIDATE_PKG.VALIDATE_UPDATE_ORG_INF
330 (P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
331 ,P_ORG_INFORMATION_ID => P_ORG_INFORMATION_ID
332 ,P_ORG_INFO_TYPE_CODE => P_ORG_INFO_TYPE_CODE
333 ,P_ORG_INFORMATION1 => P_ORG_INFORMATION1
334 ,P_ORG_INFORMATION2 => P_ORG_INFORMATION2
335 ,P_ORG_INFORMATION3 => P_ORG_INFORMATION3
336 ,P_ORG_INFORMATION4 => P_ORG_INFORMATION4
337 ,P_ORG_INFORMATION5 => P_ORG_INFORMATION5
338 ,P_ORG_INFORMATION6 => P_ORG_INFORMATION6
339 ,P_ORG_INFORMATION7 => P_ORG_INFORMATION7
340 ,P_ORG_INFORMATION8 => P_ORG_INFORMATION8
341 ,P_ORG_INFORMATION9 => P_ORG_INFORMATION9
342 ,P_ORG_INFORMATION10 => P_ORG_INFORMATION10
343 );
344 elsif l_legislation_code = 'NO' then
345 HR_NO_VALIDATE_PKG.VALIDATE_UPDATE_ORG_INF
346 (P_ORG_INFO_TYPE_CODE => P_ORG_INFO_TYPE_CODE
347 ,P_ORG_INFORMATION_ID => P_ORG_INFORMATION_ID
348 ,P_ORG_INFORMATION1 => P_ORG_INFORMATION1
349 ,P_ORG_INFORMATION2 => P_ORG_INFORMATION2
350 ,P_ORG_INFORMATION3 => P_ORG_INFORMATION3
351 ,P_ORG_INFORMATION4 => P_ORG_INFORMATION4
352 ,P_ORG_INFORMATION5 => P_ORG_INFORMATION5
353 ,P_ORG_INFORMATION6 => P_ORG_INFORMATION6
354 ,P_ORG_INFORMATION7 => P_ORG_INFORMATION7
355 ,P_ORG_INFORMATION8 => P_ORG_INFORMATION8
356 ,P_ORG_INFORMATION9 => P_ORG_INFORMATION9
357 ,P_ORG_INFORMATION10 => P_ORG_INFORMATION10
358 ,P_ORG_INFORMATION11 => P_ORG_INFORMATION11
359 ,P_ORG_INFORMATION12 => P_ORG_INFORMATION12
360 ,P_ORG_INFORMATION13 => P_ORG_INFORMATION13
361 ,P_ORG_INFORMATION14 => P_ORG_INFORMATION14
362 ,P_ORG_INFORMATION15 => P_ORG_INFORMATION15
363 ,P_ORG_INFORMATION16 => P_ORG_INFORMATION16
364 ,P_ORG_INFORMATION17 => P_ORG_INFORMATION17
365 ,P_ORG_INFORMATION18 => P_ORG_INFORMATION18
366 ,P_ORG_INFORMATION19 => P_ORG_INFORMATION19
367 ,P_ORG_INFORMATION20 => P_ORG_INFORMATION20
368 );
369 elsif l_legislation_code = 'PL' then
370 PER_PL_ORG_INFO.UPDATE_PL_ORG_INFO
371 (P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
372 ,P_ORG_INFO_TYPE_CODE => P_ORG_INFO_TYPE_CODE
373 ,P_ORG_INFORMATION1 => P_ORG_INFORMATION1
374 ,P_ORG_INFORMATION2 => P_ORG_INFORMATION2
375 ,P_ORG_INFORMATION3 => P_ORG_INFORMATION3
376 ,P_ORG_INFORMATION4 => P_ORG_INFORMATION4
377 ,P_ORG_INFORMATION5 => P_ORG_INFORMATION5
378 ,P_ORG_INFORMATION6 => P_ORG_INFORMATION6
379 ,P_ORG_INFORMATION7 => P_ORG_INFORMATION7
380 ,P_ORG_INFORMATION8 => P_ORG_INFORMATION8
381 ,P_ORG_INFORMATION9 => P_ORG_INFORMATION9
382 ,P_ORG_INFORMATION10 => P_ORG_INFORMATION10
383 ,P_ORG_INFORMATION11 => P_ORG_INFORMATION11
384 ,P_ORG_INFORMATION12 => P_ORG_INFORMATION12
385 ,P_ORG_INFORMATION13 => P_ORG_INFORMATION13
386 ,P_ORG_INFORMATION14 => P_ORG_INFORMATION14
387 ,P_ORG_INFORMATION15 => P_ORG_INFORMATION15
388 ,P_ORG_INFORMATION16 => P_ORG_INFORMATION16
389 ,P_ORG_INFORMATION17 => P_ORG_INFORMATION17
390 ,P_ORG_INFORMATION18 => P_ORG_INFORMATION18
391 ,P_ORG_INFORMATION19 => P_ORG_INFORMATION19
392 ,P_ORG_INFORMATION20 => P_ORG_INFORMATION20
393 ,P_ORG_INFORMATION_ID => P_ORG_INFORMATION_ID
394 );
395 elsif l_legislation_code = 'RO' then
396 HR_RO_ORG_VALIDATIONS.UPDATE_RO_ORG_INFO
397 (P_ORG_INFO_TYPE_CODE => P_ORG_INFO_TYPE_CODE
398 ,P_ORG_INFORMATION1 => P_ORG_INFORMATION1
399 ,P_ORG_INFORMATION2 => P_ORG_INFORMATION2
400 ,P_ORG_INFORMATION3 => P_ORG_INFORMATION3
401 ,P_ORG_INFORMATION4 => P_ORG_INFORMATION4
402 ,P_ORG_INFORMATION5 => P_ORG_INFORMATION5
403 ,P_ORG_INFORMATION6 => P_ORG_INFORMATION6
404 ,P_ORG_INFORMATION7 => P_ORG_INFORMATION7
405 ,P_ORG_INFORMATION8 => P_ORG_INFORMATION8
406 ,P_ORG_INFORMATION_ID => P_ORG_INFORMATION_ID
407 ,P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
408 );
409 elsif l_legislation_code = 'RU' then
410 PER_RU_ORG_INFO.UPDATE_RU_ORG_INFO
411 (P_ORG_INFORMATION_ID => P_ORG_INFORMATION_ID
412 ,P_ORG_INFO_TYPE_CODE => P_ORG_INFO_TYPE_CODE
413 ,P_ORG_INFORMATION1 => P_ORG_INFORMATION1
414 ,P_ORG_INFORMATION2 => P_ORG_INFORMATION2
415 ,P_ORG_INFORMATION3 => P_ORG_INFORMATION3
416 ,P_ORG_INFORMATION4 => P_ORG_INFORMATION4
417 ,P_ORG_INFORMATION5 => P_ORG_INFORMATION5
418 ,P_ORG_INFORMATION7 => P_ORG_INFORMATION7
419 ,P_ORG_INFORMATION8 => P_ORG_INFORMATION8
420 ,P_ORG_INFORMATION12 => P_ORG_INFORMATION12
421 );
422 elsif l_legislation_code = 'SE' then
423 HR_SE_VALIDATE_PKG.VALIDATE_UPDATE_ORG_INF
424 (P_ORG_INFO_TYPE_CODE => P_ORG_INFO_TYPE_CODE
425 ,P_ORG_INFORMATION_ID => P_ORG_INFORMATION_ID
426 ,P_ORG_INFORMATION1 => P_ORG_INFORMATION1
427 ,P_ORG_INFORMATION2 => P_ORG_INFORMATION2
428 ,P_ORG_INFORMATION3 => P_ORG_INFORMATION3
429 ,P_ORG_INFORMATION4 => P_ORG_INFORMATION4
430 ,P_ORG_INFORMATION5 => P_ORG_INFORMATION5
431 ,P_ORG_INFORMATION6 => P_ORG_INFORMATION6
432 ,P_ORG_INFORMATION7 => P_ORG_INFORMATION7
433 ,P_ORG_INFORMATION8 => P_ORG_INFORMATION8
434 ,P_ORG_INFORMATION9 => P_ORG_INFORMATION9
435 ,P_ORG_INFORMATION10 => P_ORG_INFORMATION10
436 ,P_ORG_INFORMATION11 => P_ORG_INFORMATION11
437 ,P_ORG_INFORMATION12 => P_ORG_INFORMATION12
438 ,P_ORG_INFORMATION13 => P_ORG_INFORMATION13
439 ,P_ORG_INFORMATION14 => P_ORG_INFORMATION14
440 ,P_ORG_INFORMATION15 => P_ORG_INFORMATION15
441 ,P_ORG_INFORMATION16 => P_ORG_INFORMATION16
442 );
443 elsif l_legislation_code = 'SG' then
444 PER_SG_ORG_INFO_LEG_HOOK.CHECK_SG_ORG_INFO_TYPE_UPDATE
445 (P_ORG_INFO_TYPE_CODE => P_ORG_INFO_TYPE_CODE
446 ,P_ORG_INFORMATION_ID => P_ORG_INFORMATION_ID
447 ,P_ORG_INFORMATION1 => P_ORG_INFORMATION1
448 ,P_ORG_INFORMATION2 => P_ORG_INFORMATION2
449 ,P_ORG_INFORMATION3 => P_ORG_INFORMATION3
450 ,P_ORG_INFORMATION4 => P_ORG_INFORMATION4
451 ,P_ORG_INFORMATION5 => P_ORG_INFORMATION5
452 ,P_ORG_INFORMATION6 => P_ORG_INFORMATION6
453 ,P_ORG_INFORMATION7 => P_ORG_INFORMATION7
454 ,P_ORG_INFORMATION8 => P_ORG_INFORMATION8
455 ,P_ORG_INFORMATION9 => P_ORG_INFORMATION9
456 ,P_ORG_INFORMATION10 => P_ORG_INFORMATION10
457 ,P_ORG_INFORMATION11 => P_ORG_INFORMATION11
458 ,P_ORG_INFORMATION12 => P_ORG_INFORMATION12
459 ,P_ORG_INFORMATION13 => P_ORG_INFORMATION13
460 ,P_ORG_INFORMATION14 => P_ORG_INFORMATION14
461 ,P_ORG_INFORMATION15 => P_ORG_INFORMATION15
462 ,P_ORG_INFORMATION16 => P_ORG_INFORMATION16
463 ,P_ORG_INFORMATION17 => P_ORG_INFORMATION17
464 ,P_ORG_INFORMATION18 => P_ORG_INFORMATION18
465 ,P_ORG_INFORMATION19 => P_ORG_INFORMATION19
466 ,P_ORG_INFORMATION20 => P_ORG_INFORMATION20
467 );
468 elsif l_legislation_code = 'US' then
469 PER_US_ORG_INFO_LEG_HOOK.UPDATE_US_ORG_INFO
470 (P_ORG_INFORMATION_ID => P_ORG_INFORMATION_ID
471 ,P_ORG_INFO_TYPE_CODE => P_ORG_INFO_TYPE_CODE
472 ,P_ORG_INFORMATION1 => P_ORG_INFORMATION1
473 ,P_ORG_INFORMATION2 => P_ORG_INFORMATION2
474 );
475 end if;
476 end if;
477 hr_api.validate_commit_unit(l_commit_unit_number, 'UPDATE_ORG_INFORMATION', 'BP');
478 hr_utility.set_location(' Leaving: HR_ORGANIZATION_BK2.UPDATE_ORG_INFORMATION_B', 20);
479 end UPDATE_ORG_INFORMATION_B;
480 end HR_ORGANIZATION_BK2;