[Home] [Help]
PACKAGE: APPS.XDPCORE_FA
Source
1 PACKAGE XDPCORE_FA AUTHID CURRENT_USER AS
2 /* $Header: XDPCORFS.pls 120.1 2005/06/15 22:38:00 appldev $ */
3
4
5 --global strings..
6 g_fp_name varchar2(20) := 'FP_NAME';
7 g_xdp_fp_error_threshold varchar2(30) := 'XDP_FP_ERROR_THRESHOLD';
8 g_fp_in_error varchar2(20) := 'FP_IN_ERROR';
9
10 e_NullValueException EXCEPTION;
11 e_UnhandledException EXCEPTION;
12
13 x_ErrMsg VARCHAR2(2000);
14 x_DebugMsg VARCHAR2(2000);
15
16 x_ErrorID number;
17 x_ErrCode number;
18 x_ErrStr varchar2(800);
19 x_MessageList XDP_TYPES.MESSAGE_TOKEN_LIST;
20
21
22
23 Procedure CreateFAProcess(parentitemtype in varchar2,
24 parentitemkey in varchar2,
25 FAInstanceID in number,
26 WIInstanceID in number,
27 OrderID in number,
28 FaCaller in varchar2 DEFAULT 'EXTERNAL',
29 FaMaster in varchar2,
30 FaItemtype OUT NOCOPY varchar2,
31 FaItemkey OUT NOCOPY varchar2,
32 ErrCode OUT NOCOPY number,
33 ErrStr OUT NOCOPY varchar2);
34
35 Procedure CreateFAProcess(parentitemtype in varchar2,
36 parentitemkey in varchar2,
37 FAInstanceID in number,
38 WIInstanceID in number,
39 OrderID in number,
40 LineItemID in number,
41 ResubmissionJobID in number,
42 FaCaller in varchar2 DEFAULT 'EXTERNAL',
43 FaMaster in varchar2,
44 FaItemtype OUT NOCOPY varchar2,
45 FaItemkey OUT NOCOPY varchar2,
46 ErrCode OUT NOCOPY number,
47 ErrStr OUT NOCOPY varchar2);
48
49
50 -- ARE_ALL_FAS_DONE
51 -- Resultout
52 -- Activity Performed - Activity was completed without any errors
53 --
54 -- Your Description here:
55
56
57 Procedure ARE_ALL_FAS_DONE (itemtype in varchar2,
58 itemkey in varchar2,
59 actid in number,
60 funcmode in varchar2,
61 resultout OUT NOCOPY varchar2);
62
63
64
65
66
67
68 -- ENQUEUE_FP_QUEUE
69 -- Resultout
70 -- Activity Performed - Activity was completed without any errors
71 --
72 -- Your Description here:
73
74
75 Procedure ENQUEUE_FP_QUEUE (itemtype in varchar2,
76 itemkey in varchar2,
77 actid in number,
78 funcmode in varchar2,
79 resultout OUT NOCOPY varchar2);
80
81
82
83 -- GET_FE
84 -- Resultout
85 -- Activity Performed - Activity was completed without any errors
86 --
87 -- Your Description here:
88
89
90 Procedure GET_FE (itemtype in varchar2,
91 itemkey in varchar2,
92 actid in number,
93 funcmode in varchar2,
94 resultout OUT NOCOPY varchar2);
95
96
97 Procedure OVERRIDE_FE (itemtype in varchar2,
98 itemkey in varchar2,
99 actid in number,
100 funcmode in varchar2,
101 resultout OUT NOCOPY varchar2);
102
103
104 -- INITIALIZE_FA
105 -- Resultout
106 -- Activity Performed - Activity was completed without any errors
107 --
108 -- Your Description here:
109
110
111 Procedure INITIALIZE_FA (itemtype in varchar2,
112 itemkey in varchar2,
113 actid in number,
114 funcmode in varchar2,
115 resultout OUT NOCOPY varchar2);
116
117
118
119 -- INITIALIZE_FA_LIST
120 -- Resultout
121 -- Activity Performed - Activity was completed without any errors
122 --
123 -- Your Description here:
124
125
126 Procedure INITIALIZE_FA_LIST (itemtype in varchar2,
127 itemkey in varchar2,
128 actid in number,
129 funcmode in varchar2,
130 resultout OUT NOCOPY varchar2);
131
132
133 Procedure IS_CHANNEL_AVAILABLE (itemtype in varchar2,
134 itemkey in varchar2,
135 actid in number,
136 funcmode in varchar2,
137 resultout OUT NOCOPY varchar2);
138
139
140 -- IS_COD_CHANNEL_AVAILABLE
141 -- Resultout
142 -- Yes/No - Yes if a Connect-On-Demand Channel is available
143 -- No if No such channel is configured or not available
144 -- to be used at this time
145
146 Procedure IS_COD_CHANNEL_AVAILABLE (itemtype in varchar2,
147 itemkey in varchar2,
148 actid in number,
149 funcmode in varchar2,
150 resultout OUT NOCOPY varchar2);
151
152
153
154 -- CONNECT_ON_DEMAND
155 -- Resultout
156 -- Success/Failure - Success if the Adapter Connected Successfully
157 -- Failure if the Connect Procedure fails
158
159 Procedure CONNECT_ON_DEMAND (itemtype in varchar2,
160 itemkey in varchar2,
161 actid in number,
162 funcmode in varchar2,
163 resultout OUT NOCOPY varchar2);
164
165 -- LAUNCH_FA_PROVISIONING_PROCESS
166 -- Resultout
167 -- Activity Performed - Activity was completed without any errors
168 --
169 -- Your Description here:
170
171
172 Procedure LAUNCH_FA_PROVISIONING_PROCESS (itemtype in varchar2,
173 itemkey in varchar2,
174 actid in number,
175 funcmode in varchar2,
176 resultout OUT NOCOPY varchar2);
177
178
179
180 -- LAUNCH_FA_PROCESS
181 -- Resultout
182 -- Activity Performed - Activity was completed without any errors
183 --
184 -- Your Description here:
185
186
187 Procedure LAUNCH_FA_PROCESS (itemtype in varchar2,
188 itemkey in varchar2,
189 actid in number,
190 funcmode in varchar2,
191 resultout OUT NOCOPY varchar2);
192
193
194 -- LAUNCH_FA_PROCESS_SEQ
195 -- Resultout
196 -- Activity Performed - Activity was completed without any errors
197 --
198 -- Your Description here:
199
200
201 Procedure LAUNCH_FA_PROCESS_SEQ (itemtype in varchar2,
202 itemkey in varchar2,
203 actid in number,
204 funcmode in varchar2,
205 resultout OUT NOCOPY varchar2);
206
207 -- PROVISION_FE
208 -- Resultout
209 -- Activity Performed - Activity was completed without any errors
210 --
211 -- Your Description here:
212
213
214 Procedure PROVISION_FE (itemtype in varchar2,
215 itemkey in varchar2,
216 actid in number,
217 funcmode in varchar2,
218 resultout OUT NOCOPY varchar2);
219
220
221
222 -- RELEASE_FE_CHANNEL
223 -- Resultout
224 -- Activity Performed - Activity was completed without any errors
225 --
226 -- Your Description here:
227
228
229 Procedure RELEASE_FE_CHANNEL (itemtype in varchar2,
230 itemkey in varchar2,
231 actid in number,
232 funcmode in varchar2,
233 resultout OUT NOCOPY varchar2);
234
235
236
237 -- GET_FA_CALLER
238 -- Resultout
239 -- Activity Performed - Activity was completed without any errors
240 --
241 -- Your Description here:
242
243
244 Procedure GET_FA_CALLER (itemtype in varchar2,
245 itemkey in varchar2,
246 actid in number,
247 funcmode in varchar2,
248 resultout OUT NOCOPY varchar2);
249
250
251 -- STOP_FA_PROCESSING
252 -- Resultout
253 -- Activity Performed - Activity was completed without any errors
254 --
255 -- Your Description here:
256
257
258 Procedure STOP_FA_PROCESSING (itemtype in varchar2,
259 itemkey in varchar2,
260 actid in number,
261 funcmode in varchar2,
262 resultout OUT NOCOPY varchar2);
263
264
265
266 -- WAIT_IN_FP_QUEUE
267 -- Resultout
268 -- Activity Performed - Activity was completed without any errors
269 --
270 -- Your Description here:
271
272
273 Procedure WAIT_IN_FP_QUEUE (itemtype in varchar2,
274 itemkey in varchar2,
275 actid in number,
276 funcmode in varchar2,
277 resultout OUT NOCOPY varchar2);
278
279
280
281 -- VERIFY_CHANNEL
282 -- Resultout
283 -- Activity Performed - Activity was completed without any errors
284 --
285 -- Your Description here:
286
287
288 Procedure VERIFY_CHANNEL (itemtype in varchar2,
289 itemkey in varchar2,
290 actid in number,
291 funcmode in varchar2,
292 resultout OUT NOCOPY varchar2);
293
294
295
296 -- Resultout
297 -- Activity Performed - Activity was completed without any errors
298 --
299 -- Your Description here:
300
301 Procedure RESET_CHANNEL (itemtype in varchar2,
302 itemkey in varchar2,
303 actid in number,
304 funcmode in varchar2,
305 resultout OUT NOCOPY varchar2);
306
307 Procedure RESOLVE_IND_DEP_FAS (itemtype in varchar2,
308 itemkey in varchar2,
309 actid in number,
310 funcmode in varchar2,
311 resultout OUT NOCOPY varchar2);
312
313 Procedure INITIALIZE_DEP_FA_PROCESS (itemtype in varchar2,
314 itemkey in varchar2,
315 actid in number,
316 funcmode in varchar2,
317 resultout OUT NOCOPY varchar2);
318
319 Procedure LAUNCH_ALL_IND_FAS (itemtype in varchar2,
320 itemkey in varchar2,
321 actid in number,
322 funcmode in varchar2,
323 resultout OUT NOCOPY varchar2);
324
325 Procedure IS_ANY_CHANNEL_AVAILABLE (itemtype in varchar2,
326 itemkey in varchar2,
327 actid in number,
328 funcmode in varchar2,
329 resultout OUT NOCOPY varchar2);
330
331 Procedure IS_THRESHOLD_EXCEEDED (itemtype in varchar2,
332 itemkey in varchar2,
333 actid in number,
334 funcmode in varchar2,
335 resultout OUT NOCOPY varchar2);
336
337 Procedure ERROR_DURING_RETRY (itemtype in varchar2,
338 itemkey in varchar2,
339 actid in number,
340 funcmode in varchar2,
341 resultout OUT NOCOPY varchar2 );
342
343 Procedure IS_THRESHOLD_REACHED (itemtype in varchar2,
344 itemkey in varchar2,
345 actid in number,
346 funcmode in varchar2,
347 resultout OUT NOCOPY varchar2 );
348
349 Procedure RESET_SYSTEM_HOLD (itemtype in varchar2,
350 itemkey in varchar2,
351 actid in number,
352 funcmode in varchar2,
353 resultout OUT NOCOPY varchar2 );
354
355
356 Procedure ENQUEUE_FP_HOLD (itemtype in varchar2,
357 itemkey in varchar2,
358 actid in number,
359 funcmode in varchar2,
360 resultout OUT NOCOPY varchar2 );
361
362 Procedure AUTO_RETRY_ENABLED (itemtype in varchar2,
363 itemkey in varchar2,
364 actid in number,
365 funcmode in varchar2,
366 resultout OUT NOCOPY varchar2 );
367
368
369
370 -- Obsoleted with 11.5.6
371 -- Procedure HandOverChannel (p_ChannelName in varchar2,
372 -- p_FeName in varchar2,
373 -- p_ErrCode out number,
374 -- p_ErrStr out varchar2);
375
376 Procedure HandOverChannel (ChannelName in varchar2,
377 FeID in number,
378 ChannelUsageCode in varchar2,
379 Caller in varchar2 default 'FA',
380 ErrCode OUT NOCOPY number,
381 ErrStr OUT NOCOPY varchar2);
382
383
384 Function ConnectOnDemand(
385 p_Channel_Name in varchar2,
386 x_return_code OUT NOCOPY number,
387 x_error_description OUT NOCOPY varchar2) return varchar2;
388
389 Procedure SearchAndLockChannel( p_FEID in number,
390 p_ChannelUsageCode in varchar2,
391 p_CODFlag in varchar2,
392 p_AdapterStatus in varchar2,
393 x_LockedFlag OUT NOCOPY varchar2,
394 x_ChannelName OUT NOCOPY varchar2);
395
396 Function IsFAAborted(FAInstanceID in number) return boolean;
397
398 Function get_display_name( p_FAInstanceID IN NUMBER) return varchar2;
399
400 --Function IsChannelAvailable(itemtype in varchar2,
401 -- itemkey in varchar2) return varchar2;
402
403 End XDPCORE_FA;