DBA Data[Home] [Help]

APPS.AME_MAN_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_mandatory_attributes t
102: where t.attribute_id = p_rec.attribute_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_mandatory_attributes.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 502: start_date and nvl(end_date - ame_util.oneSecond, sysdate)

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

Line 526: p_validation_end_date := ame_utility_pkg.endOfTime;

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