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

Line 498: where name = ame_util.rejectionResponseAttribute

494: -- REJECTION_RESPONSE
495: cursor getRejectionAttributeId is
496: select attribute_id
497: from ame_attributes
498: where name = ame_util.rejectionResponseAttribute
499: and (sysdate between start_date
500: and nvl(end_date - (1/86400),sysdate));
501: -- USE_WORKFLOW
502: cursor getUseWorkflowId is

Line 505: where name = ame_util.useWorkflowAttribute

501: -- USE_WORKFLOW
502: cursor getUseWorkflowId is
503: select attribute_id
504: from ame_attributes
505: where name = ame_util.useWorkflowAttribute
506: and (sysdate between start_date
507: and nvl(end_date - (1/86400),sysdate));
508: --REPEAT_SUBSTITUTIONS
509: cursor getRepeatSubAttributeId is

Line 546: ame_util.orderNumberVoting,

542: end_date,
543: object_version_number)
544: select X_APPLICATION_ID,
545: groupsRec.approval_group_id,
546: ame_util.orderNumberVoting,
547: groupOrderNumber,
548: x_created_by,
549: sysdate,
550: x_created_by,

Line 573: and rule_type = ame_util.authorityRuleType;

569: select count(*)
570: into authorityRuleTypeCount
571: from ame_action_type_usages
572: where action_type_id = actionRec.action_type_id
573: and rule_type = ame_util.authorityRuleType;
574: if authorityRuleTypeCount > 0 then
575: votingRegimeValue := ame_util.serializedVoting;
576: else
577: votingRegimeValue := null;

Line 575: votingRegimeValue := ame_util.serializedVoting;

571: from ame_action_type_usages
572: where action_type_id = actionRec.action_type_id
573: and rule_type = ame_util.authorityRuleType;
574: if authorityRuleTypeCount > 0 then
575: votingRegimeValue := ame_util.serializedVoting;
576: else
577: votingRegimeValue := null;
578: end if;
579: if actionRec.created_by <> ame_util.seededDataCreatedById then

Line 579: if actionRec.created_by <> ame_util.seededDataCreatedById then

