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

Line 105: and ame_utility_pkg.is_seed_user(created_by) = ame_util.seededDataCreatedById

101: select created_by
102: from ame_condition_usages t
103: where t.condition_id = p_rec.condition_id
104: and t.rule_id = p_rec.rule_id
105: and ame_utility_pkg.is_seed_user(created_by) = ame_util.seededDataCreatedById
106: and rownum < 2;
107: --
108: l_proc varchar2(72) := g_package||'dt_insert_dml';
109: l_created_by ame_condition_usages.created_by%TYPE;

Line 181: -- then the created_by value should be ame_util.seededDataCreatedById

177: Else
178: p_rec.object_version_number := 1; -- Initialise the object version
179: --
180: -- If the current user logged in using AME Developer responsibility
181: -- then the created_by value should be ame_util.seededDataCreatedById
182: --
183: if fnd_global.resp_name = 'AME Developer' then
184: l_created_by := ame_util.seededDataCreatedById;
185: else

Line 184: l_created_by := ame_util.seededDataCreatedById;

180: -- If the current user logged in using AME Developer responsibility
181: -- then the created_by value should be ame_util.seededDataCreatedById
182: --
183: if fnd_global.resp_name = 'AME Developer' then
184: l_created_by := ame_util.seededDataCreatedById;
185: else
186: l_created_by := l_current_user_id;
187: end if;
188:

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

332: ame_cnu_ins.g_rule_id_i
333: and condition_id =
334: ame_cnu_ins.g_condition_id_i
335: and ( p_effective_date
336: between start_date and nvl(end_date - ame_util.oneSecond,p_effective_date)
337: or
338: (p_effective_date < start_date and
339: start_date < nvl(end_date,start_date + ame_util.oneSecond)));
340: --

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

335: and ( p_effective_date
336: between start_date and nvl(end_date - ame_util.oneSecond,p_effective_date)
337: or
338: (p_effective_date < start_date and
339: start_date < nvl(end_date,start_date + ame_util.oneSecond)));
340: --
341: l_proc varchar2(72) := g_package||'pre_insert';
342: l_exists varchar2(1);
343: --

Line 521: p_validation_end_date := ame_utility_pkg.endOfTime;

517: -- p_validation_start_date := l_validation_start_date;
518: -- p_validation_end_date := l_validation_end_date;
519: -- MURTHY_CHANGES
520: p_validation_start_date := sysdate;
521: p_validation_end_date := ame_utility_pkg.endOfTime;
522: --
523: -- Lock the parent rows in ame_rules and ame_conditions
524: --
525: begin

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

527: into l_dummy
528: from ame_conditions
529: where condition_id = p_rec.condition_id
530: and p_effective_date between start_date and
531: nvl(end_date - ame_util.oneSecond, p_effective_date)
532: for update of end_date nowait;
533: select null
534: into l_dummy
535: from ame_rules

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

534: into l_dummy
535: from ame_rules
536: where rule_id = p_rec.rule_id and
537: ((p_effective_date between start_date and
538: nvl(end_date - ame_util.oneSecond, p_effective_date)) or
539: (p_effective_date < start_date and
540: start_date < nvl(end_date,start_date + ame_util.oneSecond)))
541: for update of end_date nowait;
542: exception

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

536: where rule_id = p_rec.rule_id and
537: ((p_effective_date between start_date and
538: nvl(end_date - ame_util.oneSecond, p_effective_date)) or
539: (p_effective_date < start_date and
540: start_date < nvl(end_date,start_date + ame_util.oneSecond)))
541: for update of end_date nowait;
542: exception
543: when others then
544: --