[Home] [Help]
114: cursor groupCursor is
115: select
116: approval_group_id
117: ,name
118: from ame_approval_groups
119: where
120: sysdate between start_date and (end_date - ame_util.oneSecond);
121: l_proc varchar2(72) := g_package||'get_allowed_nested_groups';
122: tempIndex number;
306: -- Cursor to find number of groups with approval_group_id = p_approval_Group_id and is_static='Y'
307: --
308: Cursor C_Sel1 Is
309: select count(t.approval_group_id)
310: from ame_approval_groups t
311: where t.approval_group_id = p_approval_group_id
312: and p_effective_date between t.start_date
313: and (t.end_date - ame_util.oneSecond);
314: Cursor C_Sel2 Is
312: and p_effective_date between t.start_date
313: and (t.end_date - ame_util.oneSecond);
314: Cursor C_Sel2 Is
315: select count(t.approval_group_id)
316: from ame_approval_groups t
317: where t.approval_group_id = p_approval_group_id
318: and t.is_static = 'Y'
319: and p_effective_date between t.start_date
320: and (t.end_date - ame_util.oneSecond);
452: -- Cursor to find number of groups with approval_group_id = p_parameter
453: --
454: Cursor C_Sel1 Is
455: select count(t.approval_group_id)
456: from ame_approval_groups t
457: where to_char(t.approval_group_id) = p_parameter
458: and p_effective_date between t.start_date and (t.end_date - ame_util.oneSecond);
459:
460: Cursor C_Sel2 Is
471: hr_api.mandatory_arg_error(p_api_name => l_proc
472: ,p_argument => 'PARAMETER'
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