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

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

179: if(TEMP_COUNT > 0) then
180: NEW_USE_COUNT := NEW_USE_COUNT + 1;
181: else
182: if(TEMPRULE.ACTION_ID is null) then
183: -- action_id is already migrated from ame_rules to ame_action_usages
184: select count(*)
185: into TEMP_COUNT
186: from
187: AME_MANDATORY_ATTRIBUTES,

Line 189: AME_ACTION_USAGES

185: into TEMP_COUNT
186: from
187: AME_MANDATORY_ATTRIBUTES,
188: AME_ACTIONS,
189: AME_ACTION_USAGES
190: where
191: AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID = X_ATTRIBUTE_ID and
192: AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID = AME_ACTIONS.ACTION_TYPE_ID and
193: AME_ACTIONS.ACTION_ID = AME_ACTION_USAGES.ACTION_ID and

Line 193: AME_ACTIONS.ACTION_ID = AME_ACTION_USAGES.ACTION_ID and

189: AME_ACTION_USAGES
190: where
191: AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID = X_ATTRIBUTE_ID and
192: AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID = AME_ACTIONS.ACTION_TYPE_ID and
193: AME_ACTIONS.ACTION_ID = AME_ACTION_USAGES.ACTION_ID and
194: AME_ACTION_USAGES.RULE_ID = TEMPRULE.RULE_ID and
195: sysdate between AME_MANDATORY_ATTRIBUTES.START_DATE and
196: nvl(AME_MANDATORY_ATTRIBUTES.END_DATE - (1/86400), sysdate) and
197: sysdate between AME_ACTIONS.START_DATE and

Line 194: AME_ACTION_USAGES.RULE_ID = TEMPRULE.RULE_ID and

190: where
191: AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID = X_ATTRIBUTE_ID and
192: AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID = AME_ACTIONS.ACTION_TYPE_ID and
193: AME_ACTIONS.ACTION_ID = AME_ACTION_USAGES.ACTION_ID and
194: AME_ACTION_USAGES.RULE_ID = TEMPRULE.RULE_ID and
195: sysdate between AME_MANDATORY_ATTRIBUTES.START_DATE and
196: nvl(AME_MANDATORY_ATTRIBUTES.END_DATE - (1/86400), sysdate) and
197: sysdate between AME_ACTIONS.START_DATE and
198: nvl(AME_ACTIONS.END_DATE - (1/86400), sysdate) and

Line 199: ((sysdate between AME_ACTION_USAGES.START_DATE and

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

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

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

Line 201: (sysdate < AME_ACTION_USAGES.START_DATE and

197: sysdate between AME_ACTIONS.START_DATE and
198: nvl(AME_ACTIONS.END_DATE - (1/86400), sysdate) and
199: ((sysdate between AME_ACTION_USAGES.START_DATE and
200: nvl(AME_ACTION_USAGES.END_DATE - (1/86400), sysdate)) or
201: (sysdate < AME_ACTION_USAGES.START_DATE and
202: AME_ACTION_USAGES.START_DATE < nvl(AME_ACTION_USAGES.END_DATE,
203: AME_ACTION_USAGES.START_DATE + (1/86400))));
204: else
205: select count(*)

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

198: nvl(AME_ACTIONS.END_DATE - (1/86400), sysdate) and
199: ((sysdate between AME_ACTION_USAGES.START_DATE and
200: nvl(AME_ACTION_USAGES.END_DATE - (1/86400), sysdate)) or
201: (sysdate < AME_ACTION_USAGES.START_DATE and
202: AME_ACTION_USAGES.START_DATE < nvl(AME_ACTION_USAGES.END_DATE,
203: AME_ACTION_USAGES.START_DATE + (1/86400))));
204: else
205: select count(*)
206: into TEMP_COUNT

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

199: ((sysdate between AME_ACTION_USAGES.START_DATE and
200: nvl(AME_ACTION_USAGES.END_DATE - (1/86400), sysdate)) or
201: (sysdate < AME_ACTION_USAGES.START_DATE and
202: AME_ACTION_USAGES.START_DATE < nvl(AME_ACTION_USAGES.END_DATE,
203: AME_ACTION_USAGES.START_DATE + (1/86400))));
204: else
205: select count(*)
206: into TEMP_COUNT
207: from

Line 263: AME_ACTION_USAGES,

259: AME_CONDITION_USAGES.START_DATE + (1/86400))))
260: union
261: select AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID
262: from AME_MANDATORY_ATTRIBUTES,
263: AME_ACTION_USAGES,
264: AME_ACTIONS
265: where
266: AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID = AME_ACTIONS.ACTION_TYPE_ID and
267: AME_ACTIONS.ACTION_ID = AME_ACTION_USAGES.ACTION_ID and

Line 267: AME_ACTIONS.ACTION_ID = AME_ACTION_USAGES.ACTION_ID and

