1 PACKAGE ad_patch_analysis_engine
2 /* $Header: adpaengs.pls 120.2 2007/03/28 08:13:46 vlim ship $ */
3 AS
4
5 TYPE typeHashVarchar IS TABLE OF VARCHAR2(50) INDEX BY VARCHAR2(50);
6
7 ----------------------------------------------------------------------------
8 -- Procedure to print out the usage of this package.
9 ----------------------------------------------------------------------------
10 PROCEDURE usage;
11
12 ----------------------------------------------------------------------------
13 -- Procedure to initialize the global variables.
14 ----------------------------------------------------------------------------
15 PROCEDURE initialize;
16
17 ----------------------------------------------------------------------------
18 -- Function to print messages on console
19 ----------------------------------------------------------------------------
20 PROCEDURE debugPrint
21 ( p_message IN VARCHAR2
22 );
23
24 ----------------------------------------------------------------------------
25 -- Get the value from desired hash
26 ----------------------------------------------------------------------------
27 FUNCTION getValueFromHash
28 ( p_key IN VARCHAR2,
29 p_hash IN typeHashVarchar
30 )
31 RETURN VARCHAR2;
32
33 ----------------------------------------------------------------------------
34 -- Function to compare the the 2 inputs codelevels.
35 ----------------------------------------------------------------------------
36 FUNCTION compareLevel
37 ( p_level_1 IN VARCHAR2 DEFAULT '',
38 p_level_2 IN VARCHAR2 DEFAULT ''
39 )
40 RETURN NUMBER;
41
42 ----------------------------------------------------------------------------
43 -- Function to validate and add the pre-reqs.
44 ----------------------------------------------------------------------------
45 PROCEDURE addPrereq
46 ( p_te_abbr IN VARCHAR2 ,
47 p_te_level IN VARCHAR2 ,
48 p_hashRequires IN OUT NOCOPY typeHashVarchar
49 );
50
51 ----------------------------------------------------------------------------
52 -- Function to get the status of the user input patch and baseline.
53 ----------------------------------------------------------------------------
54 FUNCTION getPatchStatus
55 ( p_bug_number IN NUMBER,
56 p_baseline IN VARCHAR2,
57 p_release IN VARCHAR2,
58 p_err_message OUT NOCOPY VARCHAR2
59 )
60 RETURN VARCHAR2;
61
62 ----------------------------------------------------------------------------
63 -- Function to get the status of the user input patch and baseline.
64 ----------------------------------------------------------------------------
65 FUNCTION getPatchStatus
66 ( p_bug_number IN NUMBER,
67 p_baseline IN VARCHAR2,
68 p_release IN VARCHAR2,
69 p_err_message OUT NOCOPY VARCHAR2,
70 p_analysis_run_id IN NUMBER ,
71 p_user_id IN NUMBER ,
72 p_overwrite IN BOOLEAN DEFAULT FALSE
73 )
74 RETURN VARCHAR2;
75
76 END ad_patch_analysis_engine;