APPS.FND_ATTACHMENT_UTIL_PKG dependencies on FND_ATTACHED_DOCUMENTS

Line 39: fnd_attached_documents fad

35: INTO l_exists
36: FROM fnd_doc_category_usages fdcu,
37: fnd_documents fd,
38: fnd_attachment_functions af,
39: fnd_attached_documents fad
40: WHERE fad.entity_name = l_entity_name
41: AND fad.pk1_value = l_pkey1
42: AND fad.pk2_value = l_pkey2
43: AND fad.pk3_value = l_pkey3

Line 64: fnd_attached_documents fad,

60: SELECT 'Y'
61: INTO l_exists
62: FROM fnd_doc_category_usages fdcu,
63: fnd_documents fd,
64: fnd_attached_documents fad,
65: fnd_attachment_functions af
66: WHERE fad.entity_name = l_entity_name
67: AND fad.pk1_value = l_pkey1
68: AND fad.pk2_value = l_pkey2

Line 91: fnd_attached_documents fad,

87: SELECT 'Y'
88: INTO l_exists
89: FROM fnd_doc_category_usages fdcu,
90: fnd_documents fd,
91: fnd_attached_documents fad,
92: fnd_attachment_functions af
93: WHERE fad.entity_name = l_entity_name
94: AND fad.pk1_value = l_pkey1
95: AND (l_pkey2 IS NULL

Line 162: 'SELECT 1 FROM fnd_attached_documents fad,'||

158: END IF;
159:
160:
161: l_sql_stmt := 'SELECT ''Y'' FROM dual WHERE EXISTS ('||
162: 'SELECT 1 FROM fnd_attached_documents fad,'||
163: 'fnd_doc_category_usages fdcu,'||
164: 'fnd_attachment_functions af,'||
165: 'fnd_documents fd '||
166: 'WHERE fad.entity_name = :ename '||

Line 650: update fnd_attached_documents

646: end if;
647:
648: if (p_from_fk_id <> p_to_fk_id) then
649:
650: update fnd_attached_documents
651: set pk1_value = p_to_fk_id
652: where pk1_value = p_from_fk_id
653: and entity_name = pen;
654: -- For Bulk processing this condition has been removed. Updated ldt to include