575: votingRegimeValue := ame_util.serializedVoting;
576: else
577: votingRegimeValue := null;
578: end if;
579: if actionRec.created_by <> ame_util.seededDataCreatedById then
580: customOrderNumber := customOrderNumber + 1;
581: end if;
582: insert into ame_action_type_config
583: (application_id,

Line 601: ame_util.preApprovalTypeName, 1,

597: X_APPLICATION_ID,
598: actionRec.action_type_id,
599: votingRegimeValue,
600: decode(actionRec.name,
601: ame_util.preApprovalTypeName, 1,
602: ame_util.dynamicPreApprover, 2,
603: ame_util.absoluteJobLevelTypeName, 1,
604: ame_util.relativeJobLevelTypeName, 2,
605: ame_util.supervisoryLevelTypeName, 3,

Line 602: ame_util.dynamicPreApprover, 2,

598: actionRec.action_type_id,
599: votingRegimeValue,
600: decode(actionRec.name,
601: ame_util.preApprovalTypeName, 1,
602: ame_util.dynamicPreApprover, 2,
603: ame_util.absoluteJobLevelTypeName, 1,
604: ame_util.relativeJobLevelTypeName, 2,
605: ame_util.supervisoryLevelTypeName, 3,
606: ame_util.positionTypeName, 4,

Line 603: ame_util.absoluteJobLevelTypeName, 1,

599: votingRegimeValue,
600: decode(actionRec.name,
601: ame_util.preApprovalTypeName, 1,
602: ame_util.dynamicPreApprover, 2,
603: ame_util.absoluteJobLevelTypeName, 1,
604: ame_util.relativeJobLevelTypeName, 2,
605: ame_util.supervisoryLevelTypeName, 3,
606: ame_util.positionTypeName, 4,
607: ame_util.positionLevelTypeName, 5,

Line 604: ame_util.relativeJobLevelTypeName, 2,

600: decode(actionRec.name,
601: ame_util.preApprovalTypeName, 1,
602: ame_util.dynamicPreApprover, 2,
603: ame_util.absoluteJobLevelTypeName, 1,
604: ame_util.relativeJobLevelTypeName, 2,
605: ame_util.supervisoryLevelTypeName, 3,
606: ame_util.positionTypeName, 4,
607: ame_util.positionLevelTypeName, 5,
608: ame_util.managerFinalApproverTypeName, 6,

Line 605: ame_util.supervisoryLevelTypeName, 3,

601: ame_util.preApprovalTypeName, 1,
602: ame_util.dynamicPreApprover, 2,
603: ame_util.absoluteJobLevelTypeName, 1,
604: ame_util.relativeJobLevelTypeName, 2,
605: ame_util.supervisoryLevelTypeName, 3,
606: ame_util.positionTypeName, 4,
607: ame_util.positionLevelTypeName, 5,
608: ame_util.managerFinalApproverTypeName, 6,
609: ame_util.finalApproverOnlyTypeName, 7,

Line 606: ame_util.positionTypeName, 4,

602: ame_util.dynamicPreApprover, 2,
603: ame_util.absoluteJobLevelTypeName, 1,
604: ame_util.relativeJobLevelTypeName, 2,
605: ame_util.supervisoryLevelTypeName, 3,
606: ame_util.positionTypeName, 4,
607: ame_util.positionLevelTypeName, 5,
608: ame_util.managerFinalApproverTypeName, 6,
609: ame_util.finalApproverOnlyTypeName, 7,
610: ame_util.lineItemJobLevelTypeName, 8,

Line 607: ame_util.positionLevelTypeName, 5,

603: ame_util.absoluteJobLevelTypeName, 1,
604: ame_util.relativeJobLevelTypeName, 2,
605: ame_util.supervisoryLevelTypeName, 3,
606: ame_util.positionTypeName, 4,
607: ame_util.positionLevelTypeName, 5,
608: ame_util.managerFinalApproverTypeName, 6,
609: ame_util.finalApproverOnlyTypeName, 7,
610: ame_util.lineItemJobLevelTypeName, 8,
611: ame_util.dualChainsAuthorityTypeName, 9,

Line 608: ame_util.managerFinalApproverTypeName, 6,

604: ame_util.relativeJobLevelTypeName, 2,
605: ame_util.supervisoryLevelTypeName, 3,
606: ame_util.positionTypeName, 4,
607: ame_util.positionLevelTypeName, 5,
608: ame_util.managerFinalApproverTypeName, 6,
609: ame_util.finalApproverOnlyTypeName, 7,
610: ame_util.lineItemJobLevelTypeName, 8,
611: ame_util.dualChainsAuthorityTypeName, 9,
612: ame_util.groupChainApprovalTypeName, 10,

Line 609: ame_util.finalApproverOnlyTypeName, 7,

605: ame_util.supervisoryLevelTypeName, 3,
606: ame_util.positionTypeName, 4,
607: ame_util.positionLevelTypeName, 5,
608: ame_util.managerFinalApproverTypeName, 6,
609: ame_util.finalApproverOnlyTypeName, 7,
610: ame_util.lineItemJobLevelTypeName, 8,
611: ame_util.dualChainsAuthorityTypeName, 9,
612: ame_util.groupChainApprovalTypeName, 10,
613: ame_util.nonFinalAuthority, 1,

Line 610: ame_util.lineItemJobLevelTypeName, 8,

606: ame_util.positionTypeName, 4,
607: ame_util.positionLevelTypeName, 5,
608: ame_util.managerFinalApproverTypeName, 6,
609: ame_util.finalApproverOnlyTypeName, 7,
610: ame_util.lineItemJobLevelTypeName, 8,
611: ame_util.dualChainsAuthorityTypeName, 9,
612: ame_util.groupChainApprovalTypeName, 10,
613: ame_util.nonFinalAuthority, 1,
614: ame_util.finalAuthorityTypeName, 2,

Line 611: ame_util.dualChainsAuthorityTypeName, 9,

607: ame_util.positionLevelTypeName, 5,
608: ame_util.managerFinalApproverTypeName, 6,
609: ame_util.finalApproverOnlyTypeName, 7,
610: ame_util.lineItemJobLevelTypeName, 8,
611: ame_util.dualChainsAuthorityTypeName, 9,
612: ame_util.groupChainApprovalTypeName, 10,
613: ame_util.nonFinalAuthority, 1,
614: ame_util.finalAuthorityTypeName, 2,
615: ame_util.substitutionTypeName, 1,

Line 612: ame_util.groupChainApprovalTypeName, 10,

608: ame_util.managerFinalApproverTypeName, 6,
609: ame_util.finalApproverOnlyTypeName, 7,
610: ame_util.lineItemJobLevelTypeName, 8,
611: ame_util.dualChainsAuthorityTypeName, 9,
612: ame_util.groupChainApprovalTypeName, 10,
613: ame_util.nonFinalAuthority, 1,
614: ame_util.finalAuthorityTypeName, 2,
615: ame_util.substitutionTypeName, 1,
616: ame_util.postApprovalTypeName, 1,

Line 613: ame_util.nonFinalAuthority, 1,

609: ame_util.finalApproverOnlyTypeName, 7,
610: ame_util.lineItemJobLevelTypeName, 8,
611: ame_util.dualChainsAuthorityTypeName, 9,
612: ame_util.groupChainApprovalTypeName, 10,
613: ame_util.nonFinalAuthority, 1,
614: ame_util.finalAuthorityTypeName, 2,
615: ame_util.substitutionTypeName, 1,
616: ame_util.postApprovalTypeName, 1,
617: ame_util.dynamicPostApprover, 2,

Line 614: ame_util.finalAuthorityTypeName, 2,

610: ame_util.lineItemJobLevelTypeName, 8,
611: ame_util.dualChainsAuthorityTypeName, 9,
612: ame_util.groupChainApprovalTypeName, 10,
613: ame_util.nonFinalAuthority, 1,
614: ame_util.finalAuthorityTypeName, 2,
615: ame_util.substitutionTypeName, 1,
616: ame_util.postApprovalTypeName, 1,
617: ame_util.dynamicPostApprover, 2,
618: customOrderNumber),

Line 615: ame_util.substitutionTypeName, 1,

611: ame_util.dualChainsAuthorityTypeName, 9,
612: ame_util.groupChainApprovalTypeName, 10,
613: ame_util.nonFinalAuthority, 1,
614: ame_util.finalAuthorityTypeName, 2,
615: ame_util.substitutionTypeName, 1,
616: ame_util.postApprovalTypeName, 1,
617: ame_util.dynamicPostApprover, 2,
618: customOrderNumber),
619: ame_util.serialChainsMode,

Line 616: ame_util.postApprovalTypeName, 1,

612: ame_util.groupChainApprovalTypeName, 10,
613: ame_util.nonFinalAuthority, 1,
614: ame_util.finalAuthorityTypeName, 2,
615: ame_util.substitutionTypeName, 1,
616: ame_util.postApprovalTypeName, 1,
617: ame_util.dynamicPostApprover, 2,
618: customOrderNumber),
619: ame_util.serialChainsMode,
620: actionRec.created_by,

Line 617: ame_util.dynamicPostApprover, 2,

613: ame_util.nonFinalAuthority, 1,
614: ame_util.finalAuthorityTypeName, 2,
615: ame_util.substitutionTypeName, 1,
616: ame_util.postApprovalTypeName, 1,
617: ame_util.dynamicPostApprover, 2,
618: customOrderNumber),
619: ame_util.serialChainsMode,
620: actionRec.created_by,
621: sysdate,

Line 619: ame_util.serialChainsMode,

615: ame_util.substitutionTypeName, 1,
616: ame_util.postApprovalTypeName, 1,
617: ame_util.dynamicPostApprover, 2,
618: customOrderNumber),
619: ame_util.serialChainsMode,
620: actionRec.created_by,
621: sysdate,
622: actionRec.last_updated_by,
623: sysdate,

