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_APPROVAL_GROUP_PKG dependencies on AME_ACTION_TYPES

Line 649: ame_action_types,

645: select count(*)
646: into useCount
647: from
648: ame_actions,
649: ame_action_types,
650: ame_action_usages
651: where
652: ame_actions.parameter = to_char(approvalGroupIdIn) and
653: ame_action_usages.action_id = ame_actions.action_id and

Line 654: ame_actions.action_type_id = ame_action_types.action_type_id and

650: ame_action_usages
651: where
652: ame_actions.parameter = to_char(approvalGroupIdIn) and
653: ame_action_usages.action_id = ame_actions.action_id and
654: ame_actions.action_type_id = ame_action_types.action_type_id and
655: ame_action_types.name in (ame_util.preApprovalTypeName,
656: ame_util.postApprovalTypeName,
657: ame_util.groupChainApprovalTypeName) and
658: sysdate between ame_actions.start_date and

Line 655: ame_action_types.name in (ame_util.preApprovalTypeName,

651: where
652: ame_actions.parameter = to_char(approvalGroupIdIn) and
653: ame_action_usages.action_id = ame_actions.action_id and
654: ame_actions.action_type_id = ame_action_types.action_type_id and
655: ame_action_types.name in (ame_util.preApprovalTypeName,
656: ame_util.postApprovalTypeName,
657: ame_util.groupChainApprovalTypeName) and
658: sysdate between ame_actions.start_date and
659: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate) and

Line 660: sysdate between ame_action_types.start_date and

656: ame_util.postApprovalTypeName,
657: ame_util.groupChainApprovalTypeName) and
658: sysdate between ame_actions.start_date and
659: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate) and
660: sysdate between ame_action_types.start_date and
661: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
662: ((sysdate between ame_action_usages.start_date and
663: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate)) or
664: (sysdate < ame_action_usages.start_date and

Line 661: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and

657: ame_util.groupChainApprovalTypeName) and
658: sysdate between ame_actions.start_date and
659: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate) and
660: sysdate between ame_action_types.start_date and
661: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
662: ((sysdate between ame_action_usages.start_date and
663: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate)) or
664: (sysdate < ame_action_usages.start_date and
665: ame_action_usages.start_date < nvl(ame_action_usages.end_date,

Line 751: actionTypeId ame_action_types.action_type_id%type;

747: finalizeIn in boolean default false,
748: updateActionIn in boolean default false) return integer as
749: approvalGroupId integer;
750: actionId ame_actions.action_id%type;
751: actionTypeId ame_action_types.action_type_id%type;
752: actionDescription ame_actions.description%type;
753: createdBy integer;
754: currentUserId integer;
755: descriptionLengthException exception;