Subversion Repositories DevTools

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
221 vnguyen 1 
CREATE PACKAGE BODY "RELEASE_MANAGER"."PK_PROJECT" IS
2 
/*
3 
------------------------------
4 
||  Last Modified:  J.Tweddle
5 
||  Modified Date:  23/Aug/2007
6 
||  Body Version:   1.0
7 
------------------------------
8 
*/
9 
 
10 
    /*------------------------------------------------------------------------*/
11 
    PROCEDURE update_base_url (
12 
        nprojid   IN  projects.proj_id%TYPE,
13 
        sbaseurl  IN  VARCHAR2
14 
        ) IS
15 
    BEGIN
16 
 
17 
        UPDATE projects
18 
        SET base_url = sbaseurl
19 
        WHERE proj_id = nprojid;
20 
 
21 
    END update_base_url;
22 
    /*------------------------------------------------------------------------*/
23 
 
24 
END pk_project;
25 
/
26 
ALTER PACKAGE "RELEASE_MANAGER"."PK_PROJECT"
27 
  COMPILE BODY
28 
    PLSQL_OPTIMIZE_LEVEL=  2
29 
    PLSQL_CODE_TYPE=  INTERPRETED
30 
    PLSQL_DEBUG=  FALSE
31 
 REUSE SETTINGS TIMESTAMP '2007-08-23 16:12:34'
32 
/