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