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
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
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
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:
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)
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,
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,
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,
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.
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
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
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,
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,
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,
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
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
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: --
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:
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)
510: * @rep:displayname Process Service Fulfillment Order
511: */
512: PROCEDURE Process_Order(
513: p_api_version IN NUMBER,
514: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
515: p_commit IN VARCHAR2 := FND_API.G_FALSE,
516: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
517: x_return_status OUT NOCOPY VARCHAR2,
518: x_msg_count OUT NOCOPY NUMBER,
511: */
512: PROCEDURE Process_Order(
513: p_api_version IN NUMBER,
514: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
515: p_commit IN VARCHAR2 := FND_API.G_FALSE,
516: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
517: x_return_status OUT NOCOPY VARCHAR2,
518: x_msg_count OUT NOCOPY NUMBER,
519: x_msg_data OUT NOCOPY VARCHAR2,
512: PROCEDURE Process_Order(
513: p_api_version IN NUMBER,
514: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
515: p_commit IN VARCHAR2 := FND_API.G_FALSE,
516: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
517: x_return_status OUT NOCOPY VARCHAR2,
518: x_msg_count OUT NOCOPY NUMBER,
519: x_msg_data OUT NOCOPY VARCHAR2,
520: x_error_code OUT NOCOPY VARCHAR2,
534: --
535: -- IN : p_api_version: NUMBER Required
536: --
537: -- p_init_msg_list: VARCHAR2 Optional
538: -- Default = FND_API.G_FALSE
539: --
540: -- p_commit: VARCHAR2 Optional
541: -- Default = FND_API.G_FALSE
542: -- This API is an autonomous routine which
537: -- p_init_msg_list: VARCHAR2 Optional
538: -- Default = FND_API.G_FALSE
539: --
540: -- p_commit: VARCHAR2 Optional
541: -- Default = FND_API.G_FALSE
542: -- This API is an autonomous routine which
543: -- handles the database transaction independently.
544: -- The value of p_commit parameter will be ignored.
545: --
543: -- handles the database transaction independently.
544: -- The value of p_commit parameter will be ignored.
545: --
546: -- p_validation_level NUMBER Optional
547: -- Default = FND_API.G_VALID_LEVEL_FULL
548: --
549: -- p_order_id: NUMBER requried if p_order_number is null
550: -- The internal order ID which was assigned by SFM
551: -- when an order was successfully submitted to SFM
592: * @rep:lifecycle active
593: * @rep:displayname Cancel Service Fulfillment Order
594: */
595: PROCEDURE Cancel_Order(
596: p_api_version IN NUMBER := FND_API.G_MISS_NUM,
597: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
598: p_commit IN VARCHAR2 := FND_API.G_FALSE,
599: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
600: x_return_status OUT NOCOPY VARCHAR2,
593: * @rep:displayname Cancel Service Fulfillment Order
594: */
595: PROCEDURE Cancel_Order(
596: p_api_version IN NUMBER := FND_API.G_MISS_NUM,
597: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
598: p_commit IN VARCHAR2 := FND_API.G_FALSE,
599: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
600: x_return_status OUT NOCOPY VARCHAR2,
601: x_msg_count OUT NOCOPY NUMBER,
594: */
595: PROCEDURE Cancel_Order(
596: p_api_version IN NUMBER := FND_API.G_MISS_NUM,
597: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
598: p_commit IN VARCHAR2 := FND_API.G_FALSE,
599: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
600: x_return_status OUT NOCOPY VARCHAR2,
601: x_msg_count OUT NOCOPY NUMBER,
602: x_msg_data OUT NOCOPY VARCHAR2,
595: PROCEDURE Cancel_Order(
596: p_api_version IN NUMBER := FND_API.G_MISS_NUM,
597: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
598: p_commit IN VARCHAR2 := FND_API.G_FALSE,
599: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
600: x_return_status OUT NOCOPY VARCHAR2,
601: x_msg_count OUT NOCOPY NUMBER,
602: x_msg_data OUT NOCOPY VARCHAR2,
603: p_order_number IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
599: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
600: x_return_status OUT NOCOPY VARCHAR2,
601: x_msg_count OUT NOCOPY NUMBER,
602: x_msg_data OUT NOCOPY VARCHAR2,
603: p_order_number IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
604: p_order_version IN VARCHAR2 DEFAULT '1',
605: p_order_id IN NUMBER := FND_API.G_MISS_NUM,
606: x_error_code OUT NOCOPY VARCHAR2,
607: p_caller_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
601: x_msg_count OUT NOCOPY NUMBER,
602: x_msg_data OUT NOCOPY VARCHAR2,
603: p_order_number IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
604: p_order_version IN VARCHAR2 DEFAULT '1',
605: p_order_id IN NUMBER := FND_API.G_MISS_NUM,
606: x_error_code OUT NOCOPY VARCHAR2,
607: p_caller_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
608: );
609:
603: p_order_number IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
604: p_order_version IN VARCHAR2 DEFAULT '1',
605: p_order_id IN NUMBER := FND_API.G_MISS_NUM,
606: x_error_code OUT NOCOPY VARCHAR2,
607: p_caller_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
608: );
609:
610: -- Start of comments
611: -- API name : Get_Order_Details
617: --
618: -- IN : p_api_version: NUMBER Required
619: --
620: -- p_init_msg_list: VARCHAR2 Optional
621: -- Default = FND_API.G_FALSE
622: --
623: -- p_commit: VARCHAR2 Optional
624: -- Default = FND_API.G_FALSE
625: -- This API is an autonomous routine which
620: -- p_init_msg_list: VARCHAR2 Optional
621: -- Default = FND_API.G_FALSE
622: --
623: -- p_commit: VARCHAR2 Optional
624: -- Default = FND_API.G_FALSE
625: -- This API is an autonomous routine which
626: -- handles the database transaction independently.
627: -- The value of p_commit parameter will be ignored.
628: --
626: -- handles the database transaction independently.
627: -- The value of p_commit parameter will be ignored.
628: --
629: -- p_validation_level NUMBER Optional
630: -- Default = FND_API.G_VALID_LEVEL_FULL.
631: --
632: -- p_order_id: NUMBER requried if p_order_number is null
633: -- The internal order ID which was assigned by SFM
634: -- when an order was successfully submitted to SFM.
745: * @rep:displayname Get Service Fulfillment Order Details
746: */
747: PROCEDURE Get_Order_Details(
748: p_api_version IN NUMBER ,
749: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
750: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
751: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
752: x_return_status OUT NOCOPY VARCHAR2,
753: x_msg_count OUT NOCOPY NUMBER,
746: */
747: PROCEDURE Get_Order_Details(
748: p_api_version IN NUMBER ,
749: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
750: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
751: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
752: x_return_status OUT NOCOPY VARCHAR2,
753: x_msg_count OUT NOCOPY NUMBER,
754: x_msg_data OUT NOCOPY VARCHAR2,
747: PROCEDURE Get_Order_Details(
748: p_api_version IN NUMBER ,
749: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
750: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
751: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
752: x_return_status OUT NOCOPY VARCHAR2,
753: x_msg_count OUT NOCOPY NUMBER,
754: x_msg_data OUT NOCOPY VARCHAR2,
755: x_error_code OUT NOCOPY VARCHAR2,
752: x_return_status OUT NOCOPY VARCHAR2,
753: x_msg_count OUT NOCOPY NUMBER,
754: x_msg_data OUT NOCOPY VARCHAR2,
755: x_error_code OUT NOCOPY VARCHAR2,
756: p_order_number IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
757: p_order_version IN VARCHAR2 DEFAULT '1',
758: p_order_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
759: x_order_header OUT NOCOPY XDP_TYPES.SERVICE_ORDER_HEADER,
760: x_order_param_list OUT NOCOPY XDP_TYPES.SERVICE_ORDER_PARAM_LIST,
754: x_msg_data OUT NOCOPY VARCHAR2,
755: x_error_code OUT NOCOPY VARCHAR2,
756: p_order_number IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
757: p_order_version IN VARCHAR2 DEFAULT '1',
758: p_order_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
759: x_order_header OUT NOCOPY XDP_TYPES.SERVICE_ORDER_HEADER,
760: x_order_param_list OUT NOCOPY XDP_TYPES.SERVICE_ORDER_PARAM_LIST,
761: x_line_item_list OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
762: x_line_param_list OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST
772: --
773: -- IN : p_api_version: NUMBER Required
774: --
775: -- p_init_msg_list: VARCHAR2 Optional
776: -- Default = FND_API.G_FALSE
777: --
778: -- p_commit: VARCHAR2 Optional
779: -- Default = FND_API.G_FALSE
780: -- This API is an autonomous routine which
775: -- p_init_msg_list: VARCHAR2 Optional
776: -- Default = FND_API.G_FALSE
777: --
778: -- p_commit: VARCHAR2 Optional
779: -- Default = FND_API.G_FALSE
780: -- This API is an autonomous routine which
781: -- handles the database transaction independently.
782: -- The value of p_commit parameter will be ignored.
783: --
781: -- handles the database transaction independently.
782: -- The value of p_commit parameter will be ignored.
783: --
784: -- p_validation_level NUMBER Optional
785: -- Default = FND_API.G_VALID_LEVEL_FULL.
786: --
787: -- p_order_id: NUMBER requried if p_order_number is null
788: -- The internal order ID which was assigned by SFM
789: -- when an order was successfully submitted to SFM.
860: * @rep:displayname Get Service Fulfillment Order Status
861: */
862: PROCEDURE Get_Order_Status(
863: p_api_version IN NUMBER,
864: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
865: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
866: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
867: x_return_status OUT NOCOPY VARCHAR2,
868: x_msg_count OUT NOCOPY NUMBER,
861: */
862: PROCEDURE Get_Order_Status(
863: p_api_version IN NUMBER,
864: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
865: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
866: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
867: x_return_status OUT NOCOPY VARCHAR2,
868: x_msg_count OUT NOCOPY NUMBER,
869: x_msg_data OUT NOCOPY VARCHAR2,
862: PROCEDURE Get_Order_Status(
863: p_api_version IN NUMBER,
864: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
865: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
866: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
867: x_return_status OUT NOCOPY VARCHAR2,
868: x_msg_count OUT NOCOPY NUMBER,
869: x_msg_data OUT NOCOPY VARCHAR2,
870: x_error_code OUT NOCOPY VARCHAR2,
867: x_return_status OUT NOCOPY VARCHAR2,
868: x_msg_count OUT NOCOPY NUMBER,
869: x_msg_data OUT NOCOPY VARCHAR2,
870: x_error_code OUT NOCOPY VARCHAR2,
871: p_order_number IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
872: p_order_version IN VARCHAR2 DEFAULT '1',
873: p_order_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
874: x_order_status OUT NOCOPY XDP_TYPES.SERVICE_ORDER_STATUS
875: );
869: x_msg_data OUT NOCOPY VARCHAR2,
870: x_error_code OUT NOCOPY VARCHAR2,
871: p_order_number IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
872: p_order_version IN VARCHAR2 DEFAULT '1',
873: p_order_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
874: x_order_status OUT NOCOPY XDP_TYPES.SERVICE_ORDER_STATUS
875: );
876:
877: END XDP_INTERFACES_PUB;