APPS.AME_RUL_BUS dependencies on AME_RULES

Line 45: p_description in ame_rules.description%type) is

41: procedure chk_description
42: (p_rule_id in number,
43: p_object_version_number in number,
44: p_effective_date in date,
45: p_description in ame_rules.description%type) is
46: l_proc varchar2(72) := g_package||'chk_description';
47: l_descriptionCount number;
48: begin
49: -- check description is null

Line 57: from ame_rules

53: );
54: -- check description not in use
55: select count(*)
56: into l_descriptionCount
57: from ame_rules
58: where upper(description) = upper(p_description)
59: and (p_rule_id is null or rule_id <> p_rule_id) /* allows for future start date */
60: and ((p_effective_date between start_date
61: and nvl(end_date - ame_util.oneSecond, p_effective_date))

Line 71: if(ame_util.isArgumentTooLong(tableNameIn => 'ame_rules'

67: fnd_message.set_name('PER','AME_400206_RUL_DESC_IN_USE');
68: fnd_message.raise_error;
69: end if;
70: -- check length
71: if(ame_util.isArgumentTooLong(tableNameIn => 'ame_rules'
72: ,columnNameIn => 'description'
73: ,argumentIn => p_description)) then
74: fnd_message.set_name('PER','AME_400207_RUL_DESC_LONG');
75: fnd_message.raise_error;

Line 124: p_item_class_id in ame_rules.item_class_id%type,

120: procedure chk_item_class_id
121: (p_rule_id in number,
122: p_object_version_number in number,
123: p_effective_date in date,
124: p_item_class_id in ame_rules.item_class_id%type,
125: p_rule_type in ame_rules.rule_type%type) is
126: l_proc varchar2(72) := g_package||'chk_item_class_id';
127: tempCount integer;
128: cursor c_sel1 is

Line 125: p_rule_type in ame_rules.rule_type%type) is

121: (p_rule_id in number,
122: p_object_version_number in number,
123: p_effective_date in date,
124: p_item_class_id in ame_rules.item_class_id%type,
125: p_rule_type in ame_rules.rule_type%type) is
126: l_proc varchar2(72) := g_package||'chk_item_class_id';
127: tempCount integer;
128: cursor c_sel1 is
129: select null

Line 191: from ame_rules

187: l_count number(2);
188: begin
189: select count(*)
190: into l_count
191: from ame_rules
192: where lower(p_rule_key) = lower(rule_key);
193: if l_count > 0 then
194: fnd_message.set_name('PER','AME_400359_RULE_KEY_EXIST');
195: fnd_message.raise_error;

Line 241: p_rule_type in ame_rules.rule_type%type) is

237: -- ----------------------------------------------------------------------------
238: procedure chk_rule_type
239: (p_rule_id in number,
240: p_object_version_number in number,
241: p_rule_type in ame_rules.rule_type%type) is
242: l_proc varchar2(72) := g_package||'chk_rule_type';
243: begin
244: if not (p_rule_type = ame_util.combinationRuleType or
245: p_rule_type = ame_util.authorityRuleType or

Line 362: p_start_date in ame_rules.start_date%type,

358: procedure chk_start_end_date_combination
359: (p_rule_id in number,
360: p_object_version_number in number,
361: p_effective_date in date,
362: p_start_date in ame_rules.start_date%type,
363: p_end_date in ame_rules.end_date%type) is
364: l_proc varchar2(72) := g_package||'chk_start_end_date_combination';
365: begin
366: if(p_start_date is null or

Line 363: p_end_date in ame_rules.end_date%type) is

359: (p_rule_id in number,
360: p_object_version_number in number,
361: p_effective_date in date,
362: p_start_date in ame_rules.start_date%type,
363: p_end_date in ame_rules.end_date%type) is
364: l_proc varchar2(72) := g_package||'chk_start_end_date_combination';
365: begin
366: if(p_start_date is null or
367: p_start_date < p_effective_date ) then