eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AME_MAN_BUS dependencies on AME_UTIL

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

103: from ame_action_types
104: where
105: action_type_id = p_action_type_id and
106: p_effective_date between start_date and
107: nvl(end_date - ame_util.oneSecond, p_effective_date) ;
108: l_exists varchar2(1);
109: begin
110: open c_sel1;
111: fetch c_sel1 into l_exists;

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

167: from ame_attributes
168: where
169: attribute_id = p_attribute_id and
170: p_effective_date between start_date and
171: nvl(end_date - ame_util.oneSecond, p_effective_date) ;
172: l_exists varchar2(1);
173: begin
174: open c_sel1;
175: fetch c_sel1 into l_exists;

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

205: from ame_mandatory_attributes
206: where attribute_id = p_attribute_id and
207: action_type_id = -1 and
208: p_effective_date between start_date and
209: nvl(end_date - ame_util.oneSecond, p_effective_date) ;
210: l_exists varchar2(1);
211: begin
212: open c_sell;
213: fetch c_sell into l_exists;

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

241: select created_by
242: from ame_action_types
243: where action_type_id = p_action_type_id and
244: p_effective_date between start_date and
245: nvl(end_date - ame_util.oneSecond, p_effective_date) ;
246: l_created_by number;
247: begin
248: open c_sell;
249: fetch c_sell into l_created_by;

Line 250: if ame_utility_pkg.is_seed_user(l_created_by) = ame_util.seededDataCreatedById and

246: l_created_by number;
247: begin
248: open c_sell;
249: fetch c_sell into l_created_by;
250: if ame_utility_pkg.is_seed_user(l_created_by) = ame_util.seededDataCreatedById and
251: ame_utility_pkg.check_seeddb = 'N'
252: then
253: fnd_message.set_name('PER','AME_400793_SEED_ATY_NO_UPD');
254: fnd_message.raise_error;

Line 251: ame_utility_pkg.check_seeddb = 'N'

247: begin
248: open c_sell;
249: fetch c_sell into l_created_by;
250: if ame_utility_pkg.is_seed_user(l_created_by) = ame_util.seededDataCreatedById and
251: ame_utility_pkg.check_seeddb = 'N'
252: then
253: fnd_message.set_name('PER','AME_400793_SEED_ATY_NO_UPD');
254: fnd_message.raise_error;
255: end if;

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

301: select null
302: from ame_action_types
303: where
304: action_type_id = p_action_type_id and
305: ame_utility_pkg.is_seed_user(created_by) = ame_util.seededDataCreatedById and
306: ame_utility_pkg.check_seeddb = 'N';
307: l_exists varchar2(1);
308: begin
309: open c_sel1;

Line 306: ame_utility_pkg.check_seeddb = 'N';

302: from ame_action_types
303: where
304: action_type_id = p_action_type_id and
305: ame_utility_pkg.is_seed_user(created_by) = ame_util.seededDataCreatedById and
306: ame_utility_pkg.check_seeddb = 'N';
307: l_exists varchar2(1);
308: begin
309: open c_sel1;
310: fetch c_sel1 into l_exists;