[Home] [Help]
PACKAGE BODY: APPS.JTF_AMV_ITEMS_PKG
Source
1 package body JTF_AMV_ITEMS_PKG as
2 /* $Header: jtfvitmb.pls 120.4 2006/01/16 01:42:50 vimohan ship $ */
3 procedure Load_Row(
4 X_ITEM_ID in VARCHAR2,
5 x_object_version_number in varchar2,
6 X_STATUS_CODE in VARCHAR2,
7 X_EFFECTIVE_START_DATE in VARCHAR2,
8 X_EXPIRATION_DATE in VARCHAR2,
9 X_APPLICATION_ID in VARCHAR2,
10 X_EXTERNAL_ACCESS_FLAG in VARCHAR2,
11 X_PRIORITY in VARCHAR2,
12 X_PUBLICATION_DATE in VARCHAR2,
13 X_LANGUAGE_CODE in VARCHAR2,
14 X_ITEM_TYPE in VARCHAR2,
15 X_URL_STRING in VARCHAR2,
16 X_CONTENT_TYPE_ID in VARCHAR2,
17 X_OWNER_ID in VARCHAR2,
18 X_DEFAULT_APPROVER_ID in VARCHAR2,
19 X_ITEM_DESTINATION_TYPE in VARCHAR2,
20 X_ACCESS_NAME in VARCHAR2,
21 X_DELIVERABLE_TYPE_CODE in VARCHAR2,
22 X_APPLICABLE_TO_CODE in VARCHAR2,
23 X_ATTRIBUTE_CATEGORY in VARCHAR2,
24 X_ATTRIBUTE1 in VARCHAR2,
25 X_ATTRIBUTE2 in VARCHAR2,
26 X_ATTRIBUTE3 in VARCHAR2,
27 X_ATTRIBUTE4 in VARCHAR2,
28 X_ATTRIBUTE5 in VARCHAR2,
29 X_ATTRIBUTE6 in VARCHAR2,
30 X_ATTRIBUTE7 in VARCHAR2,
31 X_ATTRIBUTE8 in VARCHAR2,
32 X_ATTRIBUTE9 in VARCHAR2,
33 X_ATTRIBUTE10 in VARCHAR2,
34 X_ATTRIBUTE11 in VARCHAR2,
35 X_ATTRIBUTE12 in VARCHAR2,
36 X_ATTRIBUTE13 in VARCHAR2,
37 X_ATTRIBUTE14 in VARCHAR2,
38 X_ATTRIBUTE15 in VARCHAR2,
39 X_ITEM_NAME in VARCHAR2,
40 X_DESCRIPTION in VARCHAR2,
41 X_TEXT_STRING in VARCHAR2,
42 X_OWNER in VARCHAR2,
43 X_CUSTOM_MODE in VARCHAR2 DEFAULT NULL,
44 X_LAST_UPDATE_DATE in VARCHAR2 DEFAULT NULL
45 ) AS
46 l_user_id number := fnd_load_util.owner_id(x_owner);
47 L_ITEM_ID NUMBER;
48 L_OBJECT_VERSION_NUMBER NUMBER;
49 L_APPLICATION_ID NUMBER;
50 L_EFFECTIVE_START_DATE DATE;
51 L_EXPIRATION_DATE DATE;
52 L_PUBLICATION_DATE DATE;
53 L_CONTENT_TYPE_ID NUMBER;
54 L_OWNER_ID NUMBER;
55 L_DEFAULT_APPROVER_ID NUMBER;
56 l_row_id VARCHAR2(2000);
57
58 f_luby number; -- entity owner in file
59 f_ludate date; -- entity update date in file
60 db_luby number; -- entity owner in db
61 db_ludate date; -- entity update date in db
62
63
64
65 BEGIN
66
67 --if (X_OWNER = 'SEED') then
68 -- l_user_id := 1;
69 --end if;
70 L_ITEM_ID := to_number(X_ITEM_ID);
71 L_OBJECT_VERSION_NUMBER := to_number(X_OBJECT_VERSION_NUMBER);
72 L_APPLICATION_ID := to_number(X_APPLICATION_ID);
73 L_EFFECTIVE_START_DATE := TO_DATE(X_EFFECTIVE_START_DATE, 'DD-MM-YYYY');
74 L_EXPIRATION_DATE := TO_DATE(X_EXPIRATION_DATE, 'DD-MM-YYYY');
75 L_PUBLICATION_DATE := TO_DATE(X_PUBLICATION_DATE, 'DD-MM-YYYY');
76 L_CONTENT_TYPE_ID := to_number(X_CONTENT_TYPE_ID);
77 L_OWNER_ID := to_number(X_OWNER_ID);
78 L_DEFAULT_APPROVER_ID := to_number(X_DEFAULT_APPROVER_ID);
79
80 -- Translate owner to file_last_updated_by
81 f_luby := fnd_load_util.owner_id(x_owner);
82
83 -- Translate char last_update_date to date
84 f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
85
86 -- This select stmnt also checks if
87 -- there is a row for this app_id and this app_short_name
88 -- Exception is thrown otherwise.
89
90 select LAST_UPDATED_BY, LAST_UPDATE_DATE
91 into db_luby, db_ludate
92 FROM JTF_AMV_ITEMS_B
93 where ITEM_ID = X_ITEM_ID;
94
95 if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
96 db_ludate, X_CUSTOM_MODE)) then
97
98 UPDATE_ROW (
99 X_ITEM_ID => l_ITEM_ID,
100 X_OBJECT_VERSION_NUMBER => l_OBJECT_VERSION_NUMBER,
101 X_LAST_UPDATE_DATE => f_ludate,
102 X_LAST_UPDATED_BY => f_luby,
103 X_LAST_UPDATE_LOGIN => l_user_id,
104 X_APPLICATION_ID => l_APPLICATION_ID,
105 X_EXTERNAL_ACCESS_FLAG => X_EXTERNAL_ACCESS_FLAG,
106 X_ITEM_NAME => X_ITEM_NAME,
107 X_DESCRIPTION => X_DESCRIPTION,
108 X_TEXT_STRING => X_TEXT_STRING,
109 X_LANGUAGE_CODE => X_LANGUAGE_CODE,
110 X_STATUS_CODE => X_STATUS_CODE,
111 X_EFFECTIVE_START_DATE => l_EFFECTIVE_START_DATE,
112 X_EXPIRATION_DATE => l_EXPIRATION_DATE,
113 X_ITEM_TYPE => X_ITEM_TYPE,
114 X_URL_STRING => X_URL_STRING,
115 X_PUBLICATION_DATE => l_PUBLICATION_DATE,
116 X_PRIORITY => X_PRIORITY,
117 X_CONTENT_TYPE_ID => l_CONTENT_TYPE_ID,
118 X_OWNER_ID => l_OWNER_ID,
119 X_DEFAULT_APPROVER_ID => l_DEFAULT_APPROVER_ID,
120 X_ITEM_DESTINATION_TYPE => X_ITEM_DESTINATION_TYPE,
121 X_ACCESS_NAME => X_ACCESS_NAME,
122 X_DELIVERABLE_TYPE_CODE => X_DELIVERABLE_TYPE_CODE,
123 X_APPLICABLE_TO_CODE => X_APPLICABLE_TO_CODE,
124 X_ATTRIBUTE_CATEGORY => X_ATTRIBUTE_CATEGORY,
125 X_ATTRIBUTE1 => X_ATTRIBUTE1,
126 X_ATTRIBUTE2 => X_ATTRIBUTE2,
127 X_ATTRIBUTE3 => X_ATTRIBUTE3,
128 X_ATTRIBUTE4 => X_ATTRIBUTE4,
129 X_ATTRIBUTE5 => X_ATTRIBUTE5,
130 X_ATTRIBUTE6 => X_ATTRIBUTE6,
131 X_ATTRIBUTE7 => X_ATTRIBUTE7,
132 X_ATTRIBUTE8 => X_ATTRIBUTE8,
133 X_ATTRIBUTE9 => X_ATTRIBUTE9,
134 X_ATTRIBUTE10 => X_ATTRIBUTE10,
135 X_ATTRIBUTE11 => X_ATTRIBUTE11,
136 X_ATTRIBUTE12 => X_ATTRIBUTE12,
137 X_ATTRIBUTE13 => X_ATTRIBUTE13,
138 X_ATTRIBUTE14 => X_ATTRIBUTE14,
139 X_ATTRIBUTE15 => X_ATTRIBUTE15
140 );
141 end if;
142 exception
143 when NO_DATA_FOUND then
144 INSERT_ROW (
145 X_ROWID => l_row_id,
146 X_ITEM_ID => l_ITEM_ID,
147 X_OBJECT_VERSION_NUMBER => l_OBJECT_VERSION_NUMBER,
148 X_CREATION_DATE => f_ludate,
149 X_CREATED_BY => f_luby,
150 X_LAST_UPDATE_DATE => f_ludate,
151 X_LAST_UPDATED_BY => f_luby,
152 X_LAST_UPDATE_LOGIN => l_user_id,
153 X_APPLICATION_ID => l_APPLICATION_ID,
154 X_EXTERNAL_ACCESS_FLAG => X_EXTERNAL_ACCESS_FLAG,
155 X_ITEM_NAME => X_ITEM_NAME,
156 X_DESCRIPTION => X_DESCRIPTION,
157 X_TEXT_STRING => X_TEXT_STRING,
158 X_LANGUAGE_CODE => X_LANGUAGE_CODE,
159 X_STATUS_CODE => X_STATUS_CODE,
160 X_EFFECTIVE_START_DATE => l_EFFECTIVE_START_DATE,
161 X_EXPIRATION_DATE => l_EXPIRATION_DATE,
162 X_ITEM_TYPE => X_ITEM_TYPE,
163 X_URL_STRING => X_URL_STRING,
164 X_PUBLICATION_DATE => l_PUBLICATION_DATE,
165 X_PRIORITY => X_PRIORITY,
166 X_CONTENT_TYPE_ID => l_CONTENT_TYPE_ID,
167 X_OWNER_ID => l_OWNER_ID,
168 X_DEFAULT_APPROVER_ID => l_DEFAULT_APPROVER_ID,
169 X_ITEM_DESTINATION_TYPE => X_ITEM_DESTINATION_TYPE,
170 X_ACCESS_NAME => X_ACCESS_NAME,
171 X_DELIVERABLE_TYPE_CODE => X_DELIVERABLE_TYPE_CODE,
172 X_APPLICABLE_TO_CODE => X_APPLICABLE_TO_CODE,
173 X_ATTRIBUTE_CATEGORY => X_ATTRIBUTE_CATEGORY,
174 X_ATTRIBUTE1 => X_ATTRIBUTE1,
175 X_ATTRIBUTE2 => X_ATTRIBUTE2,
176 X_ATTRIBUTE3 => X_ATTRIBUTE3,
177 X_ATTRIBUTE4 => X_ATTRIBUTE4,
178 X_ATTRIBUTE5 => X_ATTRIBUTE5,
179 X_ATTRIBUTE6 => X_ATTRIBUTE6,
180 X_ATTRIBUTE7 => X_ATTRIBUTE7,
181 X_ATTRIBUTE8 => X_ATTRIBUTE8,
182 X_ATTRIBUTE9 => X_ATTRIBUTE9,
183 X_ATTRIBUTE10 => X_ATTRIBUTE10,
184 X_ATTRIBUTE11 => X_ATTRIBUTE11,
185 X_ATTRIBUTE12 => X_ATTRIBUTE12,
186 X_ATTRIBUTE13 => X_ATTRIBUTE13,
187 X_ATTRIBUTE14 => X_ATTRIBUTE14,
188 X_ATTRIBUTE15 => X_ATTRIBUTE15
189 );
190 END Load_Row;
191
192
193
194 procedure Translate_row (
195 X_ITEM_ID in NUMBER,
196 X_ITEM_NAME in VARCHAR2,
197 X_DESCRIPTION in VARCHAR2,
198 X_TEXT_STRING in VARCHAR2,
199 X_OWNER in VARCHAR2,
200 X_CUSTOM_MODE in VARCHAR2 DEFAULT NULL,
201 X_LAST_UPDATE_DATE in VARCHAR2 DEFAULT NULL
202 ) AS
203 f_luby number; -- entity owner in file
204 f_ludate date; -- entity update date in file
205 db_luby number; -- entity owner in db
206 db_ludate date; -- entity update date in db
207 begin
208
209 -- Translate owner to file_last_updated_by
210 f_luby := fnd_load_util.owner_id(x_owner);
211
212 -- Translate char last_update_date to date
213 f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
214
215 select LAST_UPDATED_BY, LAST_UPDATE_DATE
216 into db_luby, db_ludate
217 from JTF_AMV_ITEMS_TL
218 where userenv('LANG') in (LANGUAGE, SOURCE_LANG)
219 and ITEM_ID = X_ITEM_ID;
220
221 if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
222 db_ludate, X_CUSTOM_MODE)) then
223
224 update JTF_AMV_ITEMS_TL set
225 ITEM_NAME = X_ITEM_NAME,
226 DESCRIPTION = x_description,
227 TEXT_STRING = X_TEXT_STRING,
228 LAST_UPDATE_DATE = f_ludate,
229 LAST_UPDATED_BY = f_luby,
230 LAST_UPDATE_LOGIN = 0,
231 SOURCE_LANG = userenv('LANG')
232 where userenv('LANG') in (LANGUAGE, SOURCE_LANG)
233 and ITEM_ID = X_ITEM_ID;
234 end if;
235
236 EXCEPTION
237 when no_data_found then
238 null;
239 END Translate_row;
240
241 procedure INSERT_ROW (
242 X_ROWID in out NOCOPY VARCHAR2,
243 X_ITEM_ID in NUMBER,
244 X_OBJECT_VERSION_NUMBER in NUMBER,
245 X_CREATION_DATE in DATE,
246 X_CREATED_BY in NUMBER,
247 X_LAST_UPDATE_DATE in DATE,
248 X_LAST_UPDATED_BY in NUMBER,
249 X_LAST_UPDATE_LOGIN in NUMBER,
250 X_APPLICATION_ID in NUMBER,
251 X_EXTERNAL_ACCESS_FLAG in VARCHAR2,
252 X_ITEM_NAME in VARCHAR2,
253 X_DESCRIPTION in VARCHAR2,
254 X_TEXT_STRING in VARCHAR2,
255 X_LANGUAGE_CODE in VARCHAR2,
256 X_STATUS_CODE in VARCHAR2,
257 X_EFFECTIVE_START_DATE in DATE,
258 X_EXPIRATION_DATE in DATE,
259 X_ITEM_TYPE in VARCHAR2,
260 X_URL_STRING in VARCHAR2,
261 X_PUBLICATION_DATE in DATE,
262 X_PRIORITY in VARCHAR2,
263 X_CONTENT_TYPE_ID in NUMBER,
264 X_OWNER_ID in NUMBER,
265 X_DEFAULT_APPROVER_ID in NUMBER,
266 X_ITEM_DESTINATION_TYPE in VARCHAR2,
267 X_ACCESS_NAME in VARCHAR2,
268 X_DELIVERABLE_TYPE_CODE in VARCHAR2,
269 X_APPLICABLE_TO_CODE in VARCHAR2,
270 X_ATTRIBUTE_CATEGORY in VARCHAR2,
271 X_ATTRIBUTE1 in VARCHAR2,
272 X_ATTRIBUTE2 in VARCHAR2,
273 X_ATTRIBUTE3 in VARCHAR2,
274 X_ATTRIBUTE4 in VARCHAR2,
275 X_ATTRIBUTE5 in VARCHAR2,
276 X_ATTRIBUTE6 in VARCHAR2,
277 X_ATTRIBUTE7 in VARCHAR2,
278 X_ATTRIBUTE8 in VARCHAR2,
279 X_ATTRIBUTE9 in VARCHAR2,
280 X_ATTRIBUTE10 in VARCHAR2,
281 X_ATTRIBUTE11 in VARCHAR2,
282 X_ATTRIBUTE12 in VARCHAR2,
283 X_ATTRIBUTE13 in VARCHAR2,
284 X_ATTRIBUTE14 in VARCHAR2,
285 X_ATTRIBUTE15 in VARCHAR2
286 ) is
287 cursor C is select ROWID from JTF_AMV_ITEMS_B
288 where ITEM_ID = X_ITEM_ID
289 ;
290 begin
291 insert into JTF_AMV_ITEMS_B (
292 ITEM_ID,
293 EXTERNAL_ACCESS_FLAG,
294 PUBLICATION_DATE,
295 OBJECT_VERSION_NUMBER,
296 LANGUAGE_CODE,
297 APPLICATION_ID,
298 STATUS_CODE,
299 EFFECTIVE_START_DATE,
300 EXPIRATION_DATE,
301 ITEM_TYPE,
302 URL_STRING,
303 ATTRIBUTE14,
304 CONTENT_TYPE_ID,
305 OWNER_ID,
306 DEFAULT_APPROVER_ID,
307 ITEM_DESTINATION_TYPE,
308 ATTRIBUTE_CATEGORY,
309 ATTRIBUTE1,
310 ATTRIBUTE2,
311 ATTRIBUTE3,
312 ATTRIBUTE4,
313 ATTRIBUTE5,
314 ATTRIBUTE6,
315 ATTRIBUTE7,
316 ATTRIBUTE15,
317 PRIORITY,
318 ACCESS_NAME,
319 DELIVERABLE_TYPE_CODE,
320 APPLICABLE_TO_CODE,
321 ATTRIBUTE8,
322 ATTRIBUTE9,
323 ATTRIBUTE10,
324 ATTRIBUTE11,
325 ATTRIBUTE12,
326 ATTRIBUTE13,
327 CREATION_DATE,
328 CREATED_BY,
329 LAST_UPDATE_DATE,
330 LAST_UPDATED_BY,
331 LAST_UPDATE_LOGIN
332 ) values (
333 X_ITEM_ID,
334 X_EXTERNAL_ACCESS_FLAG,
335 X_PUBLICATION_DATE,
336 X_OBJECT_VERSION_NUMBER,
337 X_LANGUAGE_CODE,
338 X_APPLICATION_ID,
339 X_STATUS_CODE,
340 X_EFFECTIVE_START_DATE,
341 X_EXPIRATION_DATE,
342 X_ITEM_TYPE,
343 X_URL_STRING,
344 X_ATTRIBUTE14,
345 X_CONTENT_TYPE_ID,
346 X_OWNER_ID,
347 X_DEFAULT_APPROVER_ID,
348 X_ITEM_DESTINATION_TYPE,
349 X_ATTRIBUTE_CATEGORY,
350 X_ATTRIBUTE1,
351 X_ATTRIBUTE2,
352 X_ATTRIBUTE3,
353 X_ATTRIBUTE4,
354 X_ATTRIBUTE5,
355 X_ATTRIBUTE6,
356 X_ATTRIBUTE7,
357 X_ATTRIBUTE15,
358 X_PRIORITY,
359 X_ACCESS_NAME,
360 X_DELIVERABLE_TYPE_CODE,
361 X_APPLICABLE_TO_CODE,
362 X_ATTRIBUTE8,
363 X_ATTRIBUTE9,
364 X_ATTRIBUTE10,
365 X_ATTRIBUTE11,
366 X_ATTRIBUTE12,
367 X_ATTRIBUTE13,
368 X_CREATION_DATE,
369 X_CREATED_BY,
370 X_LAST_UPDATE_DATE,
371 X_LAST_UPDATED_BY,
372 X_LAST_UPDATE_LOGIN
373 );
374
375 insert into JTF_AMV_ITEMS_TL (
376 ITEM_ID,
377 LAST_UPDATE_DATE,
378 LAST_UPDATED_BY,
379 CREATION_DATE,
380 CREATED_BY,
381 LAST_UPDATE_LOGIN,
382 ITEM_NAME,
383 DESCRIPTION,
384 TEXT_STRING,
385 LANGUAGE,
386 SOURCE_LANG
387 ) select
388 X_ITEM_ID,
389 X_LAST_UPDATE_DATE,
390 X_LAST_UPDATED_BY,
391 X_CREATION_DATE,
392 X_CREATED_BY,
393 X_LAST_UPDATE_LOGIN,
394 X_ITEM_NAME,
395 X_DESCRIPTION,
396 X_TEXT_STRING,
397 L.LANGUAGE_CODE,
398 userenv('LANG')
399 from FND_LANGUAGES L
400 where L.INSTALLED_FLAG in ('I', 'B')
401 and not exists
402 (select NULL
403 from JTF_AMV_ITEMS_TL T
404 where T.ITEM_ID = X_ITEM_ID
405 and T.LANGUAGE = L.LANGUAGE_CODE);
406
407 open c;
408 fetch c into X_ROWID;
409 if (c%notfound) then
410 close c;
411 raise no_data_found;
412 end if;
413 close c;
414
415 end INSERT_ROW;
416
417 procedure LOCK_ROW (
418 X_ITEM_ID in NUMBER,
419 X_PRIORITY in VARCHAR2,
420 X_ACCESS_NAME in VARCHAR2,
421 X_DELIVERABLE_TYPE_CODE in VARCHAR2,
422 X_APPLICABLE_TO_CODE in VARCHAR2,
423 X_ITEM_NAME in VARCHAR2,
424 X_DESCRIPTION in VARCHAR2,
425 X_TEXT_STRING in VARCHAR2,
426 X_EXTERNAL_ACCESS_FLAG in VARCHAR2,
427 X_PUBLICATION_DATE in DATE,
428 X_OBJECT_VERSION_NUMBER in NUMBER,
429 X_LANGUAGE_CODE in VARCHAR2,
430 X_APPLICATION_ID in NUMBER,
431 X_STATUS_CODE in VARCHAR2,
432 X_EFFECTIVE_START_DATE in DATE,
433 X_EXPIRATION_DATE in DATE,
434 X_ITEM_TYPE in VARCHAR2,
435 X_URL_STRING in VARCHAR2,
436 X_CONTENT_TYPE_ID in NUMBER,
437 X_OWNER_ID in NUMBER,
438 X_DEFAULT_APPROVER_ID in NUMBER,
439 X_ITEM_DESTINATION_TYPE in VARCHAR2,
440 X_ATTRIBUTE_CATEGORY in VARCHAR2,
441 X_ATTRIBUTE1 in VARCHAR2,
442 X_ATTRIBUTE2 in VARCHAR2,
443 X_ATTRIBUTE3 in VARCHAR2,
444 X_ATTRIBUTE4 in VARCHAR2,
445 X_ATTRIBUTE5 in VARCHAR2,
446 X_ATTRIBUTE6 in VARCHAR2,
450 X_ATTRIBUTE10 in VARCHAR2,
447 X_ATTRIBUTE7 in VARCHAR2,
448 X_ATTRIBUTE8 in VARCHAR2,
449 X_ATTRIBUTE9 in VARCHAR2,
451 X_ATTRIBUTE11 in VARCHAR2,
452 X_ATTRIBUTE12 in VARCHAR2,
453 X_ATTRIBUTE13 in VARCHAR2,
454 X_ATTRIBUTE14 in VARCHAR2,
455 X_ATTRIBUTE15 in VARCHAR2
456 ) is
457 cursor c is select
458 EXTERNAL_ACCESS_FLAG,
459 PUBLICATION_DATE,
460 OBJECT_VERSION_NUMBER,
461 LANGUAGE_CODE,
462 APPLICATION_ID,
463 STATUS_CODE,
464 EFFECTIVE_START_DATE,
465 EXPIRATION_DATE,
466 ITEM_TYPE,
467 URL_STRING,
468 ATTRIBUTE14,
469 CONTENT_TYPE_ID,
470 OWNER_ID,
471 DEFAULT_APPROVER_ID,
472 ITEM_DESTINATION_TYPE,
473 ATTRIBUTE_CATEGORY,
474 ATTRIBUTE1,
475 ATTRIBUTE2,
476 ATTRIBUTE3,
477 ATTRIBUTE4,
478 ATTRIBUTE5,
479 ATTRIBUTE6,
480 ATTRIBUTE7,
481 ATTRIBUTE15,
482 PRIORITY,
483 ACCESS_NAME,
484 DELIVERABLE_TYPE_CODE,
485 APPLICABLE_TO_CODE,
486 ATTRIBUTE8,
487 ATTRIBUTE9,
488 ATTRIBUTE10,
489 ATTRIBUTE11,
490 ATTRIBUTE12,
491 ATTRIBUTE13
492 from JTF_AMV_ITEMS_B
493 where ITEM_ID = X_ITEM_ID
494 for update of ITEM_ID nowait;
495 recinfo c%rowtype;
496
497 cursor c1 is select
498 ITEM_NAME,
499 DESCRIPTION,
500 TEXT_STRING,
501 decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
502 from JTF_AMV_ITEMS_TL
503 where ITEM_ID = X_ITEM_ID
504 and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
505 for update of ITEM_ID nowait;
506 begin
507 open c;
508 fetch c into recinfo;
509 if (c%notfound) then
510 close c;
511 fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
512 app_exception.raise_exception;
513 end if;
514 close c;
515 if ( (recinfo.EXTERNAL_ACCESS_FLAG = X_EXTERNAL_ACCESS_FLAG)
516 AND ((recinfo.PUBLICATION_DATE = X_PUBLICATION_DATE)
517 OR ((recinfo.PUBLICATION_DATE is null) AND (X_PUBLICATION_DATE is null)))
518 AND (recinfo.OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER)
519 AND (recinfo.LANGUAGE_CODE = X_LANGUAGE_CODE)
520 AND (recinfo.APPLICATION_ID = X_APPLICATION_ID)
521 AND ((recinfo.STATUS_CODE = X_STATUS_CODE)
522 OR ((recinfo.STATUS_CODE is null) AND (X_STATUS_CODE is null)))
523 AND ((recinfo.EFFECTIVE_START_DATE = X_EFFECTIVE_START_DATE)
524 OR ((recinfo.EFFECTIVE_START_DATE is null) AND (X_EFFECTIVE_START_DATE is null)))
525 AND ((recinfo.EXPIRATION_DATE = X_EXPIRATION_DATE)
526 OR ((recinfo.EXPIRATION_DATE is null) AND (X_EXPIRATION_DATE is null)))
527 AND ((recinfo.ITEM_TYPE = X_ITEM_TYPE)
528 OR ((recinfo.ITEM_TYPE is null) AND (X_ITEM_TYPE is null)))
529 AND ((recinfo.URL_STRING = X_URL_STRING)
530 OR ((recinfo.URL_STRING is null) AND (X_URL_STRING is null)))
531 AND ((recinfo.ATTRIBUTE14 = X_ATTRIBUTE14)
532 OR ((recinfo.ATTRIBUTE14 is null) AND (X_ATTRIBUTE14 is null)))
533 AND ((recinfo.CONTENT_TYPE_ID = X_CONTENT_TYPE_ID)
534 OR ((recinfo.CONTENT_TYPE_ID is null) AND (X_CONTENT_TYPE_ID is null)))
535 AND ((recinfo.OWNER_ID = X_OWNER_ID)
536 OR ((recinfo.OWNER_ID is null) AND (X_OWNER_ID is null)))
537 AND ((recinfo.DEFAULT_APPROVER_ID = X_DEFAULT_APPROVER_ID)
538 OR ((recinfo.DEFAULT_APPROVER_ID is null) AND (X_DEFAULT_APPROVER_ID is null)))
539 AND ((recinfo.ITEM_DESTINATION_TYPE = X_ITEM_DESTINATION_TYPE)
540 OR ((recinfo.ITEM_DESTINATION_TYPE is null) AND (X_ITEM_DESTINATION_TYPE is null)))
541 AND ((recinfo.ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY)
542 OR ((recinfo.ATTRIBUTE_CATEGORY is null) AND (X_ATTRIBUTE_CATEGORY is null)))
543 AND ((recinfo.ATTRIBUTE1 = X_ATTRIBUTE1)
544 OR ((recinfo.ATTRIBUTE1 is null) AND (X_ATTRIBUTE1 is null)))
545 AND ((recinfo.ATTRIBUTE2 = X_ATTRIBUTE2)
546 OR ((recinfo.ATTRIBUTE2 is null) AND (X_ATTRIBUTE2 is null)))
547 AND ((recinfo.ATTRIBUTE3 = X_ATTRIBUTE3)
548 OR ((recinfo.ATTRIBUTE3 is null) AND (X_ATTRIBUTE3 is null)))
549 AND ((recinfo.ATTRIBUTE4 = X_ATTRIBUTE4)
550 OR ((recinfo.ATTRIBUTE4 is null) AND (X_ATTRIBUTE4 is null)))
551 AND ((recinfo.ATTRIBUTE5 = X_ATTRIBUTE5)
552 OR ((recinfo.ATTRIBUTE5 is null) AND (X_ATTRIBUTE5 is null)))
553 AND ((recinfo.ATTRIBUTE6 = X_ATTRIBUTE6)
554 OR ((recinfo.ATTRIBUTE6 is null) AND (X_ATTRIBUTE6 is null)))
555 AND ((recinfo.ATTRIBUTE7 = X_ATTRIBUTE7)
556 OR ((recinfo.ATTRIBUTE7 is null) AND (X_ATTRIBUTE7 is null)))
557 AND ((recinfo.ATTRIBUTE15 = X_ATTRIBUTE15)
558 OR ((recinfo.ATTRIBUTE15 is null) AND (X_ATTRIBUTE15 is null)))
559 AND ((recinfo.PRIORITY = X_PRIORITY)
560 OR ((recinfo.PRIORITY is null) AND (X_PRIORITY is null)))
561 AND ((recinfo.ACCESS_NAME = X_ACCESS_NAME)
562 OR ((recinfo.ACCESS_NAME is null) AND (X_ACCESS_NAME is null)))
563 AND ((recinfo.DELIVERABLE_TYPE_CODE = X_DELIVERABLE_TYPE_CODE)
564 OR ((recinfo.DELIVERABLE_TYPE_CODE is null) AND (X_DELIVERABLE_TYPE_CODE is null)))
568 OR ((recinfo.ATTRIBUTE8 is null) AND (X_ATTRIBUTE8 is null)))
565 AND ((recinfo.APPLICABLE_TO_CODE = X_APPLICABLE_TO_CODE)
566 OR ((recinfo.APPLICABLE_TO_CODE is null) AND (X_APPLICABLE_TO_CODE is null)))
567 AND ((recinfo.ATTRIBUTE8 = X_ATTRIBUTE8)
569 AND ((recinfo.ATTRIBUTE9 = X_ATTRIBUTE9)
570 OR ((recinfo.ATTRIBUTE9 is null) AND (X_ATTRIBUTE9 is null)))
571 AND ((recinfo.ATTRIBUTE10 = X_ATTRIBUTE10)
572 OR ((recinfo.ATTRIBUTE10 is null) AND (X_ATTRIBUTE10 is null)))
573 AND ((recinfo.ATTRIBUTE11 = X_ATTRIBUTE11)
574 OR ((recinfo.ATTRIBUTE11 is null) AND (X_ATTRIBUTE11 is null)))
575 AND ((recinfo.ATTRIBUTE12 = X_ATTRIBUTE12)
576 OR ((recinfo.ATTRIBUTE12 is null) AND (X_ATTRIBUTE12 is null)))
577 AND ((recinfo.ATTRIBUTE13 = X_ATTRIBUTE13)
578 OR ((recinfo.ATTRIBUTE13 is null) AND (X_ATTRIBUTE13 is null)))
579 ) then
580 null;
581 else
582 fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
583 app_exception.raise_exception;
584 end if;
585
586 for tlinfo in c1 loop
587 if (tlinfo.BASELANG = 'Y') then
588 if ( (tlinfo.ITEM_NAME = X_ITEM_NAME)
589 AND ((tlinfo.DESCRIPTION = X_DESCRIPTION)
590 OR ((tlinfo.DESCRIPTION is null) AND (X_DESCRIPTION is null)))
591 AND ((tlinfo.TEXT_STRING = X_TEXT_STRING)
592 OR ((tlinfo.TEXT_STRING is null) AND (X_TEXT_STRING is null)))
593 ) then
594 null;
595 else
596 fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
597 app_exception.raise_exception;
598 end if;
599 end if;
600 end loop;
601 return;
602 end LOCK_ROW;
603
604 procedure UPDATE_ROW (
605 X_ITEM_ID in NUMBER,
606 X_OBJECT_VERSION_NUMBER in NUMBER,
607 X_LAST_UPDATE_DATE in DATE,
608 X_LAST_UPDATED_BY in NUMBER,
609 X_LAST_UPDATE_LOGIN in NUMBER,
610 X_APPLICATION_ID in NUMBER,
611 X_EXTERNAL_ACCESS_FLAG in VARCHAR2,
612 X_ITEM_NAME in VARCHAR2,
613 X_DESCRIPTION in VARCHAR2,
614 X_TEXT_STRING in VARCHAR2,
615 X_LANGUAGE_CODE in VARCHAR2,
616 X_STATUS_CODE in VARCHAR2,
617 X_EFFECTIVE_START_DATE in DATE,
618 X_EXPIRATION_DATE in DATE,
619 X_ITEM_TYPE in VARCHAR2,
620 X_URL_STRING in VARCHAR2,
621 X_PUBLICATION_DATE in DATE,
622 X_PRIORITY in VARCHAR2,
623 X_CONTENT_TYPE_ID in NUMBER,
624 X_OWNER_ID in NUMBER,
625 X_DEFAULT_APPROVER_ID in NUMBER,
626 X_ITEM_DESTINATION_TYPE in VARCHAR2,
627 X_ACCESS_NAME in VARCHAR2,
628 X_DELIVERABLE_TYPE_CODE in VARCHAR2,
629 X_APPLICABLE_TO_CODE in VARCHAR2,
630 X_ATTRIBUTE_CATEGORY in VARCHAR2,
631 X_ATTRIBUTE1 in VARCHAR2,
632 X_ATTRIBUTE2 in VARCHAR2,
633 X_ATTRIBUTE3 in VARCHAR2,
634 X_ATTRIBUTE4 in VARCHAR2,
635 X_ATTRIBUTE5 in VARCHAR2,
636 X_ATTRIBUTE6 in VARCHAR2,
637 X_ATTRIBUTE7 in VARCHAR2,
638 X_ATTRIBUTE8 in VARCHAR2,
639 X_ATTRIBUTE9 in VARCHAR2,
640 X_ATTRIBUTE10 in VARCHAR2,
641 X_ATTRIBUTE11 in VARCHAR2,
642 X_ATTRIBUTE12 in VARCHAR2,
643 X_ATTRIBUTE13 in VARCHAR2,
644 X_ATTRIBUTE14 in VARCHAR2,
645 X_ATTRIBUTE15 in VARCHAR2
646 ) is
647 begin
648 update JTF_AMV_ITEMS_B set
649 OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
650 LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
651 LAST_UPDATED_BY = X_LAST_UPDATED_BY,
652 LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
653 APPLICATION_ID = X_APPLICATION_ID,
654 EXTERNAL_ACCESS_FLAG = X_EXTERNAL_ACCESS_FLAG,
655 LANGUAGE_CODE = X_LANGUAGE_CODE,
656 STATUS_CODE = X_STATUS_CODE,
657 EFFECTIVE_START_DATE = X_EFFECTIVE_START_DATE,
658 EXPIRATION_DATE = X_EXPIRATION_DATE,
659 ITEM_TYPE = X_ITEM_TYPE,
660 URL_STRING = X_URL_STRING,
661 PUBLICATION_DATE = X_PUBLICATION_DATE,
662 PRIORITY = X_PRIORITY,
663 CONTENT_TYPE_ID = X_CONTENT_TYPE_ID,
664 OWNER_ID = X_OWNER_ID,
665 DEFAULT_APPROVER_ID = X_DEFAULT_APPROVER_ID,
666 ITEM_DESTINATION_TYPE = X_ITEM_DESTINATION_TYPE,
667 ACCESS_NAME = X_ACCESS_NAME,
668 DELIVERABLE_TYPE_CODE = X_DELIVERABLE_TYPE_CODE,
669 APPLICABLE_TO_CODE = X_APPLICABLE_TO_CODE,
670 ATTRIBUTE_CATEGORY = decode(X_ATTRIBUTE_CATEGORY,FND_API.G_MISS_CHAR,
671 ATTRIBUTE_CATEGORY, X_ATTRIBUTE_CATEGORY),
672 ATTRIBUTE1 =decode(X_ATTRIBUTE1,FND_API.G_MISS_CHAR,ATTRIBUTE1,X_ATTRIBUTE1),
673 ATTRIBUTE2 =decode(X_ATTRIBUTE2,FND_API.G_MISS_CHAR,ATTRIBUTE2,X_ATTRIBUTE2),
674 ATTRIBUTE3 =decode(X_ATTRIBUTE3,FND_API.G_MISS_CHAR,ATTRIBUTE3,X_ATTRIBUTE3),
675 ATTRIBUTE4 =decode(X_ATTRIBUTE4,FND_API.G_MISS_CHAR,ATTRIBUTE4,X_ATTRIBUTE4),
676 ATTRIBUTE5 =decode(X_ATTRIBUTE5,FND_API.G_MISS_CHAR,ATTRIBUTE5,X_ATTRIBUTE5),
677 ATTRIBUTE6 =decode(X_ATTRIBUTE6,FND_API.G_MISS_CHAR,ATTRIBUTE6,X_ATTRIBUTE6),
678 ATTRIBUTE7 =decode(X_ATTRIBUTE7,FND_API.G_MISS_CHAR,ATTRIBUTE7,X_ATTRIBUTE7),
679 ATTRIBUTE8 =decode(X_ATTRIBUTE8,FND_API.G_MISS_CHAR,ATTRIBUTE8,X_ATTRIBUTE8),
680 ATTRIBUTE9 =decode(X_ATTRIBUTE9,FND_API.G_MISS_CHAR,ATTRIBUTE9,X_ATTRIBUTE9),
681 ATTRIBUTE10 = decode(X_ATTRIBUTE10,FND_API.G_MISS_CHAR,
682 ATTRIBUTE10, X_ATTRIBUTE10),
683 ATTRIBUTE11 = decode(X_ATTRIBUTE11,FND_API.G_MISS_CHAR,
684 ATTRIBUTE11, X_ATTRIBUTE11),
685 ATTRIBUTE12 = decode(X_ATTRIBUTE12,FND_API.G_MISS_CHAR,
686 ATTRIBUTE12, X_ATTRIBUTE12),
687 ATTRIBUTE13 = decode(X_ATTRIBUTE13,FND_API.G_MISS_CHAR,
688 ATTRIBUTE13, X_ATTRIBUTE13),
689 ATTRIBUTE14 = decode(X_ATTRIBUTE14,FND_API.G_MISS_CHAR,
690 ATTRIBUTE14, X_ATTRIBUTE14),
691 ATTRIBUTE15 = decode(X_ATTRIBUTE15,FND_API.G_MISS_CHAR,
692 ATTRIBUTE15, X_ATTRIBUTE15)
693 where ITEM_ID = X_ITEM_ID;
694
695 if (sql%notfound) then
696 raise no_data_found;
697 end if;
698
699 update JTF_AMV_ITEMS_TL set
700 ITEM_NAME = decode( X_ITEM_NAME,
701 FND_API.G_MISS_CHAR, ITEM_NAME, X_ITEM_NAME),
702 DESCRIPTION = decode( X_DESCRIPTION,
703 FND_API.G_MISS_CHAR, DESCRIPTION, X_DESCRIPTION),
704 TEXT_STRING = decode (X_TEXT_STRING,
705 FND_API.G_MISS_CHAR, TEXT_STRING, X_TEXT_STRING),
706 LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
707 LAST_UPDATED_BY = X_LAST_UPDATED_BY,
708 LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
709 SOURCE_LANG = userenv('LANG')
710 where ITEM_ID = X_ITEM_ID
711 and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
712
713 if (sql%notfound) then
714 raise no_data_found;
715 end if;
716 end UPDATE_ROW ;
717
718 procedure DELETE_ROW (
719 X_ITEM_ID in NUMBER
720 ) is
721 begin
722 delete from JTF_AMV_ITEMS_TL
723 where ITEM_ID = X_ITEM_ID;
724
725 if (sql%notfound) then
726 raise no_data_found;
727 end if;
728
729 delete from JTF_AMV_ITEMS_B
730 where ITEM_ID = X_ITEM_ID;
731
732 if (sql%notfound) then
733 raise no_data_found;
734 end if;
735 end DELETE_ROW;
736
737 procedure ADD_LANGUAGE
738 is
739 begin
740 delete from JTF_AMV_ITEMS_TL T
741 where not exists
742 (select NULL
743 from JTF_AMV_ITEMS_B B
744 where B.ITEM_ID = T.ITEM_ID
745 );
746
747 update JTF_AMV_ITEMS_TL T set (
748 ITEM_NAME,
749 DESCRIPTION,
750 TEXT_STRING
751 ) = (select
752 B.ITEM_NAME,
753 B.DESCRIPTION,
754 B.TEXT_STRING
755 from JTF_AMV_ITEMS_TL B
756 where B.ITEM_ID = T.ITEM_ID
757 and B.LANGUAGE = T.SOURCE_LANG)
758 where (
762 SUBT.ITEM_ID,
759 T.ITEM_ID,
760 T.LANGUAGE
761 ) in (select
763 SUBT.LANGUAGE
764 from JTF_AMV_ITEMS_TL SUBB, JTF_AMV_ITEMS_TL SUBT
765 where SUBB.ITEM_ID = SUBT.ITEM_ID
766 and SUBB.LANGUAGE = SUBT.SOURCE_LANG
767 and (SUBB.ITEM_NAME <> SUBT.ITEM_NAME
768 or SUBB.DESCRIPTION <> SUBT.DESCRIPTION
769 or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
770 or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
771 or SUBB.TEXT_STRING <> SUBT.TEXT_STRING
772 or (SUBB.TEXT_STRING is null and SUBT.TEXT_STRING is not null)
773 or (SUBB.TEXT_STRING is not null and SUBT.TEXT_STRING is null)
774 ));
775
776 insert into JTF_AMV_ITEMS_TL (
777 ITEM_ID,
778 LAST_UPDATE_DATE,
779 LAST_UPDATED_BY,
780 CREATION_DATE,
781 CREATED_BY,
782 LAST_UPDATE_LOGIN,
783 ITEM_NAME,
784 DESCRIPTION,
785 TEXT_STRING,
786 LANGUAGE,
787 SOURCE_LANG
788 ) select
789 B.ITEM_ID,
790 B.LAST_UPDATE_DATE,
791 B.LAST_UPDATED_BY,
792 B.CREATION_DATE,
793 B.CREATED_BY,
794 B.LAST_UPDATE_LOGIN,
795 B.ITEM_NAME,
796 B.DESCRIPTION,
797 B.TEXT_STRING,
798 L.LANGUAGE_CODE,
799 B.SOURCE_LANG
800 from JTF_AMV_ITEMS_TL B, FND_LANGUAGES L
801 where L.INSTALLED_FLAG in ('I', 'B')
802 and B.LANGUAGE = userenv('LANG')
803 and not exists
804 (select NULL
805 from JTF_AMV_ITEMS_TL T
806 where T.ITEM_ID = B.ITEM_ID
807 and T.LANGUAGE = L.LANGUAGE_CODE);
808 end ADD_LANGUAGE;
809
810 procedure LOAD_SEED_ROW(
811 x_upload_mode in varchar2,
812 x_item_id in varchar2,
813 x_item_name in varchar2,
814 x_description in varchar2,
815 x_text_string in varchar2,
816 x_owner in varchar2,
817 x_object_version_number in varchar2,
818 x_status_code in varchar2,
819 x_effective_start_date in varchar2,
820 x_expiration_date in varchar2,
821 x_application_id in varchar2,
822 x_external_access_flag in varchar2,
823 x_priority in varchar2,
824 x_publication_date in varchar2,
825 x_language_code in varchar2,
826 x_item_type in varchar2,
827 x_url_string in varchar2,
828 x_content_type_id in varchar2,
829 x_owner_id in varchar2,
830 x_default_approver_id in varchar2,
831 x_item_destination_type in varchar2,
832 x_access_name in varchar2,
833 x_deliverable_type_code in varchar2,
834 x_applicable_to_code in varchar2,
835 x_attribute_category in varchar2,
836 x_attribute1 in varchar2,
837 x_attribute2 in varchar2,
838 x_attribute3 in varchar2,
839 x_attribute4 in varchar2,
840 x_attribute5 in varchar2,
841 x_attribute6 in varchar2,
842 x_attribute7 in varchar2,
843 x_attribute8 in varchar2,
844 x_attribute9 in varchar2,
845 x_attribute10 in varchar2,
846 x_attribute11 in varchar2,
847 x_attribute12 in varchar2,
848 x_attribute13 in varchar2,
849 x_attribute14 in varchar2,
850 x_attribute15 in varchar2,
851 x_custom_mode in varchar2 ,
852 x_last_update_date in varchar2
853 )
854
855 is
856
857 v_db_owner_id number;
858
859 begin
860 if (x_upload_mode = 'NLS') then
861 JTF_AMV_ITEMS_PKG.TRANSLATE_ROW (
862 X_ITEM_ID => x_item_id
863 , X_ITEM_NAME => x_item_name
864 , x_description => x_description
865 , X_TEXT_STRING => x_text_string
866 , x_owner => x_owner
867 , x_last_update_date => x_last_update_date
868 );
869 else
870
871 JTF_AMV_ITEMS_PKG.LOAD_ROW (
872 X_ITEM_ID => x_item_id,
873 x_object_version_number => x_object_version_number,
874 X_STATUS_CODE => x_status_code,
875 X_EFFECTIVE_START_DATE => x_effective_start_date,
876 X_EXPIRATION_DATE => x_expiration_date,
877 X_APPLICATION_ID => x_application_id,
878 X_EXTERNAL_ACCESS_FLAG => x_external_access_flag,
879 X_PRIORITY => x_priority,
880 X_PUBLICATION_DATE => x_publication_date,
881 X_LANGUAGE_CODE => x_language_code,
882 X_ITEM_TYPE => x_item_type,
883 X_URL_STRING => x_url_string,
884 X_CONTENT_TYPE_ID => x_content_type_id,
885 X_OWNER_ID => x_owner_id,
886 X_DEFAULT_APPROVER_ID => x_default_approver_id,
887 X_ITEM_DESTINATION_TYPE => x_item_destination_type,
888 X_ACCESS_NAME => x_access_name,
889 X_DELIVERABLE_TYPE_CODE => x_deliverable_type_code,
890 X_APPLICABLE_TO_CODE => x_applicable_to_code,
891 X_ATTRIBUTE_CATEGORY => x_attribute_category,
892 X_ATTRIBUTE1 => x_attribute1,
893 X_ATTRIBUTE2 => x_attribute2,
894 X_ATTRIBUTE3 => x_attribute3,
895 X_ATTRIBUTE4 => x_attribute4,
896 X_ATTRIBUTE5 => x_attribute5,
897 X_ATTRIBUTE6 => x_attribute6,
898 X_ATTRIBUTE7 => x_attribute7,
899 X_ATTRIBUTE8 => x_attribute8,
900 X_ATTRIBUTE9 => x_attribute9,
901 X_ATTRIBUTE10 => x_attribute10,
902 X_ATTRIBUTE11 => x_attribute11,
903 X_ATTRIBUTE12 => x_attribute12,
904 X_ATTRIBUTE13 => x_attribute13,
905 X_ATTRIBUTE14 => x_attribute14,
906 X_ATTRIBUTE15 => x_attribute15,
907 X_ITEM_NAME => x_item_name,
908 X_DESCRIPTION => x_description,
909 X_TEXT_STRING => x_text_string,
910 X_Owner => x_owner,
911 x_custom_mode => x_custom_mode,
912 x_last_update_date=>x_last_update_date
913 );
914
915 end if;
916
917 exception
918 when no_data_found then
919 JTF_AMV_ITEMS_PKG.LOAD_ROW (
920 X_ITEM_ID => x_item_id,
921 x_object_version_number => x_object_version_number,
922 X_STATUS_CODE => x_status_code,
923 X_EFFECTIVE_START_DATE => x_effective_start_date,
924 X_EXPIRATION_DATE => x_expiration_date,
925 X_APPLICATION_ID => x_application_id,
926 X_EXTERNAL_ACCESS_FLAG => x_external_access_flag,
927 X_PRIORITY => x_priority,
928 X_PUBLICATION_DATE => x_publication_date,
929 X_LANGUAGE_CODE => x_language_code,
930 X_ITEM_TYPE => x_item_type,
931 X_URL_STRING => x_url_string,
932 X_CONTENT_TYPE_ID => x_content_type_id,
933 X_OWNER_ID => x_owner_id,
934 X_DEFAULT_APPROVER_ID => x_default_approver_id,
935 X_ITEM_DESTINATION_TYPE => x_item_destination_type,
936 X_ACCESS_NAME => x_access_name,
937 X_DELIVERABLE_TYPE_CODE => x_deliverable_type_code,
938 X_APPLICABLE_TO_CODE => x_applicable_to_code,
939 X_ATTRIBUTE_CATEGORY => x_attribute_category,
940 X_ATTRIBUTE1 => x_attribute1,
941 X_ATTRIBUTE2 => x_attribute2,
942 X_ATTRIBUTE3 => x_attribute3,
943 X_ATTRIBUTE4 => x_attribute4,
944 X_ATTRIBUTE5 => x_attribute5,
945 X_ATTRIBUTE6 => x_attribute6,
946 X_ATTRIBUTE7 => x_attribute7,
947 X_ATTRIBUTE8 => x_attribute8,
948 X_ATTRIBUTE9 => x_attribute9,
949 X_ATTRIBUTE10 => x_attribute10,
950 X_ATTRIBUTE11 => x_attribute11,
951 X_ATTRIBUTE12 => x_attribute12,
952 X_ATTRIBUTE13 => x_attribute13,
953 X_ATTRIBUTE14 => x_attribute14,
954 X_ATTRIBUTE15 => x_attribute15,
955 X_ITEM_NAME => x_item_name,
956 X_DESCRIPTION => x_description,
957 X_TEXT_STRING => x_text_string,
958 X_Owner => x_owner,
959 x_custom_mode => x_custom_mode,
960 x_last_update_date=>x_last_update_date
961 );
962
963 end LOAD_SEED_ROW;
964
965 end JTF_AMV_ITEMS_PKG;