DBA Data[Home] [Help]

APPS.AME_ITC_BUS dependencies on AME_UTIL

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

90: select null
91: from ame_item_classes
92: where name = p_name
93: and p_effective_date between start_date and
94: nvl(end_date - ame_util.oneSecond, p_effective_date);
95: --
96: l_proc varchar2(72) := g_package || 'CHK_UNIQUE';
97: l_dummy varchar2(1);
98: --

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

154: select null
155: from ame_item_classes
156: where item_class_id = p_item_class_id
157: and p_effective_date between start_date and
158: nvl(end_date - ame_util.oneSecond, p_effective_date)
159: and ame_utility_pkg.is_seed_user(created_by) = ame_util.seededDataCreatedById;
160: l_proc varchar2(72) := g_package || 'CHK_DELETE';
161: l_key varchar2(1);
162: --

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

155: from ame_item_classes
156: where item_class_id = p_item_class_id
157: and p_effective_date between start_date and
158: nvl(end_date - ame_util.oneSecond, p_effective_date)
159: and ame_utility_pkg.is_seed_user(created_by) = ame_util.seededDataCreatedById;
160: l_proc varchar2(72) := g_package || 'CHK_DELETE';
161: l_key varchar2(1);
162: --
163: Begin