DBA Data[Home] [Help]

APPS.EDR_XDOC_UTIL_PKG dependencies on EDR_PSIG_DOCUMENTS

Line 521: /* Set the Security Context to access EDR_PSIG_DOCUMENTS */

517: OPEN c_get_id;
518: FETCH c_get_id INTO l_attached_document_id;
519: CLOSE c_get_id;
520:
521: /* Set the Security Context to access EDR_PSIG_DOCUMENTS */
522: edr_ctx_pkg.set_secure_attr;
523:
524: select document_requester into l_user_name
525: from edr_psig_documents where document_id = p_eRecord_Id;

Line 525: from edr_psig_documents where document_id = p_eRecord_Id;

521: /* Set the Security Context to access EDR_PSIG_DOCUMENTS */
522: edr_ctx_pkg.set_secure_attr;
523:
524: select document_requester into l_user_name
525: from edr_psig_documents where document_id = p_eRecord_Id;
526:
527: /* Get the requestors user-id for Last Updated by field in Attachments */
528: select user_id into l_user_id
529: from fnd_user where user_name = l_user_name;