1 PACKAGE MSC_WS_COLLECTIONS AUTHID CURRENT_USER AS
2 /* $Header: MSCWCOLLS.pls 120.3 2008/03/13 04:00:57 bnaghi noship $ */
3
4
5
6
7 -- =============================================================
8 -- Desc: This procedure is invoked from web service to launch
9 -- the ASCP Collection request set. The input parameters
10 -- mirror the parameters for the concurrent programs within
11 -- the request set. The procedure returns a status and
12 -- concurrent program request id. The possible return
13 -- statuses are:
14 -- SUCCESS, ERROR_SUBMITTING,
15 -- INVALID_FND_USER, INVALID_FND_RESP
16 -- INVALID_INSTANCE_ID, INVALID_COLLECTION_GROUP, INVALID_TIMEOUT,
17 -- INVALID_WORKER_NUMBER, INVALID_ODS_WORKER_NUMBER
18 -- =============================================================
19 PROCEDURE RunASCPCollections(
20 status OUT NOCOPY VARCHAR2,
21 processId OUT NOCOPY VARCHAR2,
22 UserID IN NUMBER,
23 ResponsibilityID IN NUMBER,
24 InstanceID IN Number,
25 CollectionGroup IN VARCHAR2,
26 TotalWorkerNum IN NUMBER,
27 Timeout IN NUMBER,
28 OdsPURGEoption IN VARCHAR2,
29 CollectionMethod IN VARCHAR2,
30 AnalyzeTablesEnabled IN VARCHAR2,
31 ApprovedSupplierList IN VARCHAR2,
32 AtpRulesEnabled IN VARCHAR2,
33 BomEnabled IN VARCHAR2,
34 BorEnabled IN VARCHAR2,
35 CalendarEnabled IN VARCHAR2,
36 DemandClassEnabled IN VARCHAR2,
37 ItemSubstEnabled IN VARCHAR2,
38 ForecastEnabled IN VARCHAR2,
39 ItemEnabled IN VARCHAR2,
40 KpiBisEnabled IN VARCHAR2,
41 MdsEnabled IN VARCHAR2,
42 MpsEnabled IN VARCHAR2,
43 OnHandEnabled IN VARCHAR2,
44 ParameterEnabled IN VARCHAR2,
45 PlannerEnabled IN VARCHAR2,
46 PoReceiptsEnabled IN VARCHAR2,
47 ProjectEnabled IN VARCHAR2,
48 PurReqPoEnabled IN VARCHAR2,
49 ReservesHardEnabled IN VARCHAR2,
50 ResourceAvailability IN VARCHAR2,
51 SafestockEnabled IN VARCHAR2,
52 SalesorderRtype IN VARCHAR2,
53 SourcingHistoryEnabled IN VARCHAR2,
54 SourcingEnabled IN VARCHAR2,
55 SubInvEnabled IN VARCHAR2,
56
57 SupplierResponseEnabled IN VARCHAR2,
58 TpCustomerEnabled IN VARCHAR2,
59 TripEnabled IN VARCHAR2,
60 UnitNoEnabled IN VARCHAR2,
61 UomEnabled IN VARCHAR2,
62 UserCompanyAssoc IN VARCHAR2,
63 UserSupplyDemand IN VARCHAR2,
64 WipEnabled IN VARCHAR2,
65 SalesChannelEnabled IN VARCHAR2,
66 FiscalCalendarEnabled IN VARCHAR2,
67 InternalRepairEnabled IN VARCHAR2,
68 ExternalRepairEnabled IN VARCHAR2,
69 PaybackDemandSupplyEnabled IN VARCHAR2,
70 CurrencyConversionEnabled IN VARCHAR2,
71 DeliveryDetailsEnabled IN VARCHAR2,
72
73 Odstotalworkernum IN NUMBER,
74 RecalcResAvailability IN VARCHAR2,
75 PurgeSourcingHistory IN VARCHAR2
76 ) ;
77
78
79 -- =============================================================
80 -- Desc: This procedure is invoked from web service to launch
81 -- the ASCP Collection request set. The input parameters
82 -- mirror the parameters for the concurrent programs within
83 -- the request set. The procedure returns a status and
84 -- concurrent program request id. The possible return
85 -- statuses are:
86 -- SUCCESS, ERROR_SUBMITTING,
87 -- INVALID_USER_NAME, INVALID_RESP_NAME
88 -- INVALID_LANGUAGE, INVALID_SECUTITY_GROUP_NAME, INVALID_FUNC_NAME
89 -- INVALID_INSTANCE_ID, INVALID_COLLECTION_GROUP, INVALID_TIMEOUT,
90 -- INVALID_WORKER_NUMBER, INVALID_ODS_WORKER_NUMBER
91 -- =============================================================
92 PROCEDURE RunASCPCollections_Pub(
93 processId OUT NOCOPY NUMBER,
94 status OUT NOCOPY VARCHAR2,
95 UserName IN VARCHAR2,
96 RespName IN VARCHAR2,
97 RespApplName IN VARCHAR2,
98 SecurityGroupName IN VARCHAR2,
99 Language IN VARCHAR2,
100 InstanceID IN Number,
101 CollectionGroup IN VARCHAR2,
102 TotalWorkerNum IN NUMBER,
103 Timeout IN NUMBER,
104 OdsPURGEoption IN VARCHAR2,
105 CollectionMethod IN VARCHAR2,
106 AnalyzeTablesEnabled IN VARCHAR2,
107 ApprovedSupplierList IN VARCHAR2,
108 AtpRulesEnabled IN VARCHAR2,
109 BomEnabled IN VARCHAR2,
110 BorEnabled IN VARCHAR2,
111 CalendarEnabled IN VARCHAR2,
112 DemandClassEnabled IN VARCHAR2,
113 ItemSubstEnabled IN VARCHAR2,
114 ForecastEnabled IN VARCHAR2,
115 ItemEnabled IN VARCHAR2,
116 KpiBisEnabled IN VARCHAR2,
117 MdsEnabled IN VARCHAR2,
118 MpsEnabled IN VARCHAR2,
119 OnHandEnabled IN VARCHAR2,
120 ParameterEnabled IN VARCHAR2,
121 PlannerEnabled IN VARCHAR2,
122 PoReceiptsEnabled IN VARCHAR2,
123 ProjectEnabled IN VARCHAR2,
124 PurReqPoEnabled IN VARCHAR2,
125 ReservesHardEnabled IN VARCHAR2,
126 ResourceAvailability IN VARCHAR2,
127 SafestockEnabled IN VARCHAR2,
128 SalesorderRtype IN VARCHAR2,
129 SourcingHistoryEnabled IN VARCHAR2,
130 SourcingEnabled IN VARCHAR2,
131 SubInvEnabled IN VARCHAR2,
132
133 SupplierResponseEnabled IN VARCHAR2,
134 TpCustomerEnabled IN VARCHAR2,
135 TripEnabled IN VARCHAR2,
136 UnitNoEnabled IN VARCHAR2,
137 UomEnabled IN VARCHAR2,
138 UserCompanyAssoc IN VARCHAR2,
139 UserSupplyDemand IN VARCHAR2,
140 WipEnabled IN VARCHAR2,
141 SalesChannelEnabled IN VARCHAR2,
142 FiscalCalendarEnabled IN VARCHAR2,
143 InternalRepairEnabled IN VARCHAR2,
144 ExternalRepairEnabled IN VARCHAR2,
145 PaybackDemandSupplyEnabled IN VARCHAR2,
146 CurrencyConversionEnabled IN VARCHAR2,
147 DeliveryDetailsEnabled IN VARCHAR2,
148
149 Odstotalworkernum IN NUMBER,
150 RecalcResAvailability IN VARCHAR2,
151 PurgeSourcingHistory IN VARCHAR2
152 ) ;
153 -- =============================================================
154 -- Desc: This procedure is invoked from web service to launch
155 -- the ODS Load conc prog. The input parameters
156 -- mirror the parameters for the concurrent program
157 -- The procedure returns a status and
158 -- concurrent program request id. The possible return
159 -- statuses are:
160 -- SUCCESS, ERROR_SUBMITTING,
161 -- INVALID_FND_USER, INVALID_FND_RESP
162 -- INVALID_INSTANCE_ID, INVALID_TIMEOUT ,INVALID_ODS_WORKER_NUMBER
163 -- =============================================================
164 PROCEDURE RunODSLoad(
165 status OUT NOCOPY VARCHAR2,
166 processId OUT NOCOPY VARCHAR2,
167 UserID IN NUMBER ,
168 ResponsibilityID IN NUMBER ,
169 InstanceId IN NUMBER ,
170 Timeout IN NUMBER ,
171 TotalWorkerNum IN NUMBER ,
172 RecalcResAvailability IN VARCHAR2 ,
173 RecalcSourcingHistory IN VARCHAR2 ,
174 PurgeSourcingHistory IN VARCHAR2
175 );
176
177 -- =============================================================
178 -- Desc: This procedure is invoked from web service to launch
179 -- the ODS Load conc prog. The input parameters
180 -- mirror the parameters for the concurrent program
181 -- The procedure returns a status and
182 -- concurrent program request id. The possible return
183 -- statuses are:
184 -- SUCCESS, ERROR_SUBMITTING,
185 -- INVALID_USER_NAME, INVALID_RESP_NAME
186 -- INVALID_LANGUAGE, INVALID_SECUTITY_GROUP_NAME, INVALID_FUNC_NAME
187 -- INVALID_INSTANCE_ID, INVALID_TIMEOUT ,INVALID_ODS_WORKER_NUMBER
188 -- =============================================================
189
190 PROCEDURE RunODSLoad_Pub(
191 processId OUT NOCOPY NUMBER,
192 status OUT NOCOPY VARCHAR2,
193 UserName IN VARCHAR2,
194 RespName IN VARCHAR2,
195 RespApplName IN VARCHAR2,
196 SecurityGroupName IN VARCHAR2,
197 Language IN VARCHAR2,
198 InstanceId IN NUMBER ,
199 Timeout IN NUMBER ,
200 TotalWorkerNum IN NUMBER ,
201 RecalcResAvailability IN VARCHAR2 ,
202 RecalcSourcingHistory IN VARCHAR2 ,
203 PurgeSourcingHistory IN VARCHAR2
204 );
205
206 -- =============================================================
207 -- Desc: This procedure is invoked from web service to launch
208 -- the Demantra Shipment and booking Request Set. The input parameters
209 -- mirror the parameters for the concurrent programs within the request set.
210 -- The procedure returns a status and
211 -- concurrent program request id. The possible return
212 -- statuses are:
213 -- SUCCESS, ERROR_SUBMITTING,
214 -- INVALID_FND_USER, INVALID_FND_RESP
215 -- INVALID_COLLECTION_METHOD_NOT_2, INVALID_INSTANCE_ID, INVALID_COLLECTION_GROUP,INVALID_COLLECTION_METHOD,
216 -- INVALID_DATE_RANGE_TYPE, INVALID_ORDER_TYPE_SELECTION
217
218 PROCEDURE RunDemantraShipmentBooking(
219 status OUT nocopy VARCHAR2,
220 processid OUT nocopy VARCHAR2,
221 UserID IN NUMBER,
222 ResponsibilityID IN NUMBER,
223 InstanceId IN NUMBER,
224 CollectionGroup IN VARCHAR2,
225 CollectionMethod IN NUMBER,
226 DateRangeType IN NUMBER,
227 HistoryCollectionWindow IN NUMBER DEFAULT NULL,
228 DateFrom IN DATE DEFAULT NULL,
229 DateTo IN DATE DEFAULT NULL,
230 BHBookedItemsBookedDate IN VARCHAR2,
231 BHBookedItemsRequestedDate IN VARCHAR2,
232 BHRequestedItemsBookedDate IN VARCHAR2,
233 BHRequestedItemsRequestedDate IN VARCHAR2,
234 SHShippedItemsShippedDate IN VARCHAR2,
235 SHShippedItemsRequestedDate IN VARCHAR2,
236 SHRequestedItemsShippedDate IN VARCHAR2,
237 SHRequestedItemsRequestedDate IN VARCHAR2,
238 CollectISO IN VARCHAR2,
239 CollectAllOrderTypes IN VARCHAR2,
240 IncludeOrderTypes IN VARCHAR2 DEFAULT NULL,
241 ExcludeOrderTypes IN VARCHAR2 DEFAULT NULL,
242 LaunchDownload IN VARCHAR2
243 );
244
245 -- =============================================================
246 -- Desc: This procedure is invoked from web service to launch
247 -- the Demantra Shipment and booking Request Set. The input parameters
248 -- mirror the parameters for the concurrent programs within the request set.
249 -- The procedure returns a status and
250 -- concurrent program request id. The possible return
251 -- statuses are:
252 -- SUCCESS, ERROR_SUBMITTING,
253 -- INVALID_USER_NAME, INVALID_RESP_NAME
254 -- INVALID_LANGUAGE, INVALID_SECUTITY_GROUP_NAME, INVALID_FUNC_NAME
255 -- INVALID_COLLECTION_METHOD_NOT_2, INVALID_INSTANCE_ID, INVALID_COLLECTION_GROUP,INVALID_COLLECTION_METHOD,
256 -- INVALID_DATE_RANGE_TYPE, INVALID_ORDER_TYPE_SELECTION
257
258
259 PROCEDURE RunDemantraShipmentBooking_Pub(
260 processId OUT NOCOPY NUMBER,
261 status OUT NOCOPY VARCHAR2,
262 UserName IN VARCHAR2,
263 RespName IN VARCHAR2,
264 RespApplName IN VARCHAR2,
265 SecurityGroupName IN VARCHAR2,
266 Language IN VARCHAR2,
267 InstanceId IN NUMBER,
268 CollectionGroup IN VARCHAR2,
269 CollectionMethod IN NUMBER,
270 DateRangeType IN NUMBER,
271 HistoryCollectionWindow IN NUMBER DEFAULT NULL,
272 DateFrom IN DATE DEFAULT NULL,
276 BHRequestedItemsBookedDate IN VARCHAR2,
273 DateTo IN DATE DEFAULT NULL,
274 BHBookedItemsBookedDate IN VARCHAR2,
275 BHBookedItemsRequestedDate IN VARCHAR2,
277 BHRequestedItemsRequestedDate IN VARCHAR2,
278 SHShippedItemsShippedDate IN VARCHAR2,
279 SHShippedItemsRequestedDate IN VARCHAR2,
280 SHRequestedItemsShippedDate IN VARCHAR2,
281 SHRequestedItemsRequestedDate IN VARCHAR2,
282 CollectISO IN VARCHAR2,
283 CollectAllOrderTypes IN VARCHAR2,
284 IncludeOrderTypes IN VARCHAR2 DEFAULT NULL,
285 ExcludeOrderTypes IN VARCHAR2 DEFAULT NULL,
286 LaunchDownload IN VARCHAR2
287 );
288
289 -- =============================================================
290 -- Desc: This procedure is invoked from web service to launch
291 -- the Demantra Collect SCI Data conc prog. The input parameters
292 -- mirror the parameters for the concurrent program.
293 -- The procedure returns a status and
294 -- concurrent program request id. The possible return
295 -- statuses are:
296 -- SUCCESS, ERROR_SUBMITTING,
297 -- INVALID_FND_USER, INVALID_FND_RESP
298 -- INVALID_COLLECTION_METHOD_NOT_2, INVALID_INSTANCE_ID, INVALID_COLLECTION_GROUP,INVALID_COLLECTION_METHOD,
299 -- INVALID_DATE_RANGE_TYPE
300 -- =============================================================
301
302 PROCEDURE RunDemantraSCIData (
303 status OUT NOCOPY VARCHAR2,
304 processid OUT NOCOPY VARCHAR2,
305 UserID IN NUMBER,
306 ResponsibilityID IN NUMBER,
307 InstanceId IN NUMBER,
308 CollectionGroup IN VARCHAR2,
309 CollectionMethod IN NUMBER,
310 DateRangeType IN NUMBER,
311 HistoryCollectionWindow IN NUMBER DEFAULT NULL,
312 DateFrom IN DATE DEFAULT NULL,
313 DateTo IN DATE DEFAULT NULL
314 );
315
316 -- =============================================================
317 -- Desc: This procedure is invoked from web service to launch
318 -- the Demantra Collect SCI Data conc prog. The input parameters
319 -- mirror the parameters for the concurrent program.
320 -- The procedure returns a status and
321 -- concurrent program request id. The possible return
322 -- statuses are:
323 -- SUCCESS, ERROR_SUBMITTING,
324 -- IINVALID_USER_NAME, INVALID_RESP_NAME
325 -- INVALID_LANGUAGE, INVALID_SECUTITY_GROUP_NAME, INVALID_FUNC_NAME
326 -- INVALID_COLLECTION_METHOD_NOT_2, INVALID_INSTANCE_ID, INVALID_COLLECTION_GROUP,INVALID_COLLECTION_METHOD,
327 -- INVALID_DATE_RANGE_TYPE
328 -- =============================================================
329
330 PROCEDURE RunDemantraSCIData_Pub(
331 processId OUT NOCOPY NUMBER,
332 status OUT NOCOPY VARCHAR2,
333 UserName IN VARCHAR2,
334 RespName IN VARCHAR2,
335 RespApplName IN VARCHAR2,
336 SecurityGroupName IN VARCHAR2,
337 Language IN VARCHAR2,
338 InstanceId IN NUMBER,
339 CollectionGroup IN VARCHAR2,
340 CollectionMethod IN NUMBER,
341 DateRangeType IN NUMBER,
342 HistoryCollectionWindow IN NUMBER DEFAULT NULL,
343 DateFrom IN DATE DEFAULT NULL,
344 DateTo IN DATE DEFAULT NULL
345 );
346
347 -- =============================================================
348 -- Desc: This procedure is invoked from web service to launch
349 -- the Demantra Collect Currency conc prog. The input parameters
350 -- mirror the parameters for the concurrent program.
351 -- The procedure returns a status and
352 -- concurrent program request id. The possible return
353 -- statuses are:
354 -- SUCCESS, ERROR_SUBMITTING,
355 -- INVALID_FND_USER, INVALID_FND_RESP
356 -- INVALID_INSTANCE_ID, INVALID_SELECTION_CURRENCY_LIST
357 -- =============================================================
358
359 PROCEDURE RunDemantraCurrConversion(
360 status OUT NOCOPY VARCHAR2,
361 processid OUT NOCOPY VARCHAR2,
362 UserID IN NUMBER,
363 ResponsibilityID IN NUMBER,
364 InstanceId IN NUMBER,
365 DateFrom IN DATE DEFAULT NULL,
366 DateTo IN DATE DEFAULT NULL,
367 CollectAllCurrencies IN VARCHAR2,
368 IncludeCurrencyList IN VARCHAR2 DEFAULT NULL,
369 ExcludeCurrencyList IN VARCHAR2 DEFAULT NULL
370 );
374 -- the Demantra Collect Currency conc prog. The input parameters
371
372 -- =============================================================
373 -- Desc: This procedure is invoked from web service to launch
375 -- mirror the parameters for the concurrent program.
376 -- The procedure returns a status and
377 -- concurrent program request id. The possible return
378 -- statuses are:
379 -- SUCCESS, ERROR_SUBMITTING,
380 -- INVALID_USER_NAME, INVALID_RESP_NAME
381 -- INVALID_LANGUAGE, INVALID_SECUTITY_GROUP_NAME, INVALID_FUNC_NAME
382 -- INVALID_INSTANCE_ID, INVALID_SELECTION_CURRENCY_LIST
383 -- =============================================================
384
385 PROCEDURE RunDemantraCurrConversion_Pub(
386 processId OUT NOCOPY NUMBER,
387 status OUT NOCOPY VARCHAR2,
388 UserName IN VARCHAR2,
389 RespName IN VARCHAR2,
390 RespApplName IN VARCHAR2,
391 SecurityGroupName IN VARCHAR2,
392 Language IN VARCHAR2,
393 InstanceId IN NUMBER,
394 DateFrom IN DATE DEFAULT NULL,
395 DateTo IN DATE DEFAULT NULL,
396 CollectAllCurrencies IN VARCHAR2,
397 IncludeCurrencyList IN VARCHAR2 DEFAULT NULL,
398 ExcludeCurrencyList IN VARCHAR2 DEFAULT NULL
399 );
400
401 -- =============================================================
402 -- Desc: This procedure is invoked from web service to launch
403 -- the Demantra UOM Conversions conc prog. The input parameters
404 -- mirror the parameters for the concurrent program.
405 -- The procedure returns a status and
406 -- concurrent program request id. The possible return
407 -- statuses are:
408 -- SUCCESS, ERROR_SUBMITTING,
409 -- INVALID_FND_USER, INVALID_FND_RESP
410 -- INVALID_INSTANCE_ID, INVALID_SELECTION_UOM_LIST
411 -- =============================================================
412 PROCEDURE RunDemantraUOMConversion(
413 status OUT NOCOPY VARCHAR2,
414 processid OUT NOCOPY VARCHAR2,
415 UserID IN NUMBER,
416 ResponsibilityID IN NUMBER,
417 InstanceId IN NUMBER,
418 IncludeAll IN VARCHAR2,
419 IncludeUomList IN VARCHAR2 DEFAULT NULL,
420 ExcludeUomList IN VARCHAR2 DEFAULT NULL
421 );
422
423 -- =============================================================
424 -- Desc: This procedure is invoked from web service to launch
425 -- the Demantra UOM Conversions conc prog. The input parameters
426 -- mirror the parameters for the concurrent program.
427 -- The procedure returns a status and
428 -- concurrent program request id. The possible return
429 -- statuses are:
430 -- SUCCESS, ERROR_SUBMITTING,INVALID_USER_NAME, INVALID_RESP_NAME
431 -- INVALID_LANGUAGE, INVALID_SECUTITY_GROUP_NAME, INVALID_FUNC_NAME INVALID_FND_USER, INVALID_FND_RESP
432 -- INVALID_INSTANCE_ID, INVALID_SELECTION_UOM_LIST
433 -- =============================================================
434
435 PROCEDURE RunDemantraUOMConversion_Pub(
436 processId OUT NOCOPY NUMBER,
437 status OUT NOCOPY VARCHAR2,
438 UserName IN VARCHAR2,
439 RespName IN VARCHAR2,
440 RespApplName IN VARCHAR2,
441 SecurityGroupName IN VARCHAR2,
442 Language IN VARCHAR2,
443 InstanceId IN NUMBER,
444 IncludeAll IN VARCHAR2,
445 IncludeUomList IN VARCHAR2 DEFAULT NULL,
446 ExcludeUomList IN VARCHAR2 DEFAULT NULL
447 );
448
449 -- =============================================================
450 -- Desc: This procedure is invoked from web service to launch
451 -- the Demantra Pricing Data conc prog. The input parameters
452 -- mirror the parameters for the concurrent program.
453 -- The procedure returns a status and
454 -- concurrent program request id. The possible return
455 -- statuses are:
456 -- SUCCESS, ERROR_SUBMITTING,
457 -- INVALID_FND_USER, INVALID_FND_RESP
458 -- INVALID_INSTANCE_ID, INVALID_SELECTION_PRICE_LIST
459 -- =============================================================
460 PROCEDURE RunDemantraPricingData(
461 status OUT NOCOPY VARCHAR2,
462 processid OUT NOCOPY VARCHAR2,
463 UserID IN NUMBER,
464 ResponsibilityID IN NUMBER,
465 InstanceId IN NUMBER,
466 DateFrom IN DATE,
467 DateTo IN DATE,
468 IncludeAllLists IN VARCHAR2,
469 IncludePriceList IN VARCHAR2 DEFAULT NULL,
470 ExcludePriceList IN VARCHAR2 DEFAULT NULL
471 );
472
473 -- =============================================================
474 -- Desc: This procedure is invoked from web service to launch
475 -- the Demantra Pricing Data conc prog. The input parameters
476 -- mirror the parameters for the concurrent program.
477 -- The procedure returns a status and
478 -- concurrent program request id. The possible return
479 -- statuses are:
480 -- SUCCESS, ERROR_SUBMITTING,
481 -- INVALID_USER_NAME, INVALID_RESP_NAME
482 -- INVALID_LANGUAGE, INVALID_SECUTITY_GROUP_NAME, INVALID_FUNC_NAME
483 -- INVALID_INSTANCE_ID, INVALID_SELECTION_PRICE_LIST
484 -- =============================================================
485
486 PROCEDURE RunDemantraPricingData_Pub(
487 processId OUT NOCOPY NUMBER,
488 status OUT NOCOPY VARCHAR2,
489 UserName IN VARCHAR2,
490 RespName IN VARCHAR2,
491 RespApplName IN VARCHAR2,
492 SecurityGroupName IN VARCHAR2,
493 Language IN VARCHAR2,
494 InstanceId IN NUMBER,
495 DateFrom IN DATE,
496 DateTo IN DATE,
497 IncludeAllLists IN VARCHAR2,
498 IncludePriceList IN VARCHAR2 DEFAULT NULL,
499 ExcludePriceList IN VARCHAR2 DEFAULT NULL
500 );
501
502
503 -- =============================================================
504 -- Desc: This procedure is invoked from web service to launch
505 -- the Demantra Returns History conc prog. The input parameters
506 -- mirror the parameters for the concurrent program.
507 -- The procedure returns a status and
508 -- concurrent program request id. The possible return
509 -- statuses are:
510 -- SUCCESS, ERROR_SUBMITTING,
511 -- INVALID_FND_USER, INVALID_FND_RESP
512 -- INVALID_INSTANCE_ID, INVALID_COLLECTION_METHOD, INVALID_COLLECTION_GROUP
513 -- =============================================================
514 PROCEDURE RunDemantraReturnsHistory(
515 status OUT NOCOPY VARCHAR2,
516 processid OUT NOCOPY VARCHAR2,
517 UserID IN NUMBER,
518 ResponsibilityID IN NUMBER,
519 InstanceId IN NUMBER,
520 CollectionGroup IN VARCHAR2,
521 CollectionMethod IN VARCHAR2,
522 DateRangeType IN VARCHAR2 DEFAULT NULL,
523 HistoryCollectionWindow IN NUMBER DEFAULT NULL,
524 DateFrom IN DATE DEFAULT NULL,
525 DateTo IN DATE DEFAULT NULL,
526 RMATypes IN MscChar255Arr
527 );
528
529 -- =============================================================
530 -- Desc: This procedure is invoked from web service to launch
531 -- the Demantra Returns History conc prog. The input parameters
532 -- mirror the parameters for the concurrent program.
533 -- The procedure returns a status and
534 -- concurrent program request id. The possible return
535 -- statuses are:
536 -- SUCCESS, ERROR_SUBMITTING,
537 -- INVALID_USER_NAME, INVALID_RESP_NAME
538 -- INVALID_LANGUAGE, INVALID_SECUTITY_GROUP_NAME, INVALID_FUNC_NAME
539 -- INVALID_INSTANCE_ID, INVALID_COLLECTION_METHOD, INVALID_COLLECTION_GROUP
540 -- =============================================================
541 PROCEDURE RunDemantraReturnsHistory_Pub(
542 processId OUT NOCOPY NUMBER,
543 status OUT NOCOPY VARCHAR2,
544 UserName IN VARCHAR2,
545 RespName IN VARCHAR2,
546 RespApplName IN VARCHAR2,
547 SecurityGroupName IN VARCHAR2,
548 Language IN VARCHAR2,
549 InstanceId IN NUMBER,
550 CollectionGroup IN VARCHAR2,
551 CollectionMethod IN VARCHAR2,
552 DateRangeType IN VARCHAR2 DEFAULT NULL,
553 HistoryCollectionWindow IN NUMBER DEFAULT NULL,
554 DateFrom IN DATE DEFAULT NULL,
555 DateTo IN DATE DEFAULT NULL,
556 RMATypes IN MscChar255Arr
557 );
558
559 END MSC_WS_COLLECTIONS;
560