1 PACKAGE cs_incidentlinks_pvt AUTHID CURRENT_USER AS
2 /* $Header: csvsrls.pls 120.1 2005/08/02 07:30:55 varnaray noship $ */
3
4 -- Renamed existing rec. type G_LINKS_REC to CS_INCIDENT_LINKS_REC_TYPE in 1159.
5 -- The existing rec. type was not used anywhere and since it was defined in the
6 -- private package, it is not publised for customers to use as well.
7 -- The new rec. type is the same structure as the rec. type defined in the
8 -- Public Spec.
9 -- This will be used in the overloaded procedures for create/update links.
10 -- Note : The record type does **not** have the object version number.
11 -- Also it does not have the two 1159 obsoleted parameters.
12 -- ie. from_incident_id and to_incident_id
13 -- Also, the attributed don't have to be explictly defaulted to NULL as
14 -- that happens implictly. Defaulting the link segments to FND_APIs for
15 -- backward compatability.
16 TYPE CS_INCIDENT_LINK_REC_TYPE IS RECORD (
17 LINK_ID NUMBER, -- new for 1159
18 SUBJECT_ID NUMBER, -- new for 1159
19 SUBJECT_TYPE VARCHAR2(30), -- new for 1159
20 OBJECT_ID NUMBER, -- new for 1159
21 OBJECT_NUMBER VARCHAR2(90),-- new for 1159
22 OBJECT_TYPE VARCHAR2(30), -- new for 1159
23 LINK_TYPE_ID NUMBER, -- new for 1159
24 LINK_TYPE VARCHAR2(240), -- no change
25 REQUEST_ID NUMBER, -- new for 1159
26 PROGRAM_APPLICATION_ID NUMBER, -- new for 1159
27 PROGRAM_ID NUMBER, -- new for 1159
28 PROGRAM_UPDATE_DATE DATE, -- new for 1159
29 FROM_INCIDENT_ID NUMBER := NULL, -- new in 11.5.9.1 for bugs 2972584 and 2972611
30 FROM_INCIDENT_NUMBER VARCHAR2(64) := NULL, -- new in 11.5.9.1 for bugs 2972584 and 2972611
31 TO_INCIDENT_ID NUMBER := NULL, -- new in 11.5.9.1 for bugs 2972584 and 2972611
32 TO_INCIDENT_NUMBER VARCHAR2(64) := NULL, -- new in 11.5.9.1 for bugs 2972584 and 2972611
33 LINK_SEGMENT1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34 LINK_SEGMENT2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35 LINK_SEGMENT3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
36 LINK_SEGMENT4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
37 LINK_SEGMENT5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
38 LINK_SEGMENT6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
39 LINK_SEGMENT7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
40 LINK_SEGMENT8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
41 LINK_SEGMENT9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
42 LINK_SEGMENT10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
43 LINK_SEGMENT11 VARCHAR2(150) := FND_API.G_MISS_CHAR, -- new for 1159
44 LINK_SEGMENT12 VARCHAR2(150) := FND_API.G_MISS_CHAR, -- new for 1159
45 LINK_SEGMENT13 VARCHAR2(150) := FND_API.G_MISS_CHAR, -- new for 1159
46 LINK_SEGMENT14 VARCHAR2(150) := FND_API.G_MISS_CHAR, -- new for 1159
47 LINK_SEGMENT15 VARCHAR2(150) := FND_API.G_MISS_CHAR, -- new for 1159
48 LINK_CONTEXT VARCHAR2(150) := FND_API.G_MISS_CHAR,
49 LINK_ID_EXT NUMBER := NULL ); -- new in 11.5.9.1 for bugs 2972584 and 2972611
50
51 -- Removed type G_LINKS_EXT_REC as both internal and external links are treated the
52 -- same from 1159.
53 -- TYPE G_LINKS_EXT_REC IS RECORD (
54
55 -- Added record type CS_INCIDENT_LINK_EXT_REC_TYPE based on the CS_INCIDENT_LINKS_EXT table structure.
56 -- This is used for restoring the functionality of the _ext public procedures in 11.5.9.1 for backward compatibility.
57 -- For bugs # 2972584 and 2972611
58
59 TYPE CS_INCIDENT_LINK_EXT_REC_TYPE IS RECORD (
60 LINK_ID NUMBER,
61 FROM_INCIDENT_ID NUMBER,
62 TO_OBJECT_ID NUMBER,
63 TO_OBJECT_TYPE VARCHAR2(30),
64 TO_OBJECT_NUMBER VARCHAR2(64),
65 LAST_UPDATE_DATE DATE,
66 LAST_UPDATED_BY NUMBER,
67 CREATION_DATE DATE,
68 CREATED_BY NUMBER,
69 LAST_UPDATE_LOGIN NUMBER,
70 ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71 ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72 ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73 ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74 ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75 ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76 ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77 ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78 ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79 ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80 CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
81 OBJECT_VERSION_NUMBER NUMBER);
82
83 -- Overloaded procedure (new for 1159) that accepts a record structure. This
84 -- procedure calls the create procedure with the detailed list of parameters.
85 -- Invoking programs can use either one of the procedures.
86
87 PROCEDURE CREATE_INCIDENTLINK (
88 P_API_VERSION IN NUMBER,
89 P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
90 P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
91 P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
92 P_RESP_APPL_ID IN NUMBER := NULL, -- not used
93 P_RESP_ID IN NUMBER := NULL, -- not used
94 P_USER_ID IN NUMBER := NULL, -- not used
95 P_LOGIN_ID IN NUMBER := FND_API.G_MISS_NUM,
96 P_ORG_ID IN NUMBER := NULL, -- not used
97 P_LINK_REC IN CS_INCIDENT_LINK_REC_TYPE := NULL,
98 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
99 X_MSG_COUNT OUT NOCOPY NUMBER,
100 X_MSG_DATA OUT NOCOPY VARCHAR2,
101 X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER,
102 X_RECIPROCAL_LINK_ID OUT NOCOPY NUMBER,
103 X_LINK_ID OUT NOCOPY NUMBER );
104
105 PROCEDURE CREATE_INCIDENTLINK (
106 P_API_VERSION IN NUMBER,
107 P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
108 P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
109 P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
110 P_RESP_APPL_ID IN NUMBER := NULL, -- not used
111 P_RESP_ID IN NUMBER := NULL, -- not used
112 P_USER_ID IN NUMBER := NULL, -- not used
113 P_LOGIN_ID IN NUMBER := FND_API.G_MISS_NUM,
114 P_ORG_ID IN NUMBER := NULL, -- not used
115 P_LINK_ID IN NUMBER := NULL, -- new for 1159
116 P_SUBJECT_ID IN NUMBER := NULL, -- new for 1159
117 P_SUBJECT_TYPE IN VARCHAR2 := NULL, -- new for 1159
118 P_OBJECT_ID IN NUMBER := NULL, -- new for 1159
119 P_OBJECT_NUMBER IN VARCHAR2 := NULL, -- new for 1159
120 P_OBJECT_TYPE IN VARCHAR2 := NULL, -- new for 1159
121 P_LINK_TYPE_ID IN NUMBER := NULL, -- new for 1159
122 P_LINK_TYPE IN VARCHAR2 := NULL, -- existed prior to 1159. Made this
123 -- param non mandatory in 1159
124 P_REQUEST_ID IN NUMBER := NULL, -- new for 1159
125 P_PROGRAM_APPLICATION_ID IN NUMBER := NULL, -- new for 1159
126 P_PROGRAM_ID IN NUMBER := NULL, -- new for 1159
127 P_PROGRAM_UPDATE_DATE IN DATE := NULL, -- new for 1159
128 P_FROM_INCIDENT_ID IN NUMBER, -- obsoleted for 1159
129 P_TO_INCIDENT_ID IN NUMBER, -- obsoleted for 1159
130 P_LINK_SEGMENT1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
131 P_LINK_SEGMENT2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
132 P_LINK_SEGMENT3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
133 P_LINK_SEGMENT4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
134 P_LINK_SEGMENT5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
135 P_LINK_SEGMENT6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
136 P_LINK_SEGMENT7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
137 P_LINK_SEGMENT8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
138 P_LINK_SEGMENT9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
139 P_LINK_SEGMENT10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
140 P_LINK_SEGMENT11 IN VARCHAR2 := FND_API.G_MISS_CHAR,-- new for 1159
141 P_LINK_SEGMENT12 IN VARCHAR2 := FND_API.G_MISS_CHAR,-- new for 1159
142 P_LINK_SEGMENT13 IN VARCHAR2 := FND_API.G_MISS_CHAR,-- new for 1159
143 P_LINK_SEGMENT14 IN VARCHAR2 := FND_API.G_MISS_CHAR,-- new for 1159
144 P_LINK_SEGMENT15 IN VARCHAR2 := FND_API.G_MISS_CHAR,-- new for 1159
145 P_LINK_CONTEXT IN VARCHAR2 := FND_API.G_MISS_CHAR,
146 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
147 X_MSG_COUNT OUT NOCOPY NUMBER,
148 X_MSG_DATA OUT NOCOPY VARCHAR2,
149 X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER, -- new for 1159
150 X_RECIPROCAL_LINK_ID OUT NOCOPY NUMBER, -- new for 1159
151 X_LINK_ID OUT NOCOPY NUMBER );
152
153 -- Overloaded procedure (new for 1159) that accepts a record structure. This
154 -- procedure calls the update procedure with the detailed list of parameters.
155 -- Invoking programs can use either one of the procedures.
156 PROCEDURE UPDATE_INCIDENTLINK (
157 P_API_VERSION IN NUMBER,
158 P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
159 P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
160 P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
161 P_RESP_APPL_ID IN NUMBER := NULL, -- not used
162 P_RESP_ID IN NUMBER := NULL, -- not used
163 P_USER_ID IN NUMBER := NULL,
164 P_LOGIN_ID IN NUMBER := FND_API.G_MISS_NUM,
165 P_ORG_ID IN NUMBER := NULL, -- not used
166 P_LINK_ID IN NUMBER, -- no change
167 P_OBJECT_VERSION_NUMBER IN NUMBER, -- new for 1159
168 P_LINK_REC IN CS_INCIDENT_LINK_REC_TYPE := NULL,
169 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
170 X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER, -- new for 1159
171 X_MSG_COUNT OUT NOCOPY NUMBER,
172 X_MSG_DATA OUT NOCOPY VARCHAR2 );
173
174 PROCEDURE UPDATE_INCIDENTLINK (
175 P_API_VERSION IN NUMBER,
176 P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
177 P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
178 P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
179 P_RESP_APPL_ID IN NUMBER := NULL, -- not used
180 P_RESP_ID IN NUMBER := NULL, -- not used
181 P_USER_ID IN NUMBER := NULL,
182 P_LOGIN_ID IN NUMBER := FND_API.G_MISS_NUM,
183 P_ORG_ID IN NUMBER := NULL, -- not used
184 P_LINK_ID IN NUMBER, -- no change
185 P_OBJECT_VERSION_NUMBER IN NUMBER, -- new for 1159
186 P_OBJECT_ID IN NUMBER := NULL, -- new for 1159
187 P_OBJECT_NUMBER IN VARCHAR2 := NULL, -- new for 1159
188 P_OBJECT_TYPE IN VARCHAR2 := NULL, -- new for 1159
189 P_LINK_TYPE_ID IN NUMBER := NULL, -- new for 1159
190 P_LINK_TYPE IN VARCHAR2 := NULL, -- no change
191 P_REQUEST_ID IN NUMBER := NULL, -- new for 1159
192 P_PROGRAM_APPLICATION_ID IN NUMBER := NULL, -- new for 1159
193 P_PROGRAM_ID IN NUMBER := NULL, -- new for 1159
194 P_PROGRAM_UPDATE_DATE IN DATE := NULL, -- new for 1159
195 P_FROM_INCIDENT_ID IN NUMBER := NULL, -- obsoleted for 1159
196 P_TO_INCIDENT_ID IN NUMBER := NULL, -- obsoleted for 1159
197 P_LINK_SEGMENT1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
198 P_LINK_SEGMENT2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
199 P_LINK_SEGMENT3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
200 P_LINK_SEGMENT4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
201 P_LINK_SEGMENT5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
202 P_LINK_SEGMENT6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
203 P_LINK_SEGMENT7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
204 P_LINK_SEGMENT8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
205 P_LINK_SEGMENT9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
206 P_LINK_SEGMENT10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
207 P_LINK_SEGMENT11 IN VARCHAR2 := FND_API.G_MISS_CHAR, -- new for 1159
208 P_LINK_SEGMENT12 IN VARCHAR2 := FND_API.G_MISS_CHAR, -- new for 1159
209 P_LINK_SEGMENT13 IN VARCHAR2 := FND_API.G_MISS_CHAR, -- new for 1159
210 P_LINK_SEGMENT14 IN VARCHAR2 := FND_API.G_MISS_CHAR, -- new for 1159
211 P_LINK_SEGMENT15 IN VARCHAR2 := FND_API.G_MISS_CHAR, -- new for 1159
212 P_LINK_CONTEXT IN VARCHAR2 := FND_API.G_MISS_CHAR,
213 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
214 X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER, -- new for 1159
215 X_MSG_COUNT OUT NOCOPY NUMBER,
216 X_MSG_DATA OUT NOCOPY VARCHAR2 );
217
218 -- New, overloaded procedure with the 11.5.9 signature added for bugs 2972584 and 2972611
219 PROCEDURE DELETE_INCIDENTLINK (
220 P_API_VERSION IN NUMBER,
221 P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
222 P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
223 P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL, -- not used
224 P_RESP_APPL_ID IN NUMBER := NULL, -- not used
225 P_RESP_ID IN NUMBER := NULL, -- not used
226 P_USER_ID IN NUMBER := NULL,
227 P_LOGIN_ID IN NUMBER := FND_API.G_MISS_NUM,
228 P_ORG_ID IN NUMBER := NULL, -- not used
229 P_LINK_ID IN NUMBER, -- no change
230 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
231 X_MSG_COUNT OUT NOCOPY NUMBER,
232 X_MSG_DATA OUT NOCOPY VARCHAR2 );
233
234 PROCEDURE DELETE_INCIDENTLINK (
235 P_API_VERSION IN NUMBER,
236 P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
237 P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
238 P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL, -- not used
239 P_RESP_APPL_ID IN NUMBER := NULL, -- not used
240 P_RESP_ID IN NUMBER := NULL, -- not used
241 P_USER_ID IN NUMBER := NULL,
242 P_LOGIN_ID IN NUMBER := FND_API.G_MISS_NUM,
243 P_ORG_ID IN NUMBER := NULL, -- not used
244 P_LINK_ID IN NUMBER, -- no change
245 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
246 X_MSG_COUNT OUT NOCOPY NUMBER,
247 X_MSG_DATA OUT NOCOPY VARCHAR2,
248 P_LINK_ID_EXT IN NUMBER ); -- new in 11.5.9.1 for bugs 2972584 and 2972611
249
250 PROCEDURE GET_DOC_NUMBER (
251 S_SQL_STATEMENT IN VARCHAR2,
252 S_DOC_NUMBER OUT NOCOPY VARCHAR2);
253
254 PROCEDURE GET_DOC_DETAILS (
255 S_SQL_STATEMENT IN VARCHAR2,
256 S_DOC_ID OUT NOCOPY NUMBER,
257 S_DOC_NUMBER OUT NOCOPY VARCHAR2,
258 S_DOC_SEVERITY OUT NOCOPY VARCHAR2,
259 S_DOC_STATUS OUT NOCOPY VARCHAR2,
260 S_DOC_SUMMARY OUT NOCOPY VARCHAR2,
261 S_DOC_PROD OUT NOCOPY VARCHAR2,
262 S_DOC_PROD_DESC OUT NOCOPY VARCHAR2);
263
264 /*******************
265 The _EXT procedures are obsoleted for 11.5.9. All external links in 11.5.9 will
266 be stored in table cs_incident_links. Procedures are not dropped, rather their
267 implementations will be stubbed out for backward compatability
268 ********************/
269
270 PROCEDURE CREATE_INCIDENTLINK_EXT (
271 P_API_VERSION IN NUMBER,
272 P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
273 P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
274 P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
275 P_RESP_APPL_ID IN NUMBER := NULL,
276 P_RESP_ID IN NUMBER := NULL,
277 P_USER_ID IN NUMBER := NULL,
278 P_LOGIN_ID IN NUMBER := FND_API.G_MISS_NUM,
279 P_ORG_ID IN NUMBER := NULL,
280 P_FROM_INCIDENT_ID IN NUMBER,
281 P_TO_OBJECT_ID IN NUMBER,
282 P_TO_OBJECT_NUMBER IN VARCHAR2,
283 P_TO_OBJECT_TYPE IN VARCHAR2,
284 P_LINK_SEGMENT1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
285 P_LINK_SEGMENT2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
286 P_LINK_SEGMENT3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
287 P_LINK_SEGMENT4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
288 P_LINK_SEGMENT5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
289 P_LINK_SEGMENT6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
290 P_LINK_SEGMENT7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
291 P_LINK_SEGMENT8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
292 P_LINK_SEGMENT9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
293 P_LINK_SEGMENT10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
294 P_LINK_CONTEXT IN VARCHAR2 := FND_API.G_MISS_CHAR,
295 X_LINK_ID OUT NOCOPY NUMBER,
296 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
297 X_MSG_COUNT OUT NOCOPY NUMBER,
298 X_MSG_DATA OUT NOCOPY VARCHAR2 );
299
300 PROCEDURE UPDATE_INCIDENTLINK_EXT (
301 P_API_VERSION IN NUMBER,
302 P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
303 P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
304 P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
305 P_RESP_APPL_ID IN NUMBER := NULL,
306 P_RESP_ID IN NUMBER := NULL,
307 P_USER_ID IN NUMBER := NULL,
308 P_LOGIN_ID IN NUMBER := FND_API.G_MISS_NUM,
309 P_ORG_ID IN NUMBER := NULL,
310 P_LINK_ID IN NUMBER,
311 P_FROM_INCIDENT_ID IN NUMBER := NULL,
312 P_TO_OBJECT_ID IN NUMBER := NULL,
313 P_TO_OBJECT_TYPE IN VARCHAR2 := NULL,
314 P_LINK_SEGMENT1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
315 P_LINK_SEGMENT2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
316 P_LINK_SEGMENT3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
317 P_LINK_SEGMENT4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
318 P_LINK_SEGMENT5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
319 P_LINK_SEGMENT6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
320 P_LINK_SEGMENT7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
321 P_LINK_SEGMENT8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
322 P_LINK_SEGMENT9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
323 P_LINK_SEGMENT10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
324 P_LINK_CONTEXT IN VARCHAR2 := FND_API.G_MISS_CHAR,
325 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
326 X_MSG_COUNT OUT NOCOPY NUMBER,
327 X_MSG_DATA OUT NOCOPY VARCHAR2 );
328
329 PROCEDURE DELETE_INCIDENTLINK_EXT (
330 P_API_VERSION IN NUMBER,
331 P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
332 P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
333 P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
334 P_RESP_APPL_ID IN NUMBER := NULL,
335 P_RESP_ID IN NUMBER := NULL,
336 P_USER_ID IN NUMBER := NULL,
337 P_LOGIN_ID IN NUMBER := FND_API.G_MISS_NUM,
338 P_ORG_ID IN NUMBER := NULL,
339 P_LINK_ID IN NUMBER,
340 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
341 X_MSG_COUNT OUT NOCOPY NUMBER,
342 X_MSG_DATA OUT NOCOPY VARCHAR2 );
343
344 PROCEDURE Delete_IncidentLink
345 (
346 p_api_version_number IN NUMBER := 1.0
347 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
348 , p_commit IN VARCHAR2 := FND_API.G_FALSE
349 , p_object_type IN VARCHAR2
350 , p_processing_set_id IN NUMBER
351 , x_return_status OUT NOCOPY VARCHAR2
352 , x_msg_count OUT NOCOPY NUMBER
353 , x_msg_data OUT NOCOPY VARCHAR2
354 );
355
356 END CS_INCIDENTLINKS_PVT;
[Home] [Help]