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_BK1

Source


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