APPS.EDR_ISIGN_CHECKLIST_PVT SQL Statements

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

Line: 51

     select b.guid,A.status,b.status
     from
       wf_events a, wf_event_subscriptions b
     where a.GUID = b.EVENT_FILTER_GUID
       and a.name = p_event_name
       and b.RULE_FUNCTION='EDR_PSIG_RULE.PSIG_RULE'
       and b.STATUS = 'ENABLED'
	 --Bug No 4912782- Start
	 and b.source_type = 'LOCAL'
	 and b.system_guid = hextoraw(wf_core.translate('WF_SYSTEM_GUID')) ;

Line: 76

        select count(*)  INTO l_no_enabled_eres_sub
        from
          wf_events a, wf_event_subscriptions b
        where a.GUID = b.EVENT_FILTER_GUID
          and a.name = p_event_name
          and b.RULE_FUNCTION='EDR_PSIG_RULE.PSIG_RULE'
          and b.STATUS = 'ENABLED'
	    --Bug No 4912782- Start
  	    and b.source_type = 'LOCAL'
	    and b.system_guid = hextoraw(wf_core.translate('WF_SYSTEM_GUID')) ;

Line: 113

                   /* Select APPLICATION_ID of the Event. This is required by AME. Assumption made here
                      is OWNER_TAG will always be set to application Short Name*/

              	 SELECT application_id,APPLICATION_SHORT_NAME into l_application_id,l_application_code
             	 FROM FND_APPLICATION
                   WHERE APPLICATION_SHORT_NAME in (SELECT OWNER_TAG from WF_EVENTS
                                                  WHERE NAME=evt.getEventName( ));

Line: 154

                	  select application_name into l_application_name
                	  from ame_Calling_Apps
                	  where FND_APPLICATION_ID=l_application_id
                	  and TRANSACTION_TYPE_ID=NVL(l_ame_transaction_type,evt.getEventName( ))
                          --Bug 4652277: Start
                          --and end_Date is null;

Line: 254

Cursor c1 is select count(*) from fnd_attached_documents
where ENTITY_NAME='EDR_FILES_B' and
      pk1_value=p_file_id and
      document_id in (select document_id from fnd_documents_vl where category_id in
                              (select category_id
				              from fnd_document_categories_vl
				              where name = 'EDR_ISIGN_ADDL_FILES'));

Line: 326

                /* select Catgory id of checklist   */
				select category_id into l_category_id
				from fnd_document_categories_vl
				where name = 'EDR_ISIGN_ADDL_FILES';

Line: 349

         X_last_update_login 		=> fnd_global.login_id,
         X_program_application_id 	=> null,
         X_program_id 			=> null,
         X_request_id 			=> null,
         X_automatically_added_flag 	=> null,
         X_from_category_id            	=> l_category_id,
         X_to_category_id              	=> l_category_id);

Line: 366

PROCEDURE DELETE_CHECKLIST  (
	p_file_id		       	IN 	NUMBER,
	x_return_Status               OUT   NOCOPY VARCHAR2) IS
      l_return_status varchar2(100);

Line: 371

Cursor c1 is select ATTACHED_DOCUMENT_ID from fnd_attached_documents
where ENTITY_NAME='EDR_FILES_B' and
      pk1_value=p_file_id and
      document_id in (select document_id from fnd_documents_vl where category_id in
                              (select category_id
				              from fnd_document_categories_vl
				              where name = 'EDR_ISIGN_ADDL_FILES'));

Line: 384

        fnd_attached_documents3_pkg.DELETE_ROW(
                   X_ATTACHED_DOCUMENT_ID=> l_attach_document_id ,
                   X_DATATYPE_ID         => 6,
                   DELETE_DOCUMENT_FLAG  => 'Y');

Line: 395

END DELETE_CHECKLIST;