CREATE PACKAGE BODY "RELEASE_MANAGER"."PK_PROJECT" IS
/*
------------------------------
||  Last Modified:  J.Tweddle
||  Modified Date:  23/Aug/2007
||  Body Version:   1.0
------------------------------
*/

    /*------------------------------------------------------------------------*/
    PROCEDURE update_base_url ( 
        nprojid   IN  projects.proj_id%TYPE,
        sbaseurl  IN  VARCHAR2
        ) IS
    BEGIN
      
        UPDATE projects
        SET base_url = sbaseurl
        WHERE proj_id = nprojid;
    
    END update_base_url;
    /*------------------------------------------------------------------------*/

END pk_project;
/
ALTER PACKAGE "RELEASE_MANAGER"."PK_PROJECT" 
  COMPILE BODY 
    PLSQL_OPTIMIZE_LEVEL=  2
    PLSQL_CODE_TYPE=  INTERPRETED
    PLSQL_DEBUG=  FALSE
 REUSE SETTINGS TIMESTAMP '2007-08-23 16:12:34'
/
