Subversion Repositories DevTools

CREATE PROCEDURE "RELEASE_MANAGER"."ADD_RUNTIME_DEPENDENCY" ( NNpv_id IN NUMBER,
                                                     SSrtd_name IN PACKAGES.pkg_name%TYPE,
                                                     SSrtd_version IN PACKAGE_VERSIONS.pkg_version%TYPE,
                                                     NNuser_id IN NUMBER
                                                    ) IS
/* ---------------------------------------------------------------------------
    Version: 3.1
   --------------------------------------------------------------------------- */

    retRTD_ID NUMBER;

        CURSOR rtd_cur IS
        SELECT rtd_id FROM runtime_dependencies WHERE pv_id = NNpv_id AND rtd_id = retRTD_ID;
    rtd_rec rtd_cur%ROWTYPE;

BEGIN
    --- Seed database with package_name and version if required ---
    Seed_Package_Names_Versions ( SSrtd_name, SSrtd_version, NNuser_id, retRTD_ID );

        OPEN rtd_cur;
    FETCH rtd_cur INTO rtd_rec;

    IF rtd_cur%NOTFOUND
    THEN
                /* Make sure it does not exists already as runtime dependency */

                --- Add new Runtime Dependency ---
            INSERT INTO runtime_dependencies ( pv_id, rtd_id, mod_date, mod_user )
            VALUES (  NNpv_id, retRTD_ID, ORA_SYSDATE , NNuser_id );

        /* LOG ACTION */
        Log_Action ( NNpv_id, 'runtime_add', NNuser_id,
                             'Runtime package: '|| SSrtd_name ||' '|| SSrtd_version );

        END IF;


END Add_Runtime_Dependency;
/