1 PACKAGE XDP_NOTIFICATIONS AUTHID CURRENT_USER AS
2 /* $Header: XDPNOTFS.pls 120.1 2005/06/09 00:19:44 appldev $ */
3
4 -- Start of comments
5 -- API name : NotificationResponse
6 -- Type : Private
7 -- Function : Respond to a provisioning error with new set of data
8 -- Pre-reqs : None.
9 -- Version : Current version 11.5
10 -- Notes :
11 -- This API is used by the notification form.
12 -- End of comments
13 PROCEDURE NotificationResponse(
14 p_response IN VARCHAR2,
15 p_order_id in NUMBER,
16 P_workitem_instance_id IN NUMBER,
17 P_fa_instance_id IN NUMBER default null,
18 P_ORDER_RETRY_PARAMS IN OUT NOCOPY XDP_TYPES.FMC_RETRY_PARAM_LIST,
19 P_workitem_RETRY_PARAMS IN OUT NOCOPY XDP_TYPES.FMC_RETRY_PARAM_LIST,
20 P_FA_RETRY_PARAMS IN OUT NOCOPY XDP_TYPES.FMC_RETRY_PARAM_LIST,
21 p_workflow_Item_Type IN VARCHAR2 ,
22 p_workflow_ItemKey IN VARCHAR2 ,
23 RETURN_CODE IN OUT NOCOPY NUMBER,
24 ERROR_DESCRIPTION IN OUT NOCOPY VARCHAR2);
25
26 -- Start of comments
27 -- API name : NotificationResponse
28 -- Type : Private
29 -- Function : Get the latest service parameter changes for a work item
30 -- Pre-reqs : None.
31 -- Version : Current version 11.5
32 -- Notes :
33 --
34 -- End of comments
35 Procedure Get_Latest_FMC_Changes(
36 p_workitem_instance_id IN NUMBER,
37 p_order_id OUT NOCOPY NUMBER,
38 p_service_name OUT NOCOPY VARCHAR2,
39 p_service_version OUT NOCOPY VARCHAR2,
40 p_action_code OUT NOCOPY VARCHAR2,
41 p_workitem_name OUT NOCOPY VARCHAR2,
42 p_fmc_response OUT NOCOPY VARCHAR2,
43 p_order_param_change_list OUT NOCOPY XDP_TYPES.FMC_RETRY_PARAM_LIST,
44 p_wi_param_change_list OUT NOCOPY XDP_TYPES.FMC_RETRY_PARAM_LIST,
45 p_fa_param_change_list OUT NOCOPY XDP_TYPES.FMC_RETRY_PARAM_LIST,
46 return_code OUT NOCOPY NUMBER,
47 error_description OUT NOCOPY VARCHAR2);
48
49
50 -- Start of comments
51 -- API name : WI_Response
52 -- Type : Private
53 -- Function : wrapper for OA 5.6 framework
54 -- Pre-reqs : None.
55 -- Notes :
56 --
57 -- End of comments
58
59 Procedure WI_Response(
60 P_workitem_instance_id IN NUMBER,
61 P_PARAMETER_NAME IN VARCHAR2,
62 P_PARAMETER_VALUE IN VARCHAR2,
63 P_PARAMETER_OLD_VALUE IN VARCHAR2,
64 P_ORDER_ID IN VARCHAR2,
65 P_ITEMTYPE IN VARCHAR2,
66 P_ITEMKEY IN VARCHAR2);
67
68 -- Start of comments
69 -- API name : Get_WI_Update_URL
70 -- Type : Private
71 -- Function : Procedure to get URL for modifying WI params
72 -- Pre-reqs : None.
73 -- Notes :
74 --
75 -- End of comments
76 Procedure Get_WI_Update_URL(
77 p_workitem_instance_id IN NUMBER,
78 p_order_id IN NUMBER,
79 p_itemtype IN VARCHAR2,
80 p_itemkey IN VARCHAR2,
81 x_url OUT NOCOPY VARCHAR2);
82
83
84 END XDP_NOTIFICATIONS;