DBA Data[Home] [Help]

APPS.FND_ATTACHMENT_UTIL_PKG dependencies on FND_DOC_CATEGORY_USAGES

Line 36: FROM fnd_doc_category_usages fdcu,

32: IF (l_pkey2 is not null) and (l_pkey3 is not null) then
33:
34: SELECT 'Y'
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

Line 62: FROM fnd_doc_category_usages fdcu,

58: ELSE IF (l_pkey2 is not null) then
59:
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

Line 89: FROM fnd_doc_category_usages fdcu,

85: ELSE
86:
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

Line 163: 'fnd_doc_category_usages fdcu,'||

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 '||
167: 'AND fad.document_id = fd.document_id '||