PACKAGE: APPS.AD_ZD_ADOP

Source

1 PACKAGE AD_ZD_ADOP AUTHID CURRENT_USER AS
2 /* $Header: ADZDADOPS.pls 120.18.12020000.18 2013/06/05 11:09:06 mkumandu ship $ */
3 
4 /*
5 ** Constants
6 */
7 --C_NE_OWNER varchar2(30) := 'SYSTEM';
8 
9 TYPE adrecord IS RECORD(BugNumber varchar2(30), File_edition varchar2(512),
10 Status varchar2(30), node varchar2(30));
11 TYPE adrecordtable IS TABLE OF adrecord
12 INDEX BY BINARY_INTEGER;
13 PROCEDURE ADOP_PATCH_APPLY_STATUS(adop_sessionID NUMBER, ADOP_tab out
14 adrecordtable, stat varchar2 default 'ALL', node varchar2 default 'ALL');
15 
16 FUNCTION  GETPATCHNUMBERS RETURN VARCHAR2;
17 
18 FUNCTION SUBMIT_REQUEST RETURN NUMBER;
19 FUNCTION GET_ACTIVE_CP_REQUEST_ID RETURN NUMBER;
20 FUNCTION WAIT_FOR_CP_TO_RUN (REQID IN NUMBER) RETURN NUMBER;
21 
22 PROCEDURE KILL_OLD_SESSIONS(p_session_id IN NUMBER);
23 
24 PROCEDURE INSERT_INTO_PATCHES_TABLE(
25                                     p_session_id IN NUMBER,
26                                     p_bug_number IN VARCHAR2,
27                                     p_patch_run_id IN NUMBER,
28                                     p_appltop_base IN VARCHAR2,
29                                     p_adpatch_options IN VARCHAR2,
30                                     p_autoconfig_status IN VARCHAR2,
31                                     p_start_date IN DATE,
32                                     p_end_date IN DATE,
33                                     p_patch_top IN VARCHAR2,
34                                     p_driverfile_name IN VARCHAR2,
35                                     p_status IN VARCHAR2
36                                   );
37 
38 FUNCTION GET_CUTOVER_STATUS(p_appltop_id in number,p_node_name in varchar2,p_session_id in number) return varchar2;
39 
40 PROCEDURE SET_CUTOVER_STATUS(
41                              p_appltop_id in number,
42                              p_node_name in varchar2,
43                              p_status in varchar2
44                             );
45 
46 FUNCTION GET_ADZDPATCH_STATUS(REQID IN NUMBER) RETURN VARCHAR2;
47 PROCEDURE LOCK_SESSIONS_TABLE(p_node_name in varchar2,p_wait_interval in number,p_num_tries in number);
48 PROCEDURE UNLOCK_SESSIONS_TABLE(p_node_name in varchar2,p_wait_interval in number,p_num_tries in number);
49 PROCEDURE LOCK_PATCHES_TABLE(p_node_name in varchar2,p_lock_name in varchar2);
50 PROCEDURE UNLOCK_PATCHES_TABLE(p_node_name in varchar2,p_lock_name in varchar2);
51 PROCEDURE ABORT(x_mode in varchar2 default null, x_session_id in number);
52 PROCEDURE CUTOVER;
53 PROCEDURE FLIP_SNAPSHOTS;
54 PROCEDURE WAIT_FOR_DB_CUTOVER(p_session_id in number);
55 FUNCTION IS_ICM_ALIVE RETURN NUMBER;
56 PROCEDURE INSERT_CLONE_TRACKING_ROW(p_run_base in varchar2,
57                                     p_patch_base in varchar2);
58 FUNCTION EVAL_SRV_STATUS(avail_node_list in VARCHAR2) RETURN BOOLEAN;
59 FUNCTION IS_ABORTABLE RETURN BOOLEAN;
60 FUNCTION ADOP_HEALTH_CHECK(phase in VARCHAR2,node in VARCHAR2 default null) RETURN NUMBER;
61 FUNCTION IS_ABANDONED(node in varchar2) RETURN NUMBER;
62 FUNCTION GET_ABANDONED_NODES(p_mode in varchar2) RETURN VARCHAR2;
63 PROCEDURE CLEAR_ABANDON_FLAG(dest_node in varchar2);
64 PROCEDURE GET_ACTIV_PATCHING_SES_DETAILS(id out NOCOPY NUMBER);
65 PROCEDURE SYNC_SNAPSHOTS(p_appl_top_id in number default null);
66 
67 /*----------------------------------------------------------------------+
68  | Global Constant Variables                                            |
69  +----------------------------------------------------------------------*/
70 
71 pkg_name constant varchar2(25) := 'AD_ZD_ADOP';
72 
73 
74 end AD_ZD_ADOP;