1 PACKAGE cs_servicerequest_cuhk AUTHID CURRENT_USER AS
2 /* $Header: cscsrs.pls 120.0.12020000.2 2012/12/24 08:56:18 lkullamb ship $ */
3
4 /*****************************************************************************************
5 This is the Customer User Hook API.
6 The Customers can add customization procedures here for Pre and Post Processing.
7 ******************************************************************************************/
8
9
10
11
12 /* Customer Procedure for pre processing in case of
13 create service request */
14
15 /*
16 PROCEDURE Create_ServiceRequest_Pre
17 (p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
18 x_return_status OUT NOCOPY VARCHAR2
19 ); */
20
21 PROCEDURE Create_ServiceRequest_Pre
22 ( p_api_version IN NUMBER,
23 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
24 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
25 p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
26 x_return_status OUT NOCOPY VARCHAR2,
27 x_msg_count OUT NOCOPY NUMBER,
28 x_msg_data OUT NOCOPY VARCHAR2,
29 p_resp_appl_id IN NUMBER DEFAULT NULL,
30 p_resp_id IN NUMBER DEFAULT NULL,
31 p_user_id IN NUMBER,
32 p_login_id IN NUMBER DEFAULT NULL,
33 p_org_id IN NUMBER DEFAULT NULL,
34 p_request_id IN NUMBER DEFAULT NULL,
35 p_request_number IN VARCHAR2 DEFAULT NULL,
36 p_invocation_mode IN VARCHAR2 := 'NORMAL',
37 p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
38 p_notes IN CS_ServiceRequest_PVT.notes_table,
39 p_contacts IN CS_ServiceRequest_PVT.contacts_table ,
40 x_request_id OUT NOCOPY NUMBER,
41 x_request_number OUT NOCOPY VARCHAR2,
42 x_interaction_id OUT NOCOPY NUMBER,
43 x_workflow_process_id OUT NOCOPY NUMBER,
44 --15995804. Add price_list_header_id
45 x_price_list_header_id OUT NOCOPY NUMBER
46 ) ;
47
48
49 /* Customer Procedure for post processing in case of
50 create service request */
51
52 /*
53 PROCEDURE Create_ServiceRequest_Post
54 (p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
55 x_return_status OUT NOCOPY VARCHAR2
56 ); */
57
58
59 PROCEDURE Create_ServiceRequest_Post
60 ( p_api_version IN NUMBER,
61 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
62 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
63 p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
64 x_return_status OUT NOCOPY VARCHAR2,
65 x_msg_count OUT NOCOPY NUMBER,
66 x_msg_data OUT NOCOPY VARCHAR2,
67 p_resp_appl_id IN NUMBER DEFAULT NULL,
68 p_resp_id IN NUMBER DEFAULT NULL,
69 p_user_id IN NUMBER,
70 p_login_id IN NUMBER DEFAULT NULL,
71 p_org_id IN NUMBER DEFAULT NULL,
72 p_request_id IN NUMBER DEFAULT NULL,
73 p_request_number IN VARCHAR2 DEFAULT NULL,
74 p_invocation_mode IN VARCHAR2 := 'NORMAL',
75 p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
76 p_notes IN CS_ServiceRequest_PVT.notes_table,
77 p_contacts IN CS_ServiceRequest_PVT.contacts_table ,
78 x_request_id OUT NOCOPY NUMBER,
79 x_request_number OUT NOCOPY VARCHAR2,
80 x_interaction_id OUT NOCOPY NUMBER,
81 x_workflow_process_id OUT NOCOPY NUMBER
82 );
83
84
85
86
87 /* Customer Procedure for pre processing in case of
88 update service request */
89
90 /*
91 PROCEDURE Update_ServiceRequest_Pre
92 ( p_request_id IN NUMBER,
93 p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
94 x_return_status OUT NOCOPY VARCHAR2
98 PROCEDURE Update_ServiceRequest_Pre
95 ); */
96
97
99 ( p_api_version IN NUMBER,
100 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
101 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
102 p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
103 x_return_status OUT NOCOPY VARCHAR2,
104 x_msg_count OUT NOCOPY NUMBER,
105 x_msg_data OUT NOCOPY VARCHAR2,
106 p_request_id IN NUMBER,
107 p_object_version_number IN NUMBER,
108 p_resp_appl_id IN NUMBER DEFAULT NULL,
109 p_resp_id IN NUMBER DEFAULT NULL,
110 p_last_updated_by IN NUMBER,
111 p_last_update_login IN NUMBER DEFAULT NULL,
112 p_last_update_date IN DATE,
113 p_invocation_mode IN VARCHAR2 := 'NORMAL',
114 p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
115 p_update_desc_flex IN VARCHAR2 DEFAULT fnd_api.g_false,
116 p_notes IN CS_ServiceRequest_PVT.notes_table,
117 p_contacts IN CS_ServiceRequest_PVT.contacts_table,
118 p_audit_comments IN VARCHAR2 DEFAULT NULL,
119 p_called_by_workflow IN VARCHAR2 DEFAULT fnd_api.g_false,
120 p_workflow_process_id IN NUMBER DEFAULT NULL,
121 x_workflow_process_id OUT NOCOPY NUMBER,
122 x_interaction_id OUT NOCOPY NUMBER
123 ) ;
124
125
126 /* Customer Procedure for post processing in case of
127 update service request */
128
129
130 /*
131 PROCEDURE Update_ServiceRequest_Post
132 ( p_request_id IN NUMBER,
133 p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
134 x_return_status OUT NOCOPY VARCHAR2); */
135
136
137
138 PROCEDURE Update_ServiceRequest_Post
139 ( p_api_version IN NUMBER,
140 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
141 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
142 p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
143 x_return_status OUT NOCOPY VARCHAR2,
144 x_msg_count OUT NOCOPY NUMBER,
145 x_msg_data OUT NOCOPY VARCHAR2,
146 p_request_id IN NUMBER,
147 p_object_version_number IN NUMBER,
148 p_resp_appl_id IN NUMBER DEFAULT NULL,
149 p_resp_id IN NUMBER DEFAULT NULL,
150 p_last_updated_by IN NUMBER,
151 p_last_update_login IN NUMBER DEFAULT NULL,
152 p_last_update_date IN DATE,
153 p_invocation_mode IN VARCHAR2 := 'NORMAL',
154 p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
155 p_update_desc_flex IN VARCHAR2 DEFAULT fnd_api.g_false,
156 p_notes IN CS_ServiceRequest_PVT.notes_table,
157 p_contacts IN CS_ServiceRequest_PVT.contacts_table,
158 p_audit_comments IN VARCHAR2 DEFAULT NULL,
159 p_called_by_workflow IN VARCHAR2 DEFAULT fnd_api.g_false,
160 p_workflow_process_id IN NUMBER DEFAULT NULL,
161 x_workflow_process_id OUT NOCOPY NUMBER,
162 x_interaction_id OUT NOCOPY NUMBER
163 ) ;
164
165
166
167
168 FUNCTION Ok_To_Generate_Msg
169 (p_request_id IN NUMBER,
170 p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type)
171 RETURN BOOLEAN ;
172
173
174 FUNCTION Ok_To_Launch_Workflow
175 ( p_request_id IN NUMBER,
176 p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type)
177 RETURN BOOLEAN ;
178
179 END cs_servicerequest_cuhk;