APPS.AME_RLU_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_rule_usages t
103: where t.rule_id = p_rec.rule_id
104: and t.item_id = p_rec.item_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_rule_usages.created_by%TYPE;

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

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

Line 186: l_created_by := ame_util.seededDataCreatedById;

182: -- If the current user logged in using AME Developer responsibility
183: -- then the created_by value should be ame_util.seededDataCreatedById
184: --
185: if fnd_global.resp_name = 'AME Developer' then
186: l_created_by := ame_util.seededDataCreatedById;
187: else
188: l_created_by := l_current_user_id;
189: end if;
190: -- For future rules, creation_date is set to sysdate.But for current rules it will be set to rule_start_date.

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

338: ame_rlu_ins.g_item_id_i
339: and rule_id =
340: ame_rlu_ins.g_rule_id_i
341: and p_effective_date between start_date
342: and nvl(end_date - ame_util.oneSecond , p_effective_date);
343: --
344: l_proc varchar2(72) := g_package||'pre_insert';
345: l_exists varchar2(1);
346: --

Line 530: p_validation_end_date := ame_utility_pkg.endOfTime;

526: -- p_validation_start_date := l_validation_start_date;
527: -- p_validation_end_date := l_validation_end_date;
528: -- MURTHY_CHANGES
529: p_validation_start_date := sysdate;
530: p_validation_end_date := ame_utility_pkg.endOfTime;
531: --
532: -- Lock the parent rows in ame_rules and ame_conditions
533: --
534: begin

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

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

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

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