APPS.AME_ACTION_USAGES_API2 dependencies on AME_ACTIONS

Line 29: from AME_ACTIONS ACT,

25: select ACT.ACTION_ID,
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')

Line 263: L_PARAMETER AME_ACTIONS.PARAMETER%TYPE;

259: L_RULE_ID number;
260: L_ACTION_ID number;
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);

Line 264: L_PARAMETER_TWO AME_ACTIONS.PARAMETER_TWO%TYPE;

260: L_ACTION_ID number;
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);

Line 381: from AME_ACTIONS ACT,

377: into X_CURRENT_OWNER,
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

Line 402: from AME_ACTIONS ACT,

398: and sysdate between ARU.START_DATE and nvl(ARU.END_DATE - (1/86400),sysdate)
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