57: from ame_approval_groups
58: where approval_group_id = p_approval_group_id
59: and p_effective_date
60: between start_date
61: and nvl(end_date - ame_util.oneSecond,p_effective_date);
62: --
63: l_fct_ret boolean;
64: --
65: Begin
143: set t.end_date = p_new_end_date
144: , t.object_version_number = l_object_version_number
145: where t.approval_group_id = p_approval_group_id
146: and p_effective_date
147: between t.start_date and nvl(t.end_date - ame_util.oneSecond,p_effective_date)
148: ;
149: --
150: --
151: p_object_version_number := l_object_version_number;
186: ,object_version_number
187: from ame_approval_groups
188: where approval_group_id = p_approval_group_id
189: and p_effective_date
190: between start_date and nvl(end_date - ame_util.oneSecond, p_effective_date)
191: for update nowait;
192: --
193: --
194: --
355: select count(*)
356: from ame_approval_group_items
357: where approval_group_id = p_
358: and p_start_date between start_date and
359: nvl(end_date - ame_util.oneSecond, p_start_date);
360:
361: Cursor C_Sel2 is
362: select count(*)
363: from ame_approval_group_config
362: select count(*)
363: from ame_approval_group_config
364: where approval_group_id = p_
365: and p_start_date between start_date and
366: nvl(end_date - ame_util.oneSecond, p_start_date);
367: --
368: --
369: --
370: l_child_count integer;