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