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 1238: UPDATE fnd_attached_documents

1234: l_progress := '080';
1235:
1236: -- flip line attachments
1237: FORALL idx IN 1..p_tempLineIds.COUNT
1238: UPDATE fnd_attached_documents
1239: SET pk1_value = to_char(p_origLineIds(idx))
1240: WHERE pk1_value = to_char(p_tempLineIds(idx))
1241: AND entity_name = 'REQ_LINES';
1242:

Line 1246: UPDATE fnd_attached_documents

1242:
1243: l_progress := '085';
1244:
1245: -- flip header attachments
1246: UPDATE fnd_attached_documents
1247: SET pk1_value = to_char(p_origHeaderId)
1248: WHERE pk1_value = to_char(p_tempHeaderId)
1249: AND entity_name = 'REQ_HEADERS';
1250:

Line 3216: select document_id from fnd_attached_documents where entity_name = 'REQ_HEADERS'

3212: BEGIN
3213: l_progress := '010';
3214: -- update the usage_type flag in fnd_documents;
3215: update fnd_documents set usage_type = 'S' where document_id in(
3216: select document_id from fnd_attached_documents where entity_name = 'REQ_HEADERS'
3217: and pk1_value = p_req_header_id
3218: union
3219: select document_id from fnd_attached_documents where entity_name = 'REQ_LINES'
3220: and pk1_value in

Line 3219: select document_id from fnd_attached_documents where entity_name = 'REQ_LINES'

3215: update fnd_documents set usage_type = 'S' where document_id in(
3216: select document_id from fnd_attached_documents where entity_name = 'REQ_HEADERS'
3217: and pk1_value = p_req_header_id
3218: union
3219: select document_id from fnd_attached_documents where entity_name = 'REQ_LINES'
3220: and pk1_value in
3221: (select requisition_line_id from po_requisition_lines_all prl, po_requisition_headers_all prh where
3222: prl.requisition_header_id = prh.requisition_header_id and prh.requisition_header_id=p_req_header_id));
3223: