[Home] [Help]
69: ,endDateIn in date)return boolean is
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
95: --+
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
229: cursor checkActionTypes(ruleIdIn in integer
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
252: ,applicationIdIn in integer
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
581: --+
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
608: --+
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
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
903: and acu.rule_id = rul.rule_id
904: and acu.end_date = rul.end_date
1201: --+
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
1234: --+
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
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
1654: and act.action_type_id = atf.action_type_id
1655: and act.action_type_id = aty.action_type_id
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
1671: and act.action_type_id = atf.action_type_id
1672: and act.action_type_id = aty.action_type_id
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
1687: and act.action_type_id = atf.action_type_id
1688: and aty.action_type_id = act.action_type_id
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)
2110: and sysdate between aty.start_date and nvl(aty.end_date - (1/86400),sysdate);
2110: and sysdate between aty.start_date and nvl(aty.end_date - (1/86400),sysdate);
2111: --+
2112: l_param ame_conditions.parameter_one%type;
2113: l_param_two ame_conditions.parameter_two%type;
2114: l_action_type ame_action_types.name%type;
2115: --+
2116: begin
2117: open getConditionParam(p_condition_id => p_condition_id);
2118: fetch getConditionParam
2358: --+
2359: function chk_lm_actions(p_rule_id in integer
2360: ,p_action_id in integer) return boolean is
2361: l_count number(2);
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
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)
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'
2380: and acu.action_id = act.action_id
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'
2399: and acu.action_id = act.action_id