APPS.AME_APT_BUS dependencies on AME_UTIL

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

166: select null
167: from ame_approver_types
168: where orig_system = p_orig_system
169: and p_effective_date between start_date and
170: nvl(end_date - ame_util.oneSecond, p_effective_date);
171: --
172: l_proc varchar2(72) := g_package || 'CHK_UNIQUE';
173: l_dummy varchar2(1);
174: --

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

241: select null
242: from ame_approver_types
243: where approver_type_id = p_approver_type_id
244: and p_effective_date between start_date
245: and nvl(end_date - ame_util.oneSecond, p_effective_date)
246: and ame_utility_pkg.is_seed_user(created_by) = ame_util.seededDataCreatedById;
247: --
248: cursor c_sel1 is
249: select null

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

242: from ame_approver_types
243: where approver_type_id = p_approver_type_id
244: and p_effective_date between start_date
245: and nvl(end_date - ame_util.oneSecond, p_effective_date)
246: and ame_utility_pkg.is_seed_user(created_by) = ame_util.seededDataCreatedById;
247: --
248: cursor c_sel1 is
249: select null
250: from ame_attributes

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

249: select null
250: from ame_attributes
251: where approver_type_id = p_approver_type_id
252: and p_effective_date between start_date
253: and nvl(end_date - ame_util.oneSecond, p_effective_date);
254: --
255: cursor c_sel2 is
256: select null
257: from ame_approver_type_usages

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

256: select null
257: from ame_approver_type_usages
258: where approver_type_id = p_approver_type_id
259: and p_effective_date between start_date
260: and nvl(end_date - ame_util.oneSecond, p_effective_date);
261: --
262: cursor c_sel3 is
263: select null
264: from AME_APPROVAL_GROUP_MEMBERS

Line 274: and nvl(cond.end_date - ame_util.oneSecond, p_effective_date);

270: ,WF_ROLES wfr
271: where cond.parameter_two = wfr.name
272: and wfr.orig_system = p_orig_system
273: and p_effective_date between cond.start_date
274: and nvl(cond.end_date - ame_util.oneSecond, p_effective_date);
275: --
276: Cursor c_sel5 is
277: select null
278: from AME_ACTIONS actions

Line 285: and nvl(actions.end_date - ame_util.oneSecond, p_effective_date);

281: where actions.parameter = wfr.name
282: and wfr.orig_system = p_orig_system
283: and act.name ='substitution'
284: and p_effective_date between actions.start_date
285: and nvl(actions.end_date - ame_util.oneSecond, p_effective_date);
286: l_exists varchar2(1);
287: begin
288: open csr_isSeeded;
289: fetch csr_isSeeded into l_key;

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

641: select orig_system
642: from ame_approver_types
643: where approver_type_id = p_rec.approver_type_id
644: and p_effective_date between start_date
645: and nvl(end_date - ame_util.oneSecond, p_effective_date);
646: Begin
647: hr_utility.set_location('Entering:'||l_proc, 5);
648: --
649: -- Call all supporting business operations