[Home] [Help]
27: dummy number;
28: --+
29: begin
30: select axu.rule_type into dummy
31: from ame_actions act
32: ,ame_action_type_usages axu
33: where act.action_id = actionIdIn
34: and act.action_type_id = axu.action_type_id
35: and sysdate between act.start_date and nvl(act.end_date - (1/86400), sysdate)
70: --+
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
96: cursor getActions2(ruleIdIn in integer
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
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
181: and act.action_id = acu.action_id
230: ,applicationIdIn in integer
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
253: ,endDateIn in date) is
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
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
523: and act.action_id = acu.action_id
582: cursor checkActionTypes(ruleIdIn in integer
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
609: cursor checkApproverGroups(ruleIdIn in integer
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
880: cursor checkActions(ruleIdIn in integer
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
893: --+
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
1202: cursor getInvalidActionTypes(applicationIdIn in integer
1203: ,actionIdIn in integer) is
1204: select aty.action_type_id, aty.name
1205: from ame_action_types aty
1206: ,ame_actions act
1207: where act.action_id = actionIdIn
1208: and act.action_type_id = aty.action_type_id
1209: and aty.action_type_id not in (select atf.action_type_id
1210: from ame_action_type_config atf
1218: ,actionIdIn in integer) is
1219: select distinct atr.attribute_id, atr.name
1220: from ame_attributes atr
1221: ,ame_mandatory_attributes man
1222: ,ame_actions act
1223: where act.action_id = actionIdIn
1224: and act.action_type_id = man.action_type_id
1225: and atr.attribute_id = man.attribute_id
1226: and atr.attribute_id not in (select attribute_id
1235: cursor getInvalidGroups(applicationIdIn in integer
1236: ,actionIdIn in integer) is
1237: select apg.approval_group_id, apg.name
1238: from ame_action_types aty
1239: ,ame_actions act
1240: ,ame_approval_groups apg
1241: where act.action_id = actionIdIn
1242: and act.action_type_id = aty.action_type_id
1243: and act.parameter = to_char(apg.approval_group_id)
1546: procedure checkActionId(p_action_id in number) is
1547: --+
1548: cursor checkAction(p_action_id in number) is
1549: select count(*)
1550: from ame_actions
1551: where action_id = p_action_id
1552: and sysdate between start_date and nvl(end_date - (1/86400),sysdate);
1553: l_count number(3);
1554: --+
1645: --+ get All non-group actions.
1646: cursor getActions(p_application_id in integer
1647: ,p_action_id in integer) is
1648: select count(act.action_id)
1649: from ame_actions act
1650: ,ame_action_type_config atf
1651: ,ame_action_types aty
1652: where act.action_id = p_action_id
1653: and atf.application_id = p_application_id
1662: --+ get all position actions.
1663: cursor getPosActions(p_application_id in integer
1664: ,p_action_id in integer) is
1665: select count(*)
1666: from ame_actions act
1667: ,ame_action_type_config atf
1668: ,ame_action_types aty
1669: where act.action_id = p_action_id
1670: and atf.application_id = p_application_id
1678: --+ get all group actions.
1679: cursor getGroupActions(p_application_id in integer
1680: ,p_action_id in integer) is
1681: select act.parameter
1682: from ame_actions act
1683: ,ame_action_type_config atf
1684: ,ame_action_types aty
1685: where act.action_id = p_action_id
1686: and atf.application_id = p_application_id
1692: and aty.name in ('approval-group chain of authority'
1693: ,'pre-chain-of-authority approvals'
1694: ,'post-chain-of-authority approvals');
1695: --+
1696: l_group_param ame_actions.parameter%type;
1697: l_count number(3);
1698: l_pos_count number(3);
1699: --+
1700: begin
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
2054: and rul.rule_id = acu.rule_id
2055: and acu.action_id = act.action_id
2101: and sysdate between start_date and nvl(end_date - (1/86400),sysdate);
2102: --+
2103: cursor getActionType(p_action_id in integer) is
2104: select aty.name
2105: from ame_actions act
2106: ,ame_action_types aty
2107: where act.action_id = p_action_id
2108: and aty.action_type_id = act.action_type_id
2109: and sysdate between act.start_date and nvl(act.end_date - (1/86400),sysdate)
2362: l_aty_name ame_action_types.name%type;
2363: begin
2364: select aty.name
2365: into l_aty_name
2366: from ame_actions act
2367: ,ame_action_types aty
2368: where act.action_id = p_action_id
2369: and act.action_type_id = aty.action_type_id
2370: and sysdate between act.start_date and nvl(act.end_date - (1/86400),sysdate)
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'
2380: and acu.action_id = act.action_id
2381: and act.action_type_id = aty.action_type_id
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'
2399: and acu.action_id = act.action_id
2400: and act.action_type_id = aty.action_type_id