APPS.AME_APG_SHD dependencies on AME_UTIL

Line 61: and nvl(end_date - ame_util.oneSecond,p_effective_date);

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

Line 147: between t.start_date and nvl(t.end_date - ame_util.oneSecond,p_effective_date)

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;

Line 190: between start_date and nvl(end_date - ame_util.oneSecond, p_effective_date)

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: --

Line 359: nvl(end_date - ame_util.oneSecond, p_start_date);

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

Line 366: nvl(end_date - ame_util.oneSecond, p_start_date);

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;