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.ENGECOBO dependencies on FND_DOCUMENTS

Line 98: l_master_item_media_id FND_DOCUMENTS.MEDIA_ID%TYPE;

94: , p_master_org_document_id IN NUMBER
95: , p_child_org_id IN NUMBER
96: )
97: RETURN NUMBER IS
98: l_master_item_media_id FND_DOCUMENTS.MEDIA_ID%TYPE;
99: l_master_item_node_id FND_DOCUMENTS.DM_NODE%TYPE;
100: l_master_item_folder_path FND_DOCUMENTS.DM_FOLDER_PATH%TYPE;
101: l_master_item_file_name FND_DOCUMENTS.FILE_NAME%TYPE;
102: l_master_item_dm_doc_id FND_DOCUMENTS.DM_DOCUMENT_ID%TYPE;

Line 99: l_master_item_node_id FND_DOCUMENTS.DM_NODE%TYPE;

95: , p_child_org_id IN NUMBER
96: )
97: RETURN NUMBER IS
98: l_master_item_media_id FND_DOCUMENTS.MEDIA_ID%TYPE;
99: l_master_item_node_id FND_DOCUMENTS.DM_NODE%TYPE;
100: l_master_item_folder_path FND_DOCUMENTS.DM_FOLDER_PATH%TYPE;
101: l_master_item_file_name FND_DOCUMENTS.FILE_NAME%TYPE;
102: l_master_item_dm_doc_id FND_DOCUMENTS.DM_DOCUMENT_ID%TYPE;
103:

Line 100: l_master_item_folder_path FND_DOCUMENTS.DM_FOLDER_PATH%TYPE;

96: )
97: RETURN NUMBER IS
98: l_master_item_media_id FND_DOCUMENTS.MEDIA_ID%TYPE;
99: l_master_item_node_id FND_DOCUMENTS.DM_NODE%TYPE;
100: l_master_item_folder_path FND_DOCUMENTS.DM_FOLDER_PATH%TYPE;
101: l_master_item_file_name FND_DOCUMENTS.FILE_NAME%TYPE;
102: l_master_item_dm_doc_id FND_DOCUMENTS.DM_DOCUMENT_ID%TYPE;
103:
104: l_item_attachment_protocol DOM_REPOSITORIES.PROTOCOL%TYPE;

Line 101: l_master_item_file_name FND_DOCUMENTS.FILE_NAME%TYPE;

97: RETURN NUMBER IS
98: l_master_item_media_id FND_DOCUMENTS.MEDIA_ID%TYPE;
99: l_master_item_node_id FND_DOCUMENTS.DM_NODE%TYPE;
100: l_master_item_folder_path FND_DOCUMENTS.DM_FOLDER_PATH%TYPE;
101: l_master_item_file_name FND_DOCUMENTS.FILE_NAME%TYPE;
102: l_master_item_dm_doc_id FND_DOCUMENTS.DM_DOCUMENT_ID%TYPE;
103:
104: l_item_attachment_protocol DOM_REPOSITORIES.PROTOCOL%TYPE;
105: l_child_item_media_id FND_DOCUMENTS.MEDIA_ID%TYPE;

Line 102: l_master_item_dm_doc_id FND_DOCUMENTS.DM_DOCUMENT_ID%TYPE;

98: l_master_item_media_id FND_DOCUMENTS.MEDIA_ID%TYPE;
99: l_master_item_node_id FND_DOCUMENTS.DM_NODE%TYPE;
100: l_master_item_folder_path FND_DOCUMENTS.DM_FOLDER_PATH%TYPE;
101: l_master_item_file_name FND_DOCUMENTS.FILE_NAME%TYPE;
102: l_master_item_dm_doc_id FND_DOCUMENTS.DM_DOCUMENT_ID%TYPE;
103:
104: l_item_attachment_protocol DOM_REPOSITORIES.PROTOCOL%TYPE;
105: l_child_item_media_id FND_DOCUMENTS.MEDIA_ID%TYPE;
106: l_child_org_document_id FND_DOCUMENTS.DOCUMENT_ID%TYPE;

