DBA Data[Home] [Help]

APPS.FND_OID_UTIL dependencies on WF_EVENT_SUBSCRIPTIONS

Line 2265: select status into l_status from wf_event_subscriptions

2261: end if;
2262:
2263:
2264: if (p_action = 'ADD') then
2265: select status into l_status from wf_event_subscriptions
2266: where rule_function = 'fnd_oid_subscriptions.hz_identity_add';
2267: elsif (p_action = 'MODIFY') then
2268: select status into l_status from wf_event_subscriptions
2269: where rule_function = 'fnd_oid_subscriptions.hz_identity_modify';

Line 2268: select status into l_status from wf_event_subscriptions

2264: if (p_action = 'ADD') then
2265: select status into l_status from wf_event_subscriptions
2266: where rule_function = 'fnd_oid_subscriptions.hz_identity_add';
2267: elsif (p_action = 'MODIFY') then
2268: select status into l_status from wf_event_subscriptions
2269: where rule_function = 'fnd_oid_subscriptions.hz_identity_modify';
2270: elsif (p_action = 'DELETE') then
2271: select status into l_status from wf_event_subscriptions
2272: where rule_function = 'fnd_oid_subscriptions.hz_identity_delete';

Line 2271: select status into l_status from wf_event_subscriptions

2267: elsif (p_action = 'MODIFY') then
2268: select status into l_status from wf_event_subscriptions
2269: where rule_function = 'fnd_oid_subscriptions.hz_identity_modify';
2270: elsif (p_action = 'DELETE') then
2271: select status into l_status from wf_event_subscriptions
2272: where rule_function = 'fnd_oid_subscriptions.hz_identity_delete';
2273: else
2274: -- Invalid action return true by default
2275: l_status := 'ENABLED';