APPS.AME_ATY_BUS dependencies on AME_UTILITY_PKG

Line 70: select ame_utility_pkg.is_seed_user(created_by)

66: fnd_message.raise_error;
67: END IF;
68: -- EDIT_HERE: Add checks to ensure non-updateable args have
69: -- not been updated.
70: select ame_utility_pkg.is_seed_user(created_by)
71: into createdBy
72: from ame_action_types
73: where
74: action_type_id = p_rec.action_type_id and

Line 78: and ame_utility_pkg.check_seeddb = 'N' then

74: action_type_id = p_rec.action_type_id and
75: p_effective_date between start_date and
76: nvl(end_date - ame_util.oneSecond, p_effective_date);
77: IF createdBy = ame_util.seededDataCreatedById
78: and ame_utility_pkg.check_seeddb = 'N' then
79: IF
80: nvl(p_rec.name,
81: hr_api.g_number) <>
82: nvl(ame_aty_shd.g_old_rec.name,

Line 424: l_valid := ame_utility_pkg.validate_query(p_query_string => p_description_query

420: END IF;
421: END IF;
422: END IF;
423: ame_util.checkForSqlInjection(queryStringIn => upper(p_description_query));
424: l_valid := ame_utility_pkg.validate_query(p_query_string => p_description_query
425: ,p_columns => 1
426: ,p_object => ame_util2.actionTypeObject
427: );
428: if l_valid <> 'Y' then

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

516: select null
517: from ame_action_types
518: where
519: action_type_id = p_action_type_id and
520: ame_utility_pkg.is_seed_user(created_by) = ame_util.seededDataCreatedById and
521: ame_utility_pkg.check_seeddb = 'N';
522: cursor c_sel6 Is
523: select null
524: from ame_actions

Line 521: ame_utility_pkg.check_seeddb = 'N';

517: from ame_action_types
518: where
519: action_type_id = p_action_type_id and
520: ame_utility_pkg.is_seed_user(created_by) = ame_util.seededDataCreatedById and
521: ame_utility_pkg.check_seeddb = 'N';
522: cursor c_sel6 Is
523: select null
524: from ame_actions
525: where