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

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

57: ,object_version_number
58: from ame_rules
59: where rule_id = p_rule_id
60: and ( p_effective_date
61: between start_date and nvl(end_date - ame_util.oneSecond,p_effective_date)
62: or
63: (p_effective_date < start_date and
64: start_date < nvl(end_date,start_date + ame_util.oneSecond)));
65: --

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

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

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

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

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

156: and ( p_effective_date
157: between t.start_date and nvl(t.end_date - ame_util.oneSecond,p_effective_date)
158: or
159: (p_effective_date < t.start_date and
160: t.start_date < nvl(t.end_date,t.start_date + ame_util.oneSecond)))
161: ;
162: --
163: --
164: p_object_version_number := l_object_version_number;

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

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

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

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

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

374: select count(*)
375: from ame_rule_usages
376: where rule_id = p_rule_id
377: and p_start_date between start_date and
378: nvl(end_date - ame_util.oneSecond, p_start_date);
379: Cursor C_Sel2 is
380: select count(*)
381: from ame_action_usages
382: where rule_id = p_rule_id

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

380: select count(*)
381: from ame_action_usages
382: where rule_id = p_rule_id
383: and p_start_date between start_date and
384: nvl(end_date - ame_util.oneSecond, p_start_date);
385: Cursor C_Sel3 is
386: select count(*)
387: from ame_condition_usages
388: where rule_id = p_rule_id

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

386: select count(*)
387: from ame_condition_usages
388: where rule_id = p_rule_id
389: and p_start_date between start_date and
390: nvl(end_date - ame_util.oneSecond, p_start_date);
391: --
392: --
393: l_child_count integer;
394: --