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_USAGES_API2 dependencies on AME_SEED_UTILITY

Line 105: AME_SEED_UTILITY.CHANGE_ATTRIBUTE_USAGES_COUNT(X_RULE_ID => X_RULE_ID

101: and sysdate between ARU.START_DATE
102: and nvl(ARU.END_DATE - (1/86400), sysdate);
103: begin
104: for TEMP_APPLICATION_ID in CSR_GET_ITEM_IDS(X_RULE_ID => X_RULE_ID) loop
105: AME_SEED_UTILITY.CHANGE_ATTRIBUTE_USAGES_COUNT(X_RULE_ID => X_RULE_ID
106: ,X_APPLICATION_ID => TEMP_APPLICATION_ID.APPLICATION_ID
107: );
108: end loop;
109: end CHANGE_RULE_ATTR_USE_COUNT;

Line 281: L_END_DATE := AME_SEED_UTILITY.GET_DEFAULT_END_DATE;

277: L_PARAMETER := X_PARAMETER;
278: L_PARAMETER_TWO := X_PARAMETER_TWO;
279: L_OWNER := X_OWNER;
280: L_LAST_UPDATE_DATE := X_LAST_UPDATE_DATE;
281: L_END_DATE := AME_SEED_UTILITY.GET_DEFAULT_END_DATE;
282:
283: VALIDATE_ROW
284: (X_RULE_KEY => L_RULE_KEY);
285:

Line 315: ,X_CREATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)

311:
312: if X_CUSTOM_MODE = 'FORCE' then
313: FORCE_UPDATE_ROW
314: (X_ROWID => L_ROWID
315: ,X_CREATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)
316: ,X_CREATION_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
317: ,X_LAST_UPDATE_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
318: ,X_LAST_UPDATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)
319: ,X_LAST_UPDATE_LOGIN => 0

Line 316: ,X_CREATION_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)

312: if X_CUSTOM_MODE = 'FORCE' then
313: FORCE_UPDATE_ROW
314: (X_ROWID => L_ROWID
315: ,X_CREATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)
316: ,X_CREATION_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
317: ,X_LAST_UPDATE_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
318: ,X_LAST_UPDATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)
319: ,X_LAST_UPDATE_LOGIN => 0
320: ,X_START_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)

Line 317: ,X_LAST_UPDATE_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)

313: FORCE_UPDATE_ROW
314: (X_ROWID => L_ROWID
315: ,X_CREATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)
316: ,X_CREATION_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
317: ,X_LAST_UPDATE_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
318: ,X_LAST_UPDATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)
319: ,X_LAST_UPDATE_LOGIN => 0
320: ,X_START_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
321: ,X_END_DATE => L_END_DATE

Line 318: ,X_LAST_UPDATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)

314: (X_ROWID => L_ROWID
315: ,X_CREATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)
316: ,X_CREATION_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
317: ,X_LAST_UPDATE_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
318: ,X_LAST_UPDATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)
319: ,X_LAST_UPDATE_LOGIN => 0
320: ,X_START_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
321: ,X_END_DATE => L_END_DATE
322: ,X_OBJECT_VERSION_NUMBER => L_OBJECT_VERSION_NUMBER + 1

Line 320: ,X_START_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)

316: ,X_CREATION_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
317: ,X_LAST_UPDATE_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
318: ,X_LAST_UPDATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)
319: ,X_LAST_UPDATE_LOGIN => 0
320: ,X_START_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
321: ,X_END_DATE => L_END_DATE
322: ,X_OBJECT_VERSION_NUMBER => L_OBJECT_VERSION_NUMBER + 1
323: );
324: end if;

Line 339: ,X_START_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)

335: if L_ACTION_USAGES_COUNT = 0 then
336: INSERT_ROW
337: (X_ACTION_ID => L_ACTION_ID
338: ,X_RULE_ID => L_RULE_ID
339: ,X_START_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
340: ,X_END_DATE => L_END_DATE
341: ,X_CREATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)
342: ,X_CREATION_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
343: ,X_LAST_UPDATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)

Line 341: ,X_CREATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)

337: (X_ACTION_ID => L_ACTION_ID
338: ,X_RULE_ID => L_RULE_ID
339: ,X_START_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
340: ,X_END_DATE => L_END_DATE
341: ,X_CREATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)
342: ,X_CREATION_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
343: ,X_LAST_UPDATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)
344: ,X_LAST_UPDATE_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
345: ,X_LAST_UPDATE_LOGIN => 0

Line 342: ,X_CREATION_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)

338: ,X_RULE_ID => L_RULE_ID
339: ,X_START_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
340: ,X_END_DATE => L_END_DATE
341: ,X_CREATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)
342: ,X_CREATION_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
343: ,X_LAST_UPDATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)
344: ,X_LAST_UPDATE_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
345: ,X_LAST_UPDATE_LOGIN => 0
346: ,X_OBJECT_VERSION_NUMBER => 1

