[Home] [Help]
PACKAGE BODY: APPS.CS_SERVICEREQUEST_VUHK
Source
1 Package Body CS_SERVICEREQUEST_VUHK AS
2 /* $Header: csisrb.pls 115.6 2003/10/15 20:51:57 aneemuch noship $ */
3
4
5 PROCEDURE Create_ServiceRequest_Pre
6 ( p_api_version IN NUMBER,
7 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
8 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
9 p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
10 x_return_status OUT NOCOPY VARCHAR2,
11 x_msg_count OUT NOCOPY NUMBER,
12 x_msg_data OUT NOCOPY VARCHAR2,
13 p_resp_appl_id IN NUMBER DEFAULT NULL,
14 p_resp_id IN NUMBER DEFAULT NULL,
15 p_user_id IN NUMBER,
16 p_login_id IN NUMBER DEFAULT NULL,
17 p_org_id IN NUMBER DEFAULT NULL,
18 p_request_id IN NUMBER DEFAULT NULL,
19 p_request_number IN VARCHAR2 DEFAULT NULL,
20 p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
21 p_notes IN CS_ServiceRequest_PVT.notes_table,
22 p_contacts IN CS_ServiceRequest_PVT.contacts_table ,
23 x_request_id OUT NOCOPY NUMBER,
24 x_request_number OUT NOCOPY VARCHAR2,
25 x_interaction_id OUT NOCOPY NUMBER,
26 x_workflow_process_id OUT NOCOPY NUMBER
27 ) IS
28 BEGIN
29 return;
30 END;
31
32
33 PROCEDURE Create_ServiceRequest_Post
34 ( p_api_version IN NUMBER,
35 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
36 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
37 p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
38 x_return_status OUT NOCOPY VARCHAR2,
39 x_msg_count OUT NOCOPY NUMBER,
40 x_msg_data OUT NOCOPY VARCHAR2,
41 p_resp_appl_id IN NUMBER DEFAULT NULL,
42 p_resp_id IN NUMBER DEFAULT NULL,
43 p_user_id IN NUMBER,
44 p_login_id IN NUMBER DEFAULT NULL,
45 p_org_id IN NUMBER DEFAULT NULL,
46 p_request_id IN NUMBER DEFAULT NULL,
47 p_request_number IN VARCHAR2 DEFAULT NULL,
48 p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
49 p_notes IN CS_ServiceRequest_PVT.notes_table,
50 p_contacts IN CS_ServiceRequest_PVT.contacts_table ,
51 x_request_id OUT NOCOPY NUMBER,
52 x_request_number OUT NOCOPY VARCHAR2,
53 x_interaction_id OUT NOCOPY NUMBER,
54 x_workflow_process_id OUT NOCOPY NUMBER
55 ) IS
56 BEGIN
57 return;
58 END;
59
60
61
62 PROCEDURE Update_ServiceRequest_Post
63 ( p_api_version IN NUMBER,
64 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
65 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
66 p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
67 x_return_status OUT NOCOPY VARCHAR2,
68 x_msg_count OUT NOCOPY NUMBER,
69 x_msg_data OUT NOCOPY VARCHAR2,
70 p_request_id IN NUMBER,
71 p_object_version_number IN NUMBER,
72 p_resp_appl_id IN NUMBER DEFAULT NULL,
73 p_resp_id IN NUMBER DEFAULT NULL,
74 p_last_updated_by IN NUMBER,
75 p_last_update_login IN NUMBER DEFAULT NULL,
76 p_last_update_date IN DATE,
77 p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
78 p_update_desc_flex IN VARCHAR2 DEFAULT fnd_api.g_false,
79 p_notes IN CS_ServiceRequest_PVT.notes_table,
80 p_contacts IN CS_ServiceRequest_PVT.contacts_table,
81 p_audit_comments IN VARCHAR2 DEFAULT NULL,
82 p_called_by_workflow IN VARCHAR2 DEFAULT fnd_api.g_false,
83 p_workflow_process_id IN NUMBER DEFAULT NULL,
84 x_workflow_process_id OUT NOCOPY NUMBER,
85 x_interaction_id OUT NOCOPY NUMBER
86 ) IS
87 BEGIN
88 return;
89 END;
90
91
92 PROCEDURE Update_ServiceRequest_Pre
93 ( p_api_version IN NUMBER,
94 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
95 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
96 p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
97 x_return_status OUT NOCOPY VARCHAR2,
98 x_msg_count OUT NOCOPY NUMBER,
99 x_msg_data OUT NOCOPY VARCHAR2,
100 p_request_id IN NUMBER,
101 p_object_version_number IN NUMBER,
102 p_resp_appl_id IN NUMBER DEFAULT NULL,
103 p_resp_id IN NUMBER DEFAULT NULL,
104 p_last_updated_by IN NUMBER,
105 p_last_update_login IN NUMBER DEFAULT NULL,
106 p_last_update_date IN DATE,
107 p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
108 p_update_desc_flex IN VARCHAR2 DEFAULT fnd_api.g_false,
109 p_notes IN CS_ServiceRequest_PVT.notes_table,
110 p_contacts IN CS_ServiceRequest_PVT.contacts_table,
111 p_audit_comments IN VARCHAR2 DEFAULT NULL,
112 p_called_by_workflow IN VARCHAR2 DEFAULT fnd_api.g_false,
113 p_workflow_process_id IN NUMBER DEFAULT NULL,
114 x_workflow_process_id OUT NOCOPY NUMBER,
115 x_interaction_id OUT NOCOPY NUMBER
116 )
117 IS
118 l_return_status VARCHAR2(1);
119 l_msg_data VARCHAR2(64);
120 l_msg_count NUMBER;
121
122 l_workflow_process_id NUMBER;
123 l_interaction_id NUMBER;
124
125 l_api_name_full CONSTANT VARCHAR2(61) := 'CS_SERVICEREQUEST_VUHK'||'.'||'Update_ServiceRequest_Pre';
126 BEGIN
127 return;
128
129 -- Start of change by aneemuch, 15-Oct-2003
130 -- Removed vertical hook validation that use to prevent updation of CIC SR.
131 /*
132 BEGIN
133 CUG_PREVENT_SR_UPDATE_PKG.Update_ServiceRequest_Prevent
134 ( p_api_version=>p_api_version,
135 p_init_msg_list=>p_init_msg_list,
136 p_commit=>p_commit,
137 p_validation_level=>p_validation_level,
138 x_return_status =>l_return_status,
139 x_msg_count=>l_msg_count,
140 x_msg_data=>l_msg_data,
141 p_request_id=>p_request_id,
142 p_object_version_number=>p_object_version_number,
143 p_resp_appl_id=>p_resp_appl_id,
144 p_resp_id=>p_resp_id,
145 p_last_updated_by=>p_last_updated_by,
146 p_last_update_login =>p_last_update_login,
147 p_last_update_date=>p_last_update_date,
148 p_service_request_rec=>p_service_request_rec,
149 p_update_desc_flex=>p_update_desc_flex,
150 p_notes=>p_notes,
151 p_contacts =>p_contacts,
152 p_audit_comments=>p_audit_comments,
153 p_called_by_workflow=>p_called_by_workflow,
154 p_workflow_process_id=>p_workflow_process_id,
155 x_workflow_process_id=>l_workflow_process_id,
156 x_interaction_id=>l_interaction_id
157 );
158
159
160 x_return_status := l_return_status;
161 x_msg_count := l_msg_count;
162 x_msg_data := l_msg_data;
163
164
165 EXCEPTION
166 WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
167 x_return_status := FND_API.G_RET_STS_ERROR;
168 x_msg_count := l_msg_count;
169 x_msg_data := l_msg_data;
170
171 FND_MSG_PUB.Count_And_Get
172 ( p_count => x_msg_count,
173 p_data => x_msg_data
174 );
175 WHEN FND_API.G_EXC_ERROR THEN
176 x_return_status := FND_API.G_RET_STS_ERROR;
177 x_msg_count := l_msg_count;
178 x_msg_data := l_msg_data;
179
180 FND_MSG_PUB.Count_And_Get
181 ( p_count => x_msg_count,
182 p_data => x_msg_data
183 );
184
185 */
186 -- End of changes by aneemuch, 15-Oct-2003
187
188 END Update_ServiceRequest_pre;
189
190
191 END CS_SERVICEREQUEST_VUHK;