APPS.AME_TEST_UTILITY_PKG dependencies on AME_RULES

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 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);