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

Line 1: PACKAGE BODY AME_ACTION_TYPES_API AS

1: PACKAGE BODY AME_ACTION_TYPES_API AS
2: /* $Header: ameacapi.pkb 120.6 2005/10/14 04:10:32 ubhat noship $ */
3: procedure OWNER_TO_WHO (
4: X_OWNER in VARCHAR2,
5: X_CREATED_BY out nocopy NUMBER,

Line 31: from AME_ACTION_TYPES

27: select ROWID, ACTION_TYPE_ID,
28: LAST_UPDATED_BY,
29: to_char(LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),
30: nvl(OBJECT_VERSION_NUMBER,1)
31: from AME_ACTION_TYPES
32: where NAME = X_ACTION_TYPE_NAME
33: and sysdate between START_DATE
34: and nvl(END_DATE - (1/86400), sysdate);
35: begin

Line 104: insert into AME_ACTION_TYPES

100: is
101:
102: begin
103:
104: insert into AME_ACTION_TYPES
105: (
106: ACTION_TYPE_ID,
107: NAME,
108: PROCEDURE_NAME,

Line 151: insert into AME_ACTION_TYPES_TL

147: begin
148: if not AME_SEED_UTILITY.MLS_ENABLED then
149: return;
150: end if;
151: insert into AME_ACTION_TYPES_TL
152: (ACTION_TYPE_ID
153: ,USER_ACTION_TYPE_NAME
154: ,DESCRIPTION
155: ,CREATED_BY

Line 175: from AME_ACTION_TYPES_TL T

171: userenv('LANG')
172: from FND_LANGUAGES L
173: where L.INSTALLED_FLAG in ('I', 'B')
174: and not exists (select null
175: from AME_ACTION_TYPES_TL T
176: where T.ACTION_TYPE_ID = X_ACTION_TYPE_ID
177: and T.LANGUAGE = L.LANGUAGE_CODE);
178: END INSERT_TL_ROW;
179:

Line 200: FROM AME_ACTION_TYPES_TL

196: select LAST_UPDATED_BY,
197: LAST_UPDATE_DATE
198: into X_CURRENT_OWNER,
199: X_CURRENT_LAST_UPDATE_DATE
200: FROM AME_ACTION_TYPES_TL
201: WHERE ACTION_TYPE_ID = X_ACTION_TYPE_ID
202: AND LANGUAGE = USERENV('LANG');
203:
204: if DO_UPDATE_INSERT

Line 210: update AME_ACTION_TYPES_TL

206: ,X_CURRENT_OWNER
207: ,AME_SEED_UTILITY.DATE_AS_STRING(X_LAST_UPDATE_DATE)
208: ,AME_SEED_UTILITY.DATE_AS_STRING(X_CURRENT_LAST_UPDATE_DATE)
209: ,X_CUSTOM_MODE) then
210: update AME_ACTION_TYPES_TL
211: set USER_ACTION_TYPE_NAME = nvl(X_USER_ACTION_TYPE_NAME,USER_ACTION_TYPE_NAME),
212: DESCRIPTION = nvl(X_DESCRIPTION,DESCRIPTION),
213: SOURCE_LANG = userenv('LANG'),
214: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 230: update AME_ACTION_TYPES set

226: X_ACTION_TYPE_ROWID in VARCHAR2,
227: X_END_DATE in DATE)
228: is
229: begin
230: update AME_ACTION_TYPES set
231: END_DATE = X_END_DATE
232: where ROWID = X_ACTION_TYPE_ROWID;
233: end UPDATE_ROW;
234:

Line 252: update AME_ACTION_TYPES

248: X_END_DATE in DATE,
249: X_OBJECT_VERSION_NUMBER in NUMBER
250: ) is
251: begin
252: update AME_ACTION_TYPES
253: set NAME = X_NAME,
254: PROCEDURE_NAME = X_PROCEDURE_NAME,
255: DYNAMIC_DESCRIPTION = X_DYNAMIC_DESCRIPTION,
256: DESCRIPTION_QUERY = X_DESCRIPTION_QUERY,

