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_ACTIONS_API dependencies on AME_ACTIONS

Line 1: PACKAGE BODY AME_ACTIONS_API AS

1: PACKAGE BODY AME_ACTIONS_API AS
2: /* $Header: ameanapi.pkb 120.8.12000000.2 2007/04/19 08:04:56 prasashe noship $ */
3: procedure OWNER_TO_WHO (
4: X_OWNER in VARCHAR2,
5: X_CREATED_BY out nocopy NUMBER,

Line 43: from AME_ACTIONS

39: ) is select ACTION_ID, ROWID,
40: LAST_UPDATED_BY,
41: to_char(LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),
42: nvl(OBJECT_VERSION_NUMBER,1)
43: from AME_ACTIONS
44: where ACTION_TYPE_ID = X_ACTION_TYPE_ID
45: and nvl(PARAMETER,'NULL') = nvl(X_PARAMETER,'NULL')
46: and nvl(PARAMETER_TWO,'NULL') = nvl(X_PARAMETER_TWO,'NULL')
47: and sysdate between START_DATE

Line 160: insert into AME_ACTIONS

156: X_OBJECT_VERSION_NUMBER in NUMBER
157: )
158: is
159: begin
160: insert into AME_ACTIONS
161: (
162: ACTION_ID,
163: ACTION_TYPE_ID,
164: PARAMETER,

Line 203: insert into AME_ACTIONS_TL

199: begin
200: if not AME_SEED_UTILITY.MLS_ENABLED then
201: return;
202: end if;
203: insert into AME_ACTIONS_TL
204: (ACTION_ID
205: ,DESCRIPTION
206: ,CREATED_BY
207: ,CREATION_DATE

Line 225: from AME_ACTIONS_TL T

221: userenv('LANG')
222: from FND_LANGUAGES L
223: where L.INSTALLED_FLAG in ('I', 'B')
224: and not exists (select null
225: from AME_ACTIONS_TL T
226: where T.ACTION_ID = X_ACTION_ID
227: and T.LANGUAGE = L.LANGUAGE_CODE);
228: END insert_tl_row;
229:

Line 250: FROM AME_ACTIONS_TL

246: select LAST_UPDATED_BY,
247: LAST_UPDATE_DATE
248: into X_CURRENT_OWNER,
249: X_CURRENT_LAST_UPDATE_DATE
250: FROM AME_ACTIONS_TL
251: WHERE ACTION_ID = X_ACTION_ID
252: AND LANGUAGE = USERENV('LANG');
253:
254: if DO_UPDATE_INSERT

Line 260: update AME_ACTIONS_TL

256: ,X_CURRENT_OWNER
257: ,AME_SEED_UTILITY.DATE_AS_STRING(X_LAST_UPDATE_DATE)
258: ,AME_SEED_UTILITY.DATE_AS_STRING(X_CURRENT_LAST_UPDATE_DATE)
259: ,X_CUSTOM_MODE) then
260: update AME_ACTIONS_TL
261: set DESCRIPTION = nvl(X_DESCRIPTION,DESCRIPTION),
262: SOURCE_LANG = userenv('LANG'),
263: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
264: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 279: update AME_ACTIONS set

275: X_ACTION_ROWID in VARCHAR2,
276: X_END_DATE in DATE)
277: is
278: begin
279: update AME_ACTIONS set
280: END_DATE = X_END_DATE
281: where ROWID = X_ACTION_ROWID;
282: end UPDATE_ROW;
283:

Line 297: update AME_ACTIONS

293: X_END_DATE in DATE,
294: X_OBJECT_VERSION_NUMBER in NUMBER
295: ) is
296: begin
297: update AME_ACTIONS
298: set DESCRIPTION = X_DESCRIPTION,
299: CREATED_BY = X_CREATED_BY,
300: CREATION_DATE = X_CREATION_DATE,
301: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 315: delete from AME_ACTIONS_TL

