APPS.CSM_HA_EVENT_PKG dependencies on WF_EVENTS

Line 621: UPDATE wf_events SET STATUS='DISABLED' WHERE lower(name)=lower(rec.WF_EVENT_NAME);

617: WHERE AUTO_DISABLE_FLAG='Y' AND ENABLED_ON_RECORD='N')
618: LOOP
619: IF rec.WF_EVENT_NAME IS NOT NULL THEN
620: IF rec.WF_EVENT_SUBSCRIPTION_GUID IS NULL THEN
621: UPDATE wf_events SET STATUS='DISABLED' WHERE lower(name)=lower(rec.WF_EVENT_NAME);
622: ELSE
623: UPDATE wf_event_subscriptions SET STATUS='DISABLED'
624: WHERE GUID=rec.WF_EVENT_SUBSCRIPTION_GUID
625: AND EVENT_FILTER_GUID = (select guid from wf_events where lower(name)=lower(rec.WF_EVENT_NAME));

Line 625: AND EVENT_FILTER_GUID = (select guid from wf_events where lower(name)=lower(rec.WF_EVENT_NAME));

621: UPDATE wf_events SET STATUS='DISABLED' WHERE lower(name)=lower(rec.WF_EVENT_NAME);
622: ELSE
623: UPDATE wf_event_subscriptions SET STATUS='DISABLED'
624: WHERE GUID=rec.WF_EVENT_SUBSCRIPTION_GUID
625: AND EVENT_FILTER_GUID = (select guid from wf_events where lower(name)=lower(rec.WF_EVENT_NAME));
626: END IF;
627: END IF;
628:
629: IF rec.WF_ITEM_TYPE IS NOT NULL THEN