APPS.AME_ACU_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_action_usages t
103: where t.action_id = p_rec.action_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_action_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: -- For future rules, creation_date is set to sysdate.But for current rules it will be set to rule_start_date.

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

328: ame_acu_ins.g_rule_id_i
329: and action_id =
330: ame_acu_ins.g_action_id_i
331: and ( p_effective_date
332: between start_date and nvl(end_date - ame_util.oneSecond,p_effective_date)
333: or
334: (p_effective_date < start_date and
335: start_date < nvl(end_date,start_date + ame_util.oneSecond)));
336: --

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

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

Line 515: p_validation_end_date := ame_utility_pkg.endOfTime;

511: -- p_validation_start_date := l_validation_start_date;
512: -- p_validation_end_date := l_validation_end_date;
513: -- MURTHY_CHANGES
514: p_validation_start_date := sysdate;
515: p_validation_end_date := ame_utility_pkg.endOfTime;
516: --
517: -- Lock the parent rows in ame_rules and ame_conditions
518: --
519: begin

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

521: into l_dummy
522: from ame_actions
523: where action_id = p_rec.action_id
524: and p_effective_date between start_date and
525: nvl(end_date - ame_util.oneSecond, p_effective_date)
526: for update of end_date nowait;
527: select null
528: into l_dummy
529: from ame_rules

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

528: into l_dummy
529: from ame_rules
530: where rule_id = p_rec.rule_id and
531: ((p_effective_date between start_date and
532: nvl(end_date - ame_util.oneSecond, p_effective_date)) or
533: (p_effective_date < start_date and
534: start_date < nvl(end_date,start_date + ame_util.oneSecond)))
535: for update of end_date nowait;
536: exception

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

530: where rule_id = p_rec.rule_id and
531: ((p_effective_date between start_date and
532: nvl(end_date - ame_util.oneSecond, p_effective_date)) or
533: (p_effective_date < start_date and
534: start_date < nvl(end_date,start_date + ame_util.oneSecond)))
535: for update of end_date nowait;
536: exception
537: when others then
538: --