[Home] [Help]
71: cursor getActions(ruleIdIn in integer) is
72: select 'Y'
73: from ame_action_types aty
74: ,ame_actions act
75: ,ame_action_usages acu
76: ,ame_rules rul
77: ,ame_action_type_usages axu
78: where rul.rule_id = ruleIdIn
79: and rul.rule_id = acu.rule_id
97: ,endDateIn in date) is
98: select 'Y'
99: from ame_action_types aty
100: ,ame_actions act
101: ,ame_action_usages acu
102: ,ame_rules rul
103: ,ame_action_type_usages axu
104: where rul.rule_id = ruleIdIn
105: and rul.rule_id = acu.rule_id
172: and condu.end_date = rules.end_date
173: union
174: select distinct atr.attribute_id, atr.name
175: from ame_attributes atr
176: ,ame_action_usages acu
177: ,ame_actions act
178: ,ame_mandatory_attributes ama
179: ,ame_rules rules
180: where ama.attribute_id = atr.attribute_id
231: ,endDateIn in date) is
232: select distinct aty.action_type_id, aty.name
233: from ame_action_types aty
234: ,ame_actions act
235: ,ame_action_usages acu
236: ,ame_rules rul
237: where rul.rule_id = ruleIdIn
238: and rul.rule_id = acu.rule_id
239: and acu.action_id = act.action_id
254: select apg.approval_group_id
255: ,apg.name
256: from ame_action_types aty
257: ,ame_actions act
258: ,ame_action_usages acu
259: ,ame_rules rul
260: ,ame_approval_groups apg
261: where rul.rule_id = ruleIdIn
262: and rul.end_date = endDateIn
514: )
515: union
516: select distinct atr.attribute_id, atr.name
517: from ame_attributes atr
518: ,ame_action_usages acu
519: ,ame_actions act
520: ,ame_mandatory_attributes ama
521: ,ame_rules rules
522: where ama.attribute_id = atr.attribute_id
583: ,applicationIdIn in integer) is
584: select distinct aty.action_type_id, aty.name
585: from ame_action_types aty
586: ,ame_actions act
587: ,ame_action_usages acu
588: ,ame_rules rul
589: where rul.rule_id = ruleIdIn
590: and rul.rule_id = acu.rule_id
591: and acu.action_id = act.action_id
610: ,applicationIdIn in integer) is
611: select apg.approval_group_id, apg.name
612: from ame_action_types aty
613: ,ame_actions act
614: ,ame_action_usages acu
615: ,ame_rules rul
616: ,ame_approval_groups apg
617: where rul.rule_id = ruleIdIn
618: and ((sysdate between rul.start_date and nvl(rul.end_date - (1/86400),sysdate))
869: --+
870: cursor getActions(ruleIdIn in integer
871: ,endDateIn in date) is
872: select count(*)
873: from ame_action_usages acu
874: ,ame_rules rul
875: where rul.rule_id = ruleIdIn
876: and rul.end_date = endDateIn
877: and acu.rule_id = rul.rule_id
881: ,endDateIn in date
882: ) is
883: select count(*)
884: from ame_actions act
885: ,ame_action_usages acu
886: ,ame_rules rul
887: where rul.rule_id = ruleIdIn
888: and rul.end_date = endDateIn
889: and acu.rule_id = rul.rule_id
894: cursor checkActionTypes(ruleIdIn in integer
895: ,endDateIn in date) is
896: select 'Y'
897: from ame_actions act
898: ,ame_action_usages acu
899: ,ame_rules rul
900: ,ame_action_types aty
901: where rul.rule_id = ruleIdIn
902: and rul.end_date = endDateIn
1001: --+
1002: cursor getACtions(ruleIdIn in integer
1003: ,endDateIn in date)is
1004: select action_id,created_by,creation_date
1005: from ame_action_usages
1006: where rule_id = ruleIdIn
1007: and end_date = endDateIn;
1008: --+
1009: tempOVN integer;
1068: ,1);
1069: end loop;
1070: --+ actions
1071: for actionRec in getActions(ruleIdIn,ruleEndDateIn) loop
1072: insert into ame_action_usages
1073: (rule_id
1074: ,action_id
1075: ,created_by
1076: ,creation_date
1379: select action_id
1380: ,start_date
1381: ,end_date
1382: ,object_version_number
1383: from ame_action_usages
1384: where rule_id = p_rule_id
1385: and ((l_effective_date between start_date
1386: and nvl(end_date - ame_util.oneSecond, l_effective_date))
1387: or
1756: ,p_rule_id in integer) return number is
1757: --+
1758: cursor getRuleActions(p_rule_id in integer) is
1759: select acu.action_id
1760: from ame_action_usages acu
1761: ,ame_rules rul
1762: where rul.rule_id = acu.rule_id
1763: and rul.rule_id = p_rule_id
1764: and ((sysdate between rul.start_date and nvl(rul.end_date - (1/86400),sysdate))
2045: cursor getNonProdActionCnt(p_rule_id in integer
2046: ,p_action_id in integer) is
2047: select count(*)
2048: from ame_rules rul
2049: ,ame_action_usages acu
2050: ,ame_action_type_usages atyu
2051: ,ame_actions act
2052: where act.action_id <> p_action_id
2053: and rul.rule_id = p_rule_id
2371: and sysdate between aty.start_date and nvl(aty.end_date - (1/86400),sysdate);
2372: if l_aty_name = 'final authority' then
2373: select count(*)
2374: into l_count
2375: from ame_action_usages acu
2376: ,ame_action_types aty
2377: ,ame_actions act
2378: where acu.rule_id = p_rule_id
2379: and aty.name = 'nonfinal authority'
2390: end if;
2391: elsif l_aty_name = 'nonfinal authority' then
2392: select count(*)
2393: into l_count
2394: from ame_action_usages acu
2395: ,ame_action_types aty
2396: ,ame_actions act
2397: where acu.rule_id = p_rule_id
2398: and aty.name = 'final authority'