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_ACTION_USAGES_API2 dependencies on AME_ACTION_TYPES

Line 30: AME_ACTION_TYPES AAT

26: ACT.ACTION_TYPE_ID
27: into X_ACTION_ID,
28: X_ACTION_TYPE_ID
29: from AME_ACTIONS ACT,
30: AME_ACTION_TYPES AAT
31: where ACT.ACTION_TYPE_ID = AAT.ACTION_TYPE_ID
32: and AAT.NAME = X_ACTION_TYPE_NAME
33: and nvl(ACT.PARAMETER,'NULL') = nvl(X_PARAMETER,'NULL')
34: and nvl(ACT.PARAMETER_TWO,'NULL') = nvl(X_PARAMETER_TWO,'NULL')

Line 265: L_ACTION_TYPE_NAME AME_ACTION_TYPES.NAME%TYPE;

261: L_END_DATE date;
262: L_DUMMY varchar2(1);
263: L_PARAMETER AME_ACTIONS.PARAMETER%TYPE;
264: L_PARAMETER_TWO AME_ACTIONS.PARAMETER_TWO%TYPE;
265: L_ACTION_TYPE_NAME AME_ACTION_TYPES.NAME%TYPE;
266: L_RULE_KEY AME_RULES.RULE_KEY%TYPE;
267: L_OWNER varchar2(100);
268: L_LAST_UPDATE_DATE varchar2(19);
269: L_OBJECT_VERSION_NUMBER number;

Line 382: AME_ACTION_TYPES AAT,

378: X_CURRENT_LAST_UPDATE_DATE
379: from (select AAU.LAST_UPDATED_BY OWNER,
380: AME_SEED_UTILITY.DATE_AS_STRING(AAU.LAST_UPDATE_DATE) LAST_UPDATE_DATE
381: from AME_ACTIONS ACT,
382: AME_ACTION_TYPES AAT,
383: AME_RULES ARU,
384: AME_ACTION_USAGES AAU
385: where ACT.ACTION_TYPE_ID = AAT.ACTION_TYPE_ID
386: and ACT.ACTION_ID = AAU.ACTION_ID

Line 403: AME_ACTION_TYPES AAT,

399: union
400: select AAU.LAST_UPDATED_BY OWNER,
401: AME_SEED_UTILITY.DATE_AS_STRING(AAU.LAST_UPDATE_DATE) LAST_UPDATE_DATE
402: from AME_ACTIONS ACT,
403: AME_ACTION_TYPES AAT,
404: AME_RULES ARU,
405: AME_ACTION_USAGES AAU,
406: AME_APPROVAL_GROUPS AAG
407: where ACT.ACTION_TYPE_ID = AAT.ACTION_TYPE_ID