APPS.AME_RUL_INS dependencies on AME_UTIL

Line 36: seededKeyPrefix := ame_util.seededKeyPrefix;

32: when no_data_found then
33: databaseId := null;
34: end;
35: if (fnd_global.resp_name = 'AME Developer') then
36: seededKeyPrefix := ame_util.seededKeyPrefix;
37: else
38: seededKeyPrefix := null;
39: end if;
40: loop

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

150: Cursor C_Sel2 Is
151: select created_by
152: from ame_rules t
153: where t.rule_id = p_rec.rule_id
154: and ame_utility_pkg.is_seed_user(created_by) = ame_util.seededDataCreatedById
155: and rownum < 2;
156: --
157: l_proc varchar2(72) := g_package||'dt_insert_dml';
158: l_created_by ame_rules.created_by%TYPE;

Line 230: -- then the created_by value should be ame_util.seededDataCreatedById

226: Else
227: p_rec.object_version_number := 1; -- Initialise the object version
228: --
229: -- If the current user logged in using AME Developer responsibility
230: -- then the created_by value should be ame_util.seededDataCreatedById
231: --
232: if fnd_global.resp_name = 'AME Developer' then
233: l_created_by := ame_util.seededDataCreatedById;
234: else

Line 233: l_created_by := ame_util.seededDataCreatedById;

229: -- If the current user logged in using AME Developer responsibility
230: -- then the created_by value should be ame_util.seededDataCreatedById
231: --
232: if fnd_global.resp_name = 'AME Developer' then
233: l_created_by := ame_util.seededDataCreatedById;
234: else
235: l_created_by := l_current_user_id;
236: end if;
237: -- For future rules, creation_date is set to sysdate.But for current rules it will be set to rule_start_date.

Line 390: between start_date and nvl(end_date - ame_util.oneSecond,p_effective_date)

386: from ame_rules
387: where rule_id =
388: ame_rul_ins.g_rule_id_i
389: and ( p_effective_date
390: between start_date and nvl(end_date - ame_util.oneSecond,p_effective_date)
391: or
392: (p_effective_date < start_date and
393: start_date < nvl(end_date,start_date + ame_util.oneSecond)));
394: --

Line 393: start_date < nvl(end_date,start_date + ame_util.oneSecond)));

389: and ( p_effective_date
390: between start_date and nvl(end_date - ame_util.oneSecond,p_effective_date)
391: or
392: (p_effective_date < start_date and
393: start_date < nvl(end_date,start_date + ame_util.oneSecond)));
394: --
395: l_proc varchar2(72) := g_package||'pre_insert';
396: l_exists varchar2(1);
397: --

Line 594: p_validation_end_date := ame_utility_pkg.endOfTime;

590: -- p_validation_start_date := l_validation_start_date;
591: -- p_validation_end_date := l_validation_end_date;
592: -- MURTHY_CHANGES
593: p_validation_start_date := sysdate;
594: p_validation_end_date := ame_utility_pkg.endOfTime;
595: --
596: hr_utility.set_location(' Leaving:'||l_proc, 10);
597: --
598: End ins_lck;

Line 630: p_rec.end_date := ame_utility_pkg.endOfTime;

626: if p_rec.start_date is null then
627: p_rec.start_date := p_effective_date;
628: end if;
629: if p_rec.end_date is null then
630: p_rec.end_date := ame_utility_pkg.endOfTime;
631: end if;
632:
633: --
634: -- Call the supporting insert validate operations