Subversion Repositories DevTools

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
221 vnguyen 1 
CREATE PACKAGE "RELEASE_MANAGER"."PK_PACKAGE"
2 
IS
3 
/*
4 
------------------------------
5 
||  Last Modified:  Jeremy Tweddle
6 
||  Modified Date:  24/08/2007
7 
||
8 
------------------------------
9 
*/
10 
   TYPE typecur IS REF CURSOR;
11 
 
12 
/*================================================================================================*/
13 
   PROCEDURE new_version (
14 
      nlastpvid                   IN       NUMBER,
15 
      snewpkgversion              IN       VARCHAR2 DEFAULT NULL,
16 
      cbuildtype                  IN       CHAR,
17 
      nsettopvid                  IN       NUMBER DEFAULT NULL,
18 
      nrtagid                     IN       NUMBER,
19 
      nuserid                     IN       NUMBER,
20 
      enumissues_state_imported   IN       NUMBER,
21 
      returnpvid                  OUT      NUMBER
22 
   );
23 
 
24 
   PROCEDURE change_state (
25 
      pvid       IN   NUMBER,
26 
      newstate   IN   package_versions.dlocked%TYPE,
27 
      userid     IN   NUMBER
28 
   );
29 
 
30 
   PROCEDURE new_patch (
31 
      snewpatchversion   IN       package_versions.pkg_version%TYPE,
32 
      nparentpvid        IN       NUMBER,
33 
      spatchidlist       IN       VARCHAR2,
34 
      nuserid            IN       NUMBER,
35 
      returnpatchid      OUT      NUMBER
36 
   );
37 
 
38 
   PROCEDURE obsolete_patch (
39 
      patchid            IN   NUMBER,
40 
      isobsolete         IN   CHAR,
41 
      obsoletecomments   IN   VARCHAR2,
42 
      userid             IN   NUMBER
43 
   );
44 
 
45 
   PROCEDURE obsolete_patches (
46 
      spatchidlist       IN   VARCHAR2,
47 
      isobsolete         IN   CHAR,
48 
      obsoletecomments   IN   VARCHAR2,
49 
      userid             IN   NUMBER
50 
   );
51 
 
52 
   PROCEDURE destroy_package (
53 
      pvid               IN       NUMBER,
54 
      overridewarnings   IN       CHAR DEFAULT 'N',
55 
      problemstring      OUT      VARCHAR2
56 
   );
57 
 
58 
   PROCEDURE add_process (
59 
      nprocid         IN   processes.proc_id%TYPE,
60 
      shealthtag      IN   processes.proc_name%TYPE,
61 
      sprocdesc       IN   processes.proc_description%TYPE,
62 
      scmdinterface   IN   processes.run_as%TYPE,
63 
      spkgowner       IN   processes.pkg_owner%TYPE,
64 
      sisinterface    IN   processes.is_interface%TYPE,
65 
      npvid           IN   package_processes.pv_id%TYPE,
66 
      nuserid         IN   NUMBER
67 
   );
68 
 
69 
   PROCEDURE add_package_process (
70 
      nprocidlist   IN   VARCHAR2,
71 
      npvid         IN   package_processes.pv_id%TYPE,
72 
      nuserid       IN   NUMBER
73 
   );
74 
 
75 
 
76 
 
77 
   PROCEDURE remove_process (
78 
      nprocid   IN   package_processes.proc_id%TYPE,
79 
      npvid     IN   package_processes.pv_id%TYPE,
80 
      nuserid   IN   NUMBER
81 
   );
82 
 
83 
   PROCEDURE move_package (
84 
   	  npvid  			  IN package_versions.pv_id%TYPE,
85 
	  nrtagid 			  IN release_tags.rtag_id%TYPE,
86 
	  nnewrtagid 		  IN release_tags.rtag_id%TYPE,
87 
	  nuserid			  IN NUMBER
88 
   );
89 
 
90 
   PROCEDURE modify_product_state (
91 
   	  npvid IN package_versions.pv_id%TYPE,
92 
	  nrtagid IN release_tags.rtag_id%TYPE,
93 
	  nstateid IN product_states.state_id%TYPE,
94 
	  nuserid IN NUMBER
95 
   );
96 
 
97 
   PROCEDURE add_code_review_url (
98 
        npvid           IN    NUMBER,
99 
        nprojid         IN    NUMBER,
100 
        surl            IN    VARCHAR2,
101 
        sreason         IN    VARCHAR2,
102 
        ddateofreview   IN    DATE
103 
   );
104 
 
105 
   PROCEDURE update_code_review_url (
106 
        ncrid           IN    NUMBER,
107 
        nprojid         IN    NUMBER,
108 
        surl            IN    VARCHAR2,
109 
        sreason         IN    VARCHAR2
110 
   );
111 
 
112 
   PROCEDURE remove_code_review_url (
113 
        ncrid           IN    NUMBER
114 
   );
115 
/*================================================================================================*/
116 
END pk_package;
117 
/