Line 343: ,X_LAST_UPDATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)

339: ,X_START_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
340: ,X_END_DATE => L_END_DATE
341: ,X_CREATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)
342: ,X_CREATION_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
343: ,X_LAST_UPDATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)
344: ,X_LAST_UPDATE_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
345: ,X_LAST_UPDATE_LOGIN => 0
346: ,X_OBJECT_VERSION_NUMBER => 1
347: );

Line 344: ,X_LAST_UPDATE_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)

340: ,X_END_DATE => L_END_DATE
341: ,X_CREATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)
342: ,X_CREATION_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
343: ,X_LAST_UPDATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)
344: ,X_LAST_UPDATE_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
345: ,X_LAST_UPDATE_LOGIN => 0
346: ,X_OBJECT_VERSION_NUMBER => 1
347: );
348: AME_SEED_UTILITY.CREATE_PARALLEL_CONFIG

Line 348: AME_SEED_UTILITY.CREATE_PARALLEL_CONFIG

344: ,X_LAST_UPDATE_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
345: ,X_LAST_UPDATE_LOGIN => 0
346: ,X_OBJECT_VERSION_NUMBER => 1
347: );
348: AME_SEED_UTILITY.CREATE_PARALLEL_CONFIG
349: (L_ACTION_TYPE_ID
350: ,L_ACTION_TYPE_NAME
351: ,L_ACTION_ID
352: ,L_APPROVAL_GROUP_ID

Line 380: AME_SEED_UTILITY.DATE_AS_STRING(AAU.LAST_UPDATE_DATE) LAST_UPDATE_DATE

376: CUST.LAST_UPDATE_DATE
377: into X_CURRENT_OWNER,
378: X_CURRENT_LAST_UPDATE_DATE
379: from (select AAU.LAST_UPDATED_BY OWNER,
380: AME_SEED_UTILITY.DATE_AS_STRING(AAU.LAST_UPDATE_DATE) LAST_UPDATE_DATE
381: from AME_ACTIONS ACT,
382: AME_ACTION_TYPES AAT,
383: AME_RULES ARU,
384: AME_ACTION_USAGES AAU

Line 401: AME_SEED_UTILITY.DATE_AS_STRING(AAU.LAST_UPDATE_DATE) LAST_UPDATE_DATE

397: and sysdate between AAU.START_DATE and nvl(AAU.END_DATE - (1/86400),sysdate)
398: and sysdate between ARU.START_DATE and nvl(ARU.END_DATE - (1/86400),sysdate)
399: union
400: select AAU.LAST_UPDATED_BY OWNER,
401: AME_SEED_UTILITY.DATE_AS_STRING(AAU.LAST_UPDATE_DATE) LAST_UPDATE_DATE
402: from AME_ACTIONS ACT,
403: AME_ACTION_TYPES AAT,
404: AME_RULES ARU,
405: AME_ACTION_USAGES AAU,

Line 430: return AME_SEED_UTILITY.MERGE_ROW_TEST

426: when no_data_found then
427: return true;
428: end;
429: end if;
430: return AME_SEED_UTILITY.MERGE_ROW_TEST
431: (X_CURRENT_OWNER => X_CURRENT_OWNER
432: ,X_CURRENT_LAST_UPDATE_DATE => X_CURRENT_LAST_UPDATE_DATE
433: ,X_OWNER => AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER)
434: ,X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE

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

429: end if;
430: return AME_SEED_UTILITY.MERGE_ROW_TEST
431: (X_CURRENT_OWNER => X_CURRENT_OWNER
432: ,X_CURRENT_LAST_UPDATE_DATE => X_CURRENT_LAST_UPDATE_DATE
433: ,X_OWNER => AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER)
434: ,X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE
435: ,X_CUSTOM_MODE => X_CUSTOM_MODE
436: );
437: end MERGE_ROW_TEST;

Line 450: AME_SEED_UTILITY.INIT_AME_INSTALLATION_LEVEL;

446: ,X_UPLOAD_MODE in varchar2
447: ,X_CUSTOM_MODE in varchar2
448: ) as
449: begin
450: AME_SEED_UTILITY.INIT_AME_INSTALLATION_LEVEL;
451:
452: if AME_SEED_UTILITY.AME_INSTALLATION_LEVEL is null then
453: raise_application_error (-20001,'AME is trying to upload action usages to a 11.5.9 or lower instance');
454: end if;

Line 452: if AME_SEED_UTILITY.AME_INSTALLATION_LEVEL is null then

448: ) as
449: begin
450: AME_SEED_UTILITY.INIT_AME_INSTALLATION_LEVEL;
451:
452: if AME_SEED_UTILITY.AME_INSTALLATION_LEVEL is null then
453: raise_application_error (-20001,'AME is trying to upload action usages to a 11.5.9 or lower instance');
454: end if;
455:
456: if X_UPLOAD_MODE = 'NLS' then