| 221 |
vnguyen |
1 |
CREATE PACKAGE "RELEASE_MANAGER"."PK_PACKAGE_TEST"
|
|
|
2 |
IS
|
|
|
3 |
/*
|
|
|
4 |
------------------------------
|
|
|
5 |
|| Last Modified: Rupesh Solanki
|
|
|
6 |
|| Modified Date: 18/05/2006
|
|
|
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 |
nstateid IN product_states.state_id%TYPE,
|
|
|
93 |
nuserid IN NUMBER
|
|
|
94 |
);
|
|
|
95 |
/*================================================================================================*/
|
|
|
96 |
END pk_package_Test;
|
|
|
97 |
/
|