APPS.AME_AXU_BUS dependencies on AME_UTIL

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

47: from ame_action_types
48: where
49: action_type_id = p_action_type_id and
50: p_effective_date between start_date and
51: nvl(end_date - ame_util.oneSecond, p_effective_date) ;
52: l_exists varchar2(1);
53: begin
54: open c_sel1;
55: fetch c_sel1 into l_exists;

Line 175: ame_util.authorityRuleType,

171: ,p_argument => 'rule_type'
172: ,p_argument_value => p_rule_type
173: );
174: if p_rule_type not in (
175: ame_util.authorityRuleType,
176: ame_util.listModRuleType,
177: ame_util.substitutionRuleType,
178: ame_util.preListGroupRuleType,
179: ame_util.postListGroupRuleType,

Line 176: ame_util.listModRuleType,

172: ,p_argument_value => p_rule_type
173: );
174: if p_rule_type not in (
175: ame_util.authorityRuleType,
176: ame_util.listModRuleType,
177: ame_util.substitutionRuleType,
178: ame_util.preListGroupRuleType,
179: ame_util.postListGroupRuleType,
180: ame_util.productionRuleType) then

Line 177: ame_util.substitutionRuleType,

173: );
174: if p_rule_type not in (
175: ame_util.authorityRuleType,
176: ame_util.listModRuleType,
177: ame_util.substitutionRuleType,
178: ame_util.preListGroupRuleType,
179: ame_util.postListGroupRuleType,
180: ame_util.productionRuleType) then
181: -- AT MESSAGE

Line 178: ame_util.preListGroupRuleType,

174: if p_rule_type not in (
175: ame_util.authorityRuleType,
176: ame_util.listModRuleType,
177: ame_util.substitutionRuleType,
178: ame_util.preListGroupRuleType,
179: ame_util.postListGroupRuleType,
180: ame_util.productionRuleType) then
181: -- AT MESSAGE
182: -- The rule type specified is not valid

Line 179: ame_util.postListGroupRuleType,

175: ame_util.authorityRuleType,
176: ame_util.listModRuleType,
177: ame_util.substitutionRuleType,
178: ame_util.preListGroupRuleType,
179: ame_util.postListGroupRuleType,
180: ame_util.productionRuleType) then
181: -- AT MESSAGE
182: -- The rule type specified is not valid
183: fnd_message.set_name('PER','AME_400638_INVALID_RULE_TYPE');

Line 180: ame_util.productionRuleType) then

176: ame_util.listModRuleType,
177: ame_util.substitutionRuleType,
178: ame_util.preListGroupRuleType,
179: ame_util.postListGroupRuleType,
180: ame_util.productionRuleType) then
181: -- AT MESSAGE
182: -- The rule type specified is not valid
183: fnd_message.set_name('PER','AME_400638_INVALID_RULE_TYPE');
184: fnd_message.raise_error;

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

287: select null
288: from ame_action_types
289: where
290: action_type_id = p_action_type_id and
291: ame_utility_pkg.is_seed_user(created_by) = ame_util.seededDataCreatedById and
292: ame_utility_pkg.check_seeddb = 'N';
293: l_exists varchar2(1);
294: begin
295: open c_sel1;

Line 292: ame_utility_pkg.check_seeddb = 'N';

288: from ame_action_types
289: where
290: action_type_id = p_action_type_id and
291: ame_utility_pkg.is_seed_user(created_by) = ame_util.seededDataCreatedById and
292: ame_utility_pkg.check_seeddb = 'N';
293: l_exists varchar2(1);
294: begin
295: open c_sel1;
296: fetch c_sel1 into l_exists;