APPS.AME_ATR_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_attributes t
99: where t.attribute_id = p_rec.attribute_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_attributes.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 326: and nvl(end_date - ame_util.oneSecond , p_effective_date);

322: from ame_attributes
323: where attribute_id =
324: ame_atr_ins.g_attribute_id_i
325: and p_effective_date between start_date
326: and nvl(end_date - ame_util.oneSecond , p_effective_date);
327: --
328: l_proc varchar2(72) := g_package||'pre_insert';
329: l_exists varchar2(1);
330: --

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;