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_ACU_SHD dependencies on AME_UTIL

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

54: from ame_action_usages
55: where action_id = p_action_id
56: and rule_id = p_rule_id
57: and ( p_effective_date
58: between start_date and nvl(end_date - ame_util.oneSecond,p_effective_date)
59: or
60: (p_effective_date < start_date and
61: start_date < nvl(end_date,start_date + ame_util.oneSecond)));
62: --

Line 61: start_date < nvl(end_date,start_date + ame_util.oneSecond)));

57: and ( p_effective_date
58: between start_date and nvl(end_date - ame_util.oneSecond,p_effective_date)
59: or
60: (p_effective_date < start_date and
61: start_date < nvl(end_date,start_date + ame_util.oneSecond)));
62: --
63: l_fct_ret boolean;
64: --
65: Begin

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

155: , t.object_version_number = l_object_version_number
156: where t.action_id = p_action_id
157: and t.rule_id = p_rule_id
158: and ( p_effective_date
159: between t.start_date and nvl(t.end_date - ame_util.oneSecond,p_effective_date)
160: or
161: (p_effective_date < t.start_date and
162: t.start_date < nvl(t.end_date,t.start_date + ame_util.oneSecond)));
163: --

Line 162: t.start_date < nvl(t.end_date,t.start_date + ame_util.oneSecond)));

158: and ( p_effective_date
159: between t.start_date and nvl(t.end_date - ame_util.oneSecond,p_effective_date)
160: or
161: (p_effective_date < t.start_date and
162: t.start_date < nvl(t.end_date,t.start_date + ame_util.oneSecond)));
163: --
164: --
165: p_object_version_number := l_object_version_number;
166: hr_utility.set_location(' Leaving:'||l_proc, 15);

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

199: from ame_action_usages
200: where action_id = p_action_id
201: and rule_id = p_rule_id
202: and ( p_effective_date
203: between start_date and nvl(end_date - ame_util.oneSecond,p_effective_date)
204: or
205: (p_effective_date < start_date and
206: start_date < nvl(end_date,start_date + ame_util.oneSecond)))
207: for update nowait;

Line 206: start_date < nvl(end_date,start_date + ame_util.oneSecond)))

202: and ( p_effective_date
203: between start_date and nvl(end_date - ame_util.oneSecond,p_effective_date)
204: or
205: (p_effective_date < start_date and
206: start_date < nvl(end_date,start_date + ame_util.oneSecond)))
207: for update nowait;
208: --
209: --
210: --

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

289: into l_dummy
290: from ame_actions
291: where action_id = p_action_id
292: and p_effective_date between start_date and
293: nvl(end_date - ame_util.oneSecond, p_effective_date)
294: for update of end_date nowait;
295: /*select null
296: into l_dummy
297: from ame_rules

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

296: into l_dummy
297: from ame_rules
298: where rule_id = p_rule_id and
299: ((p_effective_date between start_date and
300: nvl(end_date - ame_util.oneSecond, p_effective_date)) or
301: (p_effective_date < start_date and
302: start_date < nvl(end_date,start_date + ame_util.oneSecond)))
303: for update of end_date nowait;*/
304: exception

Line 302: start_date < nvl(end_date,start_date + ame_util.oneSecond)))

298: where rule_id = p_rule_id and
299: ((p_effective_date between start_date and
300: nvl(end_date - ame_util.oneSecond, p_effective_date)) or
301: (p_effective_date < start_date and
302: start_date < nvl(end_date,start_date + ame_util.oneSecond)))
303: for update of end_date nowait;*/
304: exception
305: when others then
306: --