1 PACKAGE BODY CSM_HA_PROCESS_PKG AS
2 /* $Header: csmhapb.pls 120.2 2011/02/02 06:36:48 trajasek noship $*/
3 g_debug_level NUMBER; -- debug level
4
5 PROCEDURE SAVE_SEQUENCE(p_session_id IN NUMBER, p_action IN VARCHAR2)
6 AS
7 BEGIN
8 NULL;
9 END SAVE_SEQUENCE;
10
11 PROCEDURE DISABLE_WF_ONAPPLY
12 IS
13 BEGIN
14 NULL;
15 END DISABLE_WF_ONAPPLY;
16
17 PROCEDURE ENABLE_WF_ONAPPLY
18 IS
19 BEGIN
20 NULL;
21 END ENABLE_WF_ONAPPLY;
22
23 PROCEDURE SET_CONTEXT( P_CON_NAME_LIST CSM_VARCHAR_LIST,
24 p_CON_VALUE_LIST CSM_VARCHAR_LIST,
25 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
26 X_ERROR_MESSAGE OUT NOCOPY VARCHAR2)
27 IS
28 BEGIN
29 NULL;
30 END SET_CONTEXT;
31
32 PROCEDURE SET_DEFERRED( P_HA_SESSION_ID NUMBER,
33 p_HA_PAYLOAD_ID NUMBER,
34 P_STATUS NUMBER,
35 P_ERROR_MESSAGE VARCHAR2)
36 IS
37 BEGIN
38 NULL;
39 END SET_DEFERRED;
40
41 PROCEDURE PROCESS_HA(X_RETURN_STATUS OUT NOCOPY VARCHAR2,
42 x_ERROR_MESSAGE OUT NOCOPY VARCHAR2,
43 P_SESSION_ID IN NUMBER DEFAULT NULL)
44 AS
45 BEGIN
46 NULL;
47 END PROCESS_HA;
48
49 PROCEDURE PARSE_XML(p_HA_PAYLOAD_ID IN NUMBER,
50 X_COL_NAME_LIST OUT NOCOPY CSM_VARCHAR_LIST,
51 X_COL_VALUE_LIST OUT NOCOPY CSM_VARCHAR_LIST,
52 X_CON_NAME_LIST OUT NOCOPY CSM_VARCHAR_LIST,
53 X_CON_VALUE_LIST OUT NOCOPY CSM_VARCHAR_LIST,
54 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
55 x_ERROR_MESSAGE OUT NOCOPY VARCHAR2)
56 AS
57 BEGIN
58 NULL;
59 END PARSE_XML;
60
61 FUNCTION PROCESS_HA
62 RETURN NUMBER
63 IS
64 BEGIN
65 NULL;
66 END PROCESS_HA;
67
68
69
70 --Private Api
71 FUNCTION GET_PK_VALUE (p_PK_NAME_LIST IN CSM_VARCHAR_LIST,
72 p_COL_NAME_LIST IN CSM_VARCHAR_LIST,
73 p_COL_VALUE_LIST IN CSM_VARCHAR_LIST)
74 RETURN VARCHAR2
75 IS
76 BEGIN
77 NULL;
78 END GET_PK_VALUE;
79
80 PROCEDURE PROCESS_DIRECT_UPDATE(P_TABLE_NAME IN VARCHAR2,P_PK_VALUE IN VARCHAR2,
81 P_COL_NAME_LIST IN CSM_VARCHAR_LIST,P_COL_VALUE_LIST IN CSM_VARCHAR_LIST,
82 x_RETURN_STATUS OUT NOCOPY VARCHAR2 ,x_ERROR_MESSAGE OUT NOCOPY VARCHAR2)
83 IS
84 BEGIN
85 NULL;
86 END PROCESS_DIRECT_UPDATE;
87
88 --Private Api
89 PROCEDURE PROCESS_DIRECT_INSERT(P_TABLE_NAME IN VARCHAR2,P_PK_VALUE IN VARCHAR2,
90 P_COL_NAME_LIST IN CSM_VARCHAR_LIST,
91 P_COL_VALUE_LIST IN CSM_VARCHAR_LIST,
92 x_RETURN_STATUS OUT NOCOPY VARCHAR2 ,x_ERROR_MESSAGE OUT NOCOPY VARCHAR2)
93 IS
94 BEGIN
95 NULL;
96 END PROCESS_DIRECT_INSERT;
97 --Public Api
98 PROCEDURE PROCESS_DIRECT_DML(p_PAYLOAD_ID IN NUMBER
99 ,x_RETURN_STATUS OUT NOCOPY VARCHAR2
100 ,x_ERROR_MESSAGE OUT NOCOPY VARCHAR2)
101 IS
102 BEGIN
103 NULL;
104 END PROCESS_DIRECT_DML;
105
106 PROCEDURE SET_HA_PROFILE(P_VALUE IN VARCHAR2)
107 IS
108 BEGIN
109 NULL;
110 END SET_HA_PROFILE;
111 --Function to convert clob to blob
112 FUNCTION CLOB_TO_BLOB( p_clob_data IN CLOB ) RETURN BLOB
113 IS
114
115 BEGIN
116 RETURN NULL;
117 END CLOB_TO_BLOB;
118
119
120 PROCEDURE PROCESS_HTML5(X_RETURN_STATUS OUT NOCOPY VARCHAR2,
121 X_ERROR_MESSAGE OUT NOCOPY VARCHAR2)
122 IS
123 BEGIN
124 NULL;
125 END PROCESS_HTML5;
126
127 PROCEDURE UPLOAD_SYNC_DATA(P_SYNC_ID IN NUMBER,
128 P_USER_NAME IN VARCHAR2,
129 P_SYNC_DATA IN CLOB,
130 X_RETURN_STATUS OUT NOCOPY varchar2,
131 X_ERROR_MESSAGE OUT NOCOPY varchar2)
132 IS
133 BEGIN
134 NULL;
135 END UPLOAD_SYNC_DATA;
136
137 PROCEDURE HTML5_SESSION(p_sync_id IN NUMBER,p_status IN VARCHAR2)
138 IS
139 BEGIN
140 NULL;
141 END HTML5_SESSION;
142
143 PROCEDURE HTML5_PARSE_XML(p_SYNC_ID IN NUMBER,
144 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
145 X_ERROR_MESSAGE OUT NOCOPY VARCHAR2)
146 IS
147 BEGIN
148 NULL;
149 END HTML5_PARSE_XML;
150
151
152 PROCEDURE HTML5_DISCARD(p_SYNC_ID IN NUMBER,
153 P_PAYLOAD_ID IN NUMBER DEFAULT NULL,
154 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
155 x_ERROR_MESSAGE OUT NOCOPY VARCHAR2)
156 IS
157 BEGIN
158 NULL;
159 END HTML5_DISCARD;
160
161 PROCEDURE PROCESS_HTML5_SELECT(p_SYNC_ID IN NUMBER,
162 P_PAYLOAD_ID IN NUMBER DEFAULT NULL,
163 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
164 x_ERROR_MESSAGE OUT NOCOPY VARCHAR2)
165 AS
166 BEGIN
167 NULL;
168 END PROCESS_HTML5_SELECT;
169
170 END CSM_HA_PROCESS_PKG;