APPS.AME_GPI_BUS dependencies on WF_ROLES

Line 223: if p_parameter_name = 'wf_roles_name' then

219: ,p_argument_value => p_approval_group_id
220: );
221: -- Check if the group item has members of approver type other than 'PER'
222: -- and 'FND_USR'
223: if p_parameter_name = 'wf_roles_name' then
224: select count(*) into l_count
225: from wf_roles
226: where name=p_parameter
227: and orig_system not in ('PER','FND_USR')

Line 225: from wf_roles

221: -- Check if the group item has members of approver type other than 'PER'
222: -- and 'FND_USR'
223: if p_parameter_name = 'wf_roles_name' then
224: select count(*) into l_count
225: from wf_roles
226: where name=p_parameter
227: and orig_system not in ('PER','FND_USR')
228: and sysdate between nvl(start_date,sysdate) and
229: nvl(expiration_date,sysdate);

Line 369: -- in ('OAM_group_id','wf_roles_name') .

365: -- {Start Of Comments}
366: --
367: -- Description:
368: -- This procedure validates the parameter_name. Its value should be
369: -- in ('OAM_group_id','wf_roles_name') .
370: --
371: -- Pre-Requisites:
372: -- None
373: --

Line 399: -- Check if the parameter_name is in ('OAM_group_id','wf_roles_name')

395: hr_api.mandatory_arg_error(p_api_name => l_proc
396: ,p_argument => 'PARAMETER_NAME'
397: ,p_argument_value => p_parameter_name
398: );
399: -- Check if the parameter_name is in ('OAM_group_id','wf_roles_name')
400: if p_parameter_name not in ('OAM_group_id','wf_roles_name') then
401: fnd_message.set_name('PER','AME_400567_INV_APG_ITM_PAR_NAM');
402: fnd_message.raise_error;
403: end if;

Line 400: if p_parameter_name not in ('OAM_group_id','wf_roles_name') then

396: ,p_argument => 'PARAMETER_NAME'
397: ,p_argument_value => p_parameter_name
398: );
399: -- Check if the parameter_name is in ('OAM_group_id','wf_roles_name')
400: if p_parameter_name not in ('OAM_group_id','wf_roles_name') then
401: fnd_message.set_name('PER','AME_400567_INV_APG_ITM_PAR_NAM');
402: fnd_message.raise_error;
403: end if;
404: hr_utility.set_location(' Leaving:'||l_proc,30);

Line 468: from wf_roles

464: and p_effective_date between t.start_date and (t.end_date - ame_util.oneSecond);
465:
466: Cursor C_Sel2 Is
467: select count(name)
468: from wf_roles
469: where name = p_parameter
470: and status = 'ACTIVE'
471: and (expiration_date is null or
472: sysdate < expiration_date)

Line 483: -- If parameter_name = 'wf_roles_name' then validate the wf_roles_name.

479: ,p_argument_value => p_parameter
480: );
481: -- Check if the parameter corresponds to a valid group in ame_approval_groups
482: -- whenever parameter_name = 'OAM_group_id'
483: -- If parameter_name = 'wf_roles_name' then validate the wf_roles_name.
484: --
485: if p_parameter_name = ame_util.approverOamGroupId then
486: open C_Sel1;
487: fetch C_Sel1 into l_count;

Line 523: elsif p_parameter_name = 'wf_roles_name' then

519: fnd_message.set_name('PER','AME_400569_NEST_APG_NOT_ALLOW');
520: fnd_message.raise_error;
521: end if;
522:
523: elsif p_parameter_name = 'wf_roles_name' then
524: open C_Sel2;
525: fetch C_Sel2 into l_count;
526: close C_Sel2;
527: if (l_count = 0) then