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_RULE_USAGES_API dependencies on AME_ACTION_USAGES

Line 110: -- action_id is already migrated from ame_rules to ame_action_usages

106: if(TEMP_COUNT > 0) then
107: NEW_USE_COUNT := NEW_USE_COUNT + 1;
108: else
109: if(TEMPRULE.ACTION_ID is null) then
110: -- action_id is already migrated from ame_rules to ame_action_usages
111: select count(*)
112: into TEMP_COUNT
113: from
114: AME_MANDATORY_ATTRIBUTES,

Line 116: AME_ACTION_USAGES

112: into TEMP_COUNT
113: from
114: AME_MANDATORY_ATTRIBUTES,
115: AME_ACTIONS,
116: AME_ACTION_USAGES
117: where
118: AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID = X_ATTRIBUTE_ID and
119: AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID = AME_ACTIONS.ACTION_TYPE_ID and
120: AME_ACTIONS.ACTION_ID = AME_ACTION_USAGES.ACTION_ID and

Line 120: AME_ACTIONS.ACTION_ID = AME_ACTION_USAGES.ACTION_ID and

116: AME_ACTION_USAGES
117: where
118: AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID = X_ATTRIBUTE_ID and
119: AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID = AME_ACTIONS.ACTION_TYPE_ID and
120: AME_ACTIONS.ACTION_ID = AME_ACTION_USAGES.ACTION_ID and
121: AME_ACTION_USAGES.RULE_ID = TEMPRULE.RULE_ID and
122: sysdate between AME_MANDATORY_ATTRIBUTES.START_DATE and
123: nvl(AME_MANDATORY_ATTRIBUTES.END_DATE - (1/86400), sysdate) and
124: sysdate between AME_ACTIONS.START_DATE and

Line 121: AME_ACTION_USAGES.RULE_ID = TEMPRULE.RULE_ID and

117: where
118: AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID = X_ATTRIBUTE_ID and
119: AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID = AME_ACTIONS.ACTION_TYPE_ID and
120: AME_ACTIONS.ACTION_ID = AME_ACTION_USAGES.ACTION_ID and
121: AME_ACTION_USAGES.RULE_ID = TEMPRULE.RULE_ID and
122: sysdate between AME_MANDATORY_ATTRIBUTES.START_DATE and
123: nvl(AME_MANDATORY_ATTRIBUTES.END_DATE - (1/86400), sysdate) and
124: sysdate between AME_ACTIONS.START_DATE and
125: nvl(AME_ACTIONS.END_DATE - (1/86400), sysdate) and

Line 126: ((sysdate between AME_ACTION_USAGES.START_DATE and

122: sysdate between AME_MANDATORY_ATTRIBUTES.START_DATE and
123: nvl(AME_MANDATORY_ATTRIBUTES.END_DATE - (1/86400), sysdate) and
124: sysdate between AME_ACTIONS.START_DATE and
125: nvl(AME_ACTIONS.END_DATE - (1/86400), sysdate) and
126: ((sysdate between AME_ACTION_USAGES.START_DATE and
127: nvl(AME_ACTION_USAGES.END_DATE - (1/86400), sysdate)) or
128: (sysdate < AME_ACTION_USAGES.START_DATE and
129: AME_ACTION_USAGES.START_DATE < nvl(AME_ACTION_USAGES.END_DATE,
130: AME_ACTION_USAGES.START_DATE + (1/86400))));

Line 127: nvl(AME_ACTION_USAGES.END_DATE - (1/86400), sysdate)) or

123: nvl(AME_MANDATORY_ATTRIBUTES.END_DATE - (1/86400), sysdate) and
124: sysdate between AME_ACTIONS.START_DATE and
125: nvl(AME_ACTIONS.END_DATE - (1/86400), sysdate) and
126: ((sysdate between AME_ACTION_USAGES.START_DATE and
127: nvl(AME_ACTION_USAGES.END_DATE - (1/86400), sysdate)) or
128: (sysdate < AME_ACTION_USAGES.START_DATE and
129: AME_ACTION_USAGES.START_DATE < nvl(AME_ACTION_USAGES.END_DATE,
130: AME_ACTION_USAGES.START_DATE + (1/86400))));
131: else

Line 128: (sysdate < AME_ACTION_USAGES.START_DATE and

124: sysdate between AME_ACTIONS.START_DATE and
125: nvl(AME_ACTIONS.END_DATE - (1/86400), sysdate) and
126: ((sysdate between AME_ACTION_USAGES.START_DATE and
127: nvl(AME_ACTION_USAGES.END_DATE - (1/86400), sysdate)) or
128: (sysdate < AME_ACTION_USAGES.START_DATE and
129: AME_ACTION_USAGES.START_DATE < nvl(AME_ACTION_USAGES.END_DATE,
130: AME_ACTION_USAGES.START_DATE + (1/86400))));
131: else
132: select count(*)

Line 129: AME_ACTION_USAGES.START_DATE < nvl(AME_ACTION_USAGES.END_DATE,

125: nvl(AME_ACTIONS.END_DATE - (1/86400), sysdate) and
126: ((sysdate between AME_ACTION_USAGES.START_DATE and
127: nvl(AME_ACTION_USAGES.END_DATE - (1/86400), sysdate)) or
128: (sysdate < AME_ACTION_USAGES.START_DATE and
129: AME_ACTION_USAGES.START_DATE < nvl(AME_ACTION_USAGES.END_DATE,
130: AME_ACTION_USAGES.START_DATE + (1/86400))));
131: else
132: select count(*)
133: into TEMP_COUNT

Line 130: AME_ACTION_USAGES.START_DATE + (1/86400))));

