APPS.FND_WEBATTCH dependencies on FND_DOCUMENTS_LONG_TEXT

Line 935: INSERT INTO fnd_documents_long_text(

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(
936: media_id,
937: long_text) VALUES (
938: l_media_id,
939: text);

Line 1199: UPDATE fnd_documents_long_text

1195: -- Commit the transaction.
1196: commit;
1197:
1198: elsif (datatype_id = 2 ) then -- Long Text Document
1199: UPDATE fnd_documents_long_text
1200: set long_text = text
1201: where media_id = l_media_id;
1202:
1203: -- Commit the transaction.

Line 1765: from fnd_attached_docs_form_vl fdfv, fnd_documents_long_text fdlt

1761: if (l_datatype_id = 2) then
1762: select fdfv.seq_num, fdfv.category_description,
1763: fdfv.document_description, fdlt.long_text
1764: into l_seq_num,l_category_description,l_document_description,l_text
1765: from fnd_attached_docs_form_vl fdfv, fnd_documents_long_text fdlt
1766: where fdfv.media_id = fdlt.media_id
1767: and fdfv.attached_document_id = to_number(l_attached_document_id)
1768: and fdfv.function_name = l_function_name
1769: and fdfv.function_type = 'F';

Line 2072: from fnd_documents_long_text

2068:
2069: elsif (x_datatype_id = 2) then
2070: select long_text
2071: into document_long_text
2072: from fnd_documents_long_text
2073: where media_id = x_media_id;
2074:
2075: -- Display the blank text information for Update.
2076: DocumentInformation (x_datatype_id => x_datatype_id,