Line 274: delete from AME_ACTION_TYPES_TL

270: X_ACTION_TYPE_ID in NUMBER
271: ) is
272: begin
273: if AME_SEED_UTILITY.MLS_ENABLED then
274: delete from AME_ACTION_TYPES_TL
275: where ACTION_TYPE_ID = X_ACTION_TYPE_ID;
276: end if;
277: delete from AME_ACTION_TYPES
278: where ACTION_TYPE_ID = X_ACTION_TYPE_ID;

Line 277: delete from AME_ACTION_TYPES

273: if AME_SEED_UTILITY.MLS_ENABLED then
274: delete from AME_ACTION_TYPES_TL
275: where ACTION_TYPE_ID = X_ACTION_TYPE_ID;
276: end if;
277: delete from AME_ACTION_TYPES
278: where ACTION_TYPE_ID = X_ACTION_TYPE_ID;
279:
280: if (sql%notfound) then
281: raise no_data_found;

Line 326: select ame_action_types_s.nextval into X_ACTION_TYPE_ID from dual;

322: );
323: begin
324: -- the current row was not found insert a new row
325: if X_ACTION_TYPE_ID is null then
326: select ame_action_types_s.nextval into X_ACTION_TYPE_ID from dual;
327: INSERT_ROW (
328: X_ACTION_TYPE_ID,
329: X_ACTION_TYPE_NAME,
330: X_PROCEDURE_NAME,

Line 423: ame_util.runtimeException('ame_action_types_api',

419: end if;
420: end;
421: exception
422: when others then
423: ame_util.runtimeException('ame_action_types_api',
424: 'load_row',
425: sqlcode,
426: sqlerrm);
427: raise;

Line 467: from AME_ACTION_TYPES_TL AATTL,

463: into X_CURRENT_OWNER,
464: X_CURRENT_LAST_UPDATE_DATE,
465: X_CURRENT_CREATED_BY,
466: X_ACTION_TYPE_ID
467: from AME_ACTION_TYPES_TL AATTL,
468: AME_ACTION_TYPES AAT
469: where AAT.NAME = X_ACTION_TYPE_NAME
470: and AAT.ACTION_TYPE_ID = AATTL.ACTION_TYPE_ID
471: and sysdate between AAT.START_DATE and nvl(AAT.END_DATE - (1/86400),sysdate)

Line 468: AME_ACTION_TYPES AAT

464: X_CURRENT_LAST_UPDATE_DATE,
465: X_CURRENT_CREATED_BY,
466: X_ACTION_TYPE_ID
467: from AME_ACTION_TYPES_TL AATTL,
468: AME_ACTION_TYPES AAT
469: where AAT.NAME = X_ACTION_TYPE_NAME
470: and AAT.ACTION_TYPE_ID = AATTL.ACTION_TYPE_ID
471: and sysdate between AAT.START_DATE and nvl(AAT.END_DATE - (1/86400),sysdate)
472: and AATTL.ACTION_TYPE_ID = AAT.ACTION_TYPE_ID

Line 481: update AME_ACTION_TYPES_TL AATTL

477: X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE,
478: X_CURRENT_LAST_UPDATE_DATE => X_CURRENT_LAST_UPDATE_DATE,
479: X_CURRENT_CREATED_BY => X_CURRENT_CREATED_BY,
480: X_CUSTOM_MODE => X_CUSTOM_MODE) then
481: update AME_ACTION_TYPES_TL AATTL
482: set USER_ACTION_TYPE_NAME = nvl(X_USER_ACTION_TYPE_NAME,USER_ACTION_TYPE_NAME),
483: DESCRIPTION = nvl(X_DESCRIPTION,DESCRIPTION),
484: SOURCE_LANG = userenv('LANG'),
485: LAST_UPDATE_DATE = AME_SEED_UTILITY.DATE_AS_DATE(X_LAST_UPDATE_DATE),

Line 497: end AME_ACTION_TYPES_API;

493: null;
494: end;
495: end TRANSLATE_ROW;
496:
497: end AME_ACTION_TYPES_API;