APPS.AME_STV_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_string_values t
103: where t.condition_id = p_rec.condition_id
104: and t.string_value = p_rec.string_value
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_string_values.created_by%TYPE;

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

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

Line 180: l_created_by := ame_util.seededDataCreatedById;

176: -- If the current user logged in using AME Developer responsibility
177: -- then the created_by value should be ame_util.seededDataCreatedById
178: --
179: if fnd_global.resp_name = 'AME Developer' then
180: l_created_by := ame_util.seededDataCreatedById;
181: else
182: l_created_by := l_current_user_id;
183: end if;
184: l_creation_date := sysdate;

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

320: ame_stv_ins.g_condition_id_i
321: and string_value =
322: ame_stv_ins.g_string_value_i
323: and p_effective_date between start_date
324: and nvl(end_date - ame_util.oneSecond , p_effective_date);
325: --
326: l_proc varchar2(72) := g_package||'pre_insert';
327: l_exists varchar2(1);
328: --

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

500: select null
501: from AME_CONDITIONS
502: where condition_id = p_rec.condition_id
503: and p_effective_date between start_date
504: and nvl(end_date - ame_util.oneSecond, p_effective_date)
505: for update nowait;
506: l_proc varchar2(72) := g_package||'ins_lck';
507: l_key varchar2(1);
508: l_validation_start_date date;

Line 536: p_validation_end_date := ame_utility_pkg.endOfTime;

532: end if;
533: close csr_lck;
534: --
535: p_validation_start_date := sysdate;
536: p_validation_end_date := ame_utility_pkg.endOfTime;
537: --
538: hr_utility.set_location(' Leaving:'||l_proc, 10);
539: --
540: End ins_lck;