1 PACKAGE AD_PATCH_IMPACT_API AS
2 /* $Header: adpaias.pls 120.3 2006/04/05 03:29:02 msailoz noship $ */
3
4 TYPE t_rec_patch is TABLE of NUMBER(30)
5 INDEX BY BINARY_INTEGER;
6 TYPE t_prereq_patch is TABLE of NUMBER(30)
7 INDEX BY BINARY_INTEGER;
8
9 TYPE t_recomm_patch_rec IS RECORD (
10 bug_number NUMBER,
11 baseline VARCHAR2(150),
12 patch_id NUMBER
13 );
14
15 TYPE t_recomm_patch_tab IS TABLE OF t_recomm_patch_rec;
16
17 /**
18 The Function returns the list of patches recommended in the current request set.
19 i.e., this AD API would query the FND Concurrent Request table to get the request
20 ID of the currently running Request Set and use this request ID to query the
21 AD_PA_ANALYSIS_RUN_BUGS table to get the list of bug numbers recommended.
22 **/
23 PROCEDURE get_recommend_patch_list
24 (
25 a_rec_patch OUT NOCOPY t_rec_patch
26 )
27 ;
28
29 /**
30 The Function returns the list of patches recommended in the current request set.
31 i.e., this AD API would query the FND Concurrent Request table to get the request
32 ID of the currently running Request Set and use this request ID to query the
33 AD_PA_ANALYSIS_RUN_BUGS table to get the list of bug numbers recommended.
34 **/
35 PROCEDURE get_recommend_patch_list
36 (
37 p_recomm_patch_tab OUT NOCOPY t_recomm_patch_tab
38 )
39 ;
40
41
42 /**
43 This API will return to PIA the Global Snapshot ID.
44 **/
45 PROCEDURE get_global_snapshot_id
46 (
47 snap_id OUT NOCOPY Number
48 )
49 ;
50
51 /**
52 PIA CPs would call this PL/SQL API that returns the list of
53 pre-req'ed patches that have not been applied for each recommended patch.
54 API input: recommended patch bug number (obtained from the 1st API)
55 API output: list of pre-req's of this recommended patch that have not been
56 applied to the system.
57 **/
58 PROCEDURE get_prereq_list
59 (
60 bug_number_val IN Number,
61 a_prereq_patch OUT NOCOPY t_prereq_patch
62 )
63 ;
64
65 /**
66 PIA CPs would call this PL/SQL API that returns the list of
67 pre-req'ed patches that have not been applied for each recommended patch
68 for a particular request set.
69 API input: request set id
70 API input: recommended patch bug number (obtained from the 1st API)
71 API output: list of pre-req's of this recommended patch that have not been
72 applied to the system.
73 The Function returns 1 in case of error
74 **/
75 PROCEDURE get_prereq_list
76 (
77 pRequestId IN Number,
78 pBugNumber IN Number,
79 pPrereqPatches OUT NOCOPY t_prereq_patch
80 )
81 ;
82
83
84 END AD_PATCH_IMPACT_API;