263: AME_ACTION_USAGES,
264: AME_ACTIONS
265: where
266: AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID = AME_ACTIONS.ACTION_TYPE_ID and
267: AME_ACTIONS.ACTION_ID = AME_ACTION_USAGES.ACTION_ID and
268: AME_ACTION_USAGES.RULE_ID = X_RULE_ID and
269: (AME_MANDATORY_ATTRIBUTES.START_DATE <= sysdate and
270: (AME_MANDATORY_ATTRIBUTES.END_DATE is null or sysdate < AME_MANDATORY_ATTRIBUTES.END_DATE)) and
271: ((sysdate between AME_ACTION_USAGES.START_DATE and

Line 268: AME_ACTION_USAGES.RULE_ID = X_RULE_ID and

264: AME_ACTIONS
265: where
266: AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID = AME_ACTIONS.ACTION_TYPE_ID and
267: AME_ACTIONS.ACTION_ID = AME_ACTION_USAGES.ACTION_ID and
268: AME_ACTION_USAGES.RULE_ID = X_RULE_ID and
269: (AME_MANDATORY_ATTRIBUTES.START_DATE <= sysdate and
270: (AME_MANDATORY_ATTRIBUTES.END_DATE is null or sysdate < AME_MANDATORY_ATTRIBUTES.END_DATE)) and
271: ((sysdate between AME_ACTION_USAGES.START_DATE and
272: nvl(AME_ACTION_USAGES.END_DATE - (1/86400), sysdate)) or

Line 271: ((sysdate between AME_ACTION_USAGES.START_DATE and

267: AME_ACTIONS.ACTION_ID = AME_ACTION_USAGES.ACTION_ID and
268: AME_ACTION_USAGES.RULE_ID = X_RULE_ID and
269: (AME_MANDATORY_ATTRIBUTES.START_DATE <= sysdate and
270: (AME_MANDATORY_ATTRIBUTES.END_DATE is null or sysdate < AME_MANDATORY_ATTRIBUTES.END_DATE)) and
271: ((sysdate between AME_ACTION_USAGES.START_DATE and
272: nvl(AME_ACTION_USAGES.END_DATE - (1/86400), sysdate)) or
273: (sysdate < AME_ACTION_USAGES.START_DATE and
274: AME_ACTION_USAGES.START_DATE < nvl(AME_ACTION_USAGES.END_DATE,AME_ACTION_USAGES.START_DATE
275: + (1/86400)))) and

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

268: AME_ACTION_USAGES.RULE_ID = X_RULE_ID and
269: (AME_MANDATORY_ATTRIBUTES.START_DATE <= sysdate and
270: (AME_MANDATORY_ATTRIBUTES.END_DATE is null or sysdate < AME_MANDATORY_ATTRIBUTES.END_DATE)) and
271: ((sysdate between AME_ACTION_USAGES.START_DATE and
272: nvl(AME_ACTION_USAGES.END_DATE - (1/86400), sysdate)) or
273: (sysdate < AME_ACTION_USAGES.START_DATE and
274: AME_ACTION_USAGES.START_DATE < nvl(AME_ACTION_USAGES.END_DATE,AME_ACTION_USAGES.START_DATE
275: + (1/86400)))) and
276: (AME_ACTIONS.START_DATE <= sysdate and

Line 273: (sysdate < AME_ACTION_USAGES.START_DATE and

269: (AME_MANDATORY_ATTRIBUTES.START_DATE <= sysdate and
270: (AME_MANDATORY_ATTRIBUTES.END_DATE is null or sysdate < AME_MANDATORY_ATTRIBUTES.END_DATE)) and
271: ((sysdate between AME_ACTION_USAGES.START_DATE and
272: nvl(AME_ACTION_USAGES.END_DATE - (1/86400), sysdate)) or
273: (sysdate < AME_ACTION_USAGES.START_DATE and
274: AME_ACTION_USAGES.START_DATE < nvl(AME_ACTION_USAGES.END_DATE,AME_ACTION_USAGES.START_DATE
275: + (1/86400)))) and
276: (AME_ACTIONS.START_DATE <= sysdate and
277: (AME_ACTIONS.END_DATE is null or sysdate < AME_ACTIONS.END_DATE))

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

270: (AME_MANDATORY_ATTRIBUTES.END_DATE is null or sysdate < AME_MANDATORY_ATTRIBUTES.END_DATE)) and
271: ((sysdate between AME_ACTION_USAGES.START_DATE and
272: nvl(AME_ACTION_USAGES.END_DATE - (1/86400), sysdate)) or
273: (sysdate < AME_ACTION_USAGES.START_DATE and
274: AME_ACTION_USAGES.START_DATE < nvl(AME_ACTION_USAGES.END_DATE,AME_ACTION_USAGES.START_DATE
275: + (1/86400)))) and
276: (AME_ACTIONS.START_DATE <= sysdate and
277: (AME_ACTIONS.END_DATE is null or sysdate < AME_ACTIONS.END_DATE))
278: union

Line 324: ame_action_usages aau,

320: aa.action_type_id,
321: aat.name,
322: aa.parameter
323: from ame_rule_usages aru,
324: ame_action_usages aau,
325: ame_actions aa,
326: ame_action_types aat
327: where aru.rule_id = x_rule_id
328: and aru.item_id = x_application_id