APPS.AME_PRODUCTION_ACTIONS_API dependencies on AME_ACTION_TYPES

Line 11: from AME_ACTION_TYPES AAT

7: begin
8: begin
9: select AAT.ACTION_TYPE_ID
10: into X_ACTION_TYPE_ID
11: from AME_ACTION_TYPES AAT
12: where AAT.NAME = X_ACTION_TYPE_NAME
13: and sysdate between AAT.START_DATE and nvl(AAT.END_DATE - (1/86400),sysdate);
14: exception
15: when no_data_found then

Line 236: L_ACTION_TYPE_NAME AME_ACTION_TYPES.NAME%TYPE;

232: L_END_DATE date;
233: L_PARAMETER AME_ACTIONS.PARAMETER%TYPE;
234: L_PARAMETER_TWO AME_ACTIONS.PARAMETER_TWO%TYPE;
235: L_DESCRIPTION AME_ACTIONS_TL.DESCRIPTION%TYPE;
236: L_ACTION_TYPE_NAME AME_ACTION_TYPES.NAME%TYPE;
237: L_OWNER varchar2(100);
238: L_LAST_UPDATE_DATE varchar2(19);
239: L_OBJECT_VERSION_NUMBER number;
240: L_ROWID ROWID;

Line 333: L_ACTION_TYPE_NAME AME_ACTION_TYPES.NAME%TYPE;

329: L_ACTION_ID number;
330: L_PARAMETER AME_ACTIONS.PARAMETER%TYPE;
331: L_PARAMETER_TWO AME_ACTIONS.PARAMETER_TWO%TYPE;
332: L_DESCRIPTION AME_ACTIONS_TL.DESCRIPTION%TYPE;
333: L_ACTION_TYPE_NAME AME_ACTION_TYPES.NAME%TYPE;
334: L_OWNER varchar2(100);
335: L_LAST_UPDATE_DATE varchar2(19);
336: begin
337: if not AME_SEED_UTILITY.MLS_ENABLED then

Line 405: AME_ACTION_TYPES AAT

401: X_CURRENT_LAST_UPDATE_DATE,
402: X_CREATED_BY
403: from AME_ACTIONS_TL ACTTL,
404: AME_ACTIONS ACT,
405: AME_ACTION_TYPES AAT
406: where ACT.ACTION_TYPE_ID = AAT.ACTION_TYPE_ID
407: and ACTTL.ACTION_ID = ACT.ACTION_ID
408: and AAT.NAME = X_ACTION_TYPE_NAME
409: and ACT.PARAMETER = X_PARAMETER

Line 436: AME_ACTION_TYPES AAT

432: AME_SEED_UTILITY.DATE_AS_STRING(ACT.LAST_UPDATE_DATE)
433: into X_CURRENT_OWNER,
434: X_CURRENT_LAST_UPDATE_DATE
435: from AME_ACTIONS ACT,
436: AME_ACTION_TYPES AAT
437: where ACT.ACTION_TYPE_ID = AAT.ACTION_TYPE_ID
438: and AAT.NAME = X_ACTION_TYPE_NAME
439: and ACT.PARAMETER = X_PARAMETER
440: and ACT.PARAMETER_TWO = X_PARAMETER_TWO