eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FND_WEBATTCH dependencies on FND_DOCUMENTS

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 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 968: -- fnd_documents_tl table using the above procedure we get the media_id

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(
972: media_id,

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 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 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 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 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 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,

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,