APPS.EDR_ERES_EVENT_PVT SQL Statements

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

Line: 21

     select b.guid
     from wf_events_vl a, wf_event_subscriptions b
     where	a.guid=b.EVENT_FILTER_GUID
	  and a.name = p_event_name
	  and UPPER(b.rule_function) = EDR_CONSTANTS_GRP.g_rule_function
        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: 33

     select b.guid
     from wf_events_vl a, wf_event_subscriptions b
     where	a.guid=b.EVENT_FILTER_GUID
	  and a.name = p_event_name
	  and UPPER(b.rule_function) = EDR_CONSTANTS_GRP.g_rule_function
	  --Bug No 4912782- Start
	  and b.source_type = 'LOCAL'
	  and b.system_guid = hextoraw(wf_core.translate('WF_SYSTEM_GUID')) ;

Line: 58

         select count(*)  INTO l_no_of_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'
	     --Bug No 4912782- Start
	     and b.source_type = 'LOCAL'
	     and b.system_guid = hextoraw(wf_core.translate('WF_SYSTEM_GUID')) ;

Line: 80

            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: 601

  SELECT application_id
		FROM FND_APPLICATION A, WF_EVENTS B
		WHERE A.APPLICATION_SHORT_NAME = B.OWNER_TAG
		AND B.NAME=P_EVENT_NAME;

Line: 607

  select count(*)
        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: 620

          select user_name
	      from FND_USER
	      where USER_ID = l_cur_user_id;

Line: 671

         SELECT EDR_INDEXED_XML_UTIL.GET_WF_PARAMS('EDR_AME_TRANSACTION_TYPE',b.guid) into l_ame_txn_type
		from wf_events_vl 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: 829

                                 P_LAST_UPDATE_DATE     IN         DATE,
                                 P_LAST_UPDATED_BY      IN         NUMBER,
                                 P_LAST_UPDATE_LOGIN    IN         NUMBER,
                                 X_ERES_PROCESS_ID      OUT NOCOPY NUMBER)
IS
BEGIN
  --get the next pk value from sequence
  select EDR_ERESMANAGER_T_S.nextval into X_ERES_PROCESS_ID from dual;

Line: 839

  insert into EDR_ERESMANAGER_T(ERES_PROCESS_ID,
                                RETURN_URL,
                                RETURN_FUNCTION,
                        				OVERALL_STATUS,
                                CREATED_BY,
                        				CREATION_DATE,
                                LAST_UPDATE_DATE,
                                LAST_UPDATED_BY,
                                LAST_UPDATE_LOGIN
                               )
                         values( X_ERES_PROCESS_ID,
                                 P_RETURN_URL,
                                 P_RETURN_FUNCTION,
                                 P_OVERALL_STATUS,
                                 P_CREATED_BY,
                                 P_CREATION_DATE,
                                 P_LAST_UPDATE_DATE,
                                 P_LAST_UPDATED_BY,
                                 P_LAST_UPDATE_LOGIN);

Line: 865

PROCEDURE DELETE_ERECORDS(P_ERES_PROCESS_ID  IN    NUMBER)
IS
  L_TEMP_DATA_LIFE      VARCHAR2(128);

Line: 879

    delete from EDR_ERESPARAMETERS_T params
           where params.PARENT_ID in (select ERECORD_SEQUENCE_ID
                                     from EDR_PROCESS_ERECORDS_T records
                                     where records.ERES_PROCESS_ID = P_ERES_PROCESS_ID
                                    ) and params.parent_type = 'ERECORD';

Line: 885

    delete from EDR_ERESPARAMETERS_T where parent_id = p_eres_process_id
           and parent_type = 'ERESMANAGER';

Line: 888

    delete from EDR_PROCESS_ERECORDS_T where ERES_PROCESS_ID = P_ERES_PROCESS_ID;

Line: 889

    delete from EDR_ERESMANAGER_T where ERES_PROCESS_ID = P_ERES_PROCESS_ID;

Line: 911

      delete from EDR_ERESPARAMETERS_T params
      where params.PARENT_ID in (select records.ERECORD_SEQUENCE_ID
                                 from EDR_PROCESS_ERECORDS_T records
                                 where records.CREATION_DATE <= L_TEMP_DATE
                                 ) and params.parent_type = 'ERECORD';

Line: 917

      delete from EDR_ERESPARAMETERS_T params
      where params.PARENT_ID in (select manager.ERES_PROCESS_ID
                                 from EDR_ERESMANAGER_T manager
                                 where manager.CREATION_DATE <= L_TEMP_DATE
                                 ) and params.parent_type = 'ERESMANAGER';

Line: 924

      delete from EDR_ERESMANAGER_T where CREATION_DATE <= L_TEMP_DATE;

Line: 929

      delete from EDR_PROCESS_ERECORDS_T where CREATION_DATE <= L_TEMP_DATE;

Line: 935

      delete from EDR_RAW_XML_T where CREATION_DATE <= L_TEMP_DATE;

Line: 949

END DELETE_ERECORDS;

Line: 1103

        SELECT EVENT_NAME, EVENT_KEY
        FROM EDR_PSIG_DOCUMENTS
        WHERE DOCUMENT_ID = p_erecord_id;