DBA Data[Home] [Help]

APPS.POR_UTIL_PKG dependencies on FND_DOCUMENTS

Line 3214: -- update the usage_type flag in fnd_documents;

3210: l_api_name CONSTANT VARCHAR2(100) := 'update_attachment_to_standard';
3211:
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

Line 3215: update fnd_documents set usage_type = 'S' where document_id in(

3211:
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'