Subversion Repositories DevTools

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
221 vnguyen 1 
CREATE PROCEDURE "RELEASE_MANAGER"."RIPPLE_PACKAGE" (
2 
        sPvIdList IN VARCHAR2,
3 
        nRtagId IN RELEASE_TAGS.RTAG_ID%TYPE,
4 
        nUserId IN NUMBER
5 
    ) IS
6 
/* ---------------------------------------------------------------------------
7 
    Version: 4.1
8 
   --------------------------------------------------------------------------- */
9 
 
10 
BEGIN
11 
 
12 
    IF (sPvIdList IS NULL) THEN
13 
        RAISE_APPLICATION_ERROR (-20000, 'Please select at least one package.' );
14 
    END IF;
15 
 
16 
    -- Ripple Package
17 
    DELETE FROM DO_NOT_RIPPLE
18 
    WHERE RTAG_ID = nRtagId
19 
    AND PV_ID IN (
20 
        SELECT *
21 
        FROM THE (
22 
            SELECT CAST( IN_LIST_NUMBER( sPvIdList )
23 
            AS RELMGR_NUMBER_TAB_t )
24 
            FROM DUAL
25 
        )
26 
    );
27 
 
28 
    /* LOG ACTION */
29 
    Log_Action_Bulk ( sPvIdList, 'ripple_package', nUserId );
30 
 
31 
END Ripple_Package;
32 
/