DBA Data[Home] [Help]

APPS.AME_ITC_INS dependencies on AME_UTIL

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

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

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

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

Line 172: l_created_by := ame_util.seededDataCreatedById;

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

Line 307: nvl(end_date - ame_util.oneSecond, sysdate);

303: Select count(*)+1
304: from ame_item_classes
305: where
306: sysdate between start_date and
307: nvl(end_date - ame_util.oneSecond, sysdate);
308: --
309: Cursor C_Sel2 is
310: Select null
311: from ame_item_classes

Line 486: p_validation_end_date := ame_utility_pkg.endOfTime;

482: --
483: -- Set the validation start and end date OUT arguments
484: --
485: p_validation_start_date := sysdate;
486: p_validation_end_date := ame_utility_pkg.endOfTime;
487: --
488: hr_utility.set_location(' Leaving:'||l_proc, 10);
489: --
490: End ins_lck;