1 PACKAGE XDP_DRC_UTIL_PUB AUTHID CURRENT_USER AS
2 /* $Header: XDPDRCUS.pls 120.2 2005/07/07 02:14:10 appldev ship $ */
3
4 -- Start of comments
5 -- API name : Process_DRC_Order
6 -- Type : Public
7 -- Function : API for processing a DRC order in a synchronous mode
8 -- Pre-reqs : None.
9 -- Parameters :
10 -- IN : p_api_version IN NUMBER Required
11 -- p_init_msg_list IN VARCHAR2 Optional
12 -- Default = FND_API.G_FALSE
13 -- p_commit IN VARCHAR2 Optional
14 -- Default = FND_API.G_FALSE
15 -- p_validation_level IN NUMBER Optional
16 -- Default = FND_API.G_VALID_LEVEL_FULL
17 -- P_WORKITEM_ID IN NUMBER Required
18 -- The internal ID of the work item to be executed
19 -- P_TASK_PARAMETER IN XDP_TYPES.ORDER_PARAMETER_LIST
20 -- The list of parameters for the request
21 -- OUT : x_return_status OUT VARCHAR2(1)
22 -- The execution status of the API call.
23 -- x_msg_count OUT NUMBER
24 -- x_msg_data OUT VARCHAR2(2000)
25 -- x_sdp_Order_id OUT NUMBER
26 -- The internal order ID which is assigned by SFM
27 -- when the request is fulfilled
28 -- Version : Current version 11.5
29 -- Notes :
30 -- This API is used for the test center to execute a work item synchronously. The
31 -- process flow is as followed:
32 -- 1) Check if the work item can be executed synchronously. The condition is that
33 -- the FA mapping type of the work item must be either STATIC or DYNAMIC. This
34 -- API does not invoke any workflow. It does not use any OP process queue
35 -- either.
36 -- 2)Create a dummy service order in SFM for tracking purpose only. The internal order
37 -- ID will be returned to the caller after the call is completed.
38 -- 3)Find out all the FAs which have been mapped to this work item per configuration.
39 -- 4)For each FA, find out which FE it will be executed upon.
40 -- 5)Find the available adapter for the given FE. The usage code for the adapter must
41 -- be TEST.
42 -- 6)Execute the appropriate Fulfillment Procedure.
43 -- 7)Return when all the FAs have been executed.
44 --
45 -- End of comments
46 PROCEDURE Process_DRC_Order(
47 p_api_version IN NUMBER,
48 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
49 p_commit IN VARCHAR2 := FND_API.G_FALSE,
50 p_validation_level IN NUMBER :=
51 FND_API.G_VALID_LEVEL_FULL,
52 x_RETURN_STATUS OUT NOCOPY VARCHAR2,
53 x_msg_count OUT NOCOPY NUMBER,
54 x_msg_data OUT NOCOPY VARCHAR2,
55 P_WORKITEM_ID IN NUMBER,
56 P_TASK_PARAMETER IN XDP_TYPES.ORDER_PARAMETER_LIST,
57 x_SDP_ORDER_ID OUT NOCOPY NUMBER);
58
59 -- Start of comments
60 -- API name : Process_DRC_Order
61 -- Type : Public
62 -- Function : Wrapper on the above API with two extra out parameters
63 -- Pre-reqs : None.
64 -- Parameters :
65 -- IN : p_api_version IN NUMBER Required
66 -- p_init_msg_list IN VARCHAR2 Optional
67 -- Default = FND_API.G_FALSE
68 -- p_commit IN VARCHAR2 Optional
69 -- Default = FND_API.G_FALSE
70 -- p_validation_level IN NUMBER Optional
71 -- Default = FND_API.G_VALID_LEVEL_FULL
72 -- P_WORKITEM_ID IN NUMBER Required
73 -- The internal ID of the work item to be executed
74 -- P_TASK_PARAMETER IN XDP_TYPES.ORDER_PARAMETER_LIST
75 -- The list of parameters for the request
76 -- OUT : x_return_status OUT VARCHAR2(1)
77 -- The execution status of the API call.
78 -- x_msg_count OUT NUMBER
79 -- x_msg_data OUT VARCHAR2(2000)
80 -- x_sdp_Order_id OUT NUMBER
81 -- The internal order ID which is assigned by SFM
82 -- when the request is fulfilled
83 -- x_sdp_Fulfillment_Status OUT VARCHAR2
84 -- x_sdp_Fulfillment_Status OUT VARCHAR2
85 -- Version : Current version 11.5
86 -- Notes :
87 -- This API is used for the test center to execute a work item synchronously. The
88 -- process flow is as followed:
89 -- 1) Check if the work item can be executed synchronously. The condition is that
90 -- the FA mapping type of the work item must be either STATIC or DYNAMIC. This
91 -- API does not invoke any workflow. It does not use any OP process queue
92 -- either.
93 -- 2)Create a dummy service order in SFM for tracking purpose only. The internal order
94 -- ID will be returned to the caller after the call is completed.
95 -- 3)Find out all the FAs which have been mapped to this work item per configuration.
96 -- 4)For each FA, find out which FE it will be executed upon.
97 -- 5)Find the available adapter for the given FE. The usage code for the adapter must
98 -- be TEST.
99 -- 6)Execute the appropriate Fulfillment Procedure.
100 -- 7)Return when all the FAs have been executed.
101 -- 8)Retreive fulfillment status
102 -- End of comments
103 PROCEDURE Process_DRC_Order(
104 p_api_version IN NUMBER,
105 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
106 p_commit IN VARCHAR2 := FND_API.G_FALSE,
107 p_validation_level IN NUMBER :=
108 FND_API.G_VALID_LEVEL_FULL,
109 x_RETURN_STATUS OUT NOCOPY VARCHAR2,
110 x_msg_count OUT NOCOPY NUMBER,
111 x_msg_data OUT NOCOPY VARCHAR2,
112 P_WORKITEM_ID IN NUMBER,
113 P_TASK_PARAMETER IN XDP_TYPES.ORDER_PARAMETER_LIST,
114 x_SDP_ORDER_ID OUT NOCOPY NUMBER,
115 x_sdp_Fulfillment_Status OUT NOCOPY VARCHAR2,
116 x_sdp_Fulfillment_Result OUT NOCOPY VARCHAR2);
117
118 END XDP_DRC_UTIL_PUB;