APPS.AME_GCF_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_approval_group_config t
103: where t.approval_group_id = p_rec.approval_group_id
104: and t.application_id = p_rec.application_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_approval_group_config.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 390: and nvl(end_date - ame_util.oneSecond , p_effective_date);

386: ame_gcf_ins.g_application_id_i
387: and approval_group_id =
388: ame_gcf_ins.g_approval_group_id_i
389: and p_effective_date between start_date
390: and nvl(end_date - ame_util.oneSecond , p_effective_date);
391: --
392: l_proc varchar2(72) := g_package||'pre_insert';
393: l_exists varchar2(1);
394: --

Line 586: between start_date and nvl(end_date - ame_util.oneSecond, p_effective_date)

582: null
583: from ame_calling_apps
584: where application_id = p_rec.application_id
585: and p_effective_date
586: between start_date and nvl(end_date - ame_util.oneSecond, p_effective_date)
587: for update nowait;
588: Cursor C_Sel2 is
589: select
590: null

Line 594: between start_date and nvl(end_date - ame_util.oneSecond, p_effective_date)

590: null
591: from ame_approval_groups
592: where approval_group_id = p_rec.approval_group_id
593: and p_effective_date
594: between start_date and nvl(end_date - ame_util.oneSecond, p_effective_date)
595: for update nowait;
596: Begin
597: hr_utility.set_location('Entering:'||l_proc, 5);
598: --

Line 609: p_validation_end_date := ame_utility_pkg.endOfTime;

605: -- p_validation_start_date := l_validation_start_date;
606: -- p_validation_end_date := l_validation_end_date;
607: -- MURTHY_CHANGES
608: p_validation_start_date := sysdate;
609: p_validation_end_date := ame_utility_pkg.endOfTime;
610: --
611: ame_gcf_bus.chk_application_id(p_application_id => p_rec.application_id
612: ,p_effective_date => p_effective_date
613: );