APPS.FND_WEBATTCH dependencies on FND_ATTACHED_DOCUMENTS

Line 494: fnd_attached_documents3_pkg.delete_row ( l_attached_document_id,

490: l_file_name := deldatarec.file_name;
491: l_media_id := deldatarec.media_id;
492:
493: -- Call the procedure to delete the attachment and document.
494: fnd_attached_documents3_pkg.delete_row ( l_attached_document_id,
495: l_datatype_id, 'Y' );
496:
497: -- Delete the file from fnd_lobs.
498: if (l_datatype_id = 6 ) then

Line 691: from fnd_attached_documents ad, fnd_documents_tl dt

687: ) as
688:
689: cursor filename_cursor (l_attached_document_id varchar2) is
690: select dt.file_name, dt.media_id
691: from fnd_attached_documents ad, fnd_documents_tl dt
692: where ad.document_id = dt.document_id
693: and ad.attached_document_id = to_number(l_attached_document_id);
694:
695: l_url varchar2(255);

Line 847: select fnd_attached_documents_s.nextval

843: l_created_by := to_number(user_id);
844: l_last_updated_by := l_created_by;
845:
846: -- Attached Document Id has to be populated from the sequence.
847: select fnd_attached_documents_s.nextval
848: into l_attached_document_id
849: from sys.dual;
850:
851: -- Set the language parameter

Line 857: fnd_attached_documents_pkg.insert_row (

853: into l_lang
854: from dual;
855:
856: -- Call the server side package for adding the attachment and documents.
857: fnd_attached_documents_pkg.insert_row (
858: x_rowid => l_rowid ,
859: x_attached_document_id => l_attached_document_id ,
860: x_document_id => l_document_id ,
861: x_creation_date => l_creation_date ,

Line 931: -- After the data is inserted into fnd_attached_documents, fnd_documents and

927:
928: -- Commit the transaction
929: commit;
930:
931: -- After the data is inserted into fnd_attached_documents, fnd_documents and
932: -- fnd_documents_tl table using the above procedure we get the media_id
933: -- which will be used to insert the text into fnd_document_short_text table.
934: if (to_number(datatype_id) = 2 ) then -- Text Datatype
935: INSERT INTO fnd_documents_long_text(

Line 1116: fnd_attached_documents_pkg.update_row (

1112: into l_lang
1113: from dual;
1114:
1115: -- Call the server side package for adding the attachment and documents.
1116: fnd_attached_documents_pkg.update_row (
1117: x_rowid => upddatarec.row_id ,
1118: x_attached_document_id => attached_document_id ,
1119: x_document_id => upddatarec.document_id ,
1120: x_last_update_date => l_last_update_date ,

Line 1756: from fnd_documents fd, fnd_attached_documents fad

1752:
1753: -- Find out the datatype of text being displayed.
1754: select fd.datatype_id
1755: into l_datatype_id
1756: from fnd_documents fd, fnd_attached_documents fad
1757: where fd.document_id = fad.document_id
1758: and fad.attached_document_id = to_number(l_attached_document_id);
1759:
1760: -- Get the document text for the attachment.

Line 2229: from fnd_attached_documents

2225: order by user_name;
2226:
2227: cursor sm_cursor is
2228: select NVL(max(seq_num),0) + 10
2229: from fnd_attached_documents
2230: where entity_name = PrintAddAttachment.entity_name
2231: and pk1_value = PrintAddAttachment.pk1_value
2232: and decode(PrintAddAttachment.pk2_value,null,'*',PK2_VALUE) =
2233: decode(PrintAddAttachment.pk2_value,null,'*',PrintAddAttachment.pk2_value)