APPS.POR_UTIL_PKG dependencies on FND_DOCUMENTS

Line 3606: UPDATE fnd_documents SET usage_type = 'S' WHERE document_id=doc_id_v(indx);

3602: LOOP
3603: FETCH l_fnd_document_id_csr BULK COLLECT INTO doc_id_v LIMIT 2500;
3604: EXIT WHEN doc_id_v.Count = 0;
3605: FORALL indx IN doc_id_v.FIRST .. doc_id_v.LAST
3606: UPDATE fnd_documents SET usage_type = 'S' WHERE document_id=doc_id_v(indx);
3607: END LOOP;
3608: l_progress := '020';
3609: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3610: l_log_msg := 'End procedure -> '||l_procedure_name||' l_progress -> '||l_progress ;

Line 5869: from fnd_lobs fl, fnd_documents fd, fnd_attached_documents fad

5865: 'Progress: ' || l_progress || ' Start');
5866: END IF;
5867:
5868: select count(1) into l_pdf_exists
5869: from fnd_lobs fl, fnd_documents fd, fnd_attached_documents fad
5870: where fad.document_id = fd.document_id and fd.media_id = fl.file_id
5871: and fad.entity_name = 'REQ_HEADS' and fad.pk1_value = p_document_id;
5872:
5873: l_progress := '020';

Line 6104: FROM fnd_lobs fl, fnd_documents fd, fnd_attached_documents fad

6100: itemkey => l_itemkey,
6101: aname => 'DOCUMENT_ID');
6102:
6103: SELECT fl.file_data, fl.file_name into l_document, l_filename
6104: FROM fnd_lobs fl, fnd_documents fd, fnd_attached_documents fad
6105: WHERE fad.document_id = fd.document_id AND fd.media_id = fl.file_id
6106: AND fad.entity_name = 'REQ_HEADS' AND fad.pk1_value = l_document_id;
6107:
6108: l_document_length := dbms_lob.GetLength(l_document);