126: ((sysdate between AME_ACTION_USAGES.START_DATE and
127: nvl(AME_ACTION_USAGES.END_DATE - (1/86400), sysdate)) or
128: (sysdate < AME_ACTION_USAGES.START_DATE and
129: AME_ACTION_USAGES.START_DATE < nvl(AME_ACTION_USAGES.END_DATE,
130: AME_ACTION_USAGES.START_DATE + (1/86400))));
131: else
132: select count(*)
133: into TEMP_COUNT
134: from

Line 190: AME_ACTION_USAGES,

186: AME_CONDITION_USAGES.START_DATE + (1/86400))))
187: union
188: select AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID
189: from AME_MANDATORY_ATTRIBUTES,
190: AME_ACTION_USAGES,
191: AME_ACTIONS
192: where
193: AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID = AME_ACTIONS.ACTION_TYPE_ID and
194: AME_ACTIONS.ACTION_ID = AME_ACTION_USAGES.ACTION_ID and

Line 194: AME_ACTIONS.ACTION_ID = AME_ACTION_USAGES.ACTION_ID and

190: AME_ACTION_USAGES,
191: AME_ACTIONS
192: where
193: AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID = AME_ACTIONS.ACTION_TYPE_ID and
194: AME_ACTIONS.ACTION_ID = AME_ACTION_USAGES.ACTION_ID and
195: AME_ACTION_USAGES.RULE_ID = X_RULE_ID and
196: (AME_MANDATORY_ATTRIBUTES.START_DATE <= sysdate and
197: (AME_MANDATORY_ATTRIBUTES.END_DATE is null or sysdate < AME_MANDATORY_ATTRIBUTES.END_DATE)) and
198: ((sysdate between AME_ACTION_USAGES.START_DATE and

Line 195: AME_ACTION_USAGES.RULE_ID = X_RULE_ID and

191: AME_ACTIONS
192: where
193: AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID = AME_ACTIONS.ACTION_TYPE_ID and
194: AME_ACTIONS.ACTION_ID = AME_ACTION_USAGES.ACTION_ID and
195: AME_ACTION_USAGES.RULE_ID = X_RULE_ID and
196: (AME_MANDATORY_ATTRIBUTES.START_DATE <= sysdate and
197: (AME_MANDATORY_ATTRIBUTES.END_DATE is null or sysdate < AME_MANDATORY_ATTRIBUTES.END_DATE)) and
198: ((sysdate between AME_ACTION_USAGES.START_DATE and
199: nvl(AME_ACTION_USAGES.END_DATE - (1/86400), sysdate)) or

Line 198: ((sysdate between AME_ACTION_USAGES.START_DATE and

194: AME_ACTIONS.ACTION_ID = AME_ACTION_USAGES.ACTION_ID and
195: AME_ACTION_USAGES.RULE_ID = X_RULE_ID and
196: (AME_MANDATORY_ATTRIBUTES.START_DATE <= sysdate and
197: (AME_MANDATORY_ATTRIBUTES.END_DATE is null or sysdate < AME_MANDATORY_ATTRIBUTES.END_DATE)) and
198: ((sysdate between AME_ACTION_USAGES.START_DATE and
199: nvl(AME_ACTION_USAGES.END_DATE - (1/86400), sysdate)) or
200: (sysdate < AME_ACTION_USAGES.START_DATE and
201: AME_ACTION_USAGES.START_DATE < nvl(AME_ACTION_USAGES.END_DATE,AME_ACTION_USAGES.START_DATE
202: + (1/86400)))) and

Line 199: nvl(AME_ACTION_USAGES.END_DATE - (1/86400), sysdate)) or

195: AME_ACTION_USAGES.RULE_ID = X_RULE_ID and
196: (AME_MANDATORY_ATTRIBUTES.START_DATE <= sysdate and
197: (AME_MANDATORY_ATTRIBUTES.END_DATE is null or sysdate < AME_MANDATORY_ATTRIBUTES.END_DATE)) and
198: ((sysdate between AME_ACTION_USAGES.START_DATE and
199: nvl(AME_ACTION_USAGES.END_DATE - (1/86400), sysdate)) or
200: (sysdate < AME_ACTION_USAGES.START_DATE and
201: AME_ACTION_USAGES.START_DATE < nvl(AME_ACTION_USAGES.END_DATE,AME_ACTION_USAGES.START_DATE
202: + (1/86400)))) and
203: (AME_ACTIONS.START_DATE <= sysdate and

Line 200: (sysdate < AME_ACTION_USAGES.START_DATE and

196: (AME_MANDATORY_ATTRIBUTES.START_DATE <= sysdate and
197: (AME_MANDATORY_ATTRIBUTES.END_DATE is null or sysdate < AME_MANDATORY_ATTRIBUTES.END_DATE)) and
198: ((sysdate between AME_ACTION_USAGES.START_DATE and
199: nvl(AME_ACTION_USAGES.END_DATE - (1/86400), sysdate)) or
200: (sysdate < AME_ACTION_USAGES.START_DATE and
201: AME_ACTION_USAGES.START_DATE < nvl(AME_ACTION_USAGES.END_DATE,AME_ACTION_USAGES.START_DATE
202: + (1/86400)))) and
203: (AME_ACTIONS.START_DATE <= sysdate and
204: (AME_ACTIONS.END_DATE is null or sysdate < AME_ACTIONS.END_DATE))

Line 201: AME_ACTION_USAGES.START_DATE < nvl(AME_ACTION_USAGES.END_DATE,AME_ACTION_USAGES.START_DATE

197: (AME_MANDATORY_ATTRIBUTES.END_DATE is null or sysdate < AME_MANDATORY_ATTRIBUTES.END_DATE)) and
198: ((sysdate between AME_ACTION_USAGES.START_DATE and
199: nvl(AME_ACTION_USAGES.END_DATE - (1/86400), sysdate)) or
200: (sysdate < AME_ACTION_USAGES.START_DATE and
201: AME_ACTION_USAGES.START_DATE < nvl(AME_ACTION_USAGES.END_DATE,AME_ACTION_USAGES.START_DATE
202: + (1/86400)))) and
203: (AME_ACTIONS.START_DATE <= sysdate and
204: (AME_ACTIONS.END_DATE is null or sysdate < AME_ACTIONS.END_DATE))
205: union

Line 307: ame_action_usages aau,

303: aa.action_type_id,
304: aat.name,
305: aa.parameter
306: from ame_rule_usages aru,
307: ame_action_usages aau,
308: ame_actions aa,
309: ame_action_types aat
310: where aru.rule_id = x_rule_id
311: and aru.item_id = x_application_id