1 package body RRS_LOCATIONS_EXT_PKG as
2 /* $Header: RRSLEXTB.pls 120.0.12010000.2 2009/01/05 18:39:30 sunarang ship $ */
3 procedure INSERT_ROW (
4 X_ROWID in out nocopy VARCHAR2,
5 X_EXTENSION_ID in NUMBER,
6 X_C_EXT_ATTR13 in VARCHAR2,
7 X_C_EXT_ATTR14 in VARCHAR2,
8 X_C_EXT_ATTR15 in VARCHAR2,
9 X_C_EXT_ATTR16 in VARCHAR2,
10 X_C_EXT_ATTR17 in VARCHAR2,
11 X_C_EXT_ATTR18 in VARCHAR2,
12 X_C_EXT_ATTR19 in VARCHAR2,
13 X_C_EXT_ATTR20 in VARCHAR2,
14 X_N_EXT_ATTR1 in NUMBER,
15 X_N_EXT_ATTR2 in NUMBER,
16 X_N_EXT_ATTR3 in NUMBER,
17 X_N_EXT_ATTR4 in NUMBER,
18 X_N_EXT_ATTR5 in NUMBER,
19 X_N_EXT_ATTR6 in NUMBER,
20 X_N_EXT_ATTR7 in NUMBER,
21 X_N_EXT_ATTR8 in NUMBER,
22 X_N_EXT_ATTR9 in NUMBER,
23 X_N_EXT_ATTR10 in NUMBER,
24 X_D_EXT_ATTR1 in DATE,
25 X_D_EXT_ATTR2 in DATE,
26 X_D_EXT_ATTR3 in DATE,
27 X_D_EXT_ATTR4 in DATE,
28 X_D_EXT_ATTR5 in DATE,
29 X_C_EXT_ATTR21 in VARCHAR2,
30 X_C_EXT_ATTR22 in VARCHAR2,
31 X_C_EXT_ATTR23 in VARCHAR2,
32 X_C_EXT_ATTR24 in VARCHAR2,
33 X_C_EXT_ATTR25 in VARCHAR2,
34 X_C_EXT_ATTR26 in VARCHAR2,
35 X_C_EXT_ATTR27 in VARCHAR2,
36 X_C_EXT_ATTR28 in VARCHAR2,
37 X_C_EXT_ATTR29 in VARCHAR2,
38 X_C_EXT_ATTR30 in VARCHAR2,
39 X_C_EXT_ATTR31 in VARCHAR2,
40 X_C_EXT_ATTR32 in VARCHAR2,
41 X_C_EXT_ATTR33 in VARCHAR2,
42 X_C_EXT_ATTR34 in VARCHAR2,
43 X_C_EXT_ATTR35 in VARCHAR2,
44 X_C_EXT_ATTR36 in VARCHAR2,
45 X_C_EXT_ATTR37 in VARCHAR2,
46 X_C_EXT_ATTR38 in VARCHAR2,
47 X_C_EXT_ATTR39 in VARCHAR2,
48 X_C_EXT_ATTR40 in VARCHAR2,
49 X_N_EXT_ATTR11 in NUMBER,
50 X_N_EXT_ATTR12 in NUMBER,
51 X_N_EXT_ATTR13 in NUMBER,
52 X_N_EXT_ATTR14 in NUMBER,
53 X_N_EXT_ATTR15 in NUMBER,
54 X_N_EXT_ATTR16 in NUMBER,
55 X_N_EXT_ATTR17 in NUMBER,
56 X_N_EXT_ATTR18 in NUMBER,
57 X_N_EXT_ATTR19 in NUMBER,
58 X_N_EXT_ATTR20 in NUMBER,
59 X_UOM_EXT_ATTR1 in VARCHAR2,
60 X_UOM_EXT_ATTR2 in VARCHAR2,
61 X_UOM_EXT_ATTR3 in VARCHAR2,
62 X_UOM_EXT_ATTR4 in VARCHAR2,
63 X_UOM_EXT_ATTR5 in VARCHAR2,
64 X_UOM_EXT_ATTR6 in VARCHAR2,
65 X_UOM_EXT_ATTR7 in VARCHAR2,
66 X_UOM_EXT_ATTR8 in VARCHAR2,
67 X_UOM_EXT_ATTR9 in VARCHAR2,
68 X_UOM_EXT_ATTR10 in VARCHAR2,
69 X_UOM_EXT_ATTR11 in VARCHAR2,
70 X_UOM_EXT_ATTR12 in VARCHAR2,
71 X_UOM_EXT_ATTR13 in VARCHAR2,
72 X_UOM_EXT_ATTR14 in VARCHAR2,
73 X_UOM_EXT_ATTR15 in VARCHAR2,
74 X_UOM_EXT_ATTR16 in VARCHAR2,
75 X_UOM_EXT_ATTR17 in VARCHAR2,
76 X_UOM_EXT_ATTR18 in VARCHAR2,
77 X_UOM_EXT_ATTR19 in VARCHAR2,
78 X_UOM_EXT_ATTR20 in VARCHAR2,
79 X_D_EXT_ATTR6 in DATE,
80 X_D_EXT_ATTR7 in DATE,
81 X_D_EXT_ATTR8 in DATE,
82 X_D_EXT_ATTR9 in DATE,
83 X_D_EXT_ATTR10 in DATE,
84 X_REQUEST_ID in NUMBER,
85 X_LOCATION_ID in NUMBER,
86 X_COUNTRY in VARCHAR2,
87 X_ATTR_GROUP_ID in NUMBER,
88 X_C_EXT_ATTR1 in VARCHAR2,
89 X_C_EXT_ATTR2 in VARCHAR2,
90 X_C_EXT_ATTR3 in VARCHAR2,
91 X_C_EXT_ATTR4 in VARCHAR2,
92 X_C_EXT_ATTR5 in VARCHAR2,
93 X_C_EXT_ATTR6 in VARCHAR2,
94 X_C_EXT_ATTR7 in VARCHAR2,
95 X_C_EXT_ATTR8 in VARCHAR2,
96 X_C_EXT_ATTR9 in VARCHAR2,
97 X_C_EXT_ATTR10 in VARCHAR2,
98 X_C_EXT_ATTR11 in VARCHAR2,
99 X_C_EXT_ATTR12 in VARCHAR2,
100 X_TL_EXT_ATTR1 in VARCHAR2,
101 X_TL_EXT_ATTR2 in VARCHAR2,
102 X_TL_EXT_ATTR3 in VARCHAR2,
103 X_TL_EXT_ATTR4 in VARCHAR2,
104 X_TL_EXT_ATTR5 in VARCHAR2,
105 X_TL_EXT_ATTR6 in VARCHAR2,
106 X_TL_EXT_ATTR7 in VARCHAR2,
107 X_TL_EXT_ATTR8 in VARCHAR2,
108 X_TL_EXT_ATTR9 in VARCHAR2,
109 X_TL_EXT_ATTR10 in VARCHAR2,
110 X_TL_EXT_ATTR11 in VARCHAR2,
111 X_TL_EXT_ATTR12 in VARCHAR2,
112 X_TL_EXT_ATTR13 in VARCHAR2,
113 X_TL_EXT_ATTR14 in VARCHAR2,
114 X_TL_EXT_ATTR15 in VARCHAR2,
115 X_TL_EXT_ATTR16 in VARCHAR2,
116 X_TL_EXT_ATTR17 in VARCHAR2,
117 X_TL_EXT_ATTR18 in VARCHAR2,
118 X_TL_EXT_ATTR19 in VARCHAR2,
119 X_TL_EXT_ATTR20 in VARCHAR2,
120 X_TL_EXT_ATTR21 in VARCHAR2,
121 X_TL_EXT_ATTR22 in VARCHAR2,
122 X_TL_EXT_ATTR23 in VARCHAR2,
123 X_TL_EXT_ATTR24 in VARCHAR2,
124 X_TL_EXT_ATTR25 in VARCHAR2,
125 X_TL_EXT_ATTR26 in VARCHAR2,
126 X_TL_EXT_ATTR27 in VARCHAR2,
127 X_TL_EXT_ATTR28 in VARCHAR2,
128 X_TL_EXT_ATTR29 in VARCHAR2,
129 X_TL_EXT_ATTR30 in VARCHAR2,
130 X_TL_EXT_ATTR31 in VARCHAR2,
131 X_TL_EXT_ATTR32 in VARCHAR2,
132 X_TL_EXT_ATTR33 in VARCHAR2,
133 X_TL_EXT_ATTR34 in VARCHAR2,
134 X_TL_EXT_ATTR35 in VARCHAR2,
135 X_TL_EXT_ATTR36 in VARCHAR2,
136 X_TL_EXT_ATTR37 in VARCHAR2,
137 X_TL_EXT_ATTR38 in VARCHAR2,
138 X_TL_EXT_ATTR39 in VARCHAR2,
139 X_TL_EXT_ATTR40 in VARCHAR2,
140 X_CREATION_DATE in DATE,
141 X_CREATED_BY in NUMBER,
142 X_LAST_UPDATE_DATE in DATE,
143 X_LAST_UPDATED_BY in NUMBER,
144 X_LAST_UPDATE_LOGIN in NUMBER
145 ) is
146 l_extension_id NUMBER;
147 cursor C is select ROWID from RRS_LOCATIONS_EXT_B
148 where EXTENSION_ID = l_extension_id
149 ;
150
151 begin
152
153 select nvl(X_EXTENSION_ID ,EGO_EXTFWK_S.nextval)
154 into l_extension_id
155 from dual;
156
157 insert into RRS_LOCATIONS_EXT_B (
158 EXTENSION_ID,
159 LOCATION_ID,
160 COUNTRY,
161 ATTR_GROUP_ID,
162 C_EXT_ATTR1,
163 C_EXT_ATTR2,
164 C_EXT_ATTR3,
165 C_EXT_ATTR4,
166 C_EXT_ATTR5,
167 C_EXT_ATTR6,
168 C_EXT_ATTR7,
169 C_EXT_ATTR8,
170 C_EXT_ATTR9,
171 C_EXT_ATTR10,
172 C_EXT_ATTR11,
173 C_EXT_ATTR12,
174 C_EXT_ATTR13,
175 C_EXT_ATTR14,
176 C_EXT_ATTR15,
177 C_EXT_ATTR16,
178 C_EXT_ATTR17,
179 C_EXT_ATTR18,
180 C_EXT_ATTR19,
181 C_EXT_ATTR20,
182 C_EXT_ATTR21,
183 C_EXT_ATTR22,
184 C_EXT_ATTR23,
185 C_EXT_ATTR24,
186 C_EXT_ATTR25,
187 C_EXT_ATTR26,
188 C_EXT_ATTR27,
189 C_EXT_ATTR28,
190 C_EXT_ATTR29,
191 C_EXT_ATTR30,
192 C_EXT_ATTR31,
193 C_EXT_ATTR32,
194 C_EXT_ATTR33,
195 C_EXT_ATTR34,
196 C_EXT_ATTR35,
197 C_EXT_ATTR36,
198 C_EXT_ATTR37,
199 C_EXT_ATTR38,
200 C_EXT_ATTR39,
201 C_EXT_ATTR40,
202 N_EXT_ATTR1,
203 N_EXT_ATTR2,
204 N_EXT_ATTR3,
205 N_EXT_ATTR4,
206 N_EXT_ATTR5,
207 N_EXT_ATTR6,
208 N_EXT_ATTR7,
209 N_EXT_ATTR8,
210 N_EXT_ATTR9,
211 N_EXT_ATTR10,
212 N_EXT_ATTR11,
213 N_EXT_ATTR12,
214 N_EXT_ATTR13,
215 N_EXT_ATTR14,
216 N_EXT_ATTR15,
217 N_EXT_ATTR16,
218 N_EXT_ATTR17,
219 N_EXT_ATTR18,
220 N_EXT_ATTR19,
221 N_EXT_ATTR20,
222 D_EXT_ATTR1,
223 D_EXT_ATTR2,
224 D_EXT_ATTR3,
225 D_EXT_ATTR4,
226 D_EXT_ATTR5,
227 D_EXT_ATTR6,
228 D_EXT_ATTR7,
229 D_EXT_ATTR8,
230 D_EXT_ATTR9,
231 D_EXT_ATTR10,
232 UOM_EXT_ATTR1,
233 UOM_EXT_ATTR2,
234 UOM_EXT_ATTR3,
235 UOM_EXT_ATTR4,
236 UOM_EXT_ATTR5,
237 UOM_EXT_ATTR6,
238 UOM_EXT_ATTR7,
239 UOM_EXT_ATTR8,
240 UOM_EXT_ATTR9,
241 UOM_EXT_ATTR10,
242 UOM_EXT_ATTR11,
243 UOM_EXT_ATTR12,
244 UOM_EXT_ATTR13,
245 UOM_EXT_ATTR14,
246 UOM_EXT_ATTR15,
247 UOM_EXT_ATTR16,
248 UOM_EXT_ATTR17,
249 UOM_EXT_ATTR18,
250 UOM_EXT_ATTR19,
251 UOM_EXT_ATTR20,
252 REQUEST_ID,
253 CREATION_DATE,
254 CREATED_BY,
255 LAST_UPDATE_DATE,
256 LAST_UPDATED_BY,
257 LAST_UPDATE_LOGIN
258 ) values (
259 l_extension_id,
260 X_LOCATION_ID,
261 X_COUNTRY,
262 X_ATTR_GROUP_ID,
263 X_C_EXT_ATTR1,
264 X_C_EXT_ATTR2,
265 X_C_EXT_ATTR3,
266 X_C_EXT_ATTR4,
267 X_C_EXT_ATTR5,
268 X_C_EXT_ATTR6,
269 X_C_EXT_ATTR7,
270 X_C_EXT_ATTR8,
271 X_C_EXT_ATTR9,
272 X_C_EXT_ATTR10,
273 X_C_EXT_ATTR11,
274 X_C_EXT_ATTR12,
275 X_C_EXT_ATTR13,
276 X_C_EXT_ATTR14,
277 X_C_EXT_ATTR15,
278 X_C_EXT_ATTR16,
279 X_C_EXT_ATTR17,
280 X_C_EXT_ATTR18,
281 X_C_EXT_ATTR19,
282 X_C_EXT_ATTR20,
283 X_C_EXT_ATTR21,
284 X_C_EXT_ATTR22,
285 X_C_EXT_ATTR23,
286 X_C_EXT_ATTR24,
287 X_C_EXT_ATTR25,
288 X_C_EXT_ATTR26,
289 X_C_EXT_ATTR27,
290 X_C_EXT_ATTR28,
291 X_C_EXT_ATTR29,
292 X_C_EXT_ATTR30,
293 X_C_EXT_ATTR31,
294 X_C_EXT_ATTR32,
295 X_C_EXT_ATTR33,
296 X_C_EXT_ATTR34,
297 X_C_EXT_ATTR35,
298 X_C_EXT_ATTR36,
299 X_C_EXT_ATTR37,
300 X_C_EXT_ATTR38,
301 X_C_EXT_ATTR39,
302 X_C_EXT_ATTR40,
303 X_N_EXT_ATTR1,
304 X_N_EXT_ATTR2,
305 X_N_EXT_ATTR3,
306 X_N_EXT_ATTR4,
307 X_N_EXT_ATTR5,
308 X_N_EXT_ATTR6,
309 X_N_EXT_ATTR7,
310 X_N_EXT_ATTR8,
311 X_N_EXT_ATTR9,
312 X_N_EXT_ATTR10,
313 X_N_EXT_ATTR11,
314 X_N_EXT_ATTR12,
315 X_N_EXT_ATTR13,
316 X_N_EXT_ATTR14,
317 X_N_EXT_ATTR15,
318 X_N_EXT_ATTR16,
319 X_N_EXT_ATTR17,
320 X_N_EXT_ATTR18,
321 X_N_EXT_ATTR19,
322 X_N_EXT_ATTR20,
323 X_D_EXT_ATTR1,
324 X_D_EXT_ATTR2,
325 X_D_EXT_ATTR3,
326 X_D_EXT_ATTR4,
327 X_D_EXT_ATTR5,
328 X_D_EXT_ATTR6,
329 X_D_EXT_ATTR7,
330 X_D_EXT_ATTR8,
331 X_D_EXT_ATTR9,
332 X_D_EXT_ATTR10,
333 X_UOM_EXT_ATTR1,
334 X_UOM_EXT_ATTR2,
335 X_UOM_EXT_ATTR3,
336 X_UOM_EXT_ATTR4,
337 X_UOM_EXT_ATTR5,
338 X_UOM_EXT_ATTR6,
339 X_UOM_EXT_ATTR7,
340 X_UOM_EXT_ATTR8,
341 X_UOM_EXT_ATTR9,
342 X_UOM_EXT_ATTR10,
343 X_UOM_EXT_ATTR11,
344 X_UOM_EXT_ATTR12,
345 X_UOM_EXT_ATTR13,
346 X_UOM_EXT_ATTR14,
347 X_UOM_EXT_ATTR15,
348 X_UOM_EXT_ATTR16,
349 X_UOM_EXT_ATTR17,
350 X_UOM_EXT_ATTR18,
351 X_UOM_EXT_ATTR19,
352 X_UOM_EXT_ATTR20,
353 X_REQUEST_ID,
354 X_CREATION_DATE,
355 X_CREATED_BY,
356 X_LAST_UPDATE_DATE,
357 X_LAST_UPDATED_BY,
358 X_LAST_UPDATE_LOGIN
359 );
360
361 insert into RRS_LOCATIONS_EXT_TL (
362 EXTENSION_ID,
363 LOCATION_ID,
364 COUNTRY,
365 ATTR_GROUP_ID,
366 LAST_UPDATE_DATE,
367 LAST_UPDATED_BY,
368 LAST_UPDATE_LOGIN,
369 CREATED_BY,
370 CREATION_DATE,
371 TL_EXT_ATTR1,
372 TL_EXT_ATTR2,
373 TL_EXT_ATTR3,
374 TL_EXT_ATTR4,
375 TL_EXT_ATTR5,
376 TL_EXT_ATTR6,
377 TL_EXT_ATTR7,
378 TL_EXT_ATTR8,
379 TL_EXT_ATTR9,
380 TL_EXT_ATTR10,
381 TL_EXT_ATTR11,
382 TL_EXT_ATTR12,
383 TL_EXT_ATTR13,
384 TL_EXT_ATTR14,
385 TL_EXT_ATTR15,
386 TL_EXT_ATTR16,
387 TL_EXT_ATTR17,
388 TL_EXT_ATTR18,
389 TL_EXT_ATTR19,
390 TL_EXT_ATTR20,
391 TL_EXT_ATTR21,
392 TL_EXT_ATTR22,
393 TL_EXT_ATTR23,
394 TL_EXT_ATTR24,
395 TL_EXT_ATTR25,
396 TL_EXT_ATTR26,
397 TL_EXT_ATTR27,
398 TL_EXT_ATTR28,
399 TL_EXT_ATTR29,
400 TL_EXT_ATTR30,
401 TL_EXT_ATTR31,
402 TL_EXT_ATTR32,
403 TL_EXT_ATTR33,
404 TL_EXT_ATTR34,
405 TL_EXT_ATTR35,
406 TL_EXT_ATTR36,
407 TL_EXT_ATTR37,
408 TL_EXT_ATTR38,
409 TL_EXT_ATTR39,
410 TL_EXT_ATTR40,
411 LANGUAGE,
412 SOURCE_LANG
413 ) select
414 l_extension_id,
415 X_LOCATION_ID,
416 X_COUNTRY,
417 X_ATTR_GROUP_ID,
418 X_LAST_UPDATE_DATE,
419 X_LAST_UPDATED_BY,
420 X_LAST_UPDATE_LOGIN,
421 X_CREATED_BY,
422 X_CREATION_DATE,
423 X_TL_EXT_ATTR1,
424 X_TL_EXT_ATTR2,
425 X_TL_EXT_ATTR3,
426 X_TL_EXT_ATTR4,
427 X_TL_EXT_ATTR5,
428 X_TL_EXT_ATTR6,
429 X_TL_EXT_ATTR7,
430 X_TL_EXT_ATTR8,
431 X_TL_EXT_ATTR9,
432 X_TL_EXT_ATTR10,
433 X_TL_EXT_ATTR11,
434 X_TL_EXT_ATTR12,
435 X_TL_EXT_ATTR13,
436 X_TL_EXT_ATTR14,
437 X_TL_EXT_ATTR15,
438 X_TL_EXT_ATTR16,
439 X_TL_EXT_ATTR17,
440 X_TL_EXT_ATTR18,
441 X_TL_EXT_ATTR19,
442 X_TL_EXT_ATTR20,
443 X_TL_EXT_ATTR21,
444 X_TL_EXT_ATTR22,
445 X_TL_EXT_ATTR23,
446 X_TL_EXT_ATTR24,
447 X_TL_EXT_ATTR25,
448 X_TL_EXT_ATTR26,
449 X_TL_EXT_ATTR27,
450 X_TL_EXT_ATTR28,
451 X_TL_EXT_ATTR29,
452 X_TL_EXT_ATTR30,
453 X_TL_EXT_ATTR31,
454 X_TL_EXT_ATTR32,
455 X_TL_EXT_ATTR33,
456 X_TL_EXT_ATTR34,
457 X_TL_EXT_ATTR35,
458 X_TL_EXT_ATTR36,
459 X_TL_EXT_ATTR37,
460 X_TL_EXT_ATTR38,
461 X_TL_EXT_ATTR39,
462 X_TL_EXT_ATTR40,
463 L.LANGUAGE_CODE,
464 userenv('LANG')
465 from FND_LANGUAGES L
466 where L.INSTALLED_FLAG in ('I', 'B')
467 and not exists
468 (select NULL
469 from RRS_LOCATIONS_EXT_TL T
470 where T.EXTENSION_ID = l_extension_id
471 and T.LANGUAGE = L.LANGUAGE_CODE);
472
473 open c;
474 fetch c into X_ROWID;
475 if (c%notfound) then
476 close c;
477 raise no_data_found;
478 end if;
479 close c;
480
481 end INSERT_ROW;
482
483 procedure LOCK_ROW (
484 X_EXTENSION_ID in NUMBER,
485 X_C_EXT_ATTR13 in VARCHAR2,
486 X_C_EXT_ATTR14 in VARCHAR2,
487 X_C_EXT_ATTR15 in VARCHAR2,
488 X_C_EXT_ATTR16 in VARCHAR2,
489 X_C_EXT_ATTR17 in VARCHAR2,
490 X_C_EXT_ATTR18 in VARCHAR2,
491 X_C_EXT_ATTR19 in VARCHAR2,
492 X_C_EXT_ATTR20 in VARCHAR2,
493 X_N_EXT_ATTR1 in NUMBER,
494 X_N_EXT_ATTR2 in NUMBER,
495 X_N_EXT_ATTR3 in NUMBER,
496 X_N_EXT_ATTR4 in NUMBER,
497 X_N_EXT_ATTR5 in NUMBER,
498 X_N_EXT_ATTR6 in NUMBER,
499 X_N_EXT_ATTR7 in NUMBER,
500 X_N_EXT_ATTR8 in NUMBER,
501 X_N_EXT_ATTR9 in NUMBER,
502 X_N_EXT_ATTR10 in NUMBER,
503 X_D_EXT_ATTR1 in DATE,
504 X_D_EXT_ATTR2 in DATE,
505 X_D_EXT_ATTR3 in DATE,
506 X_D_EXT_ATTR4 in DATE,
507 X_D_EXT_ATTR5 in DATE,
508 X_C_EXT_ATTR21 in VARCHAR2,
509 X_C_EXT_ATTR22 in VARCHAR2,
510 X_C_EXT_ATTR23 in VARCHAR2,
511 X_C_EXT_ATTR24 in VARCHAR2,
512 X_C_EXT_ATTR25 in VARCHAR2,
513 X_C_EXT_ATTR26 in VARCHAR2,
514 X_C_EXT_ATTR27 in VARCHAR2,
515 X_C_EXT_ATTR28 in VARCHAR2,
516 X_C_EXT_ATTR29 in VARCHAR2,
517 X_C_EXT_ATTR30 in VARCHAR2,
518 X_C_EXT_ATTR31 in VARCHAR2,
519 X_C_EXT_ATTR32 in VARCHAR2,
520 X_C_EXT_ATTR33 in VARCHAR2,
521 X_C_EXT_ATTR34 in VARCHAR2,
522 X_C_EXT_ATTR35 in VARCHAR2,
523 X_C_EXT_ATTR36 in VARCHAR2,
524 X_C_EXT_ATTR37 in VARCHAR2,
525 X_C_EXT_ATTR38 in VARCHAR2,
526 X_C_EXT_ATTR39 in VARCHAR2,
527 X_C_EXT_ATTR40 in VARCHAR2,
528 X_N_EXT_ATTR11 in NUMBER,
529 X_N_EXT_ATTR12 in NUMBER,
530 X_N_EXT_ATTR13 in NUMBER,
531 X_N_EXT_ATTR14 in NUMBER,
532 X_N_EXT_ATTR15 in NUMBER,
533 X_N_EXT_ATTR16 in NUMBER,
537 X_N_EXT_ATTR20 in NUMBER,
534 X_N_EXT_ATTR17 in NUMBER,
535 X_N_EXT_ATTR18 in NUMBER,
536 X_N_EXT_ATTR19 in NUMBER,
538 X_UOM_EXT_ATTR1 in VARCHAR2,
539 X_UOM_EXT_ATTR2 in VARCHAR2,
540 X_UOM_EXT_ATTR3 in VARCHAR2,
541 X_UOM_EXT_ATTR4 in VARCHAR2,
542 X_UOM_EXT_ATTR5 in VARCHAR2,
543 X_UOM_EXT_ATTR6 in VARCHAR2,
544 X_UOM_EXT_ATTR7 in VARCHAR2,
545 X_UOM_EXT_ATTR8 in VARCHAR2,
546 X_UOM_EXT_ATTR9 in VARCHAR2,
547 X_UOM_EXT_ATTR10 in VARCHAR2,
548 X_UOM_EXT_ATTR11 in VARCHAR2,
549 X_UOM_EXT_ATTR12 in VARCHAR2,
550 X_UOM_EXT_ATTR13 in VARCHAR2,
551 X_UOM_EXT_ATTR14 in VARCHAR2,
552 X_UOM_EXT_ATTR15 in VARCHAR2,
553 X_UOM_EXT_ATTR16 in VARCHAR2,
554 X_UOM_EXT_ATTR17 in VARCHAR2,
555 X_UOM_EXT_ATTR18 in VARCHAR2,
556 X_UOM_EXT_ATTR19 in VARCHAR2,
557 X_UOM_EXT_ATTR20 in VARCHAR2,
558 X_D_EXT_ATTR6 in DATE,
559 X_D_EXT_ATTR7 in DATE,
560 X_D_EXT_ATTR8 in DATE,
561 X_D_EXT_ATTR9 in DATE,
562 X_D_EXT_ATTR10 in DATE,
563 X_REQUEST_ID in NUMBER,
564 X_LOCATION_ID in NUMBER,
565 X_COUNTRY in VARCHAR2,
566 X_ATTR_GROUP_ID in NUMBER,
567 X_C_EXT_ATTR1 in VARCHAR2,
568 X_C_EXT_ATTR2 in VARCHAR2,
569 X_C_EXT_ATTR3 in VARCHAR2,
570 X_C_EXT_ATTR4 in VARCHAR2,
571 X_C_EXT_ATTR5 in VARCHAR2,
572 X_C_EXT_ATTR6 in VARCHAR2,
573 X_C_EXT_ATTR7 in VARCHAR2,
574 X_C_EXT_ATTR8 in VARCHAR2,
575 X_C_EXT_ATTR9 in VARCHAR2,
576 X_C_EXT_ATTR10 in VARCHAR2,
577 X_C_EXT_ATTR11 in VARCHAR2,
578 X_C_EXT_ATTR12 in VARCHAR2,
579 X_TL_EXT_ATTR1 in VARCHAR2,
580 X_TL_EXT_ATTR2 in VARCHAR2,
581 X_TL_EXT_ATTR3 in VARCHAR2,
582 X_TL_EXT_ATTR4 in VARCHAR2,
583 X_TL_EXT_ATTR5 in VARCHAR2,
584 X_TL_EXT_ATTR6 in VARCHAR2,
585 X_TL_EXT_ATTR7 in VARCHAR2,
586 X_TL_EXT_ATTR8 in VARCHAR2,
587 X_TL_EXT_ATTR9 in VARCHAR2,
588 X_TL_EXT_ATTR10 in VARCHAR2,
589 X_TL_EXT_ATTR11 in VARCHAR2,
590 X_TL_EXT_ATTR12 in VARCHAR2,
591 X_TL_EXT_ATTR13 in VARCHAR2,
592 X_TL_EXT_ATTR14 in VARCHAR2,
593 X_TL_EXT_ATTR15 in VARCHAR2,
594 X_TL_EXT_ATTR16 in VARCHAR2,
595 X_TL_EXT_ATTR17 in VARCHAR2,
596 X_TL_EXT_ATTR18 in VARCHAR2,
597 X_TL_EXT_ATTR19 in VARCHAR2,
598 X_TL_EXT_ATTR20 in VARCHAR2,
599 X_TL_EXT_ATTR21 in VARCHAR2,
600 X_TL_EXT_ATTR22 in VARCHAR2,
601 X_TL_EXT_ATTR23 in VARCHAR2,
602 X_TL_EXT_ATTR24 in VARCHAR2,
603 X_TL_EXT_ATTR25 in VARCHAR2,
604 X_TL_EXT_ATTR26 in VARCHAR2,
605 X_TL_EXT_ATTR27 in VARCHAR2,
606 X_TL_EXT_ATTR28 in VARCHAR2,
607 X_TL_EXT_ATTR29 in VARCHAR2,
608 X_TL_EXT_ATTR30 in VARCHAR2,
609 X_TL_EXT_ATTR31 in VARCHAR2,
610 X_TL_EXT_ATTR32 in VARCHAR2,
611 X_TL_EXT_ATTR33 in VARCHAR2,
612 X_TL_EXT_ATTR34 in VARCHAR2,
613 X_TL_EXT_ATTR35 in VARCHAR2,
614 X_TL_EXT_ATTR36 in VARCHAR2,
615 X_TL_EXT_ATTR37 in VARCHAR2,
616 X_TL_EXT_ATTR38 in VARCHAR2,
617 X_TL_EXT_ATTR39 in VARCHAR2,
618 X_TL_EXT_ATTR40 in VARCHAR2
619 ) is
620 cursor c is select
621 C_EXT_ATTR13,
622 C_EXT_ATTR14,
623 C_EXT_ATTR15,
624 C_EXT_ATTR16,
625 C_EXT_ATTR17,
626 C_EXT_ATTR18,
627 C_EXT_ATTR19,
628 C_EXT_ATTR20,
629 N_EXT_ATTR1,
630 N_EXT_ATTR2,
631 N_EXT_ATTR3,
632 N_EXT_ATTR4,
633 N_EXT_ATTR5,
634 N_EXT_ATTR6,
635 N_EXT_ATTR7,
636 N_EXT_ATTR8,
637 N_EXT_ATTR9,
638 N_EXT_ATTR10,
639 D_EXT_ATTR1,
640 D_EXT_ATTR2,
641 D_EXT_ATTR3,
642 D_EXT_ATTR4,
643 D_EXT_ATTR5,
644 C_EXT_ATTR21,
645 C_EXT_ATTR22,
646 C_EXT_ATTR23,
647 C_EXT_ATTR24,
648 C_EXT_ATTR25,
649 C_EXT_ATTR26,
650 C_EXT_ATTR27,
651 C_EXT_ATTR28,
652 C_EXT_ATTR29,
653 C_EXT_ATTR30,
654 C_EXT_ATTR31,
655 C_EXT_ATTR32,
656 C_EXT_ATTR33,
657 C_EXT_ATTR34,
658 C_EXT_ATTR35,
659 C_EXT_ATTR36,
660 C_EXT_ATTR37,
661 C_EXT_ATTR38,
662 C_EXT_ATTR39,
663 C_EXT_ATTR40,
664 N_EXT_ATTR11,
665 N_EXT_ATTR12,
666 N_EXT_ATTR13,
667 N_EXT_ATTR14,
668 N_EXT_ATTR15,
669 N_EXT_ATTR16,
670 N_EXT_ATTR17,
671 N_EXT_ATTR18,
672 N_EXT_ATTR19,
673 N_EXT_ATTR20,
674 UOM_EXT_ATTR1,
675 UOM_EXT_ATTR2,
676 UOM_EXT_ATTR3,
677 UOM_EXT_ATTR4,
678 UOM_EXT_ATTR5,
679 UOM_EXT_ATTR6,
680 UOM_EXT_ATTR7,
681 UOM_EXT_ATTR8,
682 UOM_EXT_ATTR9,
683 UOM_EXT_ATTR10,
684 UOM_EXT_ATTR11,
685 UOM_EXT_ATTR12,
686 UOM_EXT_ATTR13,
687 UOM_EXT_ATTR14,
688 UOM_EXT_ATTR15,
689 UOM_EXT_ATTR16,
690 UOM_EXT_ATTR17,
691 UOM_EXT_ATTR18,
692 UOM_EXT_ATTR19,
693 UOM_EXT_ATTR20,
694 D_EXT_ATTR6,
695 D_EXT_ATTR7,
696 D_EXT_ATTR8,
697 D_EXT_ATTR9,
698 D_EXT_ATTR10,
699 REQUEST_ID,
703 C_EXT_ATTR1,
700 LOCATION_ID,
701 COUNTRY,
702 ATTR_GROUP_ID,
704 C_EXT_ATTR2,
705 C_EXT_ATTR3,
706 C_EXT_ATTR4,
707 C_EXT_ATTR5,
708 C_EXT_ATTR6,
709 C_EXT_ATTR7,
710 C_EXT_ATTR8,
711 C_EXT_ATTR9,
712 C_EXT_ATTR10,
713 C_EXT_ATTR11,
714 C_EXT_ATTR12
715 from RRS_LOCATIONS_EXT_B
716 where EXTENSION_ID = X_EXTENSION_ID
717 for update of EXTENSION_ID nowait;
718 recinfo c%rowtype;
719
720 cursor c1 is select
721 TL_EXT_ATTR1,
722 TL_EXT_ATTR2,
723 TL_EXT_ATTR3,
724 TL_EXT_ATTR4,
725 TL_EXT_ATTR5,
726 TL_EXT_ATTR6,
727 TL_EXT_ATTR7,
728 TL_EXT_ATTR8,
729 TL_EXT_ATTR9,
730 TL_EXT_ATTR10,
731 TL_EXT_ATTR11,
732 TL_EXT_ATTR12,
733 TL_EXT_ATTR13,
734 TL_EXT_ATTR14,
735 TL_EXT_ATTR15,
736 TL_EXT_ATTR16,
737 TL_EXT_ATTR17,
738 TL_EXT_ATTR18,
739 TL_EXT_ATTR19,
740 TL_EXT_ATTR20,
741 TL_EXT_ATTR21,
742 TL_EXT_ATTR22,
743 TL_EXT_ATTR23,
744 TL_EXT_ATTR24,
745 TL_EXT_ATTR25,
746 TL_EXT_ATTR26,
747 TL_EXT_ATTR27,
748 TL_EXT_ATTR28,
749 TL_EXT_ATTR29,
750 TL_EXT_ATTR30,
751 TL_EXT_ATTR31,
752 TL_EXT_ATTR32,
753 TL_EXT_ATTR33,
754 TL_EXT_ATTR34,
755 TL_EXT_ATTR35,
756 TL_EXT_ATTR36,
757 TL_EXT_ATTR37,
758 TL_EXT_ATTR38,
759 TL_EXT_ATTR39,
760 TL_EXT_ATTR40,
761 decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
762 from RRS_LOCATIONS_EXT_TL
763 where EXTENSION_ID = X_EXTENSION_ID
764 and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
765 for update of EXTENSION_ID nowait;
766 begin
767 open c;
768 fetch c into recinfo;
769 if (c%notfound) then
770 close c;
771 fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
772 app_exception.raise_exception;
773 end if;
774 close c;
775 if ( ((recinfo.C_EXT_ATTR13 = X_C_EXT_ATTR13)
776 OR ((recinfo.C_EXT_ATTR13 is null) AND (X_C_EXT_ATTR13 is null)))
777 AND ((recinfo.C_EXT_ATTR14 = X_C_EXT_ATTR14)
778 OR ((recinfo.C_EXT_ATTR14 is null) AND (X_C_EXT_ATTR14 is null)))
779 AND ((recinfo.C_EXT_ATTR15 = X_C_EXT_ATTR15)
780 OR ((recinfo.C_EXT_ATTR15 is null) AND (X_C_EXT_ATTR15 is null)))
781 AND ((recinfo.C_EXT_ATTR16 = X_C_EXT_ATTR16)
782 OR ((recinfo.C_EXT_ATTR16 is null) AND (X_C_EXT_ATTR16 is null)))
783 AND ((recinfo.C_EXT_ATTR17 = X_C_EXT_ATTR17)
784 OR ((recinfo.C_EXT_ATTR17 is null) AND (X_C_EXT_ATTR17 is null)))
785 AND ((recinfo.C_EXT_ATTR18 = X_C_EXT_ATTR18)
786 OR ((recinfo.C_EXT_ATTR18 is null) AND (X_C_EXT_ATTR18 is null)))
787 AND ((recinfo.C_EXT_ATTR19 = X_C_EXT_ATTR19)
788 OR ((recinfo.C_EXT_ATTR19 is null) AND (X_C_EXT_ATTR19 is null)))
789 AND ((recinfo.C_EXT_ATTR20 = X_C_EXT_ATTR20)
790 OR ((recinfo.C_EXT_ATTR20 is null) AND (X_C_EXT_ATTR20 is null)))
791 AND ((recinfo.N_EXT_ATTR1 = X_N_EXT_ATTR1)
792 OR ((recinfo.N_EXT_ATTR1 is null) AND (X_N_EXT_ATTR1 is null)))
793 AND ((recinfo.N_EXT_ATTR2 = X_N_EXT_ATTR2)
794 OR ((recinfo.N_EXT_ATTR2 is null) AND (X_N_EXT_ATTR2 is null)))
795 AND ((recinfo.N_EXT_ATTR3 = X_N_EXT_ATTR3)
796 OR ((recinfo.N_EXT_ATTR3 is null) AND (X_N_EXT_ATTR3 is null)))
797 AND ((recinfo.N_EXT_ATTR4 = X_N_EXT_ATTR4)
798 OR ((recinfo.N_EXT_ATTR4 is null) AND (X_N_EXT_ATTR4 is null)))
799 AND ((recinfo.N_EXT_ATTR5 = X_N_EXT_ATTR5)
800 OR ((recinfo.N_EXT_ATTR5 is null) AND (X_N_EXT_ATTR5 is null)))
801 AND ((recinfo.N_EXT_ATTR6 = X_N_EXT_ATTR6)
802 OR ((recinfo.N_EXT_ATTR6 is null) AND (X_N_EXT_ATTR6 is null)))
803 AND ((recinfo.N_EXT_ATTR7 = X_N_EXT_ATTR7)
804 OR ((recinfo.N_EXT_ATTR7 is null) AND (X_N_EXT_ATTR7 is null)))
805 AND ((recinfo.N_EXT_ATTR8 = X_N_EXT_ATTR8)
806 OR ((recinfo.N_EXT_ATTR8 is null) AND (X_N_EXT_ATTR8 is null)))
807 AND ((recinfo.N_EXT_ATTR9 = X_N_EXT_ATTR9)
808 OR ((recinfo.N_EXT_ATTR9 is null) AND (X_N_EXT_ATTR9 is null)))
809 AND ((recinfo.N_EXT_ATTR10 = X_N_EXT_ATTR10)
810 OR ((recinfo.N_EXT_ATTR10 is null) AND (X_N_EXT_ATTR10 is null)))
811 AND ((recinfo.D_EXT_ATTR1 = X_D_EXT_ATTR1)
812 OR ((recinfo.D_EXT_ATTR1 is null) AND (X_D_EXT_ATTR1 is null)))
813 AND ((recinfo.D_EXT_ATTR2 = X_D_EXT_ATTR2)
814 OR ((recinfo.D_EXT_ATTR2 is null) AND (X_D_EXT_ATTR2 is null)))
815 AND ((recinfo.D_EXT_ATTR3 = X_D_EXT_ATTR3)
816 OR ((recinfo.D_EXT_ATTR3 is null) AND (X_D_EXT_ATTR3 is null)))
817 AND ((recinfo.D_EXT_ATTR4 = X_D_EXT_ATTR4)
818 OR ((recinfo.D_EXT_ATTR4 is null) AND (X_D_EXT_ATTR4 is null)))
819 AND ((recinfo.D_EXT_ATTR5 = X_D_EXT_ATTR5)
820 OR ((recinfo.D_EXT_ATTR5 is null) AND (X_D_EXT_ATTR5 is null)))
821 AND ((recinfo.C_EXT_ATTR21 = X_C_EXT_ATTR21)
822 OR ((recinfo.C_EXT_ATTR21 is null) AND (X_C_EXT_ATTR21 is null)))
823 AND ((recinfo.C_EXT_ATTR22 = X_C_EXT_ATTR22)
824 OR ((recinfo.C_EXT_ATTR22 is null) AND (X_C_EXT_ATTR22 is null)))
828 OR ((recinfo.C_EXT_ATTR24 is null) AND (X_C_EXT_ATTR24 is null)))
825 AND ((recinfo.C_EXT_ATTR23 = X_C_EXT_ATTR23)
826 OR ((recinfo.C_EXT_ATTR23 is null) AND (X_C_EXT_ATTR23 is null)))
827 AND ((recinfo.C_EXT_ATTR24 = X_C_EXT_ATTR24)
829 AND ((recinfo.C_EXT_ATTR25 = X_C_EXT_ATTR25)
830 OR ((recinfo.C_EXT_ATTR25 is null) AND (X_C_EXT_ATTR25 is null)))
831 AND ((recinfo.C_EXT_ATTR26 = X_C_EXT_ATTR26)
832 OR ((recinfo.C_EXT_ATTR26 is null) AND (X_C_EXT_ATTR26 is null)))
833 AND ((recinfo.C_EXT_ATTR27 = X_C_EXT_ATTR27)
834 OR ((recinfo.C_EXT_ATTR27 is null) AND (X_C_EXT_ATTR27 is null)))
835 AND ((recinfo.C_EXT_ATTR28 = X_C_EXT_ATTR28)
836 OR ((recinfo.C_EXT_ATTR28 is null) AND (X_C_EXT_ATTR28 is null)))
837 AND ((recinfo.C_EXT_ATTR29 = X_C_EXT_ATTR29)
838 OR ((recinfo.C_EXT_ATTR29 is null) AND (X_C_EXT_ATTR29 is null)))
839 AND ((recinfo.C_EXT_ATTR30 = X_C_EXT_ATTR30)
840 OR ((recinfo.C_EXT_ATTR30 is null) AND (X_C_EXT_ATTR30 is null)))
841 AND ((recinfo.C_EXT_ATTR31 = X_C_EXT_ATTR31)
842 OR ((recinfo.C_EXT_ATTR31 is null) AND (X_C_EXT_ATTR31 is null)))
843 AND ((recinfo.C_EXT_ATTR32 = X_C_EXT_ATTR32)
844 OR ((recinfo.C_EXT_ATTR32 is null) AND (X_C_EXT_ATTR32 is null)))
845 AND ((recinfo.C_EXT_ATTR33 = X_C_EXT_ATTR33)
846 OR ((recinfo.C_EXT_ATTR33 is null) AND (X_C_EXT_ATTR33 is null)))
847 AND ((recinfo.C_EXT_ATTR34 = X_C_EXT_ATTR34)
848 OR ((recinfo.C_EXT_ATTR34 is null) AND (X_C_EXT_ATTR34 is null)))
849 AND ((recinfo.C_EXT_ATTR35 = X_C_EXT_ATTR35)
850 OR ((recinfo.C_EXT_ATTR35 is null) AND (X_C_EXT_ATTR35 is null)))
851 AND ((recinfo.C_EXT_ATTR36 = X_C_EXT_ATTR36)
852 OR ((recinfo.C_EXT_ATTR36 is null) AND (X_C_EXT_ATTR36 is null)))
853 AND ((recinfo.C_EXT_ATTR37 = X_C_EXT_ATTR37)
854 OR ((recinfo.C_EXT_ATTR37 is null) AND (X_C_EXT_ATTR37 is null)))
855 AND ((recinfo.C_EXT_ATTR38 = X_C_EXT_ATTR38)
856 OR ((recinfo.C_EXT_ATTR38 is null) AND (X_C_EXT_ATTR38 is null)))
857 AND ((recinfo.C_EXT_ATTR39 = X_C_EXT_ATTR39)
858 OR ((recinfo.C_EXT_ATTR39 is null) AND (X_C_EXT_ATTR39 is null)))
859 AND ((recinfo.C_EXT_ATTR40 = X_C_EXT_ATTR40)
860 OR ((recinfo.C_EXT_ATTR40 is null) AND (X_C_EXT_ATTR40 is null)))
861 AND ((recinfo.N_EXT_ATTR11 = X_N_EXT_ATTR11)
862 OR ((recinfo.N_EXT_ATTR11 is null) AND (X_N_EXT_ATTR11 is null)))
863 AND ((recinfo.N_EXT_ATTR12 = X_N_EXT_ATTR12)
864 OR ((recinfo.N_EXT_ATTR12 is null) AND (X_N_EXT_ATTR12 is null)))
865 AND ((recinfo.N_EXT_ATTR13 = X_N_EXT_ATTR13)
866 OR ((recinfo.N_EXT_ATTR13 is null) AND (X_N_EXT_ATTR13 is null)))
867 AND ((recinfo.N_EXT_ATTR14 = X_N_EXT_ATTR14)
868 OR ((recinfo.N_EXT_ATTR14 is null) AND (X_N_EXT_ATTR14 is null)))
869 AND ((recinfo.N_EXT_ATTR15 = X_N_EXT_ATTR15)
870 OR ((recinfo.N_EXT_ATTR15 is null) AND (X_N_EXT_ATTR15 is null)))
871 AND ((recinfo.N_EXT_ATTR16 = X_N_EXT_ATTR16)
872 OR ((recinfo.N_EXT_ATTR16 is null) AND (X_N_EXT_ATTR16 is null)))
873 AND ((recinfo.N_EXT_ATTR17 = X_N_EXT_ATTR17)
874 OR ((recinfo.N_EXT_ATTR17 is null) AND (X_N_EXT_ATTR17 is null)))
875 AND ((recinfo.N_EXT_ATTR18 = X_N_EXT_ATTR18)
876 OR ((recinfo.N_EXT_ATTR18 is null) AND (X_N_EXT_ATTR18 is null)))
877 AND ((recinfo.N_EXT_ATTR19 = X_N_EXT_ATTR19)
878 OR ((recinfo.N_EXT_ATTR19 is null) AND (X_N_EXT_ATTR19 is null)))
879 AND ((recinfo.N_EXT_ATTR20 = X_N_EXT_ATTR20)
880 OR ((recinfo.N_EXT_ATTR20 is null) AND (X_N_EXT_ATTR20 is null)))
881 AND ((recinfo.UOM_EXT_ATTR1 = X_UOM_EXT_ATTR1)
882 OR ((recinfo.UOM_EXT_ATTR1 is null) AND (X_UOM_EXT_ATTR1 is null)))
883 AND ((recinfo.UOM_EXT_ATTR2 = X_UOM_EXT_ATTR2)
884 OR ((recinfo.UOM_EXT_ATTR2 is null) AND (X_UOM_EXT_ATTR2 is null)))
885 AND ((recinfo.UOM_EXT_ATTR3 = X_UOM_EXT_ATTR3)
886 OR ((recinfo.UOM_EXT_ATTR3 is null) AND (X_UOM_EXT_ATTR3 is null)))
887 AND ((recinfo.UOM_EXT_ATTR4 = X_UOM_EXT_ATTR4)
888 OR ((recinfo.UOM_EXT_ATTR4 is null) AND (X_UOM_EXT_ATTR4 is null)))
889 AND ((recinfo.UOM_EXT_ATTR5 = X_UOM_EXT_ATTR5)
890 OR ((recinfo.UOM_EXT_ATTR5 is null) AND (X_UOM_EXT_ATTR5 is null)))
891 AND ((recinfo.UOM_EXT_ATTR6 = X_UOM_EXT_ATTR6)
892 OR ((recinfo.UOM_EXT_ATTR6 is null) AND (X_UOM_EXT_ATTR6 is null)))
893 AND ((recinfo.UOM_EXT_ATTR7 = X_UOM_EXT_ATTR7)
894 OR ((recinfo.UOM_EXT_ATTR7 is null) AND (X_UOM_EXT_ATTR7 is null)))
895 AND ((recinfo.UOM_EXT_ATTR8 = X_UOM_EXT_ATTR8)
896 OR ((recinfo.UOM_EXT_ATTR8 is null) AND (X_UOM_EXT_ATTR8 is null)))
897 AND ((recinfo.UOM_EXT_ATTR9 = X_UOM_EXT_ATTR9)
898 OR ((recinfo.UOM_EXT_ATTR9 is null) AND (X_UOM_EXT_ATTR9 is null)))
899 AND ((recinfo.UOM_EXT_ATTR10 = X_UOM_EXT_ATTR10)
900 OR ((recinfo.UOM_EXT_ATTR10 is null) AND (X_UOM_EXT_ATTR10 is null)))
901 AND ((recinfo.UOM_EXT_ATTR11 = X_UOM_EXT_ATTR11)
902 OR ((recinfo.UOM_EXT_ATTR11 is null) AND (X_UOM_EXT_ATTR11 is null)))
903 AND ((recinfo.UOM_EXT_ATTR12 = X_UOM_EXT_ATTR12)
904 OR ((recinfo.UOM_EXT_ATTR12 is null) AND (X_UOM_EXT_ATTR12 is null)))
905 AND ((recinfo.UOM_EXT_ATTR13 = X_UOM_EXT_ATTR13)
906 OR ((recinfo.UOM_EXT_ATTR13 is null) AND (X_UOM_EXT_ATTR13 is null)))
907 AND ((recinfo.UOM_EXT_ATTR14 = X_UOM_EXT_ATTR14)
908 OR ((recinfo.UOM_EXT_ATTR14 is null) AND (X_UOM_EXT_ATTR14 is null)))
909 AND ((recinfo.UOM_EXT_ATTR15 = X_UOM_EXT_ATTR15)
910 OR ((recinfo.UOM_EXT_ATTR15 is null) AND (X_UOM_EXT_ATTR15 is null)))
914 OR ((recinfo.UOM_EXT_ATTR17 is null) AND (X_UOM_EXT_ATTR17 is null)))
911 AND ((recinfo.UOM_EXT_ATTR16 = X_UOM_EXT_ATTR16)
912 OR ((recinfo.UOM_EXT_ATTR16 is null) AND (X_UOM_EXT_ATTR16 is null)))
913 AND ((recinfo.UOM_EXT_ATTR17 = X_UOM_EXT_ATTR17)
915 AND ((recinfo.UOM_EXT_ATTR18 = X_UOM_EXT_ATTR18)
916 OR ((recinfo.UOM_EXT_ATTR18 is null) AND (X_UOM_EXT_ATTR18 is null)))
917 AND ((recinfo.UOM_EXT_ATTR19 = X_UOM_EXT_ATTR19)
918 OR ((recinfo.UOM_EXT_ATTR19 is null) AND (X_UOM_EXT_ATTR19 is null)))
919 AND ((recinfo.UOM_EXT_ATTR20 = X_UOM_EXT_ATTR20)
920 OR ((recinfo.UOM_EXT_ATTR20 is null) AND (X_UOM_EXT_ATTR20 is null)))
921 AND ((recinfo.D_EXT_ATTR6 = X_D_EXT_ATTR6)
922 OR ((recinfo.D_EXT_ATTR6 is null) AND (X_D_EXT_ATTR6 is null)))
923 AND ((recinfo.D_EXT_ATTR7 = X_D_EXT_ATTR7)
924 OR ((recinfo.D_EXT_ATTR7 is null) AND (X_D_EXT_ATTR7 is null)))
925 AND ((recinfo.D_EXT_ATTR8 = X_D_EXT_ATTR8)
926 OR ((recinfo.D_EXT_ATTR8 is null) AND (X_D_EXT_ATTR8 is null)))
927 AND ((recinfo.D_EXT_ATTR9 = X_D_EXT_ATTR9)
928 OR ((recinfo.D_EXT_ATTR9 is null) AND (X_D_EXT_ATTR9 is null)))
929 AND ((recinfo.D_EXT_ATTR10 = X_D_EXT_ATTR10)
930 OR ((recinfo.D_EXT_ATTR10 is null) AND (X_D_EXT_ATTR10 is null)))
931 AND ((recinfo.REQUEST_ID = X_REQUEST_ID)
932 OR ((recinfo.REQUEST_ID is null) AND (X_REQUEST_ID is null)))
933 AND (recinfo.LOCATION_ID = X_LOCATION_ID)
934 AND (recinfo.COUNTRY = X_COUNTRY)
935 AND (recinfo.ATTR_GROUP_ID = X_ATTR_GROUP_ID)
936 AND ((recinfo.C_EXT_ATTR1 = X_C_EXT_ATTR1)
937 OR ((recinfo.C_EXT_ATTR1 is null) AND (X_C_EXT_ATTR1 is null)))
938 AND ((recinfo.C_EXT_ATTR2 = X_C_EXT_ATTR2)
939 OR ((recinfo.C_EXT_ATTR2 is null) AND (X_C_EXT_ATTR2 is null)))
940 AND ((recinfo.C_EXT_ATTR3 = X_C_EXT_ATTR3)
941 OR ((recinfo.C_EXT_ATTR3 is null) AND (X_C_EXT_ATTR3 is null)))
942 AND ((recinfo.C_EXT_ATTR4 = X_C_EXT_ATTR4)
943 OR ((recinfo.C_EXT_ATTR4 is null) AND (X_C_EXT_ATTR4 is null)))
944 AND ((recinfo.C_EXT_ATTR5 = X_C_EXT_ATTR5)
945 OR ((recinfo.C_EXT_ATTR5 is null) AND (X_C_EXT_ATTR5 is null)))
946 AND ((recinfo.C_EXT_ATTR6 = X_C_EXT_ATTR6)
947 OR ((recinfo.C_EXT_ATTR6 is null) AND (X_C_EXT_ATTR6 is null)))
948 AND ((recinfo.C_EXT_ATTR7 = X_C_EXT_ATTR7)
949 OR ((recinfo.C_EXT_ATTR7 is null) AND (X_C_EXT_ATTR7 is null)))
950 AND ((recinfo.C_EXT_ATTR8 = X_C_EXT_ATTR8)
951 OR ((recinfo.C_EXT_ATTR8 is null) AND (X_C_EXT_ATTR8 is null)))
952 AND ((recinfo.C_EXT_ATTR9 = X_C_EXT_ATTR9)
953 OR ((recinfo.C_EXT_ATTR9 is null) AND (X_C_EXT_ATTR9 is null)))
954 AND ((recinfo.C_EXT_ATTR10 = X_C_EXT_ATTR10)
955 OR ((recinfo.C_EXT_ATTR10 is null) AND (X_C_EXT_ATTR10 is null)))
956 AND ((recinfo.C_EXT_ATTR11 = X_C_EXT_ATTR11)
957 OR ((recinfo.C_EXT_ATTR11 is null) AND (X_C_EXT_ATTR11 is null)))
958 AND ((recinfo.C_EXT_ATTR12 = X_C_EXT_ATTR12)
959 OR ((recinfo.C_EXT_ATTR12 is null) AND (X_C_EXT_ATTR12 is null)))
960 ) then
961 null;
962 else
963 fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
964 app_exception.raise_exception;
965 end if;
966
967 for tlinfo in c1 loop
968 if (tlinfo.BASELANG = 'Y') then
969 if ( ((tlinfo.TL_EXT_ATTR1 = X_TL_EXT_ATTR1)
970 OR ((tlinfo.TL_EXT_ATTR1 is null) AND (X_TL_EXT_ATTR1 is null)))
971 AND ((tlinfo.TL_EXT_ATTR2 = X_TL_EXT_ATTR2)
972 OR ((tlinfo.TL_EXT_ATTR2 is null) AND (X_TL_EXT_ATTR2 is null)))
973 AND ((tlinfo.TL_EXT_ATTR3 = X_TL_EXT_ATTR3)
974 OR ((tlinfo.TL_EXT_ATTR3 is null) AND (X_TL_EXT_ATTR3 is null)))
975 AND ((tlinfo.TL_EXT_ATTR4 = X_TL_EXT_ATTR4)
976 OR ((tlinfo.TL_EXT_ATTR4 is null) AND (X_TL_EXT_ATTR4 is null)))
977 AND ((tlinfo.TL_EXT_ATTR5 = X_TL_EXT_ATTR5)
978 OR ((tlinfo.TL_EXT_ATTR5 is null) AND (X_TL_EXT_ATTR5 is null)))
979 AND ((tlinfo.TL_EXT_ATTR6 = X_TL_EXT_ATTR6)
980 OR ((tlinfo.TL_EXT_ATTR6 is null) AND (X_TL_EXT_ATTR6 is null)))
981 AND ((tlinfo.TL_EXT_ATTR7 = X_TL_EXT_ATTR7)
982 OR ((tlinfo.TL_EXT_ATTR7 is null) AND (X_TL_EXT_ATTR7 is null)))
983 AND ((tlinfo.TL_EXT_ATTR8 = X_TL_EXT_ATTR8)
984 OR ((tlinfo.TL_EXT_ATTR8 is null) AND (X_TL_EXT_ATTR8 is null)))
985 AND ((tlinfo.TL_EXT_ATTR9 = X_TL_EXT_ATTR9)
986 OR ((tlinfo.TL_EXT_ATTR9 is null) AND (X_TL_EXT_ATTR9 is null)))
987 AND ((tlinfo.TL_EXT_ATTR10 = X_TL_EXT_ATTR10)
988 OR ((tlinfo.TL_EXT_ATTR10 is null) AND (X_TL_EXT_ATTR10 is null)))
989 AND ((tlinfo.TL_EXT_ATTR11 = X_TL_EXT_ATTR11)
990 OR ((tlinfo.TL_EXT_ATTR11 is null) AND (X_TL_EXT_ATTR11 is null)))
991 AND ((tlinfo.TL_EXT_ATTR12 = X_TL_EXT_ATTR12)
992 OR ((tlinfo.TL_EXT_ATTR12 is null) AND (X_TL_EXT_ATTR12 is null)))
993 AND ((tlinfo.TL_EXT_ATTR13 = X_TL_EXT_ATTR13)
994 OR ((tlinfo.TL_EXT_ATTR13 is null) AND (X_TL_EXT_ATTR13 is null)))
995 AND ((tlinfo.TL_EXT_ATTR14 = X_TL_EXT_ATTR14)
996 OR ((tlinfo.TL_EXT_ATTR14 is null) AND (X_TL_EXT_ATTR14 is null)))
997 AND ((tlinfo.TL_EXT_ATTR15 = X_TL_EXT_ATTR15)
998 OR ((tlinfo.TL_EXT_ATTR15 is null) AND (X_TL_EXT_ATTR15 is null)))
999 AND ((tlinfo.TL_EXT_ATTR16 = X_TL_EXT_ATTR16)
1000 OR ((tlinfo.TL_EXT_ATTR16 is null) AND (X_TL_EXT_ATTR16 is null)))
1001 AND ((tlinfo.TL_EXT_ATTR17 = X_TL_EXT_ATTR17)
1005 AND ((tlinfo.TL_EXT_ATTR19 = X_TL_EXT_ATTR19)
1002 OR ((tlinfo.TL_EXT_ATTR17 is null) AND (X_TL_EXT_ATTR17 is null)))
1003 AND ((tlinfo.TL_EXT_ATTR18 = X_TL_EXT_ATTR18)
1004 OR ((tlinfo.TL_EXT_ATTR18 is null) AND (X_TL_EXT_ATTR18 is null)))
1006 OR ((tlinfo.TL_EXT_ATTR19 is null) AND (X_TL_EXT_ATTR19 is null)))
1007 AND ((tlinfo.TL_EXT_ATTR20 = X_TL_EXT_ATTR20)
1008 OR ((tlinfo.TL_EXT_ATTR20 is null) AND (X_TL_EXT_ATTR20 is null)))
1009 AND ((tlinfo.TL_EXT_ATTR21 = X_TL_EXT_ATTR21)
1010 OR ((tlinfo.TL_EXT_ATTR21 is null) AND (X_TL_EXT_ATTR21 is null)))
1011 AND ((tlinfo.TL_EXT_ATTR22 = X_TL_EXT_ATTR22)
1012 OR ((tlinfo.TL_EXT_ATTR22 is null) AND (X_TL_EXT_ATTR22 is null)))
1013 AND ((tlinfo.TL_EXT_ATTR23 = X_TL_EXT_ATTR23)
1014 OR ((tlinfo.TL_EXT_ATTR23 is null) AND (X_TL_EXT_ATTR23 is null)))
1015 AND ((tlinfo.TL_EXT_ATTR24 = X_TL_EXT_ATTR24)
1016 OR ((tlinfo.TL_EXT_ATTR24 is null) AND (X_TL_EXT_ATTR24 is null)))
1017 AND ((tlinfo.TL_EXT_ATTR25 = X_TL_EXT_ATTR25)
1018 OR ((tlinfo.TL_EXT_ATTR25 is null) AND (X_TL_EXT_ATTR25 is null)))
1019 AND ((tlinfo.TL_EXT_ATTR26 = X_TL_EXT_ATTR26)
1020 OR ((tlinfo.TL_EXT_ATTR26 is null) AND (X_TL_EXT_ATTR26 is null)))
1021 AND ((tlinfo.TL_EXT_ATTR27 = X_TL_EXT_ATTR27)
1022 OR ((tlinfo.TL_EXT_ATTR27 is null) AND (X_TL_EXT_ATTR27 is null)))
1023 AND ((tlinfo.TL_EXT_ATTR28 = X_TL_EXT_ATTR28)
1024 OR ((tlinfo.TL_EXT_ATTR28 is null) AND (X_TL_EXT_ATTR28 is null)))
1025 AND ((tlinfo.TL_EXT_ATTR29 = X_TL_EXT_ATTR29)
1026 OR ((tlinfo.TL_EXT_ATTR29 is null) AND (X_TL_EXT_ATTR29 is null)))
1027 AND ((tlinfo.TL_EXT_ATTR30 = X_TL_EXT_ATTR30)
1028 OR ((tlinfo.TL_EXT_ATTR30 is null) AND (X_TL_EXT_ATTR30 is null)))
1029 AND ((tlinfo.TL_EXT_ATTR31 = X_TL_EXT_ATTR31)
1030 OR ((tlinfo.TL_EXT_ATTR31 is null) AND (X_TL_EXT_ATTR31 is null)))
1031 AND ((tlinfo.TL_EXT_ATTR32 = X_TL_EXT_ATTR32)
1032 OR ((tlinfo.TL_EXT_ATTR32 is null) AND (X_TL_EXT_ATTR32 is null)))
1033 AND ((tlinfo.TL_EXT_ATTR33 = X_TL_EXT_ATTR33)
1034 OR ((tlinfo.TL_EXT_ATTR33 is null) AND (X_TL_EXT_ATTR33 is null)))
1035 AND ((tlinfo.TL_EXT_ATTR34 = X_TL_EXT_ATTR34)
1036 OR ((tlinfo.TL_EXT_ATTR34 is null) AND (X_TL_EXT_ATTR34 is null)))
1037 AND ((tlinfo.TL_EXT_ATTR35 = X_TL_EXT_ATTR35)
1038 OR ((tlinfo.TL_EXT_ATTR35 is null) AND (X_TL_EXT_ATTR35 is null)))
1039 AND ((tlinfo.TL_EXT_ATTR36 = X_TL_EXT_ATTR36)
1040 OR ((tlinfo.TL_EXT_ATTR36 is null) AND (X_TL_EXT_ATTR36 is null)))
1041 AND ((tlinfo.TL_EXT_ATTR37 = X_TL_EXT_ATTR37)
1042 OR ((tlinfo.TL_EXT_ATTR37 is null) AND (X_TL_EXT_ATTR37 is null)))
1043 AND ((tlinfo.TL_EXT_ATTR38 = X_TL_EXT_ATTR38)
1044 OR ((tlinfo.TL_EXT_ATTR38 is null) AND (X_TL_EXT_ATTR38 is null)))
1045 AND ((tlinfo.TL_EXT_ATTR39 = X_TL_EXT_ATTR39)
1046 OR ((tlinfo.TL_EXT_ATTR39 is null) AND (X_TL_EXT_ATTR39 is null)))
1047 AND ((tlinfo.TL_EXT_ATTR40 = X_TL_EXT_ATTR40)
1048 OR ((tlinfo.TL_EXT_ATTR40 is null) AND (X_TL_EXT_ATTR40 is null)))
1049 ) then
1050 null;
1051 else
1052 fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1053 app_exception.raise_exception;
1054 end if;
1055 end if;
1056 end loop;
1057 return;
1058 end LOCK_ROW;
1059
1060 procedure UPDATE_ROW (
1061 X_EXTENSION_ID in NUMBER,
1062 X_C_EXT_ATTR13 in VARCHAR2,
1063 X_C_EXT_ATTR14 in VARCHAR2,
1064 X_C_EXT_ATTR15 in VARCHAR2,
1065 X_C_EXT_ATTR16 in VARCHAR2,
1066 X_C_EXT_ATTR17 in VARCHAR2,
1067 X_C_EXT_ATTR18 in VARCHAR2,
1068 X_C_EXT_ATTR19 in VARCHAR2,
1069 X_C_EXT_ATTR20 in VARCHAR2,
1070 X_N_EXT_ATTR1 in NUMBER,
1071 X_N_EXT_ATTR2 in NUMBER,
1072 X_N_EXT_ATTR3 in NUMBER,
1073 X_N_EXT_ATTR4 in NUMBER,
1074 X_N_EXT_ATTR5 in NUMBER,
1075 X_N_EXT_ATTR6 in NUMBER,
1076 X_N_EXT_ATTR7 in NUMBER,
1077 X_N_EXT_ATTR8 in NUMBER,
1078 X_N_EXT_ATTR9 in NUMBER,
1079 X_N_EXT_ATTR10 in NUMBER,
1080 X_D_EXT_ATTR1 in DATE,
1081 X_D_EXT_ATTR2 in DATE,
1082 X_D_EXT_ATTR3 in DATE,
1083 X_D_EXT_ATTR4 in DATE,
1084 X_D_EXT_ATTR5 in DATE,
1085 X_C_EXT_ATTR21 in VARCHAR2,
1086 X_C_EXT_ATTR22 in VARCHAR2,
1087 X_C_EXT_ATTR23 in VARCHAR2,
1088 X_C_EXT_ATTR24 in VARCHAR2,
1089 X_C_EXT_ATTR25 in VARCHAR2,
1090 X_C_EXT_ATTR26 in VARCHAR2,
1091 X_C_EXT_ATTR27 in VARCHAR2,
1092 X_C_EXT_ATTR28 in VARCHAR2,
1093 X_C_EXT_ATTR29 in VARCHAR2,
1094 X_C_EXT_ATTR30 in VARCHAR2,
1095 X_C_EXT_ATTR31 in VARCHAR2,
1096 X_C_EXT_ATTR32 in VARCHAR2,
1097 X_C_EXT_ATTR33 in VARCHAR2,
1098 X_C_EXT_ATTR34 in VARCHAR2,
1099 X_C_EXT_ATTR35 in VARCHAR2,
1100 X_C_EXT_ATTR36 in VARCHAR2,
1101 X_C_EXT_ATTR37 in VARCHAR2,
1102 X_C_EXT_ATTR38 in VARCHAR2,
1103 X_C_EXT_ATTR39 in VARCHAR2,
1104 X_C_EXT_ATTR40 in VARCHAR2,
1105 X_N_EXT_ATTR11 in NUMBER,
1106 X_N_EXT_ATTR12 in NUMBER,
1107 X_N_EXT_ATTR13 in NUMBER,
1108 X_N_EXT_ATTR14 in NUMBER,
1109 X_N_EXT_ATTR15 in NUMBER,
1110 X_N_EXT_ATTR16 in NUMBER,
1111 X_N_EXT_ATTR17 in NUMBER,
1112 X_N_EXT_ATTR18 in NUMBER,
1113 X_N_EXT_ATTR19 in NUMBER,
1114 X_N_EXT_ATTR20 in NUMBER,
1118 X_UOM_EXT_ATTR4 in VARCHAR2,
1115 X_UOM_EXT_ATTR1 in VARCHAR2,
1116 X_UOM_EXT_ATTR2 in VARCHAR2,
1117 X_UOM_EXT_ATTR3 in VARCHAR2,
1119 X_UOM_EXT_ATTR5 in VARCHAR2,
1120 X_UOM_EXT_ATTR6 in VARCHAR2,
1121 X_UOM_EXT_ATTR7 in VARCHAR2,
1122 X_UOM_EXT_ATTR8 in VARCHAR2,
1123 X_UOM_EXT_ATTR9 in VARCHAR2,
1124 X_UOM_EXT_ATTR10 in VARCHAR2,
1125 X_UOM_EXT_ATTR11 in VARCHAR2,
1126 X_UOM_EXT_ATTR12 in VARCHAR2,
1127 X_UOM_EXT_ATTR13 in VARCHAR2,
1128 X_UOM_EXT_ATTR14 in VARCHAR2,
1129 X_UOM_EXT_ATTR15 in VARCHAR2,
1130 X_UOM_EXT_ATTR16 in VARCHAR2,
1131 X_UOM_EXT_ATTR17 in VARCHAR2,
1132 X_UOM_EXT_ATTR18 in VARCHAR2,
1133 X_UOM_EXT_ATTR19 in VARCHAR2,
1134 X_UOM_EXT_ATTR20 in VARCHAR2,
1135 X_D_EXT_ATTR6 in DATE,
1136 X_D_EXT_ATTR7 in DATE,
1137 X_D_EXT_ATTR8 in DATE,
1138 X_D_EXT_ATTR9 in DATE,
1139 X_D_EXT_ATTR10 in DATE,
1140 X_REQUEST_ID in NUMBER,
1141 X_LOCATION_ID in NUMBER,
1142 X_COUNTRY in VARCHAR2,
1143 X_ATTR_GROUP_ID in NUMBER,
1144 X_C_EXT_ATTR1 in VARCHAR2,
1145 X_C_EXT_ATTR2 in VARCHAR2,
1146 X_C_EXT_ATTR3 in VARCHAR2,
1147 X_C_EXT_ATTR4 in VARCHAR2,
1148 X_C_EXT_ATTR5 in VARCHAR2,
1149 X_C_EXT_ATTR6 in VARCHAR2,
1150 X_C_EXT_ATTR7 in VARCHAR2,
1151 X_C_EXT_ATTR8 in VARCHAR2,
1152 X_C_EXT_ATTR9 in VARCHAR2,
1153 X_C_EXT_ATTR10 in VARCHAR2,
1154 X_C_EXT_ATTR11 in VARCHAR2,
1155 X_C_EXT_ATTR12 in VARCHAR2,
1156 X_TL_EXT_ATTR1 in VARCHAR2,
1157 X_TL_EXT_ATTR2 in VARCHAR2,
1158 X_TL_EXT_ATTR3 in VARCHAR2,
1159 X_TL_EXT_ATTR4 in VARCHAR2,
1160 X_TL_EXT_ATTR5 in VARCHAR2,
1161 X_TL_EXT_ATTR6 in VARCHAR2,
1162 X_TL_EXT_ATTR7 in VARCHAR2,
1163 X_TL_EXT_ATTR8 in VARCHAR2,
1164 X_TL_EXT_ATTR9 in VARCHAR2,
1165 X_TL_EXT_ATTR10 in VARCHAR2,
1166 X_TL_EXT_ATTR11 in VARCHAR2,
1167 X_TL_EXT_ATTR12 in VARCHAR2,
1168 X_TL_EXT_ATTR13 in VARCHAR2,
1169 X_TL_EXT_ATTR14 in VARCHAR2,
1170 X_TL_EXT_ATTR15 in VARCHAR2,
1171 X_TL_EXT_ATTR16 in VARCHAR2,
1172 X_TL_EXT_ATTR17 in VARCHAR2,
1173 X_TL_EXT_ATTR18 in VARCHAR2,
1174 X_TL_EXT_ATTR19 in VARCHAR2,
1175 X_TL_EXT_ATTR20 in VARCHAR2,
1176 X_TL_EXT_ATTR21 in VARCHAR2,
1177 X_TL_EXT_ATTR22 in VARCHAR2,
1178 X_TL_EXT_ATTR23 in VARCHAR2,
1179 X_TL_EXT_ATTR24 in VARCHAR2,
1180 X_TL_EXT_ATTR25 in VARCHAR2,
1181 X_TL_EXT_ATTR26 in VARCHAR2,
1182 X_TL_EXT_ATTR27 in VARCHAR2,
1183 X_TL_EXT_ATTR28 in VARCHAR2,
1184 X_TL_EXT_ATTR29 in VARCHAR2,
1185 X_TL_EXT_ATTR30 in VARCHAR2,
1186 X_TL_EXT_ATTR31 in VARCHAR2,
1187 X_TL_EXT_ATTR32 in VARCHAR2,
1188 X_TL_EXT_ATTR33 in VARCHAR2,
1189 X_TL_EXT_ATTR34 in VARCHAR2,
1190 X_TL_EXT_ATTR35 in VARCHAR2,
1191 X_TL_EXT_ATTR36 in VARCHAR2,
1192 X_TL_EXT_ATTR37 in VARCHAR2,
1193 X_TL_EXT_ATTR38 in VARCHAR2,
1194 X_TL_EXT_ATTR39 in VARCHAR2,
1195 X_TL_EXT_ATTR40 in VARCHAR2,
1196 X_LAST_UPDATE_DATE in DATE,
1197 X_LAST_UPDATED_BY in NUMBER,
1198 X_LAST_UPDATE_LOGIN in NUMBER
1199 ) is
1200 begin
1201 update RRS_LOCATIONS_EXT_B set
1202 C_EXT_ATTR13 = X_C_EXT_ATTR13,
1203 C_EXT_ATTR14 = X_C_EXT_ATTR14,
1204 C_EXT_ATTR15 = X_C_EXT_ATTR15,
1205 C_EXT_ATTR16 = X_C_EXT_ATTR16,
1206 C_EXT_ATTR17 = X_C_EXT_ATTR17,
1207 C_EXT_ATTR18 = X_C_EXT_ATTR18,
1208 C_EXT_ATTR19 = X_C_EXT_ATTR19,
1209 C_EXT_ATTR20 = X_C_EXT_ATTR20,
1210 N_EXT_ATTR1 = X_N_EXT_ATTR1,
1211 N_EXT_ATTR2 = X_N_EXT_ATTR2,
1212 N_EXT_ATTR3 = X_N_EXT_ATTR3,
1213 N_EXT_ATTR4 = X_N_EXT_ATTR4,
1214 N_EXT_ATTR5 = X_N_EXT_ATTR5,
1215 N_EXT_ATTR6 = X_N_EXT_ATTR6,
1216 N_EXT_ATTR7 = X_N_EXT_ATTR7,
1217 N_EXT_ATTR8 = X_N_EXT_ATTR8,
1218 N_EXT_ATTR9 = X_N_EXT_ATTR9,
1219 N_EXT_ATTR10 = X_N_EXT_ATTR10,
1220 D_EXT_ATTR1 = X_D_EXT_ATTR1,
1221 D_EXT_ATTR2 = X_D_EXT_ATTR2,
1222 D_EXT_ATTR3 = X_D_EXT_ATTR3,
1223 D_EXT_ATTR4 = X_D_EXT_ATTR4,
1224 D_EXT_ATTR5 = X_D_EXT_ATTR5,
1225 C_EXT_ATTR21 = X_C_EXT_ATTR21,
1226 C_EXT_ATTR22 = X_C_EXT_ATTR22,
1227 C_EXT_ATTR23 = X_C_EXT_ATTR23,
1228 C_EXT_ATTR24 = X_C_EXT_ATTR24,
1229 C_EXT_ATTR25 = X_C_EXT_ATTR25,
1230 C_EXT_ATTR26 = X_C_EXT_ATTR26,
1231 C_EXT_ATTR27 = X_C_EXT_ATTR27,
1232 C_EXT_ATTR28 = X_C_EXT_ATTR28,
1233 C_EXT_ATTR29 = X_C_EXT_ATTR29,
1234 C_EXT_ATTR30 = X_C_EXT_ATTR30,
1235 C_EXT_ATTR31 = X_C_EXT_ATTR31,
1236 C_EXT_ATTR32 = X_C_EXT_ATTR32,
1237 C_EXT_ATTR33 = X_C_EXT_ATTR33,
1238 C_EXT_ATTR34 = X_C_EXT_ATTR34,
1239 C_EXT_ATTR35 = X_C_EXT_ATTR35,
1240 C_EXT_ATTR36 = X_C_EXT_ATTR36,
1241 C_EXT_ATTR37 = X_C_EXT_ATTR37,
1242 C_EXT_ATTR38 = X_C_EXT_ATTR38,
1243 C_EXT_ATTR39 = X_C_EXT_ATTR39,
1244 C_EXT_ATTR40 = X_C_EXT_ATTR40,
1245 N_EXT_ATTR11 = X_N_EXT_ATTR11,
1246 N_EXT_ATTR12 = X_N_EXT_ATTR12,
1247 N_EXT_ATTR13 = X_N_EXT_ATTR13,
1248 N_EXT_ATTR14 = X_N_EXT_ATTR14,
1249 N_EXT_ATTR15 = X_N_EXT_ATTR15,
1250 N_EXT_ATTR16 = X_N_EXT_ATTR16,
1251 N_EXT_ATTR17 = X_N_EXT_ATTR17,
1252 N_EXT_ATTR18 = X_N_EXT_ATTR18,
1253 N_EXT_ATTR19 = X_N_EXT_ATTR19,
1254 N_EXT_ATTR20 = X_N_EXT_ATTR20,
1255 UOM_EXT_ATTR1 = X_UOM_EXT_ATTR1,
1259 UOM_EXT_ATTR5 = X_UOM_EXT_ATTR5,
1256 UOM_EXT_ATTR2 = X_UOM_EXT_ATTR2,
1257 UOM_EXT_ATTR3 = X_UOM_EXT_ATTR3,
1258 UOM_EXT_ATTR4 = X_UOM_EXT_ATTR4,
1260 UOM_EXT_ATTR6 = X_UOM_EXT_ATTR6,
1261 UOM_EXT_ATTR7 = X_UOM_EXT_ATTR7,
1262 UOM_EXT_ATTR8 = X_UOM_EXT_ATTR8,
1263 UOM_EXT_ATTR9 = X_UOM_EXT_ATTR9,
1264 UOM_EXT_ATTR10 = X_UOM_EXT_ATTR10,
1265 UOM_EXT_ATTR11 = X_UOM_EXT_ATTR11,
1266 UOM_EXT_ATTR12 = X_UOM_EXT_ATTR12,
1267 UOM_EXT_ATTR13 = X_UOM_EXT_ATTR13,
1268 UOM_EXT_ATTR14 = X_UOM_EXT_ATTR14,
1269 UOM_EXT_ATTR15 = X_UOM_EXT_ATTR15,
1270 UOM_EXT_ATTR16 = X_UOM_EXT_ATTR16,
1271 UOM_EXT_ATTR17 = X_UOM_EXT_ATTR17,
1272 UOM_EXT_ATTR18 = X_UOM_EXT_ATTR18,
1273 UOM_EXT_ATTR19 = X_UOM_EXT_ATTR19,
1274 UOM_EXT_ATTR20 = X_UOM_EXT_ATTR20,
1275 D_EXT_ATTR6 = X_D_EXT_ATTR6,
1276 D_EXT_ATTR7 = X_D_EXT_ATTR7,
1277 D_EXT_ATTR8 = X_D_EXT_ATTR8,
1278 D_EXT_ATTR9 = X_D_EXT_ATTR9,
1279 D_EXT_ATTR10 = X_D_EXT_ATTR10,
1280 REQUEST_ID = X_REQUEST_ID,
1281 LOCATION_ID = X_LOCATION_ID,
1282 COUNTRY = X_COUNTRY,
1283 ATTR_GROUP_ID = X_ATTR_GROUP_ID,
1284 C_EXT_ATTR1 = X_C_EXT_ATTR1,
1285 C_EXT_ATTR2 = X_C_EXT_ATTR2,
1286 C_EXT_ATTR3 = X_C_EXT_ATTR3,
1287 C_EXT_ATTR4 = X_C_EXT_ATTR4,
1288 C_EXT_ATTR5 = X_C_EXT_ATTR5,
1289 C_EXT_ATTR6 = X_C_EXT_ATTR6,
1290 C_EXT_ATTR7 = X_C_EXT_ATTR7,
1291 C_EXT_ATTR8 = X_C_EXT_ATTR8,
1292 C_EXT_ATTR9 = X_C_EXT_ATTR9,
1293 C_EXT_ATTR10 = X_C_EXT_ATTR10,
1294 C_EXT_ATTR11 = X_C_EXT_ATTR11,
1295 C_EXT_ATTR12 = X_C_EXT_ATTR12,
1296 LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
1297 LAST_UPDATED_BY = X_LAST_UPDATED_BY,
1298 LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
1299 where EXTENSION_ID = X_EXTENSION_ID;
1300
1301 if (sql%notfound) then
1302 raise no_data_found;
1303 end if;
1304
1305 update RRS_LOCATIONS_EXT_TL set
1306 TL_EXT_ATTR1 = X_TL_EXT_ATTR1,
1307 TL_EXT_ATTR2 = X_TL_EXT_ATTR2,
1308 TL_EXT_ATTR3 = X_TL_EXT_ATTR3,
1309 TL_EXT_ATTR4 = X_TL_EXT_ATTR4,
1310 TL_EXT_ATTR5 = X_TL_EXT_ATTR5,
1311 TL_EXT_ATTR6 = X_TL_EXT_ATTR6,
1312 TL_EXT_ATTR7 = X_TL_EXT_ATTR7,
1313 TL_EXT_ATTR8 = X_TL_EXT_ATTR8,
1314 TL_EXT_ATTR9 = X_TL_EXT_ATTR9,
1315 TL_EXT_ATTR10 = X_TL_EXT_ATTR10,
1316 TL_EXT_ATTR11 = X_TL_EXT_ATTR11,
1317 TL_EXT_ATTR12 = X_TL_EXT_ATTR12,
1318 TL_EXT_ATTR13 = X_TL_EXT_ATTR13,
1319 TL_EXT_ATTR14 = X_TL_EXT_ATTR14,
1320 TL_EXT_ATTR15 = X_TL_EXT_ATTR15,
1321 TL_EXT_ATTR16 = X_TL_EXT_ATTR16,
1322 TL_EXT_ATTR17 = X_TL_EXT_ATTR17,
1323 TL_EXT_ATTR18 = X_TL_EXT_ATTR18,
1324 TL_EXT_ATTR19 = X_TL_EXT_ATTR19,
1325 TL_EXT_ATTR20 = X_TL_EXT_ATTR20,
1326 TL_EXT_ATTR21 = X_TL_EXT_ATTR21,
1327 TL_EXT_ATTR22 = X_TL_EXT_ATTR22,
1328 TL_EXT_ATTR23 = X_TL_EXT_ATTR23,
1329 TL_EXT_ATTR24 = X_TL_EXT_ATTR24,
1330 TL_EXT_ATTR25 = X_TL_EXT_ATTR25,
1331 TL_EXT_ATTR26 = X_TL_EXT_ATTR26,
1332 TL_EXT_ATTR27 = X_TL_EXT_ATTR27,
1333 TL_EXT_ATTR28 = X_TL_EXT_ATTR28,
1334 TL_EXT_ATTR29 = X_TL_EXT_ATTR29,
1335 TL_EXT_ATTR30 = X_TL_EXT_ATTR30,
1336 TL_EXT_ATTR31 = X_TL_EXT_ATTR31,
1337 TL_EXT_ATTR32 = X_TL_EXT_ATTR32,
1338 TL_EXT_ATTR33 = X_TL_EXT_ATTR33,
1339 TL_EXT_ATTR34 = X_TL_EXT_ATTR34,
1340 TL_EXT_ATTR35 = X_TL_EXT_ATTR35,
1341 TL_EXT_ATTR36 = X_TL_EXT_ATTR36,
1342 TL_EXT_ATTR37 = X_TL_EXT_ATTR37,
1343 TL_EXT_ATTR38 = X_TL_EXT_ATTR38,
1344 TL_EXT_ATTR39 = X_TL_EXT_ATTR39,
1345 TL_EXT_ATTR40 = X_TL_EXT_ATTR40,
1346 LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
1347 LAST_UPDATED_BY = X_LAST_UPDATED_BY,
1348 LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
1349 SOURCE_LANG = userenv('LANG')
1350 where EXTENSION_ID = X_EXTENSION_ID
1351 and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
1352
1353 if (sql%notfound) then
1354 raise no_data_found;
1355 end if;
1356 end UPDATE_ROW;
1357
1358 procedure DELETE_ROW (
1359 X_EXTENSION_ID in NUMBER
1360 ) is
1361 begin
1362 delete from RRS_LOCATIONS_EXT_TL
1363 where EXTENSION_ID = X_EXTENSION_ID;
1364
1365 if (sql%notfound) then
1366 raise no_data_found;
1367 end if;
1368
1369 delete from RRS_LOCATIONS_EXT_B
1370 where EXTENSION_ID = X_EXTENSION_ID;
1371
1372 if (sql%notfound) then
1373 raise no_data_found;
1374 end if;
1375 end DELETE_ROW;
1376
1377 procedure ADD_LANGUAGE
1378 is
1379 begin
1380 delete from RRS_LOCATIONS_EXT_TL T
1381 where not exists
1382 (select NULL
1383 from RRS_LOCATIONS_EXT_B B
1384 where B.EXTENSION_ID = T.EXTENSION_ID
1385 );
1386
1387 update RRS_LOCATIONS_EXT_TL T set (
1388 TL_EXT_ATTR1,
1389 TL_EXT_ATTR2,
1390 TL_EXT_ATTR3,
1391 TL_EXT_ATTR4,
1392 TL_EXT_ATTR5,
1393 TL_EXT_ATTR6,
1394 TL_EXT_ATTR7,
1395 TL_EXT_ATTR8,
1396 TL_EXT_ATTR9,
1397 TL_EXT_ATTR10,
1398 TL_EXT_ATTR11,
1399 TL_EXT_ATTR12,
1403 TL_EXT_ATTR16,
1400 TL_EXT_ATTR13,
1401 TL_EXT_ATTR14,
1402 TL_EXT_ATTR15,
1404 TL_EXT_ATTR17,
1405 TL_EXT_ATTR18,
1406 TL_EXT_ATTR19,
1407 TL_EXT_ATTR20,
1408 TL_EXT_ATTR21,
1409 TL_EXT_ATTR22,
1410 TL_EXT_ATTR23,
1411 TL_EXT_ATTR24,
1412 TL_EXT_ATTR25,
1413 TL_EXT_ATTR26,
1414 TL_EXT_ATTR27,
1415 TL_EXT_ATTR28,
1416 TL_EXT_ATTR29,
1417 TL_EXT_ATTR30,
1418 TL_EXT_ATTR31,
1419 TL_EXT_ATTR32,
1420 TL_EXT_ATTR33,
1421 TL_EXT_ATTR34,
1422 TL_EXT_ATTR35,
1423 TL_EXT_ATTR36,
1424 TL_EXT_ATTR37,
1425 TL_EXT_ATTR38,
1426 TL_EXT_ATTR39,
1427 TL_EXT_ATTR40
1428 ) = (select
1429 B.TL_EXT_ATTR1,
1430 B.TL_EXT_ATTR2,
1431 B.TL_EXT_ATTR3,
1432 B.TL_EXT_ATTR4,
1433 B.TL_EXT_ATTR5,
1434 B.TL_EXT_ATTR6,
1435 B.TL_EXT_ATTR7,
1436 B.TL_EXT_ATTR8,
1437 B.TL_EXT_ATTR9,
1438 B.TL_EXT_ATTR10,
1439 B.TL_EXT_ATTR11,
1440 B.TL_EXT_ATTR12,
1441 B.TL_EXT_ATTR13,
1442 B.TL_EXT_ATTR14,
1443 B.TL_EXT_ATTR15,
1444 B.TL_EXT_ATTR16,
1445 B.TL_EXT_ATTR17,
1446 B.TL_EXT_ATTR18,
1447 B.TL_EXT_ATTR19,
1448 B.TL_EXT_ATTR20,
1449 B.TL_EXT_ATTR21,
1450 B.TL_EXT_ATTR22,
1451 B.TL_EXT_ATTR23,
1452 B.TL_EXT_ATTR24,
1453 B.TL_EXT_ATTR25,
1454 B.TL_EXT_ATTR26,
1455 B.TL_EXT_ATTR27,
1456 B.TL_EXT_ATTR28,
1457 B.TL_EXT_ATTR29,
1458 B.TL_EXT_ATTR30,
1459 B.TL_EXT_ATTR31,
1460 B.TL_EXT_ATTR32,
1461 B.TL_EXT_ATTR33,
1462 B.TL_EXT_ATTR34,
1463 B.TL_EXT_ATTR35,
1464 B.TL_EXT_ATTR36,
1465 B.TL_EXT_ATTR37,
1466 B.TL_EXT_ATTR38,
1467 B.TL_EXT_ATTR39,
1468 B.TL_EXT_ATTR40
1469 from RRS_LOCATIONS_EXT_TL B
1470 where B.EXTENSION_ID = T.EXTENSION_ID
1471 and B.LANGUAGE = T.SOURCE_LANG)
1472 where (
1473 T.EXTENSION_ID,
1474 T.LANGUAGE
1475 ) in (select
1476 SUBT.EXTENSION_ID,
1477 SUBT.LANGUAGE
1478 from RRS_LOCATIONS_EXT_TL SUBB, RRS_LOCATIONS_EXT_TL SUBT
1479 where SUBB.EXTENSION_ID = SUBT.EXTENSION_ID
1480 and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1481 and (SUBB.TL_EXT_ATTR1 <> SUBT.TL_EXT_ATTR1
1482 or (SUBB.TL_EXT_ATTR1 is null and SUBT.TL_EXT_ATTR1 is not null)
1483 or (SUBB.TL_EXT_ATTR1 is not null and SUBT.TL_EXT_ATTR1 is null)
1484 or SUBB.TL_EXT_ATTR2 <> SUBT.TL_EXT_ATTR2
1485 or (SUBB.TL_EXT_ATTR2 is null and SUBT.TL_EXT_ATTR2 is not null)
1486 or (SUBB.TL_EXT_ATTR2 is not null and SUBT.TL_EXT_ATTR2 is null)
1487 or SUBB.TL_EXT_ATTR3 <> SUBT.TL_EXT_ATTR3
1488 or (SUBB.TL_EXT_ATTR3 is null and SUBT.TL_EXT_ATTR3 is not null)
1489 or (SUBB.TL_EXT_ATTR3 is not null and SUBT.TL_EXT_ATTR3 is null)
1490 or SUBB.TL_EXT_ATTR4 <> SUBT.TL_EXT_ATTR4
1491 or (SUBB.TL_EXT_ATTR4 is null and SUBT.TL_EXT_ATTR4 is not null)
1492 or (SUBB.TL_EXT_ATTR4 is not null and SUBT.TL_EXT_ATTR4 is null)
1493 or SUBB.TL_EXT_ATTR5 <> SUBT.TL_EXT_ATTR5
1494 or (SUBB.TL_EXT_ATTR5 is null and SUBT.TL_EXT_ATTR5 is not null)
1495 or (SUBB.TL_EXT_ATTR5 is not null and SUBT.TL_EXT_ATTR5 is null)
1496 or SUBB.TL_EXT_ATTR6 <> SUBT.TL_EXT_ATTR6
1497 or (SUBB.TL_EXT_ATTR6 is null and SUBT.TL_EXT_ATTR6 is not null)
1498 or (SUBB.TL_EXT_ATTR6 is not null and SUBT.TL_EXT_ATTR6 is null)
1499 or SUBB.TL_EXT_ATTR7 <> SUBT.TL_EXT_ATTR7
1500 or (SUBB.TL_EXT_ATTR7 is null and SUBT.TL_EXT_ATTR7 is not null)
1501 or (SUBB.TL_EXT_ATTR7 is not null and SUBT.TL_EXT_ATTR7 is null)
1502 or SUBB.TL_EXT_ATTR8 <> SUBT.TL_EXT_ATTR8
1503 or (SUBB.TL_EXT_ATTR8 is null and SUBT.TL_EXT_ATTR8 is not null)
1504 or (SUBB.TL_EXT_ATTR8 is not null and SUBT.TL_EXT_ATTR8 is null)
1505 or SUBB.TL_EXT_ATTR9 <> SUBT.TL_EXT_ATTR9
1506 or (SUBB.TL_EXT_ATTR9 is null and SUBT.TL_EXT_ATTR9 is not null)
1507 or (SUBB.TL_EXT_ATTR9 is not null and SUBT.TL_EXT_ATTR9 is null)
1508 or SUBB.TL_EXT_ATTR10 <> SUBT.TL_EXT_ATTR10
1509 or (SUBB.TL_EXT_ATTR10 is null and SUBT.TL_EXT_ATTR10 is not null)
1510 or (SUBB.TL_EXT_ATTR10 is not null and SUBT.TL_EXT_ATTR10 is null)
1511 or SUBB.TL_EXT_ATTR11 <> SUBT.TL_EXT_ATTR11
1512 or (SUBB.TL_EXT_ATTR11 is null and SUBT.TL_EXT_ATTR11 is not null)
1513 or (SUBB.TL_EXT_ATTR11 is not null and SUBT.TL_EXT_ATTR11 is null)
1514 or SUBB.TL_EXT_ATTR12 <> SUBT.TL_EXT_ATTR12
1515 or (SUBB.TL_EXT_ATTR12 is null and SUBT.TL_EXT_ATTR12 is not null)
1516 or (SUBB.TL_EXT_ATTR12 is not null and SUBT.TL_EXT_ATTR12 is null)
1517 or SUBB.TL_EXT_ATTR13 <> SUBT.TL_EXT_ATTR13
1518 or (SUBB.TL_EXT_ATTR13 is null and SUBT.TL_EXT_ATTR13 is not null)
1519 or (SUBB.TL_EXT_ATTR13 is not null and SUBT.TL_EXT_ATTR13 is null)
1520 or SUBB.TL_EXT_ATTR14 <> SUBT.TL_EXT_ATTR14
1521 or (SUBB.TL_EXT_ATTR14 is null and SUBT.TL_EXT_ATTR14 is not null)
1522 or (SUBB.TL_EXT_ATTR14 is not null and SUBT.TL_EXT_ATTR14 is null)
1523 or SUBB.TL_EXT_ATTR15 <> SUBT.TL_EXT_ATTR15
1524 or (SUBB.TL_EXT_ATTR15 is null and SUBT.TL_EXT_ATTR15 is not null)
1525 or (SUBB.TL_EXT_ATTR15 is not null and SUBT.TL_EXT_ATTR15 is null)
1526 or SUBB.TL_EXT_ATTR16 <> SUBT.TL_EXT_ATTR16
1527 or (SUBB.TL_EXT_ATTR16 is null and SUBT.TL_EXT_ATTR16 is not null)
1528 or (SUBB.TL_EXT_ATTR16 is not null and SUBT.TL_EXT_ATTR16 is null)
1529 or SUBB.TL_EXT_ATTR17 <> SUBT.TL_EXT_ATTR17
1530 or (SUBB.TL_EXT_ATTR17 is null and SUBT.TL_EXT_ATTR17 is not null)
1531 or (SUBB.TL_EXT_ATTR17 is not null and SUBT.TL_EXT_ATTR17 is null)
1532 or SUBB.TL_EXT_ATTR18 <> SUBT.TL_EXT_ATTR18
1533 or (SUBB.TL_EXT_ATTR18 is null and SUBT.TL_EXT_ATTR18 is not null)
1534 or (SUBB.TL_EXT_ATTR18 is not null and SUBT.TL_EXT_ATTR18 is null)
1535 or SUBB.TL_EXT_ATTR19 <> SUBT.TL_EXT_ATTR19
1536 or (SUBB.TL_EXT_ATTR19 is null and SUBT.TL_EXT_ATTR19 is not null)
1537 or (SUBB.TL_EXT_ATTR19 is not null and SUBT.TL_EXT_ATTR19 is null)
1538 or SUBB.TL_EXT_ATTR20 <> SUBT.TL_EXT_ATTR20
1539 or (SUBB.TL_EXT_ATTR20 is null and SUBT.TL_EXT_ATTR20 is not null)
1540 or (SUBB.TL_EXT_ATTR20 is not null and SUBT.TL_EXT_ATTR20 is null)
1541 or SUBB.TL_EXT_ATTR21 <> SUBT.TL_EXT_ATTR21
1542 or (SUBB.TL_EXT_ATTR21 is null and SUBT.TL_EXT_ATTR21 is not null)
1543 or (SUBB.TL_EXT_ATTR21 is not null and SUBT.TL_EXT_ATTR21 is null)
1544 or SUBB.TL_EXT_ATTR22 <> SUBT.TL_EXT_ATTR22
1545 or (SUBB.TL_EXT_ATTR22 is null and SUBT.TL_EXT_ATTR22 is not null)
1546 or (SUBB.TL_EXT_ATTR22 is not null and SUBT.TL_EXT_ATTR22 is null)
1547 or SUBB.TL_EXT_ATTR23 <> SUBT.TL_EXT_ATTR23
1548 or (SUBB.TL_EXT_ATTR23 is null and SUBT.TL_EXT_ATTR23 is not null)
1549 or (SUBB.TL_EXT_ATTR23 is not null and SUBT.TL_EXT_ATTR23 is null)
1550 or SUBB.TL_EXT_ATTR24 <> SUBT.TL_EXT_ATTR24
1551 or (SUBB.TL_EXT_ATTR24 is null and SUBT.TL_EXT_ATTR24 is not null)
1552 or (SUBB.TL_EXT_ATTR24 is not null and SUBT.TL_EXT_ATTR24 is null)
1553 or SUBB.TL_EXT_ATTR25 <> SUBT.TL_EXT_ATTR25
1554 or (SUBB.TL_EXT_ATTR25 is null and SUBT.TL_EXT_ATTR25 is not null)
1555 or (SUBB.TL_EXT_ATTR25 is not null and SUBT.TL_EXT_ATTR25 is null)
1556 or SUBB.TL_EXT_ATTR26 <> SUBT.TL_EXT_ATTR26
1557 or (SUBB.TL_EXT_ATTR26 is null and SUBT.TL_EXT_ATTR26 is not null)
1558 or (SUBB.TL_EXT_ATTR26 is not null and SUBT.TL_EXT_ATTR26 is null)
1562 or SUBB.TL_EXT_ATTR28 <> SUBT.TL_EXT_ATTR28
1559 or SUBB.TL_EXT_ATTR27 <> SUBT.TL_EXT_ATTR27
1560 or (SUBB.TL_EXT_ATTR27 is null and SUBT.TL_EXT_ATTR27 is not null)
1561 or (SUBB.TL_EXT_ATTR27 is not null and SUBT.TL_EXT_ATTR27 is null)
1563 or (SUBB.TL_EXT_ATTR28 is null and SUBT.TL_EXT_ATTR28 is not null)
1564 or (SUBB.TL_EXT_ATTR28 is not null and SUBT.TL_EXT_ATTR28 is null)
1565 or SUBB.TL_EXT_ATTR29 <> SUBT.TL_EXT_ATTR29
1566 or (SUBB.TL_EXT_ATTR29 is null and SUBT.TL_EXT_ATTR29 is not null)
1567 or (SUBB.TL_EXT_ATTR29 is not null and SUBT.TL_EXT_ATTR29 is null)
1568 or SUBB.TL_EXT_ATTR30 <> SUBT.TL_EXT_ATTR30
1569 or (SUBB.TL_EXT_ATTR30 is null and SUBT.TL_EXT_ATTR30 is not null)
1570 or (SUBB.TL_EXT_ATTR30 is not null and SUBT.TL_EXT_ATTR30 is null)
1571 or SUBB.TL_EXT_ATTR31 <> SUBT.TL_EXT_ATTR31
1572 or (SUBB.TL_EXT_ATTR31 is null and SUBT.TL_EXT_ATTR31 is not null)
1573 or (SUBB.TL_EXT_ATTR31 is not null and SUBT.TL_EXT_ATTR31 is null)
1574 or SUBB.TL_EXT_ATTR32 <> SUBT.TL_EXT_ATTR32
1575 or (SUBB.TL_EXT_ATTR32 is null and SUBT.TL_EXT_ATTR32 is not null)
1576 or (SUBB.TL_EXT_ATTR32 is not null and SUBT.TL_EXT_ATTR32 is null)
1577 or SUBB.TL_EXT_ATTR33 <> SUBT.TL_EXT_ATTR33
1578 or (SUBB.TL_EXT_ATTR33 is null and SUBT.TL_EXT_ATTR33 is not null)
1579 or (SUBB.TL_EXT_ATTR33 is not null and SUBT.TL_EXT_ATTR33 is null)
1580 or SUBB.TL_EXT_ATTR34 <> SUBT.TL_EXT_ATTR34
1581 or (SUBB.TL_EXT_ATTR34 is null and SUBT.TL_EXT_ATTR34 is not null)
1582 or (SUBB.TL_EXT_ATTR34 is not null and SUBT.TL_EXT_ATTR34 is null)
1583 or SUBB.TL_EXT_ATTR35 <> SUBT.TL_EXT_ATTR35
1584 or (SUBB.TL_EXT_ATTR35 is null and SUBT.TL_EXT_ATTR35 is not null)
1585 or (SUBB.TL_EXT_ATTR35 is not null and SUBT.TL_EXT_ATTR35 is null)
1586 or SUBB.TL_EXT_ATTR36 <> SUBT.TL_EXT_ATTR36
1587 or (SUBB.TL_EXT_ATTR36 is null and SUBT.TL_EXT_ATTR36 is not null)
1588 or (SUBB.TL_EXT_ATTR36 is not null and SUBT.TL_EXT_ATTR36 is null)
1589 or SUBB.TL_EXT_ATTR37 <> SUBT.TL_EXT_ATTR37
1590 or (SUBB.TL_EXT_ATTR37 is null and SUBT.TL_EXT_ATTR37 is not null)
1591 or (SUBB.TL_EXT_ATTR37 is not null and SUBT.TL_EXT_ATTR37 is null)
1592 or SUBB.TL_EXT_ATTR38 <> SUBT.TL_EXT_ATTR38
1593 or (SUBB.TL_EXT_ATTR38 is null and SUBT.TL_EXT_ATTR38 is not null)
1594 or (SUBB.TL_EXT_ATTR38 is not null and SUBT.TL_EXT_ATTR38 is null)
1595 or SUBB.TL_EXT_ATTR39 <> SUBT.TL_EXT_ATTR39
1596 or (SUBB.TL_EXT_ATTR39 is null and SUBT.TL_EXT_ATTR39 is not null)
1597 or (SUBB.TL_EXT_ATTR39 is not null and SUBT.TL_EXT_ATTR39 is null)
1598 or SUBB.TL_EXT_ATTR40 <> SUBT.TL_EXT_ATTR40
1599 or (SUBB.TL_EXT_ATTR40 is null and SUBT.TL_EXT_ATTR40 is not null)
1600 or (SUBB.TL_EXT_ATTR40 is not null and SUBT.TL_EXT_ATTR40 is null)
1601 ));
1602
1603 insert into RRS_LOCATIONS_EXT_TL (
1604 LAST_UPDATE_DATE,
1605 LAST_UPDATED_BY,
1606 LAST_UPDATE_LOGIN,
1607 CREATED_BY,
1608 CREATION_DATE,
1609 TL_EXT_ATTR1,
1610 TL_EXT_ATTR2,
1611 TL_EXT_ATTR3,
1612 TL_EXT_ATTR4,
1613 TL_EXT_ATTR5,
1614 TL_EXT_ATTR6,
1615 TL_EXT_ATTR7,
1616 TL_EXT_ATTR8,
1617 TL_EXT_ATTR9,
1618 TL_EXT_ATTR10,
1619 TL_EXT_ATTR11,
1620 TL_EXT_ATTR12,
1621 TL_EXT_ATTR13,
1622 TL_EXT_ATTR14,
1623 TL_EXT_ATTR15,
1624 TL_EXT_ATTR16,
1625 TL_EXT_ATTR17,
1626 TL_EXT_ATTR18,
1627 TL_EXT_ATTR19,
1628 TL_EXT_ATTR20,
1629 TL_EXT_ATTR21,
1630 TL_EXT_ATTR22,
1631 TL_EXT_ATTR23,
1632 TL_EXT_ATTR24,
1633 TL_EXT_ATTR25,
1634 TL_EXT_ATTR26,
1635 TL_EXT_ATTR27,
1636 TL_EXT_ATTR28,
1637 TL_EXT_ATTR29,
1638 TL_EXT_ATTR30,
1639 TL_EXT_ATTR31,
1640 TL_EXT_ATTR32,
1641 TL_EXT_ATTR33,
1642 TL_EXT_ATTR34,
1643 TL_EXT_ATTR35,
1644 TL_EXT_ATTR36,
1645 TL_EXT_ATTR37,
1646 TL_EXT_ATTR38,
1647 TL_EXT_ATTR39,
1648 TL_EXT_ATTR40,
1649 EXTENSION_ID,
1650 LOCATION_ID,
1651 COUNTRY,
1652 ATTR_GROUP_ID,
1653 DATA_LEVEL_ID,
1654 LANGUAGE,
1655 SOURCE_LANG
1656 ) select /*+ ORDERED */
1657 B.LAST_UPDATE_DATE,
1658 B.LAST_UPDATED_BY,
1659 B.LAST_UPDATE_LOGIN,
1660 B.CREATED_BY,
1661 B.CREATION_DATE,
1662 B.TL_EXT_ATTR1,
1663 B.TL_EXT_ATTR2,
1664 B.TL_EXT_ATTR3,
1665 B.TL_EXT_ATTR4,
1666 B.TL_EXT_ATTR5,
1667 B.TL_EXT_ATTR6,
1668 B.TL_EXT_ATTR7,
1669 B.TL_EXT_ATTR8,
1670 B.TL_EXT_ATTR9,
1671 B.TL_EXT_ATTR10,
1672 B.TL_EXT_ATTR11,
1673 B.TL_EXT_ATTR12,
1674 B.TL_EXT_ATTR13,
1675 B.TL_EXT_ATTR14,
1676 B.TL_EXT_ATTR15,
1677 B.TL_EXT_ATTR16,
1678 B.TL_EXT_ATTR17,
1679 B.TL_EXT_ATTR18,
1680 B.TL_EXT_ATTR19,
1681 B.TL_EXT_ATTR20,
1682 B.TL_EXT_ATTR21,
1683 B.TL_EXT_ATTR22,
1684 B.TL_EXT_ATTR23,
1685 B.TL_EXT_ATTR24,
1686 B.TL_EXT_ATTR25,
1687 B.TL_EXT_ATTR26,
1688 B.TL_EXT_ATTR27,
1689 B.TL_EXT_ATTR28,
1690 B.TL_EXT_ATTR29,
1691 B.TL_EXT_ATTR30,
1692 B.TL_EXT_ATTR31,
1693 B.TL_EXT_ATTR32,
1694 B.TL_EXT_ATTR33,
1695 B.TL_EXT_ATTR34,
1696 B.TL_EXT_ATTR35,
1697 B.TL_EXT_ATTR36,
1698 B.TL_EXT_ATTR37,
1699 B.TL_EXT_ATTR38,
1700 B.TL_EXT_ATTR39,
1701 B.TL_EXT_ATTR40,
1702 B.EXTENSION_ID,
1703 B.LOCATION_ID,
1704 B.COUNTRY,
1705 B.ATTR_GROUP_ID,
1706 B.DATA_LEVEL_ID,
1707 L.LANGUAGE_CODE,
1708 B.SOURCE_LANG
1709 from RRS_LOCATIONS_EXT_TL B, FND_LANGUAGES L
1710 where L.INSTALLED_FLAG in ('I', 'B')
1711 and B.LANGUAGE = userenv('LANG')
1715 where T.EXTENSION_ID = B.EXTENSION_ID
1712 and not exists
1713 (select NULL
1714 from RRS_LOCATIONS_EXT_TL T
1716 and T.LANGUAGE = L.LANGUAGE_CODE);
1717 end ADD_LANGUAGE;
1718
1719 end RRS_LOCATIONS_EXT_PKG;