| 221 |
vnguyen |
1 |
CREATE PACKAGE "RELEASE_MANAGER"."RM_ISSUES" AS
|
|
|
2 |
|
|
|
3 |
TYPE T_Cur IS REF CURSOR;
|
|
|
4 |
|
|
|
5 |
FUNCTION VerIsGrtrThanOrEqlToStart( XXstart IN NUMBER, XX IN NUMBER, YYstart IN NUMBER, YY IN NUMBER, ZZstart IN NUMBER, ZZ IN NUMBER ) RETURN NUMBER;
|
|
|
6 |
FUNCTION VersionIsBetween( version IN VARCHAR2, version_start IN VARCHAR2, version_end IN VARCHAR ) RETURN NUMBER;
|
|
|
7 |
FUNCTION VerIsLessThanOrEqlToEnd( XXend IN NUMBER, XX IN NUMBER, YYend IN NUMBER, YY IN NUMBER, ZZend IN NUMBER, ZZ IN NUMBER ) RETURN NUMBER;
|
|
|
8 |
FUNCTION GetPkgId( pkgName IN VARCHAR2 ) RETURN NUMBER;
|
|
|
9 |
|
|
|
10 |
PROCEDURE AllIssues( vCursor OUT T_Cur, pkg_name IN VARCHAR2, version_start IN VARCHAR2, version_end IN VARCHAR2 );
|
|
|
11 |
PROCEDURE LoadIssuesTable( vCursor OUT T_Cur, pkg_name IN VARCHAR2, version_start IN VARCHAR2, version_end IN VARCHAR2 );
|
|
|
12 |
PROCEDURE InsertIssuesForDepends( pvID IN NUMBER, top_pkgID IN NUMBER, top_pkgName IN VARCHAR2, top_pvID IN NUMBER, top_pkgVer IN VARCHAR2 );
|
|
|
13 |
|
|
|
14 |
END Rm_Issues;
|
|
|
15 |
/
|