DBA Data[Home] [Help]

APPS.AME_ATU_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_attribute_usages t
103: where t.attribute_id = p_rec.attribute_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_attribute_usages.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 332: and nvl(end_date - ame_util.oneSecond , p_effective_date);

328: ame_atu_ins.g_attribute_id_i
329: and application_id =
330: ame_atu_ins.g_application_id_i
331: and p_effective_date between start_date
332: and nvl(end_date - ame_util.oneSecond , p_effective_date);
333: --
334: l_proc varchar2(72) := g_package||'pre_insert';
335: l_exists varchar2(1);
336: --

Line 524: p_validation_end_date := ame_utility_pkg.endOfTime;

520: -- p_validation_start_date := l_validation_start_date;
521: -- p_validation_end_date := l_validation_end_date;
522: -- MURTHY_CHANGES
523: p_validation_start_date := sysdate;
524: p_validation_end_date := ame_utility_pkg.endOfTime;
525: -- lock the parent rows
526: begin
527: select null
528: into l_dummy

Line 532: nvl(end_date - ame_util.oneSecond, p_effective_date)

528: into l_dummy
529: from ame_attributes
530: where attribute_id = p_rec.attribute_id
531: and p_effective_date between start_date and
532: nvl(end_date - ame_util.oneSecond, p_effective_date)
533: for update of end_date nowait;
534: exception
535: when others then
536: --

Line 634: ,p_user_editable in varchar2 default ame_util.booleanTrue

630: ,p_application_id in number
631: ,p_effective_date in date
632: ,p_use_count in number
633: ,p_query_string in varchar2 default null
634: ,p_user_editable in varchar2 default ame_util.booleanTrue
635: ,p_is_static in varchar2 default ame_util.booleanTrue
636: ,p_security_group_id in number default null
637: ,p_value_set_id in number default null
638: ,p_object_version_number out nocopy number

Line 635: ,p_is_static in varchar2 default ame_util.booleanTrue

631: ,p_effective_date in date
632: ,p_use_count in number
633: ,p_query_string in varchar2 default null
634: ,p_user_editable in varchar2 default ame_util.booleanTrue
635: ,p_is_static in varchar2 default ame_util.booleanTrue
636: ,p_security_group_id in number default null
637: ,p_value_set_id in number default null
638: ,p_object_version_number out nocopy number
639: ,p_start_date out nocopy date