[Home] [Help]
PACKAGE: APPS.CZ_PUBL_SYNC_CRASH
Source
1 PACKAGE CZ_PUBL_SYNC_CRASH AUTHID CURRENT_USER AS
2 /* $Header: czpsyns.pls 115.1 2003/03/03 16:47:57 rheramba ship $ */
3
4 PROCEDURE SET_DBMS_INFO(p_module_name IN VARCHAR2);
5 ------------------------------------------------------------------------------------------
6 /* clear CZ_SYNC session */
7 PROCEDURE RESET_DBMS_INFO;
8 ------------------------------------------------------------------------------------------
9 /* Sync source instance with a single target instance */
10 PROCEDURE SYNC_SINGLE_SOURCE_CP(ERRNO IN OUT NOCOPY NUMBER,
11 ERRBUF IN OUT NOCOPY VARCHAR2,
12 p_run_id IN OUT NOCOPY NUMBER,
13 p_target_server_id IN NUMBER);
14 ------------------------------------------------------------------------------------------
15 -- should validate be in spec??
16 /* Validate if the serverId is the right source server */
17 FUNCTION ValidateSource(p_target_server_id IN NUMBER)
18 RETURN BOOLEAN;
19 ------------------------------------------------------------------------------------------
20 /* Sync source instance with all target instances */
21 PROCEDURE SYNC_ALL_SOURCE_CP (ERRNO IN OUT NOCOPY NUMBER,
22 ERRBUF IN OUT NOCOPY VARCHAR2,
23 p_run_id IN OUT NOCOPY NUMBER);
24 ------------------------------------------------------------------------------------------
25 /* Sync target instance with its source instance */
26 PROCEDURE SYNC_TARGET_CP (ERRNO IN OUT NOCOPY NUMBER,
27 ERRBUF IN OUT NOCOPY VARCHAR2,
28 p_run_id IN OUT NOCOPY NUMBER,
29 p_source_server_id IN NUMBER,
30 p_date IN DATE,
31 p_commitYesNo IN NUMBER DEFAULT 0 );
32 /*Backup date from which the db has been restored */
33 ------------------------------------------------------------------------------------------
34 /* Report all publications that will get republished if SYNC_TARGET_CP is run */
35 PROCEDURE SYNC_TARGET_LIST_CP(ERRNO IN OUT NOCOPY NUMBER,
36 ERRBUF IN OUT NOCOPY VARCHAR2,
37 p_run_id IN OUT NOCOPY NUMBER,
38 p_source_server_id IN NUMBER,
39 p_date IN DATE);
40 ------------------------------------------------------------------------------------------
41 /* Validate if the serverId is the right target server */
42 FUNCTION ValidateTarget(p_server_id IN NUMBER)
43 RETURN BOOLEAN;
44 ------------------------------------------------------------------------------------------
45 TYPE ref_cursor IS REF CURSOR;
46
47 /* Constant Declarations */
48 pbSourceClone CONSTANT VARCHAR2(30):='CZ_SYNC_SOURCE_CLONE'; /*Source clone*/
49 pbTargetClone CONSTANT VARCHAR2(30):='CZ_SYNC_TARGET_CLONE'; /*Target clone*/
50 pbSourceCrash CONSTANT VARCHAR2(30):='CZ_SYNC_SOURCE_CRASH'; /*Source crash*/
51 pbTargetCrash CONSTANT VARCHAR2(30):='CZ_SYNC_TARGET_CRASH'; /*Target crash*/
52
53 /* Error variables */
54 xERROR BOOLEAN := FALSE;
55 errNo NUMBER;
56 errBuf VARCHAR2(255);
57
58 /* Oracle Error values */
59 czOk CONSTANT NUMBER:=0;
60 czWarning CONSTANT NUMBER:=1;
61 czError CONSTANT NUMBER:=2;
62
63 /* Db linkvalues */
64
65 /* Publication error values */
66 PUBLICATION_ERROR CONSTANT VARCHAR2(3) := 'ERR';
67 PUBLICATION_OK CONSTANT VARCHAR2(3) := 'OK' ;
68 PUBLICATION_PROCESSING CONSTANT VARCHAR2(3) := 'PRC';
69 PUBLICATION_PENDING CONSTANT VARCHAR2(3) := 'PEN';
70 PUBLICATION_PEN_UPDATE CONSTANT VARCHAR2(3) := 'PUP';
71
72 /* Exceptions */
73 WRONG_INCR EXCEPTION;
74 INCORRECT_SOURCE EXCEPTION;
75 CZ_SYNC_ERROR EXCEPTION;
76 SERVER_NOT_FOUND EXCEPTION;
77 DB_LINK_DOWN EXCEPTION;
78 DB_TNS_INCORRECT EXCEPTION;
79 TNS_INCORRECT EXCEPTION;
80 VALIDATE_SERVER_ERROR EXCEPTION;
81 DELETE_PUBLICATION_ERROR EXCEPTION;
82 CREATE_PUBLICATION_ERROR EXCEPTION;
83 REDO_SEQUENCE_ERROR EXCEPTION;
84 DELETE_DEL_PUBLICATION_ERROR EXCEPTION;
85 REPUBLISH_ERROR EXCEPTION;
86 REPORT_RESULTS_ERROR EXCEPTION;
87 APPLICABILITY_PARAM_ERR EXCEPTION;
88
89 ------------------------------------------------------------------------------------------
90 END CZ_PUBL_SYNC_CRASH;