APPS.FND_WEBATTCH dependencies on FND_DOCUMENTS_LONG_TEXT

Line 971: INSERT INTO fnd_documents_long_text(

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(
972: media_id,
973: long_text) VALUES (
974: l_media_id,
975: text);

Line 1274: UPDATE fnd_documents_long_text

1270: -- Commit the transaction.
1271: commit;
1272:
1273: elsif (datatype_id = 2 ) then -- Long Text Document
1274: UPDATE fnd_documents_long_text
1275: set long_text = text
1276: where media_id = l_media_id;
1277:
1278: -- Commit the transaction.

Line 1840: from fnd_attached_docs_form_vl fdfv, fnd_documents_long_text fdlt

1836: if (l_datatype_id = 2) then
1837: select fdfv.seq_num, fdfv.category_description,
1838: fdfv.document_description, fdlt.long_text
1839: into l_seq_num,l_category_description,l_document_description,l_text
1840: from fnd_attached_docs_form_vl fdfv, fnd_documents_long_text fdlt
1841: where fdfv.media_id = fdlt.media_id
1842: and fdfv.attached_document_id = to_number(l_attached_document_id)
1843: and fdfv.function_name = l_function_name
1844: and fdfv.function_type = 'F';

Line 2147: from fnd_documents_long_text

2143:
2144: elsif (x_datatype_id = 2) then
2145: select long_text
2146: into document_long_text
2147: from fnd_documents_long_text
2148: where media_id = x_media_id;
2149:
2150: -- Display the blank text information for Update.
2151: DocumentInformation (x_datatype_id => x_datatype_id,