DBA Data[Home] [Help]

APPS.AME_ACA_INS dependencies on AME_UTIL

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

96: Cursor C_Sel2 Is
97: select created_by
98: from ame_calling_apps t
99: where t.application_id = p_rec.application_id
100: and ame_utility_pkg.is_seed_user(created_by) = ame_util.seededDataCreatedById
101: and rownum < 2;
102: --
103: l_proc varchar2(72) := g_package||'dt_insert_dml';
104: l_created_by ame_calling_apps.created_by%TYPE;

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

167: Else
168: p_rec.object_version_number := 1; -- Initialise the object version
169: --
170: -- If the current user logged in using AME Developer responsibility
171: -- then the created_by value should be ame_util.seededDataCreatedById
172: --
173: if fnd_global.resp_name = 'AME Developer' then
174: l_created_by := ame_util.seededDataCreatedById;
175: else

Line 174: l_created_by := ame_util.seededDataCreatedById;

170: -- If the current user logged in using AME Developer responsibility
171: -- then the created_by value should be ame_util.seededDataCreatedById
172: --
173: if fnd_global.resp_name = 'AME Developer' then
174: l_created_by := ame_util.seededDataCreatedById;
175: else
176: l_created_by := l_current_user_id;
177: end if;
178: l_creation_date := sysdate;

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

318: from ame_calling_apps
319: where application_id =
320: ame_aca_ins.g_application_id_i
321: and p_effective_date between start_date
322: and nvl(end_date - ame_util.oneSecond , p_effective_date);
323: --
324: l_proc varchar2(72) := g_package||'pre_insert';
325: l_exists varchar2(1);
326: --

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: hr_utility.set_location(' Leaving:'||l_proc, 10);
518: --
519: End ins_lck;