[Home] [Help]
PACKAGE BODY: APPS.JTF_AMV_ATTCHS_PKG
Source
1 package body JTF_AMV_ATTCHS_PKG as
2 /* $Header: jtfvattb.pls 120.4 2006/01/16 01:41:42 vimohan ship $ */
3 procedure Load_Row(
4 X_ATTACHMENT_ID in VARCHAR2,
5 X_OBJECT_VERSION_NUMBER in VARCHAR2,
6 X_OWNER_USER_ID in VARCHAR2,
7 X_ATTACHMENT_USED_BY_ID in VARCHAR2,
8 X_ATTACHMENT_USED_BY in VARCHAR2,
9 X_VERSION in VARCHAR2,
10 X_ENABLED_FLAG in VARCHAR2,
11 X_CAN_FULFILL_ELECTRONIC_FLAG in VARCHAR2,
12 X_FILE_ID in VARCHAR2,
13 X_FILE_NAME in VARCHAR2,
14 X_FILE_EXTENSION in VARCHAR2,
15 X_KEYWORDS in VARCHAR2,
16 X_DISPLAY_WIDTH in VARCHAR2,
17 X_DISPLAY_HEIGHT in VARCHAR2,
18 X_DISPLAY_LOCATION in VARCHAR2,
19 X_LINK_TO in VARCHAR2,
20 X_LINK_URL in VARCHAR2,
21 X_SEND_FOR_PREVIEW_FLAG in VARCHAR2,
22 X_ATTACHMENT_TYPE in VARCHAR2,
23 X_LANGUAGE_CODE in VARCHAR2,
24 X_APPLICATION_ID in VARCHAR2,
25 X_DESCRIPTION in VARCHAR2,
26 X_DEFAULT_STYLE_SHEET in VARCHAR2,
27 X_DISPLAY_URL in VARCHAR2,
28 X_DISPLAY_RULE_ID in VARCHAR2,
29 X_DISPLAY_PROGRAM in VARCHAR2,
30 X_ATTRIBUTE_CATEGORY in VARCHAR2,
31 X_ATTRIBUTE1 in VARCHAR2,
32 X_ATTRIBUTE2 in VARCHAR2,
33 X_ATTRIBUTE3 in VARCHAR2,
34 X_ATTRIBUTE4 in VARCHAR2,
35 X_ATTRIBUTE5 in VARCHAR2,
36 X_ATTRIBUTE6 in VARCHAR2,
37 X_ATTRIBUTE7 in VARCHAR2,
38 X_ATTRIBUTE8 in VARCHAR2,
39 X_ATTRIBUTE9 in VARCHAR2,
40 X_ATTRIBUTE10 in VARCHAR2,
41 X_ATTRIBUTE11 in VARCHAR2,
42 X_ATTRIBUTE12 in VARCHAR2,
43 X_ATTRIBUTE13 in VARCHAR2,
44 X_ATTRIBUTE14 in VARCHAR2,
45 X_ATTRIBUTE15 in VARCHAR2,
46 X_DISPLAY_TEXT in VARCHAR2 := NULL,
47 X_ALTERNATE_TEXT in VARCHAR2 := NULL,
48 X_ATTACHMENT_SUB_TYPE in VARCHAR2 := NULL,
49 X_DOCUMENT_ID in VARCHAR2 := NULL,
50 X_SECURED_FLAG in VARCHAR2 := NULL,
51 X_OWNER in VARCHAR2,
52 X_CUSTOM_MODE VARCHAR2 DEFAULT NULL,
53 X_LAST_UPDATE_DATE VARCHAR2 DEFAULT NULL
54 ) AS
55 --
56 l_user_id number := fnd_load_util.owner_id(x_owner);
57 l_row_id varchar2(2000);
58 l_ATTACHMENT_ID NUMBER;
59 L_OBJECT_VERSION_NUMBER NUMBER;
60 L_APPLICATION_ID NUMBER;
61 L_ATTACHMENT_USED_BY_ID NUMBER;
62 L_FILE_ID NUMBER;
63 L_DISPLAY_WIDTH NUMBER;
64 L_DISPLAY_HEIGHT NUMBER;
65 L_DISPLAY_RULE_ID NUMBER;
66 L_DOCUMENT_ID NUMBER;
67 f_luby number; -- entity owner in file
68 f_ludate date; -- entity update date in file
69 db_luby number; -- entity owner in db
70 db_ludate date; -- entity update date in db
71
72 BEGIN
73 -- if (X_OWNER = 'SEED') then
74 -- l_user_id := 1;
75 -- end if;
76 l_ATTACHMENT_ID := to_number(X_ATTACHMENT_ID);
77 L_OBJECT_VERSION_NUMBER := to_number(X_OBJECT_VERSION_NUMBER);
78 L_APPLICATION_ID := to_number(X_APPLICATION_ID);
79 L_ATTACHMENT_USED_BY_ID := to_number(X_ATTACHMENT_USED_BY_ID);
80 L_FILE_ID := to_number(X_FILE_ID);
81 L_DISPLAY_WIDTH := to_number(X_DISPLAY_WIDTH);
82 L_DISPLAY_HEIGHT := to_number(X_DISPLAY_HEIGHT);
83 L_DISPLAY_RULE_ID := to_number(X_DISPLAY_RULE_ID);
84 L_DOCUMENT_ID := to_number(X_DOCUMENT_ID);
85
86
87 -- Translate owner to file_last_updated_by
88 f_luby := fnd_load_util.owner_id(x_owner);
89 -- Translate char last_update_date to date
90 f_ludate := to_date(nvl(x_last_update_date,sysdate ), 'YYYY/MM/DD');
91 --f_ludate :=sysdate;
92 -- This select stmnt also checks if
93 -- there is a row for this app_id and this app_short_name
94 -- Exception is thrown otherwise.
95
96 select LAST_UPDATED_BY, LAST_UPDATE_DATE
97 into db_luby, db_ludate
98 FROM JTF_AMV_ATTACHMENTS
99 where ATTACHMENT_ID = X_ATTACHMENT_ID;
100
101 if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
102 db_ludate, X_CUSTOM_MODE)) then
103 UPDATE_ROW (
104 X_ATTACHMENT_ID => l_ATTACHMENT_ID,
105 X_LAST_UPDATE_DATE => f_ludate,
106 X_LAST_UPDATED_BY => f_luby,
107 X_LAST_UPDATE_LOGIN => l_user_id,
108 X_OBJECT_VERSION_NUMBER => l_OBJECT_VERSION_NUMBER,
109 X_OWNER_USER_ID => X_OWNER_USER_ID,
110 X_ATTACHMENT_USED_BY_ID => l_ATTACHMENT_USED_BY_ID,
111 X_ATTACHMENT_USED_BY => X_ATTACHMENT_USED_BY,
112 X_VERSION => X_VERSION,
113 X_ENABLED_FLAG => X_ENABLED_FLAG,
114 X_CAN_FULFILL_ELECTRONIC_FLAG => X_CAN_FULFILL_ELECTRONIC_FLAG,
115 X_FILE_ID => l_FILE_ID,
116 X_FILE_NAME => X_FILE_NAME,
117 X_FILE_EXTENSION => X_FILE_EXTENSION,
118 X_KEYWORDS => X_KEYWORDS,
119 X_DISPLAY_WIDTH => l_DISPLAY_WIDTH,
120 X_DISPLAY_HEIGHT => l_DISPLAY_HEIGHT,
121 X_DISPLAY_LOCATION => X_DISPLAY_LOCATION,
122 X_LINK_TO => X_LINK_TO,
123 X_LINK_URL => X_LINK_URL,
124 X_SEND_FOR_PREVIEW_FLAG => X_SEND_FOR_PREVIEW_FLAG,
125 X_ATTACHMENT_TYPE => X_ATTACHMENT_TYPE,
126 X_LANGUAGE_CODE => X_LANGUAGE_CODE,
127 X_APPLICATION_ID => l_APPLICATION_ID,
128 X_DESCRIPTION => X_DESCRIPTION,
129 X_DEFAULT_STYLE_SHEET => X_DEFAULT_STYLE_SHEET,
130 X_DISPLAY_URL => X_DISPLAY_URL,
131 X_DISPLAY_RULE_ID => l_DISPLAY_RULE_ID,
132 X_DISPLAY_PROGRAM => X_DISPLAY_PROGRAM,
133 X_ATTRIBUTE_CATEGORY => X_ATTRIBUTE_CATEGORY,
134 X_ATTRIBUTE1 => X_ATTRIBUTE1,
135 X_ATTRIBUTE2 => X_ATTRIBUTE2,
136 X_ATTRIBUTE3 => X_ATTRIBUTE3,
137 X_ATTRIBUTE4 => X_ATTRIBUTE4,
138 X_ATTRIBUTE5 => X_ATTRIBUTE5,
139 X_ATTRIBUTE6 => X_ATTRIBUTE6,
140 X_ATTRIBUTE7 => X_ATTRIBUTE7,
141 X_ATTRIBUTE8 => X_ATTRIBUTE8,
142 X_ATTRIBUTE9 => X_ATTRIBUTE9,
143 X_ATTRIBUTE10 => X_ATTRIBUTE10,
144 X_ATTRIBUTE11 => X_ATTRIBUTE11,
145 X_ATTRIBUTE12 => X_ATTRIBUTE12,
146 X_ATTRIBUTE13 => X_ATTRIBUTE13,
147 X_ATTRIBUTE14 => X_ATTRIBUTE14,
148 X_ATTRIBUTE15 => X_ATTRIBUTE15,
149 X_DISPLAY_TEXT => X_DISPLAY_TEXT,
150 X_ALTERNATE_TEXT => X_ALTERNATE_TEXT,
151 X_ATTACHMENT_SUB_TYPE => X_ATTACHMENT_SUB_TYPE,
152 X_DOCUMENT_ID => l_DOCUMENT_ID,
153 X_SECURED_FLAG => X_SECURED_FLAG
154 );
155 end if;
156 exception
157 when NO_DATA_FOUND then
158 INSERT_ROW (
159 X_ROWID => l_row_id,
160 X_ATTACHMENT_ID => l_ATTACHMENT_ID,
161 X_LAST_UPDATE_DATE => f_ludate,
162 X_LAST_UPDATED_BY => f_luby,
163 X_CREATION_DATE => f_ludate,
164 X_CREATED_BY => f_luby,
165 X_LAST_UPDATE_LOGIN => l_user_id,
166 X_OBJECT_VERSION_NUMBER => l_OBJECT_VERSION_NUMBER,
167 X_OWNER_USER_ID => X_OWNER_USER_ID,
168 X_ATTACHMENT_USED_BY_ID => l_ATTACHMENT_USED_BY_ID,
169 X_ATTACHMENT_USED_BY => X_ATTACHMENT_USED_BY,
170 X_VERSION => X_VERSION,
171 X_ENABLED_FLAG => X_ENABLED_FLAG,
172 X_CAN_FULFILL_ELECTRONIC_FLAG => X_CAN_FULFILL_ELECTRONIC_FLAG,
173 X_FILE_ID => l_FILE_ID,
174 X_FILE_NAME => X_FILE_NAME,
175 X_FILE_EXTENSION => X_FILE_EXTENSION,
176 X_KEYWORDS => X_KEYWORDS,
177 X_DISPLAY_WIDTH => l_DISPLAY_WIDTH,
178 X_DISPLAY_HEIGHT => l_DISPLAY_HEIGHT,
179 X_DISPLAY_LOCATION => X_DISPLAY_LOCATION,
180 X_LINK_TO => X_LINK_TO,
181 X_LINK_URL => X_LINK_URL,
182 X_SEND_FOR_PREVIEW_FLAG => X_SEND_FOR_PREVIEW_FLAG,
183 X_ATTACHMENT_TYPE => X_ATTACHMENT_TYPE,
184 X_LANGUAGE_CODE => X_LANGUAGE_CODE,
185 X_APPLICATION_ID => l_APPLICATION_ID,
186 X_DESCRIPTION => X_DESCRIPTION,
187 X_DEFAULT_STYLE_SHEET => X_DEFAULT_STYLE_SHEET,
188 X_DISPLAY_URL => X_DISPLAY_URL,
189 X_DISPLAY_RULE_ID => l_DISPLAY_RULE_ID,
190 X_DISPLAY_PROGRAM => X_DISPLAY_PROGRAM,
191 X_ATTRIBUTE_CATEGORY => X_ATTRIBUTE_CATEGORY,
192 X_ATTRIBUTE1 => X_ATTRIBUTE1,
193 X_ATTRIBUTE2 => X_ATTRIBUTE2,
194 X_ATTRIBUTE3 => X_ATTRIBUTE3,
195 X_ATTRIBUTE4 => X_ATTRIBUTE4,
196 X_ATTRIBUTE5 => X_ATTRIBUTE5,
197 X_ATTRIBUTE6 => X_ATTRIBUTE6,
198 X_ATTRIBUTE7 => X_ATTRIBUTE7,
199 X_ATTRIBUTE8 => X_ATTRIBUTE8,
200 X_ATTRIBUTE9 => X_ATTRIBUTE9,
201 X_ATTRIBUTE10 => X_ATTRIBUTE10,
202 X_ATTRIBUTE11 => X_ATTRIBUTE11,
203 X_ATTRIBUTE12 => X_ATTRIBUTE12,
204 X_ATTRIBUTE13 => X_ATTRIBUTE13,
205 X_ATTRIBUTE14 => X_ATTRIBUTE14,
206 X_ATTRIBUTE15 => X_ATTRIBUTE15,
207 X_DISPLAY_TEXT => X_DISPLAY_TEXT,
208 X_ALTERNATE_TEXT => X_ALTERNATE_TEXT,
209 X_ATTACHMENT_SUB_TYPE => X_ATTACHMENT_SUB_TYPE,
210 X_DOCUMENT_ID => l_DOCUMENT_ID,
211 X_SECURED_FLAG => X_SECURED_FLAG
212 );
213 END;
214 procedure INSERT_ROW (
215 X_ROWID in out NOCOPY VARCHAR2,
216 X_ATTACHMENT_ID in NUMBER,
217 X_LAST_UPDATE_DATE in DATE,
218 X_LAST_UPDATED_BY in NUMBER,
219 X_CREATION_DATE in DATE,
220 X_CREATED_BY in NUMBER,
221 X_LAST_UPDATE_LOGIN in NUMBER,
222 X_OBJECT_VERSION_NUMBER in NUMBER,
223 X_OWNER_USER_ID in NUMBER,
224 X_ATTACHMENT_USED_BY_ID in NUMBER,
225 X_ATTACHMENT_USED_BY in VARCHAR2,
226 X_VERSION in VARCHAR2,
227 X_ENABLED_FLAG in VARCHAR2,
228 X_CAN_FULFILL_ELECTRONIC_FLAG in VARCHAR2,
229 X_FILE_ID in NUMBER,
230 X_FILE_NAME in VARCHAR2,
231 X_FILE_EXTENSION in VARCHAR2,
232 X_KEYWORDS in VARCHAR2,
233 X_DISPLAY_WIDTH in NUMBER,
234 X_DISPLAY_HEIGHT in NUMBER,
235 X_DISPLAY_LOCATION in VARCHAR2,
236 X_LINK_TO in VARCHAR2,
237 X_LINK_URL in VARCHAR2,
238 X_SEND_FOR_PREVIEW_FLAG in VARCHAR2,
239 X_ATTACHMENT_TYPE in VARCHAR2,
240 X_LANGUAGE_CODE in VARCHAR2,
241 X_APPLICATION_ID in NUMBER,
242 X_DESCRIPTION in VARCHAR2,
243 X_DEFAULT_STYLE_SHEET in VARCHAR2,
244 X_DISPLAY_URL in VARCHAR2,
245 X_DISPLAY_RULE_ID in NUMBER,
246 X_DISPLAY_PROGRAM in VARCHAR2,
247 X_ATTRIBUTE_CATEGORY in VARCHAR2,
248 X_ATTRIBUTE1 in VARCHAR2,
249 X_ATTRIBUTE2 in VARCHAR2,
250 X_ATTRIBUTE3 in VARCHAR2,
251 X_ATTRIBUTE4 in VARCHAR2,
252 X_ATTRIBUTE5 in VARCHAR2,
253 X_ATTRIBUTE6 in VARCHAR2,
254 X_ATTRIBUTE7 in VARCHAR2,
255 X_ATTRIBUTE8 in VARCHAR2,
256 X_ATTRIBUTE9 in VARCHAR2,
257 X_ATTRIBUTE10 in VARCHAR2,
258 X_ATTRIBUTE11 in VARCHAR2,
259 X_ATTRIBUTE12 in VARCHAR2,
260 X_ATTRIBUTE13 in VARCHAR2,
261 X_ATTRIBUTE14 in VARCHAR2,
262 X_ATTRIBUTE15 in VARCHAR2,
263 X_DISPLAY_TEXT in VARCHAR2 := NULL,
264 X_ALTERNATE_TEXT in VARCHAR2 := NULL,
265 X_ATTACHMENT_SUB_TYPE in VARCHAR2 := NULL,
266 X_DOCUMENT_ID in NUMBER := NULL,
267 X_SECURED_FLAG in VARCHAR2 := NULL
268 ) AS
269 cursor C is select ROWID from JTF_AMV_ATTACHMENTS
270 where attachment_id = x_attachment_id
271 ;
272 begin
273 insert into JTF_AMV_ATTACHMENTS
274 (
275 ATTACHMENT_ID,
276 LAST_UPDATE_DATE,
277 LAST_UPDATED_BY,
278 CREATION_DATE,
279 CREATED_BY,
280 LAST_UPDATE_LOGIN,
281 OBJECT_VERSION_NUMBER,
282 OWNER_USER_ID,
283 ATTACHMENT_USED_BY_ID,
284 ATTACHMENT_USED_BY,
285 VERSION,
286 ENABLED_FLAG,
287 CAN_FULFILL_ELECTRONIC_FLAG,
288 FILE_ID,
289 FILE_NAME,
290 FILE_EXTENSION,
291 KEYWORDS,
292 DISPLAY_WIDTH,
293 DISPLAY_HEIGHT,
294 DISPLAY_LOCATION,
295 LINK_TO,
296 LINK_URL,
297 SEND_FOR_PREVIEW_FLAG,
298 ATTACHMENT_TYPE,
299 LANGUAGE_CODE,
300 APPLICATION_ID,
301 DESCRIPTION,
302 DEFAULT_STYLE_SHEET,
303 DISPLAY_URL,
304 DISPLAY_RULE_ID,
305 DISPLAY_PROGRAM,
306 ATTRIBUTE_CATEGORY,
307 ATTRIBUTE1,
308 ATTRIBUTE2,
309 ATTRIBUTE3,
310 ATTRIBUTE4,
311 ATTRIBUTE5,
312 ATTRIBUTE6,
313 ATTRIBUTE7,
314 ATTRIBUTE8,
315 ATTRIBUTE9,
316 ATTRIBUTE10,
317 ATTRIBUTE11,
318 ATTRIBUTE12,
319 ATTRIBUTE13,
320 ATTRIBUTE14,
321 ATTRIBUTE15,
322 DISPLAY_TEXT,
323 ALTERNATE_TEXT,
324 ATTACHMENT_SUB_TYPE,
325 DOCUMENT_ID,
326 SECURED_FLAG
327 ) VALUES (
328 X_ATTACHMENT_ID,
329 X_LAST_UPDATE_DATE,
330 X_LAST_UPDATED_BY,
331 X_CREATION_DATE,
332 X_CREATED_BY,
333 X_LAST_UPDATE_LOGIN,
334 X_OBJECT_VERSION_NUMBER,
335 X_OWNER_USER_ID,
336 X_ATTACHMENT_USED_BY_ID,
337 X_ATTACHMENT_USED_BY,
338 X_VERSION,
339 X_ENABLED_FLAG,
340 X_CAN_FULFILL_ELECTRONIC_FLAG,
341 X_FILE_ID,
342 X_FILE_NAME,
343 X_FILE_EXTENSION,
344 X_KEYWORDS,
345 X_DISPLAY_WIDTH,
346 X_DISPLAY_HEIGHT,
347 X_DISPLAY_LOCATION,
348 X_LINK_TO,
349 X_LINK_URL,
350 X_SEND_FOR_PREVIEW_FLAG,
351 X_ATTACHMENT_TYPE,
352 X_LANGUAGE_CODE,
353 X_APPLICATION_ID,
354 X_DESCRIPTION,
355 X_DEFAULT_STYLE_SHEET,
356 X_DISPLAY_URL,
357 X_DISPLAY_RULE_ID,
358 X_DISPLAY_PROGRAM,
359 X_ATTRIBUTE_CATEGORY,
360 X_ATTRIBUTE1,
361 X_ATTRIBUTE2,
362 X_ATTRIBUTE3,
363 X_ATTRIBUTE4,
364 X_ATTRIBUTE5,
365 X_ATTRIBUTE6,
366 X_ATTRIBUTE7,
367 X_ATTRIBUTE8,
368 X_ATTRIBUTE9,
369 X_ATTRIBUTE10,
370 X_ATTRIBUTE11,
371 X_ATTRIBUTE12,
372 X_ATTRIBUTE13,
373 X_ATTRIBUTE14,
374 X_ATTRIBUTE15,
375 X_DISPLAY_TEXT,
376 X_ALTERNATE_TEXT,
377 X_ATTACHMENT_SUB_TYPE,
378 X_DOCUMENT_ID,
379 X_SECURED_FLAG
380 );
381 open c;
382 fetch c into X_ROWID;
383 if (c%notfound) then
384 close c;
385 raise no_data_found;
386 end if;
387 close c;
388
389 END;
390 procedure UPDATE_ROW (
391 X_ATTACHMENT_ID in NUMBER,
392 X_LAST_UPDATE_DATE in DATE,
393 X_LAST_UPDATED_BY in NUMBER,
394 X_LAST_UPDATE_LOGIN in NUMBER,
395 X_OBJECT_VERSION_NUMBER in NUMBER,
396 X_OWNER_USER_ID in NUMBER,
397 X_ATTACHMENT_USED_BY_ID in NUMBER,
398 X_ATTACHMENT_USED_BY in VARCHAR2,
399 X_VERSION in VARCHAR2,
400 X_ENABLED_FLAG in VARCHAR2,
401 X_CAN_FULFILL_ELECTRONIC_FLAG in VARCHAR2,
402 X_FILE_ID in NUMBER,
403 X_FILE_NAME in VARCHAR2,
404 X_FILE_EXTENSION in VARCHAR2,
405 X_KEYWORDS in VARCHAR2,
406 X_DISPLAY_WIDTH in NUMBER,
407 X_DISPLAY_HEIGHT in NUMBER,
408 X_DISPLAY_LOCATION in VARCHAR2,
409 X_LINK_TO in VARCHAR2,
410 X_LINK_URL in VARCHAR2,
411 X_SEND_FOR_PREVIEW_FLAG in VARCHAR2,
412 X_ATTACHMENT_TYPE in VARCHAR2,
413 X_LANGUAGE_CODE in VARCHAR2,
414 X_APPLICATION_ID in NUMBER,
415 X_DESCRIPTION in VARCHAR2,
416 X_DEFAULT_STYLE_SHEET in VARCHAR2,
417 X_DISPLAY_URL in VARCHAR2,
418 X_DISPLAY_RULE_ID in NUMBER,
419 X_DISPLAY_PROGRAM in VARCHAR2,
420 X_ATTRIBUTE_CATEGORY in VARCHAR2,
421 X_ATTRIBUTE1 in VARCHAR2,
422 X_ATTRIBUTE2 in VARCHAR2,
423 X_ATTRIBUTE3 in VARCHAR2,
424 X_ATTRIBUTE4 in VARCHAR2,
425 X_ATTRIBUTE5 in VARCHAR2,
426 X_ATTRIBUTE6 in VARCHAR2,
427 X_ATTRIBUTE7 in VARCHAR2,
428 X_ATTRIBUTE8 in VARCHAR2,
429 X_ATTRIBUTE9 in VARCHAR2,
433 X_ATTRIBUTE13 in VARCHAR2,
430 X_ATTRIBUTE10 in VARCHAR2,
431 X_ATTRIBUTE11 in VARCHAR2,
432 X_ATTRIBUTE12 in VARCHAR2,
434 X_ATTRIBUTE14 in VARCHAR2,
435 X_ATTRIBUTE15 in VARCHAR2,
436 X_DISPLAY_TEXT in VARCHAR2 := NULL,
437 X_ALTERNATE_TEXT in VARCHAR2 := NULL,
438 X_ATTACHMENT_SUB_TYPE in VARCHAR2 := NULL,
439 X_DOCUMENT_ID in NUMBER := NULL,
440 X_SECURED_FLAG in VARCHAR2 := NULL
441 ) AS
442 BEGIN
443 Update JTF_AMV_ATTACHMENTS SET
444 LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
445 LAST_UPDATED_BY = X_LAST_UPDATED_BY,
446 LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
447 OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
448 OWNER_USER_ID = X_OWNER_USER_ID,
449 ATTACHMENT_USED_BY_ID = X_ATTACHMENT_USED_BY_ID,
450 ATTACHMENT_USED_BY = X_ATTACHMENT_USED_BY,
451 VERSION = X_VERSION,
452 ENABLED_FLAG = X_ENABLED_FLAG,
453 CAN_FULFILL_ELECTRONIC_FLAG = X_CAN_FULFILL_ELECTRONIC_FLAG,
454 -- FILE_ID = X_FILE_ID,
455 FILE_NAME = X_FILE_NAME,
456 FILE_EXTENSION = X_FILE_EXTENSION,
457 KEYWORDS = X_KEYWORDS,
458 DISPLAY_WIDTH = X_DISPLAY_WIDTH,
459 DISPLAY_HEIGHT = X_DISPLAY_HEIGHT,
460 DISPLAY_LOCATION = X_DISPLAY_LOCATION,
461 LINK_TO = X_LINK_TO,
462 LINK_URL = X_LINK_URL,
463 SEND_FOR_PREVIEW_FLAG = X_SEND_FOR_PREVIEW_FLAG,
464 ATTACHMENT_TYPE = X_ATTACHMENT_TYPE,
465 LANGUAGE_CODE = X_LANGUAGE_CODE,
466 APPLICATION_ID = X_APPLICATION_ID,
467 DESCRIPTION = X_DESCRIPTION,
468 DEFAULT_STYLE_SHEET = X_DEFAULT_STYLE_SHEET,
469 DISPLAY_URL = X_DISPLAY_URL,
470 DISPLAY_RULE_ID = X_DISPLAY_RULE_ID,
471 DISPLAY_PROGRAM = X_DISPLAY_PROGRAM,
472 ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
473 ATTRIBUTE1 = X_ATTRIBUTE1,
474 ATTRIBUTE2 = X_ATTRIBUTE2,
475 ATTRIBUTE3 = X_ATTRIBUTE3,
476 ATTRIBUTE4 = X_ATTRIBUTE4,
477 ATTRIBUTE5 = X_ATTRIBUTE5,
478 ATTRIBUTE6 = X_ATTRIBUTE6,
479 ATTRIBUTE7 = X_ATTRIBUTE7,
480 ATTRIBUTE8 = X_ATTRIBUTE8,
481 ATTRIBUTE9 = X_ATTRIBUTE9,
482 ATTRIBUTE10 = X_ATTRIBUTE10,
483 ATTRIBUTE11 = X_ATTRIBUTE11,
484 ATTRIBUTE12 = X_ATTRIBUTE12,
485 ATTRIBUTE13 = X_ATTRIBUTE13,
486 ATTRIBUTE14 = X_ATTRIBUTE14,
487 ATTRIBUTE15 = X_ATTRIBUTE15,
488 DISPLAY_TEXT = X_DISPLAY_TEXT,
489 ALTERNATE_TEXT = X_ALTERNATE_TEXT,
490 ATTACHMENT_SUB_TYPE = X_ATTACHMENT_SUB_TYPE,
491 DOCUMENT_ID = X_DOCUMENT_ID,
492 SECURED_FLAG = X_SECURED_FLAG
493 where ATTACHMENT_ID = X_ATTACHMENT_ID;
494
495 if (sql%notfound) then
496 raise no_data_found;
497 end if;
498 END;
499
500 procedure LOAD_SEED_ROW(
501 x_upload_mode in varchar2,
502 x_attachment_id in varchar2,
503 x_object_version_number in varchar2,
504 x_owner_user_id in varchar2,
505 x_attachment_used_by_id in varchar2,
506 x_attachment_used_by in varchar2,
507 x_version in varchar2,
508 x_enabled_flag in varchar2,
509 x_can_fulfill_electronic_flag in varchar2,
510 x_file_id in varchar2,
511 x_file_name in varchar2,
512 x_file_extension in varchar2,
513 x_keywords in varchar2,
514 x_display_width in varchar2,
515 x_display_height in varchar2,
516 x_display_location in varchar2,
517 x_link_to in varchar2,
518 x_link_url in varchar2,
519 x_send_for_preview_flag in varchar2,
520 x_attachment_type in varchar2,
521 x_language_code in varchar2,
522 x_application_id in varchar2,
523 x_description in varchar2,
524 x_default_style_sheet in varchar2,
525 x_display_url in varchar2,
526 x_display_rule_id in varchar2,
527 x_display_program in varchar2,
528 x_attribute_category in varchar2,
529 x_attribute1 in varchar2,
530 x_attribute2 in varchar2,
531 x_attribute3 in varchar2,
532 x_attribute4 in varchar2,
533 x_attribute5 in varchar2,
534 x_attribute6 in varchar2,
535 x_attribute7 in varchar2,
536 x_attribute8 in varchar2,
537 x_attribute9 in varchar2,
538 x_attribute10 in varchar2,
539 x_attribute11 in varchar2,
540 x_attribute12 in varchar2,
541 x_attribute13 in varchar2,
542 x_attribute14 in varchar2,
543 x_attribute15 in varchar2,
544 x_display_text in varchar2,
545 x_alternate_text in varchar2,
546 x_attachment_sub_type in varchar2,
547 x_document_id in varchar2,
548 x_secured_flag in varchar2,
549 x_owner in varchar2,
550 x_custom_mode in varchar2,
551 x_last_update_date in varchar2)
552 is
553 v_db_owner_id number;
554 begin
555 if (x_upload_mode = 'NLS') then
556 null;
557 else
558
559
560 JTF_AMV_ATTCHS_PKG.LOAD_ROW (
561 X_ATTACHMENT_ID => x_attachment_id,
562 X_OBJECT_VERSION_NUMBER => x_object_version_number,
563 X_OWNER_USER_ID => x_owner_user_id,
564 X_ATTACHMENT_USED_BY_ID => x_attachment_used_by_id,
565 X_ATTACHMENT_USED_BY => x_attachment_used_by,
566 X_VERSION => x_version,
567 X_ENABLED_FLAG => x_enabled_flag,
571 X_FILE_EXTENSION => x_file_extension,
568 X_CAN_FULFILL_ELECTRONIC_FLAG => x_can_fulfill_electronic_flag,
569 X_FILE_ID => x_file_id,
570 X_FILE_NAME => x_file_name,
572 X_KEYWORDS => x_keywords,
573 X_DISPLAY_WIDTH => x_display_width,
574 X_DISPLAY_HEIGHT => x_display_height,
575 X_DISPLAY_LOCATION =>x_display_location,
576 X_LINK_TO => x_link_to,
577 X_LINK_URL => x_link_url,
578 X_SEND_FOR_PREVIEW_FLAG => x_send_for_preview_flag,
579 X_ATTACHMENT_TYPE => x_attachment_type,
580 X_LANGUAGE_CODE => x_language_code,
581 X_APPLICATION_ID => x_application_id,
582 X_DESCRIPTION => x_description,
583 X_DEFAULT_STYLE_SHEET => x_default_style_sheet,
584 X_DISPLAY_URL => x_display_url,
585 X_DISPLAY_RULE_ID => x_display_rule_id,
586 X_DISPLAY_PROGRAM => x_display_program,
587 X_ATTRIBUTE_CATEGORY => x_attribute_category,
588 X_ATTRIBUTE1 => x_attribute1,
589 X_ATTRIBUTE2 => x_attribute2,
590 X_ATTRIBUTE3 => x_attribute3,
591 X_ATTRIBUTE4 => x_attribute4,
592 X_ATTRIBUTE5 => x_attribute5,
593 X_ATTRIBUTE6 => x_attribute6,
594 X_ATTRIBUTE7 => x_attribute7,
595 X_ATTRIBUTE8 => x_attribute8,
596 X_ATTRIBUTE9 => x_attribute9,
597 X_ATTRIBUTE10 => x_attribute10,
598 X_ATTRIBUTE11 => x_attribute11,
599 X_ATTRIBUTE12 => x_attribute12,
600 X_ATTRIBUTE13 => x_attribute13,
601 X_ATTRIBUTE14 => x_attribute14,
602 X_ATTRIBUTE15 => x_attribute15,
603 X_DISPLAY_TEXT => x_display_text,
604 X_ALTERNATE_TEXT => x_alternate_text,
605 X_ATTACHMENT_SUB_TYPE => x_attachment_sub_type,
606 X_DOCUMENT_ID => x_document_id,
607 X_SECURED_FLAG => x_secured_flag,
608 X_Owner => x_owner,
609 x_custom_mode => x_custom_mode,
610 x_last_update_date=> x_last_update_date
611 );
612
613
614 end if;
615
616
617 exception
618 when no_data_found then
619 JTF_AMV_ATTCHS_PKG.LOAD_ROW (
620 X_ATTACHMENT_ID => x_attachment_id,
621 X_OBJECT_VERSION_NUMBER => x_object_version_number,
622 X_OWNER_USER_ID => x_owner_user_id,
623 X_ATTACHMENT_USED_BY_ID => x_attachment_used_by_id,
624 X_ATTACHMENT_USED_BY => x_attachment_used_by,
625 X_VERSION => x_version,
626 X_ENABLED_FLAG => x_enabled_flag,
627 X_CAN_FULFILL_ELECTRONIC_FLAG => x_can_fulfill_electronic_flag,
628 X_FILE_ID => x_file_id,
629 X_FILE_NAME => x_file_name,
630 X_FILE_EXTENSION => x_file_extension,
631 X_KEYWORDS => x_keywords,
632 X_DISPLAY_WIDTH => x_display_width,
633 X_DISPLAY_HEIGHT => x_display_height,
634 X_DISPLAY_LOCATION => x_display_location,
635 X_LINK_TO => x_link_to,
636 X_LINK_URL => x_link_url,
637 X_SEND_FOR_PREVIEW_FLAG => x_send_for_preview_flag,
638 X_ATTACHMENT_TYPE => x_attachment_type,
639 X_LANGUAGE_CODE => x_language_code,
640 X_APPLICATION_ID => x_application_id,
641 X_DESCRIPTION => x_description,
642 X_DEFAULT_STYLE_SHEET => x_default_style_sheet,
643 X_DISPLAY_URL => x_display_url,
644 X_DISPLAY_RULE_ID => x_display_rule_id,
645 X_DISPLAY_PROGRAM => x_display_program,
646 X_ATTRIBUTE_CATEGORY => x_attribute_category,
647 X_ATTRIBUTE1 => x_attribute1,
648 X_ATTRIBUTE2 => x_attribute2,
649 X_ATTRIBUTE3 => x_attribute3,
650 X_ATTRIBUTE4 => x_attribute4,
651 X_ATTRIBUTE5 => x_attribute5,
652 X_ATTRIBUTE6 => x_attribute6,
653 X_ATTRIBUTE7 => x_attribute7,
654 X_ATTRIBUTE8 => x_attribute8,
655 X_ATTRIBUTE9 => x_attribute9,
656 X_ATTRIBUTE10 => x_attribute10,
657 X_ATTRIBUTE11 => x_attribute11,
658 X_ATTRIBUTE12 => x_attribute12,
659 X_ATTRIBUTE13 => x_attribute13,
660 X_ATTRIBUTE14 => x_attribute14,
661 X_ATTRIBUTE15 => x_attribute15,
662 X_DISPLAY_TEXT => x_display_text,
663 X_ALTERNATE_TEXT => x_alternate_text,
664 X_ATTACHMENT_SUB_TYPE => x_attachment_sub_type,
665 X_DOCUMENT_ID => x_document_id,
666 X_SECURED_FLAG => x_secured_flag,
667 X_Owner => x_owner,
668 x_custom_mode =>x_custom_mode,
669 x_last_update_date=>x_last_update_date
670 );
671 END LOAD_SEED_ROW;
672
673 end JTF_AMV_ATTCHS_PKG;