2722 FUNCTION COLLECTION_MAX_SEQ(
 2723     P_COLLECTION_NAME IN VARCHAR2 )
 2724     RETURN NUMBER
 2725 IS
 2726     L_MAX NUMBER := 0;
 2727     L_SESSION_ID NUMBER;
 2728 BEGIN
 2729     L_SESSION_ID := NV('SESSION');
 2730     
 2731     
 2732     
 2733     CHECK_COLLECTION_NAME( P_COLLECTION_NAME => P_COLLECTION_NAME );
 2734 
 2735     FOR C1 IN (SELECT   NVL(MAX(SEQ_ID),0) MAXSEQ
 2736                  FROM WWV_FLOW_COLLECTIONS$ C,
 2737                       WWV_FLOW_COLLECTION_MEMBERS$ M
 2738                 WHERE C.SESSION_ID = L_SESSION_ID
 2739                   AND C.SECURITY_GROUP_ID = WWV_FLOW_SECURITY.G_SECURITY_GROUP_ID
 2740                   AND C.FLOW_ID = WWV_FLOW.G_FLOW_ID
 2741                   AND C.ID = M.COLLECTION_ID
 2742                   AND C.COLLECTION_NAME = UPPER(P_COLLECTION_NAME)) LOOP
 2743         L_MAX := C1.MAXSEQ;
 2744     END LOOP;
 2745 
 2746     RETURN L_MAX;
 2747 END;