APPS.AME_ACF_INS dependencies on AME_UTIL

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

100: select created_by
101: from ame_action_type_config t
102: where t.action_type_id = p_rec.action_type_id
103: and t.application_id = p_rec.application_id
104: and ame_utility_pkg.is_seed_user(created_by) = ame_util.seededDataCreatedById
105: and rownum<2;
106: --
107: l_proc varchar2(72) := g_package||'dt_insert_dml';
108: l_created_by ame_action_type_config.created_by%TYPE;

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

172: Else
173: p_rec.object_version_number := 1; -- Initialise the object version
174: --
175: -- If the current user logged in using AME Developer responsibility
176: -- then the created_by value should be ame_util.seededDataCreatedById
177: --
178: if fnd_global.resp_name = 'AME Developer' then
179: l_created_by := ame_util.seededDataCreatedById;
180: else

Line 179: l_created_by := ame_util.seededDataCreatedById;

175: -- If the current user logged in using AME Developer responsibility
176: -- then the created_by value should be ame_util.seededDataCreatedById
177: --
178: if fnd_global.resp_name = 'AME Developer' then
179: l_created_by := ame_util.seededDataCreatedById;
180: else
181: l_created_by := l_current_user_id;
182: end if;
183: l_creation_date := sysdate;

Line 327: nvl(end_date - ame_util.oneSecond, sysdate);

323: from ame_action_type_config
324: where
325: application_id = p_application_id and
326: sysdate between start_date and
327: nvl(end_date - ame_util.oneSecond, sysdate);
328: if(l_temp_count = 0) then
329: p_order_number := 1;
330: else
331: select (nvl(max(order_number), 0) + 1)

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

336: ame_action_type_config.action_type_id = ame_action_type_usages.action_type_id and
337: ame_action_type_config.application_id = p_application_id and
338: ame_action_type_usages.rule_type = l_rule_type and
339: p_effective_date between ame_action_type_config.start_date and
340: nvl(ame_action_type_config.end_date - ame_util.oneSecond, p_effective_date) and
341: p_effective_date between ame_action_type_usages.start_date and
342: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, p_effective_date);
343: end if;
344: else

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

338: ame_action_type_usages.rule_type = l_rule_type and
339: p_effective_date between ame_action_type_config.start_date and
340: nvl(ame_action_type_config.end_date - ame_util.oneSecond, p_effective_date) and
341: p_effective_date between ame_action_type_usages.start_date and
342: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, p_effective_date);
343: end if;
344: else
345: hr_api.mandatory_arg_error
346: (p_api_name => l_proc

Line 629: p_validation_end_date := ame_utility_pkg.endOfTime;

625: -- p_validation_start_date := l_validation_start_date;
626: -- p_validation_end_date := l_validation_end_date;
627: -- MURTHY_CHANGES
628: p_validation_start_date := sysdate;
629: p_validation_end_date := ame_utility_pkg.endOfTime;
630: --
631: hr_utility.set_location(' Leaving:'||l_proc, 10);
632: --
633: End ins_lck;