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_SEED_UTILITY

Line 10: X_CREATED_BY := AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER);

6: X_LAST_UPDATED_BY out nocopy NUMBER,
7: X_LAST_UPDATE_LOGIN out nocopy NUMBER
8: ) is
9: begin
10: X_CREATED_BY := AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER);
11: X_LAST_UPDATED_BY := AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER);
12: X_LAST_UPDATE_LOGIN := 0;
13: end OWNER_TO_WHO;
14:

Line 11: X_LAST_UPDATED_BY := AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER);

7: X_LAST_UPDATE_LOGIN out nocopy NUMBER
8: ) is
9: begin
10: X_CREATED_BY := AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER);
11: X_LAST_UPDATED_BY := AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER);
12: X_LAST_UPDATE_LOGIN := 0;
13: end OWNER_TO_WHO;
14:
15: procedure KEY_TO_IDS (

Line 54: return AME_SEED_UTILITY.MERGE_ROW_TEST

50: X_CURRENT_LAST_UPDATE_DATE in VARCHAR2,
51: X_CUSTOM_MODE in VARCHAR2 default null)
52: return boolean as
53: begin
54: return AME_SEED_UTILITY.MERGE_ROW_TEST
55: (X_OWNER => X_OWNER
56: ,X_CURRENT_OWNER => X_CURRENT_OWNER
57: ,X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE
58: ,X_CURRENT_LAST_UPDATE_DATE => X_CURRENT_LAST_UPDATE_DATE

Line 73: if AME_SEED_UTILITY.IS_SEED_USER(X_CURRENT_CREATED_BY) then

69: begin
70: if X_CUSTOM_MODE = 'FORCE' then
71: return true;
72: end if;
73: if AME_SEED_UTILITY.IS_SEED_USER(X_CURRENT_CREATED_BY) then
74: return true;
75: else
76: return AME_SEED_UTILITY.TL_MERGE_ROW_TEST
77: (X_OWNER => X_OWNER

Line 76: return AME_SEED_UTILITY.TL_MERGE_ROW_TEST

72: end if;
73: if AME_SEED_UTILITY.IS_SEED_USER(X_CURRENT_CREATED_BY) then
74: return true;
75: else
76: return AME_SEED_UTILITY.TL_MERGE_ROW_TEST
77: (X_OWNER => X_OWNER
78: ,X_CURRENT_OWNER => X_CURRENT_OWNER
79: ,X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE
80: ,X_CURRENT_LAST_UPDATE_DATE => X_CURRENT_LAST_UPDATE_DATE

Line 132: AME_SEED_UTILITY.GET_DEFAULT_END_DATE,

128: X_LAST_UPDATED_BY,
129: X_LAST_UPDATE_DATE,
130: X_LAST_UPDATE_LOGIN,
131: X_START_DATE,
132: AME_SEED_UTILITY.GET_DEFAULT_END_DATE,
133: X_DESCRIPTION,
134: X_OBJECT_VERSION_NUMBER);
135:
136: end INSERT_ROW;

Line 148: if not AME_SEED_UTILITY.MLS_ENABLED then

144: X_LAST_UPDATED_BY in NUMBER,
145: X_LAST_UPDATE_DATE in DATE,
146: X_LAST_UPDATE_LOGIN in NUMBER) is
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

Line 193: if not AME_SEED_UTILITY.MLS_ENABLED then

189: X_CUSTOM_MODE in VARCHAR2) is
190: X_CURRENT_OWNER NUMBER;
191: X_CURRENT_LAST_UPDATE_DATE DATE;
192: begin
193: if not AME_SEED_UTILITY.MLS_ENABLED then
194: return;
195: end if;
196: select LAST_UPDATED_BY,
197: LAST_UPDATE_DATE

Line 207: ,AME_SEED_UTILITY.DATE_AS_STRING(X_LAST_UPDATE_DATE)

203:
204: if DO_UPDATE_INSERT
205: (X_LAST_UPDATED_BY
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),

