387: procedure getAllApprovalGroups(groupIdsOut out nocopy ame_util.idList,
388: groupNamesOut out nocopy ame_util.stringList) as
389: cursor fetchGroupsCursor is
390: select approval_group_id, name
391: from ame_approval_groups
392: where end_date is null
393: order by name;
394: begin
395: open fetchGroupsCursor;
565: errorMessage ame_util.longestStringType;
566: begin
567: select approval_group_id
568: into groupIdOut
569: from ame_approval_groups
570: where name = groupNameIn
571: and end_date is null;
572: exception
573: when no_data_found then