[Home] [Help]
PACKAGE: APPS.XDP_PROC_CTL
Source
1 PACKAGE XDP_PROC_CTL AUTHID CURRENT_USER AS
2 /* $Header: XDPPCTLS.pls 120.1 2005/06/22 06:48:22 appldev ship $ */
3
4
5 e_ParamValueException EXCEPTION;
6 e_ProcExecException EXCEPTION;
7
8 e_UnhandledException EXCEPTION;
9 e_PipeSendAckException EXCEPTION;
10 e_PipeWaitForAckException EXCEPTION;
11 e_PipeWaitForMesgException EXCEPTION;
12 e_PipeSendMesgException EXCEPTION;
13 e_PipePackMesgException EXCEPTION;
14 e_PipeUnpackMesgException EXCEPTION;
15 e_NeWarningException EXCEPTION;
16 e_NeFailureException EXCEPTION;
17 e_NeSessionLostException EXCEPTION;
18 e_NeTimedOutException EXCEPTION;
19 e_PipeOutOfSyncException EXCEPTION;
20
21 -- x_progress varchar2(32767);
22
23 pv_FeName varchar2(80);
24 pv_FeID number;
25 pv_FeType varchar2(80);
26 pv_FeTypeID number;
27 pv_SWGeneric varchar2(80);
28 pv_AdapterType varchar2(80);
29
30 pv_AckTimeout number;
31 pv_MesgTimeout number;
32
33 pv_ack_conn_timeout number;
34 pv_cmd_conn_timeout number;
35
36 pv_DirtyBit BOOLEAN;
37
38 pv_debug_mode varchar2(10);
39
40 -- Connect Command/Response
41 TYPE CONNECT_CMD IS RECORD
42 (
43 COMMAND VARCHAR2(32767),
44 RESPONSE VARCHAR2(32767));
45
46 -- list of the order parameter
47 TYPE CONNECT_CMD_LIST IS TABLE OF CONNECT_CMD
48 INDEX BY BINARY_INTEGER;
49
50 pv_ConnectCommands CONNECT_CMD_LIST;
51
52 pv_CommandTimeout number;
53
54
55 pv_attrFeCmdTimeout varchar2(80) := 'NE_CMD_TIMEOUT';
56 pv_attrFeRetryCount varchar2(80) := 'NE_CMD_RETRY_COUNT';
57 pv_attrFeCmdRetryWait varchar2(80) := 'NE_CMD_WAIT';
58 pv_attrFeNoActTimeout varchar2(80) := 'NE_NO_ACTIVITY_TIMEOUT';
59 pv_attrFeCmdKeepAlive varchar2(80) := 'NE_DUMMY_CMD';
60
61 pv_attrFeConnRetryCount varchar2(80) := 'NE_CONNECT_RETRY_COUNT';
62 pv_attrFeConnRetryWait varchar2(80) := 'NE_CONNECT_WAIT';
63
64 /* DEBUG: */
65 x_dbg_progress varchar2(32767);
66
67
68 /* These set of procedures/Functions is for the PROVISIONING PROCEDURE,
69 Generation, execution
70 */
71
72 Procedure CHECK_FOR_OLD_PARAM (Param in varchar2,
73 ParamMinusOld OUT NOCOPY varchar2,
74 OldFlag OUT NOCOPY number);
75
76 Procedure CHECK_PARAM_NAME (WorkitemID in number,
77 FAId in number,
78 ParamType in varchar2,
79 Param in varchar2,
80 ErrCode OUT NOCOPY number,
81 ErrStr OUT NOCOPY varchar2);
82
83 Procedure FIND_PARAMETERS (FAID in number,
84 WorkitemID number,
85 Str in varchar2,
86 ErrCode OUT NOCOPY varchar2,
87 ErrStr OUT NOCOPY varchar2);
88
89 Procedure GET_PARAMETER_VALUE (OrderID in number,
90 LineItemID in number,
91 WIInstanceID in number,
92 FAInstanceID in number,
93 ParamName in varchar2,
94 ParamType in varchar2,
95 ParamOldFlag in number,
96 ParamValue OUT NOCOPY varchar2,
97 LogFlag OUT NOCOPY boolean,
98 ParamLogValue OUT NOCOPY varchar2,
99 ErrCode OUT NOCOPY number,
100 ErrStr OUT NOCOPY varchar2);
101
102 Procedure FIND_REPLACE_PARAMS (OrderID in number,
103 LineItemID in number,
104 WorkiteminstanceID in number,
105 FAinstanceID in number,
106 Str in varchar2,
107 CmdStr OUT NOCOPY varchar2,
108 LogFlag OUT NOCOPY number,
109 LogStr OUT NOCOPY varchar2,
110 ErrCode OUT NOCOPY varchar2,
111 ErrStr OUT NOCOPY varchar2);
112
113
114 Procedure GENERATE_PROC (ProcName in varchar2,
115 ProcStr in varchar2,
116 CompiledProc OUT NOCOPY varchar2,
117 ErrCode OUT NOCOPY number,
118 ErrStr OUT NOCOPY varchar2);
119
120 Procedure SHOW_PROC_ERRORS (ProcName in varchar2,
121 ErrCode OUT NOCOPY number,
122 Errors OUT NOCOPY varchar2);
123
124 Function GET_UNIQUE_CHANNEL_NAME (Name in varchar2) return varchar2;
125
126 Procedure LOG_COMMAND_AUDIT_TRAIL (FAInstanceID in number,
127 FeName in varchar2,
128 FeType in varchar2,
129 SW_Generic in varchar2,
130 CommandSent in varchar2,
131 SentDate in DATE,
132 Response in varchar2,
133 RespDate in DATE,
134 ProcName in varchar2,
135 ErrCode OUT NOCOPY number,
136 ErrStr OUT NOCOPY varchar2);
137
138 Procedure SEND_ACK (ChannelName in varchar2,
139 Timeout in number,
140 ErrCode OUT NOCOPY number,
141 ErrStr OUT NOCOPY varchar2);
142
143 Procedure WAIT_FOR_MESSAGE (ChannelName in varchar2,
144 Timeout in number,
145 Message OUT NOCOPY varchar2,
146 ErrCode OUT NOCOPY number,
147 ErrStr OUT NOCOPY varchar2);
148
149
150 Procedure SEND (OrderID in number,
151 LineItemID in number,
152 WIInstanceID in number,
153 FAInstanceID in number,
154 ChannelName in varchar2,
155 FEName in varchar2,
156 ProcName in varchar2,
157 Response OUT NOCOPY varchar2,
158 sdp_internal_err_code OUT NOCOPY number,
159 sdp_internal_err_str OUT NOCOPY varchar2,
160 CmdStr in varchar2,
161 EncryptFlag in varchar2,
162 Prompt in varchar2,
163 ErrCode OUT NOCOPY number,
164 ErrStr OUT NOCOPY varchar2);
165
166 Procedure SEND (OrderID in number,
167 LineItemID in number,
168 WIInstanceID in number,
169 FAInstanceID in number,
170 ChannelName in varchar2,
171 FEName in varchar2,
172 ProcName in varchar2,
173 Response OUT NOCOPY varchar2,
174 sdp_internal_err_code OUT NOCOPY number,
175 sdp_internal_err_str OUT NOCOPY varchar2,
176 CmdStr in varchar2,
177 EncryptFlag in varchar2,
178 ErrCode OUT NOCOPY number,
179 ErrStr OUT NOCOPY varchar2);
180
181 Procedure SEND_HTTP (OrderID in number,
182 LineItemID in number,
183 WIInstanceID in number,
184 FAInstanceID in number,
185 ChannelName in varchar2,
186 FEName in varchar2,
187 ProcName in varchar2,
188 Response OUT NOCOPY varchar2,
189 sdp_internal_err_code OUT NOCOPY number,
190 sdp_internal_err_str OUT NOCOPY varchar2,
191 CmdStr in varchar2,
192 EncryptFlag in varchar2,
193 ErrCode OUT NOCOPY number,
194 ErrStr OUT NOCOPY varchar2);
195
196 Procedure NOTIFY_ERROR (ResponseStr in varchar2,
197 ErrCode OUT NOCOPY number,
198 ErrStr OUT NOCOPY varchar2,
199 UserStr in varchar2,
200 LogFlag in varchar2);
201
202 Function RESPONSE_CONTAINS (string1 in varchar2,
203 string2 in varchar2) return BOOLEAN;
204
205 Function GET_RESPONSE (ResponseStr in varchar2) return varchar2;
206
207 Function GET_PARAM_VALUE (OrderID in number,
208 LineItemID in number,
209 WIInstanceID in number,
210 FAInstanceID in number,
211 ParamName in varchar2) return varchar2;
212
213
214 -- OLD ONE WILL BE DEPRECATED SOON...
215 Procedure SEND_SYNC ( ChannelName in varchar2,
216 ErrCode OUT NOCOPY number,
217 ErrStr OUT NOCOPY varchar2);
218
219 Procedure SEND_SYNC (ChannelName in varchar2,
220 Fename in varchar2,
221 ErrCode OUT NOCOPY number,
222 ErrStr OUT NOCOPY varchar2);
223
224 /*
225
226 End of PROVISIONING Procedure Related stuff
227 */
228
229
230
231 /* These set of procedures/Functions is for the CONNECT/DISCONNECT PROCEDURE,
232 Generation, execution
233 */
234
235 PROCEDURE CHECK_CONNECT_PARAM_NAME (FeTypeID in number,
236 Param in varchar2,
237 ErrCode OUT NOCOPY number,
238 ErrStr OUT NOCOPY varchar2);
239
240
241 PROCEDURE FIND_CONNECT_PARAMETERS (FeTypeID in number,
242 ConnectStr in varchar2,
243 ErrCode OUT NOCOPY varchar2,
244 ErrStr OUT NOCOPY varchar2);
245
246
247
248 PROCEDURE FIND_REPLACE_CONNECT_PARAMS (FeName in varchar2,
249 ConnectStr in varchar2,
250 ActualStr OUT NOCOPY varchar2,
251 ErrCode OUT NOCOPY varchar2,
252 ErrStr OUT NOCOPY varchar2);
253
254 PROCEDURE GENERATE_CONNECT_PROC (ProcName in varchar2,
255 ProcBody in varchar2,
256 CompiledProc OUT NOCOPY varchar2,
257 ErrCode OUT NOCOPY number,
258 ErrStr OUT NOCOPY varchar2);
259
260 PROCEDURE GENERATE_DISCONNECT_PROC (ProcName in varchar2,
261 ProcBody in varchar2,
262 CompiledProc OUT NOCOPY varchar2,
263 ErrCode OUT NOCOPY number,
264 ErrStr OUT NOCOPY varchar2);
265
266 PROCEDURE GET_FE_PREFERENCES (FeName in varchar2,
267 CmdTimeout OUT NOCOPY number,
268 CmdRetryCount OUT NOCOPY number,
269 CmdWait OUT NOCOPY number,
270 NOActTimeout OUT NOCOPY number,
271 DummyCmd OUT NOCOPY varchar2,
272 ConnectRetryCount OUT NOCOPY number,
273 ConnectRetryWait OUT NOCOPY number,
274 ErrCode OUT NOCOPY number,
275 ErrStr OUT NOCOPY varchar2);
276
277 PROCEDURE SEND_CONNECT (FeName in varchar2,
278 ChannelName in varchar2,
279 ProcName in varchar2,
280 Response OUT NOCOPY varchar2,
281 sdp_internal_err_code OUT NOCOPY number,
282 sdp_internal_err_str OUT NOCOPY varchar2,
283 CmdStr in varchar2,
284 Prompt in varchar2 ,
285 ErrCode OUT NOCOPY number,
286 ErrStr OUT NOCOPY varchar2);
287
288 PROCEDURE SEND_CONNECT (FeName in varchar2,
289 ChannelName in varchar2,
290 ProcName in varchar2,
291 Response OUT NOCOPY varchar2,
292 sdp_internal_err_code OUT NOCOPY number,
293 sdp_internal_err_str OUT NOCOPY varchar2,
294 CmdStr in varchar2,
295 ErrCode OUT NOCOPY number,
296 ErrStr OUT NOCOPY varchar2);
297
298
299 PROCEDURE RESET_BUFFER;
300
301 PROCEDURE FETCH_CONNECT_COMMANDS(CurrIndex in number,
302 TotalCount OUT NOCOPY number,
303 Command OUT NOCOPY varchar2,
304 Response OUT NOCOPY varchar2);
305
306 END XDP_PROC_CTL;