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_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: procedure KEY_TO_IDS (

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: procedure KEY_TO_IDS (
15: X_ACTION_TYPE_NAME in VARCHAR2,

Line 112: return AME_SEED_UTILITY.MERGE_ROW_TEST

108: begin
109: if X_CUSTOM_MODE = 'FORCE' then
110: return true;
111: end if;
112: return AME_SEED_UTILITY.MERGE_ROW_TEST
113: (X_OWNER => X_OWNER
114: ,X_CURRENT_OWNER => X_CURRENT_OWNER
115: ,X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE
116: ,X_CURRENT_LAST_UPDATE_DATE => X_CURRENT_LAST_UPDATE_DATE

Line 131: if AME_SEED_UTILITY.IS_SEED_USER(X_CREATED_BY) then

127: begin
128: if X_CUSTOM_MODE = 'FORCE' then
129: return true;
130: end if;
131: if AME_SEED_UTILITY.IS_SEED_USER(X_CREATED_BY) then
132: return true;
133: else
134: return AME_SEED_UTILITY.TL_MERGE_ROW_TEST
135: (X_OWNER => X_OWNER

Line 134: return AME_SEED_UTILITY.TL_MERGE_ROW_TEST

130: end if;
131: if AME_SEED_UTILITY.IS_SEED_USER(X_CREATED_BY) then
132: return true;
133: else
134: return AME_SEED_UTILITY.TL_MERGE_ROW_TEST
135: (X_OWNER => X_OWNER
136: ,X_CURRENT_OWNER => X_CURRENT_OWNER
137: ,X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE
138: ,X_CURRENT_LAST_UPDATE_DATE => X_CURRENT_LAST_UPDATE_DATE

Line 186: AME_SEED_UTILITY.GET_DEFAULT_END_DATE,

182: X_LAST_UPDATED_BY,
183: X_LAST_UPDATE_DATE,
184: X_LAST_UPDATE_LOGIN,
185: X_START_DATE,
186: AME_SEED_UTILITY.GET_DEFAULT_END_DATE,
187: X_DESCRIPTION,
188: X_OBJECT_VERSION_NUMBER);
189: end INSERT_ROW;
190:

Line 200: if not AME_SEED_UTILITY.MLS_ENABLED then

196: X_LAST_UPDATED_BY in NUMBER,
197: X_LAST_UPDATE_DATE in DATE,
198: X_LAST_UPDATE_LOGIN in NUMBER) is
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

Line 242: if not AME_SEED_UTILITY.MLS_ENABLED then

238: X_CUSTOM_MODE in VARCHAR2) is
239: X_CURRENT_OWNER NUMBER;
240: X_CURRENT_LAST_UPDATE_DATE DATE;
241: begin
242: if not AME_SEED_UTILITY.MLS_ENABLED then
243: return;
244: end if;
245:
246: select LAST_UPDATED_BY,

Line 257: ,AME_SEED_UTILITY.DATE_AS_STRING(X_LAST_UPDATE_DATE)

253:
254: if DO_UPDATE_INSERT
255: (X_LAST_UPDATED_BY
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),

Line 258: ,AME_SEED_UTILITY.DATE_AS_STRING(X_CURRENT_LAST_UPDATE_DATE)

254: if DO_UPDATE_INSERT
255: (X_LAST_UPDATED_BY
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'),

Line 314: if AME_SEED_UTILITY.MLS_ENABLED then

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

Line 410: AME_SEED_UTILITY.GET_DEFAULT_END_DATE,

406: X_LAST_UPDATED_BY,
407: to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),
408: X_LAST_UPDATE_LOGIN,
409: to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),
410: AME_SEED_UTILITY.GET_DEFAULT_END_DATE,
411: X_CURRENT_OVN + 1
412: );
413: UPDATE_TL_ROW
414: (

Line 427: if DO_UPDATE_INSERT(AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER),

423: );
424: else
425: -- the current row was found end date the current row
426: -- insert a row with the same action type id
427: if DO_UPDATE_INSERT(AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER),
428: X_CURRENT_OWNER,
429: X_LAST_UPDATE_DATE,
430: X_CURRENT_LAST_UPDATE_DATE) then
431: UPDATE_ROW (

Line 504: if not AME_SEED_UTILITY.MLS_ENABLED then

500: X_ACTION_ID number;
501: X_APPROVAL_GROUP_ID number;
502: X_TEMP_PARAMETER varchar2(320);
503: begin
504: if not AME_SEED_UTILITY.MLS_ENABLED then
505: return;
506: end if;
507: begin
508: X_TEMP_PARAMETER := X_PARAMETER;

Line 525: AME_SEED_UTILITY.DATE_AS_STRING(ACTTL.LAST_UPDATE_DATE),

521: null;
522: end;
523: end if;
524: select ACTTL.LAST_UPDATED_BY,
525: AME_SEED_UTILITY.DATE_AS_STRING(ACTTL.LAST_UPDATE_DATE),
526: AME_SEED_UTILITY.OWNER_AS_STRING(ACTTL.CREATED_BY),
527: ACT.ACTION_ID
528: into X_CURRENT_OWNER,
529: X_CURRENT_LAST_UPDATE_DATE,

Line 526: AME_SEED_UTILITY.OWNER_AS_STRING(ACTTL.CREATED_BY),

522: end;
523: end if;
524: select ACTTL.LAST_UPDATED_BY,
525: AME_SEED_UTILITY.DATE_AS_STRING(ACTTL.LAST_UPDATE_DATE),
526: AME_SEED_UTILITY.OWNER_AS_STRING(ACTTL.CREATED_BY),
527: ACT.ACTION_ID
528: into X_CURRENT_OWNER,
529: X_CURRENT_LAST_UPDATE_DATE,
530: X_CREATED_BY,

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

554: )
555: )
556: );
557: if DO_TL_UPDATE_INSERT
558: (X_OWNER => AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER),
559: X_CURRENT_OWNER => X_CURRENT_OWNER,
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,

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

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),
569: LAST_UPDATE_LOGIN = 0
570: where ACTTL.ACTION_ID = X_ACTION_ID
571: and userenv('LANG') in (ACTTL.LANGUAGE,ACTTL.SOURCE_LANG);

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

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),
569: LAST_UPDATE_LOGIN = 0
570: where ACTTL.ACTION_ID = X_ACTION_ID
571: and userenv('LANG') in (ACTTL.LANGUAGE,ACTTL.SOURCE_LANG);
572: end if;