[Home] [Help]
PACKAGE BODY: APPS.BNE_ATTRIBUTES_PKG
Source
1 package body BNE_ATTRIBUTES_PKG as
2 /* $Header: bneattsb.pls 120.2 2005/06/29 03:39:39 dvayro noship $ */
3
4 procedure INSERT_ROW (
5 X_ROWID in out NOCOPY VARCHAR2,
6 X_APPLICATION_ID in NUMBER,
7 X_ATTRIBUTE_CODE in VARCHAR2,
8 X_OBJECT_VERSION_NUMBER in NUMBER,
9 X_ATTRIBUTE1 in VARCHAR2,
10 X_ATTRIBUTE2 in VARCHAR2,
11 X_ATTRIBUTE3 in VARCHAR2,
12 X_ATTRIBUTE4 in VARCHAR2,
13 X_ATTRIBUTE5 in VARCHAR2,
14 X_ATTRIBUTE6 in VARCHAR2,
15 X_ATTRIBUTE7 in VARCHAR2,
16 X_ATTRIBUTE8 in VARCHAR2,
17 X_ATTRIBUTE9 in VARCHAR2,
18 X_ATTRIBUTE10 in VARCHAR2,
19 X_ATTRIBUTE11 in VARCHAR2,
20 X_ATTRIBUTE12 in VARCHAR2,
21 X_ATTRIBUTE13 in VARCHAR2,
22 X_ATTRIBUTE14 in VARCHAR2,
23 X_ATTRIBUTE15 in VARCHAR2,
24 X_ATTRIBUTE16 in VARCHAR2,
25 X_ATTRIBUTE17 in VARCHAR2,
26 X_ATTRIBUTE18 in VARCHAR2,
27 X_ATTRIBUTE19 in VARCHAR2,
28 X_ATTRIBUTE20 in VARCHAR2,
29 X_ATTRIBUTE21 in VARCHAR2,
30 X_ATTRIBUTE22 in VARCHAR2,
31 X_ATTRIBUTE23 in VARCHAR2,
32 X_ATTRIBUTE24 in VARCHAR2,
33 X_ATTRIBUTE25 in VARCHAR2,
34 X_ATTRIBUTE26 in VARCHAR2,
35 X_ATTRIBUTE27 in VARCHAR2,
36 X_ATTRIBUTE28 in VARCHAR2,
37 X_ATTRIBUTE29 in VARCHAR2,
38 X_ATTRIBUTE30 in VARCHAR2,
39 X_CREATION_DATE in DATE,
40 X_CREATED_BY in NUMBER,
41 X_LAST_UPDATE_DATE in DATE,
42 X_LAST_UPDATED_BY in NUMBER,
43 X_LAST_UPDATE_LOGIN in NUMBER,
44 X_ATTRIBUTE_NAME1 in VARCHAR2,
45 X_ATTRIBUTE_NAME2 in VARCHAR2,
46 X_ATTRIBUTE_NAME3 in VARCHAR2,
47 X_ATTRIBUTE_NAME4 in VARCHAR2,
48 X_ATTRIBUTE_NAME5 in VARCHAR2,
49 X_ATTRIBUTE_NAME6 in VARCHAR2,
50 X_ATTRIBUTE_NAME7 in VARCHAR2,
51 X_ATTRIBUTE_NAME8 in VARCHAR2,
52 X_ATTRIBUTE_NAME9 in VARCHAR2,
53 X_ATTRIBUTE_NAME10 in VARCHAR2,
54 X_ATTRIBUTE_NAME11 in VARCHAR2,
55 X_ATTRIBUTE_NAME12 in VARCHAR2,
56 X_ATTRIBUTE_NAME13 in VARCHAR2,
57 X_ATTRIBUTE_NAME14 in VARCHAR2,
58 X_ATTRIBUTE_NAME15 in VARCHAR2,
59 X_ATTRIBUTE_NAME16 in VARCHAR2,
60 X_ATTRIBUTE_NAME17 in VARCHAR2,
61 X_ATTRIBUTE_NAME18 in VARCHAR2,
62 X_ATTRIBUTE_NAME19 in VARCHAR2,
63 X_ATTRIBUTE_NAME20 in VARCHAR2,
64 X_ATTRIBUTE_NAME21 in VARCHAR2,
65 X_ATTRIBUTE_NAME22 in VARCHAR2,
66 X_ATTRIBUTE_NAME23 in VARCHAR2,
67 X_ATTRIBUTE_NAME24 in VARCHAR2,
68 X_ATTRIBUTE_NAME25 in VARCHAR2,
69 X_ATTRIBUTE_NAME26 in VARCHAR2,
70 X_ATTRIBUTE_NAME27 in VARCHAR2,
71 X_ATTRIBUTE_NAME28 in VARCHAR2,
72 X_ATTRIBUTE_NAME29 in VARCHAR2,
73 X_ATTRIBUTE_NAME30 in VARCHAR2
74 ) is
75 cursor C is select ROWID from BNE_ATTRIBUTES
76 where APPLICATION_ID = X_APPLICATION_ID
77 and ATTRIBUTE_CODE = X_ATTRIBUTE_CODE
78 ;
79 begin
80 insert into BNE_ATTRIBUTES (
81 CREATION_DATE,
82 LAST_UPDATED_BY,
83 LAST_UPDATE_DATE,
84 LAST_UPDATE_LOGIN,
85 CREATED_BY,
86 APPLICATION_ID,
87 ATTRIBUTE_CODE,
88 OBJECT_VERSION_NUMBER,
89 ATTRIBUTE1,
90 ATTRIBUTE2,
91 ATTRIBUTE3,
92 ATTRIBUTE4,
93 ATTRIBUTE5,
94 ATTRIBUTE6,
95 ATTRIBUTE7,
96 ATTRIBUTE8,
97 ATTRIBUTE9,
98 ATTRIBUTE10,
99 ATTRIBUTE11,
100 ATTRIBUTE12,
101 ATTRIBUTE13,
102 ATTRIBUTE14,
103 ATTRIBUTE15,
104 ATTRIBUTE16,
105 ATTRIBUTE17,
106 ATTRIBUTE18,
107 ATTRIBUTE19,
108 ATTRIBUTE20,
109 ATTRIBUTE21,
110 ATTRIBUTE22,
111 ATTRIBUTE23,
112 ATTRIBUTE24,
113 ATTRIBUTE25,
114 ATTRIBUTE26,
115 ATTRIBUTE27,
116 ATTRIBUTE28,
117 ATTRIBUTE29,
118 ATTRIBUTE30,
119 ATTRIBUTE_NAME1,
120 ATTRIBUTE_NAME2,
121 ATTRIBUTE_NAME3,
122 ATTRIBUTE_NAME4,
123 ATTRIBUTE_NAME5,
124 ATTRIBUTE_NAME6,
125 ATTRIBUTE_NAME7,
126 ATTRIBUTE_NAME8,
127 ATTRIBUTE_NAME9,
128 ATTRIBUTE_NAME10,
129 ATTRIBUTE_NAME11,
130 ATTRIBUTE_NAME12,
131 ATTRIBUTE_NAME13,
132 ATTRIBUTE_NAME14,
133 ATTRIBUTE_NAME15,
134 ATTRIBUTE_NAME16,
135 ATTRIBUTE_NAME17,
136 ATTRIBUTE_NAME18,
137 ATTRIBUTE_NAME19,
138 ATTRIBUTE_NAME20,
139 ATTRIBUTE_NAME21,
140 ATTRIBUTE_NAME22,
141 ATTRIBUTE_NAME23,
142 ATTRIBUTE_NAME24,
143 ATTRIBUTE_NAME25,
144 ATTRIBUTE_NAME26,
145 ATTRIBUTE_NAME27,
146 ATTRIBUTE_NAME28,
147 ATTRIBUTE_NAME29,
148 ATTRIBUTE_NAME30
149 ) values (
150 X_CREATION_DATE,
151 X_LAST_UPDATED_BY,
152 X_LAST_UPDATE_DATE,
153 X_LAST_UPDATE_LOGIN,
154 X_CREATED_BY,
155 X_APPLICATION_ID,
156 X_ATTRIBUTE_CODE,
157 X_OBJECT_VERSION_NUMBER,
158 X_ATTRIBUTE1,
159 X_ATTRIBUTE2,
160 X_ATTRIBUTE3,
161 X_ATTRIBUTE4,
162 X_ATTRIBUTE5,
163 X_ATTRIBUTE6,
164 X_ATTRIBUTE7,
165 X_ATTRIBUTE8,
166 X_ATTRIBUTE9,
167 X_ATTRIBUTE10,
168 X_ATTRIBUTE11,
169 X_ATTRIBUTE12,
170 X_ATTRIBUTE13,
171 X_ATTRIBUTE14,
172 X_ATTRIBUTE15,
173 X_ATTRIBUTE16,
174 X_ATTRIBUTE17,
175 X_ATTRIBUTE18,
176 X_ATTRIBUTE19,
177 X_ATTRIBUTE20,
178 X_ATTRIBUTE21,
179 X_ATTRIBUTE22,
180 X_ATTRIBUTE23,
181 X_ATTRIBUTE24,
182 X_ATTRIBUTE25,
183 X_ATTRIBUTE26,
184 X_ATTRIBUTE27,
185 X_ATTRIBUTE28,
186 X_ATTRIBUTE29,
187 X_ATTRIBUTE30,
188 X_ATTRIBUTE_NAME1,
189 X_ATTRIBUTE_NAME2,
190 X_ATTRIBUTE_NAME3,
191 X_ATTRIBUTE_NAME4,
192 X_ATTRIBUTE_NAME5,
193 X_ATTRIBUTE_NAME6,
194 X_ATTRIBUTE_NAME7,
195 X_ATTRIBUTE_NAME8,
196 X_ATTRIBUTE_NAME9,
197 X_ATTRIBUTE_NAME10,
198 X_ATTRIBUTE_NAME11,
199 X_ATTRIBUTE_NAME12,
200 X_ATTRIBUTE_NAME13,
201 X_ATTRIBUTE_NAME14,
202 X_ATTRIBUTE_NAME15,
203 X_ATTRIBUTE_NAME16,
204 X_ATTRIBUTE_NAME17,
205 X_ATTRIBUTE_NAME18,
206 X_ATTRIBUTE_NAME19,
207 X_ATTRIBUTE_NAME20,
208 X_ATTRIBUTE_NAME21,
209 X_ATTRIBUTE_NAME22,
210 X_ATTRIBUTE_NAME23,
211 X_ATTRIBUTE_NAME24,
212 X_ATTRIBUTE_NAME25,
213 X_ATTRIBUTE_NAME26,
214 X_ATTRIBUTE_NAME27,
215 X_ATTRIBUTE_NAME28,
216 X_ATTRIBUTE_NAME29,
217 X_ATTRIBUTE_NAME30
218 );
219
220 open c;
221 fetch c into X_ROWID;
222 if (c%notfound) then
223 close c;
224 raise no_data_found;
225 end if;
226 close c;
227
228 end INSERT_ROW;
229
230 procedure LOCK_ROW (
231 X_APPLICATION_ID in NUMBER,
232 X_ATTRIBUTE_CODE in VARCHAR2,
233 X_OBJECT_VERSION_NUMBER in NUMBER,
234 X_ATTRIBUTE1 in VARCHAR2,
235 X_ATTRIBUTE2 in VARCHAR2,
236 X_ATTRIBUTE3 in VARCHAR2,
237 X_ATTRIBUTE4 in VARCHAR2,
238 X_ATTRIBUTE5 in VARCHAR2,
239 X_ATTRIBUTE6 in VARCHAR2,
240 X_ATTRIBUTE7 in VARCHAR2,
241 X_ATTRIBUTE8 in VARCHAR2,
242 X_ATTRIBUTE9 in VARCHAR2,
243 X_ATTRIBUTE10 in VARCHAR2,
244 X_ATTRIBUTE11 in VARCHAR2,
245 X_ATTRIBUTE12 in VARCHAR2,
246 X_ATTRIBUTE13 in VARCHAR2,
247 X_ATTRIBUTE14 in VARCHAR2,
248 X_ATTRIBUTE15 in VARCHAR2,
249 X_ATTRIBUTE16 in VARCHAR2,
250 X_ATTRIBUTE17 in VARCHAR2,
251 X_ATTRIBUTE18 in VARCHAR2,
252 X_ATTRIBUTE19 in VARCHAR2,
253 X_ATTRIBUTE20 in VARCHAR2,
254 X_ATTRIBUTE21 in VARCHAR2,
255 X_ATTRIBUTE22 in VARCHAR2,
256 X_ATTRIBUTE23 in VARCHAR2,
257 X_ATTRIBUTE24 in VARCHAR2,
258 X_ATTRIBUTE25 in VARCHAR2,
259 X_ATTRIBUTE26 in VARCHAR2,
260 X_ATTRIBUTE27 in VARCHAR2,
261 X_ATTRIBUTE28 in VARCHAR2,
262 X_ATTRIBUTE29 in VARCHAR2,
263 X_ATTRIBUTE30 in VARCHAR2,
264 X_ATTRIBUTE_NAME1 in VARCHAR2,
265 X_ATTRIBUTE_NAME2 in VARCHAR2,
266 X_ATTRIBUTE_NAME3 in VARCHAR2,
267 X_ATTRIBUTE_NAME4 in VARCHAR2,
268 X_ATTRIBUTE_NAME5 in VARCHAR2,
269 X_ATTRIBUTE_NAME6 in VARCHAR2,
270 X_ATTRIBUTE_NAME7 in VARCHAR2,
271 X_ATTRIBUTE_NAME8 in VARCHAR2,
272 X_ATTRIBUTE_NAME9 in VARCHAR2,
273 X_ATTRIBUTE_NAME10 in VARCHAR2,
274 X_ATTRIBUTE_NAME11 in VARCHAR2,
275 X_ATTRIBUTE_NAME12 in VARCHAR2,
276 X_ATTRIBUTE_NAME13 in VARCHAR2,
277 X_ATTRIBUTE_NAME14 in VARCHAR2,
278 X_ATTRIBUTE_NAME15 in VARCHAR2,
279 X_ATTRIBUTE_NAME16 in VARCHAR2,
280 X_ATTRIBUTE_NAME17 in VARCHAR2,
281 X_ATTRIBUTE_NAME18 in VARCHAR2,
282 X_ATTRIBUTE_NAME19 in VARCHAR2,
283 X_ATTRIBUTE_NAME20 in VARCHAR2,
284 X_ATTRIBUTE_NAME21 in VARCHAR2,
285 X_ATTRIBUTE_NAME22 in VARCHAR2,
286 X_ATTRIBUTE_NAME23 in VARCHAR2,
287 X_ATTRIBUTE_NAME24 in VARCHAR2,
288 X_ATTRIBUTE_NAME25 in VARCHAR2,
289 X_ATTRIBUTE_NAME26 in VARCHAR2,
290 X_ATTRIBUTE_NAME27 in VARCHAR2,
291 X_ATTRIBUTE_NAME28 in VARCHAR2,
292 X_ATTRIBUTE_NAME29 in VARCHAR2,
293 X_ATTRIBUTE_NAME30 in VARCHAR2
294 ) is
295 cursor c1 is select
296 OBJECT_VERSION_NUMBER,
297 ATTRIBUTE1,
298 ATTRIBUTE2,
299 ATTRIBUTE3,
300 ATTRIBUTE4,
301 ATTRIBUTE5,
302 ATTRIBUTE6,
303 ATTRIBUTE7,
304 ATTRIBUTE8,
305 ATTRIBUTE9,
306 ATTRIBUTE10,
307 ATTRIBUTE11,
308 ATTRIBUTE12,
309 ATTRIBUTE13,
310 ATTRIBUTE14,
311 ATTRIBUTE15,
312 ATTRIBUTE16,
313 ATTRIBUTE17,
314 ATTRIBUTE18,
315 ATTRIBUTE19,
316 ATTRIBUTE20,
317 ATTRIBUTE21,
318 ATTRIBUTE22,
319 ATTRIBUTE23,
320 ATTRIBUTE24,
321 ATTRIBUTE25,
322 ATTRIBUTE26,
323 ATTRIBUTE27,
324 ATTRIBUTE28,
325 ATTRIBUTE29,
326 ATTRIBUTE30,
327 ATTRIBUTE_NAME1,
328 ATTRIBUTE_NAME2,
329 ATTRIBUTE_NAME3,
330 ATTRIBUTE_NAME4,
331 ATTRIBUTE_NAME5,
332 ATTRIBUTE_NAME6,
333 ATTRIBUTE_NAME7,
334 ATTRIBUTE_NAME8,
335 ATTRIBUTE_NAME9,
336 ATTRIBUTE_NAME10,
337 ATTRIBUTE_NAME11,
338 ATTRIBUTE_NAME12,
339 ATTRIBUTE_NAME13,
340 ATTRIBUTE_NAME14,
341 ATTRIBUTE_NAME15,
342 ATTRIBUTE_NAME16,
343 ATTRIBUTE_NAME17,
344 ATTRIBUTE_NAME18,
345 ATTRIBUTE_NAME19,
346 ATTRIBUTE_NAME20,
347 ATTRIBUTE_NAME21,
348 ATTRIBUTE_NAME22,
349 ATTRIBUTE_NAME23,
350 ATTRIBUTE_NAME24,
351 ATTRIBUTE_NAME25,
352 ATTRIBUTE_NAME26,
353 ATTRIBUTE_NAME27,
354 ATTRIBUTE_NAME28,
355 ATTRIBUTE_NAME29,
356 ATTRIBUTE_NAME30
357 from BNE_ATTRIBUTES
358 where APPLICATION_ID = X_APPLICATION_ID
359 and ATTRIBUTE_CODE = X_ATTRIBUTE_CODE
360 for update of APPLICATION_ID nowait;
361 begin
362 for tlinfo in c1 loop
363 if ( (tlinfo.OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER)
364 AND ((tlinfo.ATTRIBUTE1 = X_ATTRIBUTE1)
365 OR ((tlinfo.ATTRIBUTE1 is null) AND (X_ATTRIBUTE1 is null)))
366 AND ((tlinfo.ATTRIBUTE2 = X_ATTRIBUTE2)
367 OR ((tlinfo.ATTRIBUTE2 is null) AND (X_ATTRIBUTE2 is null)))
368 AND ((tlinfo.ATTRIBUTE3 = X_ATTRIBUTE3)
369 OR ((tlinfo.ATTRIBUTE3 is null) AND (X_ATTRIBUTE3 is null)))
370 AND ((tlinfo.ATTRIBUTE4 = X_ATTRIBUTE4)
371 OR ((tlinfo.ATTRIBUTE4 is null) AND (X_ATTRIBUTE4 is null)))
372 AND ((tlinfo.ATTRIBUTE5 = X_ATTRIBUTE5)
373 OR ((tlinfo.ATTRIBUTE5 is null) AND (X_ATTRIBUTE5 is null)))
374 AND ((tlinfo.ATTRIBUTE6 = X_ATTRIBUTE6)
375 OR ((tlinfo.ATTRIBUTE6 is null) AND (X_ATTRIBUTE6 is null)))
376 AND ((tlinfo.ATTRIBUTE7 = X_ATTRIBUTE7)
377 OR ((tlinfo.ATTRIBUTE7 is null) AND (X_ATTRIBUTE7 is null)))
378 AND ((tlinfo.ATTRIBUTE8 = X_ATTRIBUTE8)
379 OR ((tlinfo.ATTRIBUTE8 is null) AND (X_ATTRIBUTE8 is null)))
383 OR ((tlinfo.ATTRIBUTE10 is null) AND (X_ATTRIBUTE10 is null)))
380 AND ((tlinfo.ATTRIBUTE9 = X_ATTRIBUTE9)
381 OR ((tlinfo.ATTRIBUTE9 is null) AND (X_ATTRIBUTE9 is null)))
382 AND ((tlinfo.ATTRIBUTE10 = X_ATTRIBUTE10)
384 AND ((tlinfo.ATTRIBUTE11 = X_ATTRIBUTE11)
385 OR ((tlinfo.ATTRIBUTE11 is null) AND (X_ATTRIBUTE11 is null)))
386 AND ((tlinfo.ATTRIBUTE12 = X_ATTRIBUTE12)
387 OR ((tlinfo.ATTRIBUTE12 is null) AND (X_ATTRIBUTE12 is null)))
388 AND ((tlinfo.ATTRIBUTE13 = X_ATTRIBUTE13)
389 OR ((tlinfo.ATTRIBUTE13 is null) AND (X_ATTRIBUTE13 is null)))
390 AND ((tlinfo.ATTRIBUTE14 = X_ATTRIBUTE14)
391 OR ((tlinfo.ATTRIBUTE14 is null) AND (X_ATTRIBUTE14 is null)))
392 AND ((tlinfo.ATTRIBUTE15 = X_ATTRIBUTE15)
393 OR ((tlinfo.ATTRIBUTE15 is null) AND (X_ATTRIBUTE15 is null)))
394 AND ((tlinfo.ATTRIBUTE16 = X_ATTRIBUTE16)
395 OR ((tlinfo.ATTRIBUTE16 is null) AND (X_ATTRIBUTE16 is null)))
396 AND ((tlinfo.ATTRIBUTE17 = X_ATTRIBUTE17)
397 OR ((tlinfo.ATTRIBUTE17 is null) AND (X_ATTRIBUTE17 is null)))
398 AND ((tlinfo.ATTRIBUTE18 = X_ATTRIBUTE18)
399 OR ((tlinfo.ATTRIBUTE18 is null) AND (X_ATTRIBUTE18 is null)))
400 AND ((tlinfo.ATTRIBUTE19 = X_ATTRIBUTE19)
401 OR ((tlinfo.ATTRIBUTE19 is null) AND (X_ATTRIBUTE19 is null)))
402 AND ((tlinfo.ATTRIBUTE20 = X_ATTRIBUTE20)
403 OR ((tlinfo.ATTRIBUTE20 is null) AND (X_ATTRIBUTE20 is null)))
404 AND ((tlinfo.ATTRIBUTE21 = X_ATTRIBUTE21)
405 OR ((tlinfo.ATTRIBUTE21 is null) AND (X_ATTRIBUTE21 is null)))
406 AND ((tlinfo.ATTRIBUTE22 = X_ATTRIBUTE22)
407 OR ((tlinfo.ATTRIBUTE22 is null) AND (X_ATTRIBUTE22 is null)))
408 AND ((tlinfo.ATTRIBUTE23 = X_ATTRIBUTE23)
409 OR ((tlinfo.ATTRIBUTE23 is null) AND (X_ATTRIBUTE23 is null)))
410 AND ((tlinfo.ATTRIBUTE24 = X_ATTRIBUTE24)
411 OR ((tlinfo.ATTRIBUTE24 is null) AND (X_ATTRIBUTE24 is null)))
412 AND ((tlinfo.ATTRIBUTE25 = X_ATTRIBUTE25)
413 OR ((tlinfo.ATTRIBUTE25 is null) AND (X_ATTRIBUTE25 is null)))
414 AND ((tlinfo.ATTRIBUTE26 = X_ATTRIBUTE26)
415 OR ((tlinfo.ATTRIBUTE26 is null) AND (X_ATTRIBUTE26 is null)))
416 AND ((tlinfo.ATTRIBUTE27 = X_ATTRIBUTE27)
417 OR ((tlinfo.ATTRIBUTE27 is null) AND (X_ATTRIBUTE27 is null)))
418 AND ((tlinfo.ATTRIBUTE28 = X_ATTRIBUTE28)
419 OR ((tlinfo.ATTRIBUTE28 is null) AND (X_ATTRIBUTE28 is null)))
420 AND ((tlinfo.ATTRIBUTE29 = X_ATTRIBUTE29)
421 OR ((tlinfo.ATTRIBUTE29 is null) AND (X_ATTRIBUTE29 is null)))
422 AND ((tlinfo.ATTRIBUTE30 = X_ATTRIBUTE30)
423 OR ((tlinfo.ATTRIBUTE30 is null) AND (X_ATTRIBUTE30 is null)))
424 AND ((tlinfo.ATTRIBUTE_NAME1 = X_ATTRIBUTE_NAME1)
425 OR ((tlinfo.ATTRIBUTE_NAME1 is null) AND (X_ATTRIBUTE_NAME1 is null)))
426 AND ((tlinfo.ATTRIBUTE_NAME2 = X_ATTRIBUTE_NAME2)
430 AND ((tlinfo.ATTRIBUTE_NAME4 = X_ATTRIBUTE_NAME4)
427 OR ((tlinfo.ATTRIBUTE_NAME2 is null) AND (X_ATTRIBUTE_NAME2 is null)))
428 AND ((tlinfo.ATTRIBUTE_NAME3 = X_ATTRIBUTE_NAME3)
429 OR ((tlinfo.ATTRIBUTE_NAME3 is null) AND (X_ATTRIBUTE_NAME3 is null)))
431 OR ((tlinfo.ATTRIBUTE_NAME4 is null) AND (X_ATTRIBUTE_NAME4 is null)))
432 AND ((tlinfo.ATTRIBUTE_NAME5 = X_ATTRIBUTE_NAME5)
433 OR ((tlinfo.ATTRIBUTE_NAME5 is null) AND (X_ATTRIBUTE_NAME5 is null)))
434 AND ((tlinfo.ATTRIBUTE_NAME6 = X_ATTRIBUTE_NAME6)
435 OR ((tlinfo.ATTRIBUTE_NAME6 is null) AND (X_ATTRIBUTE_NAME6 is null)))
436 AND ((tlinfo.ATTRIBUTE_NAME7 = X_ATTRIBUTE_NAME7)
437 OR ((tlinfo.ATTRIBUTE_NAME7 is null) AND (X_ATTRIBUTE_NAME7 is null)))
438 AND ((tlinfo.ATTRIBUTE_NAME8 = X_ATTRIBUTE_NAME8)
439 OR ((tlinfo.ATTRIBUTE_NAME8 is null) AND (X_ATTRIBUTE_NAME8 is null)))
440 AND ((tlinfo.ATTRIBUTE_NAME9 = X_ATTRIBUTE_NAME9)
441 OR ((tlinfo.ATTRIBUTE_NAME9 is null) AND (X_ATTRIBUTE_NAME9 is null)))
442 AND ((tlinfo.ATTRIBUTE_NAME10 = X_ATTRIBUTE_NAME10)
443 OR ((tlinfo.ATTRIBUTE_NAME10 is null) AND (X_ATTRIBUTE_NAME10 is null)))
444 AND ((tlinfo.ATTRIBUTE_NAME11 = X_ATTRIBUTE_NAME11)
445 OR ((tlinfo.ATTRIBUTE_NAME11 is null) AND (X_ATTRIBUTE_NAME11 is null)))
446 AND ((tlinfo.ATTRIBUTE_NAME12 = X_ATTRIBUTE_NAME12)
447 OR ((tlinfo.ATTRIBUTE_NAME12 is null) AND (X_ATTRIBUTE_NAME12 is null)))
448 AND ((tlinfo.ATTRIBUTE_NAME13 = X_ATTRIBUTE_NAME13)
449 OR ((tlinfo.ATTRIBUTE_NAME13 is null) AND (X_ATTRIBUTE_NAME13 is null)))
450 AND ((tlinfo.ATTRIBUTE_NAME14 = X_ATTRIBUTE_NAME14)
451 OR ((tlinfo.ATTRIBUTE_NAME14 is null) AND (X_ATTRIBUTE_NAME14 is null)))
452 AND ((tlinfo.ATTRIBUTE_NAME15 = X_ATTRIBUTE_NAME15)
453 OR ((tlinfo.ATTRIBUTE_NAME15 is null) AND (X_ATTRIBUTE_NAME15 is null)))
454 AND ((tlinfo.ATTRIBUTE_NAME16 = X_ATTRIBUTE_NAME16)
455 OR ((tlinfo.ATTRIBUTE_NAME16 is null) AND (X_ATTRIBUTE_NAME16 is null)))
456 AND ((tlinfo.ATTRIBUTE_NAME17 = X_ATTRIBUTE_NAME17)
457 OR ((tlinfo.ATTRIBUTE_NAME17 is null) AND (X_ATTRIBUTE_NAME17 is null)))
458 AND ((tlinfo.ATTRIBUTE_NAME18 = X_ATTRIBUTE_NAME18)
459 OR ((tlinfo.ATTRIBUTE_NAME18 is null) AND (X_ATTRIBUTE_NAME18 is null)))
460 AND ((tlinfo.ATTRIBUTE_NAME19 = X_ATTRIBUTE_NAME19)
461 OR ((tlinfo.ATTRIBUTE_NAME19 is null) AND (X_ATTRIBUTE_NAME19 is null)))
462 AND ((tlinfo.ATTRIBUTE_NAME20 = X_ATTRIBUTE_NAME20)
463 OR ((tlinfo.ATTRIBUTE_NAME20 is null) AND (X_ATTRIBUTE_NAME20 is null)))
464 AND ((tlinfo.ATTRIBUTE_NAME21 = X_ATTRIBUTE_NAME21)
465 OR ((tlinfo.ATTRIBUTE_NAME21 is null) AND (X_ATTRIBUTE_NAME21 is null)))
466 AND ((tlinfo.ATTRIBUTE_NAME22 = X_ATTRIBUTE_NAME22)
467 OR ((tlinfo.ATTRIBUTE_NAME22 is null) AND (X_ATTRIBUTE_NAME22 is null)))
468 AND ((tlinfo.ATTRIBUTE_NAME23 = X_ATTRIBUTE_NAME23)
469 OR ((tlinfo.ATTRIBUTE_NAME23 is null) AND (X_ATTRIBUTE_NAME23 is null)))
470 AND ((tlinfo.ATTRIBUTE_NAME24 = X_ATTRIBUTE_NAME24)
471 OR ((tlinfo.ATTRIBUTE_NAME24 is null) AND (X_ATTRIBUTE_NAME24 is null)))
472 AND ((tlinfo.ATTRIBUTE_NAME25 = X_ATTRIBUTE_NAME25)
473 OR ((tlinfo.ATTRIBUTE_NAME25 is null) AND (X_ATTRIBUTE_NAME25 is null)))
474 AND ((tlinfo.ATTRIBUTE_NAME26 = X_ATTRIBUTE_NAME26)
475 OR ((tlinfo.ATTRIBUTE_NAME26 is null) AND (X_ATTRIBUTE_NAME26 is null)))
476 AND ((tlinfo.ATTRIBUTE_NAME27 = X_ATTRIBUTE_NAME27)
477 OR ((tlinfo.ATTRIBUTE_NAME27 is null) AND (X_ATTRIBUTE_NAME27 is null)))
478 AND ((tlinfo.ATTRIBUTE_NAME28 = X_ATTRIBUTE_NAME28)
479 OR ((tlinfo.ATTRIBUTE_NAME28 is null) AND (X_ATTRIBUTE_NAME28 is null)))
480 AND ((tlinfo.ATTRIBUTE_NAME29 = X_ATTRIBUTE_NAME29)
481 OR ((tlinfo.ATTRIBUTE_NAME29 is null) AND (X_ATTRIBUTE_NAME29 is null)))
482 AND ((tlinfo.ATTRIBUTE_NAME30 = X_ATTRIBUTE_NAME30)
483 OR ((tlinfo.ATTRIBUTE_NAME30 is null) AND (X_ATTRIBUTE_NAME30 is null)))
484 ) then
485 null;
486 else
487 fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
488 app_exception.raise_exception;
489 end if;
490 end loop;
491 return;
492 end LOCK_ROW;
493
494 procedure UPDATE_ROW (
495 X_APPLICATION_ID in NUMBER,
496 X_ATTRIBUTE_CODE in VARCHAR2,
497 X_OBJECT_VERSION_NUMBER in NUMBER,
498 X_ATTRIBUTE1 in VARCHAR2,
499 X_ATTRIBUTE2 in VARCHAR2,
500 X_ATTRIBUTE3 in VARCHAR2,
501 X_ATTRIBUTE4 in VARCHAR2,
502 X_ATTRIBUTE5 in VARCHAR2,
503 X_ATTRIBUTE6 in VARCHAR2,
504 X_ATTRIBUTE7 in VARCHAR2,
505 X_ATTRIBUTE8 in VARCHAR2,
506 X_ATTRIBUTE9 in VARCHAR2,
507 X_ATTRIBUTE10 in VARCHAR2,
508 X_ATTRIBUTE11 in VARCHAR2,
509 X_ATTRIBUTE12 in VARCHAR2,
510 X_ATTRIBUTE13 in VARCHAR2,
511 X_ATTRIBUTE14 in VARCHAR2,
512 X_ATTRIBUTE15 in VARCHAR2,
513 X_ATTRIBUTE16 in VARCHAR2,
514 X_ATTRIBUTE17 in VARCHAR2,
515 X_ATTRIBUTE18 in VARCHAR2,
516 X_ATTRIBUTE19 in VARCHAR2,
517 X_ATTRIBUTE20 in VARCHAR2,
518 X_ATTRIBUTE21 in VARCHAR2,
519 X_ATTRIBUTE22 in VARCHAR2,
520 X_ATTRIBUTE23 in VARCHAR2,
521 X_ATTRIBUTE24 in VARCHAR2,
522 X_ATTRIBUTE25 in VARCHAR2,
523 X_ATTRIBUTE26 in VARCHAR2,
524 X_ATTRIBUTE27 in VARCHAR2,
525 X_ATTRIBUTE28 in VARCHAR2,
526 X_ATTRIBUTE29 in VARCHAR2,
527 X_ATTRIBUTE30 in VARCHAR2,
528 X_LAST_UPDATE_DATE in DATE,
529 X_LAST_UPDATED_BY in NUMBER,
530 X_LAST_UPDATE_LOGIN in NUMBER,
531 X_ATTRIBUTE_NAME1 in VARCHAR2,
532 X_ATTRIBUTE_NAME2 in VARCHAR2,
533 X_ATTRIBUTE_NAME3 in VARCHAR2,
534 X_ATTRIBUTE_NAME4 in VARCHAR2,
535 X_ATTRIBUTE_NAME5 in VARCHAR2,
536 X_ATTRIBUTE_NAME6 in VARCHAR2,
537 X_ATTRIBUTE_NAME7 in VARCHAR2,
538 X_ATTRIBUTE_NAME8 in VARCHAR2,
539 X_ATTRIBUTE_NAME9 in VARCHAR2,
540 X_ATTRIBUTE_NAME10 in VARCHAR2,
541 X_ATTRIBUTE_NAME11 in VARCHAR2,
542 X_ATTRIBUTE_NAME12 in VARCHAR2,
543 X_ATTRIBUTE_NAME13 in VARCHAR2,
544 X_ATTRIBUTE_NAME14 in VARCHAR2,
545 X_ATTRIBUTE_NAME15 in VARCHAR2,
546 X_ATTRIBUTE_NAME16 in VARCHAR2,
547 X_ATTRIBUTE_NAME17 in VARCHAR2,
548 X_ATTRIBUTE_NAME18 in VARCHAR2,
549 X_ATTRIBUTE_NAME19 in VARCHAR2,
550 X_ATTRIBUTE_NAME20 in VARCHAR2,
551 X_ATTRIBUTE_NAME21 in VARCHAR2,
552 X_ATTRIBUTE_NAME22 in VARCHAR2,
553 X_ATTRIBUTE_NAME23 in VARCHAR2,
554 X_ATTRIBUTE_NAME24 in VARCHAR2,
555 X_ATTRIBUTE_NAME25 in VARCHAR2,
556 X_ATTRIBUTE_NAME26 in VARCHAR2,
557 X_ATTRIBUTE_NAME27 in VARCHAR2,
558 X_ATTRIBUTE_NAME28 in VARCHAR2,
559 X_ATTRIBUTE_NAME29 in VARCHAR2,
560 X_ATTRIBUTE_NAME30 in VARCHAR2
561 ) is
562 begin
563 update BNE_ATTRIBUTES set
564 OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
565 ATTRIBUTE1 = X_ATTRIBUTE1,
566 ATTRIBUTE2 = X_ATTRIBUTE2,
570 ATTRIBUTE6 = X_ATTRIBUTE6,
567 ATTRIBUTE3 = X_ATTRIBUTE3,
568 ATTRIBUTE4 = X_ATTRIBUTE4,
569 ATTRIBUTE5 = X_ATTRIBUTE5,
571 ATTRIBUTE7 = X_ATTRIBUTE7,
572 ATTRIBUTE8 = X_ATTRIBUTE8,
573 ATTRIBUTE9 = X_ATTRIBUTE9,
574 ATTRIBUTE10 = X_ATTRIBUTE10,
575 ATTRIBUTE11 = X_ATTRIBUTE11,
576 ATTRIBUTE12 = X_ATTRIBUTE12,
577 ATTRIBUTE13 = X_ATTRIBUTE13,
578 ATTRIBUTE14 = X_ATTRIBUTE14,
579 ATTRIBUTE15 = X_ATTRIBUTE15,
580 ATTRIBUTE16 = X_ATTRIBUTE16,
581 ATTRIBUTE17 = X_ATTRIBUTE17,
582 ATTRIBUTE18 = X_ATTRIBUTE18,
583 ATTRIBUTE19 = X_ATTRIBUTE19,
584 ATTRIBUTE20 = X_ATTRIBUTE20,
585 ATTRIBUTE21 = X_ATTRIBUTE21,
586 ATTRIBUTE22 = X_ATTRIBUTE22,
587 ATTRIBUTE23 = X_ATTRIBUTE23,
588 ATTRIBUTE24 = X_ATTRIBUTE24,
589 ATTRIBUTE25 = X_ATTRIBUTE25,
590 ATTRIBUTE26 = X_ATTRIBUTE26,
591 ATTRIBUTE27 = X_ATTRIBUTE27,
592 ATTRIBUTE28 = X_ATTRIBUTE28,
593 ATTRIBUTE29 = X_ATTRIBUTE29,
594 ATTRIBUTE30 = X_ATTRIBUTE30,
595 ATTRIBUTE_NAME1 = X_ATTRIBUTE_NAME1,
596 ATTRIBUTE_NAME2 = X_ATTRIBUTE_NAME2,
597 ATTRIBUTE_NAME3 = X_ATTRIBUTE_NAME3,
598 ATTRIBUTE_NAME4 = X_ATTRIBUTE_NAME4,
599 ATTRIBUTE_NAME5 = X_ATTRIBUTE_NAME5,
600 ATTRIBUTE_NAME6 = X_ATTRIBUTE_NAME6,
601 ATTRIBUTE_NAME7 = X_ATTRIBUTE_NAME7,
602 ATTRIBUTE_NAME8 = X_ATTRIBUTE_NAME8,
603 ATTRIBUTE_NAME9 = X_ATTRIBUTE_NAME9,
604 ATTRIBUTE_NAME10 = X_ATTRIBUTE_NAME10,
605 ATTRIBUTE_NAME11 = X_ATTRIBUTE_NAME11,
606 ATTRIBUTE_NAME12 = X_ATTRIBUTE_NAME12,
607 ATTRIBUTE_NAME13 = X_ATTRIBUTE_NAME13,
608 ATTRIBUTE_NAME14 = X_ATTRIBUTE_NAME14,
609 ATTRIBUTE_NAME15 = X_ATTRIBUTE_NAME15,
610 ATTRIBUTE_NAME16 = X_ATTRIBUTE_NAME16,
611 ATTRIBUTE_NAME17 = X_ATTRIBUTE_NAME17,
612 ATTRIBUTE_NAME18 = X_ATTRIBUTE_NAME18,
613 ATTRIBUTE_NAME19 = X_ATTRIBUTE_NAME19,
614 ATTRIBUTE_NAME20 = X_ATTRIBUTE_NAME20,
615 ATTRIBUTE_NAME21 = X_ATTRIBUTE_NAME21,
616 ATTRIBUTE_NAME22 = X_ATTRIBUTE_NAME22,
617 ATTRIBUTE_NAME23 = X_ATTRIBUTE_NAME23,
618 ATTRIBUTE_NAME24 = X_ATTRIBUTE_NAME24,
619 ATTRIBUTE_NAME25 = X_ATTRIBUTE_NAME25,
620 ATTRIBUTE_NAME26 = X_ATTRIBUTE_NAME26,
621 ATTRIBUTE_NAME27 = X_ATTRIBUTE_NAME27,
622 ATTRIBUTE_NAME28 = X_ATTRIBUTE_NAME28,
623 ATTRIBUTE_NAME29 = X_ATTRIBUTE_NAME29,
624 ATTRIBUTE_NAME30 = X_ATTRIBUTE_NAME30,
625 LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
626 LAST_UPDATED_BY = X_LAST_UPDATED_BY,
627 LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
628 where APPLICATION_ID = X_APPLICATION_ID
629 and ATTRIBUTE_CODE = X_ATTRIBUTE_CODE;
630
631 if (sql%notfound) then
632 raise no_data_found;
633 end if;
634 end UPDATE_ROW;
635
636 procedure DELETE_ROW (
637 X_APPLICATION_ID in NUMBER,
638 X_ATTRIBUTE_CODE in VARCHAR2
639 ) is
640 begin
641 delete from BNE_ATTRIBUTES
642 where APPLICATION_ID = X_APPLICATION_ID
643 and ATTRIBUTE_CODE = X_ATTRIBUTE_CODE;
644
645 if (sql%notfound) then
646 raise no_data_found;
647 end if;
648
649 end DELETE_ROW;
650
651 procedure ADD_LANGUAGE
652 is
653 begin
654 null;
655 end ADD_LANGUAGE;
656
657 --------------------------------------------------------------------------------
658 -- PROCEDURE: LOAD_ROW --
659 -- --
660 -- DESCRIPTION: Load a row into the BNE_ATTRIBUTES entity. --
661 -- This proc is called from the apps loader. --
662 -- --
663 -- SEE: http://www-apps.us.oracle.com/atg/plans/r115/fndloadqr.txt --
664 -- --
665 -- --
666 -- MODIFICATION HISTORY --
667 -- Date Username Description --
668 -- 1-Oct-02 DGROVES CREATED --
669 --------------------------------------------------------------------------------
670
671
672 procedure LOAD_ROW(
673 x_attribute_asn IN VARCHAR2,
674 x_attribute_code IN VARCHAR2,
675 x_object_version_number IN VARCHAR2,
676 x_attribute1 IN VARCHAR2,
677 x_attribute2 IN VARCHAR2,
678 x_attribute3 IN VARCHAR2,
679 x_attribute4 IN VARCHAR2,
680 x_attribute5 IN VARCHAR2,
681 x_attribute6 IN VARCHAR2,
682 x_attribute7 IN VARCHAR2,
683 x_attribute8 IN VARCHAR2,
684 x_attribute9 IN VARCHAR2,
685 x_attribute10 IN VARCHAR2,
686 x_attribute11 IN VARCHAR2,
687 x_attribute12 IN VARCHAR2,
688 x_attribute13 IN VARCHAR2,
689 x_attribute14 IN VARCHAR2,
690 x_attribute15 IN VARCHAR2,
691 x_attribute16 IN VARCHAR2,
692 x_attribute17 IN VARCHAR2,
693 x_attribute18 IN VARCHAR2,
694 x_attribute19 IN VARCHAR2,
695 x_attribute20 IN VARCHAR2,
696 x_attribute21 IN VARCHAR2,
697 x_attribute22 IN VARCHAR2,
698 x_attribute23 IN VARCHAR2,
699 x_attribute24 IN VARCHAR2,
700 x_attribute25 IN VARCHAR2,
701 x_attribute26 IN VARCHAR2,
702 x_attribute27 IN VARCHAR2,
703 x_attribute28 IN VARCHAR2,
704 x_attribute29 IN VARCHAR2,
705 x_attribute30 IN VARCHAR2,
706 x_owner IN VARCHAR2,
710 X_ATTRIBUTE_NAME2 in VARCHAR2,
707 x_last_update_date IN VARCHAR2,
708 x_custom_mode IN VARCHAR2,
709 X_ATTRIBUTE_NAME1 in VARCHAR2,
711 X_ATTRIBUTE_NAME3 in VARCHAR2,
712 X_ATTRIBUTE_NAME4 in VARCHAR2,
713 X_ATTRIBUTE_NAME5 in VARCHAR2,
714 X_ATTRIBUTE_NAME6 in VARCHAR2,
715 X_ATTRIBUTE_NAME7 in VARCHAR2,
716 X_ATTRIBUTE_NAME8 in VARCHAR2,
717 X_ATTRIBUTE_NAME9 in VARCHAR2,
718 X_ATTRIBUTE_NAME10 in VARCHAR2,
719 X_ATTRIBUTE_NAME11 in VARCHAR2,
720 X_ATTRIBUTE_NAME12 in VARCHAR2,
721 X_ATTRIBUTE_NAME13 in VARCHAR2,
722 X_ATTRIBUTE_NAME14 in VARCHAR2,
723 X_ATTRIBUTE_NAME15 in VARCHAR2,
724 X_ATTRIBUTE_NAME16 in VARCHAR2,
725 X_ATTRIBUTE_NAME17 in VARCHAR2,
726 X_ATTRIBUTE_NAME18 in VARCHAR2,
727 X_ATTRIBUTE_NAME19 in VARCHAR2,
728 X_ATTRIBUTE_NAME20 in VARCHAR2,
729 X_ATTRIBUTE_NAME21 in VARCHAR2,
730 X_ATTRIBUTE_NAME22 in VARCHAR2,
731 X_ATTRIBUTE_NAME23 in VARCHAR2,
732 X_ATTRIBUTE_NAME24 in VARCHAR2,
733 X_ATTRIBUTE_NAME25 in VARCHAR2,
734 X_ATTRIBUTE_NAME26 in VARCHAR2,
735 X_ATTRIBUTE_NAME27 in VARCHAR2,
736 X_ATTRIBUTE_NAME28 in VARCHAR2,
737 X_ATTRIBUTE_NAME29 in VARCHAR2,
738 X_ATTRIBUTE_NAME30 in VARCHAR2
739 )
740 is
741 l_app_id number;
742 l_row_id varchar2(64);
743 f_luby number; -- entity owner in file
744 f_ludate date; -- entity update date in file
745 db_luby number; -- entity owner in db
746 db_ludate date; -- entity update date in db
747 begin
748 -- translate values to IDs
749 l_app_id := BNE_LCT_TOOLS_PKG.ASN_TO_APP_ID(x_attribute_asn);
750
751 -- Translate owner to file_last_updated_by
752 f_luby := fnd_load_util.owner_id(x_owner);
753
754 -- Translate char last_update_date to date
755 f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
756 begin
757 select LAST_UPDATED_BY, LAST_UPDATE_DATE
758 into db_luby, db_ludate
759 from BNE_ATTRIBUTES
760 where APPLICATION_ID = l_app_id
761 and ATTRIBUTE_CODE = x_attribute_code;
762
763 -- Test for customization and version
764 if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
765 db_ludate, x_custom_mode)) then
766 -- Update existing row
767
768 BNE_ATTRIBUTES_PKG.Update_Row(
769 X_APPLICATION_ID => l_app_id,
770 X_ATTRIBUTE_CODE => x_attribute_code,
771 X_OBJECT_VERSION_NUMBER => x_object_version_number,
772 X_ATTRIBUTE1 => x_attribute1,
773 X_ATTRIBUTE2 => x_attribute2,
774 X_ATTRIBUTE3 => x_attribute3,
775 X_ATTRIBUTE4 => x_attribute4,
776 X_ATTRIBUTE5 => x_attribute5,
777 X_ATTRIBUTE6 => x_attribute6,
778 X_ATTRIBUTE7 => x_attribute7,
779 X_ATTRIBUTE8 => x_attribute8,
780 X_ATTRIBUTE9 => x_attribute9,
781 X_ATTRIBUTE10 => x_attribute10,
782 X_ATTRIBUTE11 => x_attribute11,
783 X_ATTRIBUTE12 => x_attribute12,
784 X_ATTRIBUTE13 => x_attribute13,
785 X_ATTRIBUTE14 => x_attribute14,
786 X_ATTRIBUTE15 => x_attribute15,
787 X_ATTRIBUTE16 => x_attribute16,
788 X_ATTRIBUTE17 => x_attribute17,
789 X_ATTRIBUTE18 => x_attribute18,
790 X_ATTRIBUTE19 => x_attribute19,
791 X_ATTRIBUTE20 => x_attribute20,
792 X_ATTRIBUTE21 => x_attribute21,
793 X_ATTRIBUTE22 => x_attribute22,
794 X_ATTRIBUTE23 => x_attribute23,
795 X_ATTRIBUTE24 => x_attribute24,
796 X_ATTRIBUTE25 => x_attribute25,
797 X_ATTRIBUTE26 => x_attribute26,
798 X_ATTRIBUTE27 => x_attribute27,
799 X_ATTRIBUTE28 => x_attribute28,
800 X_ATTRIBUTE29 => x_attribute29,
801 X_ATTRIBUTE30 => x_attribute30,
802 X_ATTRIBUTE_NAME1 => x_attribute_name1,
803 X_ATTRIBUTE_NAME2 => x_attribute_name2,
804 X_ATTRIBUTE_NAME3 => x_attribute_name3,
805 X_ATTRIBUTE_NAME4 => x_attribute_name4,
806 X_ATTRIBUTE_NAME5 => x_attribute_name5,
807 X_ATTRIBUTE_NAME6 => x_attribute_name6,
808 X_ATTRIBUTE_NAME7 => x_attribute_name7,
809 X_ATTRIBUTE_NAME8 => x_attribute_name8,
810 X_ATTRIBUTE_NAME9 => x_attribute_name9,
811 X_ATTRIBUTE_NAME10 => x_attribute_name10,
812 X_ATTRIBUTE_NAME11 => x_attribute_name11,
813 X_ATTRIBUTE_NAME12 => x_attribute_name12,
814 X_ATTRIBUTE_NAME13 => x_attribute_name13,
815 X_ATTRIBUTE_NAME14 => x_attribute_name14,
816 X_ATTRIBUTE_NAME15 => x_attribute_name15,
817 X_ATTRIBUTE_NAME16 => x_attribute_name16,
818 X_ATTRIBUTE_NAME17 => x_attribute_name17,
819 X_ATTRIBUTE_NAME18 => x_attribute_name18,
820 X_ATTRIBUTE_NAME19 => x_attribute_name19,
821 X_ATTRIBUTE_NAME20 => x_attribute_name20,
822 X_ATTRIBUTE_NAME21 => x_attribute_name21,
823 X_ATTRIBUTE_NAME22 => x_attribute_name22,
824 X_ATTRIBUTE_NAME23 => x_attribute_name23,
825 X_ATTRIBUTE_NAME24 => x_attribute_name24,
826 X_ATTRIBUTE_NAME25 => x_attribute_name25,
827 X_ATTRIBUTE_NAME26 => x_attribute_name26,
828 X_ATTRIBUTE_NAME27 => x_attribute_name27,
832 X_LAST_UPDATE_DATE => f_ludate,
829 X_ATTRIBUTE_NAME28 => x_attribute_name28,
830 X_ATTRIBUTE_NAME29 => x_attribute_name29,
831 X_ATTRIBUTE_NAME30 => x_attribute_name30,
833 X_LAST_UPDATED_BY => f_luby,
834 X_LAST_UPDATE_LOGIN => 0
835 );
836 end if;
837 exception
838 when no_data_found then
839 -- Record doesn't exist - insert in all cases
840 BNE_ATTRIBUTES_PKG.Insert_Row(
841 X_ROWID => l_row_id,
842 X_APPLICATION_ID => l_app_id,
843 X_ATTRIBUTE_CODE => x_attribute_code,
844 X_OBJECT_VERSION_NUMBER => x_object_version_number,
845 X_ATTRIBUTE1 => x_attribute1,
846 X_ATTRIBUTE2 => x_attribute2,
847 X_ATTRIBUTE3 => x_attribute3,
848 X_ATTRIBUTE4 => x_attribute4,
849 X_ATTRIBUTE5 => x_attribute5,
850 X_ATTRIBUTE6 => x_attribute6,
851 X_ATTRIBUTE7 => x_attribute7,
852 X_ATTRIBUTE8 => x_attribute8,
853 X_ATTRIBUTE9 => x_attribute9,
854 X_ATTRIBUTE10 => x_attribute10,
855 X_ATTRIBUTE11 => x_attribute11,
856 X_ATTRIBUTE12 => x_attribute12,
857 X_ATTRIBUTE13 => x_attribute13,
858 X_ATTRIBUTE14 => x_attribute14,
859 X_ATTRIBUTE15 => x_attribute15,
860 X_ATTRIBUTE16 => x_attribute16,
861 X_ATTRIBUTE17 => x_attribute17,
862 X_ATTRIBUTE18 => x_attribute18,
863 X_ATTRIBUTE19 => x_attribute19,
864 X_ATTRIBUTE20 => x_attribute20,
865 X_ATTRIBUTE21 => x_attribute21,
866 X_ATTRIBUTE22 => x_attribute22,
867 X_ATTRIBUTE23 => x_attribute23,
868 X_ATTRIBUTE24 => x_attribute24,
869 X_ATTRIBUTE25 => x_attribute25,
870 X_ATTRIBUTE26 => x_attribute26,
871 X_ATTRIBUTE27 => x_attribute27,
872 X_ATTRIBUTE28 => x_attribute28,
873 X_ATTRIBUTE29 => x_attribute29,
874 X_ATTRIBUTE30 => x_attribute30,
875 X_ATTRIBUTE_NAME1 => x_attribute_name1,
876 X_ATTRIBUTE_NAME2 => x_attribute_name2,
877 X_ATTRIBUTE_NAME3 => x_attribute_name3,
878 X_ATTRIBUTE_NAME4 => x_attribute_name4,
879 X_ATTRIBUTE_NAME5 => x_attribute_name5,
880 X_ATTRIBUTE_NAME6 => x_attribute_name6,
881 X_ATTRIBUTE_NAME7 => x_attribute_name7,
882 X_ATTRIBUTE_NAME8 => x_attribute_name8,
883 X_ATTRIBUTE_NAME9 => x_attribute_name9,
884 X_ATTRIBUTE_NAME10 => x_attribute_name10,
885 X_ATTRIBUTE_NAME11 => x_attribute_name11,
886 X_ATTRIBUTE_NAME12 => x_attribute_name12,
887 X_ATTRIBUTE_NAME13 => x_attribute_name13,
888 X_ATTRIBUTE_NAME14 => x_attribute_name14,
889 X_ATTRIBUTE_NAME15 => x_attribute_name15,
890 X_ATTRIBUTE_NAME16 => x_attribute_name16,
891 X_ATTRIBUTE_NAME17 => x_attribute_name17,
892 X_ATTRIBUTE_NAME18 => x_attribute_name18,
893 X_ATTRIBUTE_NAME19 => x_attribute_name19,
894 X_ATTRIBUTE_NAME20 => x_attribute_name20,
895 X_ATTRIBUTE_NAME21 => x_attribute_name21,
896 X_ATTRIBUTE_NAME22 => x_attribute_name22,
897 X_ATTRIBUTE_NAME23 => x_attribute_name23,
898 X_ATTRIBUTE_NAME24 => x_attribute_name24,
899 X_ATTRIBUTE_NAME25 => x_attribute_name25,
900 X_ATTRIBUTE_NAME26 => x_attribute_name26,
901 X_ATTRIBUTE_NAME27 => x_attribute_name27,
902 X_ATTRIBUTE_NAME28 => x_attribute_name28,
903 X_ATTRIBUTE_NAME29 => x_attribute_name29,
904 X_ATTRIBUTE_NAME30 => x_attribute_name30,
905 X_CREATION_DATE => f_ludate,
906 X_CREATED_BY => f_luby,
907 X_LAST_UPDATE_DATE => f_ludate,
908 X_LAST_UPDATED_BY => f_luby,
909 X_LAST_UPDATE_LOGIN => 0
910 );
911 end;
912 end LOAD_ROW;
913
914 end BNE_ATTRIBUTES_PKG;