APPS.POR_UTIL_PKG dependencies on FND_ATTACHED_DOCUMENTS

Line 87: fnd_attached_documents2_pkg.delete_attachments('REQ_HEADERS',

83: END IF;
84: */
85:
86: -- delete the header attachments
87: fnd_attached_documents2_pkg.delete_attachments('REQ_HEADERS',
88: p_header_id,
89: null,
90: null,
91: null,

Line 99: fnd_attached_documents2_pkg.delete_attachments('REQ_LINES',

95: l_progress := '040';
96:
97: -- delete the line attachments
98: FOR idx IN 1..l_line_ids.COUNT LOOP
99: fnd_attached_documents2_pkg.delete_attachments('REQ_LINES',
100: l_line_ids(idx),
101: null,
102: null,
103: null,

Line 1279: UPDATE fnd_attached_documents

1275: l_progress := '080';
1276:
1277: -- flip line attachments
1278: FORALL idx IN 1..p_tempLineIds.COUNT
1279: UPDATE fnd_attached_documents
1280: SET pk1_value = to_char(p_origLineIds(idx))
1281: WHERE pk1_value = to_char(p_tempLineIds(idx))
1282: AND entity_name = 'REQ_LINES';
1283:

Line 1287: UPDATE fnd_attached_documents

1283:
1284: l_progress := '085';
1285:
1286: -- flip header attachments
1287: UPDATE fnd_attached_documents
1288: SET pk1_value = to_char(p_origHeaderId)
1289: WHERE pk1_value = to_char(p_tempHeaderId)
1290: AND entity_name = 'REQ_HEADERS';
1291:

Line 3581: TYPE fnd_doc_id_tb IS TABLE OF fnd_attached_documents.document_id%TYPE INDEX BY PLS_INTEGER;

3577: l_progress VARCHAR2(4) := '000';
3578: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
3579: l_api_name CONSTANT VARCHAR2(100) := 'update_attachment_to_standard';
3580: l_procedure_name CONSTANT VARCHAR2(30) := 'update_attachment_to_standard';
3581: TYPE fnd_doc_id_tb IS TABLE OF fnd_attached_documents.document_id%TYPE INDEX BY PLS_INTEGER;
3582: doc_id_v fnd_doc_id_tb;
3583: CURSOR l_fnd_document_id_csr IS
3584: SELECT document_id
3585: FROM fnd_attached_documents

Line 3585: FROM fnd_attached_documents

3581: TYPE fnd_doc_id_tb IS TABLE OF fnd_attached_documents.document_id%TYPE INDEX BY PLS_INTEGER;
3582: doc_id_v fnd_doc_id_tb;
3583: CURSOR l_fnd_document_id_csr IS
3584: SELECT document_id
3585: FROM fnd_attached_documents
3586: WHERE entity_name = 'REQ_HEADERS' and pk1_value = to_char(p_req_header_id)
3587: UNION
3588: SELECT document_id
3589: FROM fnd_attached_documents

Line 3589: FROM fnd_attached_documents

3585: FROM fnd_attached_documents
3586: WHERE entity_name = 'REQ_HEADERS' and pk1_value = to_char(p_req_header_id)
3587: UNION
3588: SELECT document_id
3589: FROM fnd_attached_documents
3590: WHERE entity_name = 'REQ_LINES' AND pk1_value IN (SELECT to_char(requisition_line_id)
3591: FROM po_requisition_lines_all prl, po_requisition_headers_all prh
3592: WHERE prl.requisition_header_id = prh.requisition_header_id AND prh.requisition_header_id=to_number(p_req_header_id));
3593:

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);