1 PACKAGE XDP_APPLICATION AUTHID CURRENT_USER AS
2 /* $Header: XDPAADMS.pls 120.1 2005/06/15 21:48:06 appldev $ */
3
4 /***************** Commented out - START - sacsharm - 11.5.6 *****
5
6 e_TableException EXCEPTION;
7 e_ProcException EXCEPTION;
8 e_ProcExecException EXCEPTION;
9 e_LockUnavailException EXCEPTION;
10 e_InvalidRequestException EXCEPTION;
11 e_ConnectExecException EXCEPTION;
12 e_DisconnExecException EXCEPTION;
13 e_GetFeConfigException EXCEPTION;
14
15 pv_AckTimeout number;
16
17 x_ErrorID number;
18 x_ErrCode number;
19 x_ErrStr varchar2(800);
20 x_MessageList XDP_TYPES.MESSAGE_TOKEN_LIST;
21
22 Procedure CLEANUP_ADAPTER_PIPE (ChannelName in varchar2,
23 ErrCode OUT NOCOPY number,
24 ErrStr OUT NOCOPY varchar2);
25
26 Procedure STOP_ADAPTER (ChannelName in varchar2,
27 Whomtostop in varchar2,
28 ErrCode OUT NOCOPY number,
29 ErrStr OUT NOCOPY varchar2);
30
31 Procedure SUSPEND_ADAPTER (RequestID in number,
32 Caller in varchar2,
33 ErrCode OUT NOCOPY number,
34 ErrStr OUT NOCOPY varchar2);
35
36 Procedure SUSPEND_ADAPTER (ChannelName in varchar2,
37 FeName in varchar2,
38 FeID in number,
39 User in varchar2,
40 Freq in varchar2,
41 Reqdate in DATE,
42 RequestID in number,
43 Caller in varchar2,
44 ErrCode OUT NOCOPY number,
45 ErrStr OUT NOCOPY varchar2);
46
47 Procedure RESUME_ADAPTER (RequestID in number,
48 Caller in varchar2,
49 ErrCode OUT NOCOPY number,
50 ErrStr OUT NOCOPY varchar2);
51
52 Procedure RESUME_ADAPTER (ChannelName in varchar2,
53 FeName in varchar2,
54 FeID in number,
55 User in varchar2,
56 Freq in varchar2,
57 Reqdate in DATE,
58 RequestID in number,
59 Caller in varchar2,
60 ErrCode OUT NOCOPY number,
61 ErrStr OUT NOCOPY varchar2);
62
63 Procedure CONNECT_ADAPTER (RequestID in number,
64 Caller in varchar2,
65 ErrCode OUT NOCOPY number,
66 ErrStr OUT NOCOPY varchar2);
67
68 Procedure CONNECT_ADAPTER (ChannelName in varchar2,
69 FeName in varchar2,
70 FeID in number,
71 User in varchar2,
72 Freq in varchar2,
73 Reqdate in DATE,
74 RequestID in number,
75 Caller in varchar2,
76 ErrCode OUT NOCOPY number,
77 ErrStr OUT NOCOPY varchar2);
78
79 Procedure DISCONNECT_ADAPTER (RequestID in number,
80 Caller in varchar2,
81 ErrCode OUT NOCOPY number,
82 ErrStr OUT NOCOPY varchar2);
83
84
85 Procedure DISCONNECT_ADAPTER (ChannelName in varchar2,
86 FeName in varchar2,
87 FeID in number,
88 User in varchar2,
89 Freq in varchar2,
90 Reqdate in DATE,
91 RequestID in number,
92 Caller in varchar2,
93 ErrCode OUT NOCOPY number,
94 ErrStr OUT NOCOPY varchar2);
95
96 Procedure SHUTDOWN_ADAPTER (RequestID in number,
97 Caller in varchar2,
98 ErrCode OUT NOCOPY number,
99 ErrStr OUT NOCOPY varchar2);
100
101 Procedure SHUTDOWN_ADAPTER (ChannelName in varchar2,
102 FeName in varchar2,
103 FeID in number,
104 User in varchar2,
105 Freq in varchar2,
106 Reqdate in DATE,
107 RequestID in number,
108 ShutdownMode in varchar2 default 'N',
109 Caller in varchar2,
110 ErrCode OUT NOCOPY number,
111 ErrStr OUT NOCOPY varchar2);
112
113 Procedure ADMINISTER_ADAPTER (RequestType in varchar2,
114 RequestID in number,
115 ErrCode OUT NOCOPY number,
116 ErrStr OUT NOCOPY varchar2);
117
118 Procedure STARTUP_ADAPTER (ChannelName in varchar2,
119 FeName in varchar2,
120 FeID in number,
121 AdapterName in varchar2,
122 AdapterUsageCode in varchar2,
123 AdapterStartupMode in varchar2,
124 AdapterDebugMode in varchar2,
125 User in varchar2,
126 Freq in varchar2,
127 Reqdate in DATE,
128 RequestID in number,
129 Caller in varchar2,
130 ErrCode OUT NOCOPY number,
131 ErrStr OUT NOCOPY varchar2);
132
133
134 Procedure STARTUP_ADAPTER (RequestID in number,
135 Caller in varchar2,
136 ErrCode OUT NOCOPY number,
137 ErrStr OUT NOCOPY varchar2);
138
139 Procedure STARTUP_NEW_ADAPTER (ChannelName in varchar2,
140 FeName in varchar2,
141 FeID in number,
142 AdapterName in varchar2,
143 AdapterUsageCode in varchar2,
144 AdapterStartupMode in varchar2,
145 AdapterDebugMode in varchar2,
146 Caller in varchar2,
147 ErrCode OUT NOCOPY number,
148 ErrStr OUT NOCOPY varchar2);
149
150
151 Procedure FTP_ADAPTER_FILE (RequestID in number,
152 Caller in varchar2,
153 ErrCode OUT NOCOPY number,
154 ErrStr OUT NOCOPY varchar2);
155
156 Procedure FTP_ADAPTER_FILE (ChannelName in varchar2,
157 FeName in varchar2,
158 FeID in number,
159 User in varchar2,
160 Freq in varchar2,
161 Reqdate in DATE,
162 RequestID in number,
163 Caller in varchar2,
164 ErrCode OUT NOCOPY number,
165 ErrStr OUT NOCOPY varchar2);
166
167 Procedure GET_ADAPTER_INFO (RequestID in number,
168 ChannelName OUT NOCOPY varchar2,
169 FeID OUT NOCOPY number,
170 User OUT NOCOPY varchar2,
171 Freq OUT NOCOPY number,
172 Reqdate OUT NOCOPY DATE,
173 ErrCode OUT NOCOPY number,
174 ErrStr OUT NOCOPY varchar2);
175
176 Procedure LOCK_ADAPTER_REG_STATUS (ChannelName in varchar2,
177 ErrCode OUT NOCOPY number,
178 ErrStr OUT NOCOPY varchar2);
179
180 Procedure UPDATE_ADAPTER_REG_STATUS (ChannelName in varchar2,
181 AdapterStatus in varchar2,
182 ErrCode OUT NOCOPY number,
183 ErrStr OUT NOCOPY varchar2);
184
185 Procedure UPDATE_ADAPTER_REG_STATUS (ChannelName in varchar2,
186 AdapterStatus in varchar2,
187 AdapterErrCode in number,
188 AdapterErrDesc in varchar2,
189 ErrCode OUT NOCOPY number,
190 ErrStr OUT NOCOPY varchar2);
191
192 Procedure UPDATE_ADAPTER_ADMIN_STATUS (RequestID in number,
193 ChannelName in varchar2,
194 FeID in number,
195 Reqcode in varchar2,
196 Reqstatus in varchar2,
197 Reqdate in DATE,
198 Reqby in varchar2,
199 Freq in varchar2,
200 ErrCode OUT NOCOPY number,
201 ErrStr OUT NOCOPY varchar2);
202
203 Procedure CHECK_FREQUENCY (ChannelName in varchar2,
204 FeID in number,
205 Request in varchar2,
206 Status in varchar2,
207 Freq in number,
208 User in varchar2,
209 ErrCode OUT NOCOPY number,
210 ErrStr OUT NOCOPY varchar2);
211
212 Procedure GET_ADAPTER_STATUS (ChannelName in varchar2,
213 Status OUT NOCOPY varchar2,
214 UsageCode OUT NOCOPY varchar2,
215 ErrCode OUT NOCOPY varchar2,
216 ErrStr OUT NOCOPY varchar2);
217
218 FUNCTION LOCK_ADAPTER_CTRL RETURN BOOLEAN;
219
220
221 Procedure SubmitControllerReq(errbuf OUT NOCOPY varchar2,
222 retcode OUT NOCOPY number,
223 DebugMode in varchar2,
224 ReqID OUT NOCOPY number);
225
226 Procedure SubmitControllerReq(errbuf OUT NOCOPY varchar2,
227 retcode OUT NOCOPY number);
228
229 Procedure VerifyController (errbuf OUT NOCOPY varchar2,
230 retcode OUT NOCOPY number,
231 MaxTries in number,
232 Caller in varchar2 DEFAULT 'CONC_JOB');
233
234 Procedure RemoveDBJobs(retcode OUT NOCOPY number,
235 errbuf OUT NOCOPY varchar2,
236 What in varchar default 'ALL');
237
238 Procedure StartController(DebugMode in varchar2,
239 ControllerAlreadyRunningFlag OUT NOCOPY boolean,
240 errbuf OUT NOCOPY varchar2,
241 retcode OUT NOCOPY number);
242
243 Procedure CONTROLLER_RESUBMIT(errbuf OUT NOCOPY varchar2,
244 retcode OUT NOCOPY number);
245
246 Procedure LockVerifyController
247 (
248 errbuf OUT NOCOPY VARCHAR2,
249 retcode OUT NOCOPY NUMBER,
250 IsControllerLocked OUT NOCOPY BOOLEAN,
251 IsControllerDown OUT NOCOPY BOOLEAN,
252 MaxTries IN NUMBER DEFAULT 1,
253 MaxTriesLock IN NUMBER DEFAULT 1,
254 Caller IN VARCHAR2 DEFAULT 'NON_CONC_JOB'
255 );
256
257 ****************** Commented out - END - sacsharm - 11.5.6 ****/
258
259 Function Fetch_CPID(ConcQID in number, Caller in varchar2 default 'SERV') return number;
260
261 Procedure Fetch_ConcQ_Details (CPID in number,
262 ConcQID OUT NOCOPY number,
263 ConcQName OUT NOCOPY varchar2);
264
265 Function Submit_Svc_Ctl_Request (CPID in number, CtlCmd in varchar2) return number;
266
267 FUNCTION GET_COMPONENT_THREADS (p_service_params_str IN VARCHAR2,
268 p_tag IN VARCHAR2)
269 RETURN NUMBER;
270
271 PROCEDURE XDP_STOP
272 (
273 errbuf OUT NOCOPY VARCHAR2,
274 retcode OUT NOCOPY NUMBER,
275 FeOptions IN VARCHAR2,
276 FeName IN VARCHAR2,
277 StopOptions IN VARCHAR2
278 );
279
280
281 PROCEDURE XDP_START
282 (
283 errbuf OUT NOCOPY VARCHAR2,
284 retcode OUT NOCOPY NUMBER,
285 FeOptions IN VARCHAR2,
286 FeName IN VARCHAR2,
287 DebugMode IN VARCHAR2
288 );
289
290 Procedure XDP_CM_SHUTDOWN ;
291
292 PROCEDURE FETCH_THREAD_CNT
293 (
294 svc_handle IN VARCHAR2,
295 num_of_threads OUT NOCOPY NUMBER
296 );
297
298 -- *** Procedure to get counts for OAM console ****
299
300
301 PROCEDURE XDP_CONSOLE_COUNTS_FENGINE(
302 p_order_threads OUT NOCOPY NUMBER
303 ,p_order_current OUT NOCOPY NUMBER
304 ,p_order_future OUT NOCOPY NUMBER
305 ,p_order_exception OUT NOCOPY NUMBER
306 ,p_order_inprogress OUT NOCOPY NUMBER
307 ,p_order_inerror OUT NOCOPY NUMBER
308 ,p_order_completed OUT NOCOPY NUMBER
309 ,p_wi_threads OUT NOCOPY NUMBER
310 ,p_wi_current OUT NOCOPY NUMBER
311 ,p_wi_future OUT NOCOPY NUMBER
312 ,p_wi_exception OUT NOCOPY NUMBER
313 ,p_wi_inprogress OUT NOCOPY NUMBER
314 ,p_wi_inerror OUT NOCOPY NUMBER
315 ,p_wi_completed OUT NOCOPY NUMBER
316 ,p_fa_threads OUT NOCOPY NUMBER
317 ,p_fa_current OUT NOCOPY NUMBER
318 ,p_fa_future OUT NOCOPY NUMBER
319 ,p_fa_exception OUT NOCOPY NUMBER
320 ,p_fa_inprogress OUT NOCOPY NUMBER
321 ,p_fa_inerror OUT NOCOPY NUMBER
322 ,p_fa_completed OUT NOCOPY NUMBER
323 ,p_fa_ready_current OUT NOCOPY NUMBER
324 ,p_fa_ready_future OUT NOCOPY NUMBER
325 ,p_fa_ready_exception OUT NOCOPY NUMBER
326 ,p_timer_threads OUT NOCOPY NUMBER
327 ,p_timer_current OUT NOCOPY NUMBER
328 ,p_timer_future OUT NOCOPY NUMBER
329 ,p_timer_exception OUT NOCOPY NUMBER
330 ,p_timer_inprogress OUT NOCOPY NUMBER
331 ,p_timer_completed OUT NOCOPY NUMBER
332 ,p_event_threads OUT NOCOPY NUMBER
333 ,p_event_current OUT NOCOPY NUMBER
334 ,p_event_future OUT NOCOPY NUMBER
335 ,p_event_exception OUT NOCOPY NUMBER
336 ,p_event_inprogress OUT NOCOPY NUMBER
337 ,p_event_inerror OUT NOCOPY NUMBER
338 ,p_event_completed OUT NOCOPY NUMBER
339 ,p_in_threads OUT NOCOPY NUMBER
340 ,p_in_current OUT NOCOPY NUMBER
341 ,p_in_future OUT NOCOPY NUMBER
342 ,p_in_exception OUT NOCOPY NUMBER
343 ,p_in_inprogress OUT NOCOPY NUMBER
344 ,p_in_inerror OUT NOCOPY NUMBER
345 ,p_in_completed OUT NOCOPY NUMBER
346 ,p_out_current OUT NOCOPY NUMBER
347 ,p_out_exception OUT NOCOPY NUMBER
348 ,p_out_inprogress OUT NOCOPY NUMBER
349 ,p_out_inerror OUT NOCOPY NUMBER
350 ,p_out_completed OUT NOCOPY NUMBER
351 );
352
353
354 END XDP_APPLICATION;