[Home] [Help]
940:
941: -- Commit the transaction
942: commit;
943: elsif (to_number(datatype_id) = 1 ) then -- Short text Type Documents.
944: INSERT INTO fnd_documents_short_text(
945: media_id,
946: short_text) VALUES (
947: l_media_id,
948: text);
1183:
1184: -- Commit the transaction.
1185: commit;
1186:
1187: -- When the text is altered the the fnd_documents_short_text
1188: -- needs to be updated. When the file type is altered we have to
1189: -- upload the file.
1190: if (datatype_id = 1 ) then -- Short Text Datatype
1191: UPDATE fnd_documents_short_text
1187: -- When the text is altered the the fnd_documents_short_text
1188: -- needs to be updated. When the file type is altered we have to
1189: -- upload the file.
1190: if (datatype_id = 1 ) then -- Short Text Datatype
1191: UPDATE fnd_documents_short_text
1192: set short_text = text
1193: where media_id = l_media_id;
1194:
1195: -- Commit the transaction.
1770: else
1771: select fdfv.seq_num, fdfv.category_description,
1772: fdfv.document_description, fdst.short_text
1773: into l_seq_num,l_category_description,l_document_description,l_text
1774: from fnd_attached_docs_form_vl fdfv, fnd_documents_short_text fdst
1775: where fdfv.media_id = fdst.media_id
1776: and fdfv.attached_document_id = to_number(l_attached_document_id)
1777: and fdfv.function_name = l_function_name
1778: and fdfv.function_type = 'F';
2058: -- Query the text from the database.
2059: if (x_datatype_id = 1 ) then
2060: select short_text
2061: into document_short_text
2062: from fnd_documents_short_text
2063: where media_id = x_media_id;
2064:
2065: -- Display the blank text information for Update.
2066: DocumentInformation (x_datatype_id => x_datatype_id,