DBA Data[Home] [Help]

APPS.FND_OID_UTIL dependencies on WF_EVENT_SUBSCRIPTIONS

Line 2429: select status into l_status from wf_event_subscriptions

2425: end if;
2426:
2427:
2428: if (p_action = 'ADD') then
2429: select status into l_status from wf_event_subscriptions
2430: where rule_function = 'fnd_oid_subscriptions.hz_identity_add';
2431: elsif (p_action = 'MODIFY') then
2432: select status into l_status from wf_event_subscriptions
2433: where rule_function = 'fnd_oid_subscriptions.hz_identity_modify';

Line 2432: select status into l_status from wf_event_subscriptions

2428: if (p_action = 'ADD') then
2429: select status into l_status from wf_event_subscriptions
2430: where rule_function = 'fnd_oid_subscriptions.hz_identity_add';
2431: elsif (p_action = 'MODIFY') then
2432: select status into l_status from wf_event_subscriptions
2433: where rule_function = 'fnd_oid_subscriptions.hz_identity_modify';
2434: elsif (p_action = 'DELETE') then
2435: select status into l_status from wf_event_subscriptions
2436: where rule_function = 'fnd_oid_subscriptions.hz_identity_delete';

Line 2435: select status into l_status from wf_event_subscriptions

2431: elsif (p_action = 'MODIFY') then
2432: select status into l_status from wf_event_subscriptions
2433: where rule_function = 'fnd_oid_subscriptions.hz_identity_modify';
2434: elsif (p_action = 'DELETE') then
2435: select status into l_status from wf_event_subscriptions
2436: where rule_function = 'fnd_oid_subscriptions.hz_identity_delete';
2437: else
2438: -- Invalid action return true by default
2439: l_status := 'ENABLED';