APPS.EDR_EVENT_RELATIONSHIP_PVT dependencies on EDR_CTX_PKG

Line 391: edr_ctx_pkg.set_secure_attr;

387: L_CHILD_EVENT_NAME := parent_child_record(i).child_event_name;
388:
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;

Line 395: edr_ctx_pkg.unset_secure_attr;

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,
398: p_init_msg_list => FND_API.G_FALSE,
399: p_commit => FND_API.G_TRUE,

Line 488: edr_ctx_pkg.set_secure_attr;

484: --The parent e-record ID has also been defined.
485: --Hence query evidence store to check if the parent e-record exists.
486:
487: --Set the secure context to enable direct query on evidence store.
488: edr_ctx_pkg.set_secure_attr;
489:
490: --Query the evidence store using the cursor for the specified parent
491: --e-record.
492: open l_psig_count_csr;

Line 495: edr_ctx_pkg.unset_secure_attr;

491: --e-record.
492: open l_psig_count_csr;
493: fetch l_psig_count_csr into l_count;
494: close l_psig_count_csr;
495: edr_ctx_pkg.unset_secure_attr;
496: --If count is zero then the specified parent e-record does not exist.
497: --Hence raise an exception.
498: if l_count = 0 then
499:

Line 588: edr_ctx_pkg.set_secure_attr;

584: --Convert the VARCHAR2 e-record id value into number format.
585: L_CHILD_ERECORD_ID:=to_number(P_CHILD_ERECORD_IDS(i),'999999999999.999999');
586:
587: --Set secure attribute
588: edr_ctx_pkg.set_secure_attr;
589: --Query the evidence using the cursor.
590: OPEN l_psig_details_csr(L_CHILD_ERECORD_ID);
591: FETCH L_PSIG_DETAILS_CSR into L_TEMP_EVENT_NAME;
592:

Line 616: edr_ctx_pkg.unset_secure_attr;

612: CLOSE L_PSIG_DETAILS_CSR;
613: end loop;
614:
615: --unset secure attribute
616: edr_ctx_pkg.unset_secure_attr;
617:
618: if l_counter1 > 0 and l_counter2 > 0 then
619: --Some of the specified child e-record IDs do not exist in evidence store
620: --and also there exists some e-record IDS whose event name is the same as