311: X_ACTION_ID in NUMBER
312: ) is
313: begin
314: if AME_SEED_UTILITY.MLS_ENABLED then
315: delete from AME_ACTIONS_TL
316: where ACTION_ID = X_ACTION_ID;
317: end if;
318: delete from AME_ACTIONS
319: where ACTION_ID = X_ACTION_ID;

Line 318: delete from AME_ACTIONS

314: if AME_SEED_UTILITY.MLS_ENABLED then
315: delete from AME_ACTIONS_TL
316: where ACTION_ID = X_ACTION_ID;
317: end if;
318: delete from AME_ACTIONS
319: where ACTION_ID = X_ACTION_ID;
320: if (sql%notfound) then
321: raise no_data_found;
322: end if;

Line 370: select ame_actions_s.nextval

366: -- the current row was not found insert a new row
367: if X_ACTION_TYPE_ID is not null then
368: if X_ACTION_ROWID is null then
369: if X_ACTION_ID is null then
370: select ame_actions_s.nextval
371: into X_ACTION_ID
372: from dual;
373: end if;
374: INSERT_ROW (

Line 469: ame_util.runtimeException('ame_actions_usages_api',

465: end if;
466: end;
467: exception
468: when others then
469: ame_util.runtimeException('ame_actions_usages_api',
470: 'load_row',
471: sqlcode,
472: sqlerrm);
473: raise;

Line 532: from AME_ACTIONS_TL ACTTL,

528: into X_CURRENT_OWNER,
529: X_CURRENT_LAST_UPDATE_DATE,
530: X_CREATED_BY,
531: X_ACTION_ID
532: from AME_ACTIONS_TL ACTTL,
533: AME_ACTIONS ACT,
534: AME_ACTION_TYPES AAT
535: where AAT.NAME = X_ACTION_TYPE_NAME
536: and AAT.ACTION_TYPE_ID = ACT.ACTION_TYPE_ID

Line 533: AME_ACTIONS ACT,

529: X_CURRENT_LAST_UPDATE_DATE,
530: X_CREATED_BY,
531: X_ACTION_ID
532: from AME_ACTIONS_TL ACTTL,
533: AME_ACTIONS ACT,
534: AME_ACTION_TYPES AAT
535: where AAT.NAME = X_ACTION_TYPE_NAME
536: and AAT.ACTION_TYPE_ID = ACT.ACTION_TYPE_ID
537: and nvl(ACT.PARAMETER,'NULL') = nvl(X_TEMP_PARAMETER,'NULL')

Line 547: from ame_actions aac,ame_action_types aaty

543: and (X_ACTION_TYPE_NAME <> ame_util.finalAuthorityTypeName
544: or (X_ACTION_TYPE_NAME = ame_util.finalAuthorityTypeName and
545: ACT.ACTION_ID = (
546: select MIN(ACTION_ID)
547: from ame_actions aac,ame_action_types aaty
548: where aac.action_type_id = aaty.action_type_id
549: and aaty.name = X_ACTION_TYPE_NAME
550: and sysdate between aac.start_date
551: and nvl(aac.end_date,sysdate)

Line 564: update AME_ACTIONS_TL ACTTL

560: X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE,
561: X_CURRENT_LAST_UPDATE_DATE => X_CURRENT_LAST_UPDATE_DATE,
562: X_CREATED_BY => X_CREATED_BY,
563: X_CUSTOM_MODE => X_CUSTOM_MODE) then
564: update AME_ACTIONS_TL ACTTL
565: set DESCRIPTION = nvl(X_DESCRIPTION,DESCRIPTION),
566: SOURCE_LANG = userenv('LANG'),
567: LAST_UPDATE_DATE = AME_SEED_UTILITY.DATE_AS_DATE(X_LAST_UPDATE_DATE),
568: LAST_UPDATED_BY = AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER),

Line 579: END AME_ACTIONS_API;

575: null;
576: end;
577: end TRANSLATE_ROW;
578:
579: END AME_ACTIONS_API;