1 package body HZ_PER_PROFILES_EXT_PKG as
2 /* $Header: ARHEXPPB.pls 120.1 2006/02/09 10:16:18 jhuang noship $ */
3
4 procedure INSERT_ROW (
5 X_ROWID in out nocopy VARCHAR2,
6 X_EXTENSION_ID IN NUMBER,
7 X_PERSON_PROFILE_ID IN NUMBER,
8 X_OLD_EXTENSION_ID IN NUMBER,
9 X_ATTR_GROUP_ID IN NUMBER,
10 X_C_EXT_ATTR1 IN VARCHAR2,
11 X_C_EXT_ATTR2 IN VARCHAR2,
12 X_C_EXT_ATTR3 IN VARCHAR2,
13 X_C_EXT_ATTR4 IN VARCHAR2,
14 X_C_EXT_ATTR5 IN VARCHAR2,
15 X_C_EXT_ATTR6 IN VARCHAR2,
16 X_C_EXT_ATTR7 IN VARCHAR2,
17 X_C_EXT_ATTR8 IN VARCHAR2,
18 X_C_EXT_ATTR9 IN VARCHAR2,
19 X_C_EXT_ATTR10 IN VARCHAR2,
20 X_C_EXT_ATTR11 IN VARCHAR2,
21 X_C_EXT_ATTR12 IN VARCHAR2,
22 X_C_EXT_ATTR13 IN VARCHAR2,
23 X_C_EXT_ATTR14 IN VARCHAR2,
24 X_C_EXT_ATTR15 IN VARCHAR2,
25 X_C_EXT_ATTR16 IN VARCHAR2,
26 X_C_EXT_ATTR17 IN VARCHAR2,
27 X_C_EXT_ATTR18 IN VARCHAR2,
28 X_C_EXT_ATTR19 IN VARCHAR2,
29 X_C_EXT_ATTR20 IN VARCHAR2,
30 X_N_EXT_ATTR1 IN NUMBER,
31 X_N_EXT_ATTR2 IN NUMBER,
32 X_N_EXT_ATTR3 IN NUMBER,
33 X_N_EXT_ATTR4 IN NUMBER,
34 X_N_EXT_ATTR5 IN NUMBER,
35 X_N_EXT_ATTR6 IN NUMBER,
36 X_N_EXT_ATTR7 IN NUMBER,
37 X_N_EXT_ATTR8 IN NUMBER,
38 X_N_EXT_ATTR9 IN NUMBER,
39 X_N_EXT_ATTR10 IN NUMBER,
40 X_N_EXT_ATTR11 IN NUMBER,
41 X_N_EXT_ATTR12 IN NUMBER,
42 X_N_EXT_ATTR13 IN NUMBER,
43 X_N_EXT_ATTR14 IN NUMBER,
44 X_N_EXT_ATTR15 IN NUMBER,
45 X_N_EXT_ATTR16 IN NUMBER,
46 X_N_EXT_ATTR17 IN NUMBER,
47 X_N_EXT_ATTR18 IN NUMBER,
48 X_N_EXT_ATTR19 IN NUMBER,
49 X_N_EXT_ATTR20 IN NUMBER,
50 X_D_EXT_ATTR1 IN DATE,
51 X_D_EXT_ATTR2 IN DATE,
52 X_D_EXT_ATTR3 IN DATE,
53 X_D_EXT_ATTR4 IN DATE,
54 X_D_EXT_ATTR5 IN DATE,
55 X_D_EXT_ATTR6 IN DATE,
56 X_D_EXT_ATTR7 IN DATE,
57 X_D_EXT_ATTR8 IN DATE,
58 X_D_EXT_ATTR9 IN DATE,
59 X_D_EXT_ATTR10 IN DATE,
60 X_TL_EXT_ATTR1 IN VARCHAR2,
61 X_TL_EXT_ATTR2 IN VARCHAR2,
62 X_TL_EXT_ATTR3 IN VARCHAR2,
63 X_TL_EXT_ATTR4 IN VARCHAR2,
64 X_TL_EXT_ATTR5 IN VARCHAR2,
65 X_TL_EXT_ATTR6 IN VARCHAR2,
66 X_TL_EXT_ATTR7 IN VARCHAR2,
67 X_TL_EXT_ATTR8 IN VARCHAR2,
68 X_TL_EXT_ATTR9 IN VARCHAR2,
69 X_TL_EXT_ATTR10 IN VARCHAR2,
70 X_TL_EXT_ATTR11 IN VARCHAR2,
71 X_TL_EXT_ATTR12 IN VARCHAR2,
72 X_TL_EXT_ATTR13 IN VARCHAR2,
73 X_TL_EXT_ATTR14 IN VARCHAR2,
74 X_TL_EXT_ATTR15 IN VARCHAR2,
75 X_TL_EXT_ATTR16 IN VARCHAR2,
76 X_TL_EXT_ATTR17 IN VARCHAR2,
77 X_TL_EXT_ATTR18 IN VARCHAR2,
78 X_TL_EXT_ATTR19 IN VARCHAR2,
79 X_TL_EXT_ATTR20 IN VARCHAR2,
80 X_CREATION_DATE in DATE,
81 X_CREATED_BY in NUMBER,
82 X_LAST_UPDATE_DATE in DATE,
83 X_LAST_UPDATED_BY in NUMBER,
84 X_LAST_UPDATE_LOGIN in NUMBER
85 ) is
86 cursor C is select ROWID from HZ_PER_PROFILES_EXT_B
87 where EXTENSION_ID = X_EXTENSION_ID
88 ;
89 begin
90 insert into HZ_PER_PROFILES_EXT_B (
91 EXTENSION_ID,
92 PERSON_PROFILE_ID,
93 ATTR_GROUP_ID,
94 C_EXT_ATTR1,
95 C_EXT_ATTR2,
96 C_EXT_ATTR3,
97 C_EXT_ATTR4,
98 C_EXT_ATTR5,
99 C_EXT_ATTR6,
100 C_EXT_ATTR7,
101 C_EXT_ATTR8,
102 C_EXT_ATTR9,
103 C_EXT_ATTR10,
104 C_EXT_ATTR11,
105 C_EXT_ATTR12,
106 C_EXT_ATTR13,
107 C_EXT_ATTR14,
108 C_EXT_ATTR15,
109 C_EXT_ATTR16,
110 C_EXT_ATTR17,
111 C_EXT_ATTR18,
112 C_EXT_ATTR19,
113 C_EXT_ATTR20,
114 N_EXT_ATTR1,
115 N_EXT_ATTR2,
116 N_EXT_ATTR3,
117 N_EXT_ATTR4,
118 N_EXT_ATTR5,
119 N_EXT_ATTR6,
120 N_EXT_ATTR7,
121 N_EXT_ATTR8,
122 N_EXT_ATTR9,
123 N_EXT_ATTR10,
124 N_EXT_ATTR11,
125 N_EXT_ATTR12,
126 N_EXT_ATTR13,
127 N_EXT_ATTR14,
128 N_EXT_ATTR15,
129 N_EXT_ATTR16,
130 N_EXT_ATTR17,
131 N_EXT_ATTR18,
132 N_EXT_ATTR19,
133 N_EXT_ATTR20,
134 D_EXT_ATTR1,
135 D_EXT_ATTR2,
136 D_EXT_ATTR3,
137 D_EXT_ATTR4,
138 D_EXT_ATTR5,
139 D_EXT_ATTR6,
140 D_EXT_ATTR7,
141 D_EXT_ATTR8,
142 D_EXT_ATTR9,
143 D_EXT_ATTR10,
144 OLD_EXTENSION_ID,
145 CREATION_DATE,
146 CREATED_BY,
147 LAST_UPDATE_DATE,
148 LAST_UPDATED_BY,
149 LAST_UPDATE_LOGIN
150 ) values (
151 X_EXTENSION_ID,
152 X_PERSON_PROFILE_ID,
153 X_ATTR_GROUP_ID,
154 X_C_EXT_ATTR1,
155 X_C_EXT_ATTR2,
156 X_C_EXT_ATTR3,
157 X_C_EXT_ATTR4,
158 X_C_EXT_ATTR5,
159 X_C_EXT_ATTR6,
160 X_C_EXT_ATTR7,
161 X_C_EXT_ATTR8,
162 X_C_EXT_ATTR9,
163 X_C_EXT_ATTR10,
164 X_C_EXT_ATTR11,
165 X_C_EXT_ATTR12,
166 X_C_EXT_ATTR13,
167 X_C_EXT_ATTR14,
168 X_C_EXT_ATTR15,
169 X_C_EXT_ATTR16,
170 X_C_EXT_ATTR17,
171 X_C_EXT_ATTR18,
172 X_C_EXT_ATTR19,
173 X_C_EXT_ATTR20,
174 X_N_EXT_ATTR1,
175 X_N_EXT_ATTR2,
176 X_N_EXT_ATTR3,
177 X_N_EXT_ATTR4,
178 X_N_EXT_ATTR5,
179 X_N_EXT_ATTR6,
180 X_N_EXT_ATTR7,
181 X_N_EXT_ATTR8,
182 X_N_EXT_ATTR9,
183 X_N_EXT_ATTR10,
184 X_N_EXT_ATTR11,
185 X_N_EXT_ATTR12,
186 X_N_EXT_ATTR13,
187 X_N_EXT_ATTR14,
188 X_N_EXT_ATTR15,
189 X_N_EXT_ATTR16,
190 X_N_EXT_ATTR17,
191 X_N_EXT_ATTR18,
192 X_N_EXT_ATTR19,
193 X_N_EXT_ATTR20,
194 X_D_EXT_ATTR1,
195 X_D_EXT_ATTR2,
196 X_D_EXT_ATTR3,
197 X_D_EXT_ATTR4,
198 X_D_EXT_ATTR5,
199 X_D_EXT_ATTR6,
200 X_D_EXT_ATTR7,
201 X_D_EXT_ATTR8,
202 X_D_EXT_ATTR9,
203 X_D_EXT_ATTR10,
204 X_OLD_EXTENSION_ID,
205 X_CREATION_DATE,
206 X_CREATED_BY,
207 X_LAST_UPDATE_DATE,
208 X_LAST_UPDATED_BY,
209 X_LAST_UPDATE_LOGIN
210 );
211
212 insert into HZ_PER_PROFILES_EXT_TL (
213 EXTENSION_ID,
214 PERSON_PROFILE_ID,
215 ATTR_GROUP_ID,
216 CREATED_BY,
217 CREATION_DATE,
218 LAST_UPDATED_BY,
219 LAST_UPDATE_DATE,
220 LAST_UPDATE_LOGIN,
221 TL_EXT_ATTR1,
222 TL_EXT_ATTR2,
223 TL_EXT_ATTR3,
224 TL_EXT_ATTR4,
225 TL_EXT_ATTR5,
226 TL_EXT_ATTR6,
227 TL_EXT_ATTR7,
228 TL_EXT_ATTR8,
229 TL_EXT_ATTR9,
230 TL_EXT_ATTR10,
231 TL_EXT_ATTR11,
232 TL_EXT_ATTR12,
233 TL_EXT_ATTR13,
234 TL_EXT_ATTR14,
235 TL_EXT_ATTR15,
236 TL_EXT_ATTR16,
237 TL_EXT_ATTR17,
238 TL_EXT_ATTR18,
239 TL_EXT_ATTR19,
240 TL_EXT_ATTR20,
241 LANGUAGE,
242 SOURCE_LANG
243 ) select
244 X_EXTENSION_ID,
245 X_PERSON_PROFILE_ID,
246 X_ATTR_GROUP_ID,
247 X_CREATED_BY,
248 X_CREATION_DATE,
249 X_LAST_UPDATED_BY,
250 X_LAST_UPDATE_DATE,
251 X_LAST_UPDATE_LOGIN,
252 X_TL_EXT_ATTR1,
253 X_TL_EXT_ATTR2,
254 X_TL_EXT_ATTR3,
255 X_TL_EXT_ATTR4,
256 X_TL_EXT_ATTR5,
257 X_TL_EXT_ATTR6,
258 X_TL_EXT_ATTR7,
259 X_TL_EXT_ATTR8,
260 X_TL_EXT_ATTR9,
261 X_TL_EXT_ATTR10,
262 X_TL_EXT_ATTR11,
263 X_TL_EXT_ATTR12,
264 X_TL_EXT_ATTR13,
265 X_TL_EXT_ATTR14,
266 X_TL_EXT_ATTR15,
267 X_TL_EXT_ATTR16,
268 X_TL_EXT_ATTR17,
269 X_TL_EXT_ATTR18,
270 X_TL_EXT_ATTR19,
271 X_TL_EXT_ATTR20,
272 L.LANGUAGE_CODE,
273 userenv('LANG')
274 from FND_LANGUAGES L
275 where L.INSTALLED_FLAG in ('I', 'B')
276 and not exists
277 (select NULL
278 from HZ_PER_PROFILES_EXT_TL T
279 where T.EXTENSION_ID = X_EXTENSION_ID
280 and T.LANGUAGE = L.LANGUAGE_CODE);
281
282 open c;
283 fetch c into X_ROWID;
284 if (c%notfound) then
285 close c;
286 raise no_data_found;
287 end if;
288 close c;
289
290 end INSERT_ROW;
291
292 procedure LOCK_ROW (
293 X_EXTENSION_ID IN NUMBER,
294 X_PERSON_PROFILE_ID IN NUMBER,
295 X_OLD_EXTENSION_ID IN NUMBER,
296 X_ATTR_GROUP_ID IN NUMBER,
297 X_C_EXT_ATTR1 IN VARCHAR2,
298 X_C_EXT_ATTR2 IN VARCHAR2,
299 X_C_EXT_ATTR3 IN VARCHAR2,
300 X_C_EXT_ATTR4 IN VARCHAR2,
301 X_C_EXT_ATTR5 IN VARCHAR2,
302 X_C_EXT_ATTR6 IN VARCHAR2,
303 X_C_EXT_ATTR7 IN VARCHAR2,
304 X_C_EXT_ATTR8 IN VARCHAR2,
305 X_C_EXT_ATTR9 IN VARCHAR2,
306 X_C_EXT_ATTR10 IN VARCHAR2,
307 X_C_EXT_ATTR11 IN VARCHAR2,
308 X_C_EXT_ATTR12 IN VARCHAR2,
309 X_C_EXT_ATTR13 IN VARCHAR2,
310 X_C_EXT_ATTR14 IN VARCHAR2,
311 X_C_EXT_ATTR15 IN VARCHAR2,
312 X_C_EXT_ATTR16 IN VARCHAR2,
313 X_C_EXT_ATTR17 IN VARCHAR2,
314 X_C_EXT_ATTR18 IN VARCHAR2,
315 X_C_EXT_ATTR19 IN VARCHAR2,
316 X_C_EXT_ATTR20 IN VARCHAR2,
317 X_N_EXT_ATTR1 IN NUMBER,
318 X_N_EXT_ATTR2 IN NUMBER,
319 X_N_EXT_ATTR3 IN NUMBER,
320 X_N_EXT_ATTR4 IN NUMBER,
321 X_N_EXT_ATTR5 IN NUMBER,
322 X_N_EXT_ATTR6 IN NUMBER,
323 X_N_EXT_ATTR7 IN NUMBER,
324 X_N_EXT_ATTR8 IN NUMBER,
325 X_N_EXT_ATTR9 IN NUMBER,
326 X_N_EXT_ATTR10 IN NUMBER,
327 X_N_EXT_ATTR11 IN NUMBER,
328 X_N_EXT_ATTR12 IN NUMBER,
329 X_N_EXT_ATTR13 IN NUMBER,
330 X_N_EXT_ATTR14 IN NUMBER,
331 X_N_EXT_ATTR15 IN NUMBER,
332 X_N_EXT_ATTR16 IN NUMBER,
333 X_N_EXT_ATTR17 IN NUMBER,
334 X_N_EXT_ATTR18 IN NUMBER,
335 X_N_EXT_ATTR19 IN NUMBER,
336 X_N_EXT_ATTR20 IN NUMBER,
337 X_D_EXT_ATTR1 IN DATE,
338 X_D_EXT_ATTR2 IN DATE,
339 X_D_EXT_ATTR3 IN DATE,
340 X_D_EXT_ATTR4 IN DATE,
341 X_D_EXT_ATTR5 IN DATE,
342 X_D_EXT_ATTR6 IN DATE,
343 X_D_EXT_ATTR7 IN DATE,
344 X_D_EXT_ATTR8 IN DATE,
345 X_D_EXT_ATTR9 IN DATE,
346 X_D_EXT_ATTR10 IN DATE,
347 X_TL_EXT_ATTR1 IN VARCHAR2,
348 X_TL_EXT_ATTR2 IN VARCHAR2,
349 X_TL_EXT_ATTR3 IN VARCHAR2,
350 X_TL_EXT_ATTR4 IN VARCHAR2,
351 X_TL_EXT_ATTR5 IN VARCHAR2,
352 X_TL_EXT_ATTR6 IN VARCHAR2,
353 X_TL_EXT_ATTR7 IN VARCHAR2,
354 X_TL_EXT_ATTR8 IN VARCHAR2,
355 X_TL_EXT_ATTR9 IN VARCHAR2,
356 X_TL_EXT_ATTR10 IN VARCHAR2,
357 X_TL_EXT_ATTR11 IN VARCHAR2,
358 X_TL_EXT_ATTR12 IN VARCHAR2,
359 X_TL_EXT_ATTR13 IN VARCHAR2,
360 X_TL_EXT_ATTR14 IN VARCHAR2,
361 X_TL_EXT_ATTR15 IN VARCHAR2,
362 X_TL_EXT_ATTR16 IN VARCHAR2,
363 X_TL_EXT_ATTR17 IN VARCHAR2,
364 X_TL_EXT_ATTR18 IN VARCHAR2,
365 X_TL_EXT_ATTR19 IN VARCHAR2,
366 X_TL_EXT_ATTR20 IN VARCHAR2
367 ) is
368 cursor c is select
369 PERSON_PROFILE_ID,
370 ATTR_GROUP_ID,
371 C_EXT_ATTR1,
372 C_EXT_ATTR2,
373 C_EXT_ATTR3,
374 C_EXT_ATTR4,
375 C_EXT_ATTR5,
376 C_EXT_ATTR6,
377 C_EXT_ATTR7,
378 C_EXT_ATTR8,
379 C_EXT_ATTR9,
380 C_EXT_ATTR10,
381 C_EXT_ATTR11,
382 C_EXT_ATTR12,
383 C_EXT_ATTR13,
384 C_EXT_ATTR14,
385 C_EXT_ATTR15,
386 C_EXT_ATTR16,
387 C_EXT_ATTR17,
388 C_EXT_ATTR18,
389 C_EXT_ATTR19,
390 C_EXT_ATTR20,
391 N_EXT_ATTR1,
392 N_EXT_ATTR2,
393 N_EXT_ATTR3,
394 N_EXT_ATTR4,
395 N_EXT_ATTR5,
396 N_EXT_ATTR6,
397 N_EXT_ATTR7,
398 N_EXT_ATTR8,
399 N_EXT_ATTR9,
400 N_EXT_ATTR10,
401 N_EXT_ATTR11,
402 N_EXT_ATTR12,
403 N_EXT_ATTR13,
404 N_EXT_ATTR14,
405 N_EXT_ATTR15,
406 N_EXT_ATTR16,
407 N_EXT_ATTR17,
408 N_EXT_ATTR18,
409 N_EXT_ATTR19,
410 N_EXT_ATTR20,
411 D_EXT_ATTR1,
412 D_EXT_ATTR2,
413 D_EXT_ATTR3,
414 D_EXT_ATTR4,
415 D_EXT_ATTR5,
416 D_EXT_ATTR6,
417 D_EXT_ATTR7,
418 D_EXT_ATTR8,
419 D_EXT_ATTR9,
420 D_EXT_ATTR10,
421 OLD_EXTENSION_ID
422 from HZ_PER_PROFILES_EXT_B
423 where EXTENSION_ID = X_EXTENSION_ID
424 for update of EXTENSION_ID nowait;
425 recinfo c%rowtype;
426
427 cursor c1 is select
428 TL_EXT_ATTR1,
429 TL_EXT_ATTR2,
430 TL_EXT_ATTR3,
431 TL_EXT_ATTR4,
432 TL_EXT_ATTR5,
433 TL_EXT_ATTR6,
434 TL_EXT_ATTR7,
435 TL_EXT_ATTR8,
436 TL_EXT_ATTR9,
437 TL_EXT_ATTR10,
438 TL_EXT_ATTR11,
439 TL_EXT_ATTR12,
440 TL_EXT_ATTR13,
441 TL_EXT_ATTR14,
442 TL_EXT_ATTR15,
443 TL_EXT_ATTR16,
444 TL_EXT_ATTR17,
445 TL_EXT_ATTR18,
446 TL_EXT_ATTR19,
447 TL_EXT_ATTR20,
448 decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
449 from HZ_PER_PROFILES_EXT_TL
450 where EXTENSION_ID = X_EXTENSION_ID
451 and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
452 for update of EXTENSION_ID nowait;
453 begin
454 open c;
455 fetch c into recinfo;
456 if (c%notfound) then
457 close c;
458 fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
459 app_exception.raise_exception;
460 end if;
461 close c;
462 if ( (recinfo.PERSON_PROFILE_ID = X_PERSON_PROFILE_ID)
463 AND (recinfo.ATTR_GROUP_ID = X_ATTR_GROUP_ID)
464 AND ((recinfo.C_EXT_ATTR1 = X_C_EXT_ATTR1)
465 OR ((recinfo.C_EXT_ATTR1 is null) AND (X_C_EXT_ATTR1 is null)))
466 AND ((recinfo.C_EXT_ATTR2 = X_C_EXT_ATTR2)
467 OR ((recinfo.C_EXT_ATTR2 is null) AND (X_C_EXT_ATTR2 is null)))
468 AND ((recinfo.C_EXT_ATTR3 = X_C_EXT_ATTR3)
469 OR ((recinfo.C_EXT_ATTR3 is null) AND (X_C_EXT_ATTR3 is null)))
470 AND ((recinfo.C_EXT_ATTR4 = X_C_EXT_ATTR4)
471 OR ((recinfo.C_EXT_ATTR4 is null) AND (X_C_EXT_ATTR4 is null)))
472 AND ((recinfo.C_EXT_ATTR5 = X_C_EXT_ATTR5)
473 OR ((recinfo.C_EXT_ATTR5 is null) AND (X_C_EXT_ATTR5 is null)))
474 AND ((recinfo.C_EXT_ATTR6 = X_C_EXT_ATTR6)
475 OR ((recinfo.C_EXT_ATTR6 is null) AND (X_C_EXT_ATTR6 is null)))
476 AND ((recinfo.C_EXT_ATTR7 = X_C_EXT_ATTR7)
477 OR ((recinfo.C_EXT_ATTR7 is null) AND (X_C_EXT_ATTR7 is null)))
478 AND ((recinfo.C_EXT_ATTR8 = X_C_EXT_ATTR8)
479 OR ((recinfo.C_EXT_ATTR8 is null) AND (X_C_EXT_ATTR8 is null)))
480 AND ((recinfo.C_EXT_ATTR9 = X_C_EXT_ATTR9)
481 OR ((recinfo.C_EXT_ATTR9 is null) AND (X_C_EXT_ATTR9 is null)))
482 AND ((recinfo.C_EXT_ATTR10 = X_C_EXT_ATTR10)
483 OR ((recinfo.C_EXT_ATTR10 is null) AND (X_C_EXT_ATTR10 is null)))
484 AND ((recinfo.C_EXT_ATTR11 = X_C_EXT_ATTR11)
485 OR ((recinfo.C_EXT_ATTR11 is null) AND (X_C_EXT_ATTR11 is null)))
486 AND ((recinfo.C_EXT_ATTR12 = X_C_EXT_ATTR12)
487 OR ((recinfo.C_EXT_ATTR12 is null) AND (X_C_EXT_ATTR12 is null)))
488 AND ((recinfo.C_EXT_ATTR13 = X_C_EXT_ATTR13)
489 OR ((recinfo.C_EXT_ATTR13 is null) AND (X_C_EXT_ATTR13 is null)))
490 AND ((recinfo.C_EXT_ATTR14 = X_C_EXT_ATTR14)
491 OR ((recinfo.C_EXT_ATTR14 is null) AND (X_C_EXT_ATTR14 is null)))
492 AND ((recinfo.C_EXT_ATTR15 = X_C_EXT_ATTR15)
493 OR ((recinfo.C_EXT_ATTR15 is null) AND (X_C_EXT_ATTR15 is null)))
494 AND ((recinfo.C_EXT_ATTR16 = X_C_EXT_ATTR16)
495 OR ((recinfo.C_EXT_ATTR16 is null) AND (X_C_EXT_ATTR16 is null)))
496 AND ((recinfo.C_EXT_ATTR17 = X_C_EXT_ATTR17)
497 OR ((recinfo.C_EXT_ATTR17 is null) AND (X_C_EXT_ATTR17 is null)))
498 AND ((recinfo.C_EXT_ATTR18 = X_C_EXT_ATTR18)
499 OR ((recinfo.C_EXT_ATTR18 is null) AND (X_C_EXT_ATTR18 is null)))
500 AND ((recinfo.C_EXT_ATTR19 = X_C_EXT_ATTR19)
501 OR ((recinfo.C_EXT_ATTR19 is null) AND (X_C_EXT_ATTR19 is null)))
502 AND ((recinfo.C_EXT_ATTR20 = X_C_EXT_ATTR20)
503 OR ((recinfo.C_EXT_ATTR20 is null) AND (X_C_EXT_ATTR20 is null)))
504 AND ((recinfo.N_EXT_ATTR1 = X_N_EXT_ATTR1)
505 OR ((recinfo.N_EXT_ATTR1 is null) AND (X_N_EXT_ATTR1 is null)))
506 AND ((recinfo.N_EXT_ATTR2 = X_N_EXT_ATTR2)
507 OR ((recinfo.N_EXT_ATTR2 is null) AND (X_N_EXT_ATTR2 is null)))
508 AND ((recinfo.N_EXT_ATTR3 = X_N_EXT_ATTR3)
509 OR ((recinfo.N_EXT_ATTR3 is null) AND (X_N_EXT_ATTR3 is null)))
510 AND ((recinfo.N_EXT_ATTR4 = X_N_EXT_ATTR4)
511 OR ((recinfo.N_EXT_ATTR4 is null) AND (X_N_EXT_ATTR4 is null)))
512 AND ((recinfo.N_EXT_ATTR5 = X_N_EXT_ATTR5)
513 OR ((recinfo.N_EXT_ATTR5 is null) AND (X_N_EXT_ATTR5 is null)))
514 AND ((recinfo.N_EXT_ATTR6 = X_N_EXT_ATTR6)
515 OR ((recinfo.N_EXT_ATTR6 is null) AND (X_N_EXT_ATTR6 is null)))
516 AND ((recinfo.N_EXT_ATTR7 = X_N_EXT_ATTR7)
517 OR ((recinfo.N_EXT_ATTR7 is null) AND (X_N_EXT_ATTR7 is null)))
518 AND ((recinfo.N_EXT_ATTR8 = X_N_EXT_ATTR8)
519 OR ((recinfo.N_EXT_ATTR8 is null) AND (X_N_EXT_ATTR8 is null)))
520 AND ((recinfo.N_EXT_ATTR9 = X_N_EXT_ATTR9)
521 OR ((recinfo.N_EXT_ATTR9 is null) AND (X_N_EXT_ATTR9 is null)))
522 AND ((recinfo.N_EXT_ATTR10 = X_N_EXT_ATTR10)
523 OR ((recinfo.N_EXT_ATTR10 is null) AND (X_N_EXT_ATTR10 is null)))
524 AND ((recinfo.N_EXT_ATTR11 = X_N_EXT_ATTR11)
525 OR ((recinfo.N_EXT_ATTR11 is null) AND (X_N_EXT_ATTR11 is null)))
526 AND ((recinfo.N_EXT_ATTR12 = X_N_EXT_ATTR12)
527 OR ((recinfo.N_EXT_ATTR12 is null) AND (X_N_EXT_ATTR12 is null)))
528 AND ((recinfo.N_EXT_ATTR13 = X_N_EXT_ATTR13)
529 OR ((recinfo.N_EXT_ATTR13 is null) AND (X_N_EXT_ATTR13 is null)))
530 AND ((recinfo.N_EXT_ATTR14 = X_N_EXT_ATTR14)
531 OR ((recinfo.N_EXT_ATTR14 is null) AND (X_N_EXT_ATTR14 is null)))
532 AND ((recinfo.N_EXT_ATTR15 = X_N_EXT_ATTR15)
533 OR ((recinfo.N_EXT_ATTR15 is null) AND (X_N_EXT_ATTR15 is null)))
534 AND ((recinfo.N_EXT_ATTR16 = X_N_EXT_ATTR16)
535 OR ((recinfo.N_EXT_ATTR16 is null) AND (X_N_EXT_ATTR16 is null)))
536 AND ((recinfo.N_EXT_ATTR17 = X_N_EXT_ATTR17)
537 OR ((recinfo.N_EXT_ATTR17 is null) AND (X_N_EXT_ATTR17 is null)))
538 AND ((recinfo.N_EXT_ATTR18 = X_N_EXT_ATTR18)
539 OR ((recinfo.N_EXT_ATTR18 is null) AND (X_N_EXT_ATTR18 is null)))
540 AND ((recinfo.N_EXT_ATTR19 = X_N_EXT_ATTR19)
541 OR ((recinfo.N_EXT_ATTR19 is null) AND (X_N_EXT_ATTR19 is null)))
542 AND ((recinfo.N_EXT_ATTR20 = X_N_EXT_ATTR20)
543 OR ((recinfo.N_EXT_ATTR20 is null) AND (X_N_EXT_ATTR20 is null)))
544 AND ((recinfo.D_EXT_ATTR1 = X_D_EXT_ATTR1)
545 OR ((recinfo.D_EXT_ATTR1 is null) AND (X_D_EXT_ATTR1 is null)))
546 AND ((recinfo.D_EXT_ATTR2 = X_D_EXT_ATTR2)
547 OR ((recinfo.D_EXT_ATTR2 is null) AND (X_D_EXT_ATTR2 is null)))
548 AND ((recinfo.D_EXT_ATTR3 = X_D_EXT_ATTR3)
549 OR ((recinfo.D_EXT_ATTR3 is null) AND (X_D_EXT_ATTR3 is null)))
550 AND ((recinfo.D_EXT_ATTR4 = X_D_EXT_ATTR4)
551 OR ((recinfo.D_EXT_ATTR4 is null) AND (X_D_EXT_ATTR4 is null)))
552 AND ((recinfo.D_EXT_ATTR5 = X_D_EXT_ATTR5)
553 OR ((recinfo.D_EXT_ATTR5 is null) AND (X_D_EXT_ATTR5 is null)))
554 AND ((recinfo.D_EXT_ATTR6 = X_D_EXT_ATTR6)
555 OR ((recinfo.D_EXT_ATTR6 is null) AND (X_D_EXT_ATTR6 is null)))
556 AND ((recinfo.D_EXT_ATTR7 = X_D_EXT_ATTR7)
557 OR ((recinfo.D_EXT_ATTR7 is null) AND (X_D_EXT_ATTR7 is null)))
558 AND ((recinfo.D_EXT_ATTR8 = X_D_EXT_ATTR8)
559 OR ((recinfo.D_EXT_ATTR8 is null) AND (X_D_EXT_ATTR8 is null)))
560 AND ((recinfo.D_EXT_ATTR9 = X_D_EXT_ATTR9)
561 OR ((recinfo.D_EXT_ATTR9 is null) AND (X_D_EXT_ATTR9 is null)))
562 AND ((recinfo.D_EXT_ATTR10 = X_D_EXT_ATTR10)
563 OR ((recinfo.D_EXT_ATTR10 is null) AND (X_D_EXT_ATTR10 is null)))
564 AND ((recinfo.OLD_EXTENSION_ID = X_OLD_EXTENSION_ID)
565 OR ((recinfo.OLD_EXTENSION_ID is null) AND (X_OLD_EXTENSION_ID is null)))
566 ) then
567 null;
568 else
569 fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
570 app_exception.raise_exception;
571 end if;
572
573 for tlinfo in c1 loop
574 if (tlinfo.BASELANG = 'Y') then
575 if ( ((tlinfo.TL_EXT_ATTR1 = X_TL_EXT_ATTR1)
576 OR ((tlinfo.TL_EXT_ATTR1 is null) AND (X_TL_EXT_ATTR1 is null)))
577 AND ((tlinfo.TL_EXT_ATTR2 = X_TL_EXT_ATTR2)
578 OR ((tlinfo.TL_EXT_ATTR2 is null) AND (X_TL_EXT_ATTR2 is null)))
579 AND ((tlinfo.TL_EXT_ATTR3 = X_TL_EXT_ATTR3)
580 OR ((tlinfo.TL_EXT_ATTR3 is null) AND (X_TL_EXT_ATTR3 is null)))
581 AND ((tlinfo.TL_EXT_ATTR4 = X_TL_EXT_ATTR4)
582 OR ((tlinfo.TL_EXT_ATTR4 is null) AND (X_TL_EXT_ATTR4 is null)))
583 AND ((tlinfo.TL_EXT_ATTR5 = X_TL_EXT_ATTR5)
584 OR ((tlinfo.TL_EXT_ATTR5 is null) AND (X_TL_EXT_ATTR5 is null)))
585 AND ((tlinfo.TL_EXT_ATTR6 = X_TL_EXT_ATTR6)
586 OR ((tlinfo.TL_EXT_ATTR6 is null) AND (X_TL_EXT_ATTR6 is null)))
587 AND ((tlinfo.TL_EXT_ATTR7 = X_TL_EXT_ATTR7)
588 OR ((tlinfo.TL_EXT_ATTR7 is null) AND (X_TL_EXT_ATTR7 is null)))
589 AND ((tlinfo.TL_EXT_ATTR8 = X_TL_EXT_ATTR8)
590 OR ((tlinfo.TL_EXT_ATTR8 is null) AND (X_TL_EXT_ATTR8 is null)))
591 AND ((tlinfo.TL_EXT_ATTR9 = X_TL_EXT_ATTR9)
592 OR ((tlinfo.TL_EXT_ATTR9 is null) AND (X_TL_EXT_ATTR9 is null)))
593 AND ((tlinfo.TL_EXT_ATTR10 = X_TL_EXT_ATTR10)
594 OR ((tlinfo.TL_EXT_ATTR10 is null) AND (X_TL_EXT_ATTR10 is null)))
595 AND ((tlinfo.TL_EXT_ATTR11 = X_TL_EXT_ATTR11)
596 OR ((tlinfo.TL_EXT_ATTR11 is null) AND (X_TL_EXT_ATTR11 is null)))
597 AND ((tlinfo.TL_EXT_ATTR12 = X_TL_EXT_ATTR12)
598 OR ((tlinfo.TL_EXT_ATTR12 is null) AND (X_TL_EXT_ATTR12 is null)))
599 AND ((tlinfo.TL_EXT_ATTR13 = X_TL_EXT_ATTR13)
600 OR ((tlinfo.TL_EXT_ATTR13 is null) AND (X_TL_EXT_ATTR13 is null)))
601 AND ((tlinfo.TL_EXT_ATTR14 = X_TL_EXT_ATTR14)
602 OR ((tlinfo.TL_EXT_ATTR14 is null) AND (X_TL_EXT_ATTR14 is null)))
603 AND ((tlinfo.TL_EXT_ATTR15 = X_TL_EXT_ATTR15)
604 OR ((tlinfo.TL_EXT_ATTR15 is null) AND (X_TL_EXT_ATTR15 is null)))
605 AND ((tlinfo.TL_EXT_ATTR16 = X_TL_EXT_ATTR16)
606 OR ((tlinfo.TL_EXT_ATTR16 is null) AND (X_TL_EXT_ATTR16 is null)))
607 AND ((tlinfo.TL_EXT_ATTR17 = X_TL_EXT_ATTR17)
608 OR ((tlinfo.TL_EXT_ATTR17 is null) AND (X_TL_EXT_ATTR17 is null)))
609 AND ((tlinfo.TL_EXT_ATTR18 = X_TL_EXT_ATTR18)
610 OR ((tlinfo.TL_EXT_ATTR18 is null) AND (X_TL_EXT_ATTR18 is null)))
611 AND ((tlinfo.TL_EXT_ATTR19 = X_TL_EXT_ATTR19)
612 OR ((tlinfo.TL_EXT_ATTR19 is null) AND (X_TL_EXT_ATTR19 is null)))
613 AND ((tlinfo.TL_EXT_ATTR20 = X_TL_EXT_ATTR20)
614 OR ((tlinfo.TL_EXT_ATTR20 is null) AND (X_TL_EXT_ATTR20 is null)))
615 ) then
616 null;
617 else
618 fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
619 app_exception.raise_exception;
620 end if;
621 end if;
622 end loop;
623 return;
624 end LOCK_ROW;
625
626 procedure UPDATE_ROW (
627 X_EXTENSION_ID IN NUMBER,
628 X_PERSON_PROFILE_ID IN NUMBER,
629 X_OLD_EXTENSION_ID IN NUMBER,
630 X_ATTR_GROUP_ID IN NUMBER,
631 X_C_EXT_ATTR1 IN VARCHAR2,
632 X_C_EXT_ATTR2 IN VARCHAR2,
633 X_C_EXT_ATTR3 IN VARCHAR2,
634 X_C_EXT_ATTR4 IN VARCHAR2,
635 X_C_EXT_ATTR5 IN VARCHAR2,
636 X_C_EXT_ATTR6 IN VARCHAR2,
637 X_C_EXT_ATTR7 IN VARCHAR2,
638 X_C_EXT_ATTR8 IN VARCHAR2,
639 X_C_EXT_ATTR9 IN VARCHAR2,
640 X_C_EXT_ATTR10 IN VARCHAR2,
641 X_C_EXT_ATTR11 IN VARCHAR2,
642 X_C_EXT_ATTR12 IN VARCHAR2,
643 X_C_EXT_ATTR13 IN VARCHAR2,
644 X_C_EXT_ATTR14 IN VARCHAR2,
645 X_C_EXT_ATTR15 IN VARCHAR2,
646 X_C_EXT_ATTR16 IN VARCHAR2,
647 X_C_EXT_ATTR17 IN VARCHAR2,
648 X_C_EXT_ATTR18 IN VARCHAR2,
649 X_C_EXT_ATTR19 IN VARCHAR2,
650 X_C_EXT_ATTR20 IN VARCHAR2,
651 X_N_EXT_ATTR1 IN NUMBER,
652 X_N_EXT_ATTR2 IN NUMBER,
653 X_N_EXT_ATTR3 IN NUMBER,
654 X_N_EXT_ATTR4 IN NUMBER,
655 X_N_EXT_ATTR5 IN NUMBER,
656 X_N_EXT_ATTR6 IN NUMBER,
657 X_N_EXT_ATTR7 IN NUMBER,
658 X_N_EXT_ATTR8 IN NUMBER,
659 X_N_EXT_ATTR9 IN NUMBER,
660 X_N_EXT_ATTR10 IN NUMBER,
661 X_N_EXT_ATTR11 IN NUMBER,
662 X_N_EXT_ATTR12 IN NUMBER,
663 X_N_EXT_ATTR13 IN NUMBER,
664 X_N_EXT_ATTR14 IN NUMBER,
665 X_N_EXT_ATTR15 IN NUMBER,
666 X_N_EXT_ATTR16 IN NUMBER,
667 X_N_EXT_ATTR17 IN NUMBER,
668 X_N_EXT_ATTR18 IN NUMBER,
669 X_N_EXT_ATTR19 IN NUMBER,
670 X_N_EXT_ATTR20 IN NUMBER,
671 X_D_EXT_ATTR1 IN DATE,
672 X_D_EXT_ATTR2 IN DATE,
673 X_D_EXT_ATTR3 IN DATE,
674 X_D_EXT_ATTR4 IN DATE,
675 X_D_EXT_ATTR5 IN DATE,
676 X_D_EXT_ATTR6 IN DATE,
677 X_D_EXT_ATTR7 IN DATE,
678 X_D_EXT_ATTR8 IN DATE,
679 X_D_EXT_ATTR9 IN DATE,
680 X_D_EXT_ATTR10 IN DATE,
681 X_TL_EXT_ATTR1 IN VARCHAR2,
682 X_TL_EXT_ATTR2 IN VARCHAR2,
683 X_TL_EXT_ATTR3 IN VARCHAR2,
684 X_TL_EXT_ATTR4 IN VARCHAR2,
685 X_TL_EXT_ATTR5 IN VARCHAR2,
686 X_TL_EXT_ATTR6 IN VARCHAR2,
687 X_TL_EXT_ATTR7 IN VARCHAR2,
688 X_TL_EXT_ATTR8 IN VARCHAR2,
689 X_TL_EXT_ATTR9 IN VARCHAR2,
690 X_TL_EXT_ATTR10 IN VARCHAR2,
691 X_TL_EXT_ATTR11 IN VARCHAR2,
692 X_TL_EXT_ATTR12 IN VARCHAR2,
693 X_TL_EXT_ATTR13 IN VARCHAR2,
694 X_TL_EXT_ATTR14 IN VARCHAR2,
695 X_TL_EXT_ATTR15 IN VARCHAR2,
696 X_TL_EXT_ATTR16 IN VARCHAR2,
697 X_TL_EXT_ATTR17 IN VARCHAR2,
698 X_TL_EXT_ATTR18 IN VARCHAR2,
699 X_TL_EXT_ATTR19 IN VARCHAR2,
700 X_TL_EXT_ATTR20 IN VARCHAR2,
701 X_LAST_UPDATE_DATE in DATE,
702 X_LAST_UPDATED_BY in NUMBER,
703 X_LAST_UPDATE_LOGIN in NUMBER
704 ) is
705 begin
706 update HZ_PER_PROFILES_EXT_B set
707 PERSON_PROFILE_ID = X_PERSON_PROFILE_ID,
708 ATTR_GROUP_ID = X_ATTR_GROUP_ID,
709 C_EXT_ATTR1 = X_C_EXT_ATTR1,
710 C_EXT_ATTR2 = X_C_EXT_ATTR2,
711 C_EXT_ATTR3 = X_C_EXT_ATTR3,
712 C_EXT_ATTR4 = X_C_EXT_ATTR4,
713 C_EXT_ATTR5 = X_C_EXT_ATTR5,
714 C_EXT_ATTR6 = X_C_EXT_ATTR6,
715 C_EXT_ATTR7 = X_C_EXT_ATTR7,
716 C_EXT_ATTR8 = X_C_EXT_ATTR8,
717 C_EXT_ATTR9 = X_C_EXT_ATTR9,
718 C_EXT_ATTR10 = X_C_EXT_ATTR10,
719 C_EXT_ATTR11 = X_C_EXT_ATTR11,
720 C_EXT_ATTR12 = X_C_EXT_ATTR12,
721 C_EXT_ATTR13 = X_C_EXT_ATTR13,
722 C_EXT_ATTR14 = X_C_EXT_ATTR14,
723 C_EXT_ATTR15 = X_C_EXT_ATTR15,
724 C_EXT_ATTR16 = X_C_EXT_ATTR16,
725 C_EXT_ATTR17 = X_C_EXT_ATTR17,
726 C_EXT_ATTR18 = X_C_EXT_ATTR18,
727 C_EXT_ATTR19 = X_C_EXT_ATTR19,
728 C_EXT_ATTR20 = X_C_EXT_ATTR20,
729 N_EXT_ATTR1 = X_N_EXT_ATTR1,
730 N_EXT_ATTR2 = X_N_EXT_ATTR2,
731 N_EXT_ATTR3 = X_N_EXT_ATTR3,
732 N_EXT_ATTR4 = X_N_EXT_ATTR4,
733 N_EXT_ATTR5 = X_N_EXT_ATTR5,
734 N_EXT_ATTR6 = X_N_EXT_ATTR6,
735 N_EXT_ATTR7 = X_N_EXT_ATTR7,
736 N_EXT_ATTR8 = X_N_EXT_ATTR8,
737 N_EXT_ATTR9 = X_N_EXT_ATTR9,
738 N_EXT_ATTR10 = X_N_EXT_ATTR10,
739 N_EXT_ATTR11 = X_N_EXT_ATTR11,
740 N_EXT_ATTR12 = X_N_EXT_ATTR12,
741 N_EXT_ATTR13 = X_N_EXT_ATTR13,
742 N_EXT_ATTR14 = X_N_EXT_ATTR14,
743 N_EXT_ATTR15 = X_N_EXT_ATTR15,
744 N_EXT_ATTR16 = X_N_EXT_ATTR16,
745 N_EXT_ATTR17 = X_N_EXT_ATTR17,
746 N_EXT_ATTR18 = X_N_EXT_ATTR18,
747 N_EXT_ATTR19 = X_N_EXT_ATTR19,
748 N_EXT_ATTR20 = X_N_EXT_ATTR20,
749 D_EXT_ATTR1 = X_D_EXT_ATTR1,
750 D_EXT_ATTR2 = X_D_EXT_ATTR2,
751 D_EXT_ATTR3 = X_D_EXT_ATTR3,
752 D_EXT_ATTR4 = X_D_EXT_ATTR4,
753 D_EXT_ATTR5 = X_D_EXT_ATTR5,
754 D_EXT_ATTR6 = X_D_EXT_ATTR6,
755 D_EXT_ATTR7 = X_D_EXT_ATTR7,
756 D_EXT_ATTR8 = X_D_EXT_ATTR8,
757 D_EXT_ATTR9 = X_D_EXT_ATTR9,
758 D_EXT_ATTR10 = X_D_EXT_ATTR10,
759 OLD_EXTENSION_ID = X_OLD_EXTENSION_ID,
760 LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
761 LAST_UPDATED_BY = X_LAST_UPDATED_BY,
762 LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
763 where EXTENSION_ID = X_EXTENSION_ID;
764
765 if (sql%notfound) then
766 raise no_data_found;
767 end if;
768
769 update HZ_PER_PROFILES_EXT_TL set
770 TL_EXT_ATTR1 = X_TL_EXT_ATTR1,
771 TL_EXT_ATTR2 = X_TL_EXT_ATTR2,
772 TL_EXT_ATTR3 = X_TL_EXT_ATTR3,
773 TL_EXT_ATTR4 = X_TL_EXT_ATTR4,
774 TL_EXT_ATTR5 = X_TL_EXT_ATTR5,
775 TL_EXT_ATTR6 = X_TL_EXT_ATTR6,
776 TL_EXT_ATTR7 = X_TL_EXT_ATTR7,
777 TL_EXT_ATTR8 = X_TL_EXT_ATTR8,
778 TL_EXT_ATTR9 = X_TL_EXT_ATTR9,
779 TL_EXT_ATTR10 = X_TL_EXT_ATTR10,
780 TL_EXT_ATTR11 = X_TL_EXT_ATTR11,
781 TL_EXT_ATTR12 = X_TL_EXT_ATTR12,
782 TL_EXT_ATTR13 = X_TL_EXT_ATTR13,
783 TL_EXT_ATTR14 = X_TL_EXT_ATTR14,
784 TL_EXT_ATTR15 = X_TL_EXT_ATTR15,
785 TL_EXT_ATTR16 = X_TL_EXT_ATTR16,
786 TL_EXT_ATTR17 = X_TL_EXT_ATTR17,
787 TL_EXT_ATTR18 = X_TL_EXT_ATTR18,
788 TL_EXT_ATTR19 = X_TL_EXT_ATTR19,
789 TL_EXT_ATTR20 = X_TL_EXT_ATTR20,
790 LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
791 LAST_UPDATED_BY = X_LAST_UPDATED_BY,
792 LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
793 SOURCE_LANG = userenv('LANG')
794 where EXTENSION_ID = X_EXTENSION_ID
795 and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
796
797 if (sql%notfound) then
798 raise no_data_found;
799 end if;
800 end UPDATE_ROW;
801
802 procedure DELETE_ROW (
803 X_EXTENSION_ID IN NUMBER) is
804 begin
805 delete from HZ_PER_PROFILES_EXT_TL
806 where EXTENSION_ID = X_EXTENSION_ID;
807
808 if (sql%notfound) then
809 raise no_data_found;
810 end if;
811
812 delete from HZ_PER_PROFILES_EXT_B
813 where EXTENSION_ID = X_EXTENSION_ID;
814
815 if (sql%notfound) then
816 raise no_data_found;
817 end if;
818 end DELETE_ROW;
819
820 procedure ADD_LANGUAGE
821 is
822 begin
823 insert into /*+ append parallel(tt) */ HZ_PER_PROFILES_EXT_TL tt (
824 EXTENSION_ID,
825 PERSON_PROFILE_ID,
826 ATTR_GROUP_ID,
827 CREATED_BY,
828 CREATION_DATE,
829 LAST_UPDATED_BY,
830 LAST_UPDATE_DATE,
831 LAST_UPDATE_LOGIN,
832 TL_EXT_ATTR1,
833 TL_EXT_ATTR2,
834 TL_EXT_ATTR3,
835 TL_EXT_ATTR4,
836 TL_EXT_ATTR5,
837 TL_EXT_ATTR6,
838 TL_EXT_ATTR7,
839 TL_EXT_ATTR8,
840 TL_EXT_ATTR9,
841 TL_EXT_ATTR10,
842 TL_EXT_ATTR11,
843 TL_EXT_ATTR12,
844 TL_EXT_ATTR13,
845 TL_EXT_ATTR14,
846 TL_EXT_ATTR15,
847 TL_EXT_ATTR16,
848 TL_EXT_ATTR17,
849 TL_EXT_ATTR18,
850 TL_EXT_ATTR19,
851 TL_EXT_ATTR20,
852 LANGUAGE,
853 SOURCE_LANG
854 )
855 select /*+ parallel(v) parallel(t) use_nl(t) */
856 v.EXTENSION_ID,
857 v.PERSON_PROFILE_ID,
858 v.ATTR_GROUP_ID,
859 v.CREATED_BY,
860 v.CREATION_DATE,
861 v.LAST_UPDATED_BY,
862 v.LAST_UPDATE_DATE,
863 v.LAST_UPDATE_LOGIN,
864 v.TL_EXT_ATTR1,
865 v.TL_EXT_ATTR2,
866 v.TL_EXT_ATTR3,
867 v.TL_EXT_ATTR4,
868 v.TL_EXT_ATTR5,
869 v.TL_EXT_ATTR6,
870 v.TL_EXT_ATTR7,
871 v.TL_EXT_ATTR8,
872 v.TL_EXT_ATTR9,
873 v.TL_EXT_ATTR10,
874 v.TL_EXT_ATTR11,
875 v.TL_EXT_ATTR12,
876 v.TL_EXT_ATTR13,
877 v.TL_EXT_ATTR14,
878 v.TL_EXT_ATTR15,
879 v.TL_EXT_ATTR16,
880 v.TL_EXT_ATTR17,
881 v.TL_EXT_ATTR18,
882 v.TL_EXT_ATTR19,
883 v.TL_EXT_ATTR20,
884 v.LANGUAGE_CODE,
885 v.SOURCE_LANG
886 from
887 (SELECT /*+ no_merge ordered parallel(b) */
888 B.EXTENSION_ID,
889 B.PERSON_PROFILE_ID,
890 B.ATTR_GROUP_ID,
891 B.CREATED_BY,
892 B.CREATION_DATE,
893 B.LAST_UPDATED_BY,
894 B.LAST_UPDATE_DATE,
895 B.LAST_UPDATE_LOGIN,
896 B.TL_EXT_ATTR1,
897 B.TL_EXT_ATTR2,
898 B.TL_EXT_ATTR3,
899 B.TL_EXT_ATTR4,
900 B.TL_EXT_ATTR5,
901 B.TL_EXT_ATTR6,
902 B.TL_EXT_ATTR7,
903 B.TL_EXT_ATTR8,
904 B.TL_EXT_ATTR9,
905 B.TL_EXT_ATTR10,
906 B.TL_EXT_ATTR11,
907 B.TL_EXT_ATTR12,
908 B.TL_EXT_ATTR13,
909 B.TL_EXT_ATTR14,
910 B.TL_EXT_ATTR15,
911 B.TL_EXT_ATTR16,
912 B.TL_EXT_ATTR17,
913 B.TL_EXT_ATTR18,
914 B.TL_EXT_ATTR19,
915 B.TL_EXT_ATTR20,
916 L.LANGUAGE_CODE,
917 B.SOURCE_LANG
918 FROM HZ_PER_PROFILES_EXT_TL B ,
919 FND_LANGUAGES L
920 WHERE L.INSTALLED_FLAG IN ( 'I','B' )
921 AND B.LANGUAGE = USERENV ( 'LANG' )
922 ) v, HZ_PER_PROFILES_EXT_TL t
923 WHERE t.EXTENSION_ID(+) = v.EXTENSION_ID
924 AND t.language(+) = v.language_code
925 AND t.EXTENSION_ID IS NULL;
926 end ADD_LANGUAGE;
927
928 procedure LOAD_ROW(
929 X_EXTENSION_ID IN NUMBER,
930 X_PERSON_PROFILE_ID IN NUMBER,
931 X_OLD_EXTENSION_ID IN NUMBER,
932 X_ATTR_GROUP_ID IN NUMBER,
933 X_C_EXT_ATTR1 IN VARCHAR2,
934 X_C_EXT_ATTR2 IN VARCHAR2,
935 X_C_EXT_ATTR3 IN VARCHAR2,
936 X_C_EXT_ATTR4 IN VARCHAR2,
937 X_C_EXT_ATTR5 IN VARCHAR2,
938 X_C_EXT_ATTR6 IN VARCHAR2,
939 X_C_EXT_ATTR7 IN VARCHAR2,
940 X_C_EXT_ATTR8 IN VARCHAR2,
941 X_C_EXT_ATTR9 IN VARCHAR2,
942 X_C_EXT_ATTR10 IN VARCHAR2,
943 X_C_EXT_ATTR11 IN VARCHAR2,
944 X_C_EXT_ATTR12 IN VARCHAR2,
945 X_C_EXT_ATTR13 IN VARCHAR2,
946 X_C_EXT_ATTR14 IN VARCHAR2,
947 X_C_EXT_ATTR15 IN VARCHAR2,
948 X_C_EXT_ATTR16 IN VARCHAR2,
949 X_C_EXT_ATTR17 IN VARCHAR2,
950 X_C_EXT_ATTR18 IN VARCHAR2,
951 X_C_EXT_ATTR19 IN VARCHAR2,
952 X_C_EXT_ATTR20 IN VARCHAR2,
953 X_N_EXT_ATTR1 IN NUMBER,
954 X_N_EXT_ATTR2 IN NUMBER,
955 X_N_EXT_ATTR3 IN NUMBER,
956 X_N_EXT_ATTR4 IN NUMBER,
957 X_N_EXT_ATTR5 IN NUMBER,
958 X_N_EXT_ATTR6 IN NUMBER,
959 X_N_EXT_ATTR7 IN NUMBER,
960 X_N_EXT_ATTR8 IN NUMBER,
961 X_N_EXT_ATTR9 IN NUMBER,
962 X_N_EXT_ATTR10 IN NUMBER,
963 X_N_EXT_ATTR11 IN NUMBER,
964 X_N_EXT_ATTR12 IN NUMBER,
965 X_N_EXT_ATTR13 IN NUMBER,
966 X_N_EXT_ATTR14 IN NUMBER,
967 X_N_EXT_ATTR15 IN NUMBER,
968 X_N_EXT_ATTR16 IN NUMBER,
969 X_N_EXT_ATTR17 IN NUMBER,
970 X_N_EXT_ATTR18 IN NUMBER,
971 X_N_EXT_ATTR19 IN NUMBER,
972 X_N_EXT_ATTR20 IN NUMBER,
973 X_D_EXT_ATTR1 IN DATE,
974 X_D_EXT_ATTR2 IN DATE,
975 X_D_EXT_ATTR3 IN DATE,
976 X_D_EXT_ATTR4 IN DATE,
977 X_D_EXT_ATTR5 IN DATE,
978 X_D_EXT_ATTR6 IN DATE,
979 X_D_EXT_ATTR7 IN DATE,
980 X_D_EXT_ATTR8 IN DATE,
981 X_D_EXT_ATTR9 IN DATE,
982 X_D_EXT_ATTR10 IN DATE,
983 X_TL_EXT_ATTR1 IN VARCHAR2,
984 X_TL_EXT_ATTR2 IN VARCHAR2,
985 X_TL_EXT_ATTR3 IN VARCHAR2,
986 X_TL_EXT_ATTR4 IN VARCHAR2,
987 X_TL_EXT_ATTR5 IN VARCHAR2,
988 X_TL_EXT_ATTR6 IN VARCHAR2,
989 X_TL_EXT_ATTR7 IN VARCHAR2,
990 X_TL_EXT_ATTR8 IN VARCHAR2,
991 X_TL_EXT_ATTR9 IN VARCHAR2,
992 X_TL_EXT_ATTR10 IN VARCHAR2,
993 X_TL_EXT_ATTR11 IN VARCHAR2,
994 X_TL_EXT_ATTR12 IN VARCHAR2,
995 X_TL_EXT_ATTR13 IN VARCHAR2,
996 X_TL_EXT_ATTR14 IN VARCHAR2,
997 X_TL_EXT_ATTR15 IN VARCHAR2,
998 X_TL_EXT_ATTR16 IN VARCHAR2,
999 X_TL_EXT_ATTR17 IN VARCHAR2,
1000 X_TL_EXT_ATTR18 IN VARCHAR2,
1001 X_TL_EXT_ATTR19 IN VARCHAR2,
1002 X_TL_EXT_ATTR20 IN VARCHAR2,
1003 X_OWNER in VARCHAR2)
1004 IS
1005 BEGIN
1006 null;
1007 end LOAD_ROW;
1008
1009
1010 procedure TRANSLATE_ROW (
1011 X_EXTENSION_ID IN NUMBER,
1012 X_PERSON_PROFILE_ID IN NUMBER,
1013 X_OLD_EXTENSION_ID IN NUMBER,
1014 X_ATTR_GROUP_ID IN NUMBER,
1015 X_TL_EXT_ATTR1 IN VARCHAR2,
1016 X_TL_EXT_ATTR2 IN VARCHAR2,
1017 X_TL_EXT_ATTR3 IN VARCHAR2,
1018 X_TL_EXT_ATTR4 IN VARCHAR2,
1019 X_TL_EXT_ATTR5 IN VARCHAR2,
1020 X_TL_EXT_ATTR6 IN VARCHAR2,
1021 X_TL_EXT_ATTR7 IN VARCHAR2,
1022 X_TL_EXT_ATTR8 IN VARCHAR2,
1023 X_TL_EXT_ATTR9 IN VARCHAR2,
1024 X_TL_EXT_ATTR10 IN VARCHAR2,
1025 X_TL_EXT_ATTR11 IN VARCHAR2,
1026 X_TL_EXT_ATTR12 IN VARCHAR2,
1027 X_TL_EXT_ATTR13 IN VARCHAR2,
1028 X_TL_EXT_ATTR14 IN VARCHAR2,
1029 X_TL_EXT_ATTR15 IN VARCHAR2,
1030 X_TL_EXT_ATTR16 IN VARCHAR2,
1031 X_TL_EXT_ATTR17 IN VARCHAR2,
1032 X_TL_EXT_ATTR18 IN VARCHAR2,
1033 X_TL_EXT_ATTR19 IN VARCHAR2,
1034 X_TL_EXT_ATTR20 IN VARCHAR2,
1035 X_OWNER in VARCHAR2)
1036 IS
1037 BEGIN
1038 null;
1039 end TRANSLATE_ROW;
1040
1041
1042 end HZ_PER_PROFILES_EXT_PKG;
[Home] [Help]