62: function calculateUseCount(attributeIdIn in integer,
63: applicationIdIn in integer) return integer as
64: cursor ruleCursor(applicationIdIn in integer) is
65: select rule_id
66: from ame_rule_usages
67: where
68: ame_rule_usages.item_id = applicationIdIn and
69: ((sysdate between ame_rule_usages.start_date and
70: nvl(ame_rule_usages.end_date - ame_util.oneSecond, sysdate)) or
64: cursor ruleCursor(applicationIdIn in integer) is
65: select rule_id
66: from ame_rule_usages
67: where
68: ame_rule_usages.item_id = applicationIdIn and
69: ((sysdate between ame_rule_usages.start_date and
70: nvl(ame_rule_usages.end_date - ame_util.oneSecond, sysdate)) or
71: (sysdate < ame_rule_usages.start_date and
72: ame_rule_usages.start_date < nvl(ame_rule_usages.end_date,
65: select rule_id
66: from ame_rule_usages
67: where
68: ame_rule_usages.item_id = applicationIdIn and
69: ((sysdate between ame_rule_usages.start_date and
70: nvl(ame_rule_usages.end_date - ame_util.oneSecond, sysdate)) or
71: (sysdate < ame_rule_usages.start_date and
72: ame_rule_usages.start_date < nvl(ame_rule_usages.end_date,
73: ame_rule_usages.start_date + ame_util.oneSecond)));
66: from ame_rule_usages
67: where
68: ame_rule_usages.item_id = applicationIdIn and
69: ((sysdate between ame_rule_usages.start_date and
70: nvl(ame_rule_usages.end_date - ame_util.oneSecond, sysdate)) or
71: (sysdate < ame_rule_usages.start_date and
72: ame_rule_usages.start_date < nvl(ame_rule_usages.end_date,
73: ame_rule_usages.start_date + ame_util.oneSecond)));
74: ruleCount integer;
67: where
68: ame_rule_usages.item_id = applicationIdIn and
69: ((sysdate between ame_rule_usages.start_date and
70: nvl(ame_rule_usages.end_date - ame_util.oneSecond, sysdate)) or
71: (sysdate < ame_rule_usages.start_date and
72: ame_rule_usages.start_date < nvl(ame_rule_usages.end_date,
73: ame_rule_usages.start_date + ame_util.oneSecond)));
74: ruleCount integer;
75: tempCount integer;
68: ame_rule_usages.item_id = applicationIdIn and
69: ((sysdate between ame_rule_usages.start_date and
70: nvl(ame_rule_usages.end_date - ame_util.oneSecond, sysdate)) or
71: (sysdate < ame_rule_usages.start_date and
72: ame_rule_usages.start_date < nvl(ame_rule_usages.end_date,
73: ame_rule_usages.start_date + ame_util.oneSecond)));
74: ruleCount integer;
75: tempCount integer;
76: useCount integer;
69: ((sysdate between ame_rule_usages.start_date and
70: nvl(ame_rule_usages.end_date - ame_util.oneSecond, sysdate)) or
71: (sysdate < ame_rule_usages.start_date and
72: ame_rule_usages.start_date < nvl(ame_rule_usages.end_date,
73: ame_rule_usages.start_date + ame_util.oneSecond)));
74: ruleCount integer;
75: tempCount integer;
76: useCount integer;
77: begin
89: isBecomingStripingAttributeIn = ame_util.booleanTrue) and
90: isStripingAttributeChangeIn = ame_util.booleanFalse) then
91: select count(*)
92: into ruleCount
93: from ame_rule_usages
94: where
95: ame_rule_usages.item_id = applicationIdIn and
96: (ame_rule_usages.start_date <= sysdate and
97: (ame_rule_usages.end_date is null or sysdate < ame_rule_usages.end_date));
91: select count(*)
92: into ruleCount
93: from ame_rule_usages
94: where
95: ame_rule_usages.item_id = applicationIdIn and
96: (ame_rule_usages.start_date <= sysdate and
97: (ame_rule_usages.end_date is null or sysdate < ame_rule_usages.end_date));
98: return(ruleCount);
99: end if;
92: into ruleCount
93: from ame_rule_usages
94: where
95: ame_rule_usages.item_id = applicationIdIn and
96: (ame_rule_usages.start_date <= sysdate and
97: (ame_rule_usages.end_date is null or sysdate < ame_rule_usages.end_date));
98: return(ruleCount);
99: end if;
100: */
93: from ame_rule_usages
94: where
95: ame_rule_usages.item_id = applicationIdIn and
96: (ame_rule_usages.start_date <= sysdate and
97: (ame_rule_usages.end_date is null or sysdate < ame_rule_usages.end_date));
98: return(ruleCount);
99: end if;
100: */
101: useCount := 0;
3686: /* select every application having a rule that uses the approval type */
3687: cursor getApplicationId (actionTypeIdIn in integer) is
3688: /* the distinct is necessary because of the possibility that multiple rules
3689: within an application will use the specified approval type */
3690: select distinct ame_rule_usages.item_id
3691: from ame_action_usages,
3692: ame_actions,
3693: ame_rule_usages
3694: where
3689: within an application will use the specified approval type */
3690: select distinct ame_rule_usages.item_id
3691: from ame_action_usages,
3692: ame_actions,
3693: ame_rule_usages
3694: where
3695: ame_action_usages.action_id = ame_actions.action_id and
3696: ame_action_usages.rule_id = ame_rule_usages.rule_id and
3697: ame_actions.action_type_id = actionTypeIdIn and
3692: ame_actions,
3693: ame_rule_usages
3694: where
3695: ame_action_usages.action_id = ame_actions.action_id and
3696: ame_action_usages.rule_id = ame_rule_usages.rule_id and
3697: ame_actions.action_type_id = actionTypeIdIn and
3698: ((sysdate between ame_action_usages.start_date and
3699: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate)) or
3700: (sysdate < ame_action_usages.start_date and
3701: ame_action_usages.start_date < nvl(ame_action_usages.end_date,
3702: ame_action_usages.start_date + ame_util.oneSecond))) and
3703: ( sysdate between ame_actions.start_date and
3704: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate) ) and
3705: ((sysdate between ame_rule_usages.start_date and
3706: nvl(ame_rule_usages.end_date - ame_util.oneSecond, sysdate)) or
3707: (sysdate < ame_rule_usages.start_date and
3708: ame_rule_usages.start_date < nvl(ame_rule_usages.end_date,
3709: ame_rule_usages.start_date + ame_util.oneSecond)));
3702: ame_action_usages.start_date + ame_util.oneSecond))) and
3703: ( sysdate between ame_actions.start_date and
3704: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate) ) and
3705: ((sysdate between ame_rule_usages.start_date and
3706: nvl(ame_rule_usages.end_date - ame_util.oneSecond, sysdate)) or
3707: (sysdate < ame_rule_usages.start_date and
3708: ame_rule_usages.start_date < nvl(ame_rule_usages.end_date,
3709: ame_rule_usages.start_date + ame_util.oneSecond)));
3710: cursor applicationCursor(attributeIdIn in integer) is
3703: ( sysdate between ame_actions.start_date and
3704: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate) ) and
3705: ((sysdate between ame_rule_usages.start_date and
3706: nvl(ame_rule_usages.end_date - ame_util.oneSecond, sysdate)) or
3707: (sysdate < ame_rule_usages.start_date and
3708: ame_rule_usages.start_date < nvl(ame_rule_usages.end_date,
3709: ame_rule_usages.start_date + ame_util.oneSecond)));
3710: cursor applicationCursor(attributeIdIn in integer) is
3711: select application_id
3704: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate) ) and
3705: ((sysdate between ame_rule_usages.start_date and
3706: nvl(ame_rule_usages.end_date - ame_util.oneSecond, sysdate)) or
3707: (sysdate < ame_rule_usages.start_date and
3708: ame_rule_usages.start_date < nvl(ame_rule_usages.end_date,
3709: ame_rule_usages.start_date + ame_util.oneSecond)));
3710: cursor applicationCursor(attributeIdIn in integer) is
3711: select application_id
3712: from ame_attribute_usages
3705: ((sysdate between ame_rule_usages.start_date and
3706: nvl(ame_rule_usages.end_date - ame_util.oneSecond, sysdate)) or
3707: (sysdate < ame_rule_usages.start_date and
3708: ame_rule_usages.start_date < nvl(ame_rule_usages.end_date,
3709: ame_rule_usages.start_date + ame_util.oneSecond)));
3710: cursor applicationCursor(attributeIdIn in integer) is
3711: select application_id
3712: from ame_attribute_usages
3713: where