Line 208: ,AME_SEED_UTILITY.DATE_AS_STRING(X_CURRENT_LAST_UPDATE_DATE)

204: if DO_UPDATE_INSERT
205: (X_LAST_UPDATED_BY
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),

Line 273: if AME_SEED_UTILITY.MLS_ENABLED then

269: procedure DELETE_ROW (
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

Line 370: AME_SEED_UTILITY.GET_DEFAULT_END_DATE,

366: X_LAST_UPDATED_BY,
367: to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),
368: X_LAST_UPDATE_LOGIN,
369: to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),
370: AME_SEED_UTILITY.GET_DEFAULT_END_DATE,
371: X_CURRENT_OVN + 1);
372: UPDATE_TL_ROW
373: (X_ACTION_TYPE_ID,
374: nvl(X_USER_ACTION_TYPE_NAME,X_ACTION_TYPE_NAME),

Line 385: (AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER),

381: X_CUSTOM_MODE
382: );
383: else
384: if DO_UPDATE_INSERT
385: (AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER),
386: X_CURRENT_OWNER,
387: X_LAST_UPDATE_DATE,
388: X_CURRENT_LAST_UPDATE_DATE) then
389: UPDATE_ROW (

Line 455: if not AME_SEED_UTILITY.MLS_ENABLED then

451: X_CURRENT_LAST_UPDATE_DATE varchar2(20);
452: X_CURRENT_CREATED_BY varchar2(100);
453: X_ACTION_TYPE_ID number;
454: begin
455: if not AME_SEED_UTILITY.MLS_ENABLED then
456: return;
457: end if;
458: begin
459: select AATTL.LAST_UPDATED_BY,

Line 460: AME_SEED_UTILITY.DATE_AS_STRING(AATTL.LAST_UPDATE_DATE),

456: return;
457: end if;
458: begin
459: select AATTL.LAST_UPDATED_BY,
460: AME_SEED_UTILITY.DATE_AS_STRING(AATTL.LAST_UPDATE_DATE),
461: AME_SEED_UTILITY.OWNER_AS_STRING(AATTL.CREATED_BY),
462: AAT.ACTION_TYPE_ID
463: into X_CURRENT_OWNER,
464: X_CURRENT_LAST_UPDATE_DATE,

Line 461: AME_SEED_UTILITY.OWNER_AS_STRING(AATTL.CREATED_BY),

457: end if;
458: begin
459: select AATTL.LAST_UPDATED_BY,
460: AME_SEED_UTILITY.DATE_AS_STRING(AATTL.LAST_UPDATE_DATE),
461: AME_SEED_UTILITY.OWNER_AS_STRING(AATTL.CREATED_BY),
462: AAT.ACTION_TYPE_ID
463: into X_CURRENT_OWNER,
464: X_CURRENT_LAST_UPDATE_DATE,
465: X_CURRENT_CREATED_BY,

Line 475: (X_OWNER => AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER),

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
473: and AATTL.LANGUAGE = userenv('LANG');
474: if DO_TL_UPDATE_INSERT
475: (X_OWNER => AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER),
476: X_CURRENT_OWNER => X_CURRENT_OWNER,
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,

Line 485: LAST_UPDATE_DATE = AME_SEED_UTILITY.DATE_AS_DATE(X_LAST_UPDATE_DATE),

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),
486: LAST_UPDATED_BY = AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER),
487: LAST_UPDATE_LOGIN = 0
488: where AATTL.ACTION_TYPE_ID = X_ACTION_TYPE_ID
489: and userenv('LANG') in (AATTL.LANGUAGE,AATTL.SOURCE_LANG);

Line 486: LAST_UPDATED_BY = AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER),

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),
486: LAST_UPDATED_BY = AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER),
487: LAST_UPDATE_LOGIN = 0
488: where AATTL.ACTION_TYPE_ID = X_ACTION_TYPE_ID
489: and userenv('LANG') in (AATTL.LANGUAGE,AATTL.SOURCE_LANG);
490: end if;