Line 105: l_child_item_media_id FND_DOCUMENTS.MEDIA_ID%TYPE;

101: l_master_item_file_name FND_DOCUMENTS.FILE_NAME%TYPE;
102: l_master_item_dm_doc_id FND_DOCUMENTS.DM_DOCUMENT_ID%TYPE;
103:
104: l_item_attachment_protocol DOM_REPOSITORIES.PROTOCOL%TYPE;
105: l_child_item_media_id FND_DOCUMENTS.MEDIA_ID%TYPE;
106: l_child_org_document_id FND_DOCUMENTS.DOCUMENT_ID%TYPE;
107: l_child_item_folder_path FND_DOCUMENTS.DM_FOLDER_PATH%TYPE;
108: l_child_item_file_name FND_DOCUMENTS.FILE_NAME%TYPE;
109: l_master_folder_and_file VARCHAR2(3500); -- DM_FOLDER_PATH || '/' || FILE_NAME

Line 106: l_child_org_document_id FND_DOCUMENTS.DOCUMENT_ID%TYPE;

102: l_master_item_dm_doc_id FND_DOCUMENTS.DM_DOCUMENT_ID%TYPE;
103:
104: l_item_attachment_protocol DOM_REPOSITORIES.PROTOCOL%TYPE;
105: l_child_item_media_id FND_DOCUMENTS.MEDIA_ID%TYPE;
106: l_child_org_document_id FND_DOCUMENTS.DOCUMENT_ID%TYPE;
107: l_child_item_folder_path FND_DOCUMENTS.DM_FOLDER_PATH%TYPE;
108: l_child_item_file_name FND_DOCUMENTS.FILE_NAME%TYPE;
109: l_master_folder_and_file VARCHAR2(3500); -- DM_FOLDER_PATH || '/' || FILE_NAME
110: BEGIN

Line 107: l_child_item_folder_path FND_DOCUMENTS.DM_FOLDER_PATH%TYPE;

103:
104: l_item_attachment_protocol DOM_REPOSITORIES.PROTOCOL%TYPE;
105: l_child_item_media_id FND_DOCUMENTS.MEDIA_ID%TYPE;
106: l_child_org_document_id FND_DOCUMENTS.DOCUMENT_ID%TYPE;
107: l_child_item_folder_path FND_DOCUMENTS.DM_FOLDER_PATH%TYPE;
108: l_child_item_file_name FND_DOCUMENTS.FILE_NAME%TYPE;
109: l_master_folder_and_file VARCHAR2(3500); -- DM_FOLDER_PATH || '/' || FILE_NAME
110: BEGIN
111: -- Get the master item attachments information

Line 108: l_child_item_file_name FND_DOCUMENTS.FILE_NAME%TYPE;

104: l_item_attachment_protocol DOM_REPOSITORIES.PROTOCOL%TYPE;
105: l_child_item_media_id FND_DOCUMENTS.MEDIA_ID%TYPE;
106: l_child_org_document_id FND_DOCUMENTS.DOCUMENT_ID%TYPE;
107: l_child_item_folder_path FND_DOCUMENTS.DM_FOLDER_PATH%TYPE;
108: l_child_item_file_name FND_DOCUMENTS.FILE_NAME%TYPE;
109: l_master_folder_and_file VARCHAR2(3500); -- DM_FOLDER_PATH || '/' || FILE_NAME
110: BEGIN
111: -- Get the master item attachments information
112: SELECT dm_node, media_id, dm_folder_path, file_name, dm_document_id

Line 114: FROM fnd_documents

