APPS.EDR_FWK_VERIFY SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 20

 Cursor c1 is select count(*) from fnd_attached_documents
 where ENTITY_NAME='EDR_FWK_TEST_B' and
      pk1_value=l_event_key;

Line: 31

   Select fwk_test_no,last_updated_by into l_fwk_test_no,l_requester from edr_fwk_test_vl
    where fwk_test_id = to_number(l_event_key,'999999999999.999999');

Line: 34

   select user_name into l_requester from fnd_user
         where user_id=l_requester;

Line: 96

PROCEDURE UPDATE_EVIDENCE
	(p_itemtype   IN VARCHAR2,
      	 p_itemkey    IN VARCHAR2,
      	 p_actid      IN NUMBER,
         p_funcmode   IN VARCHAR2,
         p_resultout  OUT NOCOPY VARCHAR2
	 ) IS

l_Event_name varchar2(240);

Line: 192

      WF_CORE.CONTEXT ('EDR_FWK_VERIFY','UPDATE_EVIDENCE',p_itemtype,p_itemkey,SQLERRM);

Line: 195

END UPDATE_EVIDENCE;

Line: 318

      WF_CORE.CONTEXT ('EDR_FWK_VERIFY','UPDATE_EVIDENCE',p_itemtype,p_itemkey,SQLERRM);