1 package body RRS_SITES_EXT_PKG as
2 /* $Header: RRSSEXTB.pls 120.2.12010000.2 2009/01/05 18:11:55 sunarang ship $ */
3 procedure INSERT_ROW (
4 X_ROWID in out nocopy VARCHAR2,
5 X_EXTENSION_ID in NUMBER,
6 X_N_EXT_ATTR17 in NUMBER,
7 X_N_EXT_ATTR18 in NUMBER,
8 X_N_EXT_ATTR19 in NUMBER,
9 X_N_EXT_ATTR20 in NUMBER,
10 X_UOM_EXT_ATTR1 in VARCHAR2,
11 X_UOM_EXT_ATTR2 in VARCHAR2,
12 X_UOM_EXT_ATTR3 in VARCHAR2,
13 X_UOM_EXT_ATTR4 in VARCHAR2,
14 X_UOM_EXT_ATTR5 in VARCHAR2,
15 X_UOM_EXT_ATTR6 in VARCHAR2,
16 X_UOM_EXT_ATTR7 in VARCHAR2,
17 X_UOM_EXT_ATTR8 in VARCHAR2,
18 X_UOM_EXT_ATTR9 in VARCHAR2,
19 X_UOM_EXT_ATTR10 in VARCHAR2,
20 X_UOM_EXT_ATTR11 in VARCHAR2,
21 X_UOM_EXT_ATTR12 in VARCHAR2,
22 X_UOM_EXT_ATTR13 in VARCHAR2,
23 X_UOM_EXT_ATTR14 in VARCHAR2,
24 X_UOM_EXT_ATTR15 in VARCHAR2,
25 X_UOM_EXT_ATTR16 in VARCHAR2,
26 X_UOM_EXT_ATTR17 in VARCHAR2,
27 X_UOM_EXT_ATTR18 in VARCHAR2,
28 X_UOM_EXT_ATTR19 in VARCHAR2,
29 X_UOM_EXT_ATTR20 in VARCHAR2,
30 X_D_EXT_ATTR6 in DATE,
31 X_D_EXT_ATTR7 in DATE,
32 X_D_EXT_ATTR8 in DATE,
33 X_D_EXT_ATTR9 in DATE,
34 X_D_EXT_ATTR10 in DATE,
35 X_REQUEST_ID in NUMBER,
36 X_SITE_ID in NUMBER,
37 X_SITE_USE_TYPE_CODE in VARCHAR2,
38 X_ATTR_GROUP_ID in NUMBER,
39 X_C_EXT_ATTR1 in VARCHAR2,
40 X_C_EXT_ATTR2 in VARCHAR2,
41 X_C_EXT_ATTR3 in VARCHAR2,
42 X_C_EXT_ATTR4 in VARCHAR2,
43 X_C_EXT_ATTR5 in VARCHAR2,
44 X_C_EXT_ATTR6 in VARCHAR2,
45 X_C_EXT_ATTR7 in VARCHAR2,
46 X_C_EXT_ATTR8 in VARCHAR2,
47 X_C_EXT_ATTR9 in VARCHAR2,
48 X_C_EXT_ATTR10 in VARCHAR2,
49 X_C_EXT_ATTR11 in VARCHAR2,
50 X_C_EXT_ATTR12 in VARCHAR2,
51 X_C_EXT_ATTR13 in VARCHAR2,
52 X_C_EXT_ATTR14 in VARCHAR2,
53 X_C_EXT_ATTR15 in VARCHAR2,
54 X_C_EXT_ATTR16 in VARCHAR2,
55 X_C_EXT_ATTR17 in VARCHAR2,
56 X_C_EXT_ATTR18 in VARCHAR2,
57 X_C_EXT_ATTR19 in VARCHAR2,
58 X_C_EXT_ATTR20 in VARCHAR2,
59 X_N_EXT_ATTR1 in NUMBER,
60 X_N_EXT_ATTR2 in NUMBER,
61 X_N_EXT_ATTR3 in NUMBER,
62 X_N_EXT_ATTR4 in NUMBER,
63 X_N_EXT_ATTR5 in NUMBER,
64 X_N_EXT_ATTR6 in NUMBER,
65 X_N_EXT_ATTR7 in NUMBER,
66 X_N_EXT_ATTR8 in NUMBER,
67 X_N_EXT_ATTR9 in NUMBER,
68 X_N_EXT_ATTR10 in NUMBER,
69 X_D_EXT_ATTR1 in DATE,
70 X_D_EXT_ATTR2 in DATE,
71 X_D_EXT_ATTR3 in DATE,
72 X_D_EXT_ATTR4 in DATE,
73 X_D_EXT_ATTR5 in DATE,
74 X_C_EXT_ATTR21 in VARCHAR2,
75 X_C_EXT_ATTR22 in VARCHAR2,
76 X_C_EXT_ATTR23 in VARCHAR2,
77 X_C_EXT_ATTR24 in VARCHAR2,
78 X_C_EXT_ATTR25 in VARCHAR2,
79 X_C_EXT_ATTR26 in VARCHAR2,
80 X_C_EXT_ATTR27 in VARCHAR2,
81 X_C_EXT_ATTR28 in VARCHAR2,
82 X_C_EXT_ATTR29 in VARCHAR2,
83 X_C_EXT_ATTR30 in VARCHAR2,
84 X_C_EXT_ATTR31 in VARCHAR2,
85 X_C_EXT_ATTR32 in VARCHAR2,
86 X_C_EXT_ATTR33 in VARCHAR2,
87 X_C_EXT_ATTR34 in VARCHAR2,
88 X_C_EXT_ATTR35 in VARCHAR2,
89 X_C_EXT_ATTR36 in VARCHAR2,
90 X_C_EXT_ATTR37 in VARCHAR2,
91 X_C_EXT_ATTR38 in VARCHAR2,
92 X_C_EXT_ATTR39 in VARCHAR2,
93 X_C_EXT_ATTR40 in VARCHAR2,
94 X_N_EXT_ATTR11 in NUMBER,
95 X_N_EXT_ATTR12 in NUMBER,
96 X_N_EXT_ATTR13 in NUMBER,
97 X_N_EXT_ATTR14 in NUMBER,
98 X_N_EXT_ATTR15 in NUMBER,
99 X_N_EXT_ATTR16 in NUMBER,
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_SITES_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_SITES_EXT_B (
158 EXTENSION_ID,
159 SITE_ID,
160 SITE_USE_TYPE_CODE,
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_SITE_ID,
261 X_SITE_USE_TYPE_CODE,
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_SITES_EXT_TL (
362 EXTENSION_ID,
363 SITE_ID,
364 SITE_USE_TYPE_CODE,
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_SITE_ID,
416 X_SITE_USE_TYPE_CODE,
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_SITES_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_N_EXT_ATTR17 in NUMBER,
486 X_N_EXT_ATTR18 in NUMBER,
487 X_N_EXT_ATTR19 in NUMBER,
488 X_N_EXT_ATTR20 in NUMBER,
489 X_UOM_EXT_ATTR1 in VARCHAR2,
490 X_UOM_EXT_ATTR2 in VARCHAR2,
491 X_UOM_EXT_ATTR3 in VARCHAR2,
492 X_UOM_EXT_ATTR4 in VARCHAR2,
493 X_UOM_EXT_ATTR5 in VARCHAR2,
494 X_UOM_EXT_ATTR6 in VARCHAR2,
495 X_UOM_EXT_ATTR7 in VARCHAR2,
496 X_UOM_EXT_ATTR8 in VARCHAR2,
497 X_UOM_EXT_ATTR9 in VARCHAR2,
498 X_UOM_EXT_ATTR10 in VARCHAR2,
499 X_UOM_EXT_ATTR11 in VARCHAR2,
500 X_UOM_EXT_ATTR12 in VARCHAR2,
501 X_UOM_EXT_ATTR13 in VARCHAR2,
502 X_UOM_EXT_ATTR14 in VARCHAR2,
503 X_UOM_EXT_ATTR15 in VARCHAR2,
504 X_UOM_EXT_ATTR16 in VARCHAR2,
505 X_UOM_EXT_ATTR17 in VARCHAR2,
506 X_UOM_EXT_ATTR18 in VARCHAR2,
507 X_UOM_EXT_ATTR19 in VARCHAR2,
508 X_UOM_EXT_ATTR20 in VARCHAR2,
509 X_D_EXT_ATTR6 in DATE,
510 X_D_EXT_ATTR7 in DATE,
511 X_D_EXT_ATTR8 in DATE,
512 X_D_EXT_ATTR9 in DATE,
513 X_D_EXT_ATTR10 in DATE,
514 X_REQUEST_ID in NUMBER,
515 X_SITE_ID in NUMBER,
516 X_SITE_USE_TYPE_CODE in VARCHAR2,
517 X_ATTR_GROUP_ID in NUMBER,
518 X_C_EXT_ATTR1 in VARCHAR2,
519 X_C_EXT_ATTR2 in VARCHAR2,
520 X_C_EXT_ATTR3 in VARCHAR2,
521 X_C_EXT_ATTR4 in VARCHAR2,
522 X_C_EXT_ATTR5 in VARCHAR2,
523 X_C_EXT_ATTR6 in VARCHAR2,
524 X_C_EXT_ATTR7 in VARCHAR2,
525 X_C_EXT_ATTR8 in VARCHAR2,
526 X_C_EXT_ATTR9 in VARCHAR2,
527 X_C_EXT_ATTR10 in VARCHAR2,
528 X_C_EXT_ATTR11 in VARCHAR2,
529 X_C_EXT_ATTR12 in VARCHAR2,
530 X_C_EXT_ATTR13 in VARCHAR2,
531 X_C_EXT_ATTR14 in VARCHAR2,
535 X_C_EXT_ATTR18 in VARCHAR2,
532 X_C_EXT_ATTR15 in VARCHAR2,
533 X_C_EXT_ATTR16 in VARCHAR2,
534 X_C_EXT_ATTR17 in VARCHAR2,
536 X_C_EXT_ATTR19 in VARCHAR2,
537 X_C_EXT_ATTR20 in VARCHAR2,
538 X_N_EXT_ATTR1 in NUMBER,
539 X_N_EXT_ATTR2 in NUMBER,
540 X_N_EXT_ATTR3 in NUMBER,
541 X_N_EXT_ATTR4 in NUMBER,
542 X_N_EXT_ATTR5 in NUMBER,
543 X_N_EXT_ATTR6 in NUMBER,
544 X_N_EXT_ATTR7 in NUMBER,
545 X_N_EXT_ATTR8 in NUMBER,
546 X_N_EXT_ATTR9 in NUMBER,
547 X_N_EXT_ATTR10 in NUMBER,
548 X_D_EXT_ATTR1 in DATE,
549 X_D_EXT_ATTR2 in DATE,
550 X_D_EXT_ATTR3 in DATE,
551 X_D_EXT_ATTR4 in DATE,
552 X_D_EXT_ATTR5 in DATE,
553 X_C_EXT_ATTR21 in VARCHAR2,
554 X_C_EXT_ATTR22 in VARCHAR2,
555 X_C_EXT_ATTR23 in VARCHAR2,
556 X_C_EXT_ATTR24 in VARCHAR2,
557 X_C_EXT_ATTR25 in VARCHAR2,
558 X_C_EXT_ATTR26 in VARCHAR2,
559 X_C_EXT_ATTR27 in VARCHAR2,
560 X_C_EXT_ATTR28 in VARCHAR2,
561 X_C_EXT_ATTR29 in VARCHAR2,
562 X_C_EXT_ATTR30 in VARCHAR2,
563 X_C_EXT_ATTR31 in VARCHAR2,
564 X_C_EXT_ATTR32 in VARCHAR2,
565 X_C_EXT_ATTR33 in VARCHAR2,
566 X_C_EXT_ATTR34 in VARCHAR2,
567 X_C_EXT_ATTR35 in VARCHAR2,
568 X_C_EXT_ATTR36 in VARCHAR2,
569 X_C_EXT_ATTR37 in VARCHAR2,
570 X_C_EXT_ATTR38 in VARCHAR2,
571 X_C_EXT_ATTR39 in VARCHAR2,
572 X_C_EXT_ATTR40 in VARCHAR2,
573 X_N_EXT_ATTR11 in NUMBER,
574 X_N_EXT_ATTR12 in NUMBER,
575 X_N_EXT_ATTR13 in NUMBER,
576 X_N_EXT_ATTR14 in NUMBER,
577 X_N_EXT_ATTR15 in NUMBER,
578 X_N_EXT_ATTR16 in NUMBER,
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 N_EXT_ATTR17,
622 N_EXT_ATTR18,
623 N_EXT_ATTR19,
624 N_EXT_ATTR20,
625 UOM_EXT_ATTR1,
626 UOM_EXT_ATTR2,
627 UOM_EXT_ATTR3,
628 UOM_EXT_ATTR4,
629 UOM_EXT_ATTR5,
630 UOM_EXT_ATTR6,
631 UOM_EXT_ATTR7,
632 UOM_EXT_ATTR8,
633 UOM_EXT_ATTR9,
634 UOM_EXT_ATTR10,
635 UOM_EXT_ATTR11,
636 UOM_EXT_ATTR12,
637 UOM_EXT_ATTR13,
638 UOM_EXT_ATTR14,
639 UOM_EXT_ATTR15,
640 UOM_EXT_ATTR16,
641 UOM_EXT_ATTR17,
642 UOM_EXT_ATTR18,
643 UOM_EXT_ATTR19,
644 UOM_EXT_ATTR20,
645 D_EXT_ATTR6,
646 D_EXT_ATTR7,
647 D_EXT_ATTR8,
648 D_EXT_ATTR9,
649 D_EXT_ATTR10,
650 REQUEST_ID,
651 SITE_ID,
652 SITE_USE_TYPE_CODE,
653 ATTR_GROUP_ID,
654 C_EXT_ATTR1,
655 C_EXT_ATTR2,
656 C_EXT_ATTR3,
657 C_EXT_ATTR4,
658 C_EXT_ATTR5,
659 C_EXT_ATTR6,
660 C_EXT_ATTR7,
661 C_EXT_ATTR8,
662 C_EXT_ATTR9,
663 C_EXT_ATTR10,
664 C_EXT_ATTR11,
665 C_EXT_ATTR12,
666 C_EXT_ATTR13,
667 C_EXT_ATTR14,
668 C_EXT_ATTR15,
669 C_EXT_ATTR16,
670 C_EXT_ATTR17,
671 C_EXT_ATTR18,
672 C_EXT_ATTR19,
673 C_EXT_ATTR20,
674 N_EXT_ATTR1,
675 N_EXT_ATTR2,
676 N_EXT_ATTR3,
677 N_EXT_ATTR4,
678 N_EXT_ATTR5,
679 N_EXT_ATTR6,
680 N_EXT_ATTR7,
681 N_EXT_ATTR8,
682 N_EXT_ATTR9,
683 N_EXT_ATTR10,
684 D_EXT_ATTR1,
685 D_EXT_ATTR2,
686 D_EXT_ATTR3,
687 D_EXT_ATTR4,
688 D_EXT_ATTR5,
689 C_EXT_ATTR21,
690 C_EXT_ATTR22,
691 C_EXT_ATTR23,
692 C_EXT_ATTR24,
693 C_EXT_ATTR25,
694 C_EXT_ATTR26,
695 C_EXT_ATTR27,
696 C_EXT_ATTR28,
697 C_EXT_ATTR29,
701 C_EXT_ATTR33,
698 C_EXT_ATTR30,
699 C_EXT_ATTR31,
700 C_EXT_ATTR32,
702 C_EXT_ATTR34,
703 C_EXT_ATTR35,
704 C_EXT_ATTR36,
705 C_EXT_ATTR37,
706 C_EXT_ATTR38,
707 C_EXT_ATTR39,
708 C_EXT_ATTR40,
709 N_EXT_ATTR11,
710 N_EXT_ATTR12,
711 N_EXT_ATTR13,
712 N_EXT_ATTR14,
713 N_EXT_ATTR15,
714 N_EXT_ATTR16
715 from RRS_SITES_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_SITES_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.N_EXT_ATTR17 = X_N_EXT_ATTR17)
776 OR ((recinfo.N_EXT_ATTR17 is null) AND (X_N_EXT_ATTR17 is null)))
777 AND ((recinfo.N_EXT_ATTR18 = X_N_EXT_ATTR18)
778 OR ((recinfo.N_EXT_ATTR18 is null) AND (X_N_EXT_ATTR18 is null)))
779 AND ((recinfo.N_EXT_ATTR19 = X_N_EXT_ATTR19)
780 OR ((recinfo.N_EXT_ATTR19 is null) AND (X_N_EXT_ATTR19 is null)))
781 AND ((recinfo.N_EXT_ATTR20 = X_N_EXT_ATTR20)
782 OR ((recinfo.N_EXT_ATTR20 is null) AND (X_N_EXT_ATTR20 is null)))
783 AND ((recinfo.UOM_EXT_ATTR1 = X_UOM_EXT_ATTR1)
784 OR ((recinfo.UOM_EXT_ATTR1 is null) AND (X_UOM_EXT_ATTR1 is null)))
785 AND ((recinfo.UOM_EXT_ATTR2 = X_UOM_EXT_ATTR2)
786 OR ((recinfo.UOM_EXT_ATTR2 is null) AND (X_UOM_EXT_ATTR2 is null)))
787 AND ((recinfo.UOM_EXT_ATTR3 = X_UOM_EXT_ATTR3)
788 OR ((recinfo.UOM_EXT_ATTR3 is null) AND (X_UOM_EXT_ATTR3 is null)))
789 AND ((recinfo.UOM_EXT_ATTR4 = X_UOM_EXT_ATTR4)
790 OR ((recinfo.UOM_EXT_ATTR4 is null) AND (X_UOM_EXT_ATTR4 is null)))
791 AND ((recinfo.UOM_EXT_ATTR5 = X_UOM_EXT_ATTR5)
792 OR ((recinfo.UOM_EXT_ATTR5 is null) AND (X_UOM_EXT_ATTR5 is null)))
793 AND ((recinfo.UOM_EXT_ATTR6 = X_UOM_EXT_ATTR6)
794 OR ((recinfo.UOM_EXT_ATTR6 is null) AND (X_UOM_EXT_ATTR6 is null)))
795 AND ((recinfo.UOM_EXT_ATTR7 = X_UOM_EXT_ATTR7)
796 OR ((recinfo.UOM_EXT_ATTR7 is null) AND (X_UOM_EXT_ATTR7 is null)))
797 AND ((recinfo.UOM_EXT_ATTR8 = X_UOM_EXT_ATTR8)
798 OR ((recinfo.UOM_EXT_ATTR8 is null) AND (X_UOM_EXT_ATTR8 is null)))
799 AND ((recinfo.UOM_EXT_ATTR9 = X_UOM_EXT_ATTR9)
800 OR ((recinfo.UOM_EXT_ATTR9 is null) AND (X_UOM_EXT_ATTR9 is null)))
801 AND ((recinfo.UOM_EXT_ATTR10 = X_UOM_EXT_ATTR10)
802 OR ((recinfo.UOM_EXT_ATTR10 is null) AND (X_UOM_EXT_ATTR10 is null)))
803 AND ((recinfo.UOM_EXT_ATTR11 = X_UOM_EXT_ATTR11)
804 OR ((recinfo.UOM_EXT_ATTR11 is null) AND (X_UOM_EXT_ATTR11 is null)))
805 AND ((recinfo.UOM_EXT_ATTR12 = X_UOM_EXT_ATTR12)
806 OR ((recinfo.UOM_EXT_ATTR12 is null) AND (X_UOM_EXT_ATTR12 is null)))
807 AND ((recinfo.UOM_EXT_ATTR13 = X_UOM_EXT_ATTR13)
808 OR ((recinfo.UOM_EXT_ATTR13 is null) AND (X_UOM_EXT_ATTR13 is null)))
809 AND ((recinfo.UOM_EXT_ATTR14 = X_UOM_EXT_ATTR14)
810 OR ((recinfo.UOM_EXT_ATTR14 is null) AND (X_UOM_EXT_ATTR14 is null)))
811 AND ((recinfo.UOM_EXT_ATTR15 = X_UOM_EXT_ATTR15)
812 OR ((recinfo.UOM_EXT_ATTR15 is null) AND (X_UOM_EXT_ATTR15 is null)))
813 AND ((recinfo.UOM_EXT_ATTR16 = X_UOM_EXT_ATTR16)
814 OR ((recinfo.UOM_EXT_ATTR16 is null) AND (X_UOM_EXT_ATTR16 is null)))
815 AND ((recinfo.UOM_EXT_ATTR17 = X_UOM_EXT_ATTR17)
816 OR ((recinfo.UOM_EXT_ATTR17 is null) AND (X_UOM_EXT_ATTR17 is null)))
817 AND ((recinfo.UOM_EXT_ATTR18 = X_UOM_EXT_ATTR18)
818 OR ((recinfo.UOM_EXT_ATTR18 is null) AND (X_UOM_EXT_ATTR18 is null)))
819 AND ((recinfo.UOM_EXT_ATTR19 = X_UOM_EXT_ATTR19)
820 OR ((recinfo.UOM_EXT_ATTR19 is null) AND (X_UOM_EXT_ATTR19 is null)))
821 AND ((recinfo.UOM_EXT_ATTR20 = X_UOM_EXT_ATTR20)
822 OR ((recinfo.UOM_EXT_ATTR20 is null) AND (X_UOM_EXT_ATTR20 is null)))
823 AND ((recinfo.D_EXT_ATTR6 = X_D_EXT_ATTR6)
827 AND ((recinfo.D_EXT_ATTR8 = X_D_EXT_ATTR8)
824 OR ((recinfo.D_EXT_ATTR6 is null) AND (X_D_EXT_ATTR6 is null)))
825 AND ((recinfo.D_EXT_ATTR7 = X_D_EXT_ATTR7)
826 OR ((recinfo.D_EXT_ATTR7 is null) AND (X_D_EXT_ATTR7 is null)))
828 OR ((recinfo.D_EXT_ATTR8 is null) AND (X_D_EXT_ATTR8 is null)))
829 AND ((recinfo.D_EXT_ATTR9 = X_D_EXT_ATTR9)
830 OR ((recinfo.D_EXT_ATTR9 is null) AND (X_D_EXT_ATTR9 is null)))
831 AND ((recinfo.D_EXT_ATTR10 = X_D_EXT_ATTR10)
832 OR ((recinfo.D_EXT_ATTR10 is null) AND (X_D_EXT_ATTR10 is null)))
833 AND ((recinfo.REQUEST_ID = X_REQUEST_ID)
834 OR ((recinfo.REQUEST_ID is null) AND (X_REQUEST_ID is null)))
835 AND (recinfo.SITE_ID = X_SITE_ID)
836 AND (recinfo.SITE_USE_TYPE_CODE = X_SITE_USE_TYPE_CODE)
837 AND (recinfo.ATTR_GROUP_ID = X_ATTR_GROUP_ID)
838 AND ((recinfo.C_EXT_ATTR1 = X_C_EXT_ATTR1)
839 OR ((recinfo.C_EXT_ATTR1 is null) AND (X_C_EXT_ATTR1 is null)))
840 AND ((recinfo.C_EXT_ATTR2 = X_C_EXT_ATTR2)
841 OR ((recinfo.C_EXT_ATTR2 is null) AND (X_C_EXT_ATTR2 is null)))
842 AND ((recinfo.C_EXT_ATTR3 = X_C_EXT_ATTR3)
843 OR ((recinfo.C_EXT_ATTR3 is null) AND (X_C_EXT_ATTR3 is null)))
844 AND ((recinfo.C_EXT_ATTR4 = X_C_EXT_ATTR4)
845 OR ((recinfo.C_EXT_ATTR4 is null) AND (X_C_EXT_ATTR4 is null)))
846 AND ((recinfo.C_EXT_ATTR5 = X_C_EXT_ATTR5)
847 OR ((recinfo.C_EXT_ATTR5 is null) AND (X_C_EXT_ATTR5 is null)))
848 AND ((recinfo.C_EXT_ATTR6 = X_C_EXT_ATTR6)
849 OR ((recinfo.C_EXT_ATTR6 is null) AND (X_C_EXT_ATTR6 is null)))
850 AND ((recinfo.C_EXT_ATTR7 = X_C_EXT_ATTR7)
851 OR ((recinfo.C_EXT_ATTR7 is null) AND (X_C_EXT_ATTR7 is null)))
852 AND ((recinfo.C_EXT_ATTR8 = X_C_EXT_ATTR8)
853 OR ((recinfo.C_EXT_ATTR8 is null) AND (X_C_EXT_ATTR8 is null)))
854 AND ((recinfo.C_EXT_ATTR9 = X_C_EXT_ATTR9)
855 OR ((recinfo.C_EXT_ATTR9 is null) AND (X_C_EXT_ATTR9 is null)))
856 AND ((recinfo.C_EXT_ATTR10 = X_C_EXT_ATTR10)
857 OR ((recinfo.C_EXT_ATTR10 is null) AND (X_C_EXT_ATTR10 is null)))
858 AND ((recinfo.C_EXT_ATTR11 = X_C_EXT_ATTR11)
859 OR ((recinfo.C_EXT_ATTR11 is null) AND (X_C_EXT_ATTR11 is null)))
860 AND ((recinfo.C_EXT_ATTR12 = X_C_EXT_ATTR12)
861 OR ((recinfo.C_EXT_ATTR12 is null) AND (X_C_EXT_ATTR12 is null)))
862 AND ((recinfo.C_EXT_ATTR13 = X_C_EXT_ATTR13)
863 OR ((recinfo.C_EXT_ATTR13 is null) AND (X_C_EXT_ATTR13 is null)))
864 AND ((recinfo.C_EXT_ATTR14 = X_C_EXT_ATTR14)
865 OR ((recinfo.C_EXT_ATTR14 is null) AND (X_C_EXT_ATTR14 is null)))
866 AND ((recinfo.C_EXT_ATTR15 = X_C_EXT_ATTR15)
867 OR ((recinfo.C_EXT_ATTR15 is null) AND (X_C_EXT_ATTR15 is null)))
868 AND ((recinfo.C_EXT_ATTR16 = X_C_EXT_ATTR16)
869 OR ((recinfo.C_EXT_ATTR16 is null) AND (X_C_EXT_ATTR16 is null)))
870 AND ((recinfo.C_EXT_ATTR17 = X_C_EXT_ATTR17)
871 OR ((recinfo.C_EXT_ATTR17 is null) AND (X_C_EXT_ATTR17 is null)))
872 AND ((recinfo.C_EXT_ATTR18 = X_C_EXT_ATTR18)
873 OR ((recinfo.C_EXT_ATTR18 is null) AND (X_C_EXT_ATTR18 is null)))
874 AND ((recinfo.C_EXT_ATTR19 = X_C_EXT_ATTR19)
875 OR ((recinfo.C_EXT_ATTR19 is null) AND (X_C_EXT_ATTR19 is null)))
876 AND ((recinfo.C_EXT_ATTR20 = X_C_EXT_ATTR20)
877 OR ((recinfo.C_EXT_ATTR20 is null) AND (X_C_EXT_ATTR20 is null)))
878 AND ((recinfo.N_EXT_ATTR1 = X_N_EXT_ATTR1)
879 OR ((recinfo.N_EXT_ATTR1 is null) AND (X_N_EXT_ATTR1 is null)))
880 AND ((recinfo.N_EXT_ATTR2 = X_N_EXT_ATTR2)
881 OR ((recinfo.N_EXT_ATTR2 is null) AND (X_N_EXT_ATTR2 is null)))
882 AND ((recinfo.N_EXT_ATTR3 = X_N_EXT_ATTR3)
883 OR ((recinfo.N_EXT_ATTR3 is null) AND (X_N_EXT_ATTR3 is null)))
884 AND ((recinfo.N_EXT_ATTR4 = X_N_EXT_ATTR4)
885 OR ((recinfo.N_EXT_ATTR4 is null) AND (X_N_EXT_ATTR4 is null)))
886 AND ((recinfo.N_EXT_ATTR5 = X_N_EXT_ATTR5)
887 OR ((recinfo.N_EXT_ATTR5 is null) AND (X_N_EXT_ATTR5 is null)))
888 AND ((recinfo.N_EXT_ATTR6 = X_N_EXT_ATTR6)
889 OR ((recinfo.N_EXT_ATTR6 is null) AND (X_N_EXT_ATTR6 is null)))
890 AND ((recinfo.N_EXT_ATTR7 = X_N_EXT_ATTR7)
891 OR ((recinfo.N_EXT_ATTR7 is null) AND (X_N_EXT_ATTR7 is null)))
892 AND ((recinfo.N_EXT_ATTR8 = X_N_EXT_ATTR8)
893 OR ((recinfo.N_EXT_ATTR8 is null) AND (X_N_EXT_ATTR8 is null)))
894 AND ((recinfo.N_EXT_ATTR9 = X_N_EXT_ATTR9)
895 OR ((recinfo.N_EXT_ATTR9 is null) AND (X_N_EXT_ATTR9 is null)))
896 AND ((recinfo.N_EXT_ATTR10 = X_N_EXT_ATTR10)
897 OR ((recinfo.N_EXT_ATTR10 is null) AND (X_N_EXT_ATTR10 is null)))
898 AND ((recinfo.D_EXT_ATTR1 = X_D_EXT_ATTR1)
899 OR ((recinfo.D_EXT_ATTR1 is null) AND (X_D_EXT_ATTR1 is null)))
900 AND ((recinfo.D_EXT_ATTR2 = X_D_EXT_ATTR2)
901 OR ((recinfo.D_EXT_ATTR2 is null) AND (X_D_EXT_ATTR2 is null)))
902 AND ((recinfo.D_EXT_ATTR3 = X_D_EXT_ATTR3)
903 OR ((recinfo.D_EXT_ATTR3 is null) AND (X_D_EXT_ATTR3 is null)))
904 AND ((recinfo.D_EXT_ATTR4 = X_D_EXT_ATTR4)
905 OR ((recinfo.D_EXT_ATTR4 is null) AND (X_D_EXT_ATTR4 is null)))
906 AND ((recinfo.D_EXT_ATTR5 = X_D_EXT_ATTR5)
907 OR ((recinfo.D_EXT_ATTR5 is null) AND (X_D_EXT_ATTR5 is null)))
908 AND ((recinfo.C_EXT_ATTR21 = X_C_EXT_ATTR21)
909 OR ((recinfo.C_EXT_ATTR21 is null) AND (X_C_EXT_ATTR21 is null)))
910 AND ((recinfo.C_EXT_ATTR22 = X_C_EXT_ATTR22)
911 OR ((recinfo.C_EXT_ATTR22 is null) AND (X_C_EXT_ATTR22 is null)))
912 AND ((recinfo.C_EXT_ATTR23 = X_C_EXT_ATTR23)
916 AND ((recinfo.C_EXT_ATTR25 = X_C_EXT_ATTR25)
913 OR ((recinfo.C_EXT_ATTR23 is null) AND (X_C_EXT_ATTR23 is null)))
914 AND ((recinfo.C_EXT_ATTR24 = X_C_EXT_ATTR24)
915 OR ((recinfo.C_EXT_ATTR24 is null) AND (X_C_EXT_ATTR24 is null)))
917 OR ((recinfo.C_EXT_ATTR25 is null) AND (X_C_EXT_ATTR25 is null)))
918 AND ((recinfo.C_EXT_ATTR26 = X_C_EXT_ATTR26)
919 OR ((recinfo.C_EXT_ATTR26 is null) AND (X_C_EXT_ATTR26 is null)))
920 AND ((recinfo.C_EXT_ATTR27 = X_C_EXT_ATTR27)
921 OR ((recinfo.C_EXT_ATTR27 is null) AND (X_C_EXT_ATTR27 is null)))
922 AND ((recinfo.C_EXT_ATTR28 = X_C_EXT_ATTR28)
923 OR ((recinfo.C_EXT_ATTR28 is null) AND (X_C_EXT_ATTR28 is null)))
924 AND ((recinfo.C_EXT_ATTR29 = X_C_EXT_ATTR29)
925 OR ((recinfo.C_EXT_ATTR29 is null) AND (X_C_EXT_ATTR29 is null)))
926 AND ((recinfo.C_EXT_ATTR30 = X_C_EXT_ATTR30)
927 OR ((recinfo.C_EXT_ATTR30 is null) AND (X_C_EXT_ATTR30 is null)))
928 AND ((recinfo.C_EXT_ATTR31 = X_C_EXT_ATTR31)
929 OR ((recinfo.C_EXT_ATTR31 is null) AND (X_C_EXT_ATTR31 is null)))
930 AND ((recinfo.C_EXT_ATTR32 = X_C_EXT_ATTR32)
931 OR ((recinfo.C_EXT_ATTR32 is null) AND (X_C_EXT_ATTR32 is null)))
932 AND ((recinfo.C_EXT_ATTR33 = X_C_EXT_ATTR33)
933 OR ((recinfo.C_EXT_ATTR33 is null) AND (X_C_EXT_ATTR33 is null)))
934 AND ((recinfo.C_EXT_ATTR34 = X_C_EXT_ATTR34)
935 OR ((recinfo.C_EXT_ATTR34 is null) AND (X_C_EXT_ATTR34 is null)))
936 AND ((recinfo.C_EXT_ATTR35 = X_C_EXT_ATTR35)
937 OR ((recinfo.C_EXT_ATTR35 is null) AND (X_C_EXT_ATTR35 is null)))
938 AND ((recinfo.C_EXT_ATTR36 = X_C_EXT_ATTR36)
939 OR ((recinfo.C_EXT_ATTR36 is null) AND (X_C_EXT_ATTR36 is null)))
940 AND ((recinfo.C_EXT_ATTR37 = X_C_EXT_ATTR37)
941 OR ((recinfo.C_EXT_ATTR37 is null) AND (X_C_EXT_ATTR37 is null)))
942 AND ((recinfo.C_EXT_ATTR38 = X_C_EXT_ATTR38)
943 OR ((recinfo.C_EXT_ATTR38 is null) AND (X_C_EXT_ATTR38 is null)))
944 AND ((recinfo.C_EXT_ATTR39 = X_C_EXT_ATTR39)
945 OR ((recinfo.C_EXT_ATTR39 is null) AND (X_C_EXT_ATTR39 is null)))
946 AND ((recinfo.C_EXT_ATTR40 = X_C_EXT_ATTR40)
947 OR ((recinfo.C_EXT_ATTR40 is null) AND (X_C_EXT_ATTR40 is null)))
948 AND ((recinfo.N_EXT_ATTR11 = X_N_EXT_ATTR11)
949 OR ((recinfo.N_EXT_ATTR11 is null) AND (X_N_EXT_ATTR11 is null)))
950 AND ((recinfo.N_EXT_ATTR12 = X_N_EXT_ATTR12)
951 OR ((recinfo.N_EXT_ATTR12 is null) AND (X_N_EXT_ATTR12 is null)))
952 AND ((recinfo.N_EXT_ATTR13 = X_N_EXT_ATTR13)
953 OR ((recinfo.N_EXT_ATTR13 is null) AND (X_N_EXT_ATTR13 is null)))
954 AND ((recinfo.N_EXT_ATTR14 = X_N_EXT_ATTR14)
955 OR ((recinfo.N_EXT_ATTR14 is null) AND (X_N_EXT_ATTR14 is null)))
956 AND ((recinfo.N_EXT_ATTR15 = X_N_EXT_ATTR15)
957 OR ((recinfo.N_EXT_ATTR15 is null) AND (X_N_EXT_ATTR15 is null)))
958 AND ((recinfo.N_EXT_ATTR16 = X_N_EXT_ATTR16)
959 OR ((recinfo.N_EXT_ATTR16 is null) AND (X_N_EXT_ATTR16 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)
1002 OR ((tlinfo.TL_EXT_ATTR17 is null) AND (X_TL_EXT_ATTR17 is null)))
1006 OR ((tlinfo.TL_EXT_ATTR19 is null) AND (X_TL_EXT_ATTR19 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)))
1005 AND ((tlinfo.TL_EXT_ATTR19 = X_TL_EXT_ATTR19)
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_N_EXT_ATTR17 in NUMBER,
1063 X_N_EXT_ATTR18 in NUMBER,
1064 X_N_EXT_ATTR19 in NUMBER,
1065 X_N_EXT_ATTR20 in NUMBER,
1066 X_UOM_EXT_ATTR1 in VARCHAR2,
1067 X_UOM_EXT_ATTR2 in VARCHAR2,
1068 X_UOM_EXT_ATTR3 in VARCHAR2,
1069 X_UOM_EXT_ATTR4 in VARCHAR2,
1070 X_UOM_EXT_ATTR5 in VARCHAR2,
1071 X_UOM_EXT_ATTR6 in VARCHAR2,
1072 X_UOM_EXT_ATTR7 in VARCHAR2,
1073 X_UOM_EXT_ATTR8 in VARCHAR2,
1074 X_UOM_EXT_ATTR9 in VARCHAR2,
1075 X_UOM_EXT_ATTR10 in VARCHAR2,
1076 X_UOM_EXT_ATTR11 in VARCHAR2,
1077 X_UOM_EXT_ATTR12 in VARCHAR2,
1078 X_UOM_EXT_ATTR13 in VARCHAR2,
1079 X_UOM_EXT_ATTR14 in VARCHAR2,
1080 X_UOM_EXT_ATTR15 in VARCHAR2,
1081 X_UOM_EXT_ATTR16 in VARCHAR2,
1082 X_UOM_EXT_ATTR17 in VARCHAR2,
1083 X_UOM_EXT_ATTR18 in VARCHAR2,
1084 X_UOM_EXT_ATTR19 in VARCHAR2,
1085 X_UOM_EXT_ATTR20 in VARCHAR2,
1086 X_D_EXT_ATTR6 in DATE,
1087 X_D_EXT_ATTR7 in DATE,
1088 X_D_EXT_ATTR8 in DATE,
1089 X_D_EXT_ATTR9 in DATE,
1090 X_D_EXT_ATTR10 in DATE,
1091 X_REQUEST_ID in NUMBER,
1092 X_SITE_ID in NUMBER,
1093 X_SITE_USE_TYPE_CODE in VARCHAR2,
1094 X_ATTR_GROUP_ID in NUMBER,
1095 X_C_EXT_ATTR1 in VARCHAR2,
1096 X_C_EXT_ATTR2 in VARCHAR2,
1097 X_C_EXT_ATTR3 in VARCHAR2,
1098 X_C_EXT_ATTR4 in VARCHAR2,
1099 X_C_EXT_ATTR5 in VARCHAR2,
1100 X_C_EXT_ATTR6 in VARCHAR2,
1101 X_C_EXT_ATTR7 in VARCHAR2,
1102 X_C_EXT_ATTR8 in VARCHAR2,
1103 X_C_EXT_ATTR9 in VARCHAR2,
1104 X_C_EXT_ATTR10 in VARCHAR2,
1105 X_C_EXT_ATTR11 in VARCHAR2,
1106 X_C_EXT_ATTR12 in VARCHAR2,
1107 X_C_EXT_ATTR13 in VARCHAR2,
1108 X_C_EXT_ATTR14 in VARCHAR2,
1109 X_C_EXT_ATTR15 in VARCHAR2,
1110 X_C_EXT_ATTR16 in VARCHAR2,
1111 X_C_EXT_ATTR17 in VARCHAR2,
1115 X_N_EXT_ATTR1 in NUMBER,
1112 X_C_EXT_ATTR18 in VARCHAR2,
1113 X_C_EXT_ATTR19 in VARCHAR2,
1114 X_C_EXT_ATTR20 in VARCHAR2,
1116 X_N_EXT_ATTR2 in NUMBER,
1117 X_N_EXT_ATTR3 in NUMBER,
1118 X_N_EXT_ATTR4 in NUMBER,
1119 X_N_EXT_ATTR5 in NUMBER,
1120 X_N_EXT_ATTR6 in NUMBER,
1121 X_N_EXT_ATTR7 in NUMBER,
1122 X_N_EXT_ATTR8 in NUMBER,
1123 X_N_EXT_ATTR9 in NUMBER,
1124 X_N_EXT_ATTR10 in NUMBER,
1125 X_D_EXT_ATTR1 in DATE,
1126 X_D_EXT_ATTR2 in DATE,
1127 X_D_EXT_ATTR3 in DATE,
1128 X_D_EXT_ATTR4 in DATE,
1129 X_D_EXT_ATTR5 in DATE,
1130 X_C_EXT_ATTR21 in VARCHAR2,
1131 X_C_EXT_ATTR22 in VARCHAR2,
1132 X_C_EXT_ATTR23 in VARCHAR2,
1133 X_C_EXT_ATTR24 in VARCHAR2,
1134 X_C_EXT_ATTR25 in VARCHAR2,
1135 X_C_EXT_ATTR26 in VARCHAR2,
1136 X_C_EXT_ATTR27 in VARCHAR2,
1137 X_C_EXT_ATTR28 in VARCHAR2,
1138 X_C_EXT_ATTR29 in VARCHAR2,
1139 X_C_EXT_ATTR30 in VARCHAR2,
1140 X_C_EXT_ATTR31 in VARCHAR2,
1141 X_C_EXT_ATTR32 in VARCHAR2,
1142 X_C_EXT_ATTR33 in VARCHAR2,
1143 X_C_EXT_ATTR34 in VARCHAR2,
1144 X_C_EXT_ATTR35 in VARCHAR2,
1145 X_C_EXT_ATTR36 in VARCHAR2,
1146 X_C_EXT_ATTR37 in VARCHAR2,
1147 X_C_EXT_ATTR38 in VARCHAR2,
1148 X_C_EXT_ATTR39 in VARCHAR2,
1149 X_C_EXT_ATTR40 in VARCHAR2,
1150 X_N_EXT_ATTR11 in NUMBER,
1151 X_N_EXT_ATTR12 in NUMBER,
1152 X_N_EXT_ATTR13 in NUMBER,
1153 X_N_EXT_ATTR14 in NUMBER,
1154 X_N_EXT_ATTR15 in NUMBER,
1155 X_N_EXT_ATTR16 in NUMBER,
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_SITES_EXT_B set
1202 N_EXT_ATTR17 = X_N_EXT_ATTR17,
1203 N_EXT_ATTR18 = X_N_EXT_ATTR18,
1204 N_EXT_ATTR19 = X_N_EXT_ATTR19,
1205 N_EXT_ATTR20 = X_N_EXT_ATTR20,
1206 UOM_EXT_ATTR1 = X_UOM_EXT_ATTR1,
1207 UOM_EXT_ATTR2 = X_UOM_EXT_ATTR2,
1208 UOM_EXT_ATTR3 = X_UOM_EXT_ATTR3,
1209 UOM_EXT_ATTR4 = X_UOM_EXT_ATTR4,
1210 UOM_EXT_ATTR5 = X_UOM_EXT_ATTR5,
1211 UOM_EXT_ATTR6 = X_UOM_EXT_ATTR6,
1212 UOM_EXT_ATTR7 = X_UOM_EXT_ATTR7,
1213 UOM_EXT_ATTR8 = X_UOM_EXT_ATTR8,
1214 UOM_EXT_ATTR9 = X_UOM_EXT_ATTR9,
1215 UOM_EXT_ATTR10 = X_UOM_EXT_ATTR10,
1216 UOM_EXT_ATTR11 = X_UOM_EXT_ATTR11,
1217 UOM_EXT_ATTR12 = X_UOM_EXT_ATTR12,
1218 UOM_EXT_ATTR13 = X_UOM_EXT_ATTR13,
1219 UOM_EXT_ATTR14 = X_UOM_EXT_ATTR14,
1220 UOM_EXT_ATTR15 = X_UOM_EXT_ATTR15,
1221 UOM_EXT_ATTR16 = X_UOM_EXT_ATTR16,
1222 UOM_EXT_ATTR17 = X_UOM_EXT_ATTR17,
1223 UOM_EXT_ATTR18 = X_UOM_EXT_ATTR18,
1224 UOM_EXT_ATTR19 = X_UOM_EXT_ATTR19,
1225 UOM_EXT_ATTR20 = X_UOM_EXT_ATTR20,
1226 D_EXT_ATTR6 = X_D_EXT_ATTR6,
1227 D_EXT_ATTR7 = X_D_EXT_ATTR7,
1228 D_EXT_ATTR8 = X_D_EXT_ATTR8,
1229 D_EXT_ATTR9 = X_D_EXT_ATTR9,
1230 D_EXT_ATTR10 = X_D_EXT_ATTR10,
1231 REQUEST_ID = X_REQUEST_ID,
1232 SITE_ID = X_SITE_ID,
1233 SITE_USE_TYPE_CODE = X_SITE_USE_TYPE_CODE,
1234 ATTR_GROUP_ID = X_ATTR_GROUP_ID,
1235 C_EXT_ATTR1 = X_C_EXT_ATTR1,
1236 C_EXT_ATTR2 = X_C_EXT_ATTR2,
1237 C_EXT_ATTR3 = X_C_EXT_ATTR3,
1238 C_EXT_ATTR4 = X_C_EXT_ATTR4,
1239 C_EXT_ATTR5 = X_C_EXT_ATTR5,
1240 C_EXT_ATTR6 = X_C_EXT_ATTR6,
1241 C_EXT_ATTR7 = X_C_EXT_ATTR7,
1242 C_EXT_ATTR8 = X_C_EXT_ATTR8,
1243 C_EXT_ATTR9 = X_C_EXT_ATTR9,
1244 C_EXT_ATTR10 = X_C_EXT_ATTR10,
1245 C_EXT_ATTR11 = X_C_EXT_ATTR11,
1246 C_EXT_ATTR12 = X_C_EXT_ATTR12,
1247 C_EXT_ATTR13 = X_C_EXT_ATTR13,
1248 C_EXT_ATTR14 = X_C_EXT_ATTR14,
1249 C_EXT_ATTR15 = X_C_EXT_ATTR15,
1250 C_EXT_ATTR16 = X_C_EXT_ATTR16,
1251 C_EXT_ATTR17 = X_C_EXT_ATTR17,
1252 C_EXT_ATTR18 = X_C_EXT_ATTR18,
1253 C_EXT_ATTR19 = X_C_EXT_ATTR19,
1257 N_EXT_ATTR3 = X_N_EXT_ATTR3,
1254 C_EXT_ATTR20 = X_C_EXT_ATTR20,
1255 N_EXT_ATTR1 = X_N_EXT_ATTR1,
1256 N_EXT_ATTR2 = X_N_EXT_ATTR2,
1258 N_EXT_ATTR4 = X_N_EXT_ATTR4,
1259 N_EXT_ATTR5 = X_N_EXT_ATTR5,
1260 N_EXT_ATTR6 = X_N_EXT_ATTR6,
1261 N_EXT_ATTR7 = X_N_EXT_ATTR7,
1262 N_EXT_ATTR8 = X_N_EXT_ATTR8,
1263 N_EXT_ATTR9 = X_N_EXT_ATTR9,
1264 N_EXT_ATTR10 = X_N_EXT_ATTR10,
1265 D_EXT_ATTR1 = X_D_EXT_ATTR1,
1266 D_EXT_ATTR2 = X_D_EXT_ATTR2,
1267 D_EXT_ATTR3 = X_D_EXT_ATTR3,
1268 D_EXT_ATTR4 = X_D_EXT_ATTR4,
1269 D_EXT_ATTR5 = X_D_EXT_ATTR5,
1270 C_EXT_ATTR21 = X_C_EXT_ATTR21,
1271 C_EXT_ATTR22 = X_C_EXT_ATTR22,
1272 C_EXT_ATTR23 = X_C_EXT_ATTR23,
1273 C_EXT_ATTR24 = X_C_EXT_ATTR24,
1274 C_EXT_ATTR25 = X_C_EXT_ATTR25,
1275 C_EXT_ATTR26 = X_C_EXT_ATTR26,
1276 C_EXT_ATTR27 = X_C_EXT_ATTR27,
1277 C_EXT_ATTR28 = X_C_EXT_ATTR28,
1278 C_EXT_ATTR29 = X_C_EXT_ATTR29,
1279 C_EXT_ATTR30 = X_C_EXT_ATTR30,
1280 C_EXT_ATTR31 = X_C_EXT_ATTR31,
1281 C_EXT_ATTR32 = X_C_EXT_ATTR32,
1282 C_EXT_ATTR33 = X_C_EXT_ATTR33,
1283 C_EXT_ATTR34 = X_C_EXT_ATTR34,
1284 C_EXT_ATTR35 = X_C_EXT_ATTR35,
1285 C_EXT_ATTR36 = X_C_EXT_ATTR36,
1286 C_EXT_ATTR37 = X_C_EXT_ATTR37,
1287 C_EXT_ATTR38 = X_C_EXT_ATTR38,
1288 C_EXT_ATTR39 = X_C_EXT_ATTR39,
1289 C_EXT_ATTR40 = X_C_EXT_ATTR40,
1290 N_EXT_ATTR11 = X_N_EXT_ATTR11,
1291 N_EXT_ATTR12 = X_N_EXT_ATTR12,
1292 N_EXT_ATTR13 = X_N_EXT_ATTR13,
1293 N_EXT_ATTR14 = X_N_EXT_ATTR14,
1294 N_EXT_ATTR15 = X_N_EXT_ATTR15,
1295 N_EXT_ATTR16 = X_N_EXT_ATTR16,
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_SITES_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_SITES_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_SITES_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_SITES_EXT_TL T
1381 where not exists
1382 (select NULL
1383 from RRS_SITES_EXT_B B
1384 where B.EXTENSION_ID = T.EXTENSION_ID
1385 );
1386
1387 update RRS_SITES_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,
1402 TL_EXT_ATTR15,
1399 TL_EXT_ATTR12,
1400 TL_EXT_ATTR13,
1401 TL_EXT_ATTR14,
1403 TL_EXT_ATTR16,
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_SITES_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_SITES_EXT_TL SUBB, RRS_SITES_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)
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)
1562 or SUBB.TL_EXT_ATTR28 <> SUBT.TL_EXT_ATTR28
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_SITES_EXT_TL (
1604 EXTENSION_ID,
1605 SITE_ID,
1606 SITE_USE_TYPE_CODE,
1607 ATTR_GROUP_ID,
1608 LAST_UPDATE_DATE,
1609 LAST_UPDATED_BY,
1610 LAST_UPDATE_LOGIN,
1611 CREATED_BY,
1612 CREATION_DATE,
1613 TL_EXT_ATTR1,
1614 TL_EXT_ATTR2,
1615 TL_EXT_ATTR3,
1616 TL_EXT_ATTR4,
1617 TL_EXT_ATTR5,
1618 TL_EXT_ATTR6,
1619 TL_EXT_ATTR7,
1620 TL_EXT_ATTR8,
1621 TL_EXT_ATTR9,
1622 TL_EXT_ATTR10,
1623 TL_EXT_ATTR11,
1627 TL_EXT_ATTR15,
1624 TL_EXT_ATTR12,
1625 TL_EXT_ATTR13,
1626 TL_EXT_ATTR14,
1628 TL_EXT_ATTR16,
1629 TL_EXT_ATTR17,
1630 TL_EXT_ATTR18,
1631 TL_EXT_ATTR19,
1632 TL_EXT_ATTR20,
1633 TL_EXT_ATTR21,
1634 TL_EXT_ATTR22,
1635 TL_EXT_ATTR23,
1636 TL_EXT_ATTR24,
1637 TL_EXT_ATTR25,
1638 TL_EXT_ATTR26,
1639 TL_EXT_ATTR27,
1640 TL_EXT_ATTR28,
1641 TL_EXT_ATTR29,
1642 TL_EXT_ATTR30,
1643 TL_EXT_ATTR31,
1644 TL_EXT_ATTR32,
1645 TL_EXT_ATTR33,
1646 TL_EXT_ATTR34,
1647 TL_EXT_ATTR35,
1648 TL_EXT_ATTR36,
1649 TL_EXT_ATTR37,
1650 TL_EXT_ATTR38,
1651 TL_EXT_ATTR39,
1652 TL_EXT_ATTR40,
1653 DATA_LEVEL_ID,
1654 LANGUAGE,
1655 SOURCE_LANG
1656 ) select /*+ ORDERED */
1657 B.EXTENSION_ID,
1658 B.SITE_ID,
1659 B.SITE_USE_TYPE_CODE,
1660 B.ATTR_GROUP_ID,
1661 B.LAST_UPDATE_DATE,
1662 B.LAST_UPDATED_BY,
1663 B.LAST_UPDATE_LOGIN,
1664 B.CREATED_BY,
1665 B.CREATION_DATE,
1666 B.TL_EXT_ATTR1,
1667 B.TL_EXT_ATTR2,
1668 B.TL_EXT_ATTR3,
1669 B.TL_EXT_ATTR4,
1670 B.TL_EXT_ATTR5,
1671 B.TL_EXT_ATTR6,
1672 B.TL_EXT_ATTR7,
1673 B.TL_EXT_ATTR8,
1674 B.TL_EXT_ATTR9,
1675 B.TL_EXT_ATTR10,
1676 B.TL_EXT_ATTR11,
1677 B.TL_EXT_ATTR12,
1678 B.TL_EXT_ATTR13,
1679 B.TL_EXT_ATTR14,
1680 B.TL_EXT_ATTR15,
1681 B.TL_EXT_ATTR16,
1682 B.TL_EXT_ATTR17,
1683 B.TL_EXT_ATTR18,
1684 B.TL_EXT_ATTR19,
1685 B.TL_EXT_ATTR20,
1686 B.TL_EXT_ATTR21,
1687 B.TL_EXT_ATTR22,
1688 B.TL_EXT_ATTR23,
1689 B.TL_EXT_ATTR24,
1690 B.TL_EXT_ATTR25,
1691 B.TL_EXT_ATTR26,
1692 B.TL_EXT_ATTR27,
1693 B.TL_EXT_ATTR28,
1694 B.TL_EXT_ATTR29,
1695 B.TL_EXT_ATTR30,
1696 B.TL_EXT_ATTR31,
1697 B.TL_EXT_ATTR32,
1698 B.TL_EXT_ATTR33,
1699 B.TL_EXT_ATTR34,
1700 B.TL_EXT_ATTR35,
1701 B.TL_EXT_ATTR36,
1702 B.TL_EXT_ATTR37,
1703 B.TL_EXT_ATTR38,
1704 B.TL_EXT_ATTR39,
1705 B.TL_EXT_ATTR40,
1706 B.DATA_LEVEL_ID,
1707 L.LANGUAGE_CODE,
1708 B.SOURCE_LANG
1709 from RRS_SITES_EXT_TL B, FND_LANGUAGES L
1710 where L.INSTALLED_FLAG in ('I', 'B')
1711 and B.LANGUAGE = userenv('LANG')
1712 and not exists
1713 (select NULL
1714 from RRS_SITES_EXT_TL T
1715 where T.EXTENSION_ID = B.EXTENSION_ID
1716 and T.LANGUAGE = L.LANGUAGE_CODE);
1717 end ADD_LANGUAGE;
1718
1719 end RRS_SITES_EXT_PKG;
[Home] [Help]