40: --
41: l_proc varchar2(72) := g_package || 'CHK_APPROVER_TYPE';
42: l_count number;
43: l_config_value ame_config_vars.variable_value%type;
44: l_group_name ame_approval_groups.name%type;
45: --
46: -- cursor to find the value of allowAllApproverTypes config variable for the
47: -- current transaction type.
48: --
90: fetch C_Sel2 into l_count;
91: close C_Sel2;
92: if l_count <> 0 then
93: select name into l_group_name
94: from ame_approval_groups
95: where approval_group_id = p_approval_group_id
96: and sysdate between start_date and
97: nvl(end_date-ame_util.oneSecond,SYSDATE)
98: and rownum < 2;
314: --
315: l_proc varchar2(72) := g_package || 'CHK_APPROVAL_GROUP_ID';
316: l_count number;
317: --
318: -- Cursor to find if approval_group_id exists in ame_approval_groups
319: --
320: Cursor C_Sel1 Is
321: select count(approval_group_id)
322: from ame_approval_groups t
318: -- Cursor to find if approval_group_id exists in ame_approval_groups
319: --
320: Cursor C_Sel1 Is
321: select count(approval_group_id)
322: from ame_approval_groups t
323: where t.approval_group_id = p_approval_group_id
324: and p_effective_date between t.start_date and t.end_date;
325:
326: Begin
328: hr_api.mandatory_arg_error(p_api_name => l_proc
329: ,p_argument => 'APPROVAL_GROUP_ID'
330: ,p_argument_value => p_approval_group_id
331: );
332: -- Check if the approval_group_id is existing in ame_approval_groups.
333: open C_Sel1;
334: fetch C_Sel1 into l_count;
335: close C_Sel1;
336: if l_count = 0 then