1097: X_EVENT_NAME OUT NOCOPY VARCHAR2,
1098: X_EVENT_KEY OUT NOCOPY VARCHAR2)
1099: IS
1100:
1101: --Define a cursor on edr_psig_documents.
1102: cursor l_event_csr is
1103: SELECT EVENT_NAME, EVENT_KEY
1104: FROM EDR_PSIG_DOCUMENTS
1105: WHERE DOCUMENT_ID = p_erecord_id;
1100:
1101: --Define a cursor on edr_psig_documents.
1102: cursor l_event_csr is
1103: SELECT EVENT_NAME, EVENT_KEY
1104: FROM EDR_PSIG_DOCUMENTS
1105: WHERE DOCUMENT_ID = p_erecord_id;
1106: BEGIN
1107:
1108: --Set the secure context.