1 PACKAGE XDP_INTERFACES AUTHID CURRENT_USER AS
2 /* $Header: XDPINTFS.pls 120.1 2005/06/08 23:54:30 appldev $ */
3
4
5 -- Start of comments
6 -- API name : Process_Order
7 -- Type : Private
8 -- Function :
9 -- Pre-reqs : None.
10 -- Parameters :
11 --
12 -- IN : p_order_header: XDP_TYPES.ORDER_HEADER Required
13 -- Order header information which requires the
14 -- following atrribute values to be supplied:
15 -- order_number:
16 -- The order identifier which is assigned by the
17 -- calling system
18 -- order_version:
19 -- The version of the order. This attribute
20 -- can be NULL
21 -- provisioning_date:
22 -- The date this order is supposed to begin
23 -- fulfillment. If the value is not supplied then
24 -- it will be default to the sysdate.
25 -- order_action:
26 -- The fulfillment action which can be applied
27 -- to all the lines in the order. This attribute is
28 -- optional.
29 -- jeopardy_enabled_flag:
30 -- The flag indicates whether the jeopardy analysis
31 -- should be enabled for the order or not. The user
32 -- can then use this flag combine with other order
33 -- information in the post process user hook package
34 -- to determine whether to start a jeopardy timer or
35 -- not. This attribute is optional.
36 -- p_order_parameter: XDP_TYPES.ORDER_PARAMETER_LIST Required
37 -- The parameters that can be accessed by all
38 -- the order lines. The list can be empty.
39 -- p_order_line_list: XDP_TYPES.ORDER_LINE_LIST Required
40 -- The list of order line items which requires
41 -- the following attribute values to be supplied:
42 -- line_number:
43 -- The index number of the current line
44 -- line_item_name:
45 -- The name of the service item
46 -- version:
47 -- The version of the service item
48 -- action:
49 -- The fulfillment action of the current line. If this
50 -- value is not supplied, SFM will default it to the order
51 -- action
52 -- provisioning_date:
53 -- The date this order line is scheduled to
54 -- be fulfilled. If the value is not supplied SFM will
55 -- default it to order provisioning date.
56 -- provisioning_sequence:
57 -- SFM uses this attrribute to determine dependency between
58 -- order lines. If the value is not supplied SFM will
59 -- assume there is not dependency for this line.
60 -- p_line_parameter_list: XDP_TYPES.LINE_PARAM_LIST Required
61 -- The list of the parameters for each order line. The list
62 -- can be empty. For every record in the list, the
63 -- following attribute values to be supplied:
64 -- line_number:
65 -- The line number of this parameter is associated with
66 -- parameter_name:
67 -- The name of the parameter
68 -- parameter_value:
69 -- The value of the parameter. It can be null.
70 -- parameter_ref_value:
71 -- The reference value of the parameter. This
72 -- attribute is optional.
73 --
74 -- OUT : sdp_order_id: NUMBER
75 -- The internal order ID which is assigned by SFM
76 -- which an order is successfully submitted to SFM
77 -- return_code: NUMBER
78 -- This output argument is to indicate if the API
79 -- call is made sucessfully. The value of 0 means
80 -- the call is made sucessfully, while any non-zero
81 -- value means otherwise.
82 -- The caller must examine this parameter value
83 -- after the call is completed. If the value is
84 -- 0, the caller routine must do commit, otherwise,
85 -- the caller routine must do rollback.
86 -- error_description: VARCHAR2
87 -- The decription of the error encountered
88 -- when the return_code is not 0.
89 --
90 -- Version : Current version 11.5
91 -- Notes :
92 -- This API is used as an internal API to submit a
93 -- service order to SFM.
94 --
95 -- End of comments
96 PROCEDURE Process_Order(
97 P_ORDER_HEADER IN XDP_TYPES.ORDER_HEADER,
98 P_ORDER_PARAMETER IN XDP_TYPES.ORDER_PARAMETER_LIST,
99 P_ORDER_LINE_LIST IN XDP_TYPES.ORDER_LINE_LIST,
100 P_LINE_PARAMETER_LIST IN XDP_TYPES.LINE_PARAM_LIST,
101 SDP_ORDER_ID OUT NOCOPY NUMBER,
102 RETURN_CODE IN OUT NOCOPY NUMBER,
103 ERROR_DESCRIPTION IN OUT NOCOPY VARCHAR2);
104 --
105 -- This is a backward compatibility implementation of
106 -- DRC orders. It is called by
107 -- XDP_DRC_UTIL_PUB.Process_DRC_ORDER
108 -- This will eventually be phased out
109 --
110 PROCEDURE Process_DRC_Order(
111 p_workitem_id IN NUMBER,
112 p_task_parameter IN XDP_TYPES.ORDER_PARAMETER_LIST,
113 x_order_id OUT NOCOPY NUMBER,
114 x_return_code OUT NOCOPY NUMBER,
115 x_error_description OUT NOCOPY VARCHAR2);
116
117 -- Start of comments
118 -- API name : Cancel_Order
119 -- Type : Private
120 -- Function :
121 -- Pre-reqs : None.
122 -- Parameters :
123 --
124 -- IN : p_sdp_order_id: NUMBER Required
125 -- The order ID of the service order tobe cancelled
126 -- p_caller_name VARCHAR2 Required
127 -- The name of the CSR who cancel the order
128 -- OUT : return_code: NUMBER
129 -- This output argument is to indicate if the API
130 -- call is made sucessfully. The value of 0 means
131 -- the call is made sucessfully, while any non-zero
132 -- value means otherwise.
133 -- error_description: VARCHAR2
134 -- The decription of the error encountered
135 -- when the return_code is not 0.
136 -- Version : Current version 11.5
137 -- Notes :
138 -- This API is used as an internal API to submit a
139 -- request to SFM for cancelling an order.
140 --
141 -- End of comments
142 PROCEDURE Cancel_Order(
143 P_SDP_ORDER_ID IN NUMBER,
144 p_caller_name IN VARCHAR2 default user,
145 RETURN_CODE OUT NOCOPY NUMBER,
146 ERROR_DESCRIPTION OUT NOCOPY VARCHAR2);
147
148 -- Start of comments
149 -- API name : Cancel_Order
150 -- Type : Private
151 -- Function :
152 -- Pre-reqs : None.
153 -- Parameters :
154 --
155 -- IN : p_order_number: Varchar2 Required
156 -- The external order number of the service
157 -- order to be cancelled
158 -- p_order_version VARCHAR2 Optional
159 -- The external order version of the service
160 -- order to be cancelled
161 -- p_caller_name VARCHAR2 Required
162 -- The name of the CSR who cancel the order
163 -- OUT : return_code: NUMBER
164 -- This output argument is to indicate if the API
165 -- call is made sucessfully. The value of 0 means
166 -- the call is made sucessfully, while any non-zero
167 -- value means otherwise.
168 -- error_description: VARCHAR2
169 -- The decription of the error encountered
170 -- when the return_code is not 0.
171 -- Version : Current version 11.5
172 -- Notes :
173 -- Overload Function. This API is used as an internal API
174 -- to submit a request to SFM for cancelling an order.
175 --
176 -- End of comments
177 PROCEDURE Cancel_Order(
178 P_ORDER_NUMBER IN VARCHAR2,
179 p_order_version IN VARCHAR2,
180 p_caller_name IN VARCHAR2 default user,
181 RETURN_CODE OUT NOCOPY NUMBER,
182 ERROR_DESCRIPTION OUT NOCOPY VARCHAR2);
183
184 -- Start of comments
185 -- API name : Get_Order_Status
186 -- Type : Group
187 -- Function :
188 -- Pre-reqs : None.
189 -- Parameters :
190 --
191 -- IN : p_sdp_order_id: Number Required
192 -- The internal order ID which is assigned
193 -- by SFM upon order arrival
194 -- OUT : p_order_header XDP_TYPES.ORDER_HEADER
195 -- The order header record which contains
196 -- up to date order general information,
197 -- such as order status, state, etc..
198 -- P_Order_lines XDP_TYPES.ORDER_LINE_LIST
199 -- The list of order line record which contains
200 -- up to date general order line information for
201 -- all the lines in the order
202 -- return_code: NUMBER
203 -- This output argument is to indicate if the API
204 -- call is made sucessfully. The value of 0 means
205 -- the call is made sucessfully, while any non-zero
206 -- value means otherwise.
207 -- error_description: VARCHAR2
208 -- The decription of the error encountered
209 -- when the return_code is not 0.
210 -- Version : Current version 11.5
211 -- Notes :
212 -- This API is used as a group API
213 -- to get the up to date information for a given order
214 --
215 -- End of comments
216 PROCEDURE Get_Order_Status(
217 P_SDP_ORDER_ID IN NUMBER,
218 p_order_header OUT NOCOPY XDP_TYPES.ORDER_HEADER,
219 P_Order_lines OUT NOCOPY XDP_TYPES.ORDER_LINE_LIST,
220 RETURN_CODE OUT NOCOPY NUMBER,
221 ERROR_DESCRIPTION OUT NOCOPY VARCHAR2);
222
223 -- Start of comments
224 -- API name : Get_Order_Status
225 -- Type : Group
226 -- Function :
227 -- Pre-reqs : None.
228 -- Parameters :
229 --
230 -- IN : p_sdp_order_id: Number Required
231 -- The internal order ID which is assigned
232 -- by SFM upon order arrival
233 -- OUT : x_status VARCHAR2
234 -- The current staus of the order
235 -- x_state VARCHAR2
236 -- The current fulfillment state of the order
237 -- x_completion_date DATE
238 -- The date when the order is completed
239 -- x_cancellation_date DATE
240 -- The date when the order is canceled
241 -- x_return_code: NUMBER
242 -- This output argument is to indicate if the API
243 -- call is made sucessfully. The value of 0 means
244 -- the call is made sucessfully, while any non-zero
245 -- value means otherwise.
246 -- x_error_description: VARCHAR2
247 -- The decription of the error encountered
248 -- when the return_code is not 0.
249 -- Version : Current version 11.5
250 -- Notes :
251 -- Overload Function. A light-weight API for upstream
252 -- ordering system to retrieve only the key order status
253 -- information.
254 --
255 -- End of comments
256 PROCEDURE Get_Order_Status(
257 P_SDP_ORDER_ID IN NUMBER,
258 x_status OUT NOCOPY VARCHAR2,
259 x_state OUT NOCOPY VARCHAR2,
260 x_completion_date OUT NOCOPY DATE,
261 x_cancellation_date OUT NOCOPY DATE,
262 x_RETURN_CODE OUT NOCOPY NUMBER,
263 x_ERROR_DESCRIPTION OUT NOCOPY VARCHAR2);
264
265 -- Start of comments
266 -- API name : Get_Order_Status
267 -- Type : Group
268 -- Function :
269 -- Pre-reqs : None.
270 -- Parameters :
271 --
272 -- IN : p_order_number: VARCHAR2 Required
273 -- The order number which is assigned to
274 -- the order by the calling system
275 -- p_order_version: VARCHAR2 Optional
276 -- The order version which is assigned to
277 -- the order by the calling system, if any
278 -- OUT : x_status VARCHAR2
279 -- The current staus of the order
280 -- x_state VARCHAR2
281 -- The current fulfillment state of the order
282 -- x_completion_date DATE
283 -- The date when the order is completed
284 -- x_cancellation_date DATE
285 -- The date when the order is canceled
286 -- x_return_code: NUMBER
287 -- This output argument is to indicate if the API
288 -- call is made sucessfully. The value of 0 means
289 -- the call is made sucessfully, while any non-zero
290 -- value means otherwise.
291 -- x_error_description: VARCHAR2
292 -- The decription of the error encountered
293 -- when the return_code is not 0.
294 -- Version : Current version 11.5
295 -- Notes :
296 -- Overload Function. A light-weight API for upstream
297 -- ordering system to retrieve only the key order status
298 -- information.
299 --
300 -- End of comments
301 PROCEDURE Get_Order_Status(
302 P_ORDER_NUMBER IN VARCHAR2,
303 P_ORDER_VERSION IN VARCHAR2,
304 x_status OUT NOCOPY VARCHAR2,
305 x_state OUT NOCOPY VARCHAR2,
306 x_completion_date OUT NOCOPY DATE,
307 x_cancellation_date OUT NOCOPY DATE,
308 x_RETURN_CODE OUT NOCOPY NUMBER,
309 x_ERROR_DESCRIPTION OUT NOCOPY VARCHAR2);
310
311 -- Start of comments
312 -- API name : Get_Line_Status
313 -- Type : Group
314 -- Function :
315 -- Pre-reqs : None.
316 -- Parameters :
317 --
318 -- IN : p_sdp_order_id: Number Required
319 -- The internal order ID which is assigned
320 -- by SFM upon order arrival
321 -- p_line_number: Number Required
322 -- The line number of the order line to be
323 -- searched
324 -- OUT : x_status VARCHAR2
325 -- The current staus of the order line
326 -- x_state VARCHAR2
327 -- The current fulfillment state of the order line
328 -- x_completion_date DATE
329 -- The date when the order line is completed
330 -- x_cancellation_date DATE
331 -- The date when the order line is canceled
332 -- x_return_code: NUMBER
333 -- This output argument is to indicate if the API
334 -- call is made sucessfully. The value of 0 means
335 -- the call is made sucessfully, while any non-zero
336 -- value means otherwise.
337 -- x_error_description: VARCHAR2
338 -- The decription of the error encountered
339 -- when the return_code is not 0.
340 -- Version : Current version 11.5
341 -- Notes :
342 -- Overload Function. A light-weight API for upstream
343 -- ordering system to retrieve only the key line status
344 -- information.
345 --
346 -- End of comments
347 PROCEDURE Get_Line_Status(
348 P_SDP_ORDER_ID IN NUMBER,
349 p_line_number IN NUMBER,
350 x_status OUT NOCOPY VARCHAR2,
351 x_state OUT NOCOPY VARCHAR2,
352 x_completion_date OUT NOCOPY DATE,
353 x_cancellation_date OUT NOCOPY DATE,
354 x_RETURN_CODE OUT NOCOPY NUMBER,
355 x_ERROR_DESCRIPTION OUT NOCOPY VARCHAR2);
356
357 -- Start of comments
358 -- API name : Get_Line_Status
359 -- Type : Group
360 -- Function :
361 -- Pre-reqs : None.
362 -- Parameters :
363 --
364 -- IN : p_order_number: VARCHAR2 Required
365 -- The order number which is assigned to
366 -- the order by the calling system
367 -- p_order_version: VARCHAR2 Optional
368 -- The order version which is assigned to
369 -- the order by the calling system, if any
370 -- p_line_number: Number Required
371 -- The line number of the order line to be
372 -- searched
373 -- OUT : x_status VARCHAR2
374 -- The current staus of the order line
375 -- x_state VARCHAR2
376 -- The current fulfillment state of the order line
377 -- x_completion_date DATE
378 -- The date when the order line is completed
379 -- x_cancellation_date DATE
380 -- The date when the order line is canceled
381 -- x_return_code: NUMBER
382 -- This output argument is to indicate if the API
383 -- call is made sucessfully. The value of 0 means
384 -- the call is made sucessfully, while any non-zero
385 -- value means otherwise.
386 -- x_error_description: VARCHAR2
387 -- The decription of the error encountered
388 -- when the return_code is not 0.
389 -- Version : Current version 11.5
390 -- Notes :
391 -- Overload Function. A light-weight API for upstream
392 -- ordering system to retrieve only the key line status
393 -- information.
394 --
395 -- End of comments
396 PROCEDURE Get_Line_Status(
397 P_ORDER_NUMBER IN VARCHAR2,
398 P_ORDER_VERSION IN VARCHAR2,
399 p_line_number IN NUMBER,
400 x_status OUT NOCOPY VARCHAR2,
401 x_state OUT NOCOPY VARCHAR2,
402 x_completion_date OUT NOCOPY DATE,
403 x_cancellation_date OUT NOCOPY DATE,
404 x_RETURN_CODE OUT NOCOPY NUMBER,
405 x_ERROR_DESCRIPTION OUT NOCOPY VARCHAR2);
406
410 -- Function :
407 -- Start of comments
408 -- API name : Get_Line_Status
409 -- Type : Group
411 -- Pre-reqs : None.
412 -- Parameters :
413 --
414 -- IN : p_order_number: VARCHAR2 Required
415 -- The order number which is assigned to
416 -- the order by the calling system
417 -- p_order_version: VARCHAR2 Optional
418 -- The order version which is assigned to
419 -- the order by the calling system, if any
420 -- p_line_item_name: VARCHAR2 Required
421 -- The service name of the order line to be
422 -- searched
423 -- OUT : x_status VARCHAR2
424 -- The current staus of the order line
425 -- x_state VARCHAR2
426 -- The current fulfillment state of the order line
427 -- x_completion_date DATE
428 -- The date when the order line is completed
429 -- x_cancellation_date DATE
430 -- The date when the order line is canceled
431 -- x_return_code: NUMBER
432 -- This output argument is to indicate if the API
433 -- call is made sucessfully. The value of 0 means
434 -- the call is made sucessfully, while any non-zero
435 -- value means otherwise.
436 -- x_error_description: VARCHAR2
437 -- The decription of the error encountered
438 -- when the return_code is not 0.
439 -- Version : Current version 11.5
440 -- Notes :
441 -- Overload Function. A light-weight API for upstream
442 -- ordering system to retrieve only the key line status
443 -- information.
444 -- This API will return error if more than one order line
445 -- have the same line item name
446 --
447 -- End of comments
448 PROCEDURE Get_Line_Status(
449 P_ORDER_NUMBER IN VARCHAR2,
450 P_ORDER_VERSION IN VARCHAR2,
451 p_line_item_name IN VARCHAR2,
452 x_status OUT NOCOPY VARCHAR2,
453 x_state OUT NOCOPY VARCHAR2,
454 x_completion_date OUT NOCOPY DATE,
455 x_cancellation_date OUT NOCOPY DATE,
456 x_RETURN_CODE OUT NOCOPY NUMBER,
457 x_ERROR_DESCRIPTION OUT NOCOPY VARCHAR2);
458
459 --
460 -- The following APIs are developed as part of integration with Oracle Sales for Comms.
461 -- 12/06/2000
462 -- By Anping Wang
463 --
464
465 --//
466 --// API name : GET_ORD_FULFILLMENT_STATUS
467 --// Type : Group
468 --// Function :
469 --// Pre-reqs : None.
470 --// Parameters :
471 --//
472 --// IN : p_order_id: NUMBER Required
473 --// The order id is SFM order id returned when process_order is called.
474 --// The calling procedure should use this id
475 --// OUT : x_fulfillment_status VARCHAR2
476 --// The current fulfillment status of the order in upper case
477 --// x_fulfillment_result VARCHAR2
478 --// The current fulfillment status of the order
479 --// x_return_code: NUMBER
480 --// This output argument is to indicate if the API
481 --// call is made sucessfully. The value of 0 means
482 --// the call is made sucessfully, while any non-zero
483 --// value means otherwise.
484 --// x_error_description: VARCHAR2
485 --// The decription of the error encountered
486 --// when the return_code is not 0.
487 --// Version : Current version 11.5
488 --// Notes :
489 --// Overload Function. A light-weight API for upstream
490 --// ordering system to retrieve only the order fulfillment status
491 --//
492 --// End of comments
493 PROCEDURE Get_Ord_Fulfillment_Status(
494 p_order_id IN VARCHAR2,
495 x_fulfillment_status OUT NOCOPY VARCHAR2,
496 x_fulfillment_result OUT NOCOPY VARCHAR2,
497 x_RETURN_CODE OUT NOCOPY NUMBER,
498 x_ERROR_DESCRIPTION OUT NOCOPY VARCHAR2
499 );
500
501 --// API name : Get_Order_Param_Value
502 --// Type : Group
503 --// Function :
504 --// Pre-reqs : None.
505 --// Parameters :
506 --//
507 --// IN : p_order_id: NUMBER Required
508 --// The order id is SFM order id returned when process_order is called.
509 --// The calling procedure should use this id
510 --// p_parameter_name: VARCHAR2 Optional
511 --// The order version which is assigned to
512 --// the order by the calling system, if any
513 --// OUT : x_parameter_value VARCHAR2
514 --// The current fulfillment status of the order
515 --// x_return_code: NUMBER
516 --// This output argument is to indicate if the API
517 --// call is made sucessfully. The value of 0 means
518 --// the call is made sucessfully, while any non-zero
519 --// value means otherwise.
520 --// x_error_description: VARCHAR2
521 --// The decription of the error encountered
522 --// when the return_code is not 0.
523 --// Version : Current version 11.5
524 --//
525 --// End of comments
526 PROCEDURE Get_Order_Param_Value(
527 p_order_id IN NUMBER,
528 p_parameter_name IN VARCHAR2,
529 x_parameter_value OUT NOCOPY VARCHAR2,
530 x_RETURN_CODE OUT NOCOPY NUMBER,
531 x_ERROR_DESCRIPTION OUT NOCOPY VARCHAR2
532 );
533
534 --// API name : Get_Order_Param_List
535 --// Type : Group
536 --// Function :
537 --// Pre-reqs : None.
538 --// Parameters :
539 --//
540 --// IN : p_order_id: NUMBER Required
541 --// The order id is SFM order id returned when process_order is called.
545 --// call is made sucessfully. The value of 0 means
542 --// The calling procedure should use this id
543 --// OUT : x_return_code: NUMBER
544 --// This output argument is to indicate if the API
546 --// the call is made sucessfully, while any non-zero
547 --// value means otherwise.
548 --// x_error_description: VARCHAR2
549 --// The decription of the error encountered
550 --// when the return_code is not 0.
551 --// Version : Current version 11.5
552 --//
553 --// End of comments
554
555 FUNCTION Get_Order_Param_List(
556 p_order_id IN NUMBER,
557 x_RETURN_CODE OUT NOCOPY NUMBER,
558 x_ERROR_DESCRIPTION OUT NOCOPY VARCHAR2
559 ) RETURN XDP_ENGINE.PARAMETER_LIST;
560
561 --// API name : Get_Line_Param_Value
562 --// Type : Group
563 --// Function :
564 --// Pre-reqs : None.
565 --// Parameters :
566 --//
567 --// IN : p_order_id: NUMBER Required
568 --// The order id is SFM order id returned when process_order is called.
569 --// The calling procedure should use this id
570 --// p_order_line_number: VARCHAR2 Required
571 --// The order line number is the value passed to SFM by the calling application
572 --// which is assigned to the order line item by the calling system
573 --// p_parameter_name: VARCHAR2 Optional
574 --// The order version which is assigned to
575 --// the order by the calling system, if any
576 --// OUT : x_parameter_value VARCHAR2
577 --// The current fulfillment status of the order
578 --// x_return_code: NUMBER
579 --// This output argument is to indicate if the API
580 --// call is made sucessfully. The value of 0 means
581 --// the call is made sucessfully, while any non-zero
582 --// value means otherwise.
583 --// x_error_description: VARCHAR2
584 --// The decription of the error encountered
585 --// when the return_code is not 0.
586 --// Version : Current version 11.5
587 --//
588 --// End of comments
589 PROCEDURE Get_Line_Param_Value(
590 p_order_id IN NUMBER,
591 p_line_number IN VARCHAR2,
592 p_parameter_name IN VARCHAR2,
593 x_parameter_value OUT NOCOPY VARCHAR2,
594 x_RETURN_CODE OUT NOCOPY NUMBER,
595 x_ERROR_DESCRIPTION OUT NOCOPY VARCHAR2
596 );
597
598 --// API name : Set_Ord_Fulfillment_Status
599 --// Type : Group
600 --// Function :
601 --// Pre-reqs : None.
602 --// Parameters :
603 --//
604 --// IN : p_order_id: NUMBER Required
605 --// The order id is SFM order id returned when process_order is called.
606 --// The calling procedure should use this id
607 --// p_fulfillment_status VARCHAR2
608 --// The current fulfillment status of the order
609 --// p_fulfillment_result VARCHAR2
610 --// The current fulfillment status of the order
611 --// OUT : x_return_code: NUMBER
612 --// This output argument is to indicate if the API
613 --// call is made sucessfully. The value of 0 means
614 --// the call is made sucessfully, while any non-zero
615 --// value means otherwise.
616 --// x_error_description: VARCHAR2
617 --// The decription of the error encountered
618 --// when the return_code is not 0.
619 --// Version : Current version 11.5
620 --//
621 --// End of comments
622 PROCEDURE Set_Ord_Fulfillment_Status(
623 p_order_id IN NUMBER,
624 p_fulfillment_status IN VARCHAR2 DEFAULT NULL,
625 p_fulfillment_result IN VARCHAR2 DEFAULT NULL,
626 x_RETURN_CODE OUT NOCOPY NUMBER,
627 x_ERROR_DESCRIPTION OUT NOCOPY VARCHAR2
628 );
629
630 --
631 -- Following procedures are the new private APIs for order information
632 -- They are called by the public APIs.
633 --
634
635 -- This is the internal API for get order status. It is used
636 -- by public API to retrieve order status information.
637 -- Data is stored in x_order_status
638
639 Procedure Get_Order_Status(
640 p_order_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
641 p_order_number IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
642 p_order_version IN VARCHAR2 DEFAULT '1',
643 x_order_status OUT NOCOPY XDP_TYPES.SERVICE_ORDER_STATUS,
644 x_return_code OUT NOCOPY NUMBER,
645 x_error_description OUT NOCOPY VARCHAR2);
646
647 -- This is the internal API for get order details. It is used
648 -- by public API to retrieve order status information.
649 -- Data is stored in four data structures as defined in XDP_TYPES
650
654 p_order_version IN VARCHAR2 DEFAULT '1',
651 Procedure Get_Order_Details(
652 p_order_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
653 p_order_number IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
655 x_order_header OUT NOCOPY XDP_TYPES.SERVICE_ORDER_HEADER,
656 x_order_param_list OUT NOCOPY XDP_TYPES.SERVICE_ORDER_PARAM_LIST,
657 x_line_item_list OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
658 x_line_param_list OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST,
659 x_return_code OUT NOCOPY NUMBER,
660 x_error_description OUT NOCOPY VARCHAR2);
661
662 PROCEDURE Set_Line_Fulfillment_Status(
663 p_line_item_id IN NUMBER,
664 p_fulfillment_status IN VARCHAR2 DEFAULT NULL,
665 x_RETURN_CODE OUT NOCOPY NUMBER,
666 x_ERROR_DESCRIPTION OUT NOCOPY VARCHAR2
667 );
668
669 PROCEDURE Set_Line_Fulfillment_Status(
670 p_order_id IN NUMBER,
671 p_line_number IN NUMBER,
672 p_fulfillment_status IN VARCHAR2 DEFAULT NULL,
673 x_RETURN_CODE OUT NOCOPY NUMBER,
674 x_ERROR_DESCRIPTION OUT NOCOPY VARCHAR2
675 );
676
677 PROCEDURE Get_Line_Fulfillment_Status(
678 p_line_item_id IN NUMBER,
679 x_fulfillment_status OUT NOCOPY VARCHAR2,
680 x_RETURN_CODE OUT NOCOPY NUMBER,
681 x_ERROR_DESCRIPTION OUT NOCOPY VARCHAR2
682 );
683
684 PROCEDURE Get_Line_Fulfillment_Status(
685 p_order_id IN NUMBER,
686 p_line_number IN NUMBER,
687 x_fulfillment_status OUT NOCOPY VARCHAR2,
688 x_RETURN_CODE OUT NOCOPY NUMBER,
689 x_ERROR_DESCRIPTION OUT NOCOPY VARCHAR2
690 );
691
692 END XDP_INTERFACES;