APPS.AME_TEST_UTILITY_PKG dependencies on AME_RULE

Line 172: where fl.lookup_type = 'AME_RULE_TYPE'

168: begin
169: select meaning
170: into ruleTypeDesc
171: from fnd_lookups fl
172: where fl.lookup_type = 'AME_RULE_TYPE'
173: and fl.enabled_flag = 'Y'
174: and fl.lookup_code = ruleTypeIn
175: and trunc(sysdate) between start_date_active
176: and nvl(end_date_active, trunc(sysdate));

Line 195: from ame_rules

191: ruleTypeDesc fnd_lookups.meaning%type;
192: begin
193: select rule_type
194: into ruleTypeCode
195: from ame_rules
196: where rule_id = ruleIdIn
197: and effectiveDateIn between start_date
198: and nvl(end_date - ame_util.oneSecond, sysdate);
199: return getApprovalCategoryDesc(ruleTypeCode);

Line 219: from ame_rule_usages

215: begin
216: begin
217: select approver_category
218: into categoryCode
219: from ame_rule_usages
220: where rule_id = ruleIdIn
221: and item_id = applicationIdIn
222: and effectiveDateIn between start_date
223: and nvl(end_date - ame_util.oneSecond, sysdate);

Line 351: ruleDesc ame_rules_vl.description%type;

347: return null;
348: end getActionsList;
349: --+
350: function getRuleDescription(ruleIdIn in integer,effectiveRuleDate in date) return varchar2 as
351: ruleDesc ame_rules_vl.description%type;
352: begin
353: select description
354: into ruleDesc
355: from ame_rules_vl

Line 355: from ame_rules_vl

351: ruleDesc ame_rules_vl.description%type;
352: begin
353: select description
354: into ruleDesc
355: from ame_rules_vl
356: where rule_id = ruleIdIn
357: and effectiveRuleDate between start_date
358: and nvl(end_date - ame_util.oneSecond, sysdate);
359: return ruleDesc;

Line 1006: ,rulesOut out nocopy ame_rules_list

1002: ,transactionIdIn in varchar2
1003: ,isRealTransaction in varchar2 -- 'Y' for a real transaction
1004: -- 'N' for a test transaction
1005: ,processPriorities in varchar2
1006: ,rulesOut out nocopy ame_rules_list
1007: ,errString out nocopy varchar2) as
1008: ruleItemClassIds ame_util.idList;
1009: itemClassIds ame_util.idList;
1010: itemIds ame_util.stringList;

Line 1014: rulesList ame_rules_list := ame_rules_list();

1010: itemIds ame_util.stringList;
1011: ruleTypes ame_util.idList;
1012: ruleDescriptions ame_util.stringList;
1013: ruleIds ame_util.idList;
1014: rulesList ame_rules_list := ame_rules_list();
1015: ruleObject ame_rule;
1016: effectiveRuleDate date;
1017: effecitveRuleDateString ame_util.stringType;
1018: itemClassName varchar2(100);

Line 1015: ruleObject ame_rule;

1011: ruleTypes ame_util.idList;
1012: ruleDescriptions ame_util.stringList;
1013: ruleIds ame_util.idList;
1014: rulesList ame_rules_list := ame_rules_list();
1015: ruleObject ame_rule;
1016: effectiveRuleDate date;
1017: effecitveRuleDateString ame_util.stringType;
1018: itemClassName varchar2(100);
1019: begin

Line 1055: ruleObject := ame_rule(ruleIds(i)

1051: itemClassName := ame_test_utility_pkg.getItemClassNameById(ruleItemClassIds(i));
1052: else
1053: itemClassName := null;
1054: end if;
1055: ruleObject := ame_rule(ruleIds(i)
1056: ,ruleDescriptions(i)
1057: ,ruleItemClassIds(i)
1058: ,itemClassName
1059: ,itemIds(i)

Line 1063: ,ame_rule_pkg.getEffectiveStartDateUsage

1059: ,itemIds(i)
1060: ,getRuleTypeDesc(ruleTypes(i))
1061: ,ruleTypes(i)
1062: ,getRuleCategory(ruleIds(i),applicationIdIn,effectiveRuleDate)
1063: ,ame_rule_pkg.getEffectiveStartDateUsage
1064: (applicationIdIn => applicationIdIn
1065: ,ruleIdIn => ruleIds(i)
1066: ,effectiveDateIn => effectiveRuleDate)
1067: ,ame_rule_pkg.getEffectiveEndDateUsage

Line 1067: ,ame_rule_pkg.getEffectiveEndDateUsage

1063: ,ame_rule_pkg.getEffectiveStartDateUsage
1064: (applicationIdIn => applicationIdIn
1065: ,ruleIdIn => ruleIds(i)
1066: ,effectiveDateIn => effectiveRuleDate)
1067: ,ame_rule_pkg.getEffectiveEndDateUsage
1068: (applicationIdIn => applicationIdIn
1069: ,ruleIdIn => ruleIds(i)
1070: ,effectiveDateIn => effectiveRuleDate)
1071: ,getConditionsList(ruleIds(i),effectiveRuleDate)