[Home] [Help]
563: and (nameIn is null or upper(name) = upper(nameIn))
564: and (descriptionIn is null or upper(description) = upper(descriptionIn))
565: and is_static = isStaticIn
566: and (queryStringIn is null or upper(query_string) = upper(queryStringIn))
567: and sysdate between ame_approval_groups.start_date
568: and nvl(ame_approval_groups.end_date - ame_util.oneSecond, sysdate);
569: if(tempCount = 0) then
570: return(true);
571: else
619: (nameIn is null or upper(name) = upper(nameIn)) and
620: (descriptionIn is null or upper(description) = upper(descriptionIn)) and
621: is_static = isStaticIn and
622: (queryStringIn is null or upper(query_string) = upper(queryStringIn)) and
623: sysdate between ame_approval_groups.start_date and
624: nvl(ame_approval_groups.end_date - ame_util.oneSecond, sysdate) and
625: sysdate between ame_approval_group_config.start_date and
626: nvl(ame_approval_group_config.end_date - ame_util.oneSecond, sysdate);
627: if(tempCount = 0 or groupHasBeenUpdated) then
801: */
802: currentUserId := ame_util.getCurrentUserId;
803: if(approvalGroupIdIn is null) then
804: createdBy := currentUserId;
805: select ame_approval_groups_s.nextval into approvalGroupId from dual;
806: else
807: approvalGroupId := approvalGroupIdIn;
808: select count(*)
809: into tempCount
2180: ame_approval_group_config
2181: where
2182: ame_approval_groups.approval_group_id = ame_approval_group_config.approval_group_id and
2183: ame_approval_group_config.application_id = applicationIdIn and
2184: sysdate between ame_approval_groups.start_date and
2185: nvl(ame_approval_groups.end_date - ame_util.oneSecond, sysdate) and
2186: sysdate between ame_approval_group_config.start_date and
2187: nvl(ame_approval_group_config.end_date - ame_util.oneSecond, sysdate)
2188: order by ame_approval_group_config.order_number;