APPS.AME_GPI_BUS dependencies on WF_ROLES

Line 217: if p_parameter_name = 'wf_roles_name' then

213: ,p_argument_value => p_approval_group_id
214: );
215: -- Check if the group item has members of approver type other than 'PER'
216: -- and 'FND_USR'
217: if p_parameter_name = 'wf_roles_name' then
218: select count(*) into l_count
219: from wf_roles
220: where name=p_parameter
221: and orig_system not in ('PER','FND_USR')

Line 219: from wf_roles

215: -- Check if the group item has members of approver type other than 'PER'
216: -- and 'FND_USR'
217: if p_parameter_name = 'wf_roles_name' then
218: select count(*) into l_count
219: from wf_roles
220: where name=p_parameter
221: and orig_system not in ('PER','FND_USR')
222: and sysdate between nvl(start_date,sysdate) and
223: nvl(expiration_date,sysdate);

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

359: -- {Start Of Comments}
360: --
361: -- Description:
362: -- This procedure validates the parameter_name. Its value should be
363: -- in ('OAM_group_id','wf_roles_name') .
364: --
365: -- Pre-Requisites:
366: -- None
367: --

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

389: hr_api.mandatory_arg_error(p_api_name => l_proc
390: ,p_argument => 'PARAMETER_NAME'
391: ,p_argument_value => p_parameter_name
392: );
393: -- Check if the parameter_name is in ('OAM_group_id','wf_roles_name')
394: if p_parameter_name not in ('OAM_group_id','wf_roles_name') then
395: fnd_message.set_name('PER','AME_400567_INV_APG_ITM_PAR_NAM');
396: fnd_message.raise_error;
397: end if;

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

390: ,p_argument => 'PARAMETER_NAME'
391: ,p_argument_value => p_parameter_name
392: );
393: -- Check if the parameter_name is in ('OAM_group_id','wf_roles_name')
394: if p_parameter_name not in ('OAM_group_id','wf_roles_name') then
395: fnd_message.set_name('PER','AME_400567_INV_APG_ITM_PAR_NAM');
396: fnd_message.raise_error;
397: end if;
398: hr_utility.set_location(' Leaving:'||l_proc,30);

Line 462: from wf_roles

458: and p_effective_date between t.start_date and (t.end_date - ame_util.oneSecond);
459:
460: Cursor C_Sel2 Is
461: select count(name)
462: from wf_roles
463: where name = p_parameter
464: and status = 'ACTIVE'
465: and (expiration_date is null or
466: sysdate < expiration_date)

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

473: ,p_argument_value => p_parameter
474: );
475: -- Check if the parameter corresponds to a valid group in ame_approval_groups
476: -- whenever parameter_name = 'OAM_group_id'
477: -- If parameter_name = 'wf_roles_name' then validate the wf_roles_name.
478: --
479: if p_parameter_name = ame_util.approverOamGroupId then
480: open C_Sel1;
481: fetch C_Sel1 into l_count;

Line 517: elsif p_parameter_name = 'wf_roles_name' then

513: fnd_message.set_name('PER','AME_400569_NEST_APG_NOT_ALLOW');
514: fnd_message.raise_error;
515: end if;
516:
517: elsif p_parameter_name = 'wf_roles_name' then
518: open C_Sel2;
519: fetch C_Sel2 into l_count;
520: close C_Sel2;
521: if (l_count = 0) then