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_ACTIONS

Line 648: ame_actions,

644: begin
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

Line 652: ame_actions.parameter = to_char(approvalGroupIdIn) and

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
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,

Line 653: ame_action_usages.action_id = ame_actions.action_id and

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
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

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 658: sysdate between ame_actions.start_date 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
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

Line 659: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate) 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
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

Line 750: actionId ame_actions.action_id%type;

746: approvalGroupIdIn in integer default null,
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;

Line 752: actionDescription ame_actions.description%type;

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;
756: endDate date;

Line 822: /* insert into ame_actions proper values for the approval group */

818: end if;
819: end if;
820: /* keeps this end date associated with the endDate from proc change */
821: endDate := nvl(newStartDateIn, sysdate) ;
822: /* insert into ame_actions proper values for the approval group */
823: if(approvalGroupIdIn is null or updateActionIn) then
824: for i in 1..3 loop
825: if i = 1 then
826: actionTypeId := ame_action_pkg.getPreApprovalActionTypeId;

Line 843: from ame_actions

839: ame_util.versionStringToDate(stringDateIn => ame_action_pkg.getParentVersionStartDate(actionTypeIdIn => actionTypeId));
840: end if;
841: if(updateActionIn) then
842: select action_id into actionId
843: from ame_actions
844: where
845: parameter = to_char(approvalGroupId) and
846: action_type_id = actionTypeId and
847: sysdate between start_date and

Line 850: update ame_actions

846: action_type_id = actionTypeId and
847: sysdate between start_date and
848: nvl(end_date - ame_util.oneSecond, sysdate)
849: for update of end_date;
850: update ame_actions
851: set
852: last_updated_by = currentUserId,
853: last_update_date = processingDate,
854: last_update_login = currentUserId,

Line 1510: update the ame_actions table. */

1506: else
1507: description := descriptionIn;
1508: end if;
1509: /* Check to see if name or description has changed. If so, need to
1510: update the ame_actions table. */
1511: if(nameIn <> getName(approvalGroupIdIn => approvalGroupIdIn)) then
1512: updateAction := true;
1513: else
1514: updateAction := false;

Line 2785: update ame_actions

2781: approval_group_id = approvalGroupIdIn and
2782: processingDate between start_date and
2783: nvl(end_date - ame_util.oneSecond, processingDate) ;
2784: /* End-date any related actions. */
2785: update ame_actions
2786: set
2787: last_updated_by = currentUserId,
2788: last_update_date = processingDate,
2789: last_update_login = currentUserId,