APPS.AME_APU_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_approver_types
168: where
169: approver_type_id = p_approver_type_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: l_proc varchar2(72) := g_package||'chk_approver_type_id';
174: l_temp_count number;
175: begin

Line 180: if(p_approver_type_id = ame_util.anyApproverType) then

176: open c_sel1;
177: fetch c_sel1 into l_exists;
178: -- Verify if approver type id is valid (-1 = any approver type).
179: if(c_sel1%notfound) then
180: if(p_approver_type_id = ame_util.anyApproverType) then
181: select count(*) into l_temp_count
182: from ame_approver_type_usages
183: where
184: action_type_id = p_action_type_id and

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

182: from ame_approver_type_usages
183: where
184: action_type_id = p_action_type_id and
185: p_effective_date between start_date and
186: nvl(end_date - ame_util.oneSecond, p_effective_date);
187: if(l_temp_count <> 0) then
188: close c_sel1;
189: -- AT Message
190: -- Message: An approver id already exists. Need to delete before.

Line 249: ame_utility_pkg.check_seeddb = 'N' and

245: cursor c_sel1 Is
246: select null
247: from ame_action_types
248: where
249: ame_utility_pkg.check_seeddb = 'N' and
250: action_type_id = p_action_type_id and
251: ame_utility_pkg.is_seed_user(created_by) = ame_util.seededDataCreatedById;
252: l_exists varchar2(1);
253: begin

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

247: from ame_action_types
248: where
249: ame_utility_pkg.check_seeddb = 'N' and
250: action_type_id = p_action_type_id and
251: ame_utility_pkg.is_seed_user(created_by) = ame_util.seededDataCreatedById;
252: l_exists varchar2(1);
253: begin
254: open c_sel1;
255: fetch c_sel1 into l_exists;