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 878: select fnd_attached_documents_s.nextval

874: l_created_by := to_number(user_id);
875: l_last_updated_by := l_created_by;
876:
877: -- Attached Document Id has to be populated from the sequence.
878: select fnd_attached_documents_s.nextval
879: into l_attached_document_id
880: from sys.dual;
881:
882: -- Set the language parameter

Line 888: fnd_attached_documents_pkg.insert_row (

884: into l_lang
885: from dual;
886:
887: -- Call the server side package for adding the attachment and documents.
888: fnd_attached_documents_pkg.insert_row (
889: x_rowid => l_rowid ,
890: x_attached_document_id => l_attached_document_id ,
891: x_document_id => l_document_id ,
892: x_creation_date => l_creation_date ,

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

963:
964: -- Commit the transaction
965: commit;
966:
967: -- After the data is inserted into fnd_attached_documents, fnd_documents and
968: -- fnd_documents_tl table using the above procedure we get the media_id
969: -- which will be used to insert the text into fnd_document_short_text table.
970: if (to_number(datatype_id) = 2 ) then -- Text Datatype
971: INSERT INTO fnd_documents_long_text(

Line 1184: fnd_attached_documents_pkg.update_row (

1180: into l_lang
1181: from dual;
1182:
1183: -- Call the server side package for adding the attachment and documents.
1184: fnd_attached_documents_pkg.update_row (
1185: x_rowid => upddatarec.row_id ,
1186: x_attached_document_id => attached_document_id ,
1187: x_document_id => upddatarec.document_id ,
1188: x_last_update_date => l_last_update_date ,

Line 1831: from fnd_documents fd, fnd_attached_documents fad

1827:
1828: -- Find out the datatype of text being displayed.
1829: select fd.datatype_id
1830: into l_datatype_id
1831: from fnd_documents fd, fnd_attached_documents fad
1832: where fd.document_id = fad.document_id
1833: and fad.attached_document_id = to_number(l_attached_document_id);
1834:
1835: -- Get the document text for the attachment.

Line 2304: from fnd_attached_documents

2300: order by user_name;
2301:
2302: cursor sm_cursor is
2303: select NVL(max(seq_num),0) + 10
2304: from fnd_attached_documents
2305: where entity_name = PrintAddAttachment.entity_name
2306: and pk1_value = PrintAddAttachment.pk1_value
2307: and decode(PrintAddAttachment.pk2_value,null,'*',PK2_VALUE) =
2308: decode(PrintAddAttachment.pk2_value,null,'*',PrintAddAttachment.pk2_value)