[Home] [Help]
PACKAGE BODY: APPS.CS_SERVICEREQUEST_PUB_W
Source
1 package body cs_servicerequest_pub_w as
2 /* $Header: cssrrswb.pls 120.10.12020000.3 2013/02/04 15:52:13 lkullamb ship $ */
3 rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4 rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5 rosetta_g_mistake_date_high date := to_date('01/01/+4710', 'MM/DD/SYYYY');
6 rosetta_g_mistake_date_low date := to_date('01/01/-4710', 'MM/DD/SYYYY');
7
8 -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
9 function rosetta_g_miss_date_in_map(d date) return date as
10 begin
11 if d > rosetta_g_mistake_date_high then return fnd_api.g_miss_date; end if;
12 if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
13 return d;
14 end;
15
16 procedure rosetta_table_copy_in_p1(t out nocopy cs_servicerequest_pub.notes_table, a0 JTF_VARCHAR2_TABLE_2000
17 , a1 JTF_VARCHAR2_TABLE_32767
18 , a2 JTF_VARCHAR2_TABLE_300
19 , a3 JTF_VARCHAR2_TABLE_100
20 , a4 JTF_NUMBER_TABLE
21 , a5 JTF_VARCHAR2_TABLE_100
22 , a6 JTF_NUMBER_TABLE
23 , a7 JTF_VARCHAR2_TABLE_100
24 , a8 JTF_NUMBER_TABLE
25 ) as
26 ddindx binary_integer; indx binary_integer;
27 begin
28 if a0 is not null and a0.count > 0 then
29 if a0.count > 0 then
30 indx := a0.first;
31 ddindx := 1;
32 while true loop
33 t(ddindx).note := a0(indx);
34 t(ddindx).note_detail := a1(indx);
35 t(ddindx).note_type := a2(indx);
36 t(ddindx).note_context_type_01 := a3(indx);
37 t(ddindx).note_context_type_id_01 := a4(indx);
38 t(ddindx).note_context_type_02 := a5(indx);
39 t(ddindx).note_context_type_id_02 := a6(indx);
40 t(ddindx).note_context_type_03 := a7(indx);
41 t(ddindx).note_context_type_id_03 := a8(indx);
42 ddindx := ddindx+1;
43 if a0.last =indx
44 then exit;
45 end if;
46 indx := a0.next(indx);
47 end loop;
48 end if;
49 end if;
50 end rosetta_table_copy_in_p1;
51 procedure rosetta_table_copy_out_p1(t cs_servicerequest_pub.notes_table, a0 out nocopy JTF_VARCHAR2_TABLE_2000
52 , a1 out nocopy JTF_VARCHAR2_TABLE_32767
53 , a2 out nocopy JTF_VARCHAR2_TABLE_300
54 , a3 out nocopy JTF_VARCHAR2_TABLE_100
55 , a4 out nocopy JTF_NUMBER_TABLE
56 , a5 out nocopy JTF_VARCHAR2_TABLE_100
57 , a6 out nocopy JTF_NUMBER_TABLE
58 , a7 out nocopy JTF_VARCHAR2_TABLE_100
59 , a8 out nocopy JTF_NUMBER_TABLE
60 ) as
61 ddindx binary_integer; indx binary_integer;
62 begin
63 if t is null or t.count = 0 then
64 a0 := JTF_VARCHAR2_TABLE_2000();
65 a1 := JTF_VARCHAR2_TABLE_32767();
66 a2 := JTF_VARCHAR2_TABLE_300();
67 a3 := JTF_VARCHAR2_TABLE_100();
68 a4 := JTF_NUMBER_TABLE();
69 a5 := JTF_VARCHAR2_TABLE_100();
70 a6 := JTF_NUMBER_TABLE();
71 a7 := JTF_VARCHAR2_TABLE_100();
72 a8 := JTF_NUMBER_TABLE();
73 else
74 a0 := JTF_VARCHAR2_TABLE_2000();
75 a1 := JTF_VARCHAR2_TABLE_32767();
76 a2 := JTF_VARCHAR2_TABLE_300();
77 a3 := JTF_VARCHAR2_TABLE_100();
78 a4 := JTF_NUMBER_TABLE();
79 a5 := JTF_VARCHAR2_TABLE_100();
80 a6 := JTF_NUMBER_TABLE();
81 a7 := JTF_VARCHAR2_TABLE_100();
82 a8 := JTF_NUMBER_TABLE();
83 if t.count > 0 then
84 a0.extend(t.count);
85 a1.extend(t.count);
86 a2.extend(t.count);
87 a3.extend(t.count);
88 a4.extend(t.count);
89 a5.extend(t.count);
90 a6.extend(t.count);
91 a7.extend(t.count);
92 a8.extend(t.count);
93 ddindx := t.first;
94 indx := 1;
95 while true loop
96 a0(indx) := t(ddindx).note;
97 a1(indx) := t(ddindx).note_detail;
98 a2(indx) := t(ddindx).note_type;
99 a3(indx) := t(ddindx).note_context_type_01;
100 a4(indx) := t(ddindx).note_context_type_id_01;
101 a5(indx) := t(ddindx).note_context_type_02;
102 a6(indx) := t(ddindx).note_context_type_id_02;
103 a7(indx) := t(ddindx).note_context_type_03;
104 a8(indx) := t(ddindx).note_context_type_id_03;
105 indx := indx+1;
106 if t.last =ddindx
107 then exit;
108 end if;
109 ddindx := t.next(ddindx);
110 end loop;
111 end if;
112 end if;
113 end rosetta_table_copy_out_p1;
114
115 procedure rosetta_table_copy_in_p3(t out nocopy cs_servicerequest_pub.contacts_table, a0 JTF_NUMBER_TABLE
116 , a1 JTF_NUMBER_TABLE
117 , a2 JTF_NUMBER_TABLE
118 , a3 JTF_VARCHAR2_TABLE_100
119 , a4 JTF_VARCHAR2_TABLE_100
120 , a5 JTF_VARCHAR2_TABLE_100
121 , a6 JTF_VARCHAR2_TABLE_100
122 , a7 JTF_DATE_TABLE
123 , a8 JTF_DATE_TABLE
124 ) as
125 ddindx binary_integer; indx binary_integer;
126 begin
127 if a0 is not null and a0.count > 0 then
128 if a0.count > 0 then
129 indx := a0.first;
130 ddindx := 1;
131 while true loop
132 t(ddindx).sr_contact_point_id := a0(indx);
133 t(ddindx).party_id := a1(indx);
134 t(ddindx).contact_point_id := a2(indx);
135 t(ddindx).contact_point_type := a3(indx);
136 t(ddindx).primary_flag := a4(indx);
137 t(ddindx).contact_type := a5(indx);
138 t(ddindx).party_role_code := a6(indx);
139 t(ddindx).start_date_active := rosetta_g_miss_date_in_map(a7(indx));
140 t(ddindx).end_date_active := rosetta_g_miss_date_in_map(a8(indx));
141 ddindx := ddindx+1;
142 if a0.last =indx
143 then exit;
144 end if;
145 indx := a0.next(indx);
146 end loop;
147 end if;
148 end if;
149 end rosetta_table_copy_in_p3;
150 procedure rosetta_table_copy_out_p3(t cs_servicerequest_pub.contacts_table, a0 out nocopy JTF_NUMBER_TABLE
151 , a1 out nocopy JTF_NUMBER_TABLE
152 , a2 out nocopy JTF_NUMBER_TABLE
153 , a3 out nocopy JTF_VARCHAR2_TABLE_100
154 , a4 out nocopy JTF_VARCHAR2_TABLE_100
155 , a5 out nocopy JTF_VARCHAR2_TABLE_100
156 , a6 out nocopy JTF_VARCHAR2_TABLE_100
157 , a7 out nocopy JTF_DATE_TABLE
158 , a8 out nocopy JTF_DATE_TABLE
159 ) as
160 ddindx binary_integer; indx binary_integer;
161 begin
162 if t is null or t.count = 0 then
163 a0 := JTF_NUMBER_TABLE();
164 a1 := JTF_NUMBER_TABLE();
165 a2 := JTF_NUMBER_TABLE();
166 a3 := JTF_VARCHAR2_TABLE_100();
167 a4 := JTF_VARCHAR2_TABLE_100();
168 a5 := JTF_VARCHAR2_TABLE_100();
169 a6 := JTF_VARCHAR2_TABLE_100();
170 a7 := JTF_DATE_TABLE();
171 a8 := JTF_DATE_TABLE();
172 else
173 a0 := JTF_NUMBER_TABLE();
174 a1 := JTF_NUMBER_TABLE();
175 a2 := JTF_NUMBER_TABLE();
176 a3 := JTF_VARCHAR2_TABLE_100();
177 a4 := JTF_VARCHAR2_TABLE_100();
178 a5 := JTF_VARCHAR2_TABLE_100();
179 a6 := JTF_VARCHAR2_TABLE_100();
180 a7 := JTF_DATE_TABLE();
181 a8 := JTF_DATE_TABLE();
182 if t.count > 0 then
183 a0.extend(t.count);
184 a1.extend(t.count);
185 a2.extend(t.count);
186 a3.extend(t.count);
187 a4.extend(t.count);
188 a5.extend(t.count);
189 a6.extend(t.count);
190 a7.extend(t.count);
191 a8.extend(t.count);
192 ddindx := t.first;
193 indx := 1;
194 while true loop
195 a0(indx) := t(ddindx).sr_contact_point_id;
196 a1(indx) := t(ddindx).party_id;
197 a2(indx) := t(ddindx).contact_point_id;
198 a3(indx) := t(ddindx).contact_point_type;
199 a4(indx) := t(ddindx).primary_flag;
200 a5(indx) := t(ddindx).contact_type;
201 a6(indx) := t(ddindx).party_role_code;
202 a7(indx) := t(ddindx).start_date_active;
203 a8(indx) := t(ddindx).end_date_active;
204 indx := indx+1;
205 if t.last =ddindx
206 then exit;
207 end if;
208 ddindx := t.next(ddindx);
209 end loop;
210 end if;
211 end if;
212 end rosetta_table_copy_out_p3;
213
214 procedure rosetta_table_copy_in_p8(t out nocopy cs_servicerequest_pub.ext_attr_grp_tbl_type, a0 JTF_NUMBER_TABLE
215 , a1 JTF_VARCHAR2_TABLE_200
216 , a2 JTF_VARCHAR2_TABLE_200
217 , a3 JTF_VARCHAR2_TABLE_200
218 , a4 JTF_VARCHAR2_TABLE_200
219 , a5 JTF_VARCHAR2_TABLE_200
220 , a6 JTF_VARCHAR2_TABLE_200
221 , a7 JTF_VARCHAR2_TABLE_100
222 , a8 JTF_NUMBER_TABLE
223 , a9 JTF_NUMBER_TABLE
224 , a10 JTF_VARCHAR2_TABLE_100
225 , a11 JTF_VARCHAR2_TABLE_100
226 , a12 JTF_VARCHAR2_TABLE_200
227 , a13 JTF_VARCHAR2_TABLE_100
228 , a14 JTF_VARCHAR2_TABLE_100
229 ) as
230 ddindx binary_integer; indx binary_integer;
231 begin
232 if a0 is not null and a0.count > 0 then
233 if a0.count > 0 then
234 indx := a0.first;
235 ddindx := 1;
236 while true loop
237 t(ddindx).row_identifier := a0(indx);
238 t(ddindx).pk_column_1 := a1(indx);
239 t(ddindx).pk_column_2 := a2(indx);
240 t(ddindx).pk_column_3 := a3(indx);
241 t(ddindx).pk_column_4 := a4(indx);
242 t(ddindx).pk_column_5 := a5(indx);
243 t(ddindx).context := a6(indx);
244 t(ddindx).object_name := a7(indx);
245 t(ddindx).attr_group_id := a8(indx);
246 t(ddindx).attr_group_app_id := a9(indx);
247 t(ddindx).attr_group_type := a10(indx);
248 t(ddindx).attr_group_name := a11(indx);
249 t(ddindx).attr_group_disp_name := a12(indx);
250 t(ddindx).mapping_req := a13(indx);
251 t(ddindx).operation := a14(indx);
252 ddindx := ddindx+1;
253 if a0.last =indx
254 then exit;
255 end if;
256 indx := a0.next(indx);
257 end loop;
258 end if;
259 end if;
260 end rosetta_table_copy_in_p8;
261 procedure rosetta_table_copy_out_p8(t cs_servicerequest_pub.ext_attr_grp_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
262 , a1 out nocopy JTF_VARCHAR2_TABLE_200
263 , a2 out nocopy JTF_VARCHAR2_TABLE_200
264 , a3 out nocopy JTF_VARCHAR2_TABLE_200
265 , a4 out nocopy JTF_VARCHAR2_TABLE_200
266 , a5 out nocopy JTF_VARCHAR2_TABLE_200
267 , a6 out nocopy JTF_VARCHAR2_TABLE_200
268 , a7 out nocopy JTF_VARCHAR2_TABLE_100
269 , a8 out nocopy JTF_NUMBER_TABLE
270 , a9 out nocopy JTF_NUMBER_TABLE
271 , a10 out nocopy JTF_VARCHAR2_TABLE_100
272 , a11 out nocopy JTF_VARCHAR2_TABLE_100
273 , a12 out nocopy JTF_VARCHAR2_TABLE_200
274 , a13 out nocopy JTF_VARCHAR2_TABLE_100
275 , a14 out nocopy JTF_VARCHAR2_TABLE_100
276 ) as
277 ddindx binary_integer; indx binary_integer;
278 begin
279 if t is null or t.count = 0 then
280 a0 := JTF_NUMBER_TABLE();
281 a1 := JTF_VARCHAR2_TABLE_200();
282 a2 := JTF_VARCHAR2_TABLE_200();
283 a3 := JTF_VARCHAR2_TABLE_200();
284 a4 := JTF_VARCHAR2_TABLE_200();
285 a5 := JTF_VARCHAR2_TABLE_200();
286 a6 := JTF_VARCHAR2_TABLE_200();
287 a7 := JTF_VARCHAR2_TABLE_100();
288 a8 := JTF_NUMBER_TABLE();
289 a9 := JTF_NUMBER_TABLE();
290 a10 := JTF_VARCHAR2_TABLE_100();
291 a11 := JTF_VARCHAR2_TABLE_100();
292 a12 := JTF_VARCHAR2_TABLE_200();
293 a13 := JTF_VARCHAR2_TABLE_100();
294 a14 := JTF_VARCHAR2_TABLE_100();
295 else
296 a0 := JTF_NUMBER_TABLE();
297 a1 := JTF_VARCHAR2_TABLE_200();
298 a2 := JTF_VARCHAR2_TABLE_200();
299 a3 := JTF_VARCHAR2_TABLE_200();
300 a4 := JTF_VARCHAR2_TABLE_200();
301 a5 := JTF_VARCHAR2_TABLE_200();
302 a6 := JTF_VARCHAR2_TABLE_200();
303 a7 := JTF_VARCHAR2_TABLE_100();
304 a8 := JTF_NUMBER_TABLE();
305 a9 := JTF_NUMBER_TABLE();
306 a10 := JTF_VARCHAR2_TABLE_100();
307 a11 := JTF_VARCHAR2_TABLE_100();
308 a12 := JTF_VARCHAR2_TABLE_200();
309 a13 := JTF_VARCHAR2_TABLE_100();
310 a14 := JTF_VARCHAR2_TABLE_100();
311 if t.count > 0 then
312 a0.extend(t.count);
313 a1.extend(t.count);
314 a2.extend(t.count);
315 a3.extend(t.count);
316 a4.extend(t.count);
317 a5.extend(t.count);
318 a6.extend(t.count);
319 a7.extend(t.count);
320 a8.extend(t.count);
321 a9.extend(t.count);
322 a10.extend(t.count);
323 a11.extend(t.count);
324 a12.extend(t.count);
325 a13.extend(t.count);
326 a14.extend(t.count);
327 ddindx := t.first;
328 indx := 1;
329 while true loop
330 a0(indx) := t(ddindx).row_identifier;
331 a1(indx) := t(ddindx).pk_column_1;
332 a2(indx) := t(ddindx).pk_column_2;
333 a3(indx) := t(ddindx).pk_column_3;
334 a4(indx) := t(ddindx).pk_column_4;
335 a5(indx) := t(ddindx).pk_column_5;
336 a6(indx) := t(ddindx).context;
337 a7(indx) := t(ddindx).object_name;
338 a8(indx) := t(ddindx).attr_group_id;
339 a9(indx) := t(ddindx).attr_group_app_id;
340 a10(indx) := t(ddindx).attr_group_type;
341 a11(indx) := t(ddindx).attr_group_name;
342 a12(indx) := t(ddindx).attr_group_disp_name;
343 a13(indx) := t(ddindx).mapping_req;
344 a14(indx) := t(ddindx).operation;
345 indx := indx+1;
346 if t.last =ddindx
347 then exit;
348 end if;
349 ddindx := t.next(ddindx);
350 end loop;
351 end if;
352 end if;
353 end rosetta_table_copy_out_p8;
354
355 procedure rosetta_table_copy_in_p10(t out nocopy cs_servicerequest_pub.ext_attr_tbl_type, a0 JTF_NUMBER_TABLE
356 , a1 JTF_VARCHAR2_TABLE_100
357 , a2 JTF_VARCHAR2_TABLE_200
358 , a3 JTF_VARCHAR2_TABLE_200
359 , a4 JTF_VARCHAR2_TABLE_4000
360 , a5 JTF_NUMBER_TABLE
361 , a6 JTF_DATE_TABLE
362 , a7 JTF_VARCHAR2_TABLE_4000
363 , a8 JTF_VARCHAR2_TABLE_100
364 ) as
365 ddindx binary_integer; indx binary_integer;
366 begin
367 if a0 is not null and a0.count > 0 then
368 if a0.count > 0 then
369 indx := a0.first;
370 ddindx := 1;
371 while true loop
372 t(ddindx).row_identifier := a0(indx);
373 t(ddindx).column_name := a1(indx);
374 t(ddindx).attr_name := a2(indx);
375 t(ddindx).attr_disp_name := a3(indx);
376 t(ddindx).attr_value_str := a4(indx);
377 t(ddindx).attr_value_num := a5(indx);
378 t(ddindx).attr_value_date := rosetta_g_miss_date_in_map(a6(indx));
379 t(ddindx).attr_value_display := a7(indx);
380 t(ddindx).attr_unit_of_measure := a8(indx);
381 ddindx := ddindx+1;
382 if a0.last =indx
383 then exit;
384 end if;
385 indx := a0.next(indx);
386 end loop;
387 end if;
388 end if;
389 end rosetta_table_copy_in_p10;
390 procedure rosetta_table_copy_out_p10(t cs_servicerequest_pub.ext_attr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
391 , a1 out nocopy JTF_VARCHAR2_TABLE_100
392 , a2 out nocopy JTF_VARCHAR2_TABLE_200
393 , a3 out nocopy JTF_VARCHAR2_TABLE_200
394 , a4 out nocopy JTF_VARCHAR2_TABLE_4000
395 , a5 out nocopy JTF_NUMBER_TABLE
396 , a6 out nocopy JTF_DATE_TABLE
397 , a7 out nocopy JTF_VARCHAR2_TABLE_4000
398 , a8 out nocopy JTF_VARCHAR2_TABLE_100
399 ) as
400 ddindx binary_integer; indx binary_integer;
401 begin
402 if t is null or t.count = 0 then
403 a0 := JTF_NUMBER_TABLE();
404 a1 := JTF_VARCHAR2_TABLE_100();
405 a2 := JTF_VARCHAR2_TABLE_200();
406 a3 := JTF_VARCHAR2_TABLE_200();
407 a4 := JTF_VARCHAR2_TABLE_4000();
408 a5 := JTF_NUMBER_TABLE();
409 a6 := JTF_DATE_TABLE();
410 a7 := JTF_VARCHAR2_TABLE_4000();
411 a8 := JTF_VARCHAR2_TABLE_100();
412 else
413 a0 := JTF_NUMBER_TABLE();
414 a1 := JTF_VARCHAR2_TABLE_100();
415 a2 := JTF_VARCHAR2_TABLE_200();
416 a3 := JTF_VARCHAR2_TABLE_200();
417 a4 := JTF_VARCHAR2_TABLE_4000();
418 a5 := JTF_NUMBER_TABLE();
419 a6 := JTF_DATE_TABLE();
420 a7 := JTF_VARCHAR2_TABLE_4000();
421 a8 := JTF_VARCHAR2_TABLE_100();
422 if t.count > 0 then
423 a0.extend(t.count);
424 a1.extend(t.count);
425 a2.extend(t.count);
426 a3.extend(t.count);
427 a4.extend(t.count);
428 a5.extend(t.count);
429 a6.extend(t.count);
430 a7.extend(t.count);
431 a8.extend(t.count);
432 ddindx := t.first;
433 indx := 1;
434 while true loop
435 a0(indx) := t(ddindx).row_identifier;
436 a1(indx) := t(ddindx).column_name;
437 a2(indx) := t(ddindx).attr_name;
438 a3(indx) := t(ddindx).attr_disp_name;
439 a4(indx) := t(ddindx).attr_value_str;
440 a5(indx) := t(ddindx).attr_value_num;
441 a6(indx) := t(ddindx).attr_value_date;
442 a7(indx) := t(ddindx).attr_value_display;
443 a8(indx) := t(ddindx).attr_unit_of_measure;
444 indx := indx+1;
445 if t.last =ddindx
446 then exit;
447 end if;
448 ddindx := t.next(ddindx);
449 end loop;
450 end if;
451 end if;
452 end rosetta_table_copy_out_p10;
453
454 procedure rosetta_table_copy_in_p11(t out nocopy cs_servicerequest_pub.resource_validate_tbl_type, a0 JTF_NUMBER_TABLE) as
455 ddindx binary_integer; indx binary_integer;
456 begin
457 if a0 is not null and a0.count > 0 then
458 if a0.count > 0 then
459 indx := a0.first;
460 ddindx := 1;
461 while true loop
462 t(ddindx) := a0(indx);
463 ddindx := ddindx+1;
464 if a0.last =indx
465 then exit;
466 end if;
467 indx := a0.next(indx);
468 end loop;
469 end if;
470 end if;
471 end rosetta_table_copy_in_p11;
472 procedure rosetta_table_copy_out_p11(t cs_servicerequest_pub.resource_validate_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as
473 ddindx binary_integer; indx binary_integer;
474 begin
475 if t is null or t.count = 0 then
476 a0 := JTF_NUMBER_TABLE();
477 else
478 a0 := JTF_NUMBER_TABLE();
479 if t.count > 0 then
480 a0.extend(t.count);
481 ddindx := t.first;
482 indx := 1;
483 while true loop
484 a0(indx) := t(ddindx);
485 indx := indx+1;
486 if t.last =ddindx
487 then exit;
488 end if;
489 ddindx := t.next(ddindx);
490 end loop;
491 end if;
492 end if;
493 end rosetta_table_copy_out_p11;
494
495 procedure rosetta_table_copy_in_p13(t out nocopy cs_servicerequest_pub.vc2_table, a0 JTF_VARCHAR2_TABLE_100) as
496 ddindx binary_integer; indx binary_integer;
497 begin
498 if a0 is not null and a0.count > 0 then
499 if a0.count > 0 then
500 indx := a0.first;
501 ddindx := 1;
502 while true loop
503 t(ddindx) := a0(indx);
504 ddindx := ddindx+1;
505 if a0.last =indx
506 then exit;
507 end if;
508 indx := a0.next(indx);
509 end loop;
510 end if;
511 end if;
512 end rosetta_table_copy_in_p13;
513 procedure rosetta_table_copy_out_p13(t cs_servicerequest_pub.vc2_table, a0 out nocopy JTF_VARCHAR2_TABLE_100) as
514 ddindx binary_integer; indx binary_integer;
515 begin
516 if t is null or t.count = 0 then
517 a0 := JTF_VARCHAR2_TABLE_100();
518 else
519 a0 := JTF_VARCHAR2_TABLE_100();
520 if t.count > 0 then
521 a0.extend(t.count);
522 ddindx := t.first;
523 indx := 1;
524 while true loop
525 a0(indx) := t(ddindx);
526 indx := indx+1;
527 if t.last =ddindx
528 then exit;
529 end if;
530 ddindx := t.next(ddindx);
531 end loop;
532 end if;
533 end if;
534 end rosetta_table_copy_out_p13;
535
536 procedure rosetta_table_copy_in_p17(t out nocopy cs_servicerequest_pub.sr_notes_table, a0 JTF_VARCHAR2_TABLE_2000
537 , a1 JTF_VARCHAR2_TABLE_100
538 , a2 JTF_CLOB_TABLE
539 , a3 JTF_NUMBER_TABLE
540 ) as
541 ddindx binary_integer; indx binary_integer;
542 begin
543 if a0 is not null and a0.count > 0 then
544 if a0.count > 0 then
545 indx := a0.first;
546 ddindx := 1;
547 while true loop
548 t(ddindx).notes := a0(indx);
549 t(ddindx).note_status := a1(indx);
550 t(ddindx).notes_detail := a2(indx);
551 t(ddindx).created_by := a3(indx);
552 ddindx := ddindx+1;
553 if a0.last =indx
554 then exit;
555 end if;
556 indx := a0.next(indx);
557 end loop;
558 end if;
559 end if;
560 end rosetta_table_copy_in_p17;
561 procedure rosetta_table_copy_out_p17(t cs_servicerequest_pub.sr_notes_table, a0 out nocopy JTF_VARCHAR2_TABLE_2000
562 , a1 out nocopy JTF_VARCHAR2_TABLE_100
563 , a2 out nocopy JTF_CLOB_TABLE
564 , a3 out nocopy JTF_NUMBER_TABLE
565 ) as
566 ddindx binary_integer; indx binary_integer;
567 begin
568 if t is null or t.count = 0 then
569 a0 := JTF_VARCHAR2_TABLE_2000();
570 a1 := JTF_VARCHAR2_TABLE_100();
571 a2 := JTF_CLOB_TABLE();
572 a3 := JTF_NUMBER_TABLE();
573 else
574 a0 := JTF_VARCHAR2_TABLE_2000();
575 a1 := JTF_VARCHAR2_TABLE_100();
576 a2 := JTF_CLOB_TABLE();
577 a3 := JTF_NUMBER_TABLE();
578 if t.count > 0 then
579 a0.extend(t.count);
580 a1.extend(t.count);
581 a2.extend(t.count);
582 a3.extend(t.count);
583 ddindx := t.first;
584 indx := 1;
585 while true loop
586 a0(indx) := t(ddindx).notes;
587 a1(indx) := t(ddindx).note_status;
588 a2(indx) := t(ddindx).notes_detail;
589 a3(indx) := t(ddindx).created_by;
590 indx := indx+1;
591 if t.last =ddindx
592 then exit;
593 end if;
594 ddindx := t.next(ddindx);
595 end loop;
596 end if;
597 end if;
598 end rosetta_table_copy_out_p17;
599
600 procedure rosetta_table_copy_in_p19(t out nocopy cs_servicerequest_pub.tasks_table, a0 JTF_VARCHAR2_TABLE_100
601 , a1 JTF_VARCHAR2_TABLE_100
602 , a2 JTF_VARCHAR2_TABLE_100
603 , a3 JTF_VARCHAR2_TABLE_100
604 , a4 JTF_VARCHAR2_TABLE_100
605 , a5 JTF_VARCHAR2_TABLE_4000
606 , a6 JTF_VARCHAR2_TABLE_100
607 , a7 JTF_VARCHAR2_TABLE_4000
608 , a8 JTF_VARCHAR2_TABLE_100
609 , a9 JTF_VARCHAR2_TABLE_100
610 , a10 JTF_VARCHAR2_TABLE_100
611 , a11 JTF_VARCHAR2_TABLE_100
612 , a12 JTF_DATE_TABLE
613 , a13 JTF_DATE_TABLE
614 , a14 JTF_DATE_TABLE
615 , a15 JTF_DATE_TABLE
616 , a16 JTF_DATE_TABLE
617 , a17 JTF_DATE_TABLE
618 , a18 JTF_NUMBER_TABLE
619 , a19 JTF_VARCHAR2_TABLE_100
620 , a20 JTF_NUMBER_TABLE
621 , a21 JTF_VARCHAR2_TABLE_100
622 , a22 JTF_NUMBER_TABLE
623 , a23 JTF_VARCHAR2_TABLE_100
624 , a24 JTF_VARCHAR2_TABLE_100
625 , a25 JTF_VARCHAR2_TABLE_100
626 , a26 JTF_VARCHAR2_TABLE_100
627 , a27 JTF_NUMBER_TABLE
628 , a28 JTF_DATE_TABLE
629 , a29 JTF_NUMBER_TABLE
630 , a30 JTF_DATE_TABLE
631 , a31 JTF_NUMBER_TABLE
632 , a32 JTF_NUMBER_TABLE
633 , a33 JTF_VARCHAR2_TABLE_100
634 , a34 JTF_VARCHAR2_TABLE_100
635 , a35 JTF_NUMBER_TABLE
636 , a36 JTF_NUMBER_TABLE
637 , a37 JTF_NUMBER_TABLE
638 , a38 JTF_NUMBER_TABLE
639 , a39 JTF_NUMBER_TABLE
640 , a40 JTF_NUMBER_TABLE
641 , a41 JTF_NUMBER_TABLE
642 , a42 JTF_NUMBER_TABLE
643 , a43 JTF_NUMBER_TABLE
644 , a44 JTF_NUMBER_TABLE
645 , a45 JTF_NUMBER_TABLE
646 , a46 JTF_VARCHAR2_TABLE_100
647 , a47 JTF_NUMBER_TABLE
648 , a48 JTF_VARCHAR2_TABLE_100
649 , a49 JTF_VARCHAR2_TABLE_100
650 , a50 JTF_VARCHAR2_TABLE_100
651 , a51 JTF_VARCHAR2_TABLE_100
652 , a52 JTF_VARCHAR2_TABLE_100
653 , a53 JTF_NUMBER_TABLE
654 , a54 JTF_VARCHAR2_TABLE_200
655 , a55 JTF_VARCHAR2_TABLE_200
656 , a56 JTF_VARCHAR2_TABLE_200
657 , a57 JTF_VARCHAR2_TABLE_200
658 , a58 JTF_VARCHAR2_TABLE_200
659 , a59 JTF_VARCHAR2_TABLE_200
660 , a60 JTF_VARCHAR2_TABLE_200
661 , a61 JTF_VARCHAR2_TABLE_200
662 , a62 JTF_VARCHAR2_TABLE_200
663 , a63 JTF_VARCHAR2_TABLE_200
664 , a64 JTF_VARCHAR2_TABLE_200
665 , a65 JTF_VARCHAR2_TABLE_200
666 , a66 JTF_VARCHAR2_TABLE_200
667 , a67 JTF_VARCHAR2_TABLE_200
668 , a68 JTF_VARCHAR2_TABLE_200
669 , a69 JTF_VARCHAR2_TABLE_200
670 ) as
671 ddindx binary_integer; indx binary_integer;
672 begin
673 if a0 is not null and a0.count > 0 then
674 if a0.count > 0 then
675 indx := a0.first;
676 ddindx := 1;
677 while true loop
678 t(ddindx).task_type := a0(indx);
679 t(ddindx).task_status := a1(indx);
680 t(ddindx).task_priority := a2(indx);
681 t(ddindx).restrict_closure_flag := a3(indx);
682 t(ddindx).owner_type := a4(indx);
683 t(ddindx).owner := a5(indx);
684 t(ddindx).task_name := a6(indx);
685 t(ddindx).description := a7(indx);
686 t(ddindx).task_number := a8(indx);
687 t(ddindx).parent_task_number := a9(indx);
688 t(ddindx).escalation_level := a10(indx);
689 t(ddindx).task_confirmation_status := a11(indx);
690 t(ddindx).planned_start_date := rosetta_g_miss_date_in_map(a12(indx));
691 t(ddindx).planned_end_date := rosetta_g_miss_date_in_map(a13(indx));
692 t(ddindx).scheduled_start_date := rosetta_g_miss_date_in_map(a14(indx));
693 t(ddindx).scheduled_end_date := rosetta_g_miss_date_in_map(a15(indx));
694 t(ddindx).actual_start_date := rosetta_g_miss_date_in_map(a16(indx));
695 t(ddindx).actual_end_date := rosetta_g_miss_date_in_map(a17(indx));
696 t(ddindx).planned_effort := a18(indx);
697 t(ddindx).planned_effort_uom := a19(indx);
698 t(ddindx).actual_effort := a20(indx);
699 t(ddindx).actual_effort_uom := a21(indx);
700 t(ddindx).duration := a22(indx);
701 t(ddindx).duration_uom := a23(indx);
702 t(ddindx).private_flag := a24(indx);
703 t(ddindx).publish_flag := a25(indx);
704 t(ddindx).row_id := a26(indx);
705 t(ddindx).created_by := a27(indx);
706 t(ddindx).creation_date := rosetta_g_miss_date_in_map(a28(indx));
707 t(ddindx).last_updated_by := a29(indx);
708 t(ddindx).last_update_date := rosetta_g_miss_date_in_map(a30(indx));
709 t(ddindx).last_update_login := a31(indx);
710 t(ddindx).source_object_id := a32(indx);
711 t(ddindx).source_object_type_code := a33(indx);
712 t(ddindx).source_object_name := a34(indx);
713 t(ddindx).task_type_id := a35(indx);
714 t(ddindx).task_status_id := a36(indx);
715 t(ddindx).task_priority_id := a37(indx);
716 t(ddindx).owner_id := a38(indx);
717 t(ddindx).owner_territory_id := a39(indx);
718 t(ddindx).task_id := a40(indx);
719 t(ddindx).timezone_id := a41(indx);
720 t(ddindx).parent_task_id := a42(indx);
721 t(ddindx).object_version_number := a43(indx);
722 t(ddindx).customer_id := a44(indx);
723 t(ddindx).cust_account_id := a45(indx);
724 t(ddindx).owner_type_code := a46(indx);
725 t(ddindx).recurrence_rule_id := a47(indx);
726 t(ddindx).multi_booked_flag := a48(indx);
727 t(ddindx).milestone_flag := a49(indx);
728 t(ddindx).holiday_flag := a50(indx);
729 t(ddindx).billable_flag := a51(indx);
730 t(ddindx).currency_code := a52(indx);
731 t(ddindx).costs := a53(indx);
732 t(ddindx).attribute1 := a54(indx);
733 t(ddindx).attribute2 := a55(indx);
734 t(ddindx).attribute3 := a56(indx);
735 t(ddindx).attribute4 := a57(indx);
736 t(ddindx).attribute5 := a58(indx);
737 t(ddindx).attribute6 := a59(indx);
738 t(ddindx).attribute7 := a60(indx);
739 t(ddindx).attribute8 := a61(indx);
740 t(ddindx).attribute9 := a62(indx);
741 t(ddindx).attribute10 := a63(indx);
742 t(ddindx).attribute11 := a64(indx);
743 t(ddindx).attribute12 := a65(indx);
744 t(ddindx).attribute13 := a66(indx);
745 t(ddindx).attribute14 := a67(indx);
746 t(ddindx).attribute15 := a68(indx);
747 t(ddindx).attribute_category := a69(indx);
748 ddindx := ddindx+1;
749 if a0.last =indx
750 then exit;
751 end if;
752 indx := a0.next(indx);
753 end loop;
754 end if;
755 end if;
756 end rosetta_table_copy_in_p19;
757 procedure rosetta_table_copy_out_p19(t cs_servicerequest_pub.tasks_table, a0 out nocopy JTF_VARCHAR2_TABLE_100
758 , a1 out nocopy JTF_VARCHAR2_TABLE_100
759 , a2 out nocopy JTF_VARCHAR2_TABLE_100
760 , a3 out nocopy JTF_VARCHAR2_TABLE_100
761 , a4 out nocopy JTF_VARCHAR2_TABLE_100
762 , a5 out nocopy JTF_VARCHAR2_TABLE_4000
763 , a6 out nocopy JTF_VARCHAR2_TABLE_100
764 , a7 out nocopy JTF_VARCHAR2_TABLE_4000
765 , a8 out nocopy JTF_VARCHAR2_TABLE_100
766 , a9 out nocopy JTF_VARCHAR2_TABLE_100
767 , a10 out nocopy JTF_VARCHAR2_TABLE_100
768 , a11 out nocopy JTF_VARCHAR2_TABLE_100
769 , a12 out nocopy JTF_DATE_TABLE
770 , a13 out nocopy JTF_DATE_TABLE
771 , a14 out nocopy JTF_DATE_TABLE
772 , a15 out nocopy JTF_DATE_TABLE
773 , a16 out nocopy JTF_DATE_TABLE
774 , a17 out nocopy JTF_DATE_TABLE
775 , a18 out nocopy JTF_NUMBER_TABLE
776 , a19 out nocopy JTF_VARCHAR2_TABLE_100
777 , a20 out nocopy JTF_NUMBER_TABLE
778 , a21 out nocopy JTF_VARCHAR2_TABLE_100
779 , a22 out nocopy JTF_NUMBER_TABLE
780 , a23 out nocopy JTF_VARCHAR2_TABLE_100
781 , a24 out nocopy JTF_VARCHAR2_TABLE_100
782 , a25 out nocopy JTF_VARCHAR2_TABLE_100
783 , a26 out nocopy JTF_VARCHAR2_TABLE_100
784 , a27 out nocopy JTF_NUMBER_TABLE
785 , a28 out nocopy JTF_DATE_TABLE
786 , a29 out nocopy JTF_NUMBER_TABLE
787 , a30 out nocopy JTF_DATE_TABLE
788 , a31 out nocopy JTF_NUMBER_TABLE
789 , a32 out nocopy JTF_NUMBER_TABLE
790 , a33 out nocopy JTF_VARCHAR2_TABLE_100
791 , a34 out nocopy JTF_VARCHAR2_TABLE_100
792 , a35 out nocopy JTF_NUMBER_TABLE
793 , a36 out nocopy JTF_NUMBER_TABLE
794 , a37 out nocopy JTF_NUMBER_TABLE
795 , a38 out nocopy JTF_NUMBER_TABLE
796 , a39 out nocopy JTF_NUMBER_TABLE
797 , a40 out nocopy JTF_NUMBER_TABLE
798 , a41 out nocopy JTF_NUMBER_TABLE
799 , a42 out nocopy JTF_NUMBER_TABLE
800 , a43 out nocopy JTF_NUMBER_TABLE
801 , a44 out nocopy JTF_NUMBER_TABLE
802 , a45 out nocopy JTF_NUMBER_TABLE
803 , a46 out nocopy JTF_VARCHAR2_TABLE_100
804 , a47 out nocopy JTF_NUMBER_TABLE
805 , a48 out nocopy JTF_VARCHAR2_TABLE_100
806 , a49 out nocopy JTF_VARCHAR2_TABLE_100
807 , a50 out nocopy JTF_VARCHAR2_TABLE_100
808 , a51 out nocopy JTF_VARCHAR2_TABLE_100
809 , a52 out nocopy JTF_VARCHAR2_TABLE_100
810 , a53 out nocopy JTF_NUMBER_TABLE
811 , a54 out nocopy JTF_VARCHAR2_TABLE_200
812 , a55 out nocopy JTF_VARCHAR2_TABLE_200
813 , a56 out nocopy JTF_VARCHAR2_TABLE_200
814 , a57 out nocopy JTF_VARCHAR2_TABLE_200
815 , a58 out nocopy JTF_VARCHAR2_TABLE_200
816 , a59 out nocopy JTF_VARCHAR2_TABLE_200
817 , a60 out nocopy JTF_VARCHAR2_TABLE_200
818 , a61 out nocopy JTF_VARCHAR2_TABLE_200
819 , a62 out nocopy JTF_VARCHAR2_TABLE_200
820 , a63 out nocopy JTF_VARCHAR2_TABLE_200
821 , a64 out nocopy JTF_VARCHAR2_TABLE_200
822 , a65 out nocopy JTF_VARCHAR2_TABLE_200
823 , a66 out nocopy JTF_VARCHAR2_TABLE_200
824 , a67 out nocopy JTF_VARCHAR2_TABLE_200
825 , a68 out nocopy JTF_VARCHAR2_TABLE_200
826 , a69 out nocopy JTF_VARCHAR2_TABLE_200
827 ) as
828 ddindx binary_integer; indx binary_integer;
829 begin
830 if t is null or t.count = 0 then
831 a0 := JTF_VARCHAR2_TABLE_100();
832 a1 := JTF_VARCHAR2_TABLE_100();
833 a2 := JTF_VARCHAR2_TABLE_100();
834 a3 := JTF_VARCHAR2_TABLE_100();
835 a4 := JTF_VARCHAR2_TABLE_100();
836 a5 := JTF_VARCHAR2_TABLE_4000();
837 a6 := JTF_VARCHAR2_TABLE_100();
838 a7 := JTF_VARCHAR2_TABLE_4000();
839 a8 := JTF_VARCHAR2_TABLE_100();
840 a9 := JTF_VARCHAR2_TABLE_100();
841 a10 := JTF_VARCHAR2_TABLE_100();
842 a11 := JTF_VARCHAR2_TABLE_100();
843 a12 := JTF_DATE_TABLE();
844 a13 := JTF_DATE_TABLE();
845 a14 := JTF_DATE_TABLE();
846 a15 := JTF_DATE_TABLE();
847 a16 := JTF_DATE_TABLE();
848 a17 := JTF_DATE_TABLE();
849 a18 := JTF_NUMBER_TABLE();
850 a19 := JTF_VARCHAR2_TABLE_100();
851 a20 := JTF_NUMBER_TABLE();
852 a21 := JTF_VARCHAR2_TABLE_100();
853 a22 := JTF_NUMBER_TABLE();
854 a23 := JTF_VARCHAR2_TABLE_100();
855 a24 := JTF_VARCHAR2_TABLE_100();
856 a25 := JTF_VARCHAR2_TABLE_100();
857 a26 := JTF_VARCHAR2_TABLE_100();
858 a27 := JTF_NUMBER_TABLE();
859 a28 := JTF_DATE_TABLE();
860 a29 := JTF_NUMBER_TABLE();
861 a30 := JTF_DATE_TABLE();
862 a31 := JTF_NUMBER_TABLE();
863 a32 := JTF_NUMBER_TABLE();
864 a33 := JTF_VARCHAR2_TABLE_100();
865 a34 := JTF_VARCHAR2_TABLE_100();
866 a35 := JTF_NUMBER_TABLE();
867 a36 := JTF_NUMBER_TABLE();
868 a37 := JTF_NUMBER_TABLE();
869 a38 := JTF_NUMBER_TABLE();
870 a39 := JTF_NUMBER_TABLE();
871 a40 := JTF_NUMBER_TABLE();
872 a41 := JTF_NUMBER_TABLE();
873 a42 := JTF_NUMBER_TABLE();
874 a43 := JTF_NUMBER_TABLE();
875 a44 := JTF_NUMBER_TABLE();
876 a45 := JTF_NUMBER_TABLE();
877 a46 := JTF_VARCHAR2_TABLE_100();
878 a47 := JTF_NUMBER_TABLE();
879 a48 := JTF_VARCHAR2_TABLE_100();
880 a49 := JTF_VARCHAR2_TABLE_100();
881 a50 := JTF_VARCHAR2_TABLE_100();
882 a51 := JTF_VARCHAR2_TABLE_100();
883 a52 := JTF_VARCHAR2_TABLE_100();
884 a53 := JTF_NUMBER_TABLE();
885 a54 := JTF_VARCHAR2_TABLE_200();
886 a55 := JTF_VARCHAR2_TABLE_200();
887 a56 := JTF_VARCHAR2_TABLE_200();
888 a57 := JTF_VARCHAR2_TABLE_200();
889 a58 := JTF_VARCHAR2_TABLE_200();
890 a59 := JTF_VARCHAR2_TABLE_200();
891 a60 := JTF_VARCHAR2_TABLE_200();
892 a61 := JTF_VARCHAR2_TABLE_200();
893 a62 := JTF_VARCHAR2_TABLE_200();
894 a63 := JTF_VARCHAR2_TABLE_200();
895 a64 := JTF_VARCHAR2_TABLE_200();
896 a65 := JTF_VARCHAR2_TABLE_200();
897 a66 := JTF_VARCHAR2_TABLE_200();
898 a67 := JTF_VARCHAR2_TABLE_200();
899 a68 := JTF_VARCHAR2_TABLE_200();
900 a69 := JTF_VARCHAR2_TABLE_200();
901 else
902 a0 := JTF_VARCHAR2_TABLE_100();
903 a1 := JTF_VARCHAR2_TABLE_100();
904 a2 := JTF_VARCHAR2_TABLE_100();
905 a3 := JTF_VARCHAR2_TABLE_100();
906 a4 := JTF_VARCHAR2_TABLE_100();
907 a5 := JTF_VARCHAR2_TABLE_4000();
908 a6 := JTF_VARCHAR2_TABLE_100();
909 a7 := JTF_VARCHAR2_TABLE_4000();
910 a8 := JTF_VARCHAR2_TABLE_100();
911 a9 := JTF_VARCHAR2_TABLE_100();
912 a10 := JTF_VARCHAR2_TABLE_100();
913 a11 := JTF_VARCHAR2_TABLE_100();
914 a12 := JTF_DATE_TABLE();
915 a13 := JTF_DATE_TABLE();
916 a14 := JTF_DATE_TABLE();
917 a15 := JTF_DATE_TABLE();
918 a16 := JTF_DATE_TABLE();
919 a17 := JTF_DATE_TABLE();
920 a18 := JTF_NUMBER_TABLE();
921 a19 := JTF_VARCHAR2_TABLE_100();
922 a20 := JTF_NUMBER_TABLE();
923 a21 := JTF_VARCHAR2_TABLE_100();
924 a22 := JTF_NUMBER_TABLE();
925 a23 := JTF_VARCHAR2_TABLE_100();
926 a24 := JTF_VARCHAR2_TABLE_100();
927 a25 := JTF_VARCHAR2_TABLE_100();
928 a26 := JTF_VARCHAR2_TABLE_100();
929 a27 := JTF_NUMBER_TABLE();
930 a28 := JTF_DATE_TABLE();
931 a29 := JTF_NUMBER_TABLE();
932 a30 := JTF_DATE_TABLE();
933 a31 := JTF_NUMBER_TABLE();
934 a32 := JTF_NUMBER_TABLE();
935 a33 := JTF_VARCHAR2_TABLE_100();
936 a34 := JTF_VARCHAR2_TABLE_100();
937 a35 := JTF_NUMBER_TABLE();
938 a36 := JTF_NUMBER_TABLE();
939 a37 := JTF_NUMBER_TABLE();
940 a38 := JTF_NUMBER_TABLE();
941 a39 := JTF_NUMBER_TABLE();
942 a40 := JTF_NUMBER_TABLE();
943 a41 := JTF_NUMBER_TABLE();
944 a42 := JTF_NUMBER_TABLE();
945 a43 := JTF_NUMBER_TABLE();
946 a44 := JTF_NUMBER_TABLE();
947 a45 := JTF_NUMBER_TABLE();
948 a46 := JTF_VARCHAR2_TABLE_100();
949 a47 := JTF_NUMBER_TABLE();
950 a48 := JTF_VARCHAR2_TABLE_100();
951 a49 := JTF_VARCHAR2_TABLE_100();
952 a50 := JTF_VARCHAR2_TABLE_100();
953 a51 := JTF_VARCHAR2_TABLE_100();
954 a52 := JTF_VARCHAR2_TABLE_100();
955 a53 := JTF_NUMBER_TABLE();
956 a54 := JTF_VARCHAR2_TABLE_200();
957 a55 := JTF_VARCHAR2_TABLE_200();
958 a56 := JTF_VARCHAR2_TABLE_200();
959 a57 := JTF_VARCHAR2_TABLE_200();
960 a58 := JTF_VARCHAR2_TABLE_200();
961 a59 := JTF_VARCHAR2_TABLE_200();
962 a60 := JTF_VARCHAR2_TABLE_200();
963 a61 := JTF_VARCHAR2_TABLE_200();
964 a62 := JTF_VARCHAR2_TABLE_200();
965 a63 := JTF_VARCHAR2_TABLE_200();
966 a64 := JTF_VARCHAR2_TABLE_200();
967 a65 := JTF_VARCHAR2_TABLE_200();
968 a66 := JTF_VARCHAR2_TABLE_200();
969 a67 := JTF_VARCHAR2_TABLE_200();
970 a68 := JTF_VARCHAR2_TABLE_200();
971 a69 := JTF_VARCHAR2_TABLE_200();
972 if t.count > 0 then
973 a0.extend(t.count);
974 a1.extend(t.count);
975 a2.extend(t.count);
976 a3.extend(t.count);
977 a4.extend(t.count);
978 a5.extend(t.count);
979 a6.extend(t.count);
980 a7.extend(t.count);
981 a8.extend(t.count);
982 a9.extend(t.count);
983 a10.extend(t.count);
984 a11.extend(t.count);
985 a12.extend(t.count);
986 a13.extend(t.count);
987 a14.extend(t.count);
988 a15.extend(t.count);
989 a16.extend(t.count);
990 a17.extend(t.count);
991 a18.extend(t.count);
992 a19.extend(t.count);
993 a20.extend(t.count);
994 a21.extend(t.count);
995 a22.extend(t.count);
996 a23.extend(t.count);
997 a24.extend(t.count);
998 a25.extend(t.count);
999 a26.extend(t.count);
1000 a27.extend(t.count);
1001 a28.extend(t.count);
1002 a29.extend(t.count);
1003 a30.extend(t.count);
1004 a31.extend(t.count);
1005 a32.extend(t.count);
1006 a33.extend(t.count);
1007 a34.extend(t.count);
1008 a35.extend(t.count);
1009 a36.extend(t.count);
1010 a37.extend(t.count);
1011 a38.extend(t.count);
1012 a39.extend(t.count);
1013 a40.extend(t.count);
1014 a41.extend(t.count);
1015 a42.extend(t.count);
1016 a43.extend(t.count);
1017 a44.extend(t.count);
1018 a45.extend(t.count);
1019 a46.extend(t.count);
1020 a47.extend(t.count);
1021 a48.extend(t.count);
1022 a49.extend(t.count);
1023 a50.extend(t.count);
1024 a51.extend(t.count);
1025 a52.extend(t.count);
1026 a53.extend(t.count);
1027 a54.extend(t.count);
1028 a55.extend(t.count);
1029 a56.extend(t.count);
1030 a57.extend(t.count);
1031 a58.extend(t.count);
1032 a59.extend(t.count);
1033 a60.extend(t.count);
1034 a61.extend(t.count);
1035 a62.extend(t.count);
1036 a63.extend(t.count);
1037 a64.extend(t.count);
1038 a65.extend(t.count);
1039 a66.extend(t.count);
1040 a67.extend(t.count);
1041 a68.extend(t.count);
1042 a69.extend(t.count);
1043 ddindx := t.first;
1044 indx := 1;
1045 while true loop
1046 a0(indx) := t(ddindx).task_type;
1047 a1(indx) := t(ddindx).task_status;
1048 a2(indx) := t(ddindx).task_priority;
1049 a3(indx) := t(ddindx).restrict_closure_flag;
1050 a4(indx) := t(ddindx).owner_type;
1051 a5(indx) := t(ddindx).owner;
1052 a6(indx) := t(ddindx).task_name;
1053 a7(indx) := t(ddindx).description;
1054 a8(indx) := t(ddindx).task_number;
1055 a9(indx) := t(ddindx).parent_task_number;
1056 a10(indx) := t(ddindx).escalation_level;
1057 a11(indx) := t(ddindx).task_confirmation_status;
1058 a12(indx) := t(ddindx).planned_start_date;
1059 a13(indx) := t(ddindx).planned_end_date;
1060 a14(indx) := t(ddindx).scheduled_start_date;
1061 a15(indx) := t(ddindx).scheduled_end_date;
1062 a16(indx) := t(ddindx).actual_start_date;
1063 a17(indx) := t(ddindx).actual_end_date;
1064 a18(indx) := t(ddindx).planned_effort;
1065 a19(indx) := t(ddindx).planned_effort_uom;
1066 a20(indx) := t(ddindx).actual_effort;
1067 a21(indx) := t(ddindx).actual_effort_uom;
1068 a22(indx) := t(ddindx).duration;
1069 a23(indx) := t(ddindx).duration_uom;
1070 a24(indx) := t(ddindx).private_flag;
1071 a25(indx) := t(ddindx).publish_flag;
1072 a26(indx) := t(ddindx).row_id;
1073 a27(indx) := t(ddindx).created_by;
1074 a28(indx) := t(ddindx).creation_date;
1075 a29(indx) := t(ddindx).last_updated_by;
1076 a30(indx) := t(ddindx).last_update_date;
1077 a31(indx) := t(ddindx).last_update_login;
1078 a32(indx) := t(ddindx).source_object_id;
1079 a33(indx) := t(ddindx).source_object_type_code;
1080 a34(indx) := t(ddindx).source_object_name;
1081 a35(indx) := t(ddindx).task_type_id;
1082 a36(indx) := t(ddindx).task_status_id;
1083 a37(indx) := t(ddindx).task_priority_id;
1084 a38(indx) := t(ddindx).owner_id;
1085 a39(indx) := t(ddindx).owner_territory_id;
1086 a40(indx) := t(ddindx).task_id;
1087 a41(indx) := t(ddindx).timezone_id;
1088 a42(indx) := t(ddindx).parent_task_id;
1089 a43(indx) := t(ddindx).object_version_number;
1090 a44(indx) := t(ddindx).customer_id;
1091 a45(indx) := t(ddindx).cust_account_id;
1092 a46(indx) := t(ddindx).owner_type_code;
1093 a47(indx) := t(ddindx).recurrence_rule_id;
1094 a48(indx) := t(ddindx).multi_booked_flag;
1095 a49(indx) := t(ddindx).milestone_flag;
1096 a50(indx) := t(ddindx).holiday_flag;
1097 a51(indx) := t(ddindx).billable_flag;
1098 a52(indx) := t(ddindx).currency_code;
1099 a53(indx) := t(ddindx).costs;
1100 a54(indx) := t(ddindx).attribute1;
1101 a55(indx) := t(ddindx).attribute2;
1102 a56(indx) := t(ddindx).attribute3;
1103 a57(indx) := t(ddindx).attribute4;
1104 a58(indx) := t(ddindx).attribute5;
1105 a59(indx) := t(ddindx).attribute6;
1106 a60(indx) := t(ddindx).attribute7;
1107 a61(indx) := t(ddindx).attribute8;
1108 a62(indx) := t(ddindx).attribute9;
1109 a63(indx) := t(ddindx).attribute10;
1110 a64(indx) := t(ddindx).attribute11;
1111 a65(indx) := t(ddindx).attribute12;
1112 a66(indx) := t(ddindx).attribute13;
1113 a67(indx) := t(ddindx).attribute14;
1114 a68(indx) := t(ddindx).attribute15;
1115 a69(indx) := t(ddindx).attribute_category;
1116 indx := indx+1;
1117 if t.last =ddindx
1118 then exit;
1119 end if;
1120 ddindx := t.next(ddindx);
1121 end loop;
1122 end if;
1123 end if;
1124 end rosetta_table_copy_out_p19;
1125
1126 procedure initialize_rec(p0_a0 in out nocopy DATE
1127 , p0_a1 in out nocopy NUMBER
1128 , p0_a2 in out nocopy VARCHAR2
1129 , p0_a3 in out nocopy NUMBER
1130 , p0_a4 in out nocopy VARCHAR2
1131 , p0_a5 in out nocopy NUMBER
1132 , p0_a6 in out nocopy VARCHAR2
1133 , p0_a7 in out nocopy NUMBER
1134 , p0_a8 in out nocopy VARCHAR2
1135 , p0_a9 in out nocopy DATE
1136 , p0_a10 in out nocopy NUMBER
1137 , p0_a11 in out nocopy NUMBER
1138 , p0_a12 in out nocopy VARCHAR2
1139 , p0_a13 in out nocopy VARCHAR2
1140 , p0_a14 in out nocopy VARCHAR2
1141 , p0_a15 in out nocopy NUMBER
1142 , p0_a16 in out nocopy VARCHAR2
1143 , p0_a17 in out nocopy NUMBER
1144 , p0_a18 in out nocopy VARCHAR2
1145 , p0_a19 in out nocopy VARCHAR2
1146 , p0_a20 in out nocopy NUMBER
1147 , p0_a21 in out nocopy NUMBER
1148 , p0_a22 in out nocopy VARCHAR2
1149 , p0_a23 in out nocopy VARCHAR2
1150 , p0_a24 in out nocopy NUMBER
1151 , p0_a25 in out nocopy NUMBER
1152 , p0_a26 in out nocopy NUMBER
1153 , p0_a27 in out nocopy NUMBER
1154 , p0_a28 in out nocopy NUMBER
1155 , p0_a29 in out nocopy NUMBER
1156 , p0_a30 in out nocopy VARCHAR2
1157 , p0_a31 in out nocopy NUMBER
1158 , p0_a32 in out nocopy NUMBER
1159 , p0_a33 in out nocopy VARCHAR2
1160 , p0_a34 in out nocopy VARCHAR2
1161 , p0_a35 in out nocopy VARCHAR2
1162 , p0_a36 in out nocopy VARCHAR2
1163 , p0_a37 in out nocopy VARCHAR2
1164 , p0_a38 in out nocopy VARCHAR2
1165 , p0_a39 in out nocopy VARCHAR2
1166 , p0_a40 in out nocopy VARCHAR2
1167 , p0_a41 in out nocopy VARCHAR2
1168 , p0_a42 in out nocopy VARCHAR2
1169 , p0_a43 in out nocopy VARCHAR2
1170 , p0_a44 in out nocopy VARCHAR2
1171 , p0_a45 in out nocopy VARCHAR2
1172 , p0_a46 in out nocopy VARCHAR2
1173 , p0_a47 in out nocopy VARCHAR2
1174 , p0_a48 in out nocopy VARCHAR2
1175 , p0_a49 in out nocopy VARCHAR2
1176 , p0_a50 in out nocopy VARCHAR2
1177 , p0_a51 in out nocopy VARCHAR2
1178 , p0_a52 in out nocopy VARCHAR2
1179 , p0_a53 in out nocopy VARCHAR2
1180 , p0_a54 in out nocopy VARCHAR2
1181 , p0_a55 in out nocopy NUMBER
1182 , p0_a56 in out nocopy VARCHAR2
1183 , p0_a57 in out nocopy NUMBER
1184 , p0_a58 in out nocopy VARCHAR2
1185 , p0_a59 in out nocopy VARCHAR2
1186 , p0_a60 in out nocopy DATE
1187 , p0_a61 in out nocopy NUMBER
1188 , p0_a62 in out nocopy VARCHAR2
1189 , p0_a63 in out nocopy VARCHAR2
1190 , p0_a64 in out nocopy VARCHAR2
1191 , p0_a65 in out nocopy VARCHAR2
1192 , p0_a66 in out nocopy VARCHAR2
1193 , p0_a67 in out nocopy VARCHAR2
1194 , p0_a68 in out nocopy VARCHAR2
1195 , p0_a69 in out nocopy VARCHAR2
1196 , p0_a70 in out nocopy VARCHAR2
1197 , p0_a71 in out nocopy VARCHAR2
1198 , p0_a72 in out nocopy VARCHAR2
1199 , p0_a73 in out nocopy VARCHAR2
1200 , p0_a74 in out nocopy VARCHAR2
1201 , p0_a75 in out nocopy VARCHAR2
1202 , p0_a76 in out nocopy VARCHAR2
1203 , p0_a77 in out nocopy VARCHAR2
1204 , p0_a78 in out nocopy VARCHAR2
1205 , p0_a79 in out nocopy VARCHAR2
1206 , p0_a80 in out nocopy VARCHAR2
1207 , p0_a81 in out nocopy VARCHAR2
1208 , p0_a82 in out nocopy VARCHAR2
1209 , p0_a83 in out nocopy VARCHAR2
1210 , p0_a84 in out nocopy VARCHAR2
1211 , p0_a85 in out nocopy VARCHAR2
1212 , p0_a86 in out nocopy VARCHAR2
1213 , p0_a87 in out nocopy VARCHAR2
1214 , p0_a88 in out nocopy VARCHAR2
1215 , p0_a89 in out nocopy VARCHAR2
1216 , p0_a90 in out nocopy VARCHAR2
1217 , p0_a91 in out nocopy VARCHAR2
1218 , p0_a92 in out nocopy VARCHAR2
1219 , p0_a93 in out nocopy VARCHAR2
1220 , p0_a94 in out nocopy NUMBER
1221 , p0_a95 in out nocopy NUMBER
1222 , p0_a96 in out nocopy NUMBER
1223 , p0_a97 in out nocopy NUMBER
1224 , p0_a98 in out nocopy VARCHAR2
1225 , p0_a99 in out nocopy DATE
1226 , p0_a100 in out nocopy VARCHAR2
1227 , p0_a101 in out nocopy NUMBER
1228 , p0_a102 in out nocopy NUMBER
1229 , p0_a103 in out nocopy VARCHAR2
1230 , p0_a104 in out nocopy NUMBER
1231 , p0_a105 in out nocopy VARCHAR2
1232 , p0_a106 in out nocopy NUMBER
1233 , p0_a107 in out nocopy NUMBER
1234 , p0_a108 in out nocopy VARCHAR2
1235 , p0_a109 in out nocopy NUMBER
1236 , p0_a110 in out nocopy VARCHAR2
1237 , p0_a111 in out nocopy VARCHAR2
1238 , p0_a112 in out nocopy VARCHAR2
1239 , p0_a113 in out nocopy DATE
1240 , p0_a114 in out nocopy NUMBER
1241 , p0_a115 in out nocopy NUMBER
1242 , p0_a116 in out nocopy NUMBER
1243 , p0_a117 in out nocopy NUMBER
1244 , p0_a118 in out nocopy NUMBER
1245 , p0_a119 in out nocopy VARCHAR2
1246 , p0_a120 in out nocopy NUMBER
1247 , p0_a121 in out nocopy VARCHAR2
1248 , p0_a122 in out nocopy NUMBER
1249 , p0_a123 in out nocopy VARCHAR2
1250 , p0_a124 in out nocopy NUMBER
1251 , p0_a125 in out nocopy VARCHAR2
1252 , p0_a126 in out nocopy VARCHAR2
1253 , p0_a127 in out nocopy VARCHAR2
1254 , p0_a128 in out nocopy VARCHAR2
1255 , p0_a129 in out nocopy VARCHAR2
1256 , p0_a130 in out nocopy VARCHAR2
1257 , p0_a131 in out nocopy NUMBER
1258 , p0_a132 in out nocopy NUMBER
1259 , p0_a133 in out nocopy VARCHAR2
1260 , p0_a134 in out nocopy NUMBER
1261 , p0_a135 in out nocopy NUMBER
1262 , p0_a136 in out nocopy VARCHAR2
1263 , p0_a137 in out nocopy VARCHAR2
1264 , p0_a138 in out nocopy VARCHAR2
1265 , p0_a139 in out nocopy VARCHAR2
1266 , p0_a140 in out nocopy VARCHAR2
1267 , p0_a141 in out nocopy VARCHAR2
1268 , p0_a142 in out nocopy NUMBER
1269 , p0_a143 in out nocopy VARCHAR2
1270 , p0_a144 in out nocopy NUMBER
1271 , p0_a145 in out nocopy VARCHAR2
1272 , p0_a146 in out nocopy DATE
1273 , p0_a147 in out nocopy DATE
1274 , p0_a148 in out nocopy DATE
1275 , p0_a149 in out nocopy VARCHAR2
1276 , p0_a150 in out nocopy NUMBER
1277 , p0_a151 in out nocopy VARCHAR2
1278 , p0_a152 in out nocopy VARCHAR2
1279 , p0_a153 in out nocopy VARCHAR2
1280 , p0_a154 in out nocopy VARCHAR2
1281 , p0_a155 in out nocopy VARCHAR2
1282 , p0_a156 in out nocopy VARCHAR2
1283 , p0_a157 in out nocopy VARCHAR2
1284 , p0_a158 in out nocopy VARCHAR2
1285 , p0_a159 in out nocopy VARCHAR2
1286 , p0_a160 in out nocopy VARCHAR2
1287 , p0_a161 in out nocopy VARCHAR2
1288 , p0_a162 in out nocopy VARCHAR2
1289 , p0_a163 in out nocopy VARCHAR2
1290 , p0_a164 in out nocopy DATE
1291 , p0_a165 in out nocopy VARCHAR
1292 , p0_a166 in out nocopy VARCHAR
1293 , p0_a167 in out nocopy VARCHAR
1294 , p0_a168 in out nocopy VARCHAR
1295 , p0_a169 in out nocopy NUMBER
1296 , p0_a170 in out nocopy NUMBER
1297 , p0_a171 in out nocopy NUMBER
1298 , p0_a172 in out nocopy NUMBER
1299 , p0_a173 in out nocopy NUMBER
1300 , p0_a174 in out nocopy VARCHAR2
1301 , p0_a175 in out nocopy VARCHAR2
1302 , p0_a176 in out nocopy NUMBER
1303 , p0_a177 in out nocopy NUMBER
1304 , p0_a178 in out nocopy NUMBER
1305 , p0_a179 in out nocopy NUMBER
1306 , p0_a180 in out nocopy NUMBER
1307 , p0_a181 in out nocopy NUMBER
1308 , p0_a182 in out nocopy NUMBER
1309 , p0_a183 in out nocopy NUMBER
1310 , p0_a184 in out nocopy VARCHAR2
1311 , p0_a185 in out nocopy VARCHAR2
1312 , p0_a186 in out nocopy VARCHAR2
1313 , p0_a187 in out nocopy VARCHAR2
1314 , p0_a188 in out nocopy VARCHAR2
1315 , p0_a189 in out nocopy VARCHAR2
1316 , p0_a190 in out nocopy VARCHAR2
1317 , p0_a191 in out nocopy VARCHAR2
1318 , p0_a192 in out nocopy VARCHAR2
1319 , p0_a193 in out nocopy VARCHAR2
1320 , p0_a194 in out nocopy VARCHAR2
1321 , p0_a195 in out nocopy VARCHAR2
1322 , p0_a196 in out nocopy VARCHAR2
1323 , p0_a197 in out nocopy VARCHAR2
1324 , p0_a198 in out nocopy VARCHAR2
1325 , p0_a199 in out nocopy VARCHAR2
1326 , p0_a200 in out nocopy VARCHAR2
1327 , p0_a201 in out nocopy VARCHAR2
1328 , p0_a202 in out nocopy VARCHAR2
1329 , p0_a203 in out nocopy VARCHAR2
1330 , p0_a204 in out nocopy VARCHAR2
1331 , p0_a205 in out nocopy NUMBER
1332 , p0_a206 in out nocopy VARCHAR2
1333 , p0_a207 in out nocopy NUMBER
1334 , p0_a208 in out nocopy VARCHAR2
1335 , p0_a209 in out nocopy VARCHAR2
1336 , p0_a210 in out nocopy NUMBER
1337 , p0_a211 in out nocopy DATE
1338 , p0_a212 in out nocopy NUMBER
1339 , p0_a213 in out nocopy NUMBER
1340 , p0_a214 in out nocopy NUMBER
1341 , p0_a215 in out nocopy NUMBER
1342 , p0_a216 in out nocopy NUMBER
1343 , p0_a217 in out nocopy DATE
1344 , p0_a218 in out nocopy DATE
1345 , p0_a219 in out nocopy DATE
1346 , p0_a220 in out nocopy DATE
1347 , p0_a221 in out nocopy DATE
1348 , p0_a222 in out nocopy DATE
1349 , p0_a223 in out nocopy NUMBER
1350 , p0_a224 in out nocopy NUMBER
1351 , p0_a225 in out nocopy NUMBER
1352 )
1353
1354 as
1355 ddp_sr_record cs_servicerequest_pub.service_request_rec_type;
1356 ddindx binary_integer; indx binary_integer;
1357 begin
1358
1359 -- copy data to the local IN or IN-OUT args, if any
1360 ddp_sr_record.request_date := rosetta_g_miss_date_in_map(p0_a0);
1361 ddp_sr_record.type_id := p0_a1;
1362 ddp_sr_record.type_name := p0_a2;
1363 ddp_sr_record.status_id := p0_a3;
1364 ddp_sr_record.status_name := p0_a4;
1365 ddp_sr_record.severity_id := p0_a5;
1366 ddp_sr_record.severity_name := p0_a6;
1367 ddp_sr_record.urgency_id := p0_a7;
1368 ddp_sr_record.urgency_name := p0_a8;
1369 ddp_sr_record.closed_date := rosetta_g_miss_date_in_map(p0_a9);
1370 ddp_sr_record.owner_id := p0_a10;
1371 ddp_sr_record.owner_group_id := p0_a11;
1372 ddp_sr_record.publish_flag := p0_a12;
1373 ddp_sr_record.summary := p0_a13;
1374 ddp_sr_record.caller_type := p0_a14;
1375 ddp_sr_record.customer_id := p0_a15;
1376 ddp_sr_record.customer_number := p0_a16;
1377 ddp_sr_record.employee_id := p0_a17;
1378 ddp_sr_record.employee_number := p0_a18;
1379 ddp_sr_record.verify_cp_flag := p0_a19;
1380 ddp_sr_record.customer_product_id := p0_a20;
1381 ddp_sr_record.platform_id := p0_a21;
1382 ddp_sr_record.platform_version := p0_a22;
1383 ddp_sr_record.db_version := p0_a23;
1384 ddp_sr_record.platform_version_id := p0_a24;
1385 ddp_sr_record.cp_component_id := p0_a25;
1386 ddp_sr_record.cp_component_version_id := p0_a26;
1387 ddp_sr_record.cp_subcomponent_id := p0_a27;
1388 ddp_sr_record.cp_subcomponent_version_id := p0_a28;
1389 ddp_sr_record.language_id := p0_a29;
1390 ddp_sr_record.language := p0_a30;
1391 ddp_sr_record.cp_ref_number := p0_a31;
1392 ddp_sr_record.inventory_item_id := p0_a32;
1393 ddp_sr_record.inventory_item_conc_segs := p0_a33;
1394 ddp_sr_record.inventory_item_segment1 := p0_a34;
1395 ddp_sr_record.inventory_item_segment2 := p0_a35;
1396 ddp_sr_record.inventory_item_segment3 := p0_a36;
1397 ddp_sr_record.inventory_item_segment4 := p0_a37;
1398 ddp_sr_record.inventory_item_segment5 := p0_a38;
1399 ddp_sr_record.inventory_item_segment6 := p0_a39;
1400 ddp_sr_record.inventory_item_segment7 := p0_a40;
1401 ddp_sr_record.inventory_item_segment8 := p0_a41;
1402 ddp_sr_record.inventory_item_segment9 := p0_a42;
1403 ddp_sr_record.inventory_item_segment10 := p0_a43;
1404 ddp_sr_record.inventory_item_segment11 := p0_a44;
1405 ddp_sr_record.inventory_item_segment12 := p0_a45;
1406 ddp_sr_record.inventory_item_segment13 := p0_a46;
1407 ddp_sr_record.inventory_item_segment14 := p0_a47;
1408 ddp_sr_record.inventory_item_segment15 := p0_a48;
1409 ddp_sr_record.inventory_item_segment16 := p0_a49;
1410 ddp_sr_record.inventory_item_segment17 := p0_a50;
1411 ddp_sr_record.inventory_item_segment18 := p0_a51;
1412 ddp_sr_record.inventory_item_segment19 := p0_a52;
1413 ddp_sr_record.inventory_item_segment20 := p0_a53;
1414 ddp_sr_record.inventory_item_vals_or_ids := p0_a54;
1415 ddp_sr_record.inventory_org_id := p0_a55;
1416 ddp_sr_record.current_serial_number := p0_a56;
1417 ddp_sr_record.original_order_number := p0_a57;
1418 ddp_sr_record.purchase_order_num := p0_a58;
1419 ddp_sr_record.problem_code := p0_a59;
1420 ddp_sr_record.exp_resolution_date := rosetta_g_miss_date_in_map(p0_a60);
1421 ddp_sr_record.install_site_use_id := p0_a61;
1422 ddp_sr_record.request_attribute_1 := p0_a62;
1423 ddp_sr_record.request_attribute_2 := p0_a63;
1424 ddp_sr_record.request_attribute_3 := p0_a64;
1425 ddp_sr_record.request_attribute_4 := p0_a65;
1426 ddp_sr_record.request_attribute_5 := p0_a66;
1427 ddp_sr_record.request_attribute_6 := p0_a67;
1428 ddp_sr_record.request_attribute_7 := p0_a68;
1429 ddp_sr_record.request_attribute_8 := p0_a69;
1430 ddp_sr_record.request_attribute_9 := p0_a70;
1431 ddp_sr_record.request_attribute_10 := p0_a71;
1432 ddp_sr_record.request_attribute_11 := p0_a72;
1433 ddp_sr_record.request_attribute_12 := p0_a73;
1434 ddp_sr_record.request_attribute_13 := p0_a74;
1435 ddp_sr_record.request_attribute_14 := p0_a75;
1436 ddp_sr_record.request_attribute_15 := p0_a76;
1437 ddp_sr_record.request_context := p0_a77;
1438 ddp_sr_record.external_attribute_1 := p0_a78;
1439 ddp_sr_record.external_attribute_2 := p0_a79;
1440 ddp_sr_record.external_attribute_3 := p0_a80;
1441 ddp_sr_record.external_attribute_4 := p0_a81;
1442 ddp_sr_record.external_attribute_5 := p0_a82;
1443 ddp_sr_record.external_attribute_6 := p0_a83;
1444 ddp_sr_record.external_attribute_7 := p0_a84;
1445 ddp_sr_record.external_attribute_8 := p0_a85;
1446 ddp_sr_record.external_attribute_9 := p0_a86;
1447 ddp_sr_record.external_attribute_10 := p0_a87;
1448 ddp_sr_record.external_attribute_11 := p0_a88;
1449 ddp_sr_record.external_attribute_12 := p0_a89;
1450 ddp_sr_record.external_attribute_13 := p0_a90;
1451 ddp_sr_record.external_attribute_14 := p0_a91;
1452 ddp_sr_record.external_attribute_15 := p0_a92;
1453 ddp_sr_record.external_context := p0_a93;
1454 ddp_sr_record.bill_to_site_use_id := p0_a94;
1455 ddp_sr_record.bill_to_contact_id := p0_a95;
1456 ddp_sr_record.ship_to_site_use_id := p0_a96;
1457 ddp_sr_record.ship_to_contact_id := p0_a97;
1458 ddp_sr_record.resolution_code := p0_a98;
1459 ddp_sr_record.act_resolution_date := rosetta_g_miss_date_in_map(p0_a99);
1460 ddp_sr_record.public_comment_flag := p0_a100;
1461 ddp_sr_record.parent_interaction_id := p0_a101;
1462 ddp_sr_record.contract_service_id := p0_a102;
1463 ddp_sr_record.contract_service_number := p0_a103;
1464 ddp_sr_record.contract_id := p0_a104;
1465 ddp_sr_record.project_number := p0_a105;
1466 ddp_sr_record.qa_collection_plan_id := p0_a106;
1467 ddp_sr_record.account_id := p0_a107;
1468 ddp_sr_record.resource_type := p0_a108;
1469 ddp_sr_record.resource_subtype_id := p0_a109;
1470 ddp_sr_record.cust_po_number := p0_a110;
1471 ddp_sr_record.cust_ticket_number := p0_a111;
1472 ddp_sr_record.sr_creation_channel := p0_a112;
1473 ddp_sr_record.obligation_date := rosetta_g_miss_date_in_map(p0_a113);
1474 ddp_sr_record.time_zone_id := p0_a114;
1475 ddp_sr_record.time_difference := p0_a115;
1476 ddp_sr_record.site_id := p0_a116;
1477 ddp_sr_record.customer_site_id := p0_a117;
1478 ddp_sr_record.territory_id := p0_a118;
1479 ddp_sr_record.initialize_flag := p0_a119;
1480 ddp_sr_record.cp_revision_id := p0_a120;
1481 ddp_sr_record.inv_item_revision := p0_a121;
1482 ddp_sr_record.inv_component_id := p0_a122;
1483 ddp_sr_record.inv_component_version := p0_a123;
1484 ddp_sr_record.inv_subcomponent_id := p0_a124;
1485 ddp_sr_record.inv_subcomponent_version := p0_a125;
1486 ddp_sr_record.tier := p0_a126;
1487 ddp_sr_record.tier_version := p0_a127;
1488 ddp_sr_record.operating_system := p0_a128;
1489 ddp_sr_record.operating_system_version := p0_a129;
1490 ddp_sr_record.database := p0_a130;
1491 ddp_sr_record.cust_pref_lang_id := p0_a131;
1492 ddp_sr_record.category_id := p0_a132;
1493 ddp_sr_record.group_type := p0_a133;
1494 ddp_sr_record.group_territory_id := p0_a134;
1495 ddp_sr_record.inv_platform_org_id := p0_a135;
1496 ddp_sr_record.component_version := p0_a136;
1497 ddp_sr_record.subcomponent_version := p0_a137;
1498 ddp_sr_record.product_revision := p0_a138;
1499 ddp_sr_record.comm_pref_code := p0_a139;
1500 ddp_sr_record.cust_pref_lang_code := p0_a140;
1501 ddp_sr_record.last_update_channel := p0_a141;
1502 ddp_sr_record.category_set_id := p0_a142;
1503 ddp_sr_record.external_reference := p0_a143;
1504 ddp_sr_record.system_id := p0_a144;
1505 ddp_sr_record.error_code := p0_a145;
1506 ddp_sr_record.incident_occurred_date := rosetta_g_miss_date_in_map(p0_a146);
1507 ddp_sr_record.incident_resolved_date := rosetta_g_miss_date_in_map(p0_a147);
1508 ddp_sr_record.inc_responded_by_date := rosetta_g_miss_date_in_map(p0_a148);
1509 ddp_sr_record.resolution_summary := p0_a149;
1510 ddp_sr_record.incident_location_id := p0_a150;
1511 ddp_sr_record.incident_address := p0_a151;
1512 ddp_sr_record.incident_city := p0_a152;
1513 ddp_sr_record.incident_state := p0_a153;
1514 ddp_sr_record.incident_country := p0_a154;
1515 ddp_sr_record.incident_province := p0_a155;
1516 ddp_sr_record.incident_postal_code := p0_a156;
1517 ddp_sr_record.incident_county := p0_a157;
1518 ddp_sr_record.site_number := p0_a158;
1519 ddp_sr_record.site_name := p0_a159;
1520 ddp_sr_record.addressee := p0_a160;
1521 ddp_sr_record.owner := p0_a161;
1522 ddp_sr_record.group_owner := p0_a162;
1523 ddp_sr_record.cc_number := p0_a163;
1524 ddp_sr_record.cc_expiration_date := rosetta_g_miss_date_in_map(p0_a164);
1525 ddp_sr_record.cc_type_code := p0_a165;
1526 ddp_sr_record.cc_first_name := p0_a166;
1527 ddp_sr_record.cc_last_name := p0_a167;
1528 ddp_sr_record.cc_middle_name := p0_a168;
1529 ddp_sr_record.cc_id := p0_a169;
1530 ddp_sr_record.bill_to_account_id := p0_a170;
1531 ddp_sr_record.ship_to_account_id := p0_a171;
1532 ddp_sr_record.customer_phone_id := p0_a172;
1533 ddp_sr_record.customer_email_id := p0_a173;
1534 ddp_sr_record.creation_program_code := p0_a174;
1535 ddp_sr_record.last_update_program_code := p0_a175;
1536 ddp_sr_record.bill_to_party_id := p0_a176;
1537 ddp_sr_record.ship_to_party_id := p0_a177;
1538 ddp_sr_record.program_id := p0_a178;
1539 ddp_sr_record.program_application_id := p0_a179;
1540 ddp_sr_record.conc_request_id := p0_a180;
1541 ddp_sr_record.program_login_id := p0_a181;
1542 ddp_sr_record.bill_to_site_id := p0_a182;
1543 ddp_sr_record.ship_to_site_id := p0_a183;
1544 ddp_sr_record.incident_point_of_interest := p0_a184;
1545 ddp_sr_record.incident_cross_street := p0_a185;
1546 ddp_sr_record.incident_direction_qualifier := p0_a186;
1547 ddp_sr_record.incident_distance_qualifier := p0_a187;
1548 ddp_sr_record.incident_distance_qual_uom := p0_a188;
1549 ddp_sr_record.incident_address2 := p0_a189;
1550 ddp_sr_record.incident_address3 := p0_a190;
1551 ddp_sr_record.incident_address4 := p0_a191;
1552 ddp_sr_record.incident_address_style := p0_a192;
1553 ddp_sr_record.incident_addr_lines_phonetic := p0_a193;
1554 ddp_sr_record.incident_po_box_number := p0_a194;
1555 ddp_sr_record.incident_house_number := p0_a195;
1556 ddp_sr_record.incident_street_suffix := p0_a196;
1557 ddp_sr_record.incident_street := p0_a197;
1558 ddp_sr_record.incident_street_number := p0_a198;
1559 ddp_sr_record.incident_floor := p0_a199;
1560 ddp_sr_record.incident_suite := p0_a200;
1561 ddp_sr_record.incident_postal_plus4_code := p0_a201;
1562 ddp_sr_record.incident_position := p0_a202;
1563 ddp_sr_record.incident_location_directions := p0_a203;
1564 ddp_sr_record.incident_location_description := p0_a204;
1565 ddp_sr_record.install_site_id := p0_a205;
1566 ddp_sr_record.item_serial_number := p0_a206;
1567 ddp_sr_record.owning_department_id := p0_a207;
1568 ddp_sr_record.incident_location_type := p0_a208;
1569 ddp_sr_record.coverage_type := p0_a209;
1570 ddp_sr_record.maint_organization_id := p0_a210;
1571 ddp_sr_record.creation_date := rosetta_g_miss_date_in_map(p0_a211);
1572 ddp_sr_record.created_by := p0_a212;
1573 ddp_sr_record.instrument_payment_use_id := p0_a213;
1574 ddp_sr_record.project_id := p0_a214;
1575 ddp_sr_record.project_task_id := p0_a215;
1576 ddp_sr_record.expenditure_org_id := p0_a216;
1577 ddp_sr_record.sla_date_1 := rosetta_g_miss_date_in_map(p0_a217);
1578 ddp_sr_record.sla_date_2 := rosetta_g_miss_date_in_map(p0_a218);
1579 ddp_sr_record.sla_date_3 := rosetta_g_miss_date_in_map(p0_a219);
1580 ddp_sr_record.sla_date_4 := rosetta_g_miss_date_in_map(p0_a220);
1581 ddp_sr_record.sla_date_5 := rosetta_g_miss_date_in_map(p0_a221);
1582 ddp_sr_record.sla_date_6 := rosetta_g_miss_date_in_map(p0_a222);
1583 ddp_sr_record.sla_duration_1 := p0_a223;
1584 ddp_sr_record.sla_duration_2 := p0_a224;
1585 ddp_sr_record.price_list_header_id := p0_a225;
1586
1587 -- here's the delegated call to the old PL/SQL routine
1588 cs_servicerequest_pub.initialize_rec(ddp_sr_record);
1589
1590 -- copy data back from the local variables to OUT or IN-OUT args, if any
1591 p0_a0 := ddp_sr_record.request_date;
1592 p0_a1 := ddp_sr_record.type_id;
1593 p0_a2 := ddp_sr_record.type_name;
1594 p0_a3 := ddp_sr_record.status_id;
1595 p0_a4 := ddp_sr_record.status_name;
1596 p0_a5 := ddp_sr_record.severity_id;
1597 p0_a6 := ddp_sr_record.severity_name;
1598 p0_a7 := ddp_sr_record.urgency_id;
1599 p0_a8 := ddp_sr_record.urgency_name;
1600 p0_a9 := ddp_sr_record.closed_date;
1601 p0_a10 := ddp_sr_record.owner_id;
1602 p0_a11 := ddp_sr_record.owner_group_id;
1603 p0_a12 := ddp_sr_record.publish_flag;
1604 p0_a13 := ddp_sr_record.summary;
1605 p0_a14 := ddp_sr_record.caller_type;
1606 p0_a15 := ddp_sr_record.customer_id;
1607 p0_a16 := ddp_sr_record.customer_number;
1608 p0_a17 := ddp_sr_record.employee_id;
1609 p0_a18 := ddp_sr_record.employee_number;
1610 p0_a19 := ddp_sr_record.verify_cp_flag;
1611 p0_a20 := ddp_sr_record.customer_product_id;
1612 p0_a21 := ddp_sr_record.platform_id;
1613 p0_a22 := ddp_sr_record.platform_version;
1614 p0_a23 := ddp_sr_record.db_version;
1615 p0_a24 := ddp_sr_record.platform_version_id;
1616 p0_a25 := ddp_sr_record.cp_component_id;
1617 p0_a26 := ddp_sr_record.cp_component_version_id;
1618 p0_a27 := ddp_sr_record.cp_subcomponent_id;
1619 p0_a28 := ddp_sr_record.cp_subcomponent_version_id;
1620 p0_a29 := ddp_sr_record.language_id;
1621 p0_a30 := ddp_sr_record.language;
1622 p0_a31 := ddp_sr_record.cp_ref_number;
1623 p0_a32 := ddp_sr_record.inventory_item_id;
1624 p0_a33 := ddp_sr_record.inventory_item_conc_segs;
1625 p0_a34 := ddp_sr_record.inventory_item_segment1;
1626 p0_a35 := ddp_sr_record.inventory_item_segment2;
1627 p0_a36 := ddp_sr_record.inventory_item_segment3;
1628 p0_a37 := ddp_sr_record.inventory_item_segment4;
1629 p0_a38 := ddp_sr_record.inventory_item_segment5;
1630 p0_a39 := ddp_sr_record.inventory_item_segment6;
1631 p0_a40 := ddp_sr_record.inventory_item_segment7;
1632 p0_a41 := ddp_sr_record.inventory_item_segment8;
1633 p0_a42 := ddp_sr_record.inventory_item_segment9;
1634 p0_a43 := ddp_sr_record.inventory_item_segment10;
1635 p0_a44 := ddp_sr_record.inventory_item_segment11;
1636 p0_a45 := ddp_sr_record.inventory_item_segment12;
1637 p0_a46 := ddp_sr_record.inventory_item_segment13;
1638 p0_a47 := ddp_sr_record.inventory_item_segment14;
1639 p0_a48 := ddp_sr_record.inventory_item_segment15;
1640 p0_a49 := ddp_sr_record.inventory_item_segment16;
1641 p0_a50 := ddp_sr_record.inventory_item_segment17;
1642 p0_a51 := ddp_sr_record.inventory_item_segment18;
1643 p0_a52 := ddp_sr_record.inventory_item_segment19;
1644 p0_a53 := ddp_sr_record.inventory_item_segment20;
1645 p0_a54 := ddp_sr_record.inventory_item_vals_or_ids;
1646 p0_a55 := ddp_sr_record.inventory_org_id;
1647 p0_a56 := ddp_sr_record.current_serial_number;
1648 p0_a57 := ddp_sr_record.original_order_number;
1649 p0_a58 := ddp_sr_record.purchase_order_num;
1650 p0_a59 := ddp_sr_record.problem_code;
1651 p0_a60 := ddp_sr_record.exp_resolution_date;
1652 p0_a61 := ddp_sr_record.install_site_use_id;
1653 p0_a62 := ddp_sr_record.request_attribute_1;
1654 p0_a63 := ddp_sr_record.request_attribute_2;
1655 p0_a64 := ddp_sr_record.request_attribute_3;
1656 p0_a65 := ddp_sr_record.request_attribute_4;
1657 p0_a66 := ddp_sr_record.request_attribute_5;
1658 p0_a67 := ddp_sr_record.request_attribute_6;
1659 p0_a68 := ddp_sr_record.request_attribute_7;
1660 p0_a69 := ddp_sr_record.request_attribute_8;
1661 p0_a70 := ddp_sr_record.request_attribute_9;
1662 p0_a71 := ddp_sr_record.request_attribute_10;
1663 p0_a72 := ddp_sr_record.request_attribute_11;
1664 p0_a73 := ddp_sr_record.request_attribute_12;
1665 p0_a74 := ddp_sr_record.request_attribute_13;
1666 p0_a75 := ddp_sr_record.request_attribute_14;
1667 p0_a76 := ddp_sr_record.request_attribute_15;
1668 p0_a77 := ddp_sr_record.request_context;
1669 p0_a78 := ddp_sr_record.external_attribute_1;
1670 p0_a79 := ddp_sr_record.external_attribute_2;
1671 p0_a80 := ddp_sr_record.external_attribute_3;
1672 p0_a81 := ddp_sr_record.external_attribute_4;
1673 p0_a82 := ddp_sr_record.external_attribute_5;
1674 p0_a83 := ddp_sr_record.external_attribute_6;
1675 p0_a84 := ddp_sr_record.external_attribute_7;
1676 p0_a85 := ddp_sr_record.external_attribute_8;
1677 p0_a86 := ddp_sr_record.external_attribute_9;
1678 p0_a87 := ddp_sr_record.external_attribute_10;
1679 p0_a88 := ddp_sr_record.external_attribute_11;
1680 p0_a89 := ddp_sr_record.external_attribute_12;
1681 p0_a90 := ddp_sr_record.external_attribute_13;
1682 p0_a91 := ddp_sr_record.external_attribute_14;
1683 p0_a92 := ddp_sr_record.external_attribute_15;
1684 p0_a93 := ddp_sr_record.external_context;
1685 p0_a94 := ddp_sr_record.bill_to_site_use_id;
1686 p0_a95 := ddp_sr_record.bill_to_contact_id;
1687 p0_a96 := ddp_sr_record.ship_to_site_use_id;
1688 p0_a97 := ddp_sr_record.ship_to_contact_id;
1689 p0_a98 := ddp_sr_record.resolution_code;
1690 p0_a99 := ddp_sr_record.act_resolution_date;
1691 p0_a100 := ddp_sr_record.public_comment_flag;
1692 p0_a101 := ddp_sr_record.parent_interaction_id;
1693 p0_a102 := ddp_sr_record.contract_service_id;
1694 p0_a103 := ddp_sr_record.contract_service_number;
1695 p0_a104 := ddp_sr_record.contract_id;
1696 p0_a105 := ddp_sr_record.project_number;
1697 p0_a106 := ddp_sr_record.qa_collection_plan_id;
1698 p0_a107 := ddp_sr_record.account_id;
1699 p0_a108 := ddp_sr_record.resource_type;
1700 p0_a109 := ddp_sr_record.resource_subtype_id;
1701 p0_a110 := ddp_sr_record.cust_po_number;
1702 p0_a111 := ddp_sr_record.cust_ticket_number;
1703 p0_a112 := ddp_sr_record.sr_creation_channel;
1704 p0_a113 := ddp_sr_record.obligation_date;
1705 p0_a114 := ddp_sr_record.time_zone_id;
1706 p0_a115 := ddp_sr_record.time_difference;
1707 p0_a116 := ddp_sr_record.site_id;
1708 p0_a117 := ddp_sr_record.customer_site_id;
1709 p0_a118 := ddp_sr_record.territory_id;
1710 p0_a119 := ddp_sr_record.initialize_flag;
1711 p0_a120 := ddp_sr_record.cp_revision_id;
1712 p0_a121 := ddp_sr_record.inv_item_revision;
1713 p0_a122 := ddp_sr_record.inv_component_id;
1714 p0_a123 := ddp_sr_record.inv_component_version;
1715 p0_a124 := ddp_sr_record.inv_subcomponent_id;
1716 p0_a125 := ddp_sr_record.inv_subcomponent_version;
1717 p0_a126 := ddp_sr_record.tier;
1718 p0_a127 := ddp_sr_record.tier_version;
1719 p0_a128 := ddp_sr_record.operating_system;
1720 p0_a129 := ddp_sr_record.operating_system_version;
1721 p0_a130 := ddp_sr_record.database;
1722 p0_a131 := ddp_sr_record.cust_pref_lang_id;
1723 p0_a132 := ddp_sr_record.category_id;
1724 p0_a133 := ddp_sr_record.group_type;
1725 p0_a134 := ddp_sr_record.group_territory_id;
1726 p0_a135 := ddp_sr_record.inv_platform_org_id;
1727 p0_a136 := ddp_sr_record.component_version;
1728 p0_a137 := ddp_sr_record.subcomponent_version;
1729 p0_a138 := ddp_sr_record.product_revision;
1730 p0_a139 := ddp_sr_record.comm_pref_code;
1731 p0_a140 := ddp_sr_record.cust_pref_lang_code;
1732 p0_a141 := ddp_sr_record.last_update_channel;
1733 p0_a142 := ddp_sr_record.category_set_id;
1734 p0_a143 := ddp_sr_record.external_reference;
1735 p0_a144 := ddp_sr_record.system_id;
1736 p0_a145 := ddp_sr_record.error_code;
1737 p0_a146 := ddp_sr_record.incident_occurred_date;
1738 p0_a147 := ddp_sr_record.incident_resolved_date;
1739 p0_a148 := ddp_sr_record.inc_responded_by_date;
1740 p0_a149 := ddp_sr_record.resolution_summary;
1741 p0_a150 := ddp_sr_record.incident_location_id;
1742 p0_a151 := ddp_sr_record.incident_address;
1743 p0_a152 := ddp_sr_record.incident_city;
1744 p0_a153 := ddp_sr_record.incident_state;
1745 p0_a154 := ddp_sr_record.incident_country;
1746 p0_a155 := ddp_sr_record.incident_province;
1747 p0_a156 := ddp_sr_record.incident_postal_code;
1748 p0_a157 := ddp_sr_record.incident_county;
1749 p0_a158 := ddp_sr_record.site_number;
1750 p0_a159 := ddp_sr_record.site_name;
1751 p0_a160 := ddp_sr_record.addressee;
1752 p0_a161 := ddp_sr_record.owner;
1753 p0_a162 := ddp_sr_record.group_owner;
1754 p0_a163 := ddp_sr_record.cc_number;
1755 p0_a164 := ddp_sr_record.cc_expiration_date;
1756 p0_a165 := ddp_sr_record.cc_type_code;
1757 p0_a166 := ddp_sr_record.cc_first_name;
1758 p0_a167 := ddp_sr_record.cc_last_name;
1759 p0_a168 := ddp_sr_record.cc_middle_name;
1760 p0_a169 := ddp_sr_record.cc_id;
1761 p0_a170 := ddp_sr_record.bill_to_account_id;
1762 p0_a171 := ddp_sr_record.ship_to_account_id;
1763 p0_a172 := ddp_sr_record.customer_phone_id;
1764 p0_a173 := ddp_sr_record.customer_email_id;
1765 p0_a174 := ddp_sr_record.creation_program_code;
1766 p0_a175 := ddp_sr_record.last_update_program_code;
1767 p0_a176 := ddp_sr_record.bill_to_party_id;
1768 p0_a177 := ddp_sr_record.ship_to_party_id;
1769 p0_a178 := ddp_sr_record.program_id;
1770 p0_a179 := ddp_sr_record.program_application_id;
1771 p0_a180 := ddp_sr_record.conc_request_id;
1772 p0_a181 := ddp_sr_record.program_login_id;
1773 p0_a182 := ddp_sr_record.bill_to_site_id;
1774 p0_a183 := ddp_sr_record.ship_to_site_id;
1775 p0_a184 := ddp_sr_record.incident_point_of_interest;
1776 p0_a185 := ddp_sr_record.incident_cross_street;
1777 p0_a186 := ddp_sr_record.incident_direction_qualifier;
1778 p0_a187 := ddp_sr_record.incident_distance_qualifier;
1779 p0_a188 := ddp_sr_record.incident_distance_qual_uom;
1780 p0_a189 := ddp_sr_record.incident_address2;
1781 p0_a190 := ddp_sr_record.incident_address3;
1782 p0_a191 := ddp_sr_record.incident_address4;
1783 p0_a192 := ddp_sr_record.incident_address_style;
1784 p0_a193 := ddp_sr_record.incident_addr_lines_phonetic;
1785 p0_a194 := ddp_sr_record.incident_po_box_number;
1786 p0_a195 := ddp_sr_record.incident_house_number;
1787 p0_a196 := ddp_sr_record.incident_street_suffix;
1788 p0_a197 := ddp_sr_record.incident_street;
1789 p0_a198 := ddp_sr_record.incident_street_number;
1790 p0_a199 := ddp_sr_record.incident_floor;
1791 p0_a200 := ddp_sr_record.incident_suite;
1792 p0_a201 := ddp_sr_record.incident_postal_plus4_code;
1793 p0_a202 := ddp_sr_record.incident_position;
1794 p0_a203 := ddp_sr_record.incident_location_directions;
1795 p0_a204 := ddp_sr_record.incident_location_description;
1796 p0_a205 := ddp_sr_record.install_site_id;
1797 p0_a206 := ddp_sr_record.item_serial_number;
1798 p0_a207 := ddp_sr_record.owning_department_id;
1799 p0_a208 := ddp_sr_record.incident_location_type;
1800 p0_a209 := ddp_sr_record.coverage_type;
1801 p0_a210 := ddp_sr_record.maint_organization_id;
1802 p0_a211 := ddp_sr_record.creation_date;
1803 p0_a212 := ddp_sr_record.created_by;
1804 p0_a213 := ddp_sr_record.instrument_payment_use_id;
1805 p0_a214 := ddp_sr_record.project_id;
1806 p0_a215 := ddp_sr_record.project_task_id;
1807 p0_a216 := ddp_sr_record.expenditure_org_id;
1808 p0_a217 := ddp_sr_record.sla_date_1;
1809 p0_a218 := ddp_sr_record.sla_date_2;
1810 p0_a219 := ddp_sr_record.sla_date_3;
1811 p0_a220 := ddp_sr_record.sla_date_4;
1812 p0_a221 := ddp_sr_record.sla_date_5;
1813 p0_a222 := ddp_sr_record.sla_date_6;
1814 p0_a223 := ddp_sr_record.sla_duration_1;
1815 p0_a224 := ddp_sr_record.sla_duration_2;
1816 p0_a225 := ddp_sr_record.price_list_header_id;
1817 end;
1818
1819 procedure create_servicerequest(p_api_version NUMBER
1820 , p_init_msg_list VARCHAR2
1821 , p_commit VARCHAR2
1822 , x_return_status out nocopy VARCHAR2
1823 , x_msg_count out nocopy NUMBER
1824 , x_msg_data out nocopy VARCHAR2
1825 , p_resp_appl_id NUMBER
1826 , p_resp_id NUMBER
1827 , p_user_id NUMBER
1828 , p_login_id NUMBER
1829 , p_org_id NUMBER
1830 , p_request_id NUMBER
1831 , p_request_number VARCHAR2
1832 , p13_a0 DATE
1833 , p13_a1 NUMBER
1834 , p13_a2 VARCHAR2
1835 , p13_a3 NUMBER
1836 , p13_a4 VARCHAR2
1837 , p13_a5 NUMBER
1838 , p13_a6 VARCHAR2
1839 , p13_a7 NUMBER
1840 , p13_a8 VARCHAR2
1841 , p13_a9 DATE
1842 , p13_a10 NUMBER
1843 , p13_a11 NUMBER
1844 , p13_a12 VARCHAR2
1845 , p13_a13 VARCHAR2
1846 , p13_a14 VARCHAR2
1847 , p13_a15 NUMBER
1848 , p13_a16 VARCHAR2
1849 , p13_a17 NUMBER
1850 , p13_a18 VARCHAR2
1851 , p13_a19 VARCHAR2
1852 , p13_a20 NUMBER
1853 , p13_a21 NUMBER
1854 , p13_a22 VARCHAR2
1855 , p13_a23 VARCHAR2
1856 , p13_a24 NUMBER
1857 , p13_a25 NUMBER
1858 , p13_a26 NUMBER
1859 , p13_a27 NUMBER
1860 , p13_a28 NUMBER
1861 , p13_a29 NUMBER
1862 , p13_a30 VARCHAR2
1863 , p13_a31 NUMBER
1864 , p13_a32 NUMBER
1865 , p13_a33 VARCHAR2
1866 , p13_a34 VARCHAR2
1867 , p13_a35 VARCHAR2
1868 , p13_a36 VARCHAR2
1869 , p13_a37 VARCHAR2
1870 , p13_a38 VARCHAR2
1871 , p13_a39 VARCHAR2
1872 , p13_a40 VARCHAR2
1873 , p13_a41 VARCHAR2
1874 , p13_a42 VARCHAR2
1875 , p13_a43 VARCHAR2
1876 , p13_a44 VARCHAR2
1877 , p13_a45 VARCHAR2
1878 , p13_a46 VARCHAR2
1879 , p13_a47 VARCHAR2
1880 , p13_a48 VARCHAR2
1881 , p13_a49 VARCHAR2
1882 , p13_a50 VARCHAR2
1883 , p13_a51 VARCHAR2
1884 , p13_a52 VARCHAR2
1885 , p13_a53 VARCHAR2
1886 , p13_a54 VARCHAR2
1887 , p13_a55 NUMBER
1888 , p13_a56 VARCHAR2
1889 , p13_a57 NUMBER
1890 , p13_a58 VARCHAR2
1891 , p13_a59 VARCHAR2
1892 , p13_a60 DATE
1893 , p13_a61 NUMBER
1894 , p13_a62 VARCHAR2
1895 , p13_a63 VARCHAR2
1896 , p13_a64 VARCHAR2
1897 , p13_a65 VARCHAR2
1898 , p13_a66 VARCHAR2
1899 , p13_a67 VARCHAR2
1900 , p13_a68 VARCHAR2
1901 , p13_a69 VARCHAR2
1902 , p13_a70 VARCHAR2
1903 , p13_a71 VARCHAR2
1904 , p13_a72 VARCHAR2
1905 , p13_a73 VARCHAR2
1906 , p13_a74 VARCHAR2
1907 , p13_a75 VARCHAR2
1908 , p13_a76 VARCHAR2
1909 , p13_a77 VARCHAR2
1910 , p13_a78 VARCHAR2
1911 , p13_a79 VARCHAR2
1912 , p13_a80 VARCHAR2
1913 , p13_a81 VARCHAR2
1914 , p13_a82 VARCHAR2
1915 , p13_a83 VARCHAR2
1916 , p13_a84 VARCHAR2
1917 , p13_a85 VARCHAR2
1918 , p13_a86 VARCHAR2
1919 , p13_a87 VARCHAR2
1920 , p13_a88 VARCHAR2
1921 , p13_a89 VARCHAR2
1922 , p13_a90 VARCHAR2
1923 , p13_a91 VARCHAR2
1924 , p13_a92 VARCHAR2
1925 , p13_a93 VARCHAR2
1926 , p13_a94 NUMBER
1927 , p13_a95 NUMBER
1928 , p13_a96 NUMBER
1929 , p13_a97 NUMBER
1930 , p13_a98 VARCHAR2
1931 , p13_a99 DATE
1932 , p13_a100 VARCHAR2
1933 , p13_a101 NUMBER
1934 , p13_a102 NUMBER
1935 , p13_a103 VARCHAR2
1936 , p13_a104 NUMBER
1937 , p13_a105 VARCHAR2
1938 , p13_a106 NUMBER
1939 , p13_a107 NUMBER
1940 , p13_a108 VARCHAR2
1941 , p13_a109 NUMBER
1942 , p13_a110 VARCHAR2
1943 , p13_a111 VARCHAR2
1944 , p13_a112 VARCHAR2
1945 , p13_a113 DATE
1946 , p13_a114 NUMBER
1947 , p13_a115 NUMBER
1948 , p13_a116 NUMBER
1949 , p13_a117 NUMBER
1950 , p13_a118 NUMBER
1951 , p13_a119 VARCHAR2
1952 , p13_a120 NUMBER
1953 , p13_a121 VARCHAR2
1954 , p13_a122 NUMBER
1955 , p13_a123 VARCHAR2
1956 , p13_a124 NUMBER
1957 , p13_a125 VARCHAR2
1958 , p13_a126 VARCHAR2
1959 , p13_a127 VARCHAR2
1960 , p13_a128 VARCHAR2
1961 , p13_a129 VARCHAR2
1962 , p13_a130 VARCHAR2
1963 , p13_a131 NUMBER
1964 , p13_a132 NUMBER
1965 , p13_a133 VARCHAR2
1966 , p13_a134 NUMBER
1967 , p13_a135 NUMBER
1968 , p13_a136 VARCHAR2
1969 , p13_a137 VARCHAR2
1970 , p13_a138 VARCHAR2
1971 , p13_a139 VARCHAR2
1972 , p13_a140 VARCHAR2
1973 , p13_a141 VARCHAR2
1974 , p13_a142 NUMBER
1975 , p13_a143 VARCHAR2
1976 , p13_a144 NUMBER
1977 , p13_a145 VARCHAR2
1978 , p13_a146 DATE
1979 , p13_a147 DATE
1980 , p13_a148 DATE
1981 , p13_a149 VARCHAR2
1982 , p13_a150 NUMBER
1983 , p13_a151 VARCHAR2
1984 , p13_a152 VARCHAR2
1985 , p13_a153 VARCHAR2
1986 , p13_a154 VARCHAR2
1987 , p13_a155 VARCHAR2
1988 , p13_a156 VARCHAR2
1989 , p13_a157 VARCHAR2
1990 , p13_a158 VARCHAR2
1991 , p13_a159 VARCHAR2
1992 , p13_a160 VARCHAR2
1993 , p13_a161 VARCHAR2
1994 , p13_a162 VARCHAR2
1995 , p13_a163 VARCHAR2
1996 , p13_a164 DATE
1997 , p13_a165 VARCHAR
1998 , p13_a166 VARCHAR
1999 , p13_a167 VARCHAR
2000 , p13_a168 VARCHAR
2001 , p13_a169 NUMBER
2002 , p13_a170 NUMBER
2003 , p13_a171 NUMBER
2004 , p13_a172 NUMBER
2005 , p13_a173 NUMBER
2006 , p13_a174 VARCHAR2
2007 , p13_a175 VARCHAR2
2008 , p13_a176 NUMBER
2009 , p13_a177 NUMBER
2010 , p13_a178 NUMBER
2011 , p13_a179 NUMBER
2012 , p13_a180 NUMBER
2013 , p13_a181 NUMBER
2014 , p13_a182 NUMBER
2015 , p13_a183 NUMBER
2016 , p13_a184 VARCHAR2
2017 , p13_a185 VARCHAR2
2018 , p13_a186 VARCHAR2
2019 , p13_a187 VARCHAR2
2020 , p13_a188 VARCHAR2
2021 , p13_a189 VARCHAR2
2022 , p13_a190 VARCHAR2
2023 , p13_a191 VARCHAR2
2024 , p13_a192 VARCHAR2
2025 , p13_a193 VARCHAR2
2026 , p13_a194 VARCHAR2
2027 , p13_a195 VARCHAR2
2028 , p13_a196 VARCHAR2
2029 , p13_a197 VARCHAR2
2030 , p13_a198 VARCHAR2
2031 , p13_a199 VARCHAR2
2032 , p13_a200 VARCHAR2
2033 , p13_a201 VARCHAR2
2034 , p13_a202 VARCHAR2
2035 , p13_a203 VARCHAR2
2036 , p13_a204 VARCHAR2
2037 , p13_a205 NUMBER
2038 , p13_a206 VARCHAR2
2039 , p13_a207 NUMBER
2040 , p13_a208 VARCHAR2
2041 , p13_a209 VARCHAR2
2042 , p13_a210 NUMBER
2043 , p13_a211 DATE
2044 , p13_a212 NUMBER
2045 , p13_a213 NUMBER
2046 , p13_a214 NUMBER
2047 , p13_a215 NUMBER
2048 , p13_a216 NUMBER
2049 , p13_a217 DATE
2050 , p13_a218 DATE
2051 , p13_a219 DATE
2052 , p13_a220 DATE
2053 , p13_a221 DATE
2054 , p13_a222 DATE
2055 , p13_a223 NUMBER
2056 , p13_a224 NUMBER
2057 , p13_a225 NUMBER
2058 , p14_a0 JTF_VARCHAR2_TABLE_2000
2059 , p14_a1 JTF_VARCHAR2_TABLE_32767
2060 , p14_a2 JTF_VARCHAR2_TABLE_300
2061 , p14_a3 JTF_VARCHAR2_TABLE_100
2062 , p14_a4 JTF_NUMBER_TABLE
2063 , p14_a5 JTF_VARCHAR2_TABLE_100
2064 , p14_a6 JTF_NUMBER_TABLE
2065 , p14_a7 JTF_VARCHAR2_TABLE_100
2066 , p14_a8 JTF_NUMBER_TABLE
2067 , p15_a0 JTF_NUMBER_TABLE
2068 , p15_a1 JTF_NUMBER_TABLE
2069 , p15_a2 JTF_NUMBER_TABLE
2070 , p15_a3 JTF_VARCHAR2_TABLE_100
2071 , p15_a4 JTF_VARCHAR2_TABLE_100
2072 , p15_a5 JTF_VARCHAR2_TABLE_100
2073 , p15_a6 JTF_VARCHAR2_TABLE_100
2074 , p15_a7 JTF_DATE_TABLE
2075 , p15_a8 JTF_DATE_TABLE
2076 , p_auto_assign VARCHAR2
2077 , p_auto_generate_tasks VARCHAR2
2078 , p18_a0 out nocopy NUMBER
2079 , p18_a1 out nocopy VARCHAR2
2080 , p18_a2 out nocopy NUMBER
2081 , p18_a3 out nocopy NUMBER
2082 , p18_a4 out nocopy NUMBER
2083 , p18_a5 out nocopy NUMBER
2084 , p18_a6 out nocopy VARCHAR2
2085 , p18_a7 out nocopy VARCHAR2
2086 , p18_a8 out nocopy NUMBER
2087 , p18_a9 out nocopy NUMBER
2088 , p18_a10 out nocopy NUMBER
2089 , p18_a11 out nocopy DATE
2090 , p18_a12 out nocopy DATE
2091 , p18_a13 out nocopy DATE
2092 , p18_a14 out nocopy DATE
2093 , p18_a15 out nocopy NUMBER
2094 , p_default_contract_sla_ind VARCHAR2
2095 , p_default_coverage_template_id NUMBER
2096 )
2097
2098 as
2099 ddp_service_request_rec cs_servicerequest_pub.service_request_rec_type;
2100 ddp_notes cs_servicerequest_pub.notes_table;
2101 ddp_contacts cs_servicerequest_pub.contacts_table;
2102 ddx_sr_create_out_rec cs_servicerequest_pub.sr_create_out_rec_type;
2103 ddindx binary_integer; indx binary_integer;
2104 begin
2105
2106 -- copy data to the local IN or IN-OUT args, if any
2107
2108
2109
2110
2111
2112
2113
2114
2115
2116
2117
2118
2119
2120 ddp_service_request_rec.request_date := rosetta_g_miss_date_in_map(p13_a0);
2121 ddp_service_request_rec.type_id := p13_a1;
2122 ddp_service_request_rec.type_name := p13_a2;
2123 ddp_service_request_rec.status_id := p13_a3;
2124 ddp_service_request_rec.status_name := p13_a4;
2125 ddp_service_request_rec.severity_id := p13_a5;
2126 ddp_service_request_rec.severity_name := p13_a6;
2127 ddp_service_request_rec.urgency_id := p13_a7;
2128 ddp_service_request_rec.urgency_name := p13_a8;
2129 ddp_service_request_rec.closed_date := rosetta_g_miss_date_in_map(p13_a9);
2130 ddp_service_request_rec.owner_id := p13_a10;
2131 ddp_service_request_rec.owner_group_id := p13_a11;
2132 ddp_service_request_rec.publish_flag := p13_a12;
2133 ddp_service_request_rec.summary := p13_a13;
2134 ddp_service_request_rec.caller_type := p13_a14;
2135 ddp_service_request_rec.customer_id := p13_a15;
2136 ddp_service_request_rec.customer_number := p13_a16;
2137 ddp_service_request_rec.employee_id := p13_a17;
2138 ddp_service_request_rec.employee_number := p13_a18;
2139 ddp_service_request_rec.verify_cp_flag := p13_a19;
2140 ddp_service_request_rec.customer_product_id := p13_a20;
2141 ddp_service_request_rec.platform_id := p13_a21;
2142 ddp_service_request_rec.platform_version := p13_a22;
2143 ddp_service_request_rec.db_version := p13_a23;
2144 ddp_service_request_rec.platform_version_id := p13_a24;
2145 ddp_service_request_rec.cp_component_id := p13_a25;
2146 ddp_service_request_rec.cp_component_version_id := p13_a26;
2147 ddp_service_request_rec.cp_subcomponent_id := p13_a27;
2148 ddp_service_request_rec.cp_subcomponent_version_id := p13_a28;
2149 ddp_service_request_rec.language_id := p13_a29;
2150 ddp_service_request_rec.language := p13_a30;
2151 ddp_service_request_rec.cp_ref_number := p13_a31;
2152 ddp_service_request_rec.inventory_item_id := p13_a32;
2153 ddp_service_request_rec.inventory_item_conc_segs := p13_a33;
2154 ddp_service_request_rec.inventory_item_segment1 := p13_a34;
2155 ddp_service_request_rec.inventory_item_segment2 := p13_a35;
2156 ddp_service_request_rec.inventory_item_segment3 := p13_a36;
2157 ddp_service_request_rec.inventory_item_segment4 := p13_a37;
2158 ddp_service_request_rec.inventory_item_segment5 := p13_a38;
2159 ddp_service_request_rec.inventory_item_segment6 := p13_a39;
2160 ddp_service_request_rec.inventory_item_segment7 := p13_a40;
2161 ddp_service_request_rec.inventory_item_segment8 := p13_a41;
2162 ddp_service_request_rec.inventory_item_segment9 := p13_a42;
2163 ddp_service_request_rec.inventory_item_segment10 := p13_a43;
2164 ddp_service_request_rec.inventory_item_segment11 := p13_a44;
2165 ddp_service_request_rec.inventory_item_segment12 := p13_a45;
2166 ddp_service_request_rec.inventory_item_segment13 := p13_a46;
2167 ddp_service_request_rec.inventory_item_segment14 := p13_a47;
2168 ddp_service_request_rec.inventory_item_segment15 := p13_a48;
2169 ddp_service_request_rec.inventory_item_segment16 := p13_a49;
2170 ddp_service_request_rec.inventory_item_segment17 := p13_a50;
2171 ddp_service_request_rec.inventory_item_segment18 := p13_a51;
2172 ddp_service_request_rec.inventory_item_segment19 := p13_a52;
2173 ddp_service_request_rec.inventory_item_segment20 := p13_a53;
2174 ddp_service_request_rec.inventory_item_vals_or_ids := p13_a54;
2175 ddp_service_request_rec.inventory_org_id := p13_a55;
2176 ddp_service_request_rec.current_serial_number := p13_a56;
2177 ddp_service_request_rec.original_order_number := p13_a57;
2178 ddp_service_request_rec.purchase_order_num := p13_a58;
2179 ddp_service_request_rec.problem_code := p13_a59;
2180 ddp_service_request_rec.exp_resolution_date := rosetta_g_miss_date_in_map(p13_a60);
2181 ddp_service_request_rec.install_site_use_id := p13_a61;
2182 ddp_service_request_rec.request_attribute_1 := p13_a62;
2183 ddp_service_request_rec.request_attribute_2 := p13_a63;
2184 ddp_service_request_rec.request_attribute_3 := p13_a64;
2185 ddp_service_request_rec.request_attribute_4 := p13_a65;
2186 ddp_service_request_rec.request_attribute_5 := p13_a66;
2187 ddp_service_request_rec.request_attribute_6 := p13_a67;
2188 ddp_service_request_rec.request_attribute_7 := p13_a68;
2189 ddp_service_request_rec.request_attribute_8 := p13_a69;
2190 ddp_service_request_rec.request_attribute_9 := p13_a70;
2191 ddp_service_request_rec.request_attribute_10 := p13_a71;
2192 ddp_service_request_rec.request_attribute_11 := p13_a72;
2193 ddp_service_request_rec.request_attribute_12 := p13_a73;
2194 ddp_service_request_rec.request_attribute_13 := p13_a74;
2195 ddp_service_request_rec.request_attribute_14 := p13_a75;
2196 ddp_service_request_rec.request_attribute_15 := p13_a76;
2197 ddp_service_request_rec.request_context := p13_a77;
2198 ddp_service_request_rec.external_attribute_1 := p13_a78;
2199 ddp_service_request_rec.external_attribute_2 := p13_a79;
2200 ddp_service_request_rec.external_attribute_3 := p13_a80;
2201 ddp_service_request_rec.external_attribute_4 := p13_a81;
2202 ddp_service_request_rec.external_attribute_5 := p13_a82;
2203 ddp_service_request_rec.external_attribute_6 := p13_a83;
2204 ddp_service_request_rec.external_attribute_7 := p13_a84;
2205 ddp_service_request_rec.external_attribute_8 := p13_a85;
2206 ddp_service_request_rec.external_attribute_9 := p13_a86;
2207 ddp_service_request_rec.external_attribute_10 := p13_a87;
2208 ddp_service_request_rec.external_attribute_11 := p13_a88;
2209 ddp_service_request_rec.external_attribute_12 := p13_a89;
2210 ddp_service_request_rec.external_attribute_13 := p13_a90;
2211 ddp_service_request_rec.external_attribute_14 := p13_a91;
2212 ddp_service_request_rec.external_attribute_15 := p13_a92;
2213 ddp_service_request_rec.external_context := p13_a93;
2214 ddp_service_request_rec.bill_to_site_use_id := p13_a94;
2215 ddp_service_request_rec.bill_to_contact_id := p13_a95;
2216 ddp_service_request_rec.ship_to_site_use_id := p13_a96;
2217 ddp_service_request_rec.ship_to_contact_id := p13_a97;
2218 ddp_service_request_rec.resolution_code := p13_a98;
2219 ddp_service_request_rec.act_resolution_date := rosetta_g_miss_date_in_map(p13_a99);
2220 ddp_service_request_rec.public_comment_flag := p13_a100;
2221 ddp_service_request_rec.parent_interaction_id := p13_a101;
2222 ddp_service_request_rec.contract_service_id := p13_a102;
2223 ddp_service_request_rec.contract_service_number := p13_a103;
2224 ddp_service_request_rec.contract_id := p13_a104;
2225 ddp_service_request_rec.project_number := p13_a105;
2226 ddp_service_request_rec.qa_collection_plan_id := p13_a106;
2227 ddp_service_request_rec.account_id := p13_a107;
2228 ddp_service_request_rec.resource_type := p13_a108;
2229 ddp_service_request_rec.resource_subtype_id := p13_a109;
2230 ddp_service_request_rec.cust_po_number := p13_a110;
2231 ddp_service_request_rec.cust_ticket_number := p13_a111;
2232 ddp_service_request_rec.sr_creation_channel := p13_a112;
2233 ddp_service_request_rec.obligation_date := rosetta_g_miss_date_in_map(p13_a113);
2234 ddp_service_request_rec.time_zone_id := p13_a114;
2235 ddp_service_request_rec.time_difference := p13_a115;
2236 ddp_service_request_rec.site_id := p13_a116;
2237 ddp_service_request_rec.customer_site_id := p13_a117;
2238 ddp_service_request_rec.territory_id := p13_a118;
2239 ddp_service_request_rec.initialize_flag := p13_a119;
2240 ddp_service_request_rec.cp_revision_id := p13_a120;
2241 ddp_service_request_rec.inv_item_revision := p13_a121;
2242 ddp_service_request_rec.inv_component_id := p13_a122;
2243 ddp_service_request_rec.inv_component_version := p13_a123;
2244 ddp_service_request_rec.inv_subcomponent_id := p13_a124;
2245 ddp_service_request_rec.inv_subcomponent_version := p13_a125;
2246 ddp_service_request_rec.tier := p13_a126;
2247 ddp_service_request_rec.tier_version := p13_a127;
2248 ddp_service_request_rec.operating_system := p13_a128;
2249 ddp_service_request_rec.operating_system_version := p13_a129;
2250 ddp_service_request_rec.database := p13_a130;
2251 ddp_service_request_rec.cust_pref_lang_id := p13_a131;
2252 ddp_service_request_rec.category_id := p13_a132;
2253 ddp_service_request_rec.group_type := p13_a133;
2254 ddp_service_request_rec.group_territory_id := p13_a134;
2255 ddp_service_request_rec.inv_platform_org_id := p13_a135;
2256 ddp_service_request_rec.component_version := p13_a136;
2257 ddp_service_request_rec.subcomponent_version := p13_a137;
2258 ddp_service_request_rec.product_revision := p13_a138;
2259 ddp_service_request_rec.comm_pref_code := p13_a139;
2260 ddp_service_request_rec.cust_pref_lang_code := p13_a140;
2261 ddp_service_request_rec.last_update_channel := p13_a141;
2262 ddp_service_request_rec.category_set_id := p13_a142;
2263 ddp_service_request_rec.external_reference := p13_a143;
2264 ddp_service_request_rec.system_id := p13_a144;
2265 ddp_service_request_rec.error_code := p13_a145;
2266 ddp_service_request_rec.incident_occurred_date := rosetta_g_miss_date_in_map(p13_a146);
2267 ddp_service_request_rec.incident_resolved_date := rosetta_g_miss_date_in_map(p13_a147);
2268 ddp_service_request_rec.inc_responded_by_date := rosetta_g_miss_date_in_map(p13_a148);
2269 ddp_service_request_rec.resolution_summary := p13_a149;
2270 ddp_service_request_rec.incident_location_id := p13_a150;
2271 ddp_service_request_rec.incident_address := p13_a151;
2272 ddp_service_request_rec.incident_city := p13_a152;
2273 ddp_service_request_rec.incident_state := p13_a153;
2274 ddp_service_request_rec.incident_country := p13_a154;
2275 ddp_service_request_rec.incident_province := p13_a155;
2276 ddp_service_request_rec.incident_postal_code := p13_a156;
2277 ddp_service_request_rec.incident_county := p13_a157;
2278 ddp_service_request_rec.site_number := p13_a158;
2279 ddp_service_request_rec.site_name := p13_a159;
2280 ddp_service_request_rec.addressee := p13_a160;
2281 ddp_service_request_rec.owner := p13_a161;
2282 ddp_service_request_rec.group_owner := p13_a162;
2283 ddp_service_request_rec.cc_number := p13_a163;
2284 ddp_service_request_rec.cc_expiration_date := rosetta_g_miss_date_in_map(p13_a164);
2285 ddp_service_request_rec.cc_type_code := p13_a165;
2286 ddp_service_request_rec.cc_first_name := p13_a166;
2287 ddp_service_request_rec.cc_last_name := p13_a167;
2288 ddp_service_request_rec.cc_middle_name := p13_a168;
2289 ddp_service_request_rec.cc_id := p13_a169;
2290 ddp_service_request_rec.bill_to_account_id := p13_a170;
2291 ddp_service_request_rec.ship_to_account_id := p13_a171;
2292 ddp_service_request_rec.customer_phone_id := p13_a172;
2293 ddp_service_request_rec.customer_email_id := p13_a173;
2294 ddp_service_request_rec.creation_program_code := p13_a174;
2295 ddp_service_request_rec.last_update_program_code := p13_a175;
2296 ddp_service_request_rec.bill_to_party_id := p13_a176;
2297 ddp_service_request_rec.ship_to_party_id := p13_a177;
2298 ddp_service_request_rec.program_id := p13_a178;
2299 ddp_service_request_rec.program_application_id := p13_a179;
2300 ddp_service_request_rec.conc_request_id := p13_a180;
2301 ddp_service_request_rec.program_login_id := p13_a181;
2302 ddp_service_request_rec.bill_to_site_id := p13_a182;
2303 ddp_service_request_rec.ship_to_site_id := p13_a183;
2304 ddp_service_request_rec.incident_point_of_interest := p13_a184;
2305 ddp_service_request_rec.incident_cross_street := p13_a185;
2306 ddp_service_request_rec.incident_direction_qualifier := p13_a186;
2307 ddp_service_request_rec.incident_distance_qualifier := p13_a187;
2308 ddp_service_request_rec.incident_distance_qual_uom := p13_a188;
2309 ddp_service_request_rec.incident_address2 := p13_a189;
2310 ddp_service_request_rec.incident_address3 := p13_a190;
2311 ddp_service_request_rec.incident_address4 := p13_a191;
2312 ddp_service_request_rec.incident_address_style := p13_a192;
2313 ddp_service_request_rec.incident_addr_lines_phonetic := p13_a193;
2314 ddp_service_request_rec.incident_po_box_number := p13_a194;
2315 ddp_service_request_rec.incident_house_number := p13_a195;
2316 ddp_service_request_rec.incident_street_suffix := p13_a196;
2317 ddp_service_request_rec.incident_street := p13_a197;
2318 ddp_service_request_rec.incident_street_number := p13_a198;
2319 ddp_service_request_rec.incident_floor := p13_a199;
2320 ddp_service_request_rec.incident_suite := p13_a200;
2321 ddp_service_request_rec.incident_postal_plus4_code := p13_a201;
2322 ddp_service_request_rec.incident_position := p13_a202;
2323 ddp_service_request_rec.incident_location_directions := p13_a203;
2324 ddp_service_request_rec.incident_location_description := p13_a204;
2325 ddp_service_request_rec.install_site_id := p13_a205;
2326 ddp_service_request_rec.item_serial_number := p13_a206;
2327 ddp_service_request_rec.owning_department_id := p13_a207;
2328 ddp_service_request_rec.incident_location_type := p13_a208;
2329 ddp_service_request_rec.coverage_type := p13_a209;
2330 ddp_service_request_rec.maint_organization_id := p13_a210;
2331 ddp_service_request_rec.creation_date := rosetta_g_miss_date_in_map(p13_a211);
2332 ddp_service_request_rec.created_by := p13_a212;
2333 ddp_service_request_rec.instrument_payment_use_id := p13_a213;
2334 ddp_service_request_rec.project_id := p13_a214;
2335 ddp_service_request_rec.project_task_id := p13_a215;
2336 ddp_service_request_rec.expenditure_org_id := p13_a216;
2337 ddp_service_request_rec.sla_date_1 := rosetta_g_miss_date_in_map(p13_a217);
2338 ddp_service_request_rec.sla_date_2 := rosetta_g_miss_date_in_map(p13_a218);
2339 ddp_service_request_rec.sla_date_3 := rosetta_g_miss_date_in_map(p13_a219);
2340 ddp_service_request_rec.sla_date_4 := rosetta_g_miss_date_in_map(p13_a220);
2341 ddp_service_request_rec.sla_date_5 := rosetta_g_miss_date_in_map(p13_a221);
2342 ddp_service_request_rec.sla_date_6 := rosetta_g_miss_date_in_map(p13_a222);
2343 ddp_service_request_rec.sla_duration_1 := p13_a223;
2344 ddp_service_request_rec.sla_duration_2 := p13_a224;
2345 ddp_service_request_rec.price_list_header_id := p13_a225;
2346
2347 cs_servicerequest_pub_w.rosetta_table_copy_in_p1(ddp_notes, p14_a0
2348 , p14_a1
2349 , p14_a2
2350 , p14_a3
2351 , p14_a4
2352 , p14_a5
2353 , p14_a6
2354 , p14_a7
2355 , p14_a8
2356 );
2357
2358 cs_servicerequest_pub_w.rosetta_table_copy_in_p3(ddp_contacts, p15_a0
2359 , p15_a1
2360 , p15_a2
2361 , p15_a3
2362 , p15_a4
2363 , p15_a5
2364 , p15_a6
2365 , p15_a7
2366 , p15_a8
2367 );
2368
2369
2370
2371
2372
2373
2374 -- here's the delegated call to the old PL/SQL routine
2375 cs_servicerequest_pub.create_servicerequest(p_api_version,
2376 p_init_msg_list,
2377 p_commit,
2378 x_return_status,
2379 x_msg_count,
2380 x_msg_data,
2381 p_resp_appl_id,
2382 p_resp_id,
2383 p_user_id,
2384 p_login_id,
2385 p_org_id,
2386 p_request_id,
2387 p_request_number,
2388 ddp_service_request_rec,
2389 ddp_notes,
2390 ddp_contacts,
2391 p_auto_assign,
2392 p_auto_generate_tasks,
2393 ddx_sr_create_out_rec,
2394 p_default_contract_sla_ind,
2395 p_default_coverage_template_id);
2396
2397 -- copy data back from the local variables to OUT or IN-OUT args, if any
2398
2399
2400
2401
2402
2403
2404
2405
2406
2407
2408
2409
2410
2411
2412
2413
2414
2415
2416 p18_a0 := ddx_sr_create_out_rec.request_id;
2417 p18_a1 := ddx_sr_create_out_rec.request_number;
2418 p18_a2 := ddx_sr_create_out_rec.interaction_id;
2419 p18_a3 := ddx_sr_create_out_rec.workflow_process_id;
2420 p18_a4 := ddx_sr_create_out_rec.individual_owner;
2421 p18_a5 := ddx_sr_create_out_rec.group_owner;
2422 p18_a6 := ddx_sr_create_out_rec.individual_type;
2423 p18_a7 := ddx_sr_create_out_rec.auto_task_gen_status;
2424 if ddx_sr_create_out_rec.auto_task_gen_attempted is null
2425 then p18_a8 := null;
2426 elsif ddx_sr_create_out_rec.auto_task_gen_attempted
2427 then p18_a8 := 1;
2428 else p18_a8 := 0;
2429 end if;
2430 if ddx_sr_create_out_rec.field_service_task_created is null
2431 then p18_a9 := null;
2432 elsif ddx_sr_create_out_rec.field_service_task_created
2433 then p18_a9 := 1;
2434 else p18_a9 := 0;
2435 end if;
2436 p18_a10 := ddx_sr_create_out_rec.contract_service_id;
2437 p18_a11 := ddx_sr_create_out_rec.resolve_by_date;
2438 p18_a12 := ddx_sr_create_out_rec.respond_by_date;
2439 p18_a13 := ddx_sr_create_out_rec.resolved_on_date;
2440 p18_a14 := ddx_sr_create_out_rec.responded_on_date;
2441 p18_a15 := ddx_sr_create_out_rec.incident_location_id;
2442
2443
2444 end;
2445
2446 procedure create_servicerequest(p_api_version NUMBER
2447 , p_init_msg_list VARCHAR2
2448 , p_commit VARCHAR2
2449 , x_return_status out nocopy VARCHAR2
2450 , x_msg_count out nocopy NUMBER
2451 , x_msg_data out nocopy VARCHAR2
2452 , p_resp_appl_id NUMBER
2453 , p_resp_id NUMBER
2454 , p_user_id NUMBER
2455 , p_login_id NUMBER
2456 , p_org_id NUMBER
2457 , p_request_id NUMBER
2458 , p_request_number VARCHAR2
2459 , p13_a0 DATE
2460 , p13_a1 NUMBER
2461 , p13_a2 VARCHAR2
2462 , p13_a3 NUMBER
2463 , p13_a4 VARCHAR2
2464 , p13_a5 NUMBER
2465 , p13_a6 VARCHAR2
2466 , p13_a7 NUMBER
2467 , p13_a8 VARCHAR2
2468 , p13_a9 DATE
2469 , p13_a10 NUMBER
2470 , p13_a11 NUMBER
2471 , p13_a12 VARCHAR2
2472 , p13_a13 VARCHAR2
2473 , p13_a14 VARCHAR2
2474 , p13_a15 NUMBER
2475 , p13_a16 VARCHAR2
2476 , p13_a17 NUMBER
2477 , p13_a18 VARCHAR2
2478 , p13_a19 VARCHAR2
2479 , p13_a20 NUMBER
2480 , p13_a21 NUMBER
2481 , p13_a22 VARCHAR2
2482 , p13_a23 VARCHAR2
2483 , p13_a24 NUMBER
2484 , p13_a25 NUMBER
2485 , p13_a26 NUMBER
2486 , p13_a27 NUMBER
2487 , p13_a28 NUMBER
2488 , p13_a29 NUMBER
2489 , p13_a30 VARCHAR2
2490 , p13_a31 NUMBER
2491 , p13_a32 NUMBER
2492 , p13_a33 VARCHAR2
2493 , p13_a34 VARCHAR2
2494 , p13_a35 VARCHAR2
2495 , p13_a36 VARCHAR2
2496 , p13_a37 VARCHAR2
2497 , p13_a38 VARCHAR2
2498 , p13_a39 VARCHAR2
2499 , p13_a40 VARCHAR2
2500 , p13_a41 VARCHAR2
2501 , p13_a42 VARCHAR2
2502 , p13_a43 VARCHAR2
2503 , p13_a44 VARCHAR2
2504 , p13_a45 VARCHAR2
2505 , p13_a46 VARCHAR2
2506 , p13_a47 VARCHAR2
2507 , p13_a48 VARCHAR2
2508 , p13_a49 VARCHAR2
2509 , p13_a50 VARCHAR2
2510 , p13_a51 VARCHAR2
2511 , p13_a52 VARCHAR2
2512 , p13_a53 VARCHAR2
2513 , p13_a54 VARCHAR2
2514 , p13_a55 NUMBER
2515 , p13_a56 VARCHAR2
2516 , p13_a57 NUMBER
2517 , p13_a58 VARCHAR2
2518 , p13_a59 VARCHAR2
2519 , p13_a60 DATE
2520 , p13_a61 NUMBER
2521 , p13_a62 VARCHAR2
2522 , p13_a63 VARCHAR2
2523 , p13_a64 VARCHAR2
2524 , p13_a65 VARCHAR2
2525 , p13_a66 VARCHAR2
2526 , p13_a67 VARCHAR2
2527 , p13_a68 VARCHAR2
2528 , p13_a69 VARCHAR2
2529 , p13_a70 VARCHAR2
2530 , p13_a71 VARCHAR2
2531 , p13_a72 VARCHAR2
2532 , p13_a73 VARCHAR2
2533 , p13_a74 VARCHAR2
2534 , p13_a75 VARCHAR2
2535 , p13_a76 VARCHAR2
2536 , p13_a77 VARCHAR2
2537 , p13_a78 VARCHAR2
2538 , p13_a79 VARCHAR2
2539 , p13_a80 VARCHAR2
2540 , p13_a81 VARCHAR2
2541 , p13_a82 VARCHAR2
2542 , p13_a83 VARCHAR2
2543 , p13_a84 VARCHAR2
2544 , p13_a85 VARCHAR2
2545 , p13_a86 VARCHAR2
2546 , p13_a87 VARCHAR2
2547 , p13_a88 VARCHAR2
2548 , p13_a89 VARCHAR2
2549 , p13_a90 VARCHAR2
2550 , p13_a91 VARCHAR2
2551 , p13_a92 VARCHAR2
2552 , p13_a93 VARCHAR2
2553 , p13_a94 NUMBER
2554 , p13_a95 NUMBER
2555 , p13_a96 NUMBER
2556 , p13_a97 NUMBER
2557 , p13_a98 VARCHAR2
2558 , p13_a99 DATE
2559 , p13_a100 VARCHAR2
2560 , p13_a101 NUMBER
2561 , p13_a102 NUMBER
2562 , p13_a103 VARCHAR2
2563 , p13_a104 NUMBER
2564 , p13_a105 VARCHAR2
2565 , p13_a106 NUMBER
2566 , p13_a107 NUMBER
2567 , p13_a108 VARCHAR2
2568 , p13_a109 NUMBER
2569 , p13_a110 VARCHAR2
2570 , p13_a111 VARCHAR2
2571 , p13_a112 VARCHAR2
2572 , p13_a113 DATE
2573 , p13_a114 NUMBER
2574 , p13_a115 NUMBER
2575 , p13_a116 NUMBER
2576 , p13_a117 NUMBER
2577 , p13_a118 NUMBER
2578 , p13_a119 VARCHAR2
2579 , p13_a120 NUMBER
2580 , p13_a121 VARCHAR2
2581 , p13_a122 NUMBER
2582 , p13_a123 VARCHAR2
2583 , p13_a124 NUMBER
2584 , p13_a125 VARCHAR2
2585 , p13_a126 VARCHAR2
2586 , p13_a127 VARCHAR2
2587 , p13_a128 VARCHAR2
2588 , p13_a129 VARCHAR2
2589 , p13_a130 VARCHAR2
2590 , p13_a131 NUMBER
2591 , p13_a132 NUMBER
2592 , p13_a133 VARCHAR2
2593 , p13_a134 NUMBER
2594 , p13_a135 NUMBER
2595 , p13_a136 VARCHAR2
2596 , p13_a137 VARCHAR2
2597 , p13_a138 VARCHAR2
2598 , p13_a139 VARCHAR2
2599 , p13_a140 VARCHAR2
2600 , p13_a141 VARCHAR2
2601 , p13_a142 NUMBER
2602 , p13_a143 VARCHAR2
2603 , p13_a144 NUMBER
2604 , p13_a145 VARCHAR2
2605 , p13_a146 DATE
2606 , p13_a147 DATE
2607 , p13_a148 DATE
2608 , p13_a149 VARCHAR2
2609 , p13_a150 NUMBER
2610 , p13_a151 VARCHAR2
2611 , p13_a152 VARCHAR2
2612 , p13_a153 VARCHAR2
2613 , p13_a154 VARCHAR2
2614 , p13_a155 VARCHAR2
2615 , p13_a156 VARCHAR2
2616 , p13_a157 VARCHAR2
2617 , p13_a158 VARCHAR2
2618 , p13_a159 VARCHAR2
2619 , p13_a160 VARCHAR2
2620 , p13_a161 VARCHAR2
2621 , p13_a162 VARCHAR2
2622 , p13_a163 VARCHAR2
2623 , p13_a164 DATE
2624 , p13_a165 VARCHAR
2625 , p13_a166 VARCHAR
2626 , p13_a167 VARCHAR
2627 , p13_a168 VARCHAR
2628 , p13_a169 NUMBER
2629 , p13_a170 NUMBER
2630 , p13_a171 NUMBER
2631 , p13_a172 NUMBER
2632 , p13_a173 NUMBER
2633 , p13_a174 VARCHAR2
2634 , p13_a175 VARCHAR2
2635 , p13_a176 NUMBER
2636 , p13_a177 NUMBER
2637 , p13_a178 NUMBER
2638 , p13_a179 NUMBER
2639 , p13_a180 NUMBER
2640 , p13_a181 NUMBER
2641 , p13_a182 NUMBER
2642 , p13_a183 NUMBER
2643 , p13_a184 VARCHAR2
2644 , p13_a185 VARCHAR2
2645 , p13_a186 VARCHAR2
2646 , p13_a187 VARCHAR2
2647 , p13_a188 VARCHAR2
2648 , p13_a189 VARCHAR2
2649 , p13_a190 VARCHAR2
2650 , p13_a191 VARCHAR2
2651 , p13_a192 VARCHAR2
2652 , p13_a193 VARCHAR2
2653 , p13_a194 VARCHAR2
2654 , p13_a195 VARCHAR2
2655 , p13_a196 VARCHAR2
2656 , p13_a197 VARCHAR2
2657 , p13_a198 VARCHAR2
2658 , p13_a199 VARCHAR2
2659 , p13_a200 VARCHAR2
2660 , p13_a201 VARCHAR2
2661 , p13_a202 VARCHAR2
2662 , p13_a203 VARCHAR2
2663 , p13_a204 VARCHAR2
2664 , p13_a205 NUMBER
2665 , p13_a206 VARCHAR2
2666 , p13_a207 NUMBER
2667 , p13_a208 VARCHAR2
2668 , p13_a209 VARCHAR2
2669 , p13_a210 NUMBER
2670 , p13_a211 DATE
2671 , p13_a212 NUMBER
2672 , p13_a213 NUMBER
2673 , p13_a214 NUMBER
2674 , p13_a215 NUMBER
2675 , p13_a216 NUMBER
2676 , p13_a217 DATE
2677 , p13_a218 DATE
2678 , p13_a219 DATE
2679 , p13_a220 DATE
2680 , p13_a221 DATE
2681 , p13_a222 DATE
2682 , p13_a223 NUMBER
2683 , p13_a224 NUMBER
2684 , p13_a225 NUMBER
2685 , p14_a0 JTF_VARCHAR2_TABLE_2000
2686 , p14_a1 JTF_VARCHAR2_TABLE_32767
2687 , p14_a2 JTF_VARCHAR2_TABLE_300
2688 , p14_a3 JTF_VARCHAR2_TABLE_100
2689 , p14_a4 JTF_NUMBER_TABLE
2690 , p14_a5 JTF_VARCHAR2_TABLE_100
2691 , p14_a6 JTF_NUMBER_TABLE
2692 , p14_a7 JTF_VARCHAR2_TABLE_100
2693 , p14_a8 JTF_NUMBER_TABLE
2694 , p15_a0 JTF_NUMBER_TABLE
2695 , p15_a1 JTF_NUMBER_TABLE
2696 , p15_a2 JTF_NUMBER_TABLE
2697 , p15_a3 JTF_VARCHAR2_TABLE_100
2698 , p15_a4 JTF_VARCHAR2_TABLE_100
2699 , p15_a5 JTF_VARCHAR2_TABLE_100
2700 , p15_a6 JTF_VARCHAR2_TABLE_100
2701 , p15_a7 JTF_DATE_TABLE
2702 , p15_a8 JTF_DATE_TABLE
2703 , p_auto_assign VARCHAR2
2704 , p_default_contract_sla_ind VARCHAR2
2705 , x_request_id out nocopy NUMBER
2706 , x_request_number out nocopy VARCHAR2
2707 , x_interaction_id out nocopy NUMBER
2708 , x_workflow_process_id out nocopy NUMBER
2709 , x_individual_owner out nocopy NUMBER
2710 , x_group_owner out nocopy NUMBER
2711 , x_individual_type out nocopy VARCHAR2
2712 )
2713
2714 as
2715 ddp_service_request_rec cs_servicerequest_pub.service_request_rec_type;
2716 ddp_notes cs_servicerequest_pub.notes_table;
2717 ddp_contacts cs_servicerequest_pub.contacts_table;
2718 ddindx binary_integer; indx binary_integer;
2719 begin
2720
2721 -- copy data to the local IN or IN-OUT args, if any
2722
2723
2724
2725
2726
2727
2728
2729
2730
2731
2732
2733
2734
2735 ddp_service_request_rec.request_date := rosetta_g_miss_date_in_map(p13_a0);
2736 ddp_service_request_rec.type_id := p13_a1;
2737 ddp_service_request_rec.type_name := p13_a2;
2738 ddp_service_request_rec.status_id := p13_a3;
2739 ddp_service_request_rec.status_name := p13_a4;
2740 ddp_service_request_rec.severity_id := p13_a5;
2741 ddp_service_request_rec.severity_name := p13_a6;
2742 ddp_service_request_rec.urgency_id := p13_a7;
2743 ddp_service_request_rec.urgency_name := p13_a8;
2744 ddp_service_request_rec.closed_date := rosetta_g_miss_date_in_map(p13_a9);
2745 ddp_service_request_rec.owner_id := p13_a10;
2746 ddp_service_request_rec.owner_group_id := p13_a11;
2747 ddp_service_request_rec.publish_flag := p13_a12;
2748 ddp_service_request_rec.summary := p13_a13;
2749 ddp_service_request_rec.caller_type := p13_a14;
2750 ddp_service_request_rec.customer_id := p13_a15;
2751 ddp_service_request_rec.customer_number := p13_a16;
2752 ddp_service_request_rec.employee_id := p13_a17;
2753 ddp_service_request_rec.employee_number := p13_a18;
2754 ddp_service_request_rec.verify_cp_flag := p13_a19;
2755 ddp_service_request_rec.customer_product_id := p13_a20;
2756 ddp_service_request_rec.platform_id := p13_a21;
2757 ddp_service_request_rec.platform_version := p13_a22;
2758 ddp_service_request_rec.db_version := p13_a23;
2759 ddp_service_request_rec.platform_version_id := p13_a24;
2760 ddp_service_request_rec.cp_component_id := p13_a25;
2761 ddp_service_request_rec.cp_component_version_id := p13_a26;
2762 ddp_service_request_rec.cp_subcomponent_id := p13_a27;
2763 ddp_service_request_rec.cp_subcomponent_version_id := p13_a28;
2764 ddp_service_request_rec.language_id := p13_a29;
2765 ddp_service_request_rec.language := p13_a30;
2766 ddp_service_request_rec.cp_ref_number := p13_a31;
2767 ddp_service_request_rec.inventory_item_id := p13_a32;
2768 ddp_service_request_rec.inventory_item_conc_segs := p13_a33;
2769 ddp_service_request_rec.inventory_item_segment1 := p13_a34;
2770 ddp_service_request_rec.inventory_item_segment2 := p13_a35;
2771 ddp_service_request_rec.inventory_item_segment3 := p13_a36;
2772 ddp_service_request_rec.inventory_item_segment4 := p13_a37;
2773 ddp_service_request_rec.inventory_item_segment5 := p13_a38;
2774 ddp_service_request_rec.inventory_item_segment6 := p13_a39;
2775 ddp_service_request_rec.inventory_item_segment7 := p13_a40;
2776 ddp_service_request_rec.inventory_item_segment8 := p13_a41;
2777 ddp_service_request_rec.inventory_item_segment9 := p13_a42;
2778 ddp_service_request_rec.inventory_item_segment10 := p13_a43;
2779 ddp_service_request_rec.inventory_item_segment11 := p13_a44;
2780 ddp_service_request_rec.inventory_item_segment12 := p13_a45;
2781 ddp_service_request_rec.inventory_item_segment13 := p13_a46;
2782 ddp_service_request_rec.inventory_item_segment14 := p13_a47;
2783 ddp_service_request_rec.inventory_item_segment15 := p13_a48;
2784 ddp_service_request_rec.inventory_item_segment16 := p13_a49;
2785 ddp_service_request_rec.inventory_item_segment17 := p13_a50;
2786 ddp_service_request_rec.inventory_item_segment18 := p13_a51;
2787 ddp_service_request_rec.inventory_item_segment19 := p13_a52;
2788 ddp_service_request_rec.inventory_item_segment20 := p13_a53;
2789 ddp_service_request_rec.inventory_item_vals_or_ids := p13_a54;
2790 ddp_service_request_rec.inventory_org_id := p13_a55;
2791 ddp_service_request_rec.current_serial_number := p13_a56;
2792 ddp_service_request_rec.original_order_number := p13_a57;
2793 ddp_service_request_rec.purchase_order_num := p13_a58;
2794 ddp_service_request_rec.problem_code := p13_a59;
2795 ddp_service_request_rec.exp_resolution_date := rosetta_g_miss_date_in_map(p13_a60);
2796 ddp_service_request_rec.install_site_use_id := p13_a61;
2797 ddp_service_request_rec.request_attribute_1 := p13_a62;
2798 ddp_service_request_rec.request_attribute_2 := p13_a63;
2799 ddp_service_request_rec.request_attribute_3 := p13_a64;
2800 ddp_service_request_rec.request_attribute_4 := p13_a65;
2801 ddp_service_request_rec.request_attribute_5 := p13_a66;
2802 ddp_service_request_rec.request_attribute_6 := p13_a67;
2803 ddp_service_request_rec.request_attribute_7 := p13_a68;
2804 ddp_service_request_rec.request_attribute_8 := p13_a69;
2805 ddp_service_request_rec.request_attribute_9 := p13_a70;
2806 ddp_service_request_rec.request_attribute_10 := p13_a71;
2807 ddp_service_request_rec.request_attribute_11 := p13_a72;
2808 ddp_service_request_rec.request_attribute_12 := p13_a73;
2809 ddp_service_request_rec.request_attribute_13 := p13_a74;
2810 ddp_service_request_rec.request_attribute_14 := p13_a75;
2811 ddp_service_request_rec.request_attribute_15 := p13_a76;
2812 ddp_service_request_rec.request_context := p13_a77;
2813 ddp_service_request_rec.external_attribute_1 := p13_a78;
2814 ddp_service_request_rec.external_attribute_2 := p13_a79;
2815 ddp_service_request_rec.external_attribute_3 := p13_a80;
2816 ddp_service_request_rec.external_attribute_4 := p13_a81;
2817 ddp_service_request_rec.external_attribute_5 := p13_a82;
2818 ddp_service_request_rec.external_attribute_6 := p13_a83;
2819 ddp_service_request_rec.external_attribute_7 := p13_a84;
2820 ddp_service_request_rec.external_attribute_8 := p13_a85;
2821 ddp_service_request_rec.external_attribute_9 := p13_a86;
2822 ddp_service_request_rec.external_attribute_10 := p13_a87;
2823 ddp_service_request_rec.external_attribute_11 := p13_a88;
2824 ddp_service_request_rec.external_attribute_12 := p13_a89;
2825 ddp_service_request_rec.external_attribute_13 := p13_a90;
2826 ddp_service_request_rec.external_attribute_14 := p13_a91;
2827 ddp_service_request_rec.external_attribute_15 := p13_a92;
2828 ddp_service_request_rec.external_context := p13_a93;
2829 ddp_service_request_rec.bill_to_site_use_id := p13_a94;
2830 ddp_service_request_rec.bill_to_contact_id := p13_a95;
2831 ddp_service_request_rec.ship_to_site_use_id := p13_a96;
2832 ddp_service_request_rec.ship_to_contact_id := p13_a97;
2833 ddp_service_request_rec.resolution_code := p13_a98;
2834 ddp_service_request_rec.act_resolution_date := rosetta_g_miss_date_in_map(p13_a99);
2835 ddp_service_request_rec.public_comment_flag := p13_a100;
2836 ddp_service_request_rec.parent_interaction_id := p13_a101;
2837 ddp_service_request_rec.contract_service_id := p13_a102;
2838 ddp_service_request_rec.contract_service_number := p13_a103;
2839 ddp_service_request_rec.contract_id := p13_a104;
2840 ddp_service_request_rec.project_number := p13_a105;
2841 ddp_service_request_rec.qa_collection_plan_id := p13_a106;
2842 ddp_service_request_rec.account_id := p13_a107;
2843 ddp_service_request_rec.resource_type := p13_a108;
2844 ddp_service_request_rec.resource_subtype_id := p13_a109;
2845 ddp_service_request_rec.cust_po_number := p13_a110;
2846 ddp_service_request_rec.cust_ticket_number := p13_a111;
2847 ddp_service_request_rec.sr_creation_channel := p13_a112;
2848 ddp_service_request_rec.obligation_date := rosetta_g_miss_date_in_map(p13_a113);
2849 ddp_service_request_rec.time_zone_id := p13_a114;
2850 ddp_service_request_rec.time_difference := p13_a115;
2851 ddp_service_request_rec.site_id := p13_a116;
2852 ddp_service_request_rec.customer_site_id := p13_a117;
2853 ddp_service_request_rec.territory_id := p13_a118;
2854 ddp_service_request_rec.initialize_flag := p13_a119;
2855 ddp_service_request_rec.cp_revision_id := p13_a120;
2856 ddp_service_request_rec.inv_item_revision := p13_a121;
2857 ddp_service_request_rec.inv_component_id := p13_a122;
2858 ddp_service_request_rec.inv_component_version := p13_a123;
2859 ddp_service_request_rec.inv_subcomponent_id := p13_a124;
2860 ddp_service_request_rec.inv_subcomponent_version := p13_a125;
2861 ddp_service_request_rec.tier := p13_a126;
2862 ddp_service_request_rec.tier_version := p13_a127;
2863 ddp_service_request_rec.operating_system := p13_a128;
2864 ddp_service_request_rec.operating_system_version := p13_a129;
2865 ddp_service_request_rec.database := p13_a130;
2866 ddp_service_request_rec.cust_pref_lang_id := p13_a131;
2867 ddp_service_request_rec.category_id := p13_a132;
2868 ddp_service_request_rec.group_type := p13_a133;
2869 ddp_service_request_rec.group_territory_id := p13_a134;
2870 ddp_service_request_rec.inv_platform_org_id := p13_a135;
2871 ddp_service_request_rec.component_version := p13_a136;
2872 ddp_service_request_rec.subcomponent_version := p13_a137;
2873 ddp_service_request_rec.product_revision := p13_a138;
2874 ddp_service_request_rec.comm_pref_code := p13_a139;
2875 ddp_service_request_rec.cust_pref_lang_code := p13_a140;
2876 ddp_service_request_rec.last_update_channel := p13_a141;
2877 ddp_service_request_rec.category_set_id := p13_a142;
2878 ddp_service_request_rec.external_reference := p13_a143;
2879 ddp_service_request_rec.system_id := p13_a144;
2880 ddp_service_request_rec.error_code := p13_a145;
2881 ddp_service_request_rec.incident_occurred_date := rosetta_g_miss_date_in_map(p13_a146);
2882 ddp_service_request_rec.incident_resolved_date := rosetta_g_miss_date_in_map(p13_a147);
2883 ddp_service_request_rec.inc_responded_by_date := rosetta_g_miss_date_in_map(p13_a148);
2884 ddp_service_request_rec.resolution_summary := p13_a149;
2885 ddp_service_request_rec.incident_location_id := p13_a150;
2886 ddp_service_request_rec.incident_address := p13_a151;
2887 ddp_service_request_rec.incident_city := p13_a152;
2888 ddp_service_request_rec.incident_state := p13_a153;
2889 ddp_service_request_rec.incident_country := p13_a154;
2890 ddp_service_request_rec.incident_province := p13_a155;
2891 ddp_service_request_rec.incident_postal_code := p13_a156;
2892 ddp_service_request_rec.incident_county := p13_a157;
2893 ddp_service_request_rec.site_number := p13_a158;
2894 ddp_service_request_rec.site_name := p13_a159;
2895 ddp_service_request_rec.addressee := p13_a160;
2896 ddp_service_request_rec.owner := p13_a161;
2897 ddp_service_request_rec.group_owner := p13_a162;
2898 ddp_service_request_rec.cc_number := p13_a163;
2899 ddp_service_request_rec.cc_expiration_date := rosetta_g_miss_date_in_map(p13_a164);
2900 ddp_service_request_rec.cc_type_code := p13_a165;
2901 ddp_service_request_rec.cc_first_name := p13_a166;
2902 ddp_service_request_rec.cc_last_name := p13_a167;
2903 ddp_service_request_rec.cc_middle_name := p13_a168;
2904 ddp_service_request_rec.cc_id := p13_a169;
2905 ddp_service_request_rec.bill_to_account_id := p13_a170;
2906 ddp_service_request_rec.ship_to_account_id := p13_a171;
2907 ddp_service_request_rec.customer_phone_id := p13_a172;
2908 ddp_service_request_rec.customer_email_id := p13_a173;
2909 ddp_service_request_rec.creation_program_code := p13_a174;
2910 ddp_service_request_rec.last_update_program_code := p13_a175;
2911 ddp_service_request_rec.bill_to_party_id := p13_a176;
2912 ddp_service_request_rec.ship_to_party_id := p13_a177;
2913 ddp_service_request_rec.program_id := p13_a178;
2914 ddp_service_request_rec.program_application_id := p13_a179;
2915 ddp_service_request_rec.conc_request_id := p13_a180;
2916 ddp_service_request_rec.program_login_id := p13_a181;
2917 ddp_service_request_rec.bill_to_site_id := p13_a182;
2918 ddp_service_request_rec.ship_to_site_id := p13_a183;
2919 ddp_service_request_rec.incident_point_of_interest := p13_a184;
2920 ddp_service_request_rec.incident_cross_street := p13_a185;
2921 ddp_service_request_rec.incident_direction_qualifier := p13_a186;
2922 ddp_service_request_rec.incident_distance_qualifier := p13_a187;
2923 ddp_service_request_rec.incident_distance_qual_uom := p13_a188;
2924 ddp_service_request_rec.incident_address2 := p13_a189;
2925 ddp_service_request_rec.incident_address3 := p13_a190;
2926 ddp_service_request_rec.incident_address4 := p13_a191;
2927 ddp_service_request_rec.incident_address_style := p13_a192;
2928 ddp_service_request_rec.incident_addr_lines_phonetic := p13_a193;
2929 ddp_service_request_rec.incident_po_box_number := p13_a194;
2930 ddp_service_request_rec.incident_house_number := p13_a195;
2931 ddp_service_request_rec.incident_street_suffix := p13_a196;
2932 ddp_service_request_rec.incident_street := p13_a197;
2933 ddp_service_request_rec.incident_street_number := p13_a198;
2934 ddp_service_request_rec.incident_floor := p13_a199;
2935 ddp_service_request_rec.incident_suite := p13_a200;
2936 ddp_service_request_rec.incident_postal_plus4_code := p13_a201;
2937 ddp_service_request_rec.incident_position := p13_a202;
2938 ddp_service_request_rec.incident_location_directions := p13_a203;
2939 ddp_service_request_rec.incident_location_description := p13_a204;
2940 ddp_service_request_rec.install_site_id := p13_a205;
2941 ddp_service_request_rec.item_serial_number := p13_a206;
2942 ddp_service_request_rec.owning_department_id := p13_a207;
2943 ddp_service_request_rec.incident_location_type := p13_a208;
2944 ddp_service_request_rec.coverage_type := p13_a209;
2945 ddp_service_request_rec.maint_organization_id := p13_a210;
2946 ddp_service_request_rec.creation_date := rosetta_g_miss_date_in_map(p13_a211);
2947 ddp_service_request_rec.created_by := p13_a212;
2948 ddp_service_request_rec.instrument_payment_use_id := p13_a213;
2949 ddp_service_request_rec.project_id := p13_a214;
2950 ddp_service_request_rec.project_task_id := p13_a215;
2951 ddp_service_request_rec.expenditure_org_id := p13_a216;
2952 ddp_service_request_rec.sla_date_1 := rosetta_g_miss_date_in_map(p13_a217);
2953 ddp_service_request_rec.sla_date_2 := rosetta_g_miss_date_in_map(p13_a218);
2954 ddp_service_request_rec.sla_date_3 := rosetta_g_miss_date_in_map(p13_a219);
2955 ddp_service_request_rec.sla_date_4 := rosetta_g_miss_date_in_map(p13_a220);
2956 ddp_service_request_rec.sla_date_5 := rosetta_g_miss_date_in_map(p13_a221);
2957 ddp_service_request_rec.sla_date_6 := rosetta_g_miss_date_in_map(p13_a222);
2958 ddp_service_request_rec.sla_duration_1 := p13_a223;
2959 ddp_service_request_rec.sla_duration_2 := p13_a224;
2960 ddp_service_request_rec.price_list_header_id := p13_a225;
2961
2962 cs_servicerequest_pub_w.rosetta_table_copy_in_p1(ddp_notes, p14_a0
2963 , p14_a1
2964 , p14_a2
2965 , p14_a3
2966 , p14_a4
2967 , p14_a5
2968 , p14_a6
2969 , p14_a7
2970 , p14_a8
2971 );
2972
2973 cs_servicerequest_pub_w.rosetta_table_copy_in_p3(ddp_contacts, p15_a0
2974 , p15_a1
2975 , p15_a2
2976 , p15_a3
2977 , p15_a4
2978 , p15_a5
2979 , p15_a6
2980 , p15_a7
2981 , p15_a8
2982 );
2983
2984
2985
2986
2987
2988
2989
2990
2991
2992
2993 -- here's the delegated call to the old PL/SQL routine
2994 cs_servicerequest_pub.create_servicerequest(p_api_version,
2995 p_init_msg_list,
2996 p_commit,
2997 x_return_status,
2998 x_msg_count,
2999 x_msg_data,
3000 p_resp_appl_id,
3001 p_resp_id,
3002 p_user_id,
3003 p_login_id,
3004 p_org_id,
3005 p_request_id,
3006 p_request_number,
3007 ddp_service_request_rec,
3008 ddp_notes,
3009 ddp_contacts,
3010 p_auto_assign,
3011 p_default_contract_sla_ind,
3012 x_request_id,
3013 x_request_number,
3014 x_interaction_id,
3015 x_workflow_process_id,
3016 x_individual_owner,
3017 x_group_owner,
3018 x_individual_type);
3019
3020 -- copy data back from the local variables to OUT or IN-OUT args, if any
3021
3022
3023
3024
3025
3026
3027
3028
3029
3030
3031
3032
3033
3034
3035
3036
3037
3038
3039
3040
3041
3042
3043
3044
3045 end;
3046
3047 procedure update_servicerequest(p_api_version NUMBER
3048 , p_init_msg_list VARCHAR2
3049 , p_commit VARCHAR2
3050 , x_return_status out nocopy VARCHAR2
3051 , x_msg_count out nocopy NUMBER
3052 , x_msg_data out nocopy VARCHAR2
3053 , p_request_id NUMBER
3054 , p_request_number VARCHAR2
3055 , p_audit_comments VARCHAR2
3056 , p_object_version_number NUMBER
3057 , p_resp_appl_id NUMBER
3058 , p_resp_id NUMBER
3059 , p_last_updated_by NUMBER
3060 , p_last_update_login NUMBER
3061 , p_last_update_date date
3062 , p15_a0 DATE
3063 , p15_a1 NUMBER
3064 , p15_a2 VARCHAR2
3065 , p15_a3 NUMBER
3066 , p15_a4 VARCHAR2
3067 , p15_a5 NUMBER
3068 , p15_a6 VARCHAR2
3069 , p15_a7 NUMBER
3070 , p15_a8 VARCHAR2
3071 , p15_a9 DATE
3072 , p15_a10 NUMBER
3073 , p15_a11 NUMBER
3074 , p15_a12 VARCHAR2
3075 , p15_a13 VARCHAR2
3076 , p15_a14 VARCHAR2
3077 , p15_a15 NUMBER
3078 , p15_a16 VARCHAR2
3079 , p15_a17 NUMBER
3080 , p15_a18 VARCHAR2
3081 , p15_a19 VARCHAR2
3082 , p15_a20 NUMBER
3083 , p15_a21 NUMBER
3084 , p15_a22 VARCHAR2
3085 , p15_a23 VARCHAR2
3086 , p15_a24 NUMBER
3087 , p15_a25 NUMBER
3088 , p15_a26 NUMBER
3089 , p15_a27 NUMBER
3090 , p15_a28 NUMBER
3091 , p15_a29 NUMBER
3092 , p15_a30 VARCHAR2
3093 , p15_a31 NUMBER
3094 , p15_a32 NUMBER
3095 , p15_a33 VARCHAR2
3096 , p15_a34 VARCHAR2
3097 , p15_a35 VARCHAR2
3098 , p15_a36 VARCHAR2
3099 , p15_a37 VARCHAR2
3100 , p15_a38 VARCHAR2
3101 , p15_a39 VARCHAR2
3102 , p15_a40 VARCHAR2
3103 , p15_a41 VARCHAR2
3104 , p15_a42 VARCHAR2
3105 , p15_a43 VARCHAR2
3106 , p15_a44 VARCHAR2
3107 , p15_a45 VARCHAR2
3108 , p15_a46 VARCHAR2
3109 , p15_a47 VARCHAR2
3110 , p15_a48 VARCHAR2
3111 , p15_a49 VARCHAR2
3112 , p15_a50 VARCHAR2
3113 , p15_a51 VARCHAR2
3114 , p15_a52 VARCHAR2
3115 , p15_a53 VARCHAR2
3116 , p15_a54 VARCHAR2
3117 , p15_a55 NUMBER
3118 , p15_a56 VARCHAR2
3119 , p15_a57 NUMBER
3120 , p15_a58 VARCHAR2
3121 , p15_a59 VARCHAR2
3122 , p15_a60 DATE
3123 , p15_a61 NUMBER
3124 , p15_a62 VARCHAR2
3125 , p15_a63 VARCHAR2
3126 , p15_a64 VARCHAR2
3127 , p15_a65 VARCHAR2
3128 , p15_a66 VARCHAR2
3129 , p15_a67 VARCHAR2
3130 , p15_a68 VARCHAR2
3131 , p15_a69 VARCHAR2
3132 , p15_a70 VARCHAR2
3133 , p15_a71 VARCHAR2
3134 , p15_a72 VARCHAR2
3135 , p15_a73 VARCHAR2
3136 , p15_a74 VARCHAR2
3137 , p15_a75 VARCHAR2
3138 , p15_a76 VARCHAR2
3139 , p15_a77 VARCHAR2
3140 , p15_a78 VARCHAR2
3141 , p15_a79 VARCHAR2
3142 , p15_a80 VARCHAR2
3143 , p15_a81 VARCHAR2
3144 , p15_a82 VARCHAR2
3145 , p15_a83 VARCHAR2
3146 , p15_a84 VARCHAR2
3147 , p15_a85 VARCHAR2
3148 , p15_a86 VARCHAR2
3149 , p15_a87 VARCHAR2
3150 , p15_a88 VARCHAR2
3151 , p15_a89 VARCHAR2
3152 , p15_a90 VARCHAR2
3153 , p15_a91 VARCHAR2
3154 , p15_a92 VARCHAR2
3155 , p15_a93 VARCHAR2
3156 , p15_a94 NUMBER
3157 , p15_a95 NUMBER
3158 , p15_a96 NUMBER
3159 , p15_a97 NUMBER
3160 , p15_a98 VARCHAR2
3161 , p15_a99 DATE
3162 , p15_a100 VARCHAR2
3163 , p15_a101 NUMBER
3164 , p15_a102 NUMBER
3165 , p15_a103 VARCHAR2
3166 , p15_a104 NUMBER
3167 , p15_a105 VARCHAR2
3168 , p15_a106 NUMBER
3169 , p15_a107 NUMBER
3170 , p15_a108 VARCHAR2
3171 , p15_a109 NUMBER
3172 , p15_a110 VARCHAR2
3173 , p15_a111 VARCHAR2
3174 , p15_a112 VARCHAR2
3175 , p15_a113 DATE
3176 , p15_a114 NUMBER
3177 , p15_a115 NUMBER
3178 , p15_a116 NUMBER
3179 , p15_a117 NUMBER
3180 , p15_a118 NUMBER
3181 , p15_a119 VARCHAR2
3182 , p15_a120 NUMBER
3183 , p15_a121 VARCHAR2
3184 , p15_a122 NUMBER
3185 , p15_a123 VARCHAR2
3186 , p15_a124 NUMBER
3187 , p15_a125 VARCHAR2
3188 , p15_a126 VARCHAR2
3189 , p15_a127 VARCHAR2
3190 , p15_a128 VARCHAR2
3191 , p15_a129 VARCHAR2
3192 , p15_a130 VARCHAR2
3193 , p15_a131 NUMBER
3194 , p15_a132 NUMBER
3195 , p15_a133 VARCHAR2
3196 , p15_a134 NUMBER
3197 , p15_a135 NUMBER
3198 , p15_a136 VARCHAR2
3199 , p15_a137 VARCHAR2
3200 , p15_a138 VARCHAR2
3201 , p15_a139 VARCHAR2
3202 , p15_a140 VARCHAR2
3203 , p15_a141 VARCHAR2
3204 , p15_a142 NUMBER
3205 , p15_a143 VARCHAR2
3206 , p15_a144 NUMBER
3207 , p15_a145 VARCHAR2
3208 , p15_a146 DATE
3209 , p15_a147 DATE
3210 , p15_a148 DATE
3211 , p15_a149 VARCHAR2
3212 , p15_a150 NUMBER
3213 , p15_a151 VARCHAR2
3214 , p15_a152 VARCHAR2
3215 , p15_a153 VARCHAR2
3216 , p15_a154 VARCHAR2
3217 , p15_a155 VARCHAR2
3218 , p15_a156 VARCHAR2
3219 , p15_a157 VARCHAR2
3220 , p15_a158 VARCHAR2
3221 , p15_a159 VARCHAR2
3222 , p15_a160 VARCHAR2
3223 , p15_a161 VARCHAR2
3224 , p15_a162 VARCHAR2
3225 , p15_a163 VARCHAR2
3226 , p15_a164 DATE
3227 , p15_a165 VARCHAR
3228 , p15_a166 VARCHAR
3229 , p15_a167 VARCHAR
3230 , p15_a168 VARCHAR
3231 , p15_a169 NUMBER
3232 , p15_a170 NUMBER
3233 , p15_a171 NUMBER
3234 , p15_a172 NUMBER
3235 , p15_a173 NUMBER
3236 , p15_a174 VARCHAR2
3237 , p15_a175 VARCHAR2
3238 , p15_a176 NUMBER
3239 , p15_a177 NUMBER
3240 , p15_a178 NUMBER
3241 , p15_a179 NUMBER
3242 , p15_a180 NUMBER
3243 , p15_a181 NUMBER
3244 , p15_a182 NUMBER
3245 , p15_a183 NUMBER
3246 , p15_a184 VARCHAR2
3247 , p15_a185 VARCHAR2
3248 , p15_a186 VARCHAR2
3249 , p15_a187 VARCHAR2
3250 , p15_a188 VARCHAR2
3251 , p15_a189 VARCHAR2
3252 , p15_a190 VARCHAR2
3253 , p15_a191 VARCHAR2
3254 , p15_a192 VARCHAR2
3255 , p15_a193 VARCHAR2
3256 , p15_a194 VARCHAR2
3257 , p15_a195 VARCHAR2
3258 , p15_a196 VARCHAR2
3259 , p15_a197 VARCHAR2
3260 , p15_a198 VARCHAR2
3261 , p15_a199 VARCHAR2
3262 , p15_a200 VARCHAR2
3263 , p15_a201 VARCHAR2
3264 , p15_a202 VARCHAR2
3265 , p15_a203 VARCHAR2
3266 , p15_a204 VARCHAR2
3267 , p15_a205 NUMBER
3268 , p15_a206 VARCHAR2
3269 , p15_a207 NUMBER
3270 , p15_a208 VARCHAR2
3271 , p15_a209 VARCHAR2
3272 , p15_a210 NUMBER
3273 , p15_a211 DATE
3274 , p15_a212 NUMBER
3275 , p15_a213 NUMBER
3276 , p15_a214 NUMBER
3277 , p15_a215 NUMBER
3278 , p15_a216 NUMBER
3279 , p15_a217 DATE
3280 , p15_a218 DATE
3281 , p15_a219 DATE
3282 , p15_a220 DATE
3283 , p15_a221 DATE
3284 , p15_a222 DATE
3285 , p15_a223 NUMBER
3286 , p15_a224 NUMBER
3287 , p15_a225 NUMBER
3288 , p16_a0 JTF_VARCHAR2_TABLE_2000
3289 , p16_a1 JTF_VARCHAR2_TABLE_32767
3290 , p16_a2 JTF_VARCHAR2_TABLE_300
3291 , p16_a3 JTF_VARCHAR2_TABLE_100
3292 , p16_a4 JTF_NUMBER_TABLE
3293 , p16_a5 JTF_VARCHAR2_TABLE_100
3294 , p16_a6 JTF_NUMBER_TABLE
3295 , p16_a7 JTF_VARCHAR2_TABLE_100
3296 , p16_a8 JTF_NUMBER_TABLE
3297 , p17_a0 JTF_NUMBER_TABLE
3298 , p17_a1 JTF_NUMBER_TABLE
3299 , p17_a2 JTF_NUMBER_TABLE
3300 , p17_a3 JTF_VARCHAR2_TABLE_100
3301 , p17_a4 JTF_VARCHAR2_TABLE_100
3302 , p17_a5 JTF_VARCHAR2_TABLE_100
3303 , p17_a6 JTF_VARCHAR2_TABLE_100
3304 , p17_a7 JTF_DATE_TABLE
3305 , p17_a8 JTF_DATE_TABLE
3306 , p_called_by_workflow VARCHAR2
3307 , p_workflow_process_id NUMBER
3308 , p_auto_assign VARCHAR2
3309 , p_validate_sr_closure VARCHAR2
3310 , p_auto_close_child_entities VARCHAR2
3311 , p_default_contract_sla_ind VARCHAR2
3312 , p_auto_generate_tasks VARCHAR2
3313 , p25_a0 out nocopy NUMBER
3314 , p25_a1 out nocopy NUMBER
3315 , p25_a2 out nocopy NUMBER
3316 , p25_a3 out nocopy NUMBER
3317 , p25_a4 out nocopy VARCHAR2
3318 , p25_a5 out nocopy DATE
3319 , p25_a6 out nocopy DATE
3320 , p25_a7 out nocopy NUMBER
3321 , p25_a8 out nocopy DATE
3322 , p25_a9 out nocopy NUMBER
3323 )
3324
3325 as
3326 ddp_last_update_date date;
3327 ddp_service_request_rec cs_servicerequest_pub.service_request_rec_type;
3328 ddp_notes cs_servicerequest_pub.notes_table;
3329 ddp_contacts cs_servicerequest_pub.contacts_table;
3330 ddx_sr_update_out_rec cs_servicerequest_pub.sr_update_out_rec_type;
3331 ddindx binary_integer; indx binary_integer;
3332 begin
3333
3334 -- copy data to the local IN or IN-OUT args, if any
3335
3336
3337
3338
3339
3340
3341
3342
3343
3344
3345
3346
3347
3348
3349 ddp_last_update_date := rosetta_g_miss_date_in_map(p_last_update_date);
3350
3351 ddp_service_request_rec.request_date := rosetta_g_miss_date_in_map(p15_a0);
3352 ddp_service_request_rec.type_id := p15_a1;
3353 ddp_service_request_rec.type_name := p15_a2;
3354 ddp_service_request_rec.status_id := p15_a3;
3355 ddp_service_request_rec.status_name := p15_a4;
3356 ddp_service_request_rec.severity_id := p15_a5;
3357 ddp_service_request_rec.severity_name := p15_a6;
3358 ddp_service_request_rec.urgency_id := p15_a7;
3359 ddp_service_request_rec.urgency_name := p15_a8;
3360 ddp_service_request_rec.closed_date := rosetta_g_miss_date_in_map(p15_a9);
3361 ddp_service_request_rec.owner_id := p15_a10;
3362 ddp_service_request_rec.owner_group_id := p15_a11;
3363 ddp_service_request_rec.publish_flag := p15_a12;
3364 ddp_service_request_rec.summary := p15_a13;
3365 ddp_service_request_rec.caller_type := p15_a14;
3366 ddp_service_request_rec.customer_id := p15_a15;
3367 ddp_service_request_rec.customer_number := p15_a16;
3368 ddp_service_request_rec.employee_id := p15_a17;
3369 ddp_service_request_rec.employee_number := p15_a18;
3370 ddp_service_request_rec.verify_cp_flag := p15_a19;
3371 ddp_service_request_rec.customer_product_id := p15_a20;
3372 ddp_service_request_rec.platform_id := p15_a21;
3373 ddp_service_request_rec.platform_version := p15_a22;
3374 ddp_service_request_rec.db_version := p15_a23;
3375 ddp_service_request_rec.platform_version_id := p15_a24;
3376 ddp_service_request_rec.cp_component_id := p15_a25;
3377 ddp_service_request_rec.cp_component_version_id := p15_a26;
3378 ddp_service_request_rec.cp_subcomponent_id := p15_a27;
3379 ddp_service_request_rec.cp_subcomponent_version_id := p15_a28;
3380 ddp_service_request_rec.language_id := p15_a29;
3381 ddp_service_request_rec.language := p15_a30;
3382 ddp_service_request_rec.cp_ref_number := p15_a31;
3383 ddp_service_request_rec.inventory_item_id := p15_a32;
3384 ddp_service_request_rec.inventory_item_conc_segs := p15_a33;
3385 ddp_service_request_rec.inventory_item_segment1 := p15_a34;
3386 ddp_service_request_rec.inventory_item_segment2 := p15_a35;
3387 ddp_service_request_rec.inventory_item_segment3 := p15_a36;
3388 ddp_service_request_rec.inventory_item_segment4 := p15_a37;
3389 ddp_service_request_rec.inventory_item_segment5 := p15_a38;
3390 ddp_service_request_rec.inventory_item_segment6 := p15_a39;
3391 ddp_service_request_rec.inventory_item_segment7 := p15_a40;
3392 ddp_service_request_rec.inventory_item_segment8 := p15_a41;
3393 ddp_service_request_rec.inventory_item_segment9 := p15_a42;
3394 ddp_service_request_rec.inventory_item_segment10 := p15_a43;
3395 ddp_service_request_rec.inventory_item_segment11 := p15_a44;
3396 ddp_service_request_rec.inventory_item_segment12 := p15_a45;
3397 ddp_service_request_rec.inventory_item_segment13 := p15_a46;
3398 ddp_service_request_rec.inventory_item_segment14 := p15_a47;
3399 ddp_service_request_rec.inventory_item_segment15 := p15_a48;
3400 ddp_service_request_rec.inventory_item_segment16 := p15_a49;
3401 ddp_service_request_rec.inventory_item_segment17 := p15_a50;
3402 ddp_service_request_rec.inventory_item_segment18 := p15_a51;
3403 ddp_service_request_rec.inventory_item_segment19 := p15_a52;
3404 ddp_service_request_rec.inventory_item_segment20 := p15_a53;
3405 ddp_service_request_rec.inventory_item_vals_or_ids := p15_a54;
3406 ddp_service_request_rec.inventory_org_id := p15_a55;
3407 ddp_service_request_rec.current_serial_number := p15_a56;
3408 ddp_service_request_rec.original_order_number := p15_a57;
3409 ddp_service_request_rec.purchase_order_num := p15_a58;
3410 ddp_service_request_rec.problem_code := p15_a59;
3411 ddp_service_request_rec.exp_resolution_date := rosetta_g_miss_date_in_map(p15_a60);
3412 ddp_service_request_rec.install_site_use_id := p15_a61;
3413 ddp_service_request_rec.request_attribute_1 := p15_a62;
3414 ddp_service_request_rec.request_attribute_2 := p15_a63;
3415 ddp_service_request_rec.request_attribute_3 := p15_a64;
3416 ddp_service_request_rec.request_attribute_4 := p15_a65;
3417 ddp_service_request_rec.request_attribute_5 := p15_a66;
3418 ddp_service_request_rec.request_attribute_6 := p15_a67;
3419 ddp_service_request_rec.request_attribute_7 := p15_a68;
3420 ddp_service_request_rec.request_attribute_8 := p15_a69;
3421 ddp_service_request_rec.request_attribute_9 := p15_a70;
3422 ddp_service_request_rec.request_attribute_10 := p15_a71;
3423 ddp_service_request_rec.request_attribute_11 := p15_a72;
3424 ddp_service_request_rec.request_attribute_12 := p15_a73;
3425 ddp_service_request_rec.request_attribute_13 := p15_a74;
3426 ddp_service_request_rec.request_attribute_14 := p15_a75;
3427 ddp_service_request_rec.request_attribute_15 := p15_a76;
3428 ddp_service_request_rec.request_context := p15_a77;
3429 ddp_service_request_rec.external_attribute_1 := p15_a78;
3430 ddp_service_request_rec.external_attribute_2 := p15_a79;
3431 ddp_service_request_rec.external_attribute_3 := p15_a80;
3432 ddp_service_request_rec.external_attribute_4 := p15_a81;
3433 ddp_service_request_rec.external_attribute_5 := p15_a82;
3434 ddp_service_request_rec.external_attribute_6 := p15_a83;
3435 ddp_service_request_rec.external_attribute_7 := p15_a84;
3436 ddp_service_request_rec.external_attribute_8 := p15_a85;
3437 ddp_service_request_rec.external_attribute_9 := p15_a86;
3438 ddp_service_request_rec.external_attribute_10 := p15_a87;
3439 ddp_service_request_rec.external_attribute_11 := p15_a88;
3440 ddp_service_request_rec.external_attribute_12 := p15_a89;
3441 ddp_service_request_rec.external_attribute_13 := p15_a90;
3442 ddp_service_request_rec.external_attribute_14 := p15_a91;
3443 ddp_service_request_rec.external_attribute_15 := p15_a92;
3444 ddp_service_request_rec.external_context := p15_a93;
3445 ddp_service_request_rec.bill_to_site_use_id := p15_a94;
3446 ddp_service_request_rec.bill_to_contact_id := p15_a95;
3447 ddp_service_request_rec.ship_to_site_use_id := p15_a96;
3448 ddp_service_request_rec.ship_to_contact_id := p15_a97;
3449 ddp_service_request_rec.resolution_code := p15_a98;
3450 ddp_service_request_rec.act_resolution_date := rosetta_g_miss_date_in_map(p15_a99);
3451 ddp_service_request_rec.public_comment_flag := p15_a100;
3452 ddp_service_request_rec.parent_interaction_id := p15_a101;
3453 ddp_service_request_rec.contract_service_id := p15_a102;
3454 ddp_service_request_rec.contract_service_number := p15_a103;
3455 ddp_service_request_rec.contract_id := p15_a104;
3456 ddp_service_request_rec.project_number := p15_a105;
3457 ddp_service_request_rec.qa_collection_plan_id := p15_a106;
3458 ddp_service_request_rec.account_id := p15_a107;
3459 ddp_service_request_rec.resource_type := p15_a108;
3460 ddp_service_request_rec.resource_subtype_id := p15_a109;
3461 ddp_service_request_rec.cust_po_number := p15_a110;
3462 ddp_service_request_rec.cust_ticket_number := p15_a111;
3463 ddp_service_request_rec.sr_creation_channel := p15_a112;
3464 ddp_service_request_rec.obligation_date := rosetta_g_miss_date_in_map(p15_a113);
3465 ddp_service_request_rec.time_zone_id := p15_a114;
3466 ddp_service_request_rec.time_difference := p15_a115;
3467 ddp_service_request_rec.site_id := p15_a116;
3468 ddp_service_request_rec.customer_site_id := p15_a117;
3469 ddp_service_request_rec.territory_id := p15_a118;
3470 ddp_service_request_rec.initialize_flag := p15_a119;
3471 ddp_service_request_rec.cp_revision_id := p15_a120;
3472 ddp_service_request_rec.inv_item_revision := p15_a121;
3473 ddp_service_request_rec.inv_component_id := p15_a122;
3474 ddp_service_request_rec.inv_component_version := p15_a123;
3475 ddp_service_request_rec.inv_subcomponent_id := p15_a124;
3476 ddp_service_request_rec.inv_subcomponent_version := p15_a125;
3477 ddp_service_request_rec.tier := p15_a126;
3478 ddp_service_request_rec.tier_version := p15_a127;
3479 ddp_service_request_rec.operating_system := p15_a128;
3480 ddp_service_request_rec.operating_system_version := p15_a129;
3481 ddp_service_request_rec.database := p15_a130;
3482 ddp_service_request_rec.cust_pref_lang_id := p15_a131;
3483 ddp_service_request_rec.category_id := p15_a132;
3484 ddp_service_request_rec.group_type := p15_a133;
3485 ddp_service_request_rec.group_territory_id := p15_a134;
3486 ddp_service_request_rec.inv_platform_org_id := p15_a135;
3487 ddp_service_request_rec.component_version := p15_a136;
3488 ddp_service_request_rec.subcomponent_version := p15_a137;
3489 ddp_service_request_rec.product_revision := p15_a138;
3490 ddp_service_request_rec.comm_pref_code := p15_a139;
3491 ddp_service_request_rec.cust_pref_lang_code := p15_a140;
3492 ddp_service_request_rec.last_update_channel := p15_a141;
3493 ddp_service_request_rec.category_set_id := p15_a142;
3494 ddp_service_request_rec.external_reference := p15_a143;
3495 ddp_service_request_rec.system_id := p15_a144;
3496 ddp_service_request_rec.error_code := p15_a145;
3497 ddp_service_request_rec.incident_occurred_date := rosetta_g_miss_date_in_map(p15_a146);
3498 ddp_service_request_rec.incident_resolved_date := rosetta_g_miss_date_in_map(p15_a147);
3499 ddp_service_request_rec.inc_responded_by_date := rosetta_g_miss_date_in_map(p15_a148);
3500 ddp_service_request_rec.resolution_summary := p15_a149;
3501 ddp_service_request_rec.incident_location_id := p15_a150;
3502 ddp_service_request_rec.incident_address := p15_a151;
3503 ddp_service_request_rec.incident_city := p15_a152;
3504 ddp_service_request_rec.incident_state := p15_a153;
3505 ddp_service_request_rec.incident_country := p15_a154;
3506 ddp_service_request_rec.incident_province := p15_a155;
3507 ddp_service_request_rec.incident_postal_code := p15_a156;
3508 ddp_service_request_rec.incident_county := p15_a157;
3509 ddp_service_request_rec.site_number := p15_a158;
3510 ddp_service_request_rec.site_name := p15_a159;
3511 ddp_service_request_rec.addressee := p15_a160;
3512 ddp_service_request_rec.owner := p15_a161;
3513 ddp_service_request_rec.group_owner := p15_a162;
3514 ddp_service_request_rec.cc_number := p15_a163;
3515 ddp_service_request_rec.cc_expiration_date := rosetta_g_miss_date_in_map(p15_a164);
3516 ddp_service_request_rec.cc_type_code := p15_a165;
3517 ddp_service_request_rec.cc_first_name := p15_a166;
3518 ddp_service_request_rec.cc_last_name := p15_a167;
3519 ddp_service_request_rec.cc_middle_name := p15_a168;
3520 ddp_service_request_rec.cc_id := p15_a169;
3521 ddp_service_request_rec.bill_to_account_id := p15_a170;
3522 ddp_service_request_rec.ship_to_account_id := p15_a171;
3523 ddp_service_request_rec.customer_phone_id := p15_a172;
3524 ddp_service_request_rec.customer_email_id := p15_a173;
3525 ddp_service_request_rec.creation_program_code := p15_a174;
3526 ddp_service_request_rec.last_update_program_code := p15_a175;
3527 ddp_service_request_rec.bill_to_party_id := p15_a176;
3528 ddp_service_request_rec.ship_to_party_id := p15_a177;
3529 ddp_service_request_rec.program_id := p15_a178;
3530 ddp_service_request_rec.program_application_id := p15_a179;
3531 ddp_service_request_rec.conc_request_id := p15_a180;
3532 ddp_service_request_rec.program_login_id := p15_a181;
3533 ddp_service_request_rec.bill_to_site_id := p15_a182;
3534 ddp_service_request_rec.ship_to_site_id := p15_a183;
3535 ddp_service_request_rec.incident_point_of_interest := p15_a184;
3536 ddp_service_request_rec.incident_cross_street := p15_a185;
3537 ddp_service_request_rec.incident_direction_qualifier := p15_a186;
3538 ddp_service_request_rec.incident_distance_qualifier := p15_a187;
3539 ddp_service_request_rec.incident_distance_qual_uom := p15_a188;
3540 ddp_service_request_rec.incident_address2 := p15_a189;
3541 ddp_service_request_rec.incident_address3 := p15_a190;
3542 ddp_service_request_rec.incident_address4 := p15_a191;
3543 ddp_service_request_rec.incident_address_style := p15_a192;
3544 ddp_service_request_rec.incident_addr_lines_phonetic := p15_a193;
3545 ddp_service_request_rec.incident_po_box_number := p15_a194;
3546 ddp_service_request_rec.incident_house_number := p15_a195;
3547 ddp_service_request_rec.incident_street_suffix := p15_a196;
3548 ddp_service_request_rec.incident_street := p15_a197;
3549 ddp_service_request_rec.incident_street_number := p15_a198;
3550 ddp_service_request_rec.incident_floor := p15_a199;
3551 ddp_service_request_rec.incident_suite := p15_a200;
3552 ddp_service_request_rec.incident_postal_plus4_code := p15_a201;
3553 ddp_service_request_rec.incident_position := p15_a202;
3554 ddp_service_request_rec.incident_location_directions := p15_a203;
3555 ddp_service_request_rec.incident_location_description := p15_a204;
3556 ddp_service_request_rec.install_site_id := p15_a205;
3557 ddp_service_request_rec.item_serial_number := p15_a206;
3558 ddp_service_request_rec.owning_department_id := p15_a207;
3559 ddp_service_request_rec.incident_location_type := p15_a208;
3560 ddp_service_request_rec.coverage_type := p15_a209;
3561 ddp_service_request_rec.maint_organization_id := p15_a210;
3562 ddp_service_request_rec.creation_date := rosetta_g_miss_date_in_map(p15_a211);
3563 ddp_service_request_rec.created_by := p15_a212;
3564 ddp_service_request_rec.instrument_payment_use_id := p15_a213;
3565 ddp_service_request_rec.project_id := p15_a214;
3566 ddp_service_request_rec.project_task_id := p15_a215;
3567 ddp_service_request_rec.expenditure_org_id := p15_a216;
3568 ddp_service_request_rec.sla_date_1 := rosetta_g_miss_date_in_map(p15_a217);
3569 ddp_service_request_rec.sla_date_2 := rosetta_g_miss_date_in_map(p15_a218);
3570 ddp_service_request_rec.sla_date_3 := rosetta_g_miss_date_in_map(p15_a219);
3571 ddp_service_request_rec.sla_date_4 := rosetta_g_miss_date_in_map(p15_a220);
3572 ddp_service_request_rec.sla_date_5 := rosetta_g_miss_date_in_map(p15_a221);
3573 ddp_service_request_rec.sla_date_6 := rosetta_g_miss_date_in_map(p15_a222);
3574 ddp_service_request_rec.sla_duration_1 := p15_a223;
3575 ddp_service_request_rec.sla_duration_2 := p15_a224;
3576 ddp_service_request_rec.price_list_header_id := p15_a225;
3577
3578 cs_servicerequest_pub_w.rosetta_table_copy_in_p1(ddp_notes, p16_a0
3579 , p16_a1
3580 , p16_a2
3581 , p16_a3
3582 , p16_a4
3583 , p16_a5
3584 , p16_a6
3585 , p16_a7
3586 , p16_a8
3587 );
3588
3589 cs_servicerequest_pub_w.rosetta_table_copy_in_p3(ddp_contacts, p17_a0
3590 , p17_a1
3591 , p17_a2
3592 , p17_a3
3593 , p17_a4
3594 , p17_a5
3595 , p17_a6
3596 , p17_a7
3597 , p17_a8
3598 );
3599
3600
3601
3602
3603
3604
3605
3606
3607
3608 -- here's the delegated call to the old PL/SQL routine
3609 cs_servicerequest_pub.update_servicerequest(p_api_version,
3610 p_init_msg_list,
3611 p_commit,
3612 x_return_status,
3613 x_msg_count,
3614 x_msg_data,
3615 p_request_id,
3616 p_request_number,
3617 p_audit_comments,
3618 p_object_version_number,
3619 p_resp_appl_id,
3620 p_resp_id,
3621 p_last_updated_by,
3622 p_last_update_login,
3623 ddp_last_update_date,
3624 ddp_service_request_rec,
3625 ddp_notes,
3626 ddp_contacts,
3627 p_called_by_workflow,
3628 p_workflow_process_id,
3629 p_auto_assign,
3630 p_validate_sr_closure,
3631 p_auto_close_child_entities,
3632 p_default_contract_sla_ind,
3633 p_auto_generate_tasks,
3634 ddx_sr_update_out_rec);
3635
3636 -- copy data back from the local variables to OUT or IN-OUT args, if any
3637
3638
3639
3640
3641
3642
3643
3644
3645
3646
3647
3648
3649
3650
3651
3652
3653
3654
3655
3656
3657
3658
3659
3660
3661
3662 p25_a0 := ddx_sr_update_out_rec.interaction_id;
3663 p25_a1 := ddx_sr_update_out_rec.workflow_process_id;
3664 p25_a2 := ddx_sr_update_out_rec.individual_owner;
3665 p25_a3 := ddx_sr_update_out_rec.group_owner;
3666 p25_a4 := ddx_sr_update_out_rec.individual_type;
3667 p25_a5 := ddx_sr_update_out_rec.resolved_on_date;
3668 p25_a6 := ddx_sr_update_out_rec.responded_on_date;
3669 p25_a7 := ddx_sr_update_out_rec.status_id;
3670 p25_a8 := ddx_sr_update_out_rec.close_date;
3671 p25_a9 := ddx_sr_update_out_rec.incident_location_id;
3672 end;
3673
3674 procedure update_servicerequest(p_api_version NUMBER
3675 , p_init_msg_list VARCHAR2
3676 , p_commit VARCHAR2
3677 , x_return_status out nocopy VARCHAR2
3678 , x_msg_count out nocopy NUMBER
3679 , x_msg_data out nocopy VARCHAR2
3680 , p_request_id NUMBER
3681 , p_request_number VARCHAR2
3682 , p_audit_comments VARCHAR2
3683 , p_object_version_number NUMBER
3684 , p_resp_appl_id NUMBER
3685 , p_resp_id NUMBER
3686 , p_last_updated_by NUMBER
3687 , p_last_update_login NUMBER
3688 , p_last_update_date date
3689 , p15_a0 DATE
3690 , p15_a1 NUMBER
3691 , p15_a2 VARCHAR2
3692 , p15_a3 NUMBER
3693 , p15_a4 VARCHAR2
3694 , p15_a5 NUMBER
3695 , p15_a6 VARCHAR2
3696 , p15_a7 NUMBER
3697 , p15_a8 VARCHAR2
3698 , p15_a9 DATE
3699 , p15_a10 NUMBER
3700 , p15_a11 NUMBER
3701 , p15_a12 VARCHAR2
3702 , p15_a13 VARCHAR2
3703 , p15_a14 VARCHAR2
3704 , p15_a15 NUMBER
3705 , p15_a16 VARCHAR2
3706 , p15_a17 NUMBER
3707 , p15_a18 VARCHAR2
3708 , p15_a19 VARCHAR2
3709 , p15_a20 NUMBER
3710 , p15_a21 NUMBER
3711 , p15_a22 VARCHAR2
3712 , p15_a23 VARCHAR2
3713 , p15_a24 NUMBER
3714 , p15_a25 NUMBER
3715 , p15_a26 NUMBER
3716 , p15_a27 NUMBER
3717 , p15_a28 NUMBER
3718 , p15_a29 NUMBER
3719 , p15_a30 VARCHAR2
3720 , p15_a31 NUMBER
3721 , p15_a32 NUMBER
3722 , p15_a33 VARCHAR2
3723 , p15_a34 VARCHAR2
3724 , p15_a35 VARCHAR2
3725 , p15_a36 VARCHAR2
3726 , p15_a37 VARCHAR2
3727 , p15_a38 VARCHAR2
3728 , p15_a39 VARCHAR2
3729 , p15_a40 VARCHAR2
3730 , p15_a41 VARCHAR2
3731 , p15_a42 VARCHAR2
3732 , p15_a43 VARCHAR2
3733 , p15_a44 VARCHAR2
3734 , p15_a45 VARCHAR2
3735 , p15_a46 VARCHAR2
3736 , p15_a47 VARCHAR2
3737 , p15_a48 VARCHAR2
3738 , p15_a49 VARCHAR2
3739 , p15_a50 VARCHAR2
3740 , p15_a51 VARCHAR2
3741 , p15_a52 VARCHAR2
3742 , p15_a53 VARCHAR2
3743 , p15_a54 VARCHAR2
3744 , p15_a55 NUMBER
3745 , p15_a56 VARCHAR2
3746 , p15_a57 NUMBER
3747 , p15_a58 VARCHAR2
3748 , p15_a59 VARCHAR2
3749 , p15_a60 DATE
3750 , p15_a61 NUMBER
3751 , p15_a62 VARCHAR2
3752 , p15_a63 VARCHAR2
3753 , p15_a64 VARCHAR2
3754 , p15_a65 VARCHAR2
3755 , p15_a66 VARCHAR2
3756 , p15_a67 VARCHAR2
3757 , p15_a68 VARCHAR2
3758 , p15_a69 VARCHAR2
3759 , p15_a70 VARCHAR2
3760 , p15_a71 VARCHAR2
3761 , p15_a72 VARCHAR2
3762 , p15_a73 VARCHAR2
3763 , p15_a74 VARCHAR2
3764 , p15_a75 VARCHAR2
3765 , p15_a76 VARCHAR2
3766 , p15_a77 VARCHAR2
3767 , p15_a78 VARCHAR2
3768 , p15_a79 VARCHAR2
3769 , p15_a80 VARCHAR2
3770 , p15_a81 VARCHAR2
3771 , p15_a82 VARCHAR2
3772 , p15_a83 VARCHAR2
3773 , p15_a84 VARCHAR2
3774 , p15_a85 VARCHAR2
3775 , p15_a86 VARCHAR2
3776 , p15_a87 VARCHAR2
3777 , p15_a88 VARCHAR2
3778 , p15_a89 VARCHAR2
3779 , p15_a90 VARCHAR2
3780 , p15_a91 VARCHAR2
3781 , p15_a92 VARCHAR2
3782 , p15_a93 VARCHAR2
3783 , p15_a94 NUMBER
3784 , p15_a95 NUMBER
3785 , p15_a96 NUMBER
3786 , p15_a97 NUMBER
3787 , p15_a98 VARCHAR2
3788 , p15_a99 DATE
3789 , p15_a100 VARCHAR2
3790 , p15_a101 NUMBER
3791 , p15_a102 NUMBER
3792 , p15_a103 VARCHAR2
3793 , p15_a104 NUMBER
3794 , p15_a105 VARCHAR2
3795 , p15_a106 NUMBER
3796 , p15_a107 NUMBER
3797 , p15_a108 VARCHAR2
3798 , p15_a109 NUMBER
3799 , p15_a110 VARCHAR2
3800 , p15_a111 VARCHAR2
3801 , p15_a112 VARCHAR2
3802 , p15_a113 DATE
3803 , p15_a114 NUMBER
3804 , p15_a115 NUMBER
3805 , p15_a116 NUMBER
3806 , p15_a117 NUMBER
3807 , p15_a118 NUMBER
3808 , p15_a119 VARCHAR2
3809 , p15_a120 NUMBER
3810 , p15_a121 VARCHAR2
3811 , p15_a122 NUMBER
3812 , p15_a123 VARCHAR2
3813 , p15_a124 NUMBER
3814 , p15_a125 VARCHAR2
3815 , p15_a126 VARCHAR2
3816 , p15_a127 VARCHAR2
3817 , p15_a128 VARCHAR2
3818 , p15_a129 VARCHAR2
3819 , p15_a130 VARCHAR2
3820 , p15_a131 NUMBER
3821 , p15_a132 NUMBER
3822 , p15_a133 VARCHAR2
3823 , p15_a134 NUMBER
3824 , p15_a135 NUMBER
3825 , p15_a136 VARCHAR2
3826 , p15_a137 VARCHAR2
3827 , p15_a138 VARCHAR2
3828 , p15_a139 VARCHAR2
3829 , p15_a140 VARCHAR2
3830 , p15_a141 VARCHAR2
3831 , p15_a142 NUMBER
3832 , p15_a143 VARCHAR2
3833 , p15_a144 NUMBER
3834 , p15_a145 VARCHAR2
3835 , p15_a146 DATE
3836 , p15_a147 DATE
3837 , p15_a148 DATE
3838 , p15_a149 VARCHAR2
3839 , p15_a150 NUMBER
3840 , p15_a151 VARCHAR2
3841 , p15_a152 VARCHAR2
3842 , p15_a153 VARCHAR2
3843 , p15_a154 VARCHAR2
3844 , p15_a155 VARCHAR2
3845 , p15_a156 VARCHAR2
3846 , p15_a157 VARCHAR2
3847 , p15_a158 VARCHAR2
3848 , p15_a159 VARCHAR2
3849 , p15_a160 VARCHAR2
3850 , p15_a161 VARCHAR2
3851 , p15_a162 VARCHAR2
3852 , p15_a163 VARCHAR2
3853 , p15_a164 DATE
3854 , p15_a165 VARCHAR
3855 , p15_a166 VARCHAR
3856 , p15_a167 VARCHAR
3857 , p15_a168 VARCHAR
3858 , p15_a169 NUMBER
3859 , p15_a170 NUMBER
3860 , p15_a171 NUMBER
3861 , p15_a172 NUMBER
3862 , p15_a173 NUMBER
3863 , p15_a174 VARCHAR2
3864 , p15_a175 VARCHAR2
3865 , p15_a176 NUMBER
3866 , p15_a177 NUMBER
3867 , p15_a178 NUMBER
3868 , p15_a179 NUMBER
3869 , p15_a180 NUMBER
3870 , p15_a181 NUMBER
3871 , p15_a182 NUMBER
3872 , p15_a183 NUMBER
3873 , p15_a184 VARCHAR2
3874 , p15_a185 VARCHAR2
3875 , p15_a186 VARCHAR2
3876 , p15_a187 VARCHAR2
3877 , p15_a188 VARCHAR2
3878 , p15_a189 VARCHAR2
3879 , p15_a190 VARCHAR2
3880 , p15_a191 VARCHAR2
3881 , p15_a192 VARCHAR2
3882 , p15_a193 VARCHAR2
3883 , p15_a194 VARCHAR2
3884 , p15_a195 VARCHAR2
3885 , p15_a196 VARCHAR2
3886 , p15_a197 VARCHAR2
3887 , p15_a198 VARCHAR2
3888 , p15_a199 VARCHAR2
3889 , p15_a200 VARCHAR2
3890 , p15_a201 VARCHAR2
3891 , p15_a202 VARCHAR2
3892 , p15_a203 VARCHAR2
3893 , p15_a204 VARCHAR2
3894 , p15_a205 NUMBER
3895 , p15_a206 VARCHAR2
3896 , p15_a207 NUMBER
3897 , p15_a208 VARCHAR2
3898 , p15_a209 VARCHAR2
3899 , p15_a210 NUMBER
3900 , p15_a211 DATE
3901 , p15_a212 NUMBER
3902 , p15_a213 NUMBER
3903 , p15_a214 NUMBER
3904 , p15_a215 NUMBER
3905 , p15_a216 NUMBER
3906 , p15_a217 DATE
3907 , p15_a218 DATE
3908 , p15_a219 DATE
3909 , p15_a220 DATE
3910 , p15_a221 DATE
3911 , p15_a222 DATE
3912 , p15_a223 NUMBER
3913 , p15_a224 NUMBER
3914 , p15_a225 NUMBER
3915 , p16_a0 JTF_VARCHAR2_TABLE_2000
3916 , p16_a1 JTF_VARCHAR2_TABLE_32767
3917 , p16_a2 JTF_VARCHAR2_TABLE_300
3918 , p16_a3 JTF_VARCHAR2_TABLE_100
3919 , p16_a4 JTF_NUMBER_TABLE
3920 , p16_a5 JTF_VARCHAR2_TABLE_100
3921 , p16_a6 JTF_NUMBER_TABLE
3922 , p16_a7 JTF_VARCHAR2_TABLE_100
3923 , p16_a8 JTF_NUMBER_TABLE
3924 , p17_a0 JTF_NUMBER_TABLE
3925 , p17_a1 JTF_NUMBER_TABLE
3926 , p17_a2 JTF_NUMBER_TABLE
3927 , p17_a3 JTF_VARCHAR2_TABLE_100
3928 , p17_a4 JTF_VARCHAR2_TABLE_100
3929 , p17_a5 JTF_VARCHAR2_TABLE_100
3930 , p17_a6 JTF_VARCHAR2_TABLE_100
3931 , p17_a7 JTF_DATE_TABLE
3932 , p17_a8 JTF_DATE_TABLE
3933 , p_called_by_workflow VARCHAR2
3934 , p_workflow_process_id NUMBER
3935 , p_default_contract_sla_ind VARCHAR2
3936 , x_workflow_process_id out nocopy NUMBER
3937 , x_interaction_id out nocopy NUMBER
3938 )
3939
3940 as
3941 ddp_last_update_date date;
3942 ddp_service_request_rec cs_servicerequest_pub.service_request_rec_type;
3943 ddp_notes cs_servicerequest_pub.notes_table;
3944 ddp_contacts cs_servicerequest_pub.contacts_table;
3945 ddindx binary_integer; indx binary_integer;
3946 begin
3947
3948 -- copy data to the local IN or IN-OUT args, if any
3949
3950
3951
3952
3953
3954
3955
3956
3957
3958
3959
3960
3961
3962
3963 ddp_last_update_date := rosetta_g_miss_date_in_map(p_last_update_date);
3964
3965 ddp_service_request_rec.request_date := rosetta_g_miss_date_in_map(p15_a0);
3966 ddp_service_request_rec.type_id := p15_a1;
3967 ddp_service_request_rec.type_name := p15_a2;
3968 ddp_service_request_rec.status_id := p15_a3;
3969 ddp_service_request_rec.status_name := p15_a4;
3970 ddp_service_request_rec.severity_id := p15_a5;
3971 ddp_service_request_rec.severity_name := p15_a6;
3972 ddp_service_request_rec.urgency_id := p15_a7;
3973 ddp_service_request_rec.urgency_name := p15_a8;
3974 ddp_service_request_rec.closed_date := rosetta_g_miss_date_in_map(p15_a9);
3975 ddp_service_request_rec.owner_id := p15_a10;
3976 ddp_service_request_rec.owner_group_id := p15_a11;
3977 ddp_service_request_rec.publish_flag := p15_a12;
3978 ddp_service_request_rec.summary := p15_a13;
3979 ddp_service_request_rec.caller_type := p15_a14;
3980 ddp_service_request_rec.customer_id := p15_a15;
3981 ddp_service_request_rec.customer_number := p15_a16;
3982 ddp_service_request_rec.employee_id := p15_a17;
3983 ddp_service_request_rec.employee_number := p15_a18;
3984 ddp_service_request_rec.verify_cp_flag := p15_a19;
3985 ddp_service_request_rec.customer_product_id := p15_a20;
3986 ddp_service_request_rec.platform_id := p15_a21;
3987 ddp_service_request_rec.platform_version := p15_a22;
3988 ddp_service_request_rec.db_version := p15_a23;
3989 ddp_service_request_rec.platform_version_id := p15_a24;
3990 ddp_service_request_rec.cp_component_id := p15_a25;
3991 ddp_service_request_rec.cp_component_version_id := p15_a26;
3992 ddp_service_request_rec.cp_subcomponent_id := p15_a27;
3993 ddp_service_request_rec.cp_subcomponent_version_id := p15_a28;
3994 ddp_service_request_rec.language_id := p15_a29;
3995 ddp_service_request_rec.language := p15_a30;
3996 ddp_service_request_rec.cp_ref_number := p15_a31;
3997 ddp_service_request_rec.inventory_item_id := p15_a32;
3998 ddp_service_request_rec.inventory_item_conc_segs := p15_a33;
3999 ddp_service_request_rec.inventory_item_segment1 := p15_a34;
4000 ddp_service_request_rec.inventory_item_segment2 := p15_a35;
4001 ddp_service_request_rec.inventory_item_segment3 := p15_a36;
4002 ddp_service_request_rec.inventory_item_segment4 := p15_a37;
4003 ddp_service_request_rec.inventory_item_segment5 := p15_a38;
4004 ddp_service_request_rec.inventory_item_segment6 := p15_a39;
4005 ddp_service_request_rec.inventory_item_segment7 := p15_a40;
4006 ddp_service_request_rec.inventory_item_segment8 := p15_a41;
4007 ddp_service_request_rec.inventory_item_segment9 := p15_a42;
4008 ddp_service_request_rec.inventory_item_segment10 := p15_a43;
4009 ddp_service_request_rec.inventory_item_segment11 := p15_a44;
4010 ddp_service_request_rec.inventory_item_segment12 := p15_a45;
4011 ddp_service_request_rec.inventory_item_segment13 := p15_a46;
4012 ddp_service_request_rec.inventory_item_segment14 := p15_a47;
4013 ddp_service_request_rec.inventory_item_segment15 := p15_a48;
4014 ddp_service_request_rec.inventory_item_segment16 := p15_a49;
4015 ddp_service_request_rec.inventory_item_segment17 := p15_a50;
4016 ddp_service_request_rec.inventory_item_segment18 := p15_a51;
4017 ddp_service_request_rec.inventory_item_segment19 := p15_a52;
4018 ddp_service_request_rec.inventory_item_segment20 := p15_a53;
4019 ddp_service_request_rec.inventory_item_vals_or_ids := p15_a54;
4020 ddp_service_request_rec.inventory_org_id := p15_a55;
4021 ddp_service_request_rec.current_serial_number := p15_a56;
4022 ddp_service_request_rec.original_order_number := p15_a57;
4023 ddp_service_request_rec.purchase_order_num := p15_a58;
4024 ddp_service_request_rec.problem_code := p15_a59;
4025 ddp_service_request_rec.exp_resolution_date := rosetta_g_miss_date_in_map(p15_a60);
4026 ddp_service_request_rec.install_site_use_id := p15_a61;
4027 ddp_service_request_rec.request_attribute_1 := p15_a62;
4028 ddp_service_request_rec.request_attribute_2 := p15_a63;
4029 ddp_service_request_rec.request_attribute_3 := p15_a64;
4030 ddp_service_request_rec.request_attribute_4 := p15_a65;
4031 ddp_service_request_rec.request_attribute_5 := p15_a66;
4032 ddp_service_request_rec.request_attribute_6 := p15_a67;
4033 ddp_service_request_rec.request_attribute_7 := p15_a68;
4034 ddp_service_request_rec.request_attribute_8 := p15_a69;
4035 ddp_service_request_rec.request_attribute_9 := p15_a70;
4036 ddp_service_request_rec.request_attribute_10 := p15_a71;
4037 ddp_service_request_rec.request_attribute_11 := p15_a72;
4038 ddp_service_request_rec.request_attribute_12 := p15_a73;
4039 ddp_service_request_rec.request_attribute_13 := p15_a74;
4040 ddp_service_request_rec.request_attribute_14 := p15_a75;
4041 ddp_service_request_rec.request_attribute_15 := p15_a76;
4042 ddp_service_request_rec.request_context := p15_a77;
4043 ddp_service_request_rec.external_attribute_1 := p15_a78;
4044 ddp_service_request_rec.external_attribute_2 := p15_a79;
4045 ddp_service_request_rec.external_attribute_3 := p15_a80;
4046 ddp_service_request_rec.external_attribute_4 := p15_a81;
4047 ddp_service_request_rec.external_attribute_5 := p15_a82;
4048 ddp_service_request_rec.external_attribute_6 := p15_a83;
4049 ddp_service_request_rec.external_attribute_7 := p15_a84;
4050 ddp_service_request_rec.external_attribute_8 := p15_a85;
4051 ddp_service_request_rec.external_attribute_9 := p15_a86;
4052 ddp_service_request_rec.external_attribute_10 := p15_a87;
4053 ddp_service_request_rec.external_attribute_11 := p15_a88;
4054 ddp_service_request_rec.external_attribute_12 := p15_a89;
4055 ddp_service_request_rec.external_attribute_13 := p15_a90;
4056 ddp_service_request_rec.external_attribute_14 := p15_a91;
4057 ddp_service_request_rec.external_attribute_15 := p15_a92;
4058 ddp_service_request_rec.external_context := p15_a93;
4059 ddp_service_request_rec.bill_to_site_use_id := p15_a94;
4060 ddp_service_request_rec.bill_to_contact_id := p15_a95;
4061 ddp_service_request_rec.ship_to_site_use_id := p15_a96;
4062 ddp_service_request_rec.ship_to_contact_id := p15_a97;
4063 ddp_service_request_rec.resolution_code := p15_a98;
4064 ddp_service_request_rec.act_resolution_date := rosetta_g_miss_date_in_map(p15_a99);
4065 ddp_service_request_rec.public_comment_flag := p15_a100;
4066 ddp_service_request_rec.parent_interaction_id := p15_a101;
4067 ddp_service_request_rec.contract_service_id := p15_a102;
4068 ddp_service_request_rec.contract_service_number := p15_a103;
4069 ddp_service_request_rec.contract_id := p15_a104;
4070 ddp_service_request_rec.project_number := p15_a105;
4071 ddp_service_request_rec.qa_collection_plan_id := p15_a106;
4072 ddp_service_request_rec.account_id := p15_a107;
4073 ddp_service_request_rec.resource_type := p15_a108;
4074 ddp_service_request_rec.resource_subtype_id := p15_a109;
4075 ddp_service_request_rec.cust_po_number := p15_a110;
4076 ddp_service_request_rec.cust_ticket_number := p15_a111;
4077 ddp_service_request_rec.sr_creation_channel := p15_a112;
4078 ddp_service_request_rec.obligation_date := rosetta_g_miss_date_in_map(p15_a113);
4079 ddp_service_request_rec.time_zone_id := p15_a114;
4080 ddp_service_request_rec.time_difference := p15_a115;
4081 ddp_service_request_rec.site_id := p15_a116;
4082 ddp_service_request_rec.customer_site_id := p15_a117;
4083 ddp_service_request_rec.territory_id := p15_a118;
4084 ddp_service_request_rec.initialize_flag := p15_a119;
4085 ddp_service_request_rec.cp_revision_id := p15_a120;
4086 ddp_service_request_rec.inv_item_revision := p15_a121;
4087 ddp_service_request_rec.inv_component_id := p15_a122;
4088 ddp_service_request_rec.inv_component_version := p15_a123;
4089 ddp_service_request_rec.inv_subcomponent_id := p15_a124;
4090 ddp_service_request_rec.inv_subcomponent_version := p15_a125;
4091 ddp_service_request_rec.tier := p15_a126;
4092 ddp_service_request_rec.tier_version := p15_a127;
4093 ddp_service_request_rec.operating_system := p15_a128;
4094 ddp_service_request_rec.operating_system_version := p15_a129;
4095 ddp_service_request_rec.database := p15_a130;
4096 ddp_service_request_rec.cust_pref_lang_id := p15_a131;
4097 ddp_service_request_rec.category_id := p15_a132;
4098 ddp_service_request_rec.group_type := p15_a133;
4099 ddp_service_request_rec.group_territory_id := p15_a134;
4100 ddp_service_request_rec.inv_platform_org_id := p15_a135;
4101 ddp_service_request_rec.component_version := p15_a136;
4102 ddp_service_request_rec.subcomponent_version := p15_a137;
4103 ddp_service_request_rec.product_revision := p15_a138;
4104 ddp_service_request_rec.comm_pref_code := p15_a139;
4105 ddp_service_request_rec.cust_pref_lang_code := p15_a140;
4106 ddp_service_request_rec.last_update_channel := p15_a141;
4107 ddp_service_request_rec.category_set_id := p15_a142;
4108 ddp_service_request_rec.external_reference := p15_a143;
4109 ddp_service_request_rec.system_id := p15_a144;
4110 ddp_service_request_rec.error_code := p15_a145;
4111 ddp_service_request_rec.incident_occurred_date := rosetta_g_miss_date_in_map(p15_a146);
4112 ddp_service_request_rec.incident_resolved_date := rosetta_g_miss_date_in_map(p15_a147);
4113 ddp_service_request_rec.inc_responded_by_date := rosetta_g_miss_date_in_map(p15_a148);
4114 ddp_service_request_rec.resolution_summary := p15_a149;
4115 ddp_service_request_rec.incident_location_id := p15_a150;
4116 ddp_service_request_rec.incident_address := p15_a151;
4117 ddp_service_request_rec.incident_city := p15_a152;
4118 ddp_service_request_rec.incident_state := p15_a153;
4119 ddp_service_request_rec.incident_country := p15_a154;
4120 ddp_service_request_rec.incident_province := p15_a155;
4121 ddp_service_request_rec.incident_postal_code := p15_a156;
4122 ddp_service_request_rec.incident_county := p15_a157;
4123 ddp_service_request_rec.site_number := p15_a158;
4124 ddp_service_request_rec.site_name := p15_a159;
4125 ddp_service_request_rec.addressee := p15_a160;
4126 ddp_service_request_rec.owner := p15_a161;
4127 ddp_service_request_rec.group_owner := p15_a162;
4128 ddp_service_request_rec.cc_number := p15_a163;
4129 ddp_service_request_rec.cc_expiration_date := rosetta_g_miss_date_in_map(p15_a164);
4130 ddp_service_request_rec.cc_type_code := p15_a165;
4131 ddp_service_request_rec.cc_first_name := p15_a166;
4132 ddp_service_request_rec.cc_last_name := p15_a167;
4133 ddp_service_request_rec.cc_middle_name := p15_a168;
4134 ddp_service_request_rec.cc_id := p15_a169;
4135 ddp_service_request_rec.bill_to_account_id := p15_a170;
4136 ddp_service_request_rec.ship_to_account_id := p15_a171;
4137 ddp_service_request_rec.customer_phone_id := p15_a172;
4138 ddp_service_request_rec.customer_email_id := p15_a173;
4139 ddp_service_request_rec.creation_program_code := p15_a174;
4140 ddp_service_request_rec.last_update_program_code := p15_a175;
4141 ddp_service_request_rec.bill_to_party_id := p15_a176;
4142 ddp_service_request_rec.ship_to_party_id := p15_a177;
4143 ddp_service_request_rec.program_id := p15_a178;
4144 ddp_service_request_rec.program_application_id := p15_a179;
4145 ddp_service_request_rec.conc_request_id := p15_a180;
4146 ddp_service_request_rec.program_login_id := p15_a181;
4147 ddp_service_request_rec.bill_to_site_id := p15_a182;
4148 ddp_service_request_rec.ship_to_site_id := p15_a183;
4149 ddp_service_request_rec.incident_point_of_interest := p15_a184;
4150 ddp_service_request_rec.incident_cross_street := p15_a185;
4151 ddp_service_request_rec.incident_direction_qualifier := p15_a186;
4152 ddp_service_request_rec.incident_distance_qualifier := p15_a187;
4153 ddp_service_request_rec.incident_distance_qual_uom := p15_a188;
4154 ddp_service_request_rec.incident_address2 := p15_a189;
4155 ddp_service_request_rec.incident_address3 := p15_a190;
4156 ddp_service_request_rec.incident_address4 := p15_a191;
4157 ddp_service_request_rec.incident_address_style := p15_a192;
4158 ddp_service_request_rec.incident_addr_lines_phonetic := p15_a193;
4159 ddp_service_request_rec.incident_po_box_number := p15_a194;
4160 ddp_service_request_rec.incident_house_number := p15_a195;
4161 ddp_service_request_rec.incident_street_suffix := p15_a196;
4162 ddp_service_request_rec.incident_street := p15_a197;
4163 ddp_service_request_rec.incident_street_number := p15_a198;
4164 ddp_service_request_rec.incident_floor := p15_a199;
4165 ddp_service_request_rec.incident_suite := p15_a200;
4166 ddp_service_request_rec.incident_postal_plus4_code := p15_a201;
4167 ddp_service_request_rec.incident_position := p15_a202;
4168 ddp_service_request_rec.incident_location_directions := p15_a203;
4169 ddp_service_request_rec.incident_location_description := p15_a204;
4170 ddp_service_request_rec.install_site_id := p15_a205;
4171 ddp_service_request_rec.item_serial_number := p15_a206;
4172 ddp_service_request_rec.owning_department_id := p15_a207;
4173 ddp_service_request_rec.incident_location_type := p15_a208;
4174 ddp_service_request_rec.coverage_type := p15_a209;
4175 ddp_service_request_rec.maint_organization_id := p15_a210;
4176 ddp_service_request_rec.creation_date := rosetta_g_miss_date_in_map(p15_a211);
4177 ddp_service_request_rec.created_by := p15_a212;
4178 ddp_service_request_rec.instrument_payment_use_id := p15_a213;
4179 ddp_service_request_rec.project_id := p15_a214;
4180 ddp_service_request_rec.project_task_id := p15_a215;
4181 ddp_service_request_rec.expenditure_org_id := p15_a216;
4182 ddp_service_request_rec.sla_date_1 := rosetta_g_miss_date_in_map(p15_a217);
4183 ddp_service_request_rec.sla_date_2 := rosetta_g_miss_date_in_map(p15_a218);
4184 ddp_service_request_rec.sla_date_3 := rosetta_g_miss_date_in_map(p15_a219);
4185 ddp_service_request_rec.sla_date_4 := rosetta_g_miss_date_in_map(p15_a220);
4186 ddp_service_request_rec.sla_date_5 := rosetta_g_miss_date_in_map(p15_a221);
4187 ddp_service_request_rec.sla_date_6 := rosetta_g_miss_date_in_map(p15_a222);
4188 ddp_service_request_rec.sla_duration_1 := p15_a223;
4189 ddp_service_request_rec.sla_duration_2 := p15_a224;
4190 ddp_service_request_rec.price_list_header_id := p15_a225;
4191
4192 cs_servicerequest_pub_w.rosetta_table_copy_in_p1(ddp_notes, p16_a0
4193 , p16_a1
4194 , p16_a2
4195 , p16_a3
4196 , p16_a4
4197 , p16_a5
4198 , p16_a6
4199 , p16_a7
4200 , p16_a8
4201 );
4202
4203 cs_servicerequest_pub_w.rosetta_table_copy_in_p3(ddp_contacts, p17_a0
4204 , p17_a1
4205 , p17_a2
4206 , p17_a3
4207 , p17_a4
4208 , p17_a5
4209 , p17_a6
4210 , p17_a7
4211 , p17_a8
4212 );
4213
4214
4215
4216
4217
4218
4219 -- here's the delegated call to the old PL/SQL routine
4220 cs_servicerequest_pub.update_servicerequest(p_api_version,
4221 p_init_msg_list,
4222 p_commit,
4223 x_return_status,
4224 x_msg_count,
4225 x_msg_data,
4226 p_request_id,
4227 p_request_number,
4228 p_audit_comments,
4229 p_object_version_number,
4230 p_resp_appl_id,
4231 p_resp_id,
4232 p_last_updated_by,
4233 p_last_update_login,
4234 ddp_last_update_date,
4235 ddp_service_request_rec,
4236 ddp_notes,
4237 ddp_contacts,
4238 p_called_by_workflow,
4239 p_workflow_process_id,
4240 p_default_contract_sla_ind,
4241 x_workflow_process_id,
4242 x_interaction_id);
4243
4244 -- copy data back from the local variables to OUT or IN-OUT args, if any
4245
4246
4247
4248
4249
4250
4251
4252
4253
4254
4255
4256
4257
4258
4259
4260
4261
4262
4263
4264
4265
4266
4267 end;
4268
4269 procedure update_status(p_api_version NUMBER
4270 , p_init_msg_list VARCHAR2
4271 , p_commit VARCHAR2
4272 , x_return_status out nocopy VARCHAR2
4273 , x_msg_count out nocopy NUMBER
4274 , x_msg_data out nocopy VARCHAR2
4275 , p_resp_appl_id NUMBER
4276 , p_resp_id NUMBER
4277 , p_user_id NUMBER
4278 , p_login_id NUMBER
4279 , p_request_id NUMBER
4280 , p_request_number VARCHAR2
4281 , p_object_version_number NUMBER
4282 , p_status_id NUMBER
4283 , p_status VARCHAR2
4284 , p_closed_date date
4285 , p_audit_comments VARCHAR2
4286 , p_called_by_workflow VARCHAR2
4287 , p_workflow_process_id NUMBER
4288 , p_comments VARCHAR2
4289 , p_public_comment_flag VARCHAR2
4290 , p_validate_sr_closure VARCHAR2
4291 , p_auto_close_child_entities VARCHAR2
4292 , p_auto_generate_tasks VARCHAR2
4293 , x_interaction_id out nocopy NUMBER
4294 )
4295
4296 as
4297 ddp_closed_date date;
4298 ddindx binary_integer; indx binary_integer;
4299 begin
4300
4301 -- copy data to the local IN or IN-OUT args, if any
4302
4303
4304
4305
4306
4307
4308
4309
4310
4311
4312
4313
4314
4315
4316
4317 ddp_closed_date := rosetta_g_miss_date_in_map(p_closed_date);
4318
4319
4320
4321
4322
4323
4324
4325
4326
4327
4328 -- here's the delegated call to the old PL/SQL routine
4329 cs_servicerequest_pub.update_status(p_api_version,
4330 p_init_msg_list,
4331 p_commit,
4332 x_return_status,
4333 x_msg_count,
4334 x_msg_data,
4335 p_resp_appl_id,
4336 p_resp_id,
4337 p_user_id,
4338 p_login_id,
4339 p_request_id,
4340 p_request_number,
4341 p_object_version_number,
4342 p_status_id,
4343 p_status,
4344 ddp_closed_date,
4345 p_audit_comments,
4346 p_called_by_workflow,
4347 p_workflow_process_id,
4348 p_comments,
4349 p_public_comment_flag,
4350 p_validate_sr_closure,
4351 p_auto_close_child_entities,
4352 p_auto_generate_tasks,
4353 x_interaction_id);
4354
4355 -- copy data back from the local variables to OUT or IN-OUT args, if any
4356
4357
4358
4359
4360
4361
4362
4363
4364
4365
4366
4367
4368
4369
4370
4371
4372
4373
4374
4375
4376
4377
4378
4379
4380 end;
4381
4382 procedure create_servicerequest(p_api_version NUMBER
4383 , p_init_msg_list VARCHAR2
4384 , p_commit VARCHAR2
4385 , x_return_status out nocopy VARCHAR2
4386 , x_msg_count out nocopy NUMBER
4387 , x_msg_data out nocopy VARCHAR2
4388 , p_resp_appl_id NUMBER
4389 , p_resp_id NUMBER
4390 , p_user_id NUMBER
4391 , p_login_id NUMBER
4392 , p_org_id NUMBER
4393 , p_request_id NUMBER
4394 , p_request_number VARCHAR2
4395 , p13_a0 DATE
4396 , p13_a1 NUMBER
4397 , p13_a2 VARCHAR2
4398 , p13_a3 NUMBER
4399 , p13_a4 VARCHAR2
4400 , p13_a5 NUMBER
4401 , p13_a6 VARCHAR2
4402 , p13_a7 NUMBER
4403 , p13_a8 VARCHAR2
4404 , p13_a9 DATE
4405 , p13_a10 NUMBER
4406 , p13_a11 NUMBER
4407 , p13_a12 VARCHAR2
4408 , p13_a13 VARCHAR2
4409 , p13_a14 VARCHAR2
4410 , p13_a15 NUMBER
4411 , p13_a16 VARCHAR2
4412 , p13_a17 NUMBER
4413 , p13_a18 VARCHAR2
4414 , p13_a19 VARCHAR2
4415 , p13_a20 NUMBER
4416 , p13_a21 NUMBER
4417 , p13_a22 VARCHAR2
4418 , p13_a23 VARCHAR2
4419 , p13_a24 NUMBER
4420 , p13_a25 NUMBER
4421 , p13_a26 NUMBER
4422 , p13_a27 NUMBER
4423 , p13_a28 NUMBER
4424 , p13_a29 NUMBER
4425 , p13_a30 VARCHAR2
4426 , p13_a31 NUMBER
4427 , p13_a32 NUMBER
4428 , p13_a33 VARCHAR2
4429 , p13_a34 VARCHAR2
4430 , p13_a35 VARCHAR2
4431 , p13_a36 VARCHAR2
4432 , p13_a37 VARCHAR2
4433 , p13_a38 VARCHAR2
4434 , p13_a39 VARCHAR2
4435 , p13_a40 VARCHAR2
4436 , p13_a41 VARCHAR2
4437 , p13_a42 VARCHAR2
4438 , p13_a43 VARCHAR2
4439 , p13_a44 VARCHAR2
4440 , p13_a45 VARCHAR2
4441 , p13_a46 VARCHAR2
4442 , p13_a47 VARCHAR2
4443 , p13_a48 VARCHAR2
4444 , p13_a49 VARCHAR2
4445 , p13_a50 VARCHAR2
4446 , p13_a51 VARCHAR2
4447 , p13_a52 VARCHAR2
4448 , p13_a53 VARCHAR2
4449 , p13_a54 VARCHAR2
4450 , p13_a55 NUMBER
4451 , p13_a56 VARCHAR2
4452 , p13_a57 NUMBER
4453 , p13_a58 VARCHAR2
4454 , p13_a59 VARCHAR2
4455 , p13_a60 DATE
4456 , p13_a61 NUMBER
4457 , p13_a62 VARCHAR2
4458 , p13_a63 VARCHAR2
4459 , p13_a64 VARCHAR2
4460 , p13_a65 VARCHAR2
4461 , p13_a66 VARCHAR2
4462 , p13_a67 VARCHAR2
4463 , p13_a68 VARCHAR2
4464 , p13_a69 VARCHAR2
4465 , p13_a70 VARCHAR2
4466 , p13_a71 VARCHAR2
4467 , p13_a72 VARCHAR2
4468 , p13_a73 VARCHAR2
4469 , p13_a74 VARCHAR2
4470 , p13_a75 VARCHAR2
4471 , p13_a76 VARCHAR2
4472 , p13_a77 VARCHAR2
4473 , p13_a78 VARCHAR2
4474 , p13_a79 VARCHAR2
4475 , p13_a80 VARCHAR2
4476 , p13_a81 VARCHAR2
4477 , p13_a82 VARCHAR2
4478 , p13_a83 VARCHAR2
4479 , p13_a84 VARCHAR2
4480 , p13_a85 VARCHAR2
4481 , p13_a86 VARCHAR2
4482 , p13_a87 VARCHAR2
4483 , p13_a88 VARCHAR2
4484 , p13_a89 VARCHAR2
4485 , p13_a90 VARCHAR2
4486 , p13_a91 VARCHAR2
4487 , p13_a92 VARCHAR2
4488 , p13_a93 VARCHAR2
4489 , p13_a94 NUMBER
4490 , p13_a95 NUMBER
4491 , p13_a96 NUMBER
4492 , p13_a97 NUMBER
4493 , p13_a98 VARCHAR2
4494 , p13_a99 DATE
4495 , p13_a100 VARCHAR2
4496 , p13_a101 NUMBER
4497 , p13_a102 NUMBER
4498 , p13_a103 VARCHAR2
4499 , p13_a104 NUMBER
4500 , p13_a105 VARCHAR2
4501 , p13_a106 NUMBER
4502 , p13_a107 NUMBER
4503 , p13_a108 VARCHAR2
4504 , p13_a109 NUMBER
4505 , p13_a110 VARCHAR2
4506 , p13_a111 VARCHAR2
4507 , p13_a112 VARCHAR2
4508 , p13_a113 DATE
4509 , p13_a114 NUMBER
4510 , p13_a115 NUMBER
4511 , p13_a116 NUMBER
4512 , p13_a117 NUMBER
4513 , p13_a118 NUMBER
4514 , p13_a119 VARCHAR2
4515 , p13_a120 NUMBER
4516 , p13_a121 VARCHAR2
4517 , p13_a122 NUMBER
4518 , p13_a123 VARCHAR2
4519 , p13_a124 NUMBER
4520 , p13_a125 VARCHAR2
4521 , p13_a126 VARCHAR2
4522 , p13_a127 VARCHAR2
4523 , p13_a128 VARCHAR2
4524 , p13_a129 VARCHAR2
4525 , p13_a130 VARCHAR2
4526 , p13_a131 NUMBER
4527 , p13_a132 NUMBER
4528 , p13_a133 VARCHAR2
4529 , p13_a134 NUMBER
4530 , p13_a135 NUMBER
4531 , p13_a136 VARCHAR2
4532 , p13_a137 VARCHAR2
4533 , p13_a138 VARCHAR2
4534 , p13_a139 VARCHAR2
4535 , p13_a140 VARCHAR2
4536 , p13_a141 VARCHAR2
4537 , p13_a142 NUMBER
4538 , p13_a143 VARCHAR2
4539 , p13_a144 NUMBER
4540 , p13_a145 VARCHAR2
4541 , p13_a146 DATE
4542 , p13_a147 DATE
4543 , p13_a148 DATE
4544 , p13_a149 VARCHAR2
4545 , p13_a150 NUMBER
4546 , p13_a151 VARCHAR2
4547 , p13_a152 VARCHAR2
4548 , p13_a153 VARCHAR2
4549 , p13_a154 VARCHAR2
4550 , p13_a155 VARCHAR2
4551 , p13_a156 VARCHAR2
4552 , p13_a157 VARCHAR2
4553 , p13_a158 VARCHAR2
4554 , p13_a159 VARCHAR2
4555 , p13_a160 VARCHAR2
4556 , p13_a161 VARCHAR2
4557 , p13_a162 VARCHAR2
4558 , p13_a163 VARCHAR2
4559 , p13_a164 DATE
4560 , p13_a165 VARCHAR
4561 , p13_a166 VARCHAR
4562 , p13_a167 VARCHAR
4563 , p13_a168 VARCHAR
4564 , p13_a169 NUMBER
4565 , p13_a170 NUMBER
4566 , p13_a171 NUMBER
4567 , p13_a172 NUMBER
4568 , p13_a173 NUMBER
4569 , p13_a174 VARCHAR2
4570 , p13_a175 VARCHAR2
4571 , p13_a176 NUMBER
4572 , p13_a177 NUMBER
4573 , p13_a178 NUMBER
4574 , p13_a179 NUMBER
4575 , p13_a180 NUMBER
4576 , p13_a181 NUMBER
4577 , p13_a182 NUMBER
4578 , p13_a183 NUMBER
4579 , p13_a184 VARCHAR2
4580 , p13_a185 VARCHAR2
4581 , p13_a186 VARCHAR2
4582 , p13_a187 VARCHAR2
4583 , p13_a188 VARCHAR2
4584 , p13_a189 VARCHAR2
4585 , p13_a190 VARCHAR2
4586 , p13_a191 VARCHAR2
4587 , p13_a192 VARCHAR2
4588 , p13_a193 VARCHAR2
4589 , p13_a194 VARCHAR2
4590 , p13_a195 VARCHAR2
4591 , p13_a196 VARCHAR2
4592 , p13_a197 VARCHAR2
4593 , p13_a198 VARCHAR2
4594 , p13_a199 VARCHAR2
4595 , p13_a200 VARCHAR2
4596 , p13_a201 VARCHAR2
4597 , p13_a202 VARCHAR2
4598 , p13_a203 VARCHAR2
4599 , p13_a204 VARCHAR2
4600 , p13_a205 NUMBER
4601 , p13_a206 VARCHAR2
4602 , p13_a207 NUMBER
4603 , p13_a208 VARCHAR2
4604 , p13_a209 VARCHAR2
4605 , p13_a210 NUMBER
4606 , p13_a211 DATE
4607 , p13_a212 NUMBER
4608 , p13_a213 NUMBER
4609 , p13_a214 NUMBER
4610 , p13_a215 NUMBER
4611 , p13_a216 NUMBER
4612 , p13_a217 DATE
4613 , p13_a218 DATE
4614 , p13_a219 DATE
4615 , p13_a220 DATE
4616 , p13_a221 DATE
4617 , p13_a222 DATE
4618 , p13_a223 NUMBER
4619 , p13_a224 NUMBER
4620 , p13_a225 NUMBER
4621 , p14_a0 JTF_VARCHAR2_TABLE_2000
4622 , p14_a1 JTF_VARCHAR2_TABLE_32767
4623 , p14_a2 JTF_VARCHAR2_TABLE_300
4624 , p14_a3 JTF_VARCHAR2_TABLE_100
4625 , p14_a4 JTF_NUMBER_TABLE
4626 , p14_a5 JTF_VARCHAR2_TABLE_100
4627 , p14_a6 JTF_NUMBER_TABLE
4628 , p14_a7 JTF_VARCHAR2_TABLE_100
4629 , p14_a8 JTF_NUMBER_TABLE
4630 , p15_a0 JTF_NUMBER_TABLE
4631 , p15_a1 JTF_NUMBER_TABLE
4632 , p15_a2 JTF_NUMBER_TABLE
4633 , p15_a3 JTF_VARCHAR2_TABLE_100
4634 , p15_a4 JTF_VARCHAR2_TABLE_100
4635 , p15_a5 JTF_VARCHAR2_TABLE_100
4636 , p15_a6 JTF_VARCHAR2_TABLE_100
4637 , p15_a7 JTF_DATE_TABLE
4638 , p15_a8 JTF_DATE_TABLE
4639 , p_default_contract_sla_ind VARCHAR2
4640 , x_request_id out nocopy NUMBER
4641 , x_request_number out nocopy VARCHAR2
4642 , x_interaction_id out nocopy NUMBER
4643 , x_workflow_process_id out nocopy NUMBER
4644 )
4645
4646 as
4647 ddp_service_request_rec cs_servicerequest_pub.service_request_rec_type;
4648 ddp_notes cs_servicerequest_pub.notes_table;
4649 ddp_contacts cs_servicerequest_pub.contacts_table;
4650 ddindx binary_integer; indx binary_integer;
4651 begin
4652
4653 -- copy data to the local IN or IN-OUT args, if any
4654
4655
4656
4657
4658
4659
4660
4661
4662
4663
4664
4665
4666
4667 ddp_service_request_rec.request_date := rosetta_g_miss_date_in_map(p13_a0);
4668 ddp_service_request_rec.type_id := p13_a1;
4669 ddp_service_request_rec.type_name := p13_a2;
4670 ddp_service_request_rec.status_id := p13_a3;
4671 ddp_service_request_rec.status_name := p13_a4;
4672 ddp_service_request_rec.severity_id := p13_a5;
4673 ddp_service_request_rec.severity_name := p13_a6;
4674 ddp_service_request_rec.urgency_id := p13_a7;
4675 ddp_service_request_rec.urgency_name := p13_a8;
4676 ddp_service_request_rec.closed_date := rosetta_g_miss_date_in_map(p13_a9);
4677 ddp_service_request_rec.owner_id := p13_a10;
4678 ddp_service_request_rec.owner_group_id := p13_a11;
4679 ddp_service_request_rec.publish_flag := p13_a12;
4680 ddp_service_request_rec.summary := p13_a13;
4681 ddp_service_request_rec.caller_type := p13_a14;
4682 ddp_service_request_rec.customer_id := p13_a15;
4683 ddp_service_request_rec.customer_number := p13_a16;
4684 ddp_service_request_rec.employee_id := p13_a17;
4685 ddp_service_request_rec.employee_number := p13_a18;
4686 ddp_service_request_rec.verify_cp_flag := p13_a19;
4687 ddp_service_request_rec.customer_product_id := p13_a20;
4688 ddp_service_request_rec.platform_id := p13_a21;
4689 ddp_service_request_rec.platform_version := p13_a22;
4690 ddp_service_request_rec.db_version := p13_a23;
4691 ddp_service_request_rec.platform_version_id := p13_a24;
4692 ddp_service_request_rec.cp_component_id := p13_a25;
4693 ddp_service_request_rec.cp_component_version_id := p13_a26;
4694 ddp_service_request_rec.cp_subcomponent_id := p13_a27;
4695 ddp_service_request_rec.cp_subcomponent_version_id := p13_a28;
4696 ddp_service_request_rec.language_id := p13_a29;
4697 ddp_service_request_rec.language := p13_a30;
4698 ddp_service_request_rec.cp_ref_number := p13_a31;
4699 ddp_service_request_rec.inventory_item_id := p13_a32;
4700 ddp_service_request_rec.inventory_item_conc_segs := p13_a33;
4701 ddp_service_request_rec.inventory_item_segment1 := p13_a34;
4702 ddp_service_request_rec.inventory_item_segment2 := p13_a35;
4703 ddp_service_request_rec.inventory_item_segment3 := p13_a36;
4704 ddp_service_request_rec.inventory_item_segment4 := p13_a37;
4705 ddp_service_request_rec.inventory_item_segment5 := p13_a38;
4706 ddp_service_request_rec.inventory_item_segment6 := p13_a39;
4707 ddp_service_request_rec.inventory_item_segment7 := p13_a40;
4708 ddp_service_request_rec.inventory_item_segment8 := p13_a41;
4709 ddp_service_request_rec.inventory_item_segment9 := p13_a42;
4710 ddp_service_request_rec.inventory_item_segment10 := p13_a43;
4711 ddp_service_request_rec.inventory_item_segment11 := p13_a44;
4712 ddp_service_request_rec.inventory_item_segment12 := p13_a45;
4713 ddp_service_request_rec.inventory_item_segment13 := p13_a46;
4714 ddp_service_request_rec.inventory_item_segment14 := p13_a47;
4715 ddp_service_request_rec.inventory_item_segment15 := p13_a48;
4716 ddp_service_request_rec.inventory_item_segment16 := p13_a49;
4717 ddp_service_request_rec.inventory_item_segment17 := p13_a50;
4718 ddp_service_request_rec.inventory_item_segment18 := p13_a51;
4719 ddp_service_request_rec.inventory_item_segment19 := p13_a52;
4720 ddp_service_request_rec.inventory_item_segment20 := p13_a53;
4721 ddp_service_request_rec.inventory_item_vals_or_ids := p13_a54;
4722 ddp_service_request_rec.inventory_org_id := p13_a55;
4723 ddp_service_request_rec.current_serial_number := p13_a56;
4724 ddp_service_request_rec.original_order_number := p13_a57;
4725 ddp_service_request_rec.purchase_order_num := p13_a58;
4726 ddp_service_request_rec.problem_code := p13_a59;
4727 ddp_service_request_rec.exp_resolution_date := rosetta_g_miss_date_in_map(p13_a60);
4728 ddp_service_request_rec.install_site_use_id := p13_a61;
4729 ddp_service_request_rec.request_attribute_1 := p13_a62;
4730 ddp_service_request_rec.request_attribute_2 := p13_a63;
4731 ddp_service_request_rec.request_attribute_3 := p13_a64;
4732 ddp_service_request_rec.request_attribute_4 := p13_a65;
4733 ddp_service_request_rec.request_attribute_5 := p13_a66;
4734 ddp_service_request_rec.request_attribute_6 := p13_a67;
4735 ddp_service_request_rec.request_attribute_7 := p13_a68;
4736 ddp_service_request_rec.request_attribute_8 := p13_a69;
4737 ddp_service_request_rec.request_attribute_9 := p13_a70;
4738 ddp_service_request_rec.request_attribute_10 := p13_a71;
4739 ddp_service_request_rec.request_attribute_11 := p13_a72;
4740 ddp_service_request_rec.request_attribute_12 := p13_a73;
4741 ddp_service_request_rec.request_attribute_13 := p13_a74;
4742 ddp_service_request_rec.request_attribute_14 := p13_a75;
4743 ddp_service_request_rec.request_attribute_15 := p13_a76;
4744 ddp_service_request_rec.request_context := p13_a77;
4745 ddp_service_request_rec.external_attribute_1 := p13_a78;
4746 ddp_service_request_rec.external_attribute_2 := p13_a79;
4747 ddp_service_request_rec.external_attribute_3 := p13_a80;
4748 ddp_service_request_rec.external_attribute_4 := p13_a81;
4749 ddp_service_request_rec.external_attribute_5 := p13_a82;
4750 ddp_service_request_rec.external_attribute_6 := p13_a83;
4751 ddp_service_request_rec.external_attribute_7 := p13_a84;
4752 ddp_service_request_rec.external_attribute_8 := p13_a85;
4753 ddp_service_request_rec.external_attribute_9 := p13_a86;
4754 ddp_service_request_rec.external_attribute_10 := p13_a87;
4755 ddp_service_request_rec.external_attribute_11 := p13_a88;
4756 ddp_service_request_rec.external_attribute_12 := p13_a89;
4757 ddp_service_request_rec.external_attribute_13 := p13_a90;
4758 ddp_service_request_rec.external_attribute_14 := p13_a91;
4759 ddp_service_request_rec.external_attribute_15 := p13_a92;
4760 ddp_service_request_rec.external_context := p13_a93;
4761 ddp_service_request_rec.bill_to_site_use_id := p13_a94;
4762 ddp_service_request_rec.bill_to_contact_id := p13_a95;
4763 ddp_service_request_rec.ship_to_site_use_id := p13_a96;
4764 ddp_service_request_rec.ship_to_contact_id := p13_a97;
4765 ddp_service_request_rec.resolution_code := p13_a98;
4766 ddp_service_request_rec.act_resolution_date := rosetta_g_miss_date_in_map(p13_a99);
4767 ddp_service_request_rec.public_comment_flag := p13_a100;
4768 ddp_service_request_rec.parent_interaction_id := p13_a101;
4769 ddp_service_request_rec.contract_service_id := p13_a102;
4770 ddp_service_request_rec.contract_service_number := p13_a103;
4771 ddp_service_request_rec.contract_id := p13_a104;
4772 ddp_service_request_rec.project_number := p13_a105;
4773 ddp_service_request_rec.qa_collection_plan_id := p13_a106;
4774 ddp_service_request_rec.account_id := p13_a107;
4775 ddp_service_request_rec.resource_type := p13_a108;
4776 ddp_service_request_rec.resource_subtype_id := p13_a109;
4777 ddp_service_request_rec.cust_po_number := p13_a110;
4778 ddp_service_request_rec.cust_ticket_number := p13_a111;
4779 ddp_service_request_rec.sr_creation_channel := p13_a112;
4780 ddp_service_request_rec.obligation_date := rosetta_g_miss_date_in_map(p13_a113);
4781 ddp_service_request_rec.time_zone_id := p13_a114;
4782 ddp_service_request_rec.time_difference := p13_a115;
4783 ddp_service_request_rec.site_id := p13_a116;
4784 ddp_service_request_rec.customer_site_id := p13_a117;
4785 ddp_service_request_rec.territory_id := p13_a118;
4786 ddp_service_request_rec.initialize_flag := p13_a119;
4787 ddp_service_request_rec.cp_revision_id := p13_a120;
4788 ddp_service_request_rec.inv_item_revision := p13_a121;
4789 ddp_service_request_rec.inv_component_id := p13_a122;
4790 ddp_service_request_rec.inv_component_version := p13_a123;
4791 ddp_service_request_rec.inv_subcomponent_id := p13_a124;
4792 ddp_service_request_rec.inv_subcomponent_version := p13_a125;
4793 ddp_service_request_rec.tier := p13_a126;
4794 ddp_service_request_rec.tier_version := p13_a127;
4795 ddp_service_request_rec.operating_system := p13_a128;
4796 ddp_service_request_rec.operating_system_version := p13_a129;
4797 ddp_service_request_rec.database := p13_a130;
4798 ddp_service_request_rec.cust_pref_lang_id := p13_a131;
4799 ddp_service_request_rec.category_id := p13_a132;
4800 ddp_service_request_rec.group_type := p13_a133;
4801 ddp_service_request_rec.group_territory_id := p13_a134;
4802 ddp_service_request_rec.inv_platform_org_id := p13_a135;
4803 ddp_service_request_rec.component_version := p13_a136;
4804 ddp_service_request_rec.subcomponent_version := p13_a137;
4805 ddp_service_request_rec.product_revision := p13_a138;
4806 ddp_service_request_rec.comm_pref_code := p13_a139;
4807 ddp_service_request_rec.cust_pref_lang_code := p13_a140;
4808 ddp_service_request_rec.last_update_channel := p13_a141;
4809 ddp_service_request_rec.category_set_id := p13_a142;
4810 ddp_service_request_rec.external_reference := p13_a143;
4811 ddp_service_request_rec.system_id := p13_a144;
4812 ddp_service_request_rec.error_code := p13_a145;
4813 ddp_service_request_rec.incident_occurred_date := rosetta_g_miss_date_in_map(p13_a146);
4814 ddp_service_request_rec.incident_resolved_date := rosetta_g_miss_date_in_map(p13_a147);
4815 ddp_service_request_rec.inc_responded_by_date := rosetta_g_miss_date_in_map(p13_a148);
4816 ddp_service_request_rec.resolution_summary := p13_a149;
4817 ddp_service_request_rec.incident_location_id := p13_a150;
4818 ddp_service_request_rec.incident_address := p13_a151;
4819 ddp_service_request_rec.incident_city := p13_a152;
4820 ddp_service_request_rec.incident_state := p13_a153;
4821 ddp_service_request_rec.incident_country := p13_a154;
4822 ddp_service_request_rec.incident_province := p13_a155;
4823 ddp_service_request_rec.incident_postal_code := p13_a156;
4824 ddp_service_request_rec.incident_county := p13_a157;
4825 ddp_service_request_rec.site_number := p13_a158;
4826 ddp_service_request_rec.site_name := p13_a159;
4827 ddp_service_request_rec.addressee := p13_a160;
4828 ddp_service_request_rec.owner := p13_a161;
4829 ddp_service_request_rec.group_owner := p13_a162;
4830 ddp_service_request_rec.cc_number := p13_a163;
4831 ddp_service_request_rec.cc_expiration_date := rosetta_g_miss_date_in_map(p13_a164);
4832 ddp_service_request_rec.cc_type_code := p13_a165;
4833 ddp_service_request_rec.cc_first_name := p13_a166;
4834 ddp_service_request_rec.cc_last_name := p13_a167;
4835 ddp_service_request_rec.cc_middle_name := p13_a168;
4836 ddp_service_request_rec.cc_id := p13_a169;
4837 ddp_service_request_rec.bill_to_account_id := p13_a170;
4838 ddp_service_request_rec.ship_to_account_id := p13_a171;
4839 ddp_service_request_rec.customer_phone_id := p13_a172;
4840 ddp_service_request_rec.customer_email_id := p13_a173;
4841 ddp_service_request_rec.creation_program_code := p13_a174;
4842 ddp_service_request_rec.last_update_program_code := p13_a175;
4843 ddp_service_request_rec.bill_to_party_id := p13_a176;
4844 ddp_service_request_rec.ship_to_party_id := p13_a177;
4845 ddp_service_request_rec.program_id := p13_a178;
4846 ddp_service_request_rec.program_application_id := p13_a179;
4847 ddp_service_request_rec.conc_request_id := p13_a180;
4848 ddp_service_request_rec.program_login_id := p13_a181;
4849 ddp_service_request_rec.bill_to_site_id := p13_a182;
4850 ddp_service_request_rec.ship_to_site_id := p13_a183;
4851 ddp_service_request_rec.incident_point_of_interest := p13_a184;
4852 ddp_service_request_rec.incident_cross_street := p13_a185;
4853 ddp_service_request_rec.incident_direction_qualifier := p13_a186;
4854 ddp_service_request_rec.incident_distance_qualifier := p13_a187;
4855 ddp_service_request_rec.incident_distance_qual_uom := p13_a188;
4856 ddp_service_request_rec.incident_address2 := p13_a189;
4857 ddp_service_request_rec.incident_address3 := p13_a190;
4858 ddp_service_request_rec.incident_address4 := p13_a191;
4859 ddp_service_request_rec.incident_address_style := p13_a192;
4860 ddp_service_request_rec.incident_addr_lines_phonetic := p13_a193;
4861 ddp_service_request_rec.incident_po_box_number := p13_a194;
4862 ddp_service_request_rec.incident_house_number := p13_a195;
4863 ddp_service_request_rec.incident_street_suffix := p13_a196;
4864 ddp_service_request_rec.incident_street := p13_a197;
4865 ddp_service_request_rec.incident_street_number := p13_a198;
4866 ddp_service_request_rec.incident_floor := p13_a199;
4867 ddp_service_request_rec.incident_suite := p13_a200;
4868 ddp_service_request_rec.incident_postal_plus4_code := p13_a201;
4869 ddp_service_request_rec.incident_position := p13_a202;
4870 ddp_service_request_rec.incident_location_directions := p13_a203;
4871 ddp_service_request_rec.incident_location_description := p13_a204;
4872 ddp_service_request_rec.install_site_id := p13_a205;
4873 ddp_service_request_rec.item_serial_number := p13_a206;
4874 ddp_service_request_rec.owning_department_id := p13_a207;
4875 ddp_service_request_rec.incident_location_type := p13_a208;
4876 ddp_service_request_rec.coverage_type := p13_a209;
4877 ddp_service_request_rec.maint_organization_id := p13_a210;
4878 ddp_service_request_rec.creation_date := rosetta_g_miss_date_in_map(p13_a211);
4879 ddp_service_request_rec.created_by := p13_a212;
4880 ddp_service_request_rec.instrument_payment_use_id := p13_a213;
4881 ddp_service_request_rec.project_id := p13_a214;
4882 ddp_service_request_rec.project_task_id := p13_a215;
4883 ddp_service_request_rec.expenditure_org_id := p13_a216;
4884 ddp_service_request_rec.sla_date_1 := rosetta_g_miss_date_in_map(p13_a217);
4885 ddp_service_request_rec.sla_date_2 := rosetta_g_miss_date_in_map(p13_a218);
4886 ddp_service_request_rec.sla_date_3 := rosetta_g_miss_date_in_map(p13_a219);
4887 ddp_service_request_rec.sla_date_4 := rosetta_g_miss_date_in_map(p13_a220);
4888 ddp_service_request_rec.sla_date_5 := rosetta_g_miss_date_in_map(p13_a221);
4889 ddp_service_request_rec.sla_date_6 := rosetta_g_miss_date_in_map(p13_a222);
4890 ddp_service_request_rec.sla_duration_1 := p13_a223;
4891 ddp_service_request_rec.sla_duration_2 := p13_a224;
4892 ddp_service_request_rec.price_list_header_id := p13_a225;
4893
4894 cs_servicerequest_pub_w.rosetta_table_copy_in_p1(ddp_notes, p14_a0
4895 , p14_a1
4896 , p14_a2
4897 , p14_a3
4898 , p14_a4
4899 , p14_a5
4900 , p14_a6
4901 , p14_a7
4902 , p14_a8
4903 );
4904
4905 cs_servicerequest_pub_w.rosetta_table_copy_in_p3(ddp_contacts, p15_a0
4906 , p15_a1
4907 , p15_a2
4908 , p15_a3
4909 , p15_a4
4910 , p15_a5
4911 , p15_a6
4912 , p15_a7
4913 , p15_a8
4914 );
4915
4916
4917
4918
4919
4920
4921 -- here's the delegated call to the old PL/SQL routine
4922 cs_servicerequest_pub.create_servicerequest(p_api_version,
4923 p_init_msg_list,
4924 p_commit,
4925 x_return_status,
4926 x_msg_count,
4927 x_msg_data,
4928 p_resp_appl_id,
4929 p_resp_id,
4930 p_user_id,
4931 p_login_id,
4932 p_org_id,
4933 p_request_id,
4934 p_request_number,
4935 ddp_service_request_rec,
4936 ddp_notes,
4937 ddp_contacts,
4938 p_default_contract_sla_ind,
4939 x_request_id,
4940 x_request_number,
4941 x_interaction_id,
4942 x_workflow_process_id);
4943
4944 -- copy data back from the local variables to OUT or IN-OUT args, if any
4945
4946
4947
4948
4949
4950
4951
4952
4953
4954
4955
4956
4957
4958
4959
4960
4961
4962
4963
4964
4965 end;
4966
4967 procedure process_sr_ext_attrs(p_api_version NUMBER
4968 , p_init_msg_list VARCHAR2
4969 , p_commit VARCHAR2
4970 , p_incident_id NUMBER
4971 , p4_a0 JTF_NUMBER_TABLE
4972 , p4_a1 JTF_VARCHAR2_TABLE_200
4973 , p4_a2 JTF_VARCHAR2_TABLE_200
4974 , p4_a3 JTF_VARCHAR2_TABLE_200
4975 , p4_a4 JTF_VARCHAR2_TABLE_200
4976 , p4_a5 JTF_VARCHAR2_TABLE_200
4977 , p4_a6 JTF_VARCHAR2_TABLE_200
4978 , p4_a7 JTF_VARCHAR2_TABLE_100
4979 , p4_a8 JTF_NUMBER_TABLE
4980 , p4_a9 JTF_NUMBER_TABLE
4981 , p4_a10 JTF_VARCHAR2_TABLE_100
4982 , p4_a11 JTF_VARCHAR2_TABLE_100
4983 , p4_a12 JTF_VARCHAR2_TABLE_200
4984 , p4_a13 JTF_VARCHAR2_TABLE_100
4985 , p4_a14 JTF_VARCHAR2_TABLE_100
4986 , p5_a0 JTF_NUMBER_TABLE
4987 , p5_a1 JTF_VARCHAR2_TABLE_100
4988 , p5_a2 JTF_VARCHAR2_TABLE_200
4989 , p5_a3 JTF_VARCHAR2_TABLE_200
4990 , p5_a4 JTF_VARCHAR2_TABLE_4000
4991 , p5_a5 JTF_NUMBER_TABLE
4992 , p5_a6 JTF_DATE_TABLE
4993 , p5_a7 JTF_VARCHAR2_TABLE_4000
4994 , p5_a8 JTF_VARCHAR2_TABLE_100
4995 , p_modified_by NUMBER
4996 , p_modified_on date
4997 , x_failed_row_id_list out nocopy VARCHAR2
4998 , x_return_status out nocopy VARCHAR2
4999 , x_errorcode out nocopy NUMBER
5000 , x_msg_count out nocopy NUMBER
5001 , x_msg_data out nocopy VARCHAR2
5002 )
5003
5004 as
5005 ddp_ext_attr_grp_tbl cs_servicerequest_pub.ext_attr_grp_tbl_type;
5006 ddp_ext_attr_tbl cs_servicerequest_pub.ext_attr_tbl_type;
5007 ddp_modified_on date;
5008 ddindx binary_integer; indx binary_integer;
5009 begin
5010
5011 -- copy data to the local IN or IN-OUT args, if any
5012
5013
5014
5015
5016 cs_servicerequest_pub_w.rosetta_table_copy_in_p8(ddp_ext_attr_grp_tbl, p4_a0
5017 , p4_a1
5018 , p4_a2
5019 , p4_a3
5020 , p4_a4
5021 , p4_a5
5022 , p4_a6
5023 , p4_a7
5024 , p4_a8
5025 , p4_a9
5026 , p4_a10
5027 , p4_a11
5028 , p4_a12
5029 , p4_a13
5030 , p4_a14
5031 );
5032
5033 cs_servicerequest_pub_w.rosetta_table_copy_in_p10(ddp_ext_attr_tbl, p5_a0
5034 , p5_a1
5035 , p5_a2
5036 , p5_a3
5037 , p5_a4
5038 , p5_a5
5039 , p5_a6
5040 , p5_a7
5041 , p5_a8
5042 );
5043
5044
5045 ddp_modified_on := rosetta_g_miss_date_in_map(p_modified_on);
5046
5047
5048
5049
5050
5051
5052 -- here's the delegated call to the old PL/SQL routine
5053 cs_servicerequest_pub.process_sr_ext_attrs(p_api_version,
5054 p_init_msg_list,
5055 p_commit,
5056 p_incident_id,
5057 ddp_ext_attr_grp_tbl,
5058 ddp_ext_attr_tbl,
5059 p_modified_by,
5060 ddp_modified_on,
5061 x_failed_row_id_list,
5062 x_return_status,
5063 x_errorcode,
5064 x_msg_count,
5065 x_msg_data);
5066
5067 -- copy data back from the local variables to OUT or IN-OUT args, if any
5068
5069
5070
5071
5072
5073
5074
5075
5076
5077
5078
5079
5080 end;
5081
5082 procedure get_sr_info(p_api_version NUMBER
5083 , p_incident_id NUMBER
5084 , p_incident_number VARCHAR2
5085 , p3_a0 in out nocopy NUMBER
5086 , p3_a1 in out nocopy VARCHAR2
5087 , p3_a2 in out nocopy NUMBER
5088 , p3_a3 in out nocopy VARCHAR2
5089 , p3_a4 in out nocopy NUMBER
5090 , p3_a5 in out nocopy VARCHAR2
5091 , p3_a6 in out nocopy NUMBER
5092 , p3_a7 in out nocopy VARCHAR2
5093 , p3_a8 in out nocopy NUMBER
5094 , p3_a9 in out nocopy NUMBER
5095 , p3_a10 in out nocopy VARCHAR2
5096 , p3_a11 in out nocopy NUMBER
5097 , p3_a12 in out nocopy VARCHAR2
5098 , p3_a13 in out nocopy NUMBER
5099 , p3_a14 in out nocopy VARCHAR2
5100 , p3_a15 in out nocopy VARCHAR2
5101 , p3_a16 in out nocopy VARCHAR2
5102 , p3_a17 in out nocopy VARCHAR2
5103 , p3_a18 in out nocopy VARCHAR2
5104 , p3_a19 in out nocopy VARCHAR2
5105 , p3_a20 in out nocopy VARCHAR2
5106 , p3_a21 in out nocopy VARCHAR2
5107 , p3_a22 in out nocopy VARCHAR2
5108 , p3_a23 in out nocopy VARCHAR2
5109 , p3_a24 in out nocopy NUMBER
5110 , p3_a25 in out nocopy VARCHAR2
5111 , p3_a26 in out nocopy VARCHAR2
5112 , p3_a27 in out nocopy NUMBER
5113 , p3_a28 in out nocopy VARCHAR2
5114 , p3_a29 in out nocopy NUMBER
5115 , p3_a30 in out nocopy VARCHAR2
5116 , p3_a31 in out nocopy VARCHAR2
5117 , p3_a32 in out nocopy NUMBER
5118 , p3_a33 in out nocopy VARCHAR2
5119 , p3_a34 in out nocopy NUMBER
5120 , p3_a35 in out nocopy VARCHAR2
5121 , p3_a36 in out nocopy VARCHAR2
5122 , p3_a37 in out nocopy DATE
5123 , p3_a38 in out nocopy DATE
5124 , p3_a39 in out nocopy DATE
5125 , p3_a40 in out nocopy DATE
5126 , p3_a41 in out nocopy DATE
5127 , p3_a42 in out nocopy DATE
5128 , p3_a43 in out nocopy DATE
5129 , p3_a44 in out nocopy DATE
5130 , p3_a45 in out nocopy DATE
5131 , p3_a46 in out nocopy NUMBER
5132 , p3_a47 in out nocopy VARCHAR2
5133 , p3_a48 in out nocopy DATE
5134 , p3_a49 in out nocopy NUMBER
5135 , p3_a50 in out nocopy NUMBER
5136 , p3_a51 in out nocopy NUMBER
5137 , p3_a52 in out nocopy NUMBER
5138 , p3_a53 in out nocopy VARCHAR2
5139 , p3_a54 in out nocopy VARCHAR2
5140 , p3_a55 in out nocopy VARCHAR2
5141 , p3_a56 in out nocopy VARCHAR2
5142 , p3_a57 in out nocopy VARCHAR2
5143 , p3_a58 in out nocopy VARCHAR2
5144 , p3_a59 in out nocopy VARCHAR2
5145 , p3_a60 in out nocopy VARCHAR2
5146 , p3_a61 in out nocopy VARCHAR2
5147 , p3_a62 in out nocopy VARCHAR2
5148 , p3_a63 in out nocopy VARCHAR2
5149 , p3_a64 in out nocopy VARCHAR2
5150 , p3_a65 in out nocopy VARCHAR2
5151 , p3_a66 in out nocopy VARCHAR2
5152 , p3_a67 in out nocopy VARCHAR2
5153 , p3_a68 in out nocopy VARCHAR2
5154 , p3_a69 in out nocopy VARCHAR2
5155 , p3_a70 in out nocopy VARCHAR2
5156 , p3_a71 in out nocopy VARCHAR2
5157 , p3_a72 in out nocopy VARCHAR2
5158 , p3_a73 in out nocopy VARCHAR2
5159 , p3_a74 in out nocopy VARCHAR2
5160 , p3_a75 in out nocopy VARCHAR2
5161 , p3_a76 in out nocopy VARCHAR2
5162 , p3_a77 in out nocopy VARCHAR2
5163 , p3_a78 in out nocopy VARCHAR2
5164 , p3_a79 in out nocopy VARCHAR2
5165 , p3_a80 in out nocopy VARCHAR2
5166 , p3_a81 in out nocopy VARCHAR2
5167 , p3_a82 in out nocopy VARCHAR2
5168 , p3_a83 in out nocopy VARCHAR2
5169 , p3_a84 in out nocopy VARCHAR2
5170 , p3_a85 in out nocopy VARCHAR2
5171 , p3_a86 in out nocopy VARCHAR2
5172 , p3_a87 in out nocopy VARCHAR2
5173 , p3_a88 in out nocopy VARCHAR2
5174 , p3_a89 in out nocopy VARCHAR2
5175 , p3_a90 in out nocopy VARCHAR2
5176 , p3_a91 in out nocopy VARCHAR2
5177 , p3_a92 in out nocopy VARCHAR2
5178 , p3_a93 in out nocopy VARCHAR2
5179 , p3_a94 in out nocopy VARCHAR2
5180 , p3_a95 in out nocopy VARCHAR2
5181 , p3_a96 in out nocopy VARCHAR2
5182 , p3_a97 in out nocopy VARCHAR2
5183 , p3_a98 in out nocopy VARCHAR2
5184 , p3_a99 in out nocopy VARCHAR2
5185 , p3_a100 in out nocopy VARCHAR2
5186 , p3_a101 in out nocopy VARCHAR2
5187 , p3_a102 in out nocopy VARCHAR2
5188 , p3_a103 in out nocopy VARCHAR2
5189 , p3_a104 in out nocopy VARCHAR2
5190 , p4_a0 in out nocopy JTF_VARCHAR2_TABLE_100
5191 , p4_a1 in out nocopy JTF_VARCHAR2_TABLE_100
5192 , p4_a2 in out nocopy JTF_VARCHAR2_TABLE_100
5193 , p4_a3 in out nocopy JTF_VARCHAR2_TABLE_100
5194 , p4_a4 in out nocopy JTF_VARCHAR2_TABLE_100
5195 , p4_a5 in out nocopy JTF_VARCHAR2_TABLE_4000
5196 , p4_a6 in out nocopy JTF_VARCHAR2_TABLE_100
5197 , p4_a7 in out nocopy JTF_VARCHAR2_TABLE_4000
5198 , p4_a8 in out nocopy JTF_VARCHAR2_TABLE_100
5199 , p4_a9 in out nocopy JTF_VARCHAR2_TABLE_100
5200 , p4_a10 in out nocopy JTF_VARCHAR2_TABLE_100
5201 , p4_a11 in out nocopy JTF_VARCHAR2_TABLE_100
5202 , p4_a12 in out nocopy JTF_DATE_TABLE
5203 , p4_a13 in out nocopy JTF_DATE_TABLE
5204 , p4_a14 in out nocopy JTF_DATE_TABLE
5205 , p4_a15 in out nocopy JTF_DATE_TABLE
5206 , p4_a16 in out nocopy JTF_DATE_TABLE
5207 , p4_a17 in out nocopy JTF_DATE_TABLE
5208 , p4_a18 in out nocopy JTF_NUMBER_TABLE
5209 , p4_a19 in out nocopy JTF_VARCHAR2_TABLE_100
5210 , p4_a20 in out nocopy JTF_NUMBER_TABLE
5211 , p4_a21 in out nocopy JTF_VARCHAR2_TABLE_100
5212 , p4_a22 in out nocopy JTF_NUMBER_TABLE
5213 , p4_a23 in out nocopy JTF_VARCHAR2_TABLE_100
5214 , p4_a24 in out nocopy JTF_VARCHAR2_TABLE_100
5215 , p4_a25 in out nocopy JTF_VARCHAR2_TABLE_100
5216 , p4_a26 in out nocopy JTF_VARCHAR2_TABLE_100
5217 , p4_a27 in out nocopy JTF_NUMBER_TABLE
5218 , p4_a28 in out nocopy JTF_DATE_TABLE
5219 , p4_a29 in out nocopy JTF_NUMBER_TABLE
5220 , p4_a30 in out nocopy JTF_DATE_TABLE
5221 , p4_a31 in out nocopy JTF_NUMBER_TABLE
5222 , p4_a32 in out nocopy JTF_NUMBER_TABLE
5223 , p4_a33 in out nocopy JTF_VARCHAR2_TABLE_100
5224 , p4_a34 in out nocopy JTF_VARCHAR2_TABLE_100
5225 , p4_a35 in out nocopy JTF_NUMBER_TABLE
5226 , p4_a36 in out nocopy JTF_NUMBER_TABLE
5227 , p4_a37 in out nocopy JTF_NUMBER_TABLE
5228 , p4_a38 in out nocopy JTF_NUMBER_TABLE
5229 , p4_a39 in out nocopy JTF_NUMBER_TABLE
5230 , p4_a40 in out nocopy JTF_NUMBER_TABLE
5231 , p4_a41 in out nocopy JTF_NUMBER_TABLE
5232 , p4_a42 in out nocopy JTF_NUMBER_TABLE
5233 , p4_a43 in out nocopy JTF_NUMBER_TABLE
5234 , p4_a44 in out nocopy JTF_NUMBER_TABLE
5235 , p4_a45 in out nocopy JTF_NUMBER_TABLE
5236 , p4_a46 in out nocopy JTF_VARCHAR2_TABLE_100
5237 , p4_a47 in out nocopy JTF_NUMBER_TABLE
5238 , p4_a48 in out nocopy JTF_VARCHAR2_TABLE_100
5239 , p4_a49 in out nocopy JTF_VARCHAR2_TABLE_100
5240 , p4_a50 in out nocopy JTF_VARCHAR2_TABLE_100
5241 , p4_a51 in out nocopy JTF_VARCHAR2_TABLE_100
5242 , p4_a52 in out nocopy JTF_VARCHAR2_TABLE_100
5243 , p4_a53 in out nocopy JTF_NUMBER_TABLE
5244 , p4_a54 in out nocopy JTF_VARCHAR2_TABLE_200
5245 , p4_a55 in out nocopy JTF_VARCHAR2_TABLE_200
5246 , p4_a56 in out nocopy JTF_VARCHAR2_TABLE_200
5247 , p4_a57 in out nocopy JTF_VARCHAR2_TABLE_200
5248 , p4_a58 in out nocopy JTF_VARCHAR2_TABLE_200
5249 , p4_a59 in out nocopy JTF_VARCHAR2_TABLE_200
5250 , p4_a60 in out nocopy JTF_VARCHAR2_TABLE_200
5251 , p4_a61 in out nocopy JTF_VARCHAR2_TABLE_200
5252 , p4_a62 in out nocopy JTF_VARCHAR2_TABLE_200
5253 , p4_a63 in out nocopy JTF_VARCHAR2_TABLE_200
5254 , p4_a64 in out nocopy JTF_VARCHAR2_TABLE_200
5255 , p4_a65 in out nocopy JTF_VARCHAR2_TABLE_200
5256 , p4_a66 in out nocopy JTF_VARCHAR2_TABLE_200
5257 , p4_a67 in out nocopy JTF_VARCHAR2_TABLE_200
5258 , p4_a68 in out nocopy JTF_VARCHAR2_TABLE_200
5259 , p4_a69 in out nocopy JTF_VARCHAR2_TABLE_200
5260 , p5_a0 in out nocopy JTF_VARCHAR2_TABLE_2000
5261 , p5_a1 in out nocopy JTF_VARCHAR2_TABLE_100
5262 , p5_a2 in out nocopy JTF_CLOB_TABLE
5263 , p5_a3 in out nocopy JTF_NUMBER_TABLE
5264 , x_return_status out nocopy VARCHAR2
5265 , x_msg_count out nocopy VARCHAR2
5266 , x_msg_data out nocopy VARCHAR2
5267 )
5268
5269 as
5270 ddx_getsr_out_rec cs_servicerequest_pub.get_sr_rec;
5271 ddx_tasks cs_servicerequest_pub.tasks_table;
5272 ddx_notes cs_servicerequest_pub.sr_notes_table;
5273 ddindx binary_integer; indx binary_integer;
5274 begin
5275
5276 -- copy data to the local IN or IN-OUT args, if any
5277
5278
5279
5280 ddx_getsr_out_rec.incident_id := p3_a0;
5281 ddx_getsr_out_rec.incident_number := p3_a1;
5282 ddx_getsr_out_rec.incident_type_id := p3_a2;
5283 ddx_getsr_out_rec.incident_type := p3_a3;
5284 ddx_getsr_out_rec.incident_status_id := p3_a4;
5285 ddx_getsr_out_rec.incident_status := p3_a5;
5286 ddx_getsr_out_rec.incident_severity_id := p3_a6;
5287 ddx_getsr_out_rec.incident_severity := p3_a7;
5288 ddx_getsr_out_rec.sev_importance_level := p3_a8;
5289 ddx_getsr_out_rec.incident_urgency_id := p3_a9;
5290 ddx_getsr_out_rec.incidient_urgency := p3_a10;
5291 ddx_getsr_out_rec.sr_group_id := p3_a11;
5292 ddx_getsr_out_rec.sr_group := p3_a12;
5293 ddx_getsr_out_rec.sr_owner_id := p3_a13;
5294 ddx_getsr_out_rec.sr_owner := p3_a14;
5295 ddx_getsr_out_rec.problem_code_id := p3_a15;
5296 ddx_getsr_out_rec.problem_code := p3_a16;
5297 ddx_getsr_out_rec.resolution_code_id := p3_a17;
5298 ddx_getsr_out_rec.resolution_code := p3_a18;
5299 ddx_getsr_out_rec.publish_flag := p3_a19;
5300 ddx_getsr_out_rec.sr_creation_channel := p3_a20;
5301 ddx_getsr_out_rec.summary := p3_a21;
5302 ddx_getsr_out_rec.resolution_summary := p3_a22;
5303 ddx_getsr_out_rec.created_by := p3_a23;
5304 ddx_getsr_out_rec.contact_party_id := p3_a24;
5305 ddx_getsr_out_rec.contact_type := p3_a25;
5306 ddx_getsr_out_rec.contact_name := p3_a26;
5307 ddx_getsr_out_rec.time_zone_id := p3_a27;
5308 ddx_getsr_out_rec.time_zone_name := p3_a28;
5309 ddx_getsr_out_rec.customer_id := p3_a29;
5310 ddx_getsr_out_rec.customer_number := p3_a30;
5311 ddx_getsr_out_rec.customer_name := p3_a31;
5312 ddx_getsr_out_rec.account_id := p3_a32;
5313 ddx_getsr_out_rec.account_number := p3_a33;
5314 ddx_getsr_out_rec.inventory_item_id := p3_a34;
5315 ddx_getsr_out_rec.product := p3_a35;
5316 ddx_getsr_out_rec.product_description := p3_a36;
5317 ddx_getsr_out_rec.creation_date := rosetta_g_miss_date_in_map(p3_a37);
5318 ddx_getsr_out_rec.last_update_date := rosetta_g_miss_date_in_map(p3_a38);
5319 ddx_getsr_out_rec.incident_date := rosetta_g_miss_date_in_map(p3_a39);
5320 ddx_getsr_out_rec.close_date := rosetta_g_miss_date_in_map(p3_a40);
5321 ddx_getsr_out_rec.date_resolved := rosetta_g_miss_date_in_map(p3_a41);
5322 ddx_getsr_out_rec.expected_reaction_date := rosetta_g_miss_date_in_map(p3_a42);
5323 ddx_getsr_out_rec.expected_resolution_date := rosetta_g_miss_date_in_map(p3_a43);
5324 ddx_getsr_out_rec.date_first_reacted := rosetta_g_miss_date_in_map(p3_a44);
5325 ddx_getsr_out_rec.actual_resolution_date := rosetta_g_miss_date_in_map(p3_a45);
5326 ddx_getsr_out_rec.status_sort_order := p3_a46;
5327 ddx_getsr_out_rec.status_flag_code := p3_a47;
5328 ddx_getsr_out_rec.inc_responded_by_date := rosetta_g_miss_date_in_map(p3_a48);
5329 ddx_getsr_out_rec.created_by_id := p3_a49;
5330 ddx_getsr_out_rec.customer_product_id := p3_a50;
5331 ddx_getsr_out_rec.organization_id := p3_a51;
5332 ddx_getsr_out_rec.inventory_org_id := p3_a52;
5333 ddx_getsr_out_rec.customer_phone := p3_a53;
5334 ddx_getsr_out_rec.customer_email := p3_a54;
5335 ddx_getsr_out_rec.contract_number := p3_a55;
5336 ddx_getsr_out_rec.contract_service_description := p3_a56;
5337 ddx_getsr_out_rec.contract_coverage_description := p3_a57;
5338 ddx_getsr_out_rec.customer_type := p3_a58;
5339 ddx_getsr_out_rec.contact_phone_number := p3_a59;
5340 ddx_getsr_out_rec.contact_email := p3_a60;
5341 ddx_getsr_out_rec.item_category := p3_a61;
5342 ddx_getsr_out_rec.instance_number := p3_a62;
5343 ddx_getsr_out_rec.serial_number := p3_a63;
5344 ddx_getsr_out_rec.tag_number := p3_a64;
5345 ddx_getsr_out_rec.system_number := p3_a65;
5346 ddx_getsr_out_rec.component := p3_a66;
5347 ddx_getsr_out_rec.sub_component := p3_a67;
5348 ddx_getsr_out_rec.item_revision := p3_a68;
5349 ddx_getsr_out_rec.component_revision := p3_a69;
5350 ddx_getsr_out_rec.sub_component_revision := p3_a70;
5351 ddx_getsr_out_rec.incident_address := p3_a71;
5352 ddx_getsr_out_rec.resource_type := p3_a72;
5353 ddx_getsr_out_rec.attribute1 := p3_a73;
5354 ddx_getsr_out_rec.attribute2 := p3_a74;
5355 ddx_getsr_out_rec.attribute3 := p3_a75;
5356 ddx_getsr_out_rec.attribute4 := p3_a76;
5357 ddx_getsr_out_rec.attribute5 := p3_a77;
5358 ddx_getsr_out_rec.attribute6 := p3_a78;
5359 ddx_getsr_out_rec.attribute7 := p3_a79;
5360 ddx_getsr_out_rec.attribute8 := p3_a80;
5361 ddx_getsr_out_rec.attribute9 := p3_a81;
5362 ddx_getsr_out_rec.attribute10 := p3_a82;
5363 ddx_getsr_out_rec.attribute11 := p3_a83;
5364 ddx_getsr_out_rec.attribute12 := p3_a84;
5365 ddx_getsr_out_rec.attribute13 := p3_a85;
5366 ddx_getsr_out_rec.attribute14 := p3_a86;
5367 ddx_getsr_out_rec.attribute15 := p3_a87;
5368 ddx_getsr_out_rec.incident_context := p3_a88;
5369 ddx_getsr_out_rec.extattribute1 := p3_a89;
5370 ddx_getsr_out_rec.extattribute2 := p3_a90;
5371 ddx_getsr_out_rec.extattribute3 := p3_a91;
5372 ddx_getsr_out_rec.extattribute4 := p3_a92;
5373 ddx_getsr_out_rec.extattribute5 := p3_a93;
5374 ddx_getsr_out_rec.extattribute6 := p3_a94;
5375 ddx_getsr_out_rec.extattribute7 := p3_a95;
5376 ddx_getsr_out_rec.extattribute8 := p3_a96;
5377 ddx_getsr_out_rec.extattribute9 := p3_a97;
5378 ddx_getsr_out_rec.extattribute10 := p3_a98;
5379 ddx_getsr_out_rec.extattribute11 := p3_a99;
5380 ddx_getsr_out_rec.extattribute12 := p3_a100;
5381 ddx_getsr_out_rec.extattribute13 := p3_a101;
5382 ddx_getsr_out_rec.extattribute14 := p3_a102;
5383 ddx_getsr_out_rec.extattribute15 := p3_a103;
5384 ddx_getsr_out_rec.ext_context := p3_a104;
5385
5386 cs_servicerequest_pub_w.rosetta_table_copy_in_p19(ddx_tasks, p4_a0
5387 , p4_a1
5388 , p4_a2
5389 , p4_a3
5390 , p4_a4
5391 , p4_a5
5392 , p4_a6
5393 , p4_a7
5394 , p4_a8
5395 , p4_a9
5396 , p4_a10
5397 , p4_a11
5398 , p4_a12
5399 , p4_a13
5400 , p4_a14
5401 , p4_a15
5402 , p4_a16
5403 , p4_a17
5404 , p4_a18
5405 , p4_a19
5406 , p4_a20
5407 , p4_a21
5408 , p4_a22
5409 , p4_a23
5410 , p4_a24
5411 , p4_a25
5412 , p4_a26
5413 , p4_a27
5414 , p4_a28
5415 , p4_a29
5416 , p4_a30
5417 , p4_a31
5418 , p4_a32
5419 , p4_a33
5420 , p4_a34
5421 , p4_a35
5422 , p4_a36
5423 , p4_a37
5424 , p4_a38
5425 , p4_a39
5426 , p4_a40
5427 , p4_a41
5428 , p4_a42
5429 , p4_a43
5430 , p4_a44
5431 , p4_a45
5432 , p4_a46
5433 , p4_a47
5434 , p4_a48
5435 , p4_a49
5436 , p4_a50
5437 , p4_a51
5438 , p4_a52
5439 , p4_a53
5440 , p4_a54
5441 , p4_a55
5442 , p4_a56
5443 , p4_a57
5444 , p4_a58
5445 , p4_a59
5446 , p4_a60
5447 , p4_a61
5448 , p4_a62
5449 , p4_a63
5450 , p4_a64
5451 , p4_a65
5452 , p4_a66
5453 , p4_a67
5454 , p4_a68
5455 , p4_a69
5456 );
5457
5458 cs_servicerequest_pub_w.rosetta_table_copy_in_p17(ddx_notes, p5_a0
5459 , p5_a1
5460 , p5_a2
5461 , p5_a3
5462 );
5463
5464
5465
5466
5467 -- here's the delegated call to the old PL/SQL routine
5468 cs_servicerequest_pub.get_sr_info(p_api_version,
5469 p_incident_id,
5470 p_incident_number,
5471 ddx_getsr_out_rec,
5472 ddx_tasks,
5473 ddx_notes,
5474 x_return_status,
5475 x_msg_count,
5476 x_msg_data);
5477
5478 -- copy data back from the local variables to OUT or IN-OUT args, if any
5479
5480
5481
5482 p3_a0 := ddx_getsr_out_rec.incident_id;
5483 p3_a1 := ddx_getsr_out_rec.incident_number;
5484 p3_a2 := ddx_getsr_out_rec.incident_type_id;
5485 p3_a3 := ddx_getsr_out_rec.incident_type;
5486 p3_a4 := ddx_getsr_out_rec.incident_status_id;
5487 p3_a5 := ddx_getsr_out_rec.incident_status;
5488 p3_a6 := ddx_getsr_out_rec.incident_severity_id;
5489 p3_a7 := ddx_getsr_out_rec.incident_severity;
5490 p3_a8 := ddx_getsr_out_rec.sev_importance_level;
5491 p3_a9 := ddx_getsr_out_rec.incident_urgency_id;
5492 p3_a10 := ddx_getsr_out_rec.incidient_urgency;
5493 p3_a11 := ddx_getsr_out_rec.sr_group_id;
5494 p3_a12 := ddx_getsr_out_rec.sr_group;
5495 p3_a13 := ddx_getsr_out_rec.sr_owner_id;
5496 p3_a14 := ddx_getsr_out_rec.sr_owner;
5497 p3_a15 := ddx_getsr_out_rec.problem_code_id;
5498 p3_a16 := ddx_getsr_out_rec.problem_code;
5499 p3_a17 := ddx_getsr_out_rec.resolution_code_id;
5500 p3_a18 := ddx_getsr_out_rec.resolution_code;
5501 p3_a19 := ddx_getsr_out_rec.publish_flag;
5502 p3_a20 := ddx_getsr_out_rec.sr_creation_channel;
5503 p3_a21 := ddx_getsr_out_rec.summary;
5504 p3_a22 := ddx_getsr_out_rec.resolution_summary;
5505 p3_a23 := ddx_getsr_out_rec.created_by;
5506 p3_a24 := ddx_getsr_out_rec.contact_party_id;
5507 p3_a25 := ddx_getsr_out_rec.contact_type;
5508 p3_a26 := ddx_getsr_out_rec.contact_name;
5509 p3_a27 := ddx_getsr_out_rec.time_zone_id;
5510 p3_a28 := ddx_getsr_out_rec.time_zone_name;
5511 p3_a29 := ddx_getsr_out_rec.customer_id;
5512 p3_a30 := ddx_getsr_out_rec.customer_number;
5513 p3_a31 := ddx_getsr_out_rec.customer_name;
5514 p3_a32 := ddx_getsr_out_rec.account_id;
5515 p3_a33 := ddx_getsr_out_rec.account_number;
5516 p3_a34 := ddx_getsr_out_rec.inventory_item_id;
5517 p3_a35 := ddx_getsr_out_rec.product;
5518 p3_a36 := ddx_getsr_out_rec.product_description;
5519 p3_a37 := ddx_getsr_out_rec.creation_date;
5520 p3_a38 := ddx_getsr_out_rec.last_update_date;
5521 p3_a39 := ddx_getsr_out_rec.incident_date;
5522 p3_a40 := ddx_getsr_out_rec.close_date;
5523 p3_a41 := ddx_getsr_out_rec.date_resolved;
5524 p3_a42 := ddx_getsr_out_rec.expected_reaction_date;
5525 p3_a43 := ddx_getsr_out_rec.expected_resolution_date;
5526 p3_a44 := ddx_getsr_out_rec.date_first_reacted;
5527 p3_a45 := ddx_getsr_out_rec.actual_resolution_date;
5528 p3_a46 := ddx_getsr_out_rec.status_sort_order;
5529 p3_a47 := ddx_getsr_out_rec.status_flag_code;
5530 p3_a48 := ddx_getsr_out_rec.inc_responded_by_date;
5531 p3_a49 := ddx_getsr_out_rec.created_by_id;
5532 p3_a50 := ddx_getsr_out_rec.customer_product_id;
5533 p3_a51 := ddx_getsr_out_rec.organization_id;
5534 p3_a52 := ddx_getsr_out_rec.inventory_org_id;
5535 p3_a53 := ddx_getsr_out_rec.customer_phone;
5536 p3_a54 := ddx_getsr_out_rec.customer_email;
5537 p3_a55 := ddx_getsr_out_rec.contract_number;
5538 p3_a56 := ddx_getsr_out_rec.contract_service_description;
5539 p3_a57 := ddx_getsr_out_rec.contract_coverage_description;
5540 p3_a58 := ddx_getsr_out_rec.customer_type;
5541 p3_a59 := ddx_getsr_out_rec.contact_phone_number;
5542 p3_a60 := ddx_getsr_out_rec.contact_email;
5543 p3_a61 := ddx_getsr_out_rec.item_category;
5544 p3_a62 := ddx_getsr_out_rec.instance_number;
5545 p3_a63 := ddx_getsr_out_rec.serial_number;
5546 p3_a64 := ddx_getsr_out_rec.tag_number;
5547 p3_a65 := ddx_getsr_out_rec.system_number;
5548 p3_a66 := ddx_getsr_out_rec.component;
5549 p3_a67 := ddx_getsr_out_rec.sub_component;
5550 p3_a68 := ddx_getsr_out_rec.item_revision;
5551 p3_a69 := ddx_getsr_out_rec.component_revision;
5552 p3_a70 := ddx_getsr_out_rec.sub_component_revision;
5553 p3_a71 := ddx_getsr_out_rec.incident_address;
5554 p3_a72 := ddx_getsr_out_rec.resource_type;
5555 p3_a73 := ddx_getsr_out_rec.attribute1;
5556 p3_a74 := ddx_getsr_out_rec.attribute2;
5557 p3_a75 := ddx_getsr_out_rec.attribute3;
5558 p3_a76 := ddx_getsr_out_rec.attribute4;
5559 p3_a77 := ddx_getsr_out_rec.attribute5;
5560 p3_a78 := ddx_getsr_out_rec.attribute6;
5561 p3_a79 := ddx_getsr_out_rec.attribute7;
5562 p3_a80 := ddx_getsr_out_rec.attribute8;
5563 p3_a81 := ddx_getsr_out_rec.attribute9;
5564 p3_a82 := ddx_getsr_out_rec.attribute10;
5565 p3_a83 := ddx_getsr_out_rec.attribute11;
5566 p3_a84 := ddx_getsr_out_rec.attribute12;
5567 p3_a85 := ddx_getsr_out_rec.attribute13;
5568 p3_a86 := ddx_getsr_out_rec.attribute14;
5569 p3_a87 := ddx_getsr_out_rec.attribute15;
5570 p3_a88 := ddx_getsr_out_rec.incident_context;
5571 p3_a89 := ddx_getsr_out_rec.extattribute1;
5572 p3_a90 := ddx_getsr_out_rec.extattribute2;
5573 p3_a91 := ddx_getsr_out_rec.extattribute3;
5574 p3_a92 := ddx_getsr_out_rec.extattribute4;
5575 p3_a93 := ddx_getsr_out_rec.extattribute5;
5576 p3_a94 := ddx_getsr_out_rec.extattribute6;
5577 p3_a95 := ddx_getsr_out_rec.extattribute7;
5578 p3_a96 := ddx_getsr_out_rec.extattribute8;
5579 p3_a97 := ddx_getsr_out_rec.extattribute9;
5580 p3_a98 := ddx_getsr_out_rec.extattribute10;
5581 p3_a99 := ddx_getsr_out_rec.extattribute11;
5582 p3_a100 := ddx_getsr_out_rec.extattribute12;
5583 p3_a101 := ddx_getsr_out_rec.extattribute13;
5584 p3_a102 := ddx_getsr_out_rec.extattribute14;
5585 p3_a103 := ddx_getsr_out_rec.extattribute15;
5586 p3_a104 := ddx_getsr_out_rec.ext_context;
5587
5588 cs_servicerequest_pub_w.rosetta_table_copy_out_p19(ddx_tasks, p4_a0
5589 , p4_a1
5590 , p4_a2
5591 , p4_a3
5592 , p4_a4
5593 , p4_a5
5594 , p4_a6
5595 , p4_a7
5596 , p4_a8
5597 , p4_a9
5598 , p4_a10
5599 , p4_a11
5600 , p4_a12
5601 , p4_a13
5602 , p4_a14
5603 , p4_a15
5604 , p4_a16
5605 , p4_a17
5606 , p4_a18
5607 , p4_a19
5608 , p4_a20
5609 , p4_a21
5610 , p4_a22
5611 , p4_a23
5612 , p4_a24
5613 , p4_a25
5614 , p4_a26
5615 , p4_a27
5616 , p4_a28
5617 , p4_a29
5618 , p4_a30
5619 , p4_a31
5620 , p4_a32
5621 , p4_a33
5622 , p4_a34
5623 , p4_a35
5624 , p4_a36
5625 , p4_a37
5626 , p4_a38
5627 , p4_a39
5628 , p4_a40
5629 , p4_a41
5630 , p4_a42
5631 , p4_a43
5632 , p4_a44
5633 , p4_a45
5634 , p4_a46
5635 , p4_a47
5636 , p4_a48
5637 , p4_a49
5638 , p4_a50
5639 , p4_a51
5640 , p4_a52
5641 , p4_a53
5642 , p4_a54
5643 , p4_a55
5644 , p4_a56
5645 , p4_a57
5646 , p4_a58
5647 , p4_a59
5648 , p4_a60
5649 , p4_a61
5650 , p4_a62
5651 , p4_a63
5652 , p4_a64
5653 , p4_a65
5654 , p4_a66
5655 , p4_a67
5656 , p4_a68
5657 , p4_a69
5658 );
5659
5660 cs_servicerequest_pub_w.rosetta_table_copy_out_p17(ddx_notes, p5_a0
5661 , p5_a1
5662 , p5_a2
5663 , p5_a3
5664 );
5665
5666
5667
5668 end;
5669
5670 end cs_servicerequest_pub_w;