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';
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';
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';