Line 664: ame_util.stopAllItems,

660: )
661: select
662: X_REJECTION_RESPONSE_ID,
663: X_APPLICATION_ID,
664: ame_util.stopAllItems,
665: 0,
666: ame_util.booleanTrue,
667: x_created_by,
668: to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),

Line 666: ame_util.booleanTrue,

662: X_REJECTION_RESPONSE_ID,
663: X_APPLICATION_ID,
664: ame_util.stopAllItems,
665: 0,
666: ame_util.booleanTrue,
667: x_created_by,
668: to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),
669: x_created_by,
670: to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),

Line 674: ame_util.booleanTrue,

670: to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),
671: 0,
672: to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),
673: AME_SEED_UTILITY.GET_DEFAULT_END_DATE,
674: ame_util.booleanTrue,
675: null,
676: 1
677: from sys.dual
678: where not exists

Line 711: ame_util.booleanAttributeTrue,

707: )
708: select
709: X_USE_WORKFLOW_ID,
710: X_APPLICATION_ID,
711: ame_util.booleanAttributeTrue,
712: 0,
713: ame_util.booleanTrue,
714: x_created_by,
715: to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),

Line 713: ame_util.booleanTrue,

709: X_USE_WORKFLOW_ID,
710: X_APPLICATION_ID,
711: ame_util.booleanAttributeTrue,
712: 0,
713: ame_util.booleanTrue,
714: x_created_by,
715: to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),
716: x_created_by,
717: to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),

Line 721: ame_util.booleanTrue,

717: to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),
718: 0,
719: to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),
720: AME_SEED_UTILITY.GET_DEFAULT_END_DATE,
721: ame_util.booleanTrue,
722: null,
723: 1
724: from sys.dual
725: where not exists

Line 760: ame_util.booleanAttributeFalse,

756: )
757: select
758: X_REPEAT_SUBSTITUTIONS_ID,
759: X_APPLICATION_ID,
760: ame_util.booleanAttributeFalse,
761: 0,
762: ame_util.booleanTrue,
763: x_created_by,
764: to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),

Line 762: ame_util.booleanTrue,

758: X_REPEAT_SUBSTITUTIONS_ID,
759: X_APPLICATION_ID,
760: ame_util.booleanAttributeFalse,
761: 0,
762: ame_util.booleanTrue,
763: x_created_by,
764: to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),
765: x_created_by,
766: to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),

Line 770: ame_util.booleanTrue,

766: to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),
767: 0,
768: to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),
769: AME_SEED_UTILITY.GET_DEFAULT_END_DATE,
770: ame_util.booleanTrue,
771: null,
772: 1
773: from sys.dual
774: where not exists

Line 1038: ame_util.runtimeException('ame_calling_apps_api',

1034: end if;
1035: end;
1036: exception
1037: when others then
1038: ame_util.runtimeException('ame_calling_apps_api',
1039: 'load_row',
1040: sqlcode,
1041: sqlerrm);
1042: raise;