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