APPS.AME_GPI_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_approval_group_items t
99: where t.approval_group_item_id = p_rec.approval_group_item_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_approval_group_items.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_approval_group_items
319: where approval_group_item_id =
320: ame_gpi_ins.g_approval_group_item_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 511: between start_date and nvl(end_date - ame_util.oneSecond, p_effective_date)

507: null
508: from ame_approval_groups
509: where approval_group_id = p_rec.approval_group_id
510: and p_effective_date
511: between start_date and nvl(end_date - ame_util.oneSecond, p_effective_date)
512: for update nowait;
513: Begin
514: hr_utility.set_location('Entering:'||l_proc, 5);
515: --

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: ame_gpi_bus.chk_approval_group_id
528: (p_approval_group_id => p_rec.approval_group_id
529: ,p_effective_date => p_effective_date
530: );