eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AME_ATU_SHD dependencies on AME_UTIL

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

61: where attribute_id = p_attribute_id
62: and application_id = p_application_id
63: and p_effective_date
64: between start_date
65: and nvl(end_date - ame_util.oneSecond,p_effective_date);
66: --
67: l_fct_ret boolean;
68: --
69: Begin

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

170: , t.object_version_number = l_object_version_number
171: where t.attribute_id = p_attribute_id
172: and t.application_id = p_application_id
173: and p_effective_date
174: between t.start_date and nvl(t.end_date - ame_util.oneSecond,p_effective_date)
175: ;
176: --
177: --
178: p_object_version_number := l_object_version_number;

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

218: from ame_attribute_usages
219: where attribute_id = p_attribute_id
220: and application_id = p_application_id
221: and p_effective_date
222: between start_date and nvl(end_date - ame_util.oneSecond, p_effective_date)
223: for update nowait;
224: --
225: --
226: --

Line 309: nvl(end_date - ame_util.oneSecond, p_effective_date)

305: into l_dummy
306: from ame_attributes
307: where attribute_id = p_attribute_id
308: and p_effective_date between start_date and
309: nvl(end_date - ame_util.oneSecond, p_effective_date)
310: for update of end_date nowait;
311: exception
312: when others then
313: --