DBA Data[Home] [Help]

APPS.AME_ACTION_TYPE_USAGES_API dependencies on AME_ACTION_TYPES

Line 29: from AME_ACTION_TYPES

25: (
26: X_ACTION_TYPE_NAME in VARCHAR2
27: ) is
28: select ACTION_TYPE_ID
29: from AME_ACTION_TYPES
30: where NAME = X_ACTION_TYPE_NAME
31: and sysdate between START_DATE
32: and nvl(END_DATE - (1/86400), sysdate);
33: cursor CSR_GET_CURRENT_ACTION_USAGE

Line 272: ame_util.runtimeException('ame_action_types_usages_api',

268: end if;
269: end;
270: exception
271: when others then
272: ame_util.runtimeException('ame_action_types_usages_api',
273: 'load_row',
274: sqlcode,
275: sqlerrm);
276: raise;