| 221 |
vnguyen |
1 |
CREATE PROCEDURE "RELEASE_MANAGER"."RESET_IGNORE_WARNINGS" ( sPvIdList IN VARCHAR2,
|
|
|
2 |
nRTagId IN RELEASE_CONTENT.RTAG_ID%TYPE ) IS
|
|
|
3 |
/* ---------------------------------------------------------------------------
|
|
|
4 |
Version: 5.0
|
|
|
5 |
--------------------------------------------------------------------------- */
|
|
|
6 |
|
|
|
7 |
oPvIdCollector RELMGR_NUMBER_TAB_t := RELMGR_NUMBER_TAB_t();
|
|
|
8 |
|
|
|
9 |
BEGIN
|
|
|
10 |
oPvIdCollector := IN_LIST_NUMBER ( sPvIdList );
|
|
|
11 |
|
|
|
12 |
-- Remove Ignore Warnings
|
|
|
13 |
DELETE
|
|
|
14 |
FROM ignore_warnings
|
|
|
15 |
WHERE (rtag_id, pv_id, dpv_id) IN
|
|
|
16 |
(
|
|
|
17 |
SELECT igw.rtag_id, igw.pv_id, igw.dpv_id
|
|
|
18 |
FROM ignore_warnings igw,
|
|
|
19 |
package_versions dpv,
|
|
|
20 |
package_versions pv
|
|
|
21 |
WHERE igw.dpv_id = dpv.pv_id
|
|
|
22 |
AND igw.rtag_id = nRTagId
|
|
|
23 |
AND dpv.pkg_id = pv.pkg_id
|
|
|
24 |
AND NVL(dpv.v_ext,'|LINK_A_NULL|') = NVL(pv.v_ext,'|LINK_A_NULL|')
|
|
|
25 |
AND pv.pv_id IN ( SELECT * FROM TABLE ( CAST ( oPvIdCollector AS RELMGR_NUMBER_TAB_t ) ) )
|
|
|
26 |
);
|
|
|
27 |
|
|
|
28 |
END Reset_Ignore_Warnings;
|
|
|
29 |
/
|