APPS.AME_ATY_SHD dependencies on AME_UTIL

Line 61: between start_date and nvl(end_date - (ame_util.oneSecond), sysdate);

57: ,object_version_number
58: from ame_action_types
59: where action_type_id = p_action_type_id
60: and p_effective_date
61: between start_date and nvl(end_date - (ame_util.oneSecond), sysdate);
62: --
63: l_fct_ret boolean;
64: --
65: Begin

Line 155: and nvl(t.end_date - ame_util.oneSecond,sysdate);

151: ,t.last_update_login = l_current_user_id
152: ,t.object_version_number = l_object_version_number
153: where t.action_type_id = p_action_type_id
154: and p_effective_date between t.start_date
155: and nvl(t.end_date - ame_util.oneSecond,sysdate);
156: --
157: --
158: p_object_version_number := l_object_version_number;
159: hr_utility.set_location(' Leaving:'||l_proc, 15);

Line 198: between start_date and nvl(end_date - ame_util.oneSecond, sysdate)

194: ,object_version_number
195: from ame_action_types
196: where action_type_id = p_action_type_id
197: and p_effective_date
198: between start_date and nvl(end_date - ame_util.oneSecond, sysdate)
199: for update nowait;
200: --
201: --
202: --

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

384: select count(*)
385: from ame_actions
386: where action_type_id = p_action_type_id and
387: p_start_date between start_date and
388: nvl(end_date - ame_util.oneSecond, p_start_date);
389: --
390: Cursor C_Sel2 is
391: select count(*)
392: from ame_action_type_usages

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

391: select count(*)
392: from ame_action_type_usages
393: where action_type_id = p_action_type_id and
394: p_start_date between start_date and
395: nvl(end_date - ame_util.oneSecond, p_start_date);
396: --
397: Cursor C_Sel3 is
398: select count(*)
399: from ame_approver_type_usages

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

398: select count(*)
399: from ame_approver_type_usages
400: where action_type_id = p_action_type_id and
401: p_start_date between start_date and
402: nvl(end_date - ame_util.oneSecond, p_start_date);
403: --
404: Cursor C_Sel4 is
405: select count(*)
406: from ame_mandatory_attributes

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

405: select count(*)
406: from ame_mandatory_attributes
407: where action_type_id = p_action_type_id and
408: p_start_date between start_date and
409: nvl(end_date - ame_util.oneSecond, p_start_date);
410: --
411: Cursor C_Sel5 is
412: select count(*)
413: from ame_action_type_config

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

412: select count(*)
413: from ame_action_type_config
414: where action_type_id = p_action_type_id and
415: p_start_date between start_date and
416: nvl(end_date - ame_util.oneSecond, p_start_date);
417: l_child_count integer;
418: --
419: Begin
420: --