APPS.FND_WEBATTCH dependencies on FND_DOCUMENTS_SHORT_TEXT

Line 980: INSERT INTO fnd_documents_short_text(

976:
977: -- Commit the transaction
978: commit;
979: elsif (to_number(datatype_id) = 1 ) then -- Short text Type Documents.
980: INSERT INTO fnd_documents_short_text(
981: media_id,
982: short_text) VALUES (
983: l_media_id,
984: text);

Line 1262: -- When the text is altered the the fnd_documents_short_text

1258:
1259: -- Commit the transaction.
1260: commit;
1261:
1262: -- When the text is altered the the fnd_documents_short_text
1263: -- needs to be updated. When the file type is altered we have to
1264: -- upload the file.
1265: if (datatype_id = 1 ) then -- Short Text Datatype
1266: UPDATE fnd_documents_short_text

Line 1266: UPDATE fnd_documents_short_text

1262: -- When the text is altered the the fnd_documents_short_text
1263: -- needs to be updated. When the file type is altered we have to
1264: -- upload the file.
1265: if (datatype_id = 1 ) then -- Short Text Datatype
1266: UPDATE fnd_documents_short_text
1267: set short_text = text
1268: where media_id = l_media_id;
1269:
1270: -- Commit the transaction.

Line 1849: from fnd_attached_docs_form_vl fdfv, fnd_documents_short_text fdst

1845: else
1846: select fdfv.seq_num, fdfv.category_description,
1847: fdfv.document_description, fdst.short_text
1848: into l_seq_num,l_category_description,l_document_description,l_text
1849: from fnd_attached_docs_form_vl fdfv, fnd_documents_short_text fdst
1850: where fdfv.media_id = fdst.media_id
1851: and fdfv.attached_document_id = to_number(l_attached_document_id)
1852: and fdfv.function_name = l_function_name
1853: and fdfv.function_type = 'F';

Line 2137: from fnd_documents_short_text

2133: -- Query the text from the database.
2134: if (x_datatype_id = 1 ) then
2135: select short_text
2136: into document_short_text
2137: from fnd_documents_short_text
2138: where media_id = x_media_id;
2139:
2140: -- Display the blank text information for Update.
2141: DocumentInformation (x_datatype_id => x_datatype_id,