| 221 |
vnguyen |
1 |
CREATE PACKAGE "RELEASE_MANAGER"."PK_RELEASE" IS
|
|
|
2 |
/*
|
|
|
3 |
------------------------------
|
|
|
4 |
|| Last Modified: S.Vukovic
|
|
|
5 |
|| Modified Date: 12/Sep/2005
|
|
|
6 |
|| Body Version: 3.0
|
|
|
7 |
------------------------------
|
|
|
8 |
*/
|
|
|
9 |
|
|
|
10 |
TYPE typeCur IS REF CURSOR;
|
|
|
11 |
|
|
|
12 |
/*================================================================================================*/
|
|
|
13 |
PROCEDURE New_Release ( sReleaseName IN VARCHAR2, sReleaseComments IN VARCHAR2, nProjId IN NUMBER, nSourceRtagId IN NUMBER, sIsBranched IN CHAR, nUserId IN NUMBER );
|
|
|
14 |
PROCEDURE Update_Release ( nRtagId IN NUMBER, sReleaseName IN VARCHAR2, sReleaseComments IN VARCHAR2, nParentRtagId IN NUMBER, nMASSRtagId IN NUMBER, nConfigSpecBranch IN VARCHAR2, sOwnerEmail IN VARCHAR2, nUserId IN NUMBER, cState IN VARCHAR );
|
|
|
15 |
PROCEDURE MOVE_RELEASE ( sRtagIdList IN VARCHAR2, nProjId IN NUMBER, nUserId IN NUMBER );
|
|
|
16 |
PROCEDURE Destroy_Release ( nRtagId IN NUMBER, nUserId IN NUMBER );
|
|
|
17 |
PROCEDURE Import_Release_Contents ( nSourceRtagId IN NUMBER, nTargetRtagId IN NUMBER, nUserId IN NUMBER );
|
|
|
18 |
PROCEDURE Clean_Release_Contents ( nRtagId IN NUMBER, nUserId IN NUMBER );
|
|
|
19 |
FUNCTION GET_PARENT_RTAG ( nRtagId IN NUMBER, nSourceRtagId IN NUMBER, cIsBranch IN CHAR ) RETURN NUMBER;
|
|
|
20 |
PROCEDURE UPDATE_DISPLAY_ORDER ( nProjId IN NUMBER );
|
|
|
21 |
PROCEDURE GET_VIEW_CONTENT ( RtagId IN NUMBER, ViewId IN NUMBER, RecordSet OUT typeCur );
|
|
|
22 |
PROCEDURE ADD_PACKAGE ( newPvId IN NUMBER, ViewId IN NUMBER, RtagId IN NUMBER, UserId IN NUMBER );
|
|
|
23 |
--PROCEDURE ADD_DEPRECATE_PACKAGE ( newPvId IN NUMBER, ViewId IN NUMBER, RtagId IN NUMBER, UserId IN NUMBER, nPkgId IN NUMBER );
|
|
|
24 |
PROCEDURE REPLACE_PACKAGE ( newPvId IN NUMBER, oldPvId IN NUMBER, RtagId IN NUMBER, UserId IN NUMBER );
|
|
|
25 |
PROCEDURE REMOVE_PACKAGE ( PvId IN NUMBER, RtagId IN NUMBER, UserId IN NUMBER );
|
|
|
26 |
PROCEDURE REMOVE_MATCHING_PACKAGE ( PvId IN NUMBER, RtagId IN NUMBER, UserId IN NUMBER );
|
|
|
27 |
FUNCTION GET_PACKAGE_VIEW ( PvId IN NUMBER, RtagId IN NUMBER ) RETURN NUMBER;
|
|
|
28 |
PROCEDURE RUN_POST_ACTIONS ( PvId IN NUMBER, RtagId IN NUMBER );
|
|
|
29 |
PROCEDURE RUN_POST_ACTIONS_BULK ( PvId IN NUMBER );
|
|
|
30 |
PROCEDURE CHANGE_PACKAGE_VIEW ( PvId IN NUMBER, RtagId IN NUMBER, NewViewId IN NUMBER );
|
|
|
31 |
PROCEDURE ADD_RELEASE_REFERENCE ( nRtagId IN NUMBER, nRefRtagId IN NUMBER, ProblemString OUT VARCHAR2 );
|
|
|
32 |
PROCEDURE REMOVE_RELEASE_REFERENCE ( nRtagId IN NUMBER, nRefRtagId IN NUMBER );
|
|
|
33 |
PROCEDURE CAN_USER_WRITE_TO_RELEASE ( RtagId IN NUMBER, PvId IN NUMBER, Permission IN CHAR );
|
|
|
34 |
|
|
|
35 |
/*================================================================================================*/
|
|
|
36 |
|
|
|
37 |
END PK_RELEASE;
|
|
|
38 |
/
|