| 221 |
vnguyen |
1 |
CREATE PROCEDURE "RELEASE_MANAGER"."ADD_RUNTIME_DEPENDENCY" ( NNpv_id IN NUMBER,
|
|
|
2 |
SSrtd_name IN PACKAGES.pkg_name%TYPE,
|
|
|
3 |
SSrtd_version IN PACKAGE_VERSIONS.pkg_version%TYPE,
|
|
|
4 |
NNuser_id IN NUMBER
|
|
|
5 |
) IS
|
|
|
6 |
/* ---------------------------------------------------------------------------
|
|
|
7 |
Version: 3.1
|
|
|
8 |
--------------------------------------------------------------------------- */
|
|
|
9 |
|
|
|
10 |
retRTD_ID NUMBER;
|
|
|
11 |
|
|
|
12 |
CURSOR rtd_cur IS
|
|
|
13 |
SELECT rtd_id FROM runtime_dependencies WHERE pv_id = NNpv_id AND rtd_id = retRTD_ID;
|
|
|
14 |
rtd_rec rtd_cur%ROWTYPE;
|
|
|
15 |
|
|
|
16 |
BEGIN
|
|
|
17 |
--- Seed database with package_name and version if required ---
|
|
|
18 |
Seed_Package_Names_Versions ( SSrtd_name, SSrtd_version, NNuser_id, retRTD_ID );
|
|
|
19 |
|
|
|
20 |
OPEN rtd_cur;
|
|
|
21 |
FETCH rtd_cur INTO rtd_rec;
|
|
|
22 |
|
|
|
23 |
IF rtd_cur%NOTFOUND
|
|
|
24 |
THEN
|
|
|
25 |
/* Make sure it does not exists already as runtime dependency */
|
|
|
26 |
|
|
|
27 |
--- Add new Runtime Dependency ---
|
|
|
28 |
INSERT INTO runtime_dependencies ( pv_id, rtd_id, mod_date, mod_user )
|
|
|
29 |
VALUES ( NNpv_id, retRTD_ID, ORA_SYSDATE , NNuser_id );
|
|
|
30 |
|
|
|
31 |
/* LOG ACTION */
|
|
|
32 |
Log_Action ( NNpv_id, 'runtime_add', NNuser_id,
|
|
|
33 |
'Runtime package: '|| SSrtd_name ||' '|| SSrtd_version );
|
|
|
34 |
|
|
|
35 |
END IF;
|
|
|
36 |
|
|
|
37 |
|
|
|
38 |
END Add_Runtime_Dependency;
|
|
|
39 |
/
|