1 PACKAGE XDP_INTERFACES_PUB AUTHID CURRENT_USER AS
2 /* $Header: XDPINPBS.pls 120.2.12020000.2 2013/02/28 08:51:57 rgandhi ship $ */
3 /*#
4 * A public interface for Service Fulfillment Manager that is used to submit,
5 * retrieve details or cancel Service Fulfillment Orders. Upstream systems
6 * can provide an external order number and version which can be used to track the
7 * corresponding SFM order created. The type definitions of the parameters to the
8 * APIs can be found in the PL/SQL package XDP_TYPES.
9 * @rep:scope public
10 * @rep:product XDP
11 * @rep:lifecycle active
12 * @rep:displayname Service Fulfillment Order Processing
13 * @rep:category BUSINESS_ENTITY XDP_SERVICE_ORDER
14 * @rep:comment @see XDP_TYPES#SERVICE_ORDER_HEADER
15 * @rep:comment @see XDP_TYPES#SERVICE_ORDER_PARAM_LIST
16 * @rep:comment @see XDP_TYPES#SERVICE_ORDER_LINE_LIST
17 * @rep:comment @see XDP_TYPES#SERVICE_LINE_PARAM_LIST
18 */
19
20 -- Start of comments
21 -- API name : Process_Order
22 -- Type : Public
23 -- Function : This API is used for submitting a service order to SFM.
24 -- Pre-reqs : None.
25 -- Parameters :
26 --
27 -- IN : p_api_version: NUMBER Required
28 -- p_init_msg_list: VARCHAR2 Optional
29 -- Default = FND_API.G_FALSE
30 -- p_commit: VARCHAR2 Optional
31 -- Default = FND_API.G_FALSE
32 -- When calling this API via a database link, this
33 -- parameter must be FND_API.G_FALSE
34 -- p_validation_level NUMBER Optional
35 -- Default = FND_API.G_VALID_LEVEL_FULL
36 -- p_order_header: XDP_TYPES.ORDER_HEADER Required
37 -- Order header information which requires the
38 -- following atrribute values to be supplied:
39 -- order_number:
40 -- The order identifier which is assigned by the
41 -- calling system
42 -- order_version:
43 -- The version of the order. This attribute
44 -- can be NULL
45 -- provisioning_date:
46 -- The date this order is supposed to begin
47 -- fulfillment. If the value is not supplied then
48 -- it will be default to the sysdate.
49 -- order_action:
50 -- The fulfillment action which can be applied
51 -- to all the lines in the order. This attribute is
52 -- optional.
53 -- jeopardy_enabled_flag:
54 -- The flag indicates whether the jeopardy analysis
55 -- should be enabled for the order or not. The user
56 -- can then use this flag combine with other order
57 -- information in the post process user hook package
58 -- to determine whether to start a jeopardy timer or
59 -- not. This attribute is optional.
60 -- p_order_parameter: XDP_TYPES.ORDER_PARAMETER_LIST Required
61 -- The parameters that can be accessed by all
62 -- the order lines. The list can be empty.
63 -- p_order_line_list: XDP_TYPES.ORDER_LINE_LIST Required
64 -- The list of order line items which requires
65 -- the following attribute values to be supplied:
66 -- line_number:
67 -- The index number of the current line
68 -- line_item_name:
69 -- The name of the service item
70 -- version:
71 -- The version of the service item
72 -- action:
73 -- The fulfillment action of the current line. If this
74 -- value is not supplied, SFM will default it to the order
75 -- action
76 -- provisioning_date:
77 -- The date this order line is scheduled to
78 -- be fulfilled. If the value is not supplied SFM will
79 -- default it to order provisioning date.
80 -- provisioning_sequence:
81 -- SFM uses this attrribute to determine dependency between
82 -- order lines. If the value is not supplied SFM will
83 -- assume there is not dependency for this line.
84 -- p_line_parameter_list: XDP_TYPES.LINE_PARAM_LIST Required
85 -- The list of the parameters for each order line. The list
86 -- can be empty. For every record in the list, the
87 -- following attribute values to be supplied:
88 -- line_number:
89 -- The line number of this parameter is associated with
90 -- parameter_name:
91 -- The name of the parameter
92 -- parameter_value:
93 -- The value of the parameter. It can be null.
94 -- parameter_ref_value:
95 -- The reference value of the parameter. This
96 -- attribute is optional.
97 --
98 -- OUT : x_return_status: VARCHAR2(1) Required
99 -- The caller must examine this parameter value
100 -- after the call is completed. If the value is
101 -- FND_API.G_RET_STS_SUCCESS, the caller routine
102 -- must do commit, otherwise, the caller routine
103 -- must do rollback.
104 -- x_msg_count: NUMBER
105 -- x_msg_data: VARCHAR2(2000)
106 -- x_sdp_Order_id: NUMBER
107 -- The internal order ID which is assigned by SFM
108 -- when an order is successfully submitted to SFM
109 --
110 -- Version : Current version 11.5
111 -- Notes :
112 -- This API is used for upstream ordering system to submit a
113 -- service order to SFM. If the customer wishes to perform order
114 -- dependency and jeopardy analysis, he or she can put the
115 -- business logic in the post process API under the customer
116 -- hook package which will be supported by SFM per CRM coding
117 -- standard.
118 --
119 -- End of comments
120 PROCEDURE Process_Order(
121 p_api_version IN NUMBER,
122 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
123 p_commit IN VARCHAR2 := FND_API.G_FALSE,
124 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
125 x_RETURN_STATUS OUT NOCOPY VARCHAR2,
126 x_msg_count OUT NOCOPY NUMBER,
127 x_msg_data OUT NOCOPY VARCHAR2,
128 P_ORDER_HEADER IN XDP_TYPES.ORDER_HEADER,
129 P_ORDER_PARAMETER IN XDP_TYPES.ORDER_PARAMETER_LIST,
130 P_ORDER_LINE_LIST IN XDP_TYPES.ORDER_LINE_LIST,
131 P_LINE_PARAMETER_LIST IN XDP_TYPES.LINE_PARAM_LIST,
132 x_SDP_ORDER_ID OUT NOCOPY NUMBER);
133
134 -- Start of comments
135 -- API name : Cancel_Order
136 -- Type : Public
137 -- Function : This API is used for canceling a service order
138 -- Pre-reqs : None.
139 -- Parameters :
140 --
141 -- IN : p_api_version: NUMBER Required
142 -- p_init_msg_list: VARCHAR2 Optional
143 -- Default = FND_API.G_FALSE
144 -- p_commit: VARCHAR2 Optional
145 -- Default = FND_API.G_FALSE
146 -- This API is an autonomous routine which
147 -- handles the database transaction independently.
148 -- The value of p_commit parameter will be ignored.
149 -- p_validation_level NUMBER Optional
150 -- Default = FND_API.G_VALID_LEVEL_FULL
151 -- p_sdp_Order_id: NUMBER Required
152 -- The internal order ID which was assigned by SFM
153 -- when an order was successfully submitted to SFM
154 -- p_caller_name: VARCHAR2 Required
155 -- The name of the user who is calling this API
156 --
157 -- OUT : x_return_status: VARCHAR2(1) Required
158 -- The execution status of the API call.
159 -- x_msg_count: NUMBER
160 -- x_msg_data: VARCHAR2(2000)
161 --
162 -- Version : Current version 11.5
163 -- Notes :
164 -- This API is used for upstream ordering system to cancel
165 -- a service order which was submitted to SFM previously.
166 --
167 -- End of comments
168
169 PROCEDURE Cancel_Order(
170 p_api_version IN NUMBER,
171 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
172 p_commit IN VARCHAR2 := FND_API.G_FALSE,
173 p_validation_level IN NUMBER :=
174 FND_API.G_VALID_LEVEL_FULL,
175 x_RETURN_STATUS OUT NOCOPY VARCHAR2,
176 x_msg_count OUT NOCOPY NUMBER,
177 x_msg_data OUT NOCOPY VARCHAR2,
178 P_SDP_ORDER_ID IN NUMBER,
179 p_caller_name IN VARCHAR2 );
180
181 -- Start of comments
182 -- API name : Get_Order_Parameter_List
183 -- Type : Public
184 -- Function : This API is used for retrieve order parameter list
185 -- Pre-reqs : XDP_ENGIN.PARAMETER_LIST
186 -- Parameters :
187 --
188 -- IN : p_api_version: NUMBER Required
189 -- p_sdp_Order_id: NUMBER Required
190 -- The internal order ID which was assigned by SFM
191 -- when an order was successfully submitted to SFM
192 -- p_caller_name: VARCHAR2 Required
193 -- The name of the user who is calling this API
194 --
195 -- OUT : x_return_status: VARCHAR2(1) Required
196 -- The execution status of the API call.
197 -- x_return_msg: VARCHAR2(2000)
198 -- The execution comments of the API call
199 -- x_order_param_list: XDP_ENGINE.PARAMETER_LIST;
200 --
201 -- Version : Current version 11.5
202 -- Notes :
203 -- This API is used for upstream ordering system to retrieve order parameter list
204 -- for further used to acquire order parameter value.
205 --
206 -- End of comments
207
208 PROCEDURE Get_Order_Parameter_List(
209 p_api_version IN NUMBER,
210 x_RETURN_STATUS OUT NOCOPY VARCHAR2,
211 x_RETURN_MSG OUT NOCOPY VARCHAR2,
212 x_ORDER_PARAM_LIST OUT NOCOPY XDP_ENGINE.PARAMETER_LIST,
213 P_SDP_ORDER_ID IN NUMBER,
214 p_CALLER_NAME IN VARCHAR2 );
215
216 -- Start of comments
217 -- API name : Get_Order_Parameter_Value
218 -- Type : Public
219 -- Function : This API is used for retrieve order parameter value
220 -- Pre-reqs :
221 -- Parameters :
222 --
223 -- IN : p_api_version: NUMBER Required
224 -- p_sdp_Order_id: NUMBER Required
225 -- The internal order ID which was assigned by SFM
226 -- when an order was successfully submitted to SFM
227 -- p_order_param_name: VARCHAR2 Required
228 -- The name of the order parameter whose value will be retrieved
229 -- by calling this API
230 -- p_caller_name: VARCHAR2 Required
231 -- The name of the user who is calling this API
232 --
233 -- OUT : x_return_status: VARCHAR2(1) Required
234 -- The execution status of the API call.
235 -- x_return_msg: VARCHAR2(2000)
236 -- The execution comments of the API call
237 -- x_order_param_value: VARCHAR2;
238 --
239 -- Version : Current version 11.5
240 -- Notes :
241 -- This API is used for upstream ordering system to retrieve order parameter value.
242 --
243 -- End of comments
244
245 PROCEDURE Get_Order_Parameter_Value(
246 p_api_version IN NUMBER,
247 x_RETURN_STATUS OUT NOCOPY VARCHAR2,
248 x_RETURN_MSG OUT NOCOPY VARCHAR2,
249 x_ORDER_PARAM_VALUE OUT NOCOPY VARCHAR2,
250 p_SDP_ORDER_ID IN NUMBER,
251 p_ORDER_PARAM_NAME IN VARCHAR2,
252 p_CALLER_NAME IN VARCHAR2 );
253
254 -- Start of comments
255 -- API name : Get_Line_Parameter_Value
256 -- Type : Public
257 -- Function : This API is used for retrieve order line item parameter value
258 -- Pre-reqs :
259 -- Parameters :
260 --
261 -- IN : p_api_version: NUMBER Required
262 -- p_sdp_Order_id: NUMBER Required
263 -- The internal order ID which was assigned by SFM
264 -- when an order was successfully submitted to SFM
265 -- p_Line_Number: NUMBER Required
266 -- The line number supplied by upstream ordering system when
267 -- submiting an order
268 -- p_Line_param_name: VARCHAR2 Required
269 -- The name of the order parameter whose value will be retrieved
270 -- by calling this API
271 -- p_caller_name: VARCHAR2 Required
272 -- The name of the user who is calling this API
273 --
274 -- OUT : x_return_status: VARCHAR2(1) Required
275 -- The execution status of the API call.
276 -- x_return_msg: VARCHAR2(2000)
277 -- The execution comments of the API call
278 -- x_Line_param_value: VARCHAR2;
279 --
280 -- Version : Current version 11.5
281 -- Notes :
282 -- This API is used for upstream ordering system to retrieve order line item parameter value.
283 --
284 -- End of comments
285
286 PROCEDURE Get_Line_Parameter_Value(
287 p_api_version IN NUMBER,
288 x_RETURN_STATUS OUT NOCOPY VARCHAR2,
289 x_RETURN_MSG OUT NOCOPY VARCHAR2,
290 x_LINE_PARAM_VALUE OUT NOCOPY VARCHAR2,
291 p_SDP_ORDER_ID IN NUMBER,
292 P_LINE_NUMBER IN NUMBER,
293 p_LINE_PARAM_NAME IN VARCHAR2,
294 p_CALLER_NAME IN VARCHAR2 );
295 --
299 -- Start of comments
296 -- Implementation for Open Interface
297 -- 06/07/2001
298
300 -- API name : Process_Order
301 -- Type : Public
302 -- Function : This API is used for submitting a service order to SFM.
303 -- Pre-reqs : None.
304 -- Parameters :
305 --
306 -- IN : p_api_version: NUMBER Required
307 --
308 -- p_init_msg_list: VARCHAR2 Optional
309 -- Default = FND_API.G_FALSE
310 --
311 -- p_commit: VARCHAR2 Optional
312 -- Default = FND_API.G_FALSE
313 -- When calling this API via a database link, this
314 -- parameter must be FND_API.G_FALSE
315 --
316 -- p_validation_level NUMBER Optional
317 -- Default = FND_API.G_VALID_LEVEL_FULL
318 --
319 -- p_order_header: XDP_TYPES.SERVICE_ORDER_HEADER Required
320 -- Order header information which requires the
321 -- following atrribute values to be supplied:
322 --
323 -- order_number:
324 -- The order identifier which is assigned by the
325 -- calling system
326 --
327 -- order_version:
328 -- The version of the order. This attribute
329 -- can be NULL
330 --
331 -- provisioning_date:
332 -- The date this order is supposed to begin
333 -- fulfillment. If the value is not supplied then
334 -- it will be default to the sysdate.
335 --
336 -- jeopardy_enabled_flag:
337 -- The flag indicates whether the jeopardy analysis
338 -- should be enabled for the order or not. The user
339 -- can then use this flag combine with other order
340 -- information in the post process user hook package
341 -- to determine whether to start a jeopardy timer or
342 -- not. This attribute is optional.
343 --
344 -- order_ref_name:
345 -- This field is used to identify the type of the source system
346 -- for this order. It should be only of the following value
347 -- For Sales Orders:
348 -- ORDER_REF_NAME = 'SALES'
349 -- For Service Requests:
350 -- ORDER_REF_NAME = 'SERVICE_REQUEST'
351 -- execution_mode
352 -- This field indicate the order should be fulfilled sycn or asynchnorosly
353 -- Valid values are 'SYNC' and 'ASYNC'
354 --
355 -- account_id/account_number:
356 -- For whom the order is submitted on behalf of.
357 -- one of these two fields must be specified
358 -- The account must exist in the TCA model.
359 --
360 -- p_order_param_list: XDP_TYPES.SERVICE_ORDER_PARAM_LIST Required
361 -- The parameters that can be accessed by all
362 -- the order lines. The list can be empty.
363 -- p_order_line_list: XDP_TYPES.SERVICE_ORDER_LINE_LIST Required
364 -- The list of order line items which requires
365 -- the following attribute values to be supplied:
366 --
367 -- line_number:
368 -- The index number of the current line
369 --
370 -- line_source:
371 -- Source object name of the upstream application
372 --
373 -- inventory_item_id:
374 -- The item id in Oracle product catalog
375 -- service_item_name:
376 -- The item name in Oracle product catalog or workitem name in SFM
377 --
378 -- version:
379 -- The version of the workitem item. Only applicable when
380 -- serive_item_name is a workitem
381 -- action_code:
382 -- The fulfillment action of the current line.
383 --
384 -- fulfillment_date:
385 -- The date this order line is scheduled to
386 -- be fulfilled. If the value is not supplied SFM will
387 -- default it to order fulfillment date.
388 --
389 -- fulfillment_sequence:
390 -- SFM uses this attrribute to determine dependency between
391 -- order lines. If the value is not supplied SFM will
392 -- assume there is not dependency for this line.
393 --
394 -- organization_code/organization_id:
395 -- SFM uses these attrributes to determine organization id for the
396 -- item in the inventory system.
397 --
398 -- site_use_id:
399 -- SFM uses this attrribute to determine install to address for this item
400 --
401 -- ib_source:
402 -- SFM uses this attrribute to determine
403 -- Oracle Installed Base system to which SFM will
404 -- update product installation information for the customer
405 --
406 -- ib_source_id:
407 -- SFM uses this attrribute to determine
408 -- value that uniquely identifies a transaction line detail
409 -- in Oracle Installed Base or an item instance in
410 -- Oracle Installed Base
411 --
412 -- required_fulfillment_date:
413 -- The date customer requires for this item to be fulfilled
414 --
415 -- bundle_id:
416 -- If this line item is part of a bundle, this fields identify
417 -- the bundle it belongs to. Reserved.
418 --
419 -- bundle_sequence:
420 -- If this line item is part of a bundle, this fields identify
421 -- the sequence of this itme in the bundle, Reserved.
422 --
423 -- priority:
424 -- The priority of the line item to be fulfilled.
425 --
426 -- due_date:
427 -- The data the order should be fulfilled, otherwise, a
428 -- jeopardy event could be fired.
429 --
430 -- jeopardy_enabled_flag:
431 -- The flag indicates whether the jeopardy analysis
432 -- should be enabled for the order or not. The user
436 -- not. This attribute is optional.
433 -- can then use this flag combine with other order
434 -- information in the post process user hook package
435 -- to determine whether to start a jeopardy timer or
437 --
438 -- starting_number:
439 -- NP number range
440 --
441 -- ending_number:
442 -- NP number range
443 --
444 -- attribute 1-20:
445 -- Descriptive flexfields.
446 --
447 -- p_line_param_list: XDP_TYPES.G_MISS_LINE_PARAM_LIST Required
448 -- The list of the parameters for each order line. The list
449 -- can be empty. For every record in the list, the
450 -- following attribute values to be supplied:
451 -- line_number:
452 -- The line number of this parameter is associated with
453 -- parameter_name:
454 -- The name of the parameter
455 -- parameter_value:
456 -- The value of the parameter. It can be null.
457 -- parameter_ref_value:
458 -- The reference value of the parameter. This
459 -- attribute is optional.
460 --
461 -- OUT : x_return_status: VARCHAR2(1) Required
462 -- The caller must examine this parameter value
463 -- after the call is completed. If the value is
464 -- FND_API.G_RET_STS_SUCCESS, the caller routine
465 -- must do commit, otherwise, the caller routine
466 -- must do rollback.
467 -- x_msg_count: NUMBER
468 -- x_msg_data: VARCHAR2(2000)
469 -- x_order_id: NUMBER
470 -- The internal order ID which is assigned by SFM
471 -- when an order is successfully submitted to SFM
472 -- x_error_code VARCHAR2
473 -- The application error code that is specific to SFM
474 --
475 -- Version : Current version 11.5
476 -- Notes :
477 -- This API is used for upstream systems to submit a
478 -- service order to SFM. If the customer wishes to perform order
479 -- dependency and jeopardy analysis, he or she can put the
480 -- business logic in the post process API under the customer
481 -- hook package which will be supported by SFM per CRM coding
482 -- standard.
483 --
484 -- End of comments
485 /*#
486 * Submit a Service Fulfillment Order for processing. The order information is to be submitted as a set of
487 * SFM order structures, which include the order header, order parameters, order lines and order line parameters.
488 * An external order number and version can be specified in the order header. The internal order id is returned.
489 *
490 * @param p_api_version API version used to check call compatibility. Current version is '11.5'.
491 * @param p_init_msg_list Flag indicating whether internal message tables should be initialized.
492 * @param p_commit Flag indicating whether this API should commit the transaction, if the call is successful.
493 * @param p_validation_level The level of input validation required from the API.
494 * @param x_return_status Return status of API call.
495 * @param x_msg_count Count of stored processing messages.
496 * @param x_msg_data List of all stored processing messages.
497 * @param x_error_code SFM-specific application error code returned.
498 * @param p_order_header Header-level value information for the service order.
499 * @paraminfo {@rep:innertype XDP_TYPES.SERVICE_ORDER_HEADER}
500 * @param p_order_param_list List of header-level parameters. Each parameter is a name-value pair.
501 * @paraminfo {@rep:innertype XDP_TYPES.SERVICE_ORDER_PARAM_LIST}
502 * @param p_order_line_list Line-level value information for the service order.
503 * @paraminfo {@rep:innertype XDP_TYPES.SERVICE_ORDER_LINE_LIST}
504 * @param p_line_param_list List of line-level parameters. Each parameter is a name-value pair.
505 * @paraminfo {@rep:innertype XDP_TYPES.SERVICE_LINE_PARAM_LIST}
506 * @param x_order_id The SFM order id for the service order.
507 * @rep:scope public
508 * @rep:lifecycle active
509 * @rep:displayname Process Service Fulfillment Order
510 */
511 PROCEDURE Process_Order(
512 p_api_version IN NUMBER,
513 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
514 p_commit IN VARCHAR2 := FND_API.G_FALSE,
515 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
516 x_return_status OUT NOCOPY VARCHAR2,
517 x_msg_count OUT NOCOPY NUMBER,
518 x_msg_data OUT NOCOPY VARCHAR2,
519 x_error_code OUT NOCOPY VARCHAR2,
520 p_order_header IN XDP_TYPES.SERVICE_ORDER_HEADER := XDP_TYPES.G_MISS_SERVICE_ORDER_HEADER,
521 p_order_param_list IN XDP_TYPES.SERVICE_ORDER_PARAM_LIST := XDP_TYPES.G_MISS_ORDER_PARAM_LIST,
522 p_order_line_list IN XDP_TYPES.SERVICE_ORDER_LINE_LIST := XDP_TYPES.G_MISS_SERVICE_ORDER_LINE_LIST,
523 p_line_param_list IN XDP_TYPES.SERVICE_LINE_PARAM_LIST := XDP_TYPES.G_MISS_LINE_PARAM_LIST,
524 x_order_id OUT NOCOPY NUMBER
525 );
526
527 -- Start of comments
528 -- API name : Cancel_Order
529 -- Type : Public
530 -- Function : This API is used for canceling a service order
531 -- Pre-reqs : None.
532 -- Parameters :
533 --
534 -- IN : p_api_version: NUMBER Required
535 --
536 -- p_init_msg_list: VARCHAR2 Optional
537 -- Default = FND_API.G_FALSE
538 --
539 -- p_commit: VARCHAR2 Optional
540 -- Default = FND_API.G_FALSE
541 -- This API is an autonomous routine which
542 -- handles the database transaction independently.
543 -- The value of p_commit parameter will be ignored.
544 --
545 -- p_validation_level NUMBER Optional
546 -- Default = FND_API.G_VALID_LEVEL_FULL
547 --
548 -- p_order_id: NUMBER requried if p_order_number is null
549 -- The internal order ID which was assigned by SFM
550 -- when an order was successfully submitted to SFM
551 --
555 -- to cancel
552 -- p_order_number: VARCHAR2 requried if p_order_id is null
553 -- The order number given by the caller when the order is submitted.
554 -- This field with p_version will be used to identify which order
556 --
557 -- p_order_version: VARCHAR2 Required
558 --
559 --
560 -- OUT : x_return_status: VARCHAR2(1) Required
561 -- The execution status of the API call.
562 -- x_msg_count: NUMBER
563 -- x_msg_data: VARCHAR2(2000)
564 -- x_error_code VARCHAR2
565 -- The application error code that is specific to SFM
566 --
567 -- Version : Current version 11.5
568 -- Notes :
569 -- This API is used for upstream ordering system to cancel
570 -- a service order which was submitted to SFM previously.
571 --
572 -- End of comments
573 /*#
574 * Cancel a Service Fulfillment Order. A known external order number and version or a known SFM order id must be supplied.
575 * The given order number and version are references specified by the upstream ordering system while submitting a new service order.
576 * SFM order id is the internal order identifier for a service order in SFM.
577 *
578 * @param p_api_version API version used to check call compatibility. Current version is '11.5'.
579 * @param p_init_msg_list Flag indicating whether internal message tables should be initialized.
580 * @param p_commit This parameter is ignored. This API is an autonomous routine, which handles the database transaction independently.
581 * @param p_validation_level The level of input validation required from the API.
582 * @param x_return_status Return status of API call.
583 * @param x_msg_count Count of stored processing messages.
584 * @param x_msg_data List of all stored processing messages.
585 * @param p_order_number The external order number reference value.
586 * @param p_order_version The external order version reference value. This parameter is optional and is defaulted to '1'.
587 * @param p_order_id The SFM order id. This value is optional if p_order_number is specified.
588 * @param x_error_code SFM-specific error code returned in case of errors.
589 * @param p_caller_name The calling user/module. This parameter is optional.
590 * @rep:scope public
591 * @rep:lifecycle active
592 * @rep:displayname Cancel Service Fulfillment Order
593 */
594 PROCEDURE Cancel_Order(
595 p_api_version IN NUMBER := FND_API.G_MISS_NUM,
596 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
597 p_commit IN VARCHAR2 := FND_API.G_FALSE,
598 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
599 x_return_status OUT NOCOPY VARCHAR2,
600 x_msg_count OUT NOCOPY NUMBER,
601 x_msg_data OUT NOCOPY VARCHAR2,
602 p_order_number IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
603 p_order_version IN VARCHAR2 DEFAULT '1',
604 p_order_id IN NUMBER := FND_API.G_MISS_NUM,
605 x_error_code OUT NOCOPY VARCHAR2,
606 p_caller_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
607 );
608
609 -- Start of comments
610 -- API name : Get_Order_Details
611 -- Type : Public
612 -- Function : This API is used for retrieving current information about
613 -- a service order
614 -- Pre-reqs : None.
615 -- Parameters :
616 --
617 -- IN : p_api_version: NUMBER Required
618 --
619 -- p_init_msg_list: VARCHAR2 Optional
620 -- Default = FND_API.G_FALSE
621 --
622 -- p_commit: VARCHAR2 Optional
623 -- Default = FND_API.G_FALSE
624 -- This API is an autonomous routine which
625 -- handles the database transaction independently.
626 -- The value of p_commit parameter will be ignored.
627 --
628 -- p_validation_level NUMBER Optional
629 -- Default = FND_API.G_VALID_LEVEL_FULL.
630 --
631 -- p_order_id: NUMBER requried if p_order_number is null
632 -- The internal order ID which was assigned by SFM
633 -- when an order was successfully submitted to SFM.
634 --
635 -- p_order_number: VARCHAR2 requried if p_order_id is null
636 -- The order number given by the caller when the order is submitted.
637 -- This field with p_version will be used to identify which order
638 -- to cancel.
639 --
640 -- p_order_version: VARCHAR2, Optional.
641 --
642 --
643 -- OUT : x_return_status: VARCHAR2(1) Required
644 -- The execution status of the API call.
645 --
646 -- x_msg_count: NUMBER
647 --
648 -- x_msg_data: VARCHAR2(2000)
649 --
650 -- x_error_code VARCHAR2
651 -- The application error code that is specific to SFM
652 --
653 -- x_order_header
654 -- Order header information which contains current information
655 -- in SFM systme for the following atrributes:
656 --
657 -- order_number:
658 -- The order identifier which is assigned by the
659 -- calling system
660 --
661 -- order_version:
662 -- The version of the order. This attribute
663 -- can be NULL
664 --
665 -- provisioning_date:
666 -- The date this order is supposed to begin
667 -- fulfillment. If the value is not supplied then
668 -- it will be default to the sysdate.
669 --
670 -- jeopardy_enabled_flag:
671 -- The flag indicates whether the jeopardy analysis
672 -- should be enabled for the order or not. The user
673 -- can then use this flag combine with other order
674 -- information in the post process user hook package
675 -- to determine whether to start a jeopardy timer or
676 -- not. This attribute is optional.
677 --
678 -- execution_mode
682 -- account_id/account_number:
679 -- This field indicate the order should be fulfilled sycn or asynchnorosly
680 -- Valid values are 'SYNC' and 'ASYNC'
681 --
683 -- For whom the order is submitted on behalf of.
684 -- one of these two fields must be specified
685 -- The account must exist in the TCA model.
686 -- order_status
687 -- Current SFM order status
688 --
689 -- fulfillment_status
690 -- Current value of order parameter "Fulfillemnt Status"
691 --
692 -- fulfillment_result
693 -- Current value of order parameter "Fulfillemnt Result"
694 --
695 -- actual_fulfillment_date
696 -- The date when the fulfillment process was started for this order
697 --
698 -- completiont_date
699 -- The date when this order is fulfilled
700 --
701 -- x_order_param_list
702 -- The list of name value pair for this order. Values are the most updated ones
703 --
704 -- x_line_item_list
705 -- The table of line items of this order. Each record contains updated information
706 -- about this line item. For more details about field of this record, please refer
707 -- to the definition of record Service_Line_Item.
708 --
709 -- x_line_param_list
710 -- The list of name value pair for line items of this order. Values are the most updated ones
711 --
712 -- Version : Current version 11.5
713 -- Notes :
714 -- This API is used for upstream ordering system to cancel
715 -- a service order which was submitted to SFM previously.
716 --
717 -- End of comments
718 /*#
719 * Retrieve order header, lines and other information from a Service Fulfillment Order. An external order number and version or a known SFM order id must be supplied.
720 * The given order number and version are references specified by the upstream ordering system while submitting a new service order. SFM order id is the
721 * internally assigned order identifier for a service order in SFM.
722 * @param p_api_version API version used to check call compatibility. Current version is '11.5'.
723 * @param p_init_msg_list Flag indicating whether internal message tables should be initialized.
724 * @param p_commit This parameter is optional and is ignored.
725 * @param p_validation_level The level of input validation required from the API.
726 * @param x_return_status Return status of API call.
727 * @param x_msg_count Count of stored processing messages.
728 * @param x_msg_data List of all stored processing messages.
729 * @param x_error_code SFM-specific error code returned in case of errors.
730 * @param p_order_number The external order number reference value.
731 * @param p_order_version The external order version reference value. This parameter is optional and is defaulted to '1'.
732 * @param p_order_id The SFM order id. This value is optional if p_order_number is specified.
733 * @param x_order_header Header-level value information retrieved from the service order.
734 * @paraminfo {@rep:innertype XDP_TYPES.SERVICE_ORDER_HEADER}
735 * @param x_order_param_list List of header-level parameters retrieved from the service order. Each parameter is a name-value pair.
736 * @paraminfo {@rep:innertype XDP_TYPES.SERVICE_ORDER_PARAM_LIST}
737 * @param x_line_item_list Line-level value information retrieved from the service order.
738 * @paraminfo {@rep:innertype XDP_TYPES.SERVICE_ORDER_LINE_LIST}
739 * @param x_line_param_list List of line-level parameters retrieved from the service order. Each record is a name-value pair.
740 * @paraminfo {@rep:innertype XDP_TYPES.SERVICE_LINE_PARAM_LIST}
741 * @rep:scope public
742 * @rep:lifecycle active
743 * @rep:displayname Get Service Fulfillment Order Details
744 */
745 PROCEDURE Get_Order_Details(
746 p_api_version IN NUMBER ,
747 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
748 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
749 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
750 x_return_status OUT NOCOPY VARCHAR2,
751 x_msg_count OUT NOCOPY NUMBER,
752 x_msg_data OUT NOCOPY VARCHAR2,
753 x_error_code OUT NOCOPY VARCHAR2,
754 p_order_number IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
755 p_order_version IN VARCHAR2 DEFAULT '1',
756 p_order_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
757 x_order_header OUT NOCOPY XDP_TYPES.SERVICE_ORDER_HEADER,
758 x_order_param_list OUT NOCOPY XDP_TYPES.SERVICE_ORDER_PARAM_LIST,
759 x_line_item_list OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
760 x_line_param_list OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST
761 );
762
763 -- Start of comments
764 -- API name : Get_Order_Status
765 -- Type : Public
766 -- Function : This API is used for retrieving status of
767 -- a service order
768 -- Pre-reqs : None.
769 -- Parameters :
770 --
771 -- IN : p_api_version: NUMBER Required
772 --
773 -- p_init_msg_list: VARCHAR2 Optional
774 -- Default = FND_API.G_FALSE
775 --
776 -- p_commit: VARCHAR2 Optional
777 -- Default = FND_API.G_FALSE
778 -- This API is an autonomous routine which
779 -- handles the database transaction independently.
780 -- The value of p_commit parameter will be ignored.
781 --
782 -- p_validation_level NUMBER Optional
783 -- Default = FND_API.G_VALID_LEVEL_FULL.
784 --
785 -- p_order_id: NUMBER requried if p_order_number is null
786 -- The internal order ID which was assigned by SFM
787 -- when an order was successfully submitted to SFM.
788 --
789 -- p_order_number: VARCHAR2 requried if p_order_id is null
790 -- The order number given by the caller when the order is submitted.
791 -- This field with p_version will be used to identify which order
792 -- to cancel.
793 --
794 -- p_order_version: VARCHAR2, Optional.
795 --
796 --
797 -- OUT : x_return_status: VARCHAR2(1) Required
798 -- The execution status of the API call.
799 --
800 -- x_msg_count: NUMBER
801 --
802 -- x_msg_data: VARCHAR2(2000)
803 --
804 -- x_error_code VARCHAR2
805 -- The application error code that is specific to SFM
806 --
807 -- x_order_status SERVICE_ORDER_STATUS
808 -- Record that holds order status information which contains the
809 -- following fields
810 --
811 -- order_id: NUMBER
812 -- The internal order ID which was assigned by SFM
813 -- when an order was successfully submitted to SFM.
814 --
815 -- order_number: VARCHAR2
816 -- The order number given by the caller when the order is submitted.
817 -- This field with p_version will be used to identify which order
818 -- to cancel.
819 --
820 -- order_version: VARCHAR2
821
822 -- order_status
823 -- Current SFM order status
824 --
825 -- fulfillment_status
826 -- Current value of order parameter "Fulfillemnt Status"
827 --
828 -- fulfillment_result
829 -- Current value of order parameter "Fulfillemnt Result"
830 --
831 -- actual_fulfillment_date
832 -- The date when the fulfillment process was started for this order
833 --
834 -- completion_date
835 -- The date when this order is fulfilled
836 --
837 -- End of comments
838 /*#
839 * Retrieve the fulfillment status of a Service Fulfillment Order. An external order number and version or a known SFM order id must be supplied.
840 * The given order number and version are references specified by the upstream ordering system while submitting a new service order. SFM order id is the
841 * internally assigned order identifier for a service order in SFM.
842 * @param p_api_version API version used to check call compatibility. Current version is '11.5'.
843 * @param p_init_msg_list Flag indicating whether internal message tables should be initialized.
844 * @param p_commit This parameter is optional and is ignored.
845 * @param p_validation_level The level of input validation required from the API.
846 * @param x_return_status Return status of API call.
847 * @param x_msg_count Count of stored processing messages.
848 * @param x_msg_data List of all stored processing messages.
849 * @param x_error_code SFM-specific error code returned in case of errors.
850 * @param p_order_number The external order number reference value.
851 * @param p_order_version The external order version reference value. This parameter is optional and is defaulted to '1'.
852 * @param p_order_id The SFM order id. This value is optional if p_order_number is specified.
853 * @param x_order_status Status information record for the service order.
854 * @paraminfo {@rep:innertype XDP_TYPES.SERVICE_ORDER_STATUS}
855 * @rep:scope public
856 * @rep:lifecycle active
857 * @rep:displayname Get Service Fulfillment Order Status
858 */
859 PROCEDURE Get_Order_Status(
860 p_api_version IN NUMBER,
861 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
862 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
863 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
864 x_return_status OUT NOCOPY VARCHAR2,
865 x_msg_count OUT NOCOPY NUMBER,
866 x_msg_data OUT NOCOPY VARCHAR2,
867 x_error_code OUT NOCOPY VARCHAR2,
868 p_order_number IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
869 p_order_version IN VARCHAR2 DEFAULT '1',
870 p_order_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
871 x_order_status OUT NOCOPY XDP_TYPES.SERVICE_ORDER_STATUS
872 );
873
874 END XDP_INTERFACES_PUB;
[Home] [Help]