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