APPS.EDR_EVENT_RELATIONSHIP_PVT dependencies on EDR_PSIG_DOCUMENTS

Line 393: from edr_psig_documents

389: if length(l_child_event_name) = 0 then
390:
391: edr_ctx_pkg.set_secure_attr;
392: select event_name,event_key into l_child_event_name,l_child_event_key
393: from edr_psig_documents
394: where document_id = parent_child_record(i).child_erecord_id;
395: edr_ctx_pkg.unset_secure_attr;
396: edr_event_relationship_pub.CREATE_RELATIONSHIP
397: (p_api_version => 1.0,

Line 450: select count(*) from edr_psig_documents

446: l_count NUMBER := 0;
447:
448: --This cursor is defined to query the evidence store
449: cursor l_psig_count_csr is
450: select count(*) from edr_psig_documents
451: where event_name = p_parent_event_name
452: and event_key = p_parent_event_key
453: and document_id = p_parent_erecord_id;
454:

Line 553: select event_name from edr_psig_documents

549: --Define a cursor to query the evidence store
550: --based on the e-record id. This cursor would return
551: --the event_name for the specified e-record id.
552: cursor l_psig_details_csr(p_erecord_id NUMBER) is
553: select event_name from edr_psig_documents
554: where document_id = p_erecord_id;
555:
556:
557: L_COUNT NUMBER;