APPS.ENGECOBO dependencies on FND_ATTACHED_DOCUMENTS

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 275: l_local_att_status fnd_attached_documents.status%TYPE; -- Bug 3599366

271: l_local_change_id NUMBER;
272: l_local_attachment_id NUMBER := -1;
273: l_pk3_value VARCHAR2(100);
274: l_change_document_id NUMBER;
275: l_local_att_status fnd_attached_documents.status%TYPE; -- Bug 3599366
276: l_temp_document_id NUMBER;
277:
278: CURSOR c_attachment_changes (cp_revised_item_sequence_id NUMBER)
279: IS

Line 286: FROM eng_attachment_changes eac, fnd_attached_documents fad

282: , eac.CHANGE_DOCUMENT_ID, eac.entity_name, eac.pk1_value, eac.pk2_value, eac.pk3_value
283: , decode(eac.action_type, 'ATTACH', eac.source_document_id,fad.document_id) document_id
284: , eac.FAMILY_ID, eac.REPOSITORY_ID, eac.PK4_VALUE, eac.PK5_VALUE, eac.NEW_FILE_NAME
285: , eac.DESCRIPTIOn, eac.NEW_DESCRIPTIOn, eac.NEW_CATEGORY_ID
286: FROM eng_attachment_changes eac, fnd_attached_documents fad
287: WHERE eac.change_id = p_change_id -- 4517503
288: AND eac.revised_item_sequence_id = cp_revised_item_sequence_id
289: AND eac.attachment_id = fad.attached_document_id(+)
290: AND (eac.entity_name = 'MTL_ITEM_REVISIONS'

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 782: FROM eng_attachment_changes eac, fnd_attached_documents fad

778: CURSOR c_attachment_changes IS
779: SELECT eac.action_type, eac.entity_name, eac.pk1_value, eac.pk2_value
780: , eac.pk3_value, eac.file_name, fad.status, eac.change_document_id
781: , decode(eac.action_type, 'ATTACH', eac.source_document_id,fad.document_id) document_id,eac.category_id
782: FROM eng_attachment_changes eac, fnd_attached_documents fad
783: WHERE eac.change_id = p_change_id
784: AND eac.revised_item_sequence_id = p_rev_item_sequence_id
785: AND eac.attachment_id = fad.attached_document_id(+)
786: AND (eac.entity_name = 'MTL_ITEM_REVISIONS'

Line 822: l_local_att_status fnd_attached_documents.status%TYPE; -- Bug 3599366

818: l_local_attachment_id NUMBER;
819: l_pk3_value VARCHAR2(100);
820: l_status_name fnd_lookups.meaning%TYPE;
821: l_check_item_changes NUMBER;
822: l_local_att_status fnd_attached_documents.status%TYPE; -- Bug 3599366
823: l_Mesg_token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
824: l_Token_Tbl Error_Handler.Token_Tbl_Type;
825: l_error_logged NUMBER;
826: l_cp_not_allowed NUMBER;