1 PACKAGE CS_INCIDENTLINKS_PUB AS
2 /* $Header: cspsrls.pls 120.0 2005/11/08 10:11:43 smisra noship $ */
3 /*#
4 * Service Request Links provides functions to enable user to create, update and delete
5 * service request links to a service request object.
6 *
7 * @rep:scope public
8 * @rep:product CS
9 * @rep:displayname Service Request Link
10 * @rep:lifecycle active
11 * @rep:compatibility S
12 * @rep:category BUSINESS_ENTITY CS_SERVICE_REQUEST
13 */
14
15 /**** Above text has been added to enable the integration repository to extract the data
16 from the source code file and populate the integration repository schema so that the
17 interfaces defined in this package appears in the integration repository.
18 ****/
19
20 -- Added record structures to be used as IN parameters
21 -- New for 1159
22 -- This will be used in the overloaded procedures for create/update links.
23 -- Note : The record type does **not** have the object version number.
24 -- Also it does not have the four 1159 obsoleted parameters.
25 -- ie. from_incident_id, from_incident_number, to_incident_id and
26 -- to_incident_number
27 TYPE CS_INCIDENT_LINK_REC_TYPE IS RECORD (
28 LINK_ID NUMBER := NULL, -- new for 1159
29 SUBJECT_ID NUMBER := NULL, -- new for 1159
30 SUBJECT_TYPE VARCHAR2(30) := NULL, -- new for 1159
31 OBJECT_ID NUMBER := NULL, -- new for 1159
32 OBJECT_NUMBER VARCHAR2(90) := NULL, -- new for 1159
33 OBJECT_TYPE VARCHAR2(30) := NULL, -- new for 1159
34 LINK_TYPE_ID NUMBER := NULL, -- new for 1159
35 LINK_TYPE VARCHAR2(240), -- no change
36 REQUEST_ID NUMBER := NULL, -- new for 1159
37 PROGRAM_APPLICATION_ID NUMBER := NULL, -- new for 1159
38 PROGRAM_ID NUMBER := NULL, -- new for 1159
39 PROGRAM_UPDATE_DATE DATE := NULL, -- new for 1159
40 LINK_SEGMENT1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
41 LINK_SEGMENT2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
42 LINK_SEGMENT3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
43 LINK_SEGMENT4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
44 LINK_SEGMENT5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
45 LINK_SEGMENT6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
46 LINK_SEGMENT7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
47 LINK_SEGMENT8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
48 LINK_SEGMENT9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
49 LINK_SEGMENT10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
50 LINK_SEGMENT11 VARCHAR2(150) := FND_API.G_MISS_CHAR, -- new for 1159
51 LINK_SEGMENT12 VARCHAR2(150) := FND_API.G_MISS_CHAR, -- new for 1159
52 LINK_SEGMENT13 VARCHAR2(150) := FND_API.G_MISS_CHAR, -- new for 1159
53 LINK_SEGMENT14 VARCHAR2(150) := FND_API.G_MISS_CHAR, -- new for 1159
54 LINK_SEGMENT15 VARCHAR2(150) := FND_API.G_MISS_CHAR, -- new for 1159
55 LINK_CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR );
56
57 -- Overloaded procedure (new for 1159) that accepts a record structure. This
58 -- procedure calls the create procedure with the detailed list of parameters.
59 -- Invoking programs can use either one of the procedures.
60 /*#
61 * Create Service Request Link enables user to create service request link for
62 * an instance of a service request object.
63 * Please refer to the Metalink for parameter details.
64 *
65 * @rep:scope public
66 * @rep:lifecycle active
67 * @rep:compatibility S
68 * @rep:displayname Create Service Request Link
69 * @rep:primaryinstance
70 * @rep:businessevent oracle.apps.cs.sr.ServiceRequest.relationshipcreated
71 * @rep:metalink 131739.1 Oracle Teleservice Implementation Guide Release 11.5.9
72 */
73
74
75 /**** Above text has been added to enable the integration repository to extract the data
76 from the source code file and populate the integration repository schema so that
77 Create_IncidentLink API appears in the integration repository.
78 ****/
79
80 PROCEDURE CREATE_INCIDENTLINK (
81 P_API_VERSION IN NUMBER,
82 P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
83 P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
84 P_RESP_APPL_ID IN NUMBER := NULL, -- not used
85 P_RESP_ID IN NUMBER := NULL, -- not used
86 P_USER_ID IN NUMBER := NULL,
87 P_LOGIN_ID IN NUMBER := FND_API.G_MISS_NUM,
88 P_ORG_ID IN NUMBER := NULL, -- not used
89 P_LINK_REC IN CS_INCIDENT_LINK_REC_TYPE := NULL,
90 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
91 X_MSG_COUNT OUT NOCOPY NUMBER,
92 X_MSG_DATA OUT NOCOPY VARCHAR2,
93 X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER, -- new for 1159
94 X_RECIPROCAL_LINK_ID OUT NOCOPY NUMBER, -- new for 1159
95 X_LINK_ID OUT NOCOPY NUMBER );
96
97 -- This is an overloaded procedure introduced for backward compatibility in 11.5.9.1
98 -- The signature is the same as the pre-11.5.9 version of this procedure.
99
100 PROCEDURE CREATE_INCIDENTLINK (
101 P_API_VERSION IN NUMBER,
102 P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
103 P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
104 P_RESP_APPL_ID IN NUMBER := NULL, -- not used
105 P_RESP_ID IN NUMBER := NULL, -- not used
106 P_USER_ID IN NUMBER := NULL,
107 P_LOGIN_ID IN NUMBER := FND_API.G_MISS_NUM,
108 P_ORG_ID IN NUMBER := NULL, -- not used
109 P_LINK_TYPE IN VARCHAR2 := NULL, -- existed prior to 1159. Made this
110 -- param non mandatory in 1159
111 P_FROM_INCIDENT_ID IN NUMBER := NULL,
112 P_FROM_INCIDENT_NUMBER IN VARCHAR2 := NULL,
113 P_TO_INCIDENT_ID IN NUMBER := NULL,
114 P_TO_INCIDENT_NUMBER IN VARCHAR2 := NULL,
115 P_LINK_SEGMENT1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
116 P_LINK_SEGMENT2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
117 P_LINK_SEGMENT3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
118 P_LINK_SEGMENT4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
119 P_LINK_SEGMENT5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
120 P_LINK_SEGMENT6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
121 P_LINK_SEGMENT7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
122 P_LINK_SEGMENT8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
123 P_LINK_SEGMENT9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
124 P_LINK_SEGMENT10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
125 P_LINK_CONTEXT IN VARCHAR2 := FND_API.G_MISS_CHAR, -- new for 1159
126 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
127 X_MSG_COUNT OUT NOCOPY NUMBER,
128 X_MSG_DATA OUT NOCOPY VARCHAR2,
129 X_LINK_ID OUT NOCOPY NUMBER );
130
131
132 PROCEDURE CREATE_INCIDENTLINK (
133 P_API_VERSION IN NUMBER,
134 P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
135 P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
136 P_RESP_APPL_ID IN NUMBER := NULL, -- not used
137 P_RESP_ID IN NUMBER := NULL, -- not used
138 P_USER_ID IN NUMBER := NULL,
139 P_LOGIN_ID IN NUMBER := FND_API.G_MISS_NUM,
140 P_ORG_ID IN NUMBER := NULL, -- not used
141 P_LINK_ID IN NUMBER := NULL, -- new for 1159
142 P_SUBJECT_ID IN NUMBER := NULL, -- new for 1159
143 P_SUBJECT_TYPE IN VARCHAR2 := NULL, -- new for 1159
144 P_OBJECT_ID IN NUMBER := NULL, -- new for 1159
145 P_OBJECT_NUMBER IN VARCHAR2 := NULL, -- new for 1159
146 P_OBJECT_TYPE IN VARCHAR2 := NULL, -- new for 1159
147 P_LINK_TYPE_ID IN NUMBER := NULL, -- new for 1159
148 P_LINK_TYPE IN VARCHAR2 := NULL, -- existed prior to 1159. Made this
149 -- param non mandatory in 1159
150 P_REQUEST_ID IN NUMBER := NULL, -- new for 1159
151 P_PROGRAM_APPLICATION_ID IN NUMBER := NULL, -- new for 1159
152 P_PROGRAM_ID IN NUMBER := NULL, -- new for 1159
153 P_PROGRAM_UPDATE_DATE IN DATE := NULL, -- new for 1159
154 P_FROM_INCIDENT_ID IN NUMBER := NULL, -- obsoleted for 1159
155 P_FROM_INCIDENT_NUMBER IN VARCHAR2 := NULL, -- obsoleted for 1159
156 P_TO_INCIDENT_ID IN NUMBER := NULL, -- obsoleted for 1159
157 P_TO_INCIDENT_NUMBER IN VARCHAR2 := NULL, -- obsoleted for 1159
158 P_LINK_SEGMENT1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
159 P_LINK_SEGMENT2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
160 P_LINK_SEGMENT3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
161 P_LINK_SEGMENT4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
162 P_LINK_SEGMENT5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
163 P_LINK_SEGMENT6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
164 P_LINK_SEGMENT7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
165 P_LINK_SEGMENT8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
166 P_LINK_SEGMENT9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
167 P_LINK_SEGMENT10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
168 P_LINK_SEGMENT11 IN VARCHAR2 := FND_API.G_MISS_CHAR, -- new for 1159
169 P_LINK_SEGMENT12 IN VARCHAR2 := FND_API.G_MISS_CHAR, -- new for 1159
170 P_LINK_SEGMENT13 IN VARCHAR2 := FND_API.G_MISS_CHAR, -- new for 1159
171 P_LINK_SEGMENT14 IN VARCHAR2 := FND_API.G_MISS_CHAR, -- new for 1159
172 P_LINK_SEGMENT15 IN VARCHAR2 := FND_API.G_MISS_CHAR, -- new for 1159
173 P_LINK_CONTEXT IN VARCHAR2 := FND_API.G_MISS_CHAR, -- new for 1159
174 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
175 X_MSG_COUNT OUT NOCOPY NUMBER,
176 X_MSG_DATA OUT NOCOPY VARCHAR2,
177 X_RECIPROCAL_LINK_ID OUT NOCOPY NUMBER, -- new for 1159
178 X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER, -- new for 1159
179 X_LINK_ID OUT NOCOPY NUMBER );
180
181 -- Overloaded procedure (new for 1159) that accepts a record structure. This
182 -- procedure calls the update procedure with the detailed list of parameters.
183 -- Invoking programs can use either one of the procedures.
184 /*#
185 * Update Service Request Link enables user to update service request link.
186 * This version is primarily used for release 11.5.9 and other forward releases.
187 * Please refer to the Metalink for parameter details.
188 *
189 * @rep:scope public
190 * @rep:lifecycle active
191 * @rep:compatibility S
192 * @rep:displayname Update Service Request Link
193 * @rep:primaryinstance
194 * @rep:businessevent oracle.apps.cs.sr.ServiceRequest.relationshipcreated
195 * @rep:metalink 131739.1 Oracle Teleservice Implementation Guide Release 11.5.9
196 *
197 */
198
199 /**** Above text has been added to enable the integration repository to extract the data
200 from the source code file and populate the integration repository schema so that
201 Update_IncidentLink API appears in the integration repository.
202 ****/
203
204 PROCEDURE UPDATE_INCIDENTLINK (
205 P_API_VERSION IN NUMBER,
206 P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
207 P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
208 P_RESP_APPL_ID IN NUMBER := NULL, -- not used
209 P_RESP_ID IN NUMBER := NULL, -- not used
210 P_USER_ID IN NUMBER := NULL,
211 P_LOGIN_ID IN NUMBER := FND_API.G_MISS_NUM,
212 P_ORG_ID IN NUMBER := NULL, -- not used
213 P_LINK_ID IN NUMBER, -- no change
214 P_OBJECT_VERSION_NUMBER IN NUMBER, -- new for 1159
215 P_LINK_REC IN CS_INCIDENT_LINK_REC_TYPE := NULL,
216 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
217 X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER, -- new for 1159
218 X_MSG_COUNT OUT NOCOPY NUMBER,
219 X_MSG_DATA OUT NOCOPY VARCHAR2 );
220
221 -- This is an overloaded procedure introduced for backward compatibility in 11.5.9.1
222 -- The signature is the same as the pre-11.5.9 version of this procedure.
223
224 PROCEDURE UPDATE_INCIDENTLINK (
225 P_API_VERSION IN NUMBER,
226 P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
227 P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
228 P_RESP_APPL_ID IN NUMBER := NULL,
229 P_RESP_ID IN NUMBER := NULL,
230 P_USER_ID IN NUMBER := NULL,
231 P_LOGIN_ID IN NUMBER := FND_API.G_MISS_NUM,
232 P_ORG_ID IN NUMBER := NULL,
233 P_LINK_ID IN NUMBER,
234 P_FROM_INCIDENT_ID IN NUMBER := NULL,
235 P_FROM_INCIDENT_NUMBER IN VARCHAR2 := NULL,
236 P_TO_INCIDENT_ID IN NUMBER := NULL,
237 P_TO_INCIDENT_NUMBER IN VARCHAR2 := NULL,
238 P_LINK_TYPE IN VARCHAR2 := NULL,
239 P_LINK_SEGMENT1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
240 P_LINK_SEGMENT2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
241 P_LINK_SEGMENT3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
242 P_LINK_SEGMENT4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
243 P_LINK_SEGMENT5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
244 P_LINK_SEGMENT6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
245 P_LINK_SEGMENT7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
246 P_LINK_SEGMENT8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
247 P_LINK_SEGMENT9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
248 P_LINK_SEGMENT10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
249 P_LINK_CONTEXT IN VARCHAR2 := FND_API.G_MISS_CHAR,
250 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
251 X_MSG_COUNT OUT NOCOPY NUMBER,
252 X_MSG_DATA OUT NOCOPY VARCHAR2);
253
254
255 PROCEDURE UPDATE_INCIDENTLINK (
256 P_API_VERSION IN NUMBER,
257 P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
258 P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
259 P_RESP_APPL_ID IN NUMBER := NULL, -- not used
260 P_RESP_ID IN NUMBER := NULL, -- not used
261 P_USER_ID IN NUMBER := NULL,
262 P_LOGIN_ID IN NUMBER := FND_API.G_MISS_NUM,
263 P_ORG_ID IN NUMBER := NULL, -- not used
264 P_LINK_ID IN NUMBER, -- no change
265 P_OBJECT_VERSION_NUMBER IN NUMBER, -- new for 1159
266 P_SUBJECT_ID IN NUMBER := NULL, -- new for 1159
267 P_SUBJECT_TYPE IN VARCHAR2 := NULL, -- new for 1159
268 P_LINK_TYPE_ID IN NUMBER := NULL, -- new for 1159
269 P_LINK_TYPE IN VARCHAR2 := NULL, -- no change
270 P_OBJECT_ID IN NUMBER := NULL, -- new for 1159
271 P_OBJECT_NUMBER IN VARCHAR2 := NULL, -- new for 1159
272 P_OBJECT_TYPE IN VARCHAR2 := NULL, -- new for 1159
273 P_REQUEST_ID IN NUMBER := NULL, -- new for 1159
274 P_PROGRAM_APPLICATION_ID IN NUMBER := NULL, -- new for 1159
275 P_PROGRAM_ID IN NUMBER := NULL, -- new for 1159
276 P_PROGRAM_UPDATE_DATE IN DATE := NULL, -- new for 1159
277 P_FROM_INCIDENT_ID IN NUMBER := NULL, -- not used
278 P_FROM_INCIDENT_NUMBER IN VARCHAR2 := NULL, -- not used
279 P_TO_INCIDENT_ID IN NUMBER := NULL, -- not used
280 P_TO_INCIDENT_NUMBER IN VARCHAR2 := NULL, -- not used
281 P_LINK_SEGMENT1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
282 P_LINK_SEGMENT2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
283 P_LINK_SEGMENT3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
284 P_LINK_SEGMENT4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
285 P_LINK_SEGMENT5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
286 P_LINK_SEGMENT6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
287 P_LINK_SEGMENT7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
288 P_LINK_SEGMENT8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
289 P_LINK_SEGMENT9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
290 P_LINK_SEGMENT10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
291 P_LINK_SEGMENT11 IN VARCHAR2 := FND_API.G_MISS_CHAR, -- new for 1159
292 P_LINK_SEGMENT12 IN VARCHAR2 := FND_API.G_MISS_CHAR, -- new for 1159
293 P_LINK_SEGMENT13 IN VARCHAR2 := FND_API.G_MISS_CHAR, -- new for 1159
294 P_LINK_SEGMENT14 IN VARCHAR2 := FND_API.G_MISS_CHAR, -- new for 1159
295 P_LINK_SEGMENT15 IN VARCHAR2 := FND_API.G_MISS_CHAR, -- new for 1159
296 P_LINK_CONTEXT IN VARCHAR2 := FND_API.G_MISS_CHAR,
297 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
298 X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER, -- new for 1159
302 /*#
299 X_MSG_COUNT OUT NOCOPY NUMBER,
300 X_MSG_DATA OUT NOCOPY VARCHAR2 );
301
303 * Delete Service Request Link enables user to delete service
304 * request link.
305 * Please refer to the Metalink for parameter details.
306 *
307 * @rep:scope public
308 * @rep:lifecycle active
309 * @rep:compatibility S
310 * @rep:displayname Delete Service Request Link
311 * @rep:primaryinstance
312 * @rep:businessevent oracle.apps.cs.sr.ServiceRequest.relationshipdeleted
313 * @rep:metalink 131739.1 Oracle Teleservice Implementation Guide Release 11.5.9
314 */
315
316
317 /**** Above text has been added to enable the integration repository to extract the data
318 from the source code file and populate the integration repository schema so that
319 Delete_IncidentLink API appears in the integration repository.
320 ****/
321
322
323 PROCEDURE DELETE_INCIDENTLINK (
324 P_API_VERSION IN NUMBER,
325 P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
326 P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
327 P_RESP_APPL_ID IN NUMBER := NULL, -- not used
328 P_RESP_ID IN NUMBER := NULL, -- not used
329 P_USER_ID IN NUMBER := NULL, -- not used
330 P_LOGIN_ID IN NUMBER := FND_API.G_MISS_NUM,
331 P_ORG_ID IN NUMBER := NULL, -- not used
332 P_LINK_ID IN NUMBER, -- no change
333 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
334 X_MSG_COUNT OUT NOCOPY NUMBER,
335 X_MSG_DATA OUT NOCOPY VARCHAR2 );
336
337 /* The _EXT procedures have been restored in 11.5.9.1 All external links in 11.5.9.1 will
338 be stored both in table cs_incident_links and in table cs_incident_links_ext.
339 ********************/
340
341 PROCEDURE CREATE_INCIDENTLINK_EXT (
342 P_API_VERSION IN NUMBER,
343 P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
344 P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
345 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
346 X_MSG_COUNT OUT NOCOPY NUMBER,
347 X_MSG_DATA OUT NOCOPY VARCHAR2,
348 P_RESP_APPL_ID IN NUMBER := NULL,
349 P_RESP_ID IN NUMBER := NULL,
350 P_USER_ID IN NUMBER := NULL,
351 P_LOGIN_ID IN NUMBER := FND_API.G_MISS_NUM,
352 P_ORG_ID IN NUMBER := NULL,
353 P_FROM_INCIDENT_ID IN NUMBER := NULL,
354 P_FROM_INCIDENT_NUMBER IN NUMBER := NULL,
355 P_TO_OBJECT_ID IN NUMBER,
356 P_TO_OBJECT_TYPE IN VARCHAR2,
357 P_LINK_SEGMENT1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
358 P_LINK_SEGMENT2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
359 P_LINK_SEGMENT3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
360 P_LINK_SEGMENT4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
361 P_LINK_SEGMENT5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
362 P_LINK_SEGMENT6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
363 P_LINK_SEGMENT7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
364 P_LINK_SEGMENT8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
365 P_LINK_SEGMENT9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
366 P_LINK_SEGMENT10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
367 P_LINK_CONTEXT IN VARCHAR2 := FND_API.G_MISS_CHAR,
368 X_LINK_ID OUT NOCOPY NUMBER );
369
370 PROCEDURE UPDATE_INCIDENTLINK_EXT (
371 P_API_VERSION IN NUMBER,
372 P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
373 P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
374 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
375 X_MSG_COUNT OUT NOCOPY NUMBER,
376 X_MSG_DATA OUT NOCOPY VARCHAR2,
377 P_RESP_APPL_ID IN NUMBER := NULL,
378 P_RESP_ID IN NUMBER := NULL,
379 P_USER_ID IN NUMBER := NULL,
383 P_FROM_INCIDENT_ID IN NUMBER := NULL,
380 P_LOGIN_ID IN NUMBER := FND_API.G_MISS_NUM,
381 P_ORG_ID IN NUMBER := NULL,
382 P_LINK_ID IN NUMBER,
384 P_FROM_INCIDENT_NUMBER IN VARCHAR2 := NULL,
385 P_TO_OBJECT_ID IN NUMBER := FND_API.G_MISS_NUM,
386 P_TO_OBJECT_TYPE IN VARCHAR2 := FND_API.G_MISS_CHAR,
387 P_LINK_SEGMENT1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
388 P_LINK_SEGMENT2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
389 P_LINK_SEGMENT3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
390 P_LINK_SEGMENT4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
391 P_LINK_SEGMENT5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
392 P_LINK_SEGMENT6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
393 P_LINK_SEGMENT7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
394 P_LINK_SEGMENT8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
395 P_LINK_SEGMENT9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
396 P_LINK_SEGMENT10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
397 P_LINK_CONTEXT IN VARCHAR2 := FND_API.G_MISS_CHAR );
398
399 PROCEDURE DELETE_INCIDENTLINK_EXT (
400 P_API_VERSION IN NUMBER,
401 P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
402 P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
403 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
404 X_MSG_COUNT OUT NOCOPY NUMBER,
405 X_MSG_DATA OUT NOCOPY VARCHAR2,
406 P_RESP_APPL_ID IN NUMBER := NULL,
407 P_RESP_ID IN NUMBER := NULL,
408 P_USER_ID IN NUMBER := NULL,
409 P_LOGIN_ID IN NUMBER := FND_API.G_MISS_NUM,
410 P_ORG_ID IN NUMBER := NULL,
411 P_LINK_ID IN NUMBER );
412
413 END CS_INCIDENTLINKS_PUB;