eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AME_ATTRIBUTE_PKG dependencies on AME_ACTION_USAGES

Line 127: ame_action_usages

123: into tempCount
124: from
125: ame_mandatory_attributes,
126: ame_actions,
127: ame_action_usages
128: where
129: ame_mandatory_attributes.attribute_id = attributeIdIn and
130: ame_mandatory_attributes.action_type_id = ame_actions.action_type_id and
131: ame_actions.action_id = ame_action_usages.action_id and

Line 131: ame_actions.action_id = ame_action_usages.action_id and

127: ame_action_usages
128: where
129: ame_mandatory_attributes.attribute_id = attributeIdIn and
130: ame_mandatory_attributes.action_type_id = ame_actions.action_type_id and
131: ame_actions.action_id = ame_action_usages.action_id and
132: ame_action_usages.rule_id = tempRule.rule_id and
133: sysdate between ame_mandatory_attributes.start_date and
134: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate) and
135: sysdate between ame_actions.start_date and

Line 132: ame_action_usages.rule_id = tempRule.rule_id and

128: where
129: ame_mandatory_attributes.attribute_id = attributeIdIn and
130: ame_mandatory_attributes.action_type_id = ame_actions.action_type_id and
131: ame_actions.action_id = ame_action_usages.action_id and
132: ame_action_usages.rule_id = tempRule.rule_id and
133: sysdate between ame_mandatory_attributes.start_date and
134: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate) and
135: sysdate between ame_actions.start_date and
136: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate) and

Line 137: ((sysdate between ame_action_usages.start_date and

133: sysdate between ame_mandatory_attributes.start_date and
134: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate) and
135: sysdate between ame_actions.start_date and
136: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate) and
137: ((sysdate between ame_action_usages.start_date and
138: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate)) or
139: (sysdate < ame_action_usages.start_date and
140: ame_action_usages.start_date < nvl(ame_action_usages.end_date,
141: ame_action_usages.start_date + ame_util.oneSecond)));

Line 138: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate)) or

134: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate) and
135: sysdate between ame_actions.start_date and
136: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate) and
137: ((sysdate between ame_action_usages.start_date and
138: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate)) or
139: (sysdate < ame_action_usages.start_date and
140: ame_action_usages.start_date < nvl(ame_action_usages.end_date,
141: ame_action_usages.start_date + ame_util.oneSecond)));
142: if(tempCount > 0) then

Line 139: (sysdate < ame_action_usages.start_date and

135: sysdate between ame_actions.start_date and
136: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate) and
137: ((sysdate between ame_action_usages.start_date and
138: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate)) or
139: (sysdate < ame_action_usages.start_date and
140: ame_action_usages.start_date < nvl(ame_action_usages.end_date,
141: ame_action_usages.start_date + ame_util.oneSecond)));
142: if(tempCount > 0) then
143: useCount := useCount + 1;

Line 140: ame_action_usages.start_date < nvl(ame_action_usages.end_date,

136: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate) and
137: ((sysdate between ame_action_usages.start_date and
138: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate)) or
139: (sysdate < ame_action_usages.start_date and
140: ame_action_usages.start_date < nvl(ame_action_usages.end_date,
141: ame_action_usages.start_date + ame_util.oneSecond)));
142: if(tempCount > 0) then
143: useCount := useCount + 1;
144: end if;

Line 141: ame_action_usages.start_date + ame_util.oneSecond)));

137: ((sysdate between ame_action_usages.start_date and
138: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate)) or
139: (sysdate < ame_action_usages.start_date and
140: ame_action_usages.start_date < nvl(ame_action_usages.end_date,
141: ame_action_usages.start_date + ame_util.oneSecond)));
142: if(tempCount > 0) then
143: useCount := useCount + 1;
144: end if;
145: end if;

Line 3691: from ame_action_usages,

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
3695: ame_action_usages.action_id = ame_actions.action_id and

Line 3695: ame_action_usages.action_id = ame_actions.action_id and

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
3698: ((sysdate between ame_action_usages.start_date and
3699: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate)) or

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 3698: ((sysdate between ame_action_usages.start_date and

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

Line 3699: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate)) or

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

Line 3700: (sysdate < ame_action_usages.start_date 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

Line 3701: ame_action_usages.start_date < nvl(ame_action_usages.end_date,

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

Line 3702: ame_action_usages.start_date + ame_util.oneSecond))) 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