APPS.FND_ATTACHMENT_UTIL_PKG dependencies on FND_DOCUMENTS

Line 37: fnd_documents fd,

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
41: AND fad.pk1_value = l_pkey1

Line 63: fnd_documents fd,

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
67: AND fad.pk1_value = l_pkey1

Line 90: fnd_documents fd,

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
94: AND fad.pk1_value = l_pkey1

Line 165: 'fnd_documents fd '||

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 '||
168: 'AND fd.category_id = fdcu.category_id '||
169: 'AND fdcu.attachment_function_id = af.attachment_function_id '||

Line 585: -- Get file name from fnd_documents_tl

581: exit;
582: end if;
583: END LOOP;
584:
585: -- Get file name from fnd_documents_tl
586: -- BUG#1560000 Added language = l_language to select statement
587: select document_id,file_name
588: into l_document_id,l_file_name_tl
589: from fnd_documents

Line 589: from fnd_documents

585: -- Get file name from fnd_documents_tl
586: -- BUG#1560000 Added language = l_language to select statement
587: select document_id,file_name
588: into l_document_id,l_file_name_tl
589: from fnd_documents
590: where file_name like '%'||l_file_name ||'%';
591:
592: -- Extract content type from file name.
593: l_content_type := substr (l_file_name_tl,instr(l_file_name_tl, ':') + 1 );

Line 596: update fnd_documents

592: -- Extract content type from file name.
593: l_content_type := substr (l_file_name_tl,instr(l_file_name_tl, ':') + 1 );
594:
595: -- Update fnd_document_tl
596: update fnd_documents
597: set file_name = l_file_name,
598: media_id = update_file_metadata.X_file_id
599: where document_id = l_document_id;
600: