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_SEED_UTILITY dependencies on AME_UTIL

Line 202: ame_util.runtimeException('ame_seed_utility',

198: end loop;
199: return(NEW_USE_COUNT);
200: exception
201: when others then
202: ame_util.runtimeException('ame_seed_utility',
203: 'calculate_use_count',
204: sqlcode,
205: sqlerrm);
206: raise;

Line 232: AME_CONDITIONS.CONDITION_TYPE in (AME_UTIL.ORDINARYCONDITIONTYPE,

228: select AME_CONDITIONS.ATTRIBUTE_ID
229: from AME_CONDITIONS,
230: AME_CONDITION_USAGES
231: where
232: AME_CONDITIONS.CONDITION_TYPE in (AME_UTIL.ORDINARYCONDITIONTYPE,
233: AME_UTIL.EXCEPTIONCONDITIONTYPE) and
234: AME_CONDITION_USAGES.RULE_ID = X_RULE_ID and
235: AME_CONDITION_USAGES.CONDITION_ID = AME_CONDITIONS.CONDITION_ID and
236: (AME_CONDITIONS.START_DATE <= sysdate and

Line 233: AME_UTIL.EXCEPTIONCONDITIONTYPE) and

229: from AME_CONDITIONS,
230: AME_CONDITION_USAGES
231: where
232: AME_CONDITIONS.CONDITION_TYPE in (AME_UTIL.ORDINARYCONDITIONTYPE,
233: AME_UTIL.EXCEPTIONCONDITIONTYPE) and
234: AME_CONDITION_USAGES.RULE_ID = X_RULE_ID and
235: AME_CONDITION_USAGES.CONDITION_ID = AME_CONDITIONS.CONDITION_ID and
236: (AME_CONDITIONS.START_DATE <= sysdate and
237: (AME_CONDITIONS.END_DATE is null or sysdate < AME_CONDITIONS.END_DATE)) and

Line 280: ATTRIBUTE_IDS_LIST ame_util.idList;

276: AME_RULES.START_DATE < nvl(AME_RULES.END_DATE,AME_RULES.START_DATE
277: + (1/86400)))) and
278: (AME_ACTIONS.START_DATE <= sysdate and
279: (AME_ACTIONS.END_DATE is null or sysdate < AME_ACTIONS.END_DATE));
280: ATTRIBUTE_IDS_LIST ame_util.idList;
281: X_USE_COUNT ame_attribute_usages.use_count%type;
282: begin
283: for ATTRIBUTE_REC in GET_USED_ATTRIBUTES(X_RULE_ID => X_RULE_ID) loop
284: -- calculate use count

Line 348: AND RULE_TYPE = AME_UTIL.AUTHORITYRULETYPE;

344: SELECT NULL
345: FROM AME_ACTION_TYPE_USAGES
346: WHERE ACTION_TYPE_ID = X_ACTION_TYPE_ID
347: AND SYSDATE BETWEEN START_DATE AND NVL(END_DATE,SYSDATE)
348: AND RULE_TYPE = AME_UTIL.AUTHORITYRULETYPE;
349: X_DUMMY VARCHAR2(10);
350: X_ORDER_NUMBER INTEGER;
351: X_GROUP_BASED_ACTION VARCHAR2(1);
352: X_VOTING_REGIME VARCHAR2(1);

Line 371: X_VOTING_REGIME := AME_UTIL.SERIALIZEDVOTING;

367: FETCH COA_ACTION_TYPE_CURSOR INTO X_VOTING_REGIME;
368: IF COA_ACTION_TYPE_CURSOR%NOTFOUND THEN
369: X_VOTING_REGIME := NULL;
370: ELSE
371: X_VOTING_REGIME := AME_UTIL.SERIALIZEDVOTING;
372: END IF;
373: CLOSE COA_ACTION_TYPE_CURSOR;
374:
375: OPEN GROUP_ACTION_TYPE_CURSOR;

Line 412: AME_UTIL.PREAPPROVALTYPENAME, 1,

408: IF X_ORDER_NUMBER IS NULL THEN
409: X_ORDER_NUMBER := 1;
410: END IF;
411: SELECT DECODE (X_ACTION_TYPE_NAME,
412: AME_UTIL.PREAPPROVALTYPENAME, 1,
413: AME_UTIL.DYNAMICPREAPPROVER, 2,
414: AME_UTIL.ABSOLUTEJOBLEVELTYPENAME, 1,
415: AME_UTIL.RELATIVEJOBLEVELTYPENAME, 2,
416: AME_UTIL.SUPERVISORYLEVELTYPENAME, 3,

Line 413: AME_UTIL.DYNAMICPREAPPROVER, 2,

409: X_ORDER_NUMBER := 1;
410: END IF;
411: SELECT DECODE (X_ACTION_TYPE_NAME,
412: AME_UTIL.PREAPPROVALTYPENAME, 1,
413: AME_UTIL.DYNAMICPREAPPROVER, 2,
414: AME_UTIL.ABSOLUTEJOBLEVELTYPENAME, 1,
415: AME_UTIL.RELATIVEJOBLEVELTYPENAME, 2,
416: AME_UTIL.SUPERVISORYLEVELTYPENAME, 3,
417: AME_UTIL.POSITIONTYPENAME, 4,

Line 414: AME_UTIL.ABSOLUTEJOBLEVELTYPENAME, 1,

410: END IF;
411: SELECT DECODE (X_ACTION_TYPE_NAME,
412: AME_UTIL.PREAPPROVALTYPENAME, 1,
413: AME_UTIL.DYNAMICPREAPPROVER, 2,
414: AME_UTIL.ABSOLUTEJOBLEVELTYPENAME, 1,
415: AME_UTIL.RELATIVEJOBLEVELTYPENAME, 2,
416: AME_UTIL.SUPERVISORYLEVELTYPENAME, 3,
417: AME_UTIL.POSITIONTYPENAME, 4,
418: AME_UTIL.POSITIONLEVELTYPENAME, 5,

Line 415: AME_UTIL.RELATIVEJOBLEVELTYPENAME, 2,

411: SELECT DECODE (X_ACTION_TYPE_NAME,
412: AME_UTIL.PREAPPROVALTYPENAME, 1,
413: AME_UTIL.DYNAMICPREAPPROVER, 2,
414: AME_UTIL.ABSOLUTEJOBLEVELTYPENAME, 1,
415: AME_UTIL.RELATIVEJOBLEVELTYPENAME, 2,
416: AME_UTIL.SUPERVISORYLEVELTYPENAME, 3,
417: AME_UTIL.POSITIONTYPENAME, 4,
418: AME_UTIL.POSITIONLEVELTYPENAME, 5,
419: AME_UTIL.MANAGERFINALAPPROVERTYPENAME, 6,

Line 416: AME_UTIL.SUPERVISORYLEVELTYPENAME, 3,

412: AME_UTIL.PREAPPROVALTYPENAME, 1,
413: AME_UTIL.DYNAMICPREAPPROVER, 2,
414: AME_UTIL.ABSOLUTEJOBLEVELTYPENAME, 1,
415: AME_UTIL.RELATIVEJOBLEVELTYPENAME, 2,
416: AME_UTIL.SUPERVISORYLEVELTYPENAME, 3,
417: AME_UTIL.POSITIONTYPENAME, 4,
418: AME_UTIL.POSITIONLEVELTYPENAME, 5,
419: AME_UTIL.MANAGERFINALAPPROVERTYPENAME, 6,
420: AME_UTIL.FINALAPPROVERONLYTYPENAME, 7,

Line 417: AME_UTIL.POSITIONTYPENAME, 4,

413: AME_UTIL.DYNAMICPREAPPROVER, 2,
414: AME_UTIL.ABSOLUTEJOBLEVELTYPENAME, 1,
415: AME_UTIL.RELATIVEJOBLEVELTYPENAME, 2,
416: AME_UTIL.SUPERVISORYLEVELTYPENAME, 3,
417: AME_UTIL.POSITIONTYPENAME, 4,
418: AME_UTIL.POSITIONLEVELTYPENAME, 5,
419: AME_UTIL.MANAGERFINALAPPROVERTYPENAME, 6,
420: AME_UTIL.FINALAPPROVERONLYTYPENAME, 7,
421: AME_UTIL.LINEITEMJOBLEVELTYPENAME, 8,

Line 418: AME_UTIL.POSITIONLEVELTYPENAME, 5,

414: AME_UTIL.ABSOLUTEJOBLEVELTYPENAME, 1,
415: AME_UTIL.RELATIVEJOBLEVELTYPENAME, 2,
416: AME_UTIL.SUPERVISORYLEVELTYPENAME, 3,
417: AME_UTIL.POSITIONTYPENAME, 4,
418: AME_UTIL.POSITIONLEVELTYPENAME, 5,
419: AME_UTIL.MANAGERFINALAPPROVERTYPENAME, 6,
420: AME_UTIL.FINALAPPROVERONLYTYPENAME, 7,
421: AME_UTIL.LINEITEMJOBLEVELTYPENAME, 8,
422: AME_UTIL.DUALCHAINSAUTHORITYTYPENAME, 9,

Line 419: AME_UTIL.MANAGERFINALAPPROVERTYPENAME, 6,

415: AME_UTIL.RELATIVEJOBLEVELTYPENAME, 2,
416: AME_UTIL.SUPERVISORYLEVELTYPENAME, 3,
417: AME_UTIL.POSITIONTYPENAME, 4,
418: AME_UTIL.POSITIONLEVELTYPENAME, 5,
419: AME_UTIL.MANAGERFINALAPPROVERTYPENAME, 6,
420: AME_UTIL.FINALAPPROVERONLYTYPENAME, 7,
421: AME_UTIL.LINEITEMJOBLEVELTYPENAME, 8,
422: AME_UTIL.DUALCHAINSAUTHORITYTYPENAME, 9,
423: AME_UTIL.GROUPCHAINAPPROVALTYPENAME, 10,

Line 420: AME_UTIL.FINALAPPROVERONLYTYPENAME, 7,

416: AME_UTIL.SUPERVISORYLEVELTYPENAME, 3,
417: AME_UTIL.POSITIONTYPENAME, 4,
418: AME_UTIL.POSITIONLEVELTYPENAME, 5,
419: AME_UTIL.MANAGERFINALAPPROVERTYPENAME, 6,
420: AME_UTIL.FINALAPPROVERONLYTYPENAME, 7,
421: AME_UTIL.LINEITEMJOBLEVELTYPENAME, 8,
422: AME_UTIL.DUALCHAINSAUTHORITYTYPENAME, 9,
423: AME_UTIL.GROUPCHAINAPPROVALTYPENAME, 10,
424: AME_UTIL.NONFINALAUTHORITY, 1,

Line 421: AME_UTIL.LINEITEMJOBLEVELTYPENAME, 8,

417: AME_UTIL.POSITIONTYPENAME, 4,
418: AME_UTIL.POSITIONLEVELTYPENAME, 5,
419: AME_UTIL.MANAGERFINALAPPROVERTYPENAME, 6,
420: AME_UTIL.FINALAPPROVERONLYTYPENAME, 7,
421: AME_UTIL.LINEITEMJOBLEVELTYPENAME, 8,
422: AME_UTIL.DUALCHAINSAUTHORITYTYPENAME, 9,
423: AME_UTIL.GROUPCHAINAPPROVALTYPENAME, 10,
424: AME_UTIL.NONFINALAUTHORITY, 1,
425: AME_UTIL.FINALAUTHORITYTYPENAME, 2,

Line 422: AME_UTIL.DUALCHAINSAUTHORITYTYPENAME, 9,

418: AME_UTIL.POSITIONLEVELTYPENAME, 5,
419: AME_UTIL.MANAGERFINALAPPROVERTYPENAME, 6,
420: AME_UTIL.FINALAPPROVERONLYTYPENAME, 7,
421: AME_UTIL.LINEITEMJOBLEVELTYPENAME, 8,
422: AME_UTIL.DUALCHAINSAUTHORITYTYPENAME, 9,
423: AME_UTIL.GROUPCHAINAPPROVALTYPENAME, 10,
424: AME_UTIL.NONFINALAUTHORITY, 1,
425: AME_UTIL.FINALAUTHORITYTYPENAME, 2,
426: AME_UTIL.SUBSTITUTIONTYPENAME, 1,

Line 423: AME_UTIL.GROUPCHAINAPPROVALTYPENAME, 10,

419: AME_UTIL.MANAGERFINALAPPROVERTYPENAME, 6,
420: AME_UTIL.FINALAPPROVERONLYTYPENAME, 7,
421: AME_UTIL.LINEITEMJOBLEVELTYPENAME, 8,
422: AME_UTIL.DUALCHAINSAUTHORITYTYPENAME, 9,
423: AME_UTIL.GROUPCHAINAPPROVALTYPENAME, 10,
424: AME_UTIL.NONFINALAUTHORITY, 1,
425: AME_UTIL.FINALAUTHORITYTYPENAME, 2,
426: AME_UTIL.SUBSTITUTIONTYPENAME, 1,
427: AME_UTIL.POSTAPPROVALTYPENAME, 1,

Line 424: AME_UTIL.NONFINALAUTHORITY, 1,

420: AME_UTIL.FINALAPPROVERONLYTYPENAME, 7,
421: AME_UTIL.LINEITEMJOBLEVELTYPENAME, 8,
422: AME_UTIL.DUALCHAINSAUTHORITYTYPENAME, 9,
423: AME_UTIL.GROUPCHAINAPPROVALTYPENAME, 10,
424: AME_UTIL.NONFINALAUTHORITY, 1,
425: AME_UTIL.FINALAUTHORITYTYPENAME, 2,
426: AME_UTIL.SUBSTITUTIONTYPENAME, 1,
427: AME_UTIL.POSTAPPROVALTYPENAME, 1,
428: AME_UTIL.DYNAMICPOSTAPPROVER, 2,

Line 425: AME_UTIL.FINALAUTHORITYTYPENAME, 2,

421: AME_UTIL.LINEITEMJOBLEVELTYPENAME, 8,
422: AME_UTIL.DUALCHAINSAUTHORITYTYPENAME, 9,
423: AME_UTIL.GROUPCHAINAPPROVALTYPENAME, 10,
424: AME_UTIL.NONFINALAUTHORITY, 1,
425: AME_UTIL.FINALAUTHORITYTYPENAME, 2,
426: AME_UTIL.SUBSTITUTIONTYPENAME, 1,
427: AME_UTIL.POSTAPPROVALTYPENAME, 1,
428: AME_UTIL.DYNAMICPOSTAPPROVER, 2,
429: X_ORDER_NUMBER)

Line 426: AME_UTIL.SUBSTITUTIONTYPENAME, 1,

422: AME_UTIL.DUALCHAINSAUTHORITYTYPENAME, 9,
423: AME_UTIL.GROUPCHAINAPPROVALTYPENAME, 10,
424: AME_UTIL.NONFINALAUTHORITY, 1,
425: AME_UTIL.FINALAUTHORITYTYPENAME, 2,
426: AME_UTIL.SUBSTITUTIONTYPENAME, 1,
427: AME_UTIL.POSTAPPROVALTYPENAME, 1,
428: AME_UTIL.DYNAMICPOSTAPPROVER, 2,
429: X_ORDER_NUMBER)
430: INTO X_ACTION_TYPE_ORDER_NUMBER

Line 427: AME_UTIL.POSTAPPROVALTYPENAME, 1,

423: AME_UTIL.GROUPCHAINAPPROVALTYPENAME, 10,
424: AME_UTIL.NONFINALAUTHORITY, 1,
425: AME_UTIL.FINALAUTHORITYTYPENAME, 2,
426: AME_UTIL.SUBSTITUTIONTYPENAME, 1,
427: AME_UTIL.POSTAPPROVALTYPENAME, 1,
428: AME_UTIL.DYNAMICPOSTAPPROVER, 2,
429: X_ORDER_NUMBER)
430: INTO X_ACTION_TYPE_ORDER_NUMBER
431: FROM DUAL;

Line 428: AME_UTIL.DYNAMICPOSTAPPROVER, 2,

424: AME_UTIL.NONFINALAUTHORITY, 1,
425: AME_UTIL.FINALAUTHORITYTYPENAME, 2,
426: AME_UTIL.SUBSTITUTIONTYPENAME, 1,
427: AME_UTIL.POSTAPPROVALTYPENAME, 1,
428: AME_UTIL.DYNAMICPOSTAPPROVER, 2,
429: X_ORDER_NUMBER)
430: INTO X_ACTION_TYPE_ORDER_NUMBER
431: FROM DUAL;
432: DBMS_LOCK.ALLOCATE_UNIQUE (LOCKNAME =>'AME_ACTION_TYPE_CONFIG.'||X_APPLICATION_ID||X_ACTION_TYPE_ID

Line 455: ,AME_UTIL.SERIALCHAINSMODE

451: ) SELECT X_APPLICATION_ID
452: ,X_ACTION_TYPE_ID
453: ,X_VOTING_REGIME
454: ,X_ACTION_TYPE_ORDER_NUMBER
455: ,AME_UTIL.SERIALCHAINSMODE
456: ,X_ACA_START_DATE
457: ,X_ACA_END_DATE
458: ,X_ACA_CREATED_BY
459: ,X_ACA_CREATION_DATE

Line 511: ,AME_UTIL.ORDERNUMBERVOTING

507: ,LAST_UPDATE_LOGIN
508: ,OBJECT_VERSION_NUMBER
509: ) SELECT X_APPLICATION_ID
510: ,X_APPROVAL_GROUP_ID
511: ,AME_UTIL.ORDERNUMBERVOTING
512: ,X_ORDER_NUMBER
513: ,X_ACA_START_DATE
514: ,X_ACA_END_DATE
515: ,X_ACA_CREATED_BY