DBA Data[Home] [Help]

APPS.AME_ATTRIBUTE_PKG dependencies on AME_RULE_USAGES

Line 66: from ame_rule_usages

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

Line 68: ame_rule_usages.item_id = applicationIdIn and

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,

Line 69: ((sysdate between ame_rule_usages.start_date and

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

Line 70: nvl(ame_rule_usages.end_date - ame_util.oneSecond, sysdate)) or

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;

Line 71: (sysdate < ame_rule_usages.start_date and

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;

Line 72: ame_rule_usages.start_date < nvl(ame_rule_usages.end_date,

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;

Line 73: ame_rule_usages.start_date + ame_util.oneSecond)));

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

Line 93: from ame_rule_usages

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

Line 95: ame_rule_usages.item_id = applicationIdIn and

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;

Line 96: (ame_rule_usages.start_date <= sysdate and

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: */

Line 97: (ame_rule_usages.end_date is null or sysdate < ame_rule_usages.end_date));

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;

Line 3690: select distinct ame_rule_usages.item_id

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

Line 3693: ame_rule_usages

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

Line 3696: ame_action_usages.rule_id = ame_rule_usages.rule_id 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

Line 3705: ((sysdate between ame_rule_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)));

Line 3706: nvl(ame_rule_usages.end_date - ame_util.oneSecond, sysdate)) or

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

Line 3707: (sysdate < ame_rule_usages.start_date 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
3711: select application_id

Line 3708: ame_rule_usages.start_date < nvl(ame_rule_usages.end_date,

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

Line 3709: ame_rule_usages.start_date + ame_util.oneSecond)));

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