Subversion Repositories DevTools

CREATE PROCEDURE "RELEASE_MANAGER"."RESET_IGNORE_WARNINGS" ( sPvIdList IN VARCHAR2,
                                                    nRTagId IN RELEASE_CONTENT.RTAG_ID%TYPE ) IS
/* ---------------------------------------------------------------------------
    Version: 5.0
   --------------------------------------------------------------------------- */

oPvIdCollector RELMGR_NUMBER_TAB_t := RELMGR_NUMBER_TAB_t();

BEGIN
        oPvIdCollector := IN_LIST_NUMBER ( sPvIdList );

    -- Remove Ignore Warnings
     DELETE
       FROM ignore_warnings
          WHERE (rtag_id, pv_id, dpv_id) IN
             (
              SELECT igw.rtag_id, igw.pv_id, igw.dpv_id
                FROM ignore_warnings igw,
                     package_versions dpv,
                     package_versions pv
               WHERE igw.dpv_id = dpv.pv_id
                 AND igw.rtag_id = nRTagId
                 AND dpv.pkg_id = pv.pkg_id
                 AND NVL(dpv.v_ext,'|LINK_A_NULL|') = NVL(pv.v_ext,'|LINK_A_NULL|')
                 AND pv.pv_id IN ( SELECT * FROM TABLE ( CAST ( oPvIdCollector AS RELMGR_NUMBER_TAB_t ) ) )
         );

END Reset_Ignore_Warnings;
/