DBA Data[Home] [Help]

APPS.AME_ACT_BUS dependencies on WF_ROLES

Line 259: from wf_roles

255: p_action_type_id in number,
256: p_action_id in number default null) is
257: cursor c_sel1(p_name in varchar2) is
258: select null
259: from wf_roles
260: where
261: name = p_name
262: and status = 'ACTIVE'
263: and (expiration_date is null or

Line 310: -- The name is not valid (doesn't exist in wf_roles.name).

306: fetch c_sel1 into l_exists;
307: if c_sel1%notfound then
308: close c_sel1;
309: -- AT MESSAGE
310: -- The name is not valid (doesn't exist in wf_roles.name).
311: fnd_message.set_name('PER','AME_400605_INV_LM_ACTION_PARAM');
312: fnd_message.raise_error;
313: end if;
314: close c_sel1;