110: BEGIN
111: -- Get the master item attachments information
112: SELECT dm_node, media_id, dm_folder_path, file_name, dm_document_id
113: INTO l_master_item_node_id, l_master_item_media_id, l_master_item_folder_path, l_master_item_file_name, l_master_item_dm_doc_id
114: FROM fnd_documents
115: WHERE document_id = p_master_org_document_id;
116: l_master_folder_and_file := l_master_item_folder_path || '/' || l_master_item_file_name;
117:
118: -- Get the Protocol

Line 127: FROM fnd_documents a, fnd_attached_documents b

123: IF l_item_attachment_protocol = 'WEBSERVICES' THEN
124: BEGIN
125: SELECT b.document_id, nvl(a.media_id , a.dm_document_id)
126: INTO l_child_org_document_id, l_child_item_media_id
127: FROM fnd_documents a, fnd_attached_documents b
128: WHERE b.document_id = a.document_id AND
129: b.pk2_value = p_item_id AND
130: b.pk1_value = p_child_org_id AND
131: b.pk3_value = p_item_revision_id AND

Line 148: FROM fnd_documents a, fnd_attached_documents b

144: IF l_item_attachment_protocol = 'WEBDAV' THEN
145: BEGIN
146: SELECT b.document_id, a.dm_folder_path, a.file_name
147: INTO l_child_org_document_id, l_child_item_folder_path, l_child_item_file_name
148: FROM fnd_documents a, fnd_attached_documents b
149: WHERE b.document_id = a.document_id AND
150: b.pk2_value = p_item_id AND
151: b.pk1_value = p_child_org_id AND
152: b.pk3_value = p_item_revision_id AND

Line 217: FROM fnd_documents_vl fdv, fnd_attached_documents fad

213:
214: CURSOR c_local_attachment
215: IS
216: SELECT fad.attached_document_id, fad.status
217: FROM fnd_documents_vl fdv, fnd_attached_documents fad
218: WHERE fdv.document_id = fad.document_id
219: AND fad.entity_name = p_local_entity_name
220: AND fad.pk1_value= p_local_pk1_value
221: AND fad.pk2_value = p_local_pk2_value

Line 228: FROM fnd_documents_vl

224: OR
225: (fdv.document_id <> p_global_document_id
226: AND ( Nvl(fdv.dm_folder_path, '*NULL*'), fdv.dm_node, fdv.file_name)=
227: (SELECT Nvl(dm_folder_path, '*NULL*'), dm_node, file_name
228: FROM fnd_documents_vl
229: WHERE document_id = p_global_document_id)
230: )
231: OR
232: (fdv.document_id <> p_global_document_id

Line 236: FROM fnd_documents_vl

232: (fdv.document_id <> p_global_document_id
233: AND fdv.dm_node = 0
234: AND (fdv.file_name, fdv.datatype_id) =
235: (SELECT file_name, datatype_id
236: FROM fnd_documents_vl
237: WHERE document_id = p_global_document_id)
238: )
239: );
240:

Line 310: FROM fnd_attached_documents fad, fnd_documents_vl fdv

306: IS
307: SELECT fad.category_id, fad.status, fad.document_id
308: , fad.attached_document_id, fdv.file_name, fad.last_updated_by
309: , fdv.dm_type, fdv.datatype_id, fdv.document_id source_document_id
310: FROM fnd_attached_documents fad, fnd_documents_vl fdv
311: WHERE fad.attached_document_id = cp_attached_document_id
312: AND fad.document_id = fdv.document_id
313: AND cp_attach_action_type <> 'ATTACH'
314: UNION ALL

Line 318: FROM eng_attachment_changes eac, fnd_documents_vl fdv

314: UNION ALL
315: SELECT eac.category_id, eac.previous_status, eac.source_document_id
316: , eac.attachment_id, eac.file_name, eac.last_updated_by
317: , eac.dm_type, eac.datatype_id, eac.source_document_id
318: FROM eng_attachment_changes eac, fnd_documents_vl fdv
319: WHERE eac.change_document_id = cp_change_document_id
320: AND eac.source_document_id = fdv.document_id
321: AND cp_attach_action_type = 'ATTACH';
322: