[Home] [Help]
PACKAGE BODY: APPS.FND_ATTACHED_DOCUMENTS_PKG
Source
1 PACKAGE BODY fnd_attached_documents_pkg as
2 /* $Header: AFAKAADB.pls 120.3.12010000.2 2008/11/07 17:45:42 ctilley ship $ */
3
4
5 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
6 X_attached_document_id IN OUT NOCOPY NUMBER,
7 X_document_id IN OUT NOCOPY NUMBER,
8 X_creation_date DATE,
9 X_created_by NUMBER,
10 X_last_update_date DATE,
11 X_last_updated_by NUMBER,
12 X_last_update_login NUMBER DEFAULT NULL,
13 X_seq_num NUMBER,
14 X_entity_name VARCHAR2,
15 X_column1 VARCHAR2,
16 X_pk1_value VARCHAR2,
17 X_pk2_value VARCHAR2,
18 X_pk3_value VARCHAR2,
19 X_pk4_value VARCHAR2,
20 X_pk5_value VARCHAR2,
21 X_automatically_added_flag VARCHAR2,
22 X_request_id NUMBER DEFAULT NULL,
23 X_program_application_id NUMBER DEFAULT NULL,
24 X_program_id NUMBER DEFAULT NULL,
25 X_program_update_date DATE DEFAULT NULL,
26 X_Attribute_Category VARCHAR2 DEFAULT NULL,
27 X_Attribute1 VARCHAR2 DEFAULT NULL,
28 X_Attribute2 VARCHAR2 DEFAULT NULL,
29 X_Attribute3 VARCHAR2 DEFAULT NULL,
30 X_Attribute4 VARCHAR2 DEFAULT NULL,
31 X_Attribute5 VARCHAR2 DEFAULT NULL,
32 X_Attribute6 VARCHAR2 DEFAULT NULL,
33 X_Attribute7 VARCHAR2 DEFAULT NULL,
34 X_Attribute8 VARCHAR2 DEFAULT NULL,
35 X_Attribute9 VARCHAR2 DEFAULT NULL,
36 X_Attribute10 VARCHAR2 DEFAULT NULL,
37 X_Attribute11 VARCHAR2 DEFAULT NULL,
38 X_Attribute12 VARCHAR2 DEFAULT NULL,
39 X_Attribute13 VARCHAR2 DEFAULT NULL,
40 X_Attribute14 VARCHAR2 DEFAULT NULL,
41 X_Attribute15 VARCHAR2 DEFAULT NULL,
42 /* columns necessary for creating a document on the fly */
43 X_datatype_id NUMBER,
44 X_category_id NUMBER,
45 X_security_type NUMBER,
46 X_security_id NUMBER DEFAULT NULL,
47 X_publish_flag VARCHAR2,
48 X_image_type VARCHAR2 DEFAULT NULL,
49 X_storage_type NUMBER DEFAULT NULL,
50 X_usage_type VARCHAR2,
51 X_language VARCHAR2,
52 X_description VARCHAR2 DEFAULT NULL,
53 X_file_name VARCHAR2 DEFAULT NULL,
54 X_media_id IN OUT NOCOPY NUMBER,
55 X_doc_attribute_Category VARCHAR2,
56 X_doc_attribute1 VARCHAR2,
57 X_doc_attribute2 VARCHAR2,
58 X_doc_attribute3 VARCHAR2,
59 X_doc_attribute4 VARCHAR2,
60 X_doc_attribute5 VARCHAR2,
61 X_doc_attribute6 VARCHAR2,
62 X_doc_attribute7 VARCHAR2,
63 X_doc_attribute8 VARCHAR2,
64 X_doc_attribute9 VARCHAR2,
65 X_doc_attribute10 VARCHAR2,
66 X_doc_attribute11 VARCHAR2,
67 X_doc_attribute12 VARCHAR2,
68 X_doc_attribute13 VARCHAR2,
69 X_doc_attribute14 VARCHAR2,
70 X_doc_attribute15 VARCHAR2,
71 X_create_doc VARCHAR2 DEFAULT 'N',
72 X_url VARCHAR2 DEFAULT NULL,
73 X_title VARCHAR2 DEFAULT NULL) IS
74
75 tmp_rowid VARCHAR2(30);
76
77
78 CURSOR C IS SELECT rowid
79 FROM fnd_attached_documents
80 WHERE attached_document_id = X_attached_document_id;
81
82 l_usage_type varchar2(1);
83 l_create_doc varchar2(1);
84
85
86 BEGIN
87
88 -- Create document if necessary (indicated by X_document_id being
89 -- null)
90 IF (X_document_id IS NULL) THEN
91
92 if (x_usage_type = 'T') then
93 l_usage_type := 'O';
94 l_create_doc := 'Y';
95 else
96 l_usage_type := x_usage_type;
97 l_create_doc := x_create_doc;
98 end if;
99
100
101 fnd_documents_pkg.insert_row(
102 X_rowid => tmp_rowid,
103 X_document_id => X_document_id,
104 X_creation_date => X_creation_date,
105 X_created_by => X_created_by,
106 X_last_update_date => X_last_update_date,
107 X_last_updated_by => X_last_updated_by,
108 X_last_update_login => X_last_update_login,
109 X_datatype_id => X_datatype_id,
110 X_category_id => X_category_id,
111 X_security_type => X_security_type,
112 X_security_id => X_security_id,
113 X_publish_flag => X_publish_flag,
114 X_image_type => X_image_type,
115 X_storage_type => X_storage_type,
116 X_usage_type => NVL(l_usage_type,'O'),
117 X_start_date_active => null,
118 X_end_date_active => null,
119 X_request_id => X_request_id,
120 X_program_application_id => X_program_application_id,
121 X_program_id => X_program_id,
122 X_program_update_date => X_program_update_date,
123 X_language => X_language,
124 X_description => X_description,
125 X_file_name => X_file_name,
126 X_media_id => X_media_id,
127 X_attribute_category => X_doc_attribute_category,
128 X_attribute1 => X_doc_attribute1,
129 X_attribute2 => X_doc_attribute2,
130 X_attribute3 => X_doc_attribute3,
131 X_attribute4 => X_doc_attribute4,
132 X_attribute5 => X_doc_attribute5,
133 X_attribute6 => X_doc_attribute6,
134 X_attribute7 => X_doc_attribute7,
135 X_attribute8 => X_doc_attribute8,
136 X_attribute9 => X_doc_attribute9,
137 X_attribute10 => X_doc_attribute10,
138 X_attribute11 => X_doc_attribute11,
139 X_attribute12 => X_doc_attribute12,
140 X_attribute13 => X_doc_attribute13,
141 X_attribute14 => X_doc_attribute14,
142 X_attribute15 => X_doc_attribute15,
143 X_create_doc => l_create_doc,
144 X_url => X_url,
145 X_title => X_title);
146
147 END IF; -- done creating document
148
149 INSERT INTO fnd_attached_documents (
150 attached_document_id,
151 document_id,
152 creation_date,
153 created_by,
154 last_update_date,
155 last_updated_by,
156 last_update_login,
157 seq_num,
158 entity_name,
159 column1,
160 pk1_value,
161 pk2_value,
162 pk3_value,
163 pk4_value,
164 pk5_value,
165 automatically_added_flag,
166 attribute_category,
167 attribute1,
168 attribute2,
169 attribute3,
170 attribute4,
171 attribute5,
172 attribute6,
173 attribute7,
174 attribute8,
175 attribute9,
176 attribute10,
177 attribute11,
178 attribute12,
179 attribute13,
180 attribute14,
181 attribute15,
182 category_id) VALUES (
183 X_attached_document_id,
184 X_document_id,
185 X_creation_date,
186 X_created_by,
187 X_last_update_date,
188 X_last_updated_by,
189 X_last_update_login,
190 X_seq_num,
191 X_entity_name,
192 X_column1,
193 X_pk1_value,
194 X_pk2_value,
195 X_pk3_value,
196 X_pk4_value,
197 X_pk5_value,
198 X_automatically_added_flag,
199 X_attribute_category,
200 X_attribute1,
201 X_attribute2,
202 X_attribute3,
203 X_attribute4,
204 X_attribute5,
205 X_attribute6,
206 X_attribute7,
207 X_attribute8,
208 X_attribute9,
209 X_attribute10,
210 X_attribute11,
211 X_attribute12,
212 X_attribute13,
213 X_attribute14,
214 X_attribute15,
215 X_category_id);
216
217 -- get rowid to pass back to form
218 OPEN C;
219 FETCH C INTO X_Rowid;
220 if (C%NOTFOUND) then
221 CLOSE C;
222 RAISE NO_DATA_FOUND;
223 end if;
224 CLOSE C;
225
226 END insert_row;
227
228
229
230
231 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
232 X_attached_document_id NUMBER,
233 X_document_id NUMBER,
234 X_seq_num NUMBER,
235 X_entity_name VARCHAR2,
236 X_column1 VARCHAR2,
237 X_pk1_value VARCHAR2,
238 X_pk2_value VARCHAR2,
239 X_pk3_value VARCHAR2,
240 X_pk4_value VARCHAR2,
241 X_pk5_value VARCHAR2,
242 X_automatically_added_flag VARCHAR2,
243 X_Attribute_Category VARCHAR2 DEFAULT NULL,
244 X_Attribute1 VARCHAR2 DEFAULT NULL,
245 X_Attribute2 VARCHAR2 DEFAULT NULL,
246 X_Attribute3 VARCHAR2 DEFAULT NULL,
247 X_Attribute4 VARCHAR2 DEFAULT NULL,
248 X_Attribute5 VARCHAR2 DEFAULT NULL,
249 X_Attribute6 VARCHAR2 DEFAULT NULL,
250 X_Attribute7 VARCHAR2 DEFAULT NULL,
251 X_Attribute8 VARCHAR2 DEFAULT NULL,
252 X_Attribute9 VARCHAR2 DEFAULT NULL,
253 X_Attribute10 VARCHAR2 DEFAULT NULL,
254 X_Attribute11 VARCHAR2 DEFAULT NULL,
255 X_Attribute12 VARCHAR2 DEFAULT NULL,
256 X_Attribute13 VARCHAR2 DEFAULT NULL,
257 X_Attribute14 VARCHAR2 DEFAULT NULL,
258 X_Attribute15 VARCHAR2 DEFAULT NULL,
259 /* columns necessary for creating a document on the fly */
260 X_datatype_id NUMBER,
261 X_category_id NUMBER,
262 X_security_type NUMBER,
263 X_security_id NUMBER DEFAULT NULL,
264 X_publish_flag VARCHAR2,
265 X_image_type VARCHAR2 DEFAULT NULL,
266 X_storage_type NUMBER DEFAULT NULL,
267 X_usage_type VARCHAR2,
268 X_start_date_Active DATE,
269 X_end_date_Active DATE,
270 X_language VARCHAR2,
271 X_description VARCHAR2 DEFAULT NULL,
272 X_file_name VARCHAR2 DEFAULT NULL,
273 X_media_id IN OUT NOCOPY NUMBER,
274 X_doc_attribute_category VARCHAR2 DEFAULT NULL,
275 X_doc_attribute1 VARCHAR2 DEFAULT NULL,
276 X_doc_attribute2 VARCHAR2 DEFAULT NULL,
277 X_doc_attribute3 VARCHAR2 DEFAULT NULL,
278 X_doc_attribute4 VARCHAR2 DEFAULT NULL,
279 X_doc_attribute5 VARCHAR2 DEFAULT NULL,
280 X_doc_attribute6 VARCHAR2 DEFAULT NULL,
281 X_doc_attribute7 VARCHAR2 DEFAULT NULL,
282 X_doc_attribute8 VARCHAR2 DEFAULT NULL,
283 X_doc_attribute9 VARCHAR2 DEFAULT NULL,
284 X_doc_attribute10 VARCHAR2 DEFAULT NULL,
285 X_doc_attribute11 VARCHAR2 DEFAULT NULL,
286 X_doc_attribute12 VARCHAR2 DEFAULT NULL,
287 X_doc_attribute13 VARCHAR2 DEFAULT NULL,
288 X_doc_attribute14 VARCHAR2 DEFAULT NULL,
289 X_doc_attribute15 VARCHAR2 DEFAULT NULL,
290 X_url VARCHAR2 DEFAULT NULL,
291 X_title VARCHAR2 DEFAULT NULL) IS
292 CURSOR C IS
293 SELECT *
294 FROM fnd_attached_documents
295 WHERE rowid = X_Rowid
296 FOR UPDATE of attached_document_id NOWAIT;
297 Recinfo C%ROWTYPE;
298 BEGIN
299 OPEN C;
300 FETCH C INTO Recinfo;
301 if (C%NOTFOUND) then
302 CLOSE C;
303 FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
304 APP_EXCEPTION.Raise_Exception;
305 -- RAISE NO_DATA_FOUND;
306 end if;
307 CLOSE C;
308
309 if (
310 ( (Recinfo.attached_document_id = X_attached_document_id) )
311 AND ( (Recinfo.document_id = X_document_id) )
312 AND ( (Recinfo.seq_num = X_seq_num) )
313 AND ( (Recinfo.entity_name = X_entity_name) )
314 AND ( (Recinfo.pk1_value = X_pk1_value)
315 OR ( (Recinfo.pk1_value IS NULL)
316 AND (X_pk1_value IS NULL)))
320 AND ( (Recinfo.pk3_value = X_pk3_value)
317 AND ( (Recinfo.pk2_value = X_pk2_value)
318 OR ( (Recinfo.pk2_value IS NULL)
319 AND (X_pk2_value IS NULL)))
321 OR ( (Recinfo.pk3_value IS NULL)
322 AND (X_pk3_value IS NULL)))
323 AND ( (Recinfo.pk4_value = X_pk4_value)
324 OR ( (Recinfo.pk4_value IS NULL)
325 AND (X_pk4_value IS NULL)))
326 AND ( (Recinfo.pk5_value = X_pk5_value)
327 OR ( (Recinfo.pk5_value IS NULL)
328 AND (X_pk5_value IS NULL)))
329 AND ( (Recinfo.automatically_added_flag =
330 X_automatically_added_flag) )
331 AND ( (Recinfo.attribute_category = X_Attribute_Category)
332 OR ( (Recinfo.attribute_category IS NULL)
333 AND (X_Attribute_Category IS NULL)))
334 AND ( (Recinfo.attribute1 = X_Attribute1)
335 OR ( (Recinfo.attribute1 IS NULL)
336 AND (X_Attribute1 IS NULL)))
337 AND ( (Recinfo.attribute2 = X_Attribute2)
338 OR ( (Recinfo.attribute2 IS NULL)
339 AND (X_Attribute2 IS NULL)))
340 AND ( (Recinfo.attribute3 = X_Attribute3)
341 OR ( (Recinfo.attribute3 IS NULL)
342 AND (X_Attribute3 IS NULL)))
343 AND ( (Recinfo.attribute4 = X_Attribute4)
344 OR ( (Recinfo.attribute4 IS NULL)
345 AND (X_Attribute4 IS NULL)))
346 AND ( (Recinfo.attribute5 = X_Attribute5)
347 OR ( (Recinfo.attribute5 IS NULL)
348 AND (X_Attribute5 IS NULL)))
349 AND ( (Recinfo.attribute6 = X_Attribute6)
350 OR ( (Recinfo.attribute6 IS NULL)
351 AND (X_Attribute6 IS NULL)))
352 AND ( (Recinfo.attribute7 = X_Attribute7)
353 OR ( (Recinfo.attribute7 IS NULL)
354 AND (X_Attribute7 IS NULL)))
355 AND ( (Recinfo.attribute8 = X_Attribute8)
356 OR ( (Recinfo.attribute8 IS NULL)
357 AND (X_Attribute8 IS NULL)))
358 AND ( (Recinfo.attribute9 = X_Attribute9)
359 OR ( (Recinfo.attribute9 IS NULL)
360 AND (X_Attribute9 IS NULL)))
361 AND ( (Recinfo.attribute10 = X_Attribute10)
362 OR ( (Recinfo.attribute10 IS NULL)
363 AND (X_Attribute10 IS NULL)))
364 AND ( (Recinfo.attribute11 = X_Attribute11)
365 OR ( (Recinfo.attribute11 IS NULL)
366 AND (X_Attribute11 IS NULL)))
367 AND ( (Recinfo.attribute12 = X_Attribute12)
368 OR ( (Recinfo.attribute12 IS NULL)
369 AND (X_Attribute12 IS NULL)))
370 AND ( (Recinfo.attribute13 = X_Attribute13)
371 OR ( (Recinfo.attribute13 IS NULL)
372 AND (X_Attribute13 IS NULL)))
373 AND ( (Recinfo.attribute14 = X_Attribute14)
374 OR ( (Recinfo.attribute14 IS NULL)
375 AND (X_Attribute14 IS NULL)))
376 AND ( (Recinfo.attribute15 = X_Attribute15)
377 OR ( (Recinfo.attribute15 IS NULL)
378 AND (X_Attribute15 IS NULL)))
379 ) then
380 -- lock document as it's most likely what's changed!
381 fnd_documents_pkg.lock_row(X_document_id => X_document_id,
382 X_datatype_id => X_datatype_id,
383 X_category_id => X_category_id,
384 X_security_type => X_security_type,
385 X_security_id => X_security_id,
386 X_publish_flag => X_publish_flag,
387 X_image_type => X_image_type,
388 X_storage_type => X_storage_type,
389 X_usage_type => X_usage_type,
390 X_start_date_active => X_start_date_Active,
391 X_end_date_active => X_end_date_Active,
392 X_language => X_language,
393 X_description => X_description,
394 X_file_name => X_file_name,
395 X_media_id => X_media_id,
396 X_Attribute_Category => X_doc_attribute_category,
397 X_Attribute1 => X_doc_attribute1,
398 X_Attribute2 => X_doc_attribute2,
399 X_Attribute3 => X_doc_attribute3,
400 X_Attribute4 => X_doc_attribute4,
401 X_Attribute5 => X_doc_attribute5,
402 X_Attribute6 => X_doc_attribute6,
403 X_Attribute7 => X_doc_attribute7,
404 X_Attribute8 => X_doc_attribute8,
405 X_Attribute9 => X_doc_attribute9,
406 X_Attribute10 => X_doc_attribute10,
407 X_Attribute11 => X_doc_attribute11,
408 X_Attribute12 => X_doc_attribute12,
409 X_Attribute13 => X_doc_attribute13,
410 X_Attribute14 => X_doc_attribute14,
411 X_Attribute15 => X_doc_attribute15,
412 X_url => X_url,
413 X_title => X_title);
414
415 return;
416 else
417 FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
418 APP_EXCEPTION.RAISE_EXCEPTION;
419 end if;
420
421 END lock_Row;
422
423
424
425 PROCEDURE Update_Row(X_Rowid VARCHAR2,
426 X_attached_document_id NUMBER,
427 X_document_id NUMBER,
431 X_seq_num NUMBER,
428 X_last_update_date DATE,
429 X_last_updated_by NUMBER,
430 X_last_update_login NUMBER DEFAULT NULL,
432 X_entity_name VARCHAR2,
433 X_column1 VARCHAR2,
434 X_pk1_value VARCHAR2,
435 X_pk2_value VARCHAR2,
436 X_pk3_value VARCHAR2,
437 X_pk4_value VARCHAR2,
438 X_pk5_value VARCHAR2,
439 X_automatically_added_flag VARCHAR2,
440 X_request_id NUMBER DEFAULT NULL,
441 X_program_application_id NUMBER DEFAULT NULL,
442 X_program_id NUMBER DEFAULT NULL,
443 X_program_update_date DATE DEFAULT NULL,
444 X_Attribute_Category VARCHAR2 DEFAULT NULL,
445 X_Attribute1 VARCHAR2 DEFAULT NULL,
446 X_Attribute2 VARCHAR2 DEFAULT NULL,
447 X_Attribute3 VARCHAR2 DEFAULT NULL,
448 X_Attribute4 VARCHAR2 DEFAULT NULL,
449 X_Attribute5 VARCHAR2 DEFAULT NULL,
450 X_Attribute6 VARCHAR2 DEFAULT NULL,
451 X_Attribute7 VARCHAR2 DEFAULT NULL,
452 X_Attribute8 VARCHAR2 DEFAULT NULL,
453 X_Attribute9 VARCHAR2 DEFAULT NULL,
454 X_Attribute10 VARCHAR2 DEFAULT NULL,
455 X_Attribute11 VARCHAR2 DEFAULT NULL,
456 X_Attribute12 VARCHAR2 DEFAULT NULL,
457 X_Attribute13 VARCHAR2 DEFAULT NULL,
458 X_Attribute14 VARCHAR2 DEFAULT NULL,
459 X_Attribute15 VARCHAR2 DEFAULT NULL,
460 /* columns necessary for creating a document on the fly */
461 X_datatype_id NUMBER,
462 X_category_id NUMBER,
463 X_security_type NUMBER,
464 X_security_id NUMBER DEFAULT NULL,
465 X_publish_flag VARCHAR2,
466 X_image_type VARCHAR2 DEFAULT NULL,
467 X_storage_type NUMBER DEFAULT NULL,
468 X_usage_type VARCHAR2,
469 X_start_date_active DATE,
470 X_end_date_active DATE,
471 X_language VARCHAR2,
472 X_description VARCHAR2 DEFAULT NULL,
473 X_file_name VARCHAR2 DEFAULT NULL,
477 X_doc_attribute2 VARCHAR2 DEFAULT NULL,
474 X_media_id IN OUT NOCOPY NUMBER,
475 X_doc_attribute_category VARCHAR2 DEFAULT NULL,
476 X_doc_attribute1 VARCHAR2 DEFAULT NULL,
478 X_doc_attribute3 VARCHAR2 DEFAULT NULL,
479 X_doc_attribute4 VARCHAR2 DEFAULT NULL,
480 X_doc_attribute5 VARCHAR2 DEFAULT NULL,
481 X_doc_attribute6 VARCHAR2 DEFAULT NULL,
482 X_doc_attribute7 VARCHAR2 DEFAULT NULL,
483 X_doc_attribute8 VARCHAR2 DEFAULT NULL,
484 X_doc_attribute9 VARCHAR2 DEFAULT NULL,
485 X_doc_attribute10 VARCHAR2 DEFAULT NULL,
486 X_doc_attribute11 VARCHAR2 DEFAULT NULL,
487 X_doc_attribute12 VARCHAR2 DEFAULT NULL,
488 X_doc_attribute13 VARCHAR2 DEFAULT NULL,
489 X_doc_attribute14 VARCHAR2 DEFAULT NULL,
490 X_doc_attribute15 VARCHAR2 DEFAULT NULL,
491 X_url VARCHAR2 DEFAULT NULL,
492 X_title VARCHAR2 DEFAULT NULL) IS
493 BEGIN
494
495 -- Update the attached_documents table
496 UPDATE fnd_attached_documents
497 SET attached_document_id = X_attached_document_id,
498 document_id = X_document_id,
499 last_update_date = X_last_update_date,
500 last_updated_by = X_last_updated_by,
501 last_update_login = X_last_update_login,
502 seq_num = X_seq_num,
503 entity_name = X_entity_name,
504 column1 = X_column1,
505 pk1_value = X_pk1_value,
506 pk2_value = X_pk2_value,
507 pk3_value = X_pk3_value,
508 pk4_value = X_pk4_value,
509 pk5_value = X_pk5_value,
510 automatically_added_flag = X_automatically_added_flag,
511 attribute_category = X_attribute_category,
512 attribute1 = X_attribute1,
513 attribute2 = X_attribute2,
514 attribute3 = X_attribute3,
515 attribute4 = X_attribute4,
516 attribute5 = X_attribute5,
517 attribute6 = X_attribute6,
518 attribute7 = X_attribute7,
519 attribute8 = X_attribute8,
520 attribute9 = X_attribute9,
521 attribute10 = X_attribute10,
522 attribute11 = X_attribute11,
523 attribute12 = X_attribute12,
524 attribute13 = X_attribute13,
525 attribute14 = X_attribute14,
526 attribute15 = X_attribute15,
527 category_id = X_category_id
528 WHERE rowid = X_rowid;
529
530 if (SQL%NOTFOUND) then
531 RAISE NO_DATA_FOUND;
532 end if;
533
534 -- Call stored procedure to update document tables
535 fnd_documents_pkg.Update_Row(X_document_id => X_document_id,
536 X_last_update_date => X_last_update_date,
537 X_last_updated_by => X_last_updated_by,
538 X_last_update_login => X_last_update_login,
539 X_datatype_id => X_datatype_id,
540 X_category_id => X_category_id,
541 X_security_type => X_security_type,
542 X_security_id => X_security_id,
543 X_publish_flag => X_publish_flag,
544 X_image_type => X_image_type,
545 X_storage_type => X_storage_type,
546 X_usage_type => X_usage_type,
547 X_start_date_active => X_start_date_active,
548 X_end_date_active => X_end_date_active,
549 X_language => X_language,
550 X_description => X_description,
551 X_file_name => X_file_name,
552 X_media_id => X_media_id,
553 X_Attribute_Category => X_doc_attribute_category,
554 X_Attribute1 => X_doc_attribute1,
555 X_Attribute2 => X_doc_attribute2,
556 X_Attribute3 => X_doc_attribute3,
557 X_Attribute4 => X_doc_attribute4,
558 X_Attribute5 => X_doc_attribute5,
559 X_Attribute6 => X_doc_attribute6,
560 X_Attribute7 => X_doc_attribute7,
561 X_Attribute8 => X_doc_attribute8,
562 X_Attribute9 => X_doc_attribute9,
563 X_Attribute10 => X_doc_attribute10,
564 X_Attribute11 => X_doc_attribute11,
565 X_Attribute12 => X_doc_attribute12,
566 X_Attribute13 => X_doc_attribute13,
567 X_Attribute14 => X_doc_attribute14,
568 X_Attribute15 => X_doc_attribute15,
569 X_url => X_url,
570 X_title => X_title);
571
572 END update_row;
573
574 END fnd_attached_documents_pkg;