DBA Data[Home] [Help]

APPS.AME_APU_INS dependencies on AME_UTIL

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

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

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

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

Line 179: l_created_by := ame_util.seededDataCreatedById;

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

Line 499: start_date and nvl(end_date - ame_util.oneSecond, sysdate)

495: select action_type_id
496: from ame_action_types
497: where action_type_id = p_rec.action_type_id and
498: p_effective_date between
499: start_date and nvl(end_date - ame_util.oneSecond, sysdate)
500: for update nowait;
501: l_proc varchar2(72) := g_package||'ins_lck';
502: l_validation_start_date date;
503: l_validation_end_date date;

Line 523: p_validation_end_date := ame_utility_pkg.endOfTime;

519: -- p_validation_start_date := l_validation_start_date;
520: -- p_validation_end_date := l_validation_end_date;
521: -- MURTHY_CHANGES
522: p_validation_start_date := sysdate;
523: p_validation_end_date := ame_utility_pkg.endOfTime;
524: --
525: hr_utility.set_location(' Leaving:'||l_proc, 10);
526: --
527: End ins_lck;