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