[Home] [Help]
PACKAGE BODY: APPS.JTF_IH_PUB_W
Source
1 package body jtf_ih_pub_w as
2 /* $Header: JTFIHJWB.pls 115.32 2003/07/14 17:56:34 ialeshin 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
6 -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
7 function rosetta_g_miss_date_in_map(d date) return date as
8 begin
9 if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
10 return d;
11 end;
12
13 function rosetta_g_miss_num_map(n number) return number as
14 a number := fnd_api.g_miss_num;
15 b number := 0-1962.0724;
16 begin
17 if n=a then return b; end if;
18 if n=b then return a; end if;
19 return n;
20 end;
21
22 procedure rosetta_table_copy_in_p3(t out nocopy jtf_ih_pub.activity_tbl_type, a0 JTF_NUMBER_TABLE
23 , a1 JTF_NUMBER_TABLE
24 , a2 JTF_NUMBER_TABLE
25 , a3 JTF_NUMBER_TABLE
26 , a4 JTF_VARCHAR2_TABLE_300
27 , a5 JTF_DATE_TABLE
28 , a6 JTF_DATE_TABLE
29 , a7 JTF_NUMBER_TABLE
30 , a8 JTF_NUMBER_TABLE
31 , a9 JTF_VARCHAR2_TABLE_100
32 , a10 JTF_VARCHAR2_TABLE_100
33 , a11 JTF_NUMBER_TABLE
34 , a12 JTF_NUMBER_TABLE
35 , a13 JTF_NUMBER_TABLE
36 , a14 JTF_NUMBER_TABLE
37 , a15 JTF_NUMBER_TABLE
38 , a16 JTF_NUMBER_TABLE
39 , a17 JTF_VARCHAR2_TABLE_1000
40 , a18 JTF_NUMBER_TABLE
41 , a19 JTF_VARCHAR2_TABLE_300
42 , a20 JTF_NUMBER_TABLE
43 , a21 JTF_VARCHAR2_TABLE_100
44 , a22 JTF_NUMBER_TABLE
45 , a23 JTF_VARCHAR2_TABLE_100
46 , a24 JTF_NUMBER_TABLE
47 , a25 JTF_VARCHAR2_TABLE_200
48 , a26 JTF_VARCHAR2_TABLE_200
49 , a27 JTF_VARCHAR2_TABLE_200
50 , a28 JTF_VARCHAR2_TABLE_200
51 , a29 JTF_VARCHAR2_TABLE_200
52 , a30 JTF_VARCHAR2_TABLE_200
53 , a31 JTF_VARCHAR2_TABLE_200
54 , a32 JTF_VARCHAR2_TABLE_200
55 , a33 JTF_VARCHAR2_TABLE_200
56 , a34 JTF_VARCHAR2_TABLE_200
57 , a35 JTF_VARCHAR2_TABLE_200
58 , a36 JTF_VARCHAR2_TABLE_200
59 , a37 JTF_VARCHAR2_TABLE_200
60 , a38 JTF_VARCHAR2_TABLE_200
61 , a39 JTF_VARCHAR2_TABLE_200
62 , a40 JTF_VARCHAR2_TABLE_100
63 , a41 JTF_VARCHAR2_TABLE_300
64 , a42 JTF_VARCHAR2_TABLE_300
65 , a43 JTF_NUMBER_TABLE
66 , a44 JTF_NUMBER_TABLE
67 ) as
68 ddindx binary_integer; indx binary_integer;
69 begin
70 if a0 is not null and a0.count > 0 then
71 if a0.count > 0 then
72 indx := a0.first;
73 ddindx := 1;
74 while true loop
75 t(ddindx).activity_id := rosetta_g_miss_num_map(a0(indx));
76 t(ddindx).duration := rosetta_g_miss_num_map(a1(indx));
77 t(ddindx).cust_account_id := rosetta_g_miss_num_map(a2(indx));
78 t(ddindx).cust_org_id := rosetta_g_miss_num_map(a3(indx));
79 t(ddindx).role := a4(indx);
80 t(ddindx).end_date_time := rosetta_g_miss_date_in_map(a5(indx));
81 t(ddindx).start_date_time := rosetta_g_miss_date_in_map(a6(indx));
82 t(ddindx).task_id := rosetta_g_miss_num_map(a7(indx));
83 t(ddindx).doc_id := rosetta_g_miss_num_map(a8(indx));
84 t(ddindx).doc_ref := a9(indx);
85 t(ddindx).doc_source_object_name := a10(indx);
86 t(ddindx).media_id := rosetta_g_miss_num_map(a11(indx));
87 t(ddindx).action_item_id := rosetta_g_miss_num_map(a12(indx));
88 t(ddindx).interaction_id := rosetta_g_miss_num_map(a13(indx));
89 t(ddindx).outcome_id := rosetta_g_miss_num_map(a14(indx));
90 t(ddindx).result_id := rosetta_g_miss_num_map(a15(indx));
91 t(ddindx).reason_id := rosetta_g_miss_num_map(a16(indx));
92 t(ddindx).description := a17(indx);
93 t(ddindx).action_id := rosetta_g_miss_num_map(a18(indx));
94 t(ddindx).interaction_action_type := a19(indx);
95 t(ddindx).object_id := rosetta_g_miss_num_map(a20(indx));
96 t(ddindx).object_type := a21(indx);
97 t(ddindx).source_code_id := rosetta_g_miss_num_map(a22(indx));
98 t(ddindx).source_code := a23(indx);
99 t(ddindx).script_trans_id := rosetta_g_miss_num_map(a24(indx));
100 t(ddindx).attribute1 := a25(indx);
101 t(ddindx).attribute2 := a26(indx);
102 t(ddindx).attribute3 := a27(indx);
103 t(ddindx).attribute4 := a28(indx);
104 t(ddindx).attribute5 := a29(indx);
105 t(ddindx).attribute6 := a30(indx);
106 t(ddindx).attribute7 := a31(indx);
107 t(ddindx).attribute8 := a32(indx);
108 t(ddindx).attribute9 := a33(indx);
109 t(ddindx).attribute10 := a34(indx);
110 t(ddindx).attribute11 := a35(indx);
111 t(ddindx).attribute12 := a36(indx);
112 t(ddindx).attribute13 := a37(indx);
113 t(ddindx).attribute14 := a38(indx);
114 t(ddindx).attribute15 := a39(indx);
115 t(ddindx).attribute_category := a40(indx);
116 t(ddindx).bulk_writer_code := a41(indx);
117 t(ddindx).bulk_batch_type := a42(indx);
118 t(ddindx).bulk_batch_id := rosetta_g_miss_num_map(a43(indx));
119 t(ddindx).bulk_interaction_id := rosetta_g_miss_num_map(a44(indx));
120 ddindx := ddindx+1;
121 if a0.last =indx
122 then exit;
123 end if;
124 indx := a0.next(indx);
125 end loop;
126 end if;
127 end if;
128 end rosetta_table_copy_in_p3;
129 procedure rosetta_table_copy_out_p3(t jtf_ih_pub.activity_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
130 , a1 out nocopy JTF_NUMBER_TABLE
131 , a2 out nocopy JTF_NUMBER_TABLE
132 , a3 out nocopy JTF_NUMBER_TABLE
133 , a4 out nocopy JTF_VARCHAR2_TABLE_300
134 , a5 out nocopy JTF_DATE_TABLE
135 , a6 out nocopy JTF_DATE_TABLE
136 , a7 out nocopy JTF_NUMBER_TABLE
137 , a8 out nocopy JTF_NUMBER_TABLE
138 , a9 out nocopy JTF_VARCHAR2_TABLE_100
139 , a10 out nocopy JTF_VARCHAR2_TABLE_100
140 , a11 out nocopy JTF_NUMBER_TABLE
141 , a12 out nocopy JTF_NUMBER_TABLE
142 , a13 out nocopy JTF_NUMBER_TABLE
143 , a14 out nocopy JTF_NUMBER_TABLE
144 , a15 out nocopy JTF_NUMBER_TABLE
145 , a16 out nocopy JTF_NUMBER_TABLE
146 , a17 out nocopy JTF_VARCHAR2_TABLE_1000
147 , a18 out nocopy JTF_NUMBER_TABLE
148 , a19 out nocopy JTF_VARCHAR2_TABLE_300
149 , a20 out nocopy JTF_NUMBER_TABLE
150 , a21 out nocopy JTF_VARCHAR2_TABLE_100
151 , a22 out nocopy JTF_NUMBER_TABLE
152 , a23 out nocopy JTF_VARCHAR2_TABLE_100
153 , a24 out nocopy JTF_NUMBER_TABLE
154 , a25 out nocopy JTF_VARCHAR2_TABLE_200
155 , a26 out nocopy JTF_VARCHAR2_TABLE_200
156 , a27 out nocopy JTF_VARCHAR2_TABLE_200
157 , a28 out nocopy JTF_VARCHAR2_TABLE_200
158 , a29 out nocopy JTF_VARCHAR2_TABLE_200
159 , a30 out nocopy JTF_VARCHAR2_TABLE_200
160 , a31 out nocopy JTF_VARCHAR2_TABLE_200
161 , a32 out nocopy JTF_VARCHAR2_TABLE_200
162 , a33 out nocopy JTF_VARCHAR2_TABLE_200
163 , a34 out nocopy JTF_VARCHAR2_TABLE_200
164 , a35 out nocopy JTF_VARCHAR2_TABLE_200
165 , a36 out nocopy JTF_VARCHAR2_TABLE_200
166 , a37 out nocopy JTF_VARCHAR2_TABLE_200
167 , a38 out nocopy JTF_VARCHAR2_TABLE_200
168 , a39 out nocopy JTF_VARCHAR2_TABLE_200
169 , a40 out nocopy JTF_VARCHAR2_TABLE_100
170 , a41 out nocopy JTF_VARCHAR2_TABLE_300
171 , a42 out nocopy JTF_VARCHAR2_TABLE_300
172 , a43 out nocopy JTF_NUMBER_TABLE
173 , a44 out nocopy JTF_NUMBER_TABLE
174 ) as
175 ddindx binary_integer; indx binary_integer;
176 begin
177 if t is null or t.count = 0 then
178 a0 := JTF_NUMBER_TABLE();
179 a1 := JTF_NUMBER_TABLE();
180 a2 := JTF_NUMBER_TABLE();
181 a3 := JTF_NUMBER_TABLE();
182 a4 := JTF_VARCHAR2_TABLE_300();
183 a5 := JTF_DATE_TABLE();
184 a6 := JTF_DATE_TABLE();
185 a7 := JTF_NUMBER_TABLE();
186 a8 := JTF_NUMBER_TABLE();
187 a9 := JTF_VARCHAR2_TABLE_100();
188 a10 := JTF_VARCHAR2_TABLE_100();
189 a11 := JTF_NUMBER_TABLE();
190 a12 := JTF_NUMBER_TABLE();
191 a13 := JTF_NUMBER_TABLE();
192 a14 := JTF_NUMBER_TABLE();
193 a15 := JTF_NUMBER_TABLE();
194 a16 := JTF_NUMBER_TABLE();
195 a17 := JTF_VARCHAR2_TABLE_1000();
196 a18 := JTF_NUMBER_TABLE();
197 a19 := JTF_VARCHAR2_TABLE_300();
198 a20 := JTF_NUMBER_TABLE();
199 a21 := JTF_VARCHAR2_TABLE_100();
200 a22 := JTF_NUMBER_TABLE();
201 a23 := JTF_VARCHAR2_TABLE_100();
202 a24 := JTF_NUMBER_TABLE();
203 a25 := JTF_VARCHAR2_TABLE_200();
204 a26 := JTF_VARCHAR2_TABLE_200();
205 a27 := JTF_VARCHAR2_TABLE_200();
206 a28 := JTF_VARCHAR2_TABLE_200();
207 a29 := JTF_VARCHAR2_TABLE_200();
208 a30 := JTF_VARCHAR2_TABLE_200();
209 a31 := JTF_VARCHAR2_TABLE_200();
210 a32 := JTF_VARCHAR2_TABLE_200();
211 a33 := JTF_VARCHAR2_TABLE_200();
212 a34 := JTF_VARCHAR2_TABLE_200();
213 a35 := JTF_VARCHAR2_TABLE_200();
214 a36 := JTF_VARCHAR2_TABLE_200();
215 a37 := JTF_VARCHAR2_TABLE_200();
216 a38 := JTF_VARCHAR2_TABLE_200();
217 a39 := JTF_VARCHAR2_TABLE_200();
218 a40 := JTF_VARCHAR2_TABLE_100();
219 a41 := JTF_VARCHAR2_TABLE_300();
220 a42 := JTF_VARCHAR2_TABLE_300();
221 a43 := JTF_NUMBER_TABLE();
222 a44 := JTF_NUMBER_TABLE();
223 else
224 a0 := JTF_NUMBER_TABLE();
225 a1 := JTF_NUMBER_TABLE();
226 a2 := JTF_NUMBER_TABLE();
227 a3 := JTF_NUMBER_TABLE();
228 a4 := JTF_VARCHAR2_TABLE_300();
229 a5 := JTF_DATE_TABLE();
230 a6 := JTF_DATE_TABLE();
231 a7 := JTF_NUMBER_TABLE();
232 a8 := JTF_NUMBER_TABLE();
233 a9 := JTF_VARCHAR2_TABLE_100();
234 a10 := JTF_VARCHAR2_TABLE_100();
235 a11 := JTF_NUMBER_TABLE();
236 a12 := JTF_NUMBER_TABLE();
237 a13 := JTF_NUMBER_TABLE();
238 a14 := JTF_NUMBER_TABLE();
239 a15 := JTF_NUMBER_TABLE();
240 a16 := JTF_NUMBER_TABLE();
241 a17 := JTF_VARCHAR2_TABLE_1000();
242 a18 := JTF_NUMBER_TABLE();
243 a19 := JTF_VARCHAR2_TABLE_300();
244 a20 := JTF_NUMBER_TABLE();
245 a21 := JTF_VARCHAR2_TABLE_100();
246 a22 := JTF_NUMBER_TABLE();
247 a23 := JTF_VARCHAR2_TABLE_100();
248 a24 := JTF_NUMBER_TABLE();
249 a25 := JTF_VARCHAR2_TABLE_200();
250 a26 := JTF_VARCHAR2_TABLE_200();
251 a27 := JTF_VARCHAR2_TABLE_200();
252 a28 := JTF_VARCHAR2_TABLE_200();
253 a29 := JTF_VARCHAR2_TABLE_200();
254 a30 := JTF_VARCHAR2_TABLE_200();
255 a31 := JTF_VARCHAR2_TABLE_200();
256 a32 := JTF_VARCHAR2_TABLE_200();
257 a33 := JTF_VARCHAR2_TABLE_200();
258 a34 := JTF_VARCHAR2_TABLE_200();
259 a35 := JTF_VARCHAR2_TABLE_200();
260 a36 := JTF_VARCHAR2_TABLE_200();
261 a37 := JTF_VARCHAR2_TABLE_200();
262 a38 := JTF_VARCHAR2_TABLE_200();
263 a39 := JTF_VARCHAR2_TABLE_200();
264 a40 := JTF_VARCHAR2_TABLE_100();
265 a41 := JTF_VARCHAR2_TABLE_300();
266 a42 := JTF_VARCHAR2_TABLE_300();
267 a43 := JTF_NUMBER_TABLE();
268 a44 := JTF_NUMBER_TABLE();
269 if t.count > 0 then
270 a0.extend(t.count);
271 a1.extend(t.count);
272 a2.extend(t.count);
273 a3.extend(t.count);
274 a4.extend(t.count);
275 a5.extend(t.count);
276 a6.extend(t.count);
277 a7.extend(t.count);
278 a8.extend(t.count);
279 a9.extend(t.count);
280 a10.extend(t.count);
281 a11.extend(t.count);
282 a12.extend(t.count);
283 a13.extend(t.count);
284 a14.extend(t.count);
285 a15.extend(t.count);
286 a16.extend(t.count);
287 a17.extend(t.count);
288 a18.extend(t.count);
289 a19.extend(t.count);
290 a20.extend(t.count);
291 a21.extend(t.count);
292 a22.extend(t.count);
293 a23.extend(t.count);
294 a24.extend(t.count);
295 a25.extend(t.count);
296 a26.extend(t.count);
297 a27.extend(t.count);
298 a28.extend(t.count);
299 a29.extend(t.count);
300 a30.extend(t.count);
301 a31.extend(t.count);
302 a32.extend(t.count);
303 a33.extend(t.count);
304 a34.extend(t.count);
305 a35.extend(t.count);
306 a36.extend(t.count);
307 a37.extend(t.count);
308 a38.extend(t.count);
309 a39.extend(t.count);
310 a40.extend(t.count);
311 a41.extend(t.count);
312 a42.extend(t.count);
313 a43.extend(t.count);
314 a44.extend(t.count);
315 ddindx := t.first;
316 indx := 1;
317 while true loop
318 a0(indx) := rosetta_g_miss_num_map(t(ddindx).activity_id);
319 a1(indx) := rosetta_g_miss_num_map(t(ddindx).duration);
320 a2(indx) := rosetta_g_miss_num_map(t(ddindx).cust_account_id);
321 a3(indx) := rosetta_g_miss_num_map(t(ddindx).cust_org_id);
322 a4(indx) := t(ddindx).role;
323 a5(indx) := t(ddindx).end_date_time;
324 a6(indx) := t(ddindx).start_date_time;
325 a7(indx) := rosetta_g_miss_num_map(t(ddindx).task_id);
326 a8(indx) := rosetta_g_miss_num_map(t(ddindx).doc_id);
327 a9(indx) := t(ddindx).doc_ref;
328 a10(indx) := t(ddindx).doc_source_object_name;
329 a11(indx) := rosetta_g_miss_num_map(t(ddindx).media_id);
330 a12(indx) := rosetta_g_miss_num_map(t(ddindx).action_item_id);
331 a13(indx) := rosetta_g_miss_num_map(t(ddindx).interaction_id);
332 a14(indx) := rosetta_g_miss_num_map(t(ddindx).outcome_id);
333 a15(indx) := rosetta_g_miss_num_map(t(ddindx).result_id);
334 a16(indx) := rosetta_g_miss_num_map(t(ddindx).reason_id);
335 a17(indx) := t(ddindx).description;
336 a18(indx) := rosetta_g_miss_num_map(t(ddindx).action_id);
337 a19(indx) := t(ddindx).interaction_action_type;
338 a20(indx) := rosetta_g_miss_num_map(t(ddindx).object_id);
342 a24(indx) := rosetta_g_miss_num_map(t(ddindx).script_trans_id);
339 a21(indx) := t(ddindx).object_type;
340 a22(indx) := rosetta_g_miss_num_map(t(ddindx).source_code_id);
341 a23(indx) := t(ddindx).source_code;
343 a25(indx) := t(ddindx).attribute1;
344 a26(indx) := t(ddindx).attribute2;
345 a27(indx) := t(ddindx).attribute3;
346 a28(indx) := t(ddindx).attribute4;
347 a29(indx) := t(ddindx).attribute5;
348 a30(indx) := t(ddindx).attribute6;
349 a31(indx) := t(ddindx).attribute7;
350 a32(indx) := t(ddindx).attribute8;
351 a33(indx) := t(ddindx).attribute9;
352 a34(indx) := t(ddindx).attribute10;
353 a35(indx) := t(ddindx).attribute11;
354 a36(indx) := t(ddindx).attribute12;
355 a37(indx) := t(ddindx).attribute13;
356 a38(indx) := t(ddindx).attribute14;
357 a39(indx) := t(ddindx).attribute15;
358 a40(indx) := t(ddindx).attribute_category;
359 a41(indx) := t(ddindx).bulk_writer_code;
360 a42(indx) := t(ddindx).bulk_batch_type;
361 a43(indx) := rosetta_g_miss_num_map(t(ddindx).bulk_batch_id);
362 a44(indx) := rosetta_g_miss_num_map(t(ddindx).bulk_interaction_id);
363 indx := indx+1;
364 if t.last =ddindx
365 then exit;
366 end if;
367 ddindx := t.next(ddindx);
368 end loop;
369 end if;
370 end if;
371 end rosetta_table_copy_out_p3;
372
373 procedure rosetta_table_copy_in_p8(t out nocopy jtf_ih_pub.mlcs_tbl_type, a0 JTF_DATE_TABLE
374 , a1 JTF_VARCHAR2_TABLE_100
375 , a2 JTF_NUMBER_TABLE
376 , a3 JTF_NUMBER_TABLE
377 , a4 JTF_DATE_TABLE
378 , a5 JTF_NUMBER_TABLE
379 , a6 JTF_NUMBER_TABLE
380 , a7 JTF_NUMBER_TABLE
381 , a8 JTF_NUMBER_TABLE
382 , a9 JTF_NUMBER_TABLE
383 , a10 JTF_VARCHAR2_TABLE_100
384 , a11 JTF_VARCHAR2_TABLE_300
385 , a12 JTF_VARCHAR2_TABLE_300
386 , a13 JTF_NUMBER_TABLE
387 , a14 JTF_NUMBER_TABLE
388 ) as
389 ddindx binary_integer; indx binary_integer;
390 begin
391 if a0 is not null and a0.count > 0 then
392 if a0.count > 0 then
393 indx := a0.first;
394 ddindx := 1;
395 while true loop
396 t(ddindx).start_date_time := rosetta_g_miss_date_in_map(a0(indx));
397 t(ddindx).type_type := a1(indx);
398 t(ddindx).type_id := rosetta_g_miss_num_map(a2(indx));
399 t(ddindx).duration := rosetta_g_miss_num_map(a3(indx));
400 t(ddindx).end_date_time := rosetta_g_miss_date_in_map(a4(indx));
401 t(ddindx).milcs_id := rosetta_g_miss_num_map(a5(indx));
402 t(ddindx).milcs_type_id := rosetta_g_miss_num_map(a6(indx));
403 t(ddindx).media_id := rosetta_g_miss_num_map(a7(indx));
404 t(ddindx).handler_id := rosetta_g_miss_num_map(a8(indx));
405 t(ddindx).resource_id := rosetta_g_miss_num_map(a9(indx));
406 t(ddindx).milcs_code := a10(indx);
407 t(ddindx).bulk_writer_code := a11(indx);
408 t(ddindx).bulk_batch_type := a12(indx);
409 t(ddindx).bulk_batch_id := rosetta_g_miss_num_map(a13(indx));
410 t(ddindx).bulk_interaction_id := rosetta_g_miss_num_map(a14(indx));
411 ddindx := ddindx+1;
412 if a0.last =indx
413 then exit;
414 end if;
415 indx := a0.next(indx);
416 end loop;
417 end if;
418 end if;
419 end rosetta_table_copy_in_p8;
420 procedure rosetta_table_copy_out_p8(t jtf_ih_pub.mlcs_tbl_type, a0 out nocopy JTF_DATE_TABLE
421 , a1 out nocopy JTF_VARCHAR2_TABLE_100
422 , a2 out nocopy JTF_NUMBER_TABLE
423 , a3 out nocopy JTF_NUMBER_TABLE
424 , a4 out nocopy JTF_DATE_TABLE
425 , a5 out nocopy JTF_NUMBER_TABLE
426 , a6 out nocopy JTF_NUMBER_TABLE
427 , a7 out nocopy JTF_NUMBER_TABLE
428 , a8 out nocopy JTF_NUMBER_TABLE
429 , a9 out nocopy JTF_NUMBER_TABLE
430 , a10 out nocopy JTF_VARCHAR2_TABLE_100
431 , a11 out nocopy JTF_VARCHAR2_TABLE_300
432 , a12 out nocopy JTF_VARCHAR2_TABLE_300
433 , a13 out nocopy JTF_NUMBER_TABLE
434 , a14 out nocopy JTF_NUMBER_TABLE
435 ) as
436 ddindx binary_integer; indx binary_integer;
437 begin
438 if t is null or t.count = 0 then
439 a0 := JTF_DATE_TABLE();
440 a1 := JTF_VARCHAR2_TABLE_100();
441 a2 := JTF_NUMBER_TABLE();
442 a3 := JTF_NUMBER_TABLE();
443 a4 := JTF_DATE_TABLE();
444 a5 := JTF_NUMBER_TABLE();
445 a6 := JTF_NUMBER_TABLE();
446 a7 := JTF_NUMBER_TABLE();
447 a8 := JTF_NUMBER_TABLE();
448 a9 := JTF_NUMBER_TABLE();
449 a10 := JTF_VARCHAR2_TABLE_100();
450 a11 := JTF_VARCHAR2_TABLE_300();
451 a12 := JTF_VARCHAR2_TABLE_300();
452 a13 := JTF_NUMBER_TABLE();
453 a14 := JTF_NUMBER_TABLE();
454 else
455 a0 := JTF_DATE_TABLE();
456 a1 := JTF_VARCHAR2_TABLE_100();
457 a2 := JTF_NUMBER_TABLE();
458 a3 := JTF_NUMBER_TABLE();
459 a4 := JTF_DATE_TABLE();
460 a5 := JTF_NUMBER_TABLE();
464 a9 := JTF_NUMBER_TABLE();
461 a6 := JTF_NUMBER_TABLE();
462 a7 := JTF_NUMBER_TABLE();
463 a8 := JTF_NUMBER_TABLE();
465 a10 := JTF_VARCHAR2_TABLE_100();
466 a11 := JTF_VARCHAR2_TABLE_300();
467 a12 := JTF_VARCHAR2_TABLE_300();
468 a13 := JTF_NUMBER_TABLE();
469 a14 := JTF_NUMBER_TABLE();
470 if t.count > 0 then
471 a0.extend(t.count);
472 a1.extend(t.count);
473 a2.extend(t.count);
474 a3.extend(t.count);
475 a4.extend(t.count);
476 a5.extend(t.count);
477 a6.extend(t.count);
478 a7.extend(t.count);
479 a8.extend(t.count);
480 a9.extend(t.count);
481 a10.extend(t.count);
482 a11.extend(t.count);
483 a12.extend(t.count);
484 a13.extend(t.count);
485 a14.extend(t.count);
486 ddindx := t.first;
487 indx := 1;
488 while true loop
489 a0(indx) := t(ddindx).start_date_time;
490 a1(indx) := t(ddindx).type_type;
491 a2(indx) := rosetta_g_miss_num_map(t(ddindx).type_id);
492 a3(indx) := rosetta_g_miss_num_map(t(ddindx).duration);
493 a4(indx) := t(ddindx).end_date_time;
494 a5(indx) := rosetta_g_miss_num_map(t(ddindx).milcs_id);
495 a6(indx) := rosetta_g_miss_num_map(t(ddindx).milcs_type_id);
496 a7(indx) := rosetta_g_miss_num_map(t(ddindx).media_id);
497 a8(indx) := rosetta_g_miss_num_map(t(ddindx).handler_id);
498 a9(indx) := rosetta_g_miss_num_map(t(ddindx).resource_id);
499 a10(indx) := t(ddindx).milcs_code;
500 a11(indx) := t(ddindx).bulk_writer_code;
501 a12(indx) := t(ddindx).bulk_batch_type;
502 a13(indx) := rosetta_g_miss_num_map(t(ddindx).bulk_batch_id);
503 a14(indx) := rosetta_g_miss_num_map(t(ddindx).bulk_interaction_id);
504 indx := indx+1;
505 if t.last =ddindx
506 then exit;
507 end if;
508 ddindx := t.next(ddindx);
509 end loop;
510 end if;
511 end if;
512 end rosetta_table_copy_out_p8;
513
514 procedure create_interaction(p_api_version NUMBER
515 , p_init_msg_list VARCHAR2
516 , p_commit VARCHAR2
517 , p_resp_appl_id NUMBER
518 , p_resp_id NUMBER
519 , p_user_id NUMBER
520 , p_login_id NUMBER
521 , x_return_status out nocopy VARCHAR2
522 , x_msg_count out nocopy NUMBER
523 , x_msg_data out nocopy VARCHAR2
524 , p11_a0 JTF_NUMBER_TABLE
525 , p11_a1 JTF_NUMBER_TABLE
526 , p11_a2 JTF_NUMBER_TABLE
527 , p11_a3 JTF_NUMBER_TABLE
528 , p11_a4 JTF_VARCHAR2_TABLE_300
529 , p11_a5 JTF_DATE_TABLE
530 , p11_a6 JTF_DATE_TABLE
531 , p11_a7 JTF_NUMBER_TABLE
532 , p11_a8 JTF_NUMBER_TABLE
533 , p11_a9 JTF_VARCHAR2_TABLE_100
534 , p11_a10 JTF_VARCHAR2_TABLE_100
535 , p11_a11 JTF_NUMBER_TABLE
536 , p11_a12 JTF_NUMBER_TABLE
537 , p11_a13 JTF_NUMBER_TABLE
538 , p11_a14 JTF_NUMBER_TABLE
539 , p11_a15 JTF_NUMBER_TABLE
540 , p11_a16 JTF_NUMBER_TABLE
541 , p11_a17 JTF_VARCHAR2_TABLE_1000
542 , p11_a18 JTF_NUMBER_TABLE
543 , p11_a19 JTF_VARCHAR2_TABLE_300
544 , p11_a20 JTF_NUMBER_TABLE
545 , p11_a21 JTF_VARCHAR2_TABLE_100
546 , p11_a22 JTF_NUMBER_TABLE
547 , p11_a23 JTF_VARCHAR2_TABLE_100
548 , p11_a24 JTF_NUMBER_TABLE
549 , p11_a25 JTF_VARCHAR2_TABLE_200
550 , p11_a26 JTF_VARCHAR2_TABLE_200
554 , p11_a30 JTF_VARCHAR2_TABLE_200
551 , p11_a27 JTF_VARCHAR2_TABLE_200
552 , p11_a28 JTF_VARCHAR2_TABLE_200
553 , p11_a29 JTF_VARCHAR2_TABLE_200
555 , p11_a31 JTF_VARCHAR2_TABLE_200
556 , p11_a32 JTF_VARCHAR2_TABLE_200
557 , p11_a33 JTF_VARCHAR2_TABLE_200
558 , p11_a34 JTF_VARCHAR2_TABLE_200
559 , p11_a35 JTF_VARCHAR2_TABLE_200
560 , p11_a36 JTF_VARCHAR2_TABLE_200
561 , p11_a37 JTF_VARCHAR2_TABLE_200
562 , p11_a38 JTF_VARCHAR2_TABLE_200
563 , p11_a39 JTF_VARCHAR2_TABLE_200
564 , p11_a40 JTF_VARCHAR2_TABLE_100
565 , p11_a41 JTF_VARCHAR2_TABLE_300
566 , p11_a42 JTF_VARCHAR2_TABLE_300
567 , p11_a43 JTF_NUMBER_TABLE
568 , p11_a44 JTF_NUMBER_TABLE
569 , p10_a0 NUMBER := 0-1962.0724
570 , p10_a1 VARCHAR2 := fnd_api.g_miss_char
571 , p10_a2 VARCHAR2 := fnd_api.g_miss_char
572 , p10_a3 NUMBER := 0-1962.0724
573 , p10_a4 DATE := fnd_api.g_miss_date
574 , p10_a5 NUMBER := 0-1962.0724
575 , p10_a6 NUMBER := 0-1962.0724
576 , p10_a7 NUMBER := 0-1962.0724
577 , p10_a8 NUMBER := 0-1962.0724
578 , p10_a9 DATE := fnd_api.g_miss_date
579 , p10_a10 NUMBER := 0-1962.0724
580 , p10_a11 NUMBER := 0-1962.0724
581 , p10_a12 NUMBER := 0-1962.0724
582 , p10_a13 NUMBER := 0-1962.0724
583 , p10_a14 NUMBER := 0-1962.0724
584 , p10_a15 NUMBER := 0-1962.0724
585 , p10_a16 NUMBER := 0-1962.0724
586 , p10_a17 NUMBER := 0-1962.0724
587 , p10_a18 NUMBER := 0-1962.0724
588 , p10_a19 NUMBER := 0-1962.0724
589 , p10_a20 VARCHAR2 := fnd_api.g_miss_char
590 , p10_a21 NUMBER := 0-1962.0724
591 , p10_a22 VARCHAR2 := fnd_api.g_miss_char
592 , p10_a23 VARCHAR2 := fnd_api.g_miss_char
593 , p10_a24 VARCHAR2 := fnd_api.g_miss_char
594 , p10_a25 VARCHAR2 := fnd_api.g_miss_char
595 , p10_a26 VARCHAR2 := fnd_api.g_miss_char
596 , p10_a27 VARCHAR2 := fnd_api.g_miss_char
597 , p10_a28 VARCHAR2 := fnd_api.g_miss_char
598 , p10_a29 VARCHAR2 := fnd_api.g_miss_char
599 , p10_a30 VARCHAR2 := fnd_api.g_miss_char
600 , p10_a31 VARCHAR2 := fnd_api.g_miss_char
601 , p10_a32 VARCHAR2 := fnd_api.g_miss_char
602 , p10_a33 VARCHAR2 := fnd_api.g_miss_char
603 , p10_a34 VARCHAR2 := fnd_api.g_miss_char
604 , p10_a35 VARCHAR2 := fnd_api.g_miss_char
605 , p10_a36 VARCHAR2 := fnd_api.g_miss_char
606 , p10_a37 VARCHAR2 := fnd_api.g_miss_char
607 , p10_a38 VARCHAR2 := fnd_api.g_miss_char
608 , p10_a39 VARCHAR2 := 'PARTY'
609 , p10_a40 VARCHAR2 := 'RS_EMPLOYEE'
610 , p10_a41 VARCHAR2 := fnd_api.g_miss_char
611 , p10_a42 VARCHAR2 := fnd_api.g_miss_char
612 , p10_a43 VARCHAR2 := fnd_api.g_miss_char
613 , p10_a44 NUMBER := 0-1962.0724
614 , p10_a45 NUMBER := 0-1962.0724
615 , p10_a46 NUMBER := 0-1962.0724
616 , p10_a47 NUMBER := 0-1962.0724
617 , p10_a48 NUMBER := 0-1962.0724
618 )
619
620 as
621 ddp_interaction_rec jtf_ih_pub.interaction_rec_type;
622 ddp_activities jtf_ih_pub.activity_tbl_type;
623 ddindx binary_integer; indx binary_integer;
624 begin
625
626 -- copy data to the local IN or IN-OUT args, if any
627
628
629
630
631
632
633
634
635
636
637 ddp_interaction_rec.interaction_id := rosetta_g_miss_num_map(p10_a0);
638 ddp_interaction_rec.reference_form := p10_a1;
639 ddp_interaction_rec.follow_up_action := p10_a2;
640 ddp_interaction_rec.duration := rosetta_g_miss_num_map(p10_a3);
641 ddp_interaction_rec.end_date_time := rosetta_g_miss_date_in_map(p10_a4);
642 ddp_interaction_rec.inter_interaction_duration := rosetta_g_miss_num_map(p10_a5);
643 ddp_interaction_rec.non_productive_time_amount := rosetta_g_miss_num_map(p10_a6);
644 ddp_interaction_rec.preview_time_amount := rosetta_g_miss_num_map(p10_a7);
645 ddp_interaction_rec.productive_time_amount := rosetta_g_miss_num_map(p10_a8);
646 ddp_interaction_rec.start_date_time := rosetta_g_miss_date_in_map(p10_a9);
647 ddp_interaction_rec.wrapup_time_amount := rosetta_g_miss_num_map(p10_a10);
648 ddp_interaction_rec.handler_id := rosetta_g_miss_num_map(p10_a11);
649 ddp_interaction_rec.script_id := rosetta_g_miss_num_map(p10_a12);
650 ddp_interaction_rec.outcome_id := rosetta_g_miss_num_map(p10_a13);
651 ddp_interaction_rec.result_id := rosetta_g_miss_num_map(p10_a14);
652 ddp_interaction_rec.reason_id := rosetta_g_miss_num_map(p10_a15);
653 ddp_interaction_rec.resource_id := rosetta_g_miss_num_map(p10_a16);
654 ddp_interaction_rec.party_id := rosetta_g_miss_num_map(p10_a17);
655 ddp_interaction_rec.parent_id := rosetta_g_miss_num_map(p10_a18);
656 ddp_interaction_rec.object_id := rosetta_g_miss_num_map(p10_a19);
657 ddp_interaction_rec.object_type := p10_a20;
658 ddp_interaction_rec.source_code_id := rosetta_g_miss_num_map(p10_a21);
659 ddp_interaction_rec.source_code := p10_a22;
660 ddp_interaction_rec.attribute1 := p10_a23;
661 ddp_interaction_rec.attribute2 := p10_a24;
662 ddp_interaction_rec.attribute3 := p10_a25;
663 ddp_interaction_rec.attribute4 := p10_a26;
664 ddp_interaction_rec.attribute5 := p10_a27;
665 ddp_interaction_rec.attribute6 := p10_a28;
666 ddp_interaction_rec.attribute7 := p10_a29;
667 ddp_interaction_rec.attribute8 := p10_a30;
668 ddp_interaction_rec.attribute9 := p10_a31;
672 ddp_interaction_rec.attribute13 := p10_a35;
669 ddp_interaction_rec.attribute10 := p10_a32;
670 ddp_interaction_rec.attribute11 := p10_a33;
671 ddp_interaction_rec.attribute12 := p10_a34;
673 ddp_interaction_rec.attribute14 := p10_a36;
674 ddp_interaction_rec.attribute15 := p10_a37;
675 ddp_interaction_rec.attribute_category := p10_a38;
676 ddp_interaction_rec.touchpoint1_type := p10_a39;
677 ddp_interaction_rec.touchpoint2_type := p10_a40;
678 ddp_interaction_rec.method_code := p10_a41;
679 ddp_interaction_rec.bulk_writer_code := p10_a42;
680 ddp_interaction_rec.bulk_batch_type := p10_a43;
681 ddp_interaction_rec.bulk_batch_id := rosetta_g_miss_num_map(p10_a44);
682 ddp_interaction_rec.bulk_interaction_id := rosetta_g_miss_num_map(p10_a45);
683 ddp_interaction_rec.primary_party_id := rosetta_g_miss_num_map(p10_a46);
684 ddp_interaction_rec.contact_rel_party_id := rosetta_g_miss_num_map(p10_a47);
685 ddp_interaction_rec.contact_party_id := rosetta_g_miss_num_map(p10_a48);
686
687 jtf_ih_pub_w.rosetta_table_copy_in_p3(ddp_activities, p11_a0
688 , p11_a1
689 , p11_a2
690 , p11_a3
691 , p11_a4
692 , p11_a5
693 , p11_a6
694 , p11_a7
695 , p11_a8
696 , p11_a9
697 , p11_a10
698 , p11_a11
699 , p11_a12
700 , p11_a13
701 , p11_a14
702 , p11_a15
703 , p11_a16
704 , p11_a17
705 , p11_a18
706 , p11_a19
707 , p11_a20
708 , p11_a21
709 , p11_a22
710 , p11_a23
711 , p11_a24
712 , p11_a25
713 , p11_a26
714 , p11_a27
715 , p11_a28
716 , p11_a29
717 , p11_a30
718 , p11_a31
719 , p11_a32
720 , p11_a33
721 , p11_a34
722 , p11_a35
723 , p11_a36
724 , p11_a37
725 , p11_a38
726 , p11_a39
727 , p11_a40
728 , p11_a41
729 , p11_a42
730 , p11_a43
731 , p11_a44
732 );
733
734 -- here's the delegated call to the old PL/SQL routine
735 jtf_ih_pub.create_interaction(p_api_version,
736 p_init_msg_list,
737 p_commit,
738 p_resp_appl_id,
739 p_resp_id,
740 p_user_id,
741 p_login_id,
742 x_return_status,
743 x_msg_count,
744 x_msg_data,
745 ddp_interaction_rec,
746 ddp_activities);
747
748 -- copy data back from the local variables to OUT or IN-OUT args, if any
749
750
751
752
753
754
755
756
757
758
759
760 end;
761
762 procedure create_mediaitem(p_api_version NUMBER
763 , p_init_msg_list VARCHAR2
764 , p_commit VARCHAR2
765 , p_resp_appl_id NUMBER
766 , p_resp_id NUMBER
767 , p_user_id NUMBER
768 , p_login_id NUMBER
769 , x_return_status out nocopy VARCHAR2
770 , x_msg_count out nocopy NUMBER
771 , x_msg_data out nocopy VARCHAR2
772 , p11_a0 JTF_DATE_TABLE
773 , p11_a1 JTF_VARCHAR2_TABLE_100
774 , p11_a2 JTF_NUMBER_TABLE
775 , p11_a3 JTF_NUMBER_TABLE
776 , p11_a4 JTF_DATE_TABLE
777 , p11_a5 JTF_NUMBER_TABLE
778 , p11_a6 JTF_NUMBER_TABLE
779 , p11_a7 JTF_NUMBER_TABLE
780 , p11_a8 JTF_NUMBER_TABLE
781 , p11_a9 JTF_NUMBER_TABLE
782 , p11_a10 JTF_VARCHAR2_TABLE_100
783 , p11_a11 JTF_VARCHAR2_TABLE_300
784 , p11_a12 JTF_VARCHAR2_TABLE_300
785 , p11_a13 JTF_NUMBER_TABLE
786 , p11_a14 JTF_NUMBER_TABLE
787 , p10_a0 NUMBER := 0-1962.0724
788 , p10_a1 NUMBER := 0-1962.0724
789 , p10_a2 VARCHAR2 := fnd_api.g_miss_char
790 , p10_a3 NUMBER := 0-1962.0724
791 , p10_a4 DATE := fnd_api.g_miss_date
792 , p10_a5 VARCHAR2 := fnd_api.g_miss_char
793 , p10_a6 DATE := fnd_api.g_miss_date
794 , p10_a7 VARCHAR2 := fnd_api.g_miss_char
795 , p10_a8 DATE := fnd_api.g_miss_date
796 , p10_a9 NUMBER := 0-1962.0724
797 , p10_a10 VARCHAR2 := fnd_api.g_miss_char
798 , p10_a11 VARCHAR2 := fnd_api.g_miss_char
799 , p10_a12 VARCHAR2 := fnd_api.g_miss_char
800 , p10_a13 VARCHAR2 := fnd_api.g_miss_char
801 , p10_a14 NUMBER := 0-1962.0724
802 , p10_a15 VARCHAR2 := fnd_api.g_miss_char
803 , p10_a16 VARCHAR2 := fnd_api.g_miss_char
804 , p10_a17 VARCHAR2 := fnd_api.g_miss_char
805 , p10_a18 VARCHAR2 := fnd_api.g_miss_char
806 , p10_a19 VARCHAR2 := fnd_api.g_miss_char
807 , p10_a20 NUMBER := 0-1962.0724
808 , p10_a21 NUMBER := 0-1962.0724
809 , p10_a22 VARCHAR2 := fnd_api.g_miss_char
810 )
811
812 as
813 ddp_media jtf_ih_pub.media_rec_type;
814 ddp_mlcs jtf_ih_pub.mlcs_tbl_type;
815 ddindx binary_integer; indx binary_integer;
816 begin
817
818 -- copy data to the local IN or IN-OUT args, if any
819
820
821
822
823
824
825
826
827
828
829 ddp_media.media_id := rosetta_g_miss_num_map(p10_a0);
830 ddp_media.source_id := rosetta_g_miss_num_map(p10_a1);
834 ddp_media.interaction_performed := p10_a5;
831 ddp_media.direction := p10_a2;
832 ddp_media.duration := rosetta_g_miss_num_map(p10_a3);
833 ddp_media.end_date_time := rosetta_g_miss_date_in_map(p10_a4);
835 ddp_media.start_date_time := rosetta_g_miss_date_in_map(p10_a6);
836 ddp_media.media_data := p10_a7;
837 ddp_media.source_item_create_date_time := rosetta_g_miss_date_in_map(p10_a8);
838 ddp_media.source_item_id := rosetta_g_miss_num_map(p10_a9);
839 ddp_media.media_item_type := p10_a10;
840 ddp_media.media_item_ref := p10_a11;
841 ddp_media.media_abandon_flag := p10_a12;
842 ddp_media.media_transferred_flag := p10_a13;
843 ddp_media.server_group_id := rosetta_g_miss_num_map(p10_a14);
844 ddp_media.dnis := p10_a15;
845 ddp_media.ani := p10_a16;
846 ddp_media.classification := p10_a17;
847 ddp_media.bulk_writer_code := p10_a18;
848 ddp_media.bulk_batch_type := p10_a19;
849 ddp_media.bulk_batch_id := rosetta_g_miss_num_map(p10_a20);
850 ddp_media.bulk_interaction_id := rosetta_g_miss_num_map(p10_a21);
851 ddp_media.address := p10_a22;
852
853 jtf_ih_pub_w.rosetta_table_copy_in_p8(ddp_mlcs, p11_a0
854 , p11_a1
855 , p11_a2
856 , p11_a3
857 , p11_a4
858 , p11_a5
859 , p11_a6
860 , p11_a7
861 , p11_a8
862 , p11_a9
863 , p11_a10
864 , p11_a11
865 , p11_a12
866 , p11_a13
867 , p11_a14
868 );
869
870 -- here's the delegated call to the old PL/SQL routine
871 jtf_ih_pub.create_mediaitem(p_api_version,
872 p_init_msg_list,
873 p_commit,
874 p_resp_appl_id,
875 p_resp_id,
876 p_user_id,
877 p_login_id,
878 x_return_status,
879 x_msg_count,
880 x_msg_data,
881 ddp_media,
882 ddp_mlcs);
883
884 -- copy data back from the local variables to OUT or IN-OUT args, if any
885
886
887
888
889
890
891
892
893
894
895
896 end;
897
898 procedure create_mediaitem(p_api_version NUMBER
899 , p_init_msg_list VARCHAR2
900 , p_commit VARCHAR2
901 , p_resp_appl_id NUMBER
902 , p_resp_id NUMBER
903 , p_user_id NUMBER
904 , p_login_id NUMBER
905 , x_return_status out nocopy VARCHAR2
906 , x_msg_count out nocopy NUMBER
907 , x_msg_data out nocopy VARCHAR2
908 , x_media_id out nocopy NUMBER
909 , p10_a0 NUMBER := 0-1962.0724
910 , p10_a1 NUMBER := 0-1962.0724
911 , p10_a2 VARCHAR2 := fnd_api.g_miss_char
912 , p10_a3 NUMBER := 0-1962.0724
913 , p10_a4 DATE := fnd_api.g_miss_date
914 , p10_a5 VARCHAR2 := fnd_api.g_miss_char
915 , p10_a6 DATE := fnd_api.g_miss_date
916 , p10_a7 VARCHAR2 := fnd_api.g_miss_char
917 , p10_a8 DATE := fnd_api.g_miss_date
918 , p10_a9 NUMBER := 0-1962.0724
919 , p10_a10 VARCHAR2 := fnd_api.g_miss_char
920 , p10_a11 VARCHAR2 := fnd_api.g_miss_char
921 , p10_a12 VARCHAR2 := fnd_api.g_miss_char
922 , p10_a13 VARCHAR2 := fnd_api.g_miss_char
923 , p10_a14 NUMBER := 0-1962.0724
924 , p10_a15 VARCHAR2 := fnd_api.g_miss_char
925 , p10_a16 VARCHAR2 := fnd_api.g_miss_char
926 , p10_a17 VARCHAR2 := fnd_api.g_miss_char
927 , p10_a18 VARCHAR2 := fnd_api.g_miss_char
928 , p10_a19 VARCHAR2 := fnd_api.g_miss_char
929 , p10_a20 NUMBER := 0-1962.0724
930 , p10_a21 NUMBER := 0-1962.0724
931 , p10_a22 VARCHAR2 := fnd_api.g_miss_char
932 )
933
934 as
935 ddp_media_rec jtf_ih_pub.media_rec_type;
936 ddindx binary_integer; indx binary_integer;
937 begin
938
939 -- copy data to the local IN or IN-OUT args, if any
940
941
942
943
944
945
946
947
948
949
950 ddp_media_rec.media_id := rosetta_g_miss_num_map(p10_a0);
951 ddp_media_rec.source_id := rosetta_g_miss_num_map(p10_a1);
952 ddp_media_rec.direction := p10_a2;
953 ddp_media_rec.duration := rosetta_g_miss_num_map(p10_a3);
954 ddp_media_rec.end_date_time := rosetta_g_miss_date_in_map(p10_a4);
955 ddp_media_rec.interaction_performed := p10_a5;
956 ddp_media_rec.start_date_time := rosetta_g_miss_date_in_map(p10_a6);
957 ddp_media_rec.media_data := p10_a7;
958 ddp_media_rec.source_item_create_date_time := rosetta_g_miss_date_in_map(p10_a8);
959 ddp_media_rec.source_item_id := rosetta_g_miss_num_map(p10_a9);
960 ddp_media_rec.media_item_type := p10_a10;
961 ddp_media_rec.media_item_ref := p10_a11;
962 ddp_media_rec.media_abandon_flag := p10_a12;
963 ddp_media_rec.media_transferred_flag := p10_a13;
964 ddp_media_rec.server_group_id := rosetta_g_miss_num_map(p10_a14);
965 ddp_media_rec.dnis := p10_a15;
966 ddp_media_rec.ani := p10_a16;
967 ddp_media_rec.classification := p10_a17;
968 ddp_media_rec.bulk_writer_code := p10_a18;
969 ddp_media_rec.bulk_batch_type := p10_a19;
970 ddp_media_rec.bulk_batch_id := rosetta_g_miss_num_map(p10_a20);
971 ddp_media_rec.bulk_interaction_id := rosetta_g_miss_num_map(p10_a21);
972 ddp_media_rec.address := p10_a22;
973
974
978 p_commit,
975 -- here's the delegated call to the old PL/SQL routine
976 jtf_ih_pub.create_mediaitem(p_api_version,
977 p_init_msg_list,
979 p_resp_appl_id,
980 p_resp_id,
981 p_user_id,
982 p_login_id,
983 x_return_status,
984 x_msg_count,
985 x_msg_data,
986 ddp_media_rec,
987 x_media_id);
988
989 -- copy data back from the local variables to OUT or IN-OUT args, if any
990
991
992
993
994
995
996
997
998
999
1000
1001 end;
1002
1003 procedure create_medialifecycle(p_api_version NUMBER
1004 , p_init_msg_list VARCHAR2
1005 , p_commit VARCHAR2
1006 , p_resp_appl_id NUMBER
1007 , p_resp_id NUMBER
1008 , p_user_id NUMBER
1009 , p_login_id NUMBER
1010 , x_return_status out nocopy VARCHAR2
1011 , x_msg_count out nocopy NUMBER
1012 , x_msg_data out nocopy VARCHAR2
1013 , p10_a0 DATE := fnd_api.g_miss_date
1014 , p10_a1 VARCHAR2 := fnd_api.g_miss_char
1015 , p10_a2 NUMBER := 0-1962.0724
1016 , p10_a3 NUMBER := 0-1962.0724
1017 , p10_a4 DATE := fnd_api.g_miss_date
1018 , p10_a5 NUMBER := 0-1962.0724
1019 , p10_a6 NUMBER := 0-1962.0724
1020 , p10_a7 NUMBER := 0-1962.0724
1021 , p10_a8 NUMBER := 0-1962.0724
1022 , p10_a9 NUMBER := 0-1962.0724
1023 , p10_a10 VARCHAR2 := fnd_api.g_miss_char
1024 , p10_a11 VARCHAR2 := fnd_api.g_miss_char
1025 , p10_a12 VARCHAR2 := fnd_api.g_miss_char
1026 , p10_a13 NUMBER := 0-1962.0724
1027 , p10_a14 NUMBER := 0-1962.0724
1028 )
1029
1030 as
1031 ddp_media_lc_rec jtf_ih_pub.media_lc_rec_type;
1032 ddindx binary_integer; indx binary_integer;
1033 begin
1034
1035 -- copy data to the local IN or IN-OUT args, if any
1036
1037
1038
1039
1040
1041
1042
1043
1044
1045
1046 ddp_media_lc_rec.start_date_time := rosetta_g_miss_date_in_map(p10_a0);
1047 ddp_media_lc_rec.type_type := p10_a1;
1048 ddp_media_lc_rec.type_id := rosetta_g_miss_num_map(p10_a2);
1049 ddp_media_lc_rec.duration := rosetta_g_miss_num_map(p10_a3);
1050 ddp_media_lc_rec.end_date_time := rosetta_g_miss_date_in_map(p10_a4);
1051 ddp_media_lc_rec.milcs_id := rosetta_g_miss_num_map(p10_a5);
1052 ddp_media_lc_rec.milcs_type_id := rosetta_g_miss_num_map(p10_a6);
1053 ddp_media_lc_rec.media_id := rosetta_g_miss_num_map(p10_a7);
1054 ddp_media_lc_rec.handler_id := rosetta_g_miss_num_map(p10_a8);
1055 ddp_media_lc_rec.resource_id := rosetta_g_miss_num_map(p10_a9);
1056 ddp_media_lc_rec.milcs_code := p10_a10;
1057 ddp_media_lc_rec.bulk_writer_code := p10_a11;
1058 ddp_media_lc_rec.bulk_batch_type := p10_a12;
1059 ddp_media_lc_rec.bulk_batch_id := rosetta_g_miss_num_map(p10_a13);
1060 ddp_media_lc_rec.bulk_interaction_id := rosetta_g_miss_num_map(p10_a14);
1061
1062 -- here's the delegated call to the old PL/SQL routine
1063 jtf_ih_pub.create_medialifecycle(p_api_version,
1064 p_init_msg_list,
1065 p_commit,
1066 p_resp_appl_id,
1067 p_resp_id,
1068 p_user_id,
1069 p_login_id,
1070 x_return_status,
1071 x_msg_count,
1072 x_msg_data,
1073 ddp_media_lc_rec);
1074
1075 -- copy data back from the local variables to OUT or IN-OUT args, if any
1076
1077
1078
1079
1080
1081
1082
1083
1084
1085
1086 end;
1087
1088 procedure open_interaction(p_api_version NUMBER
1089 , p_init_msg_list VARCHAR2
1090 , p_commit VARCHAR2
1091 , p_resp_appl_id NUMBER
1092 , p_resp_id NUMBER
1093 , p_user_id NUMBER
1094 , p_login_id NUMBER
1095 , x_return_status out nocopy VARCHAR2
1096 , x_msg_count out nocopy NUMBER
1097 , x_msg_data out nocopy VARCHAR2
1098 , x_interaction_id out nocopy NUMBER
1099 , p10_a0 NUMBER := 0-1962.0724
1100 , p10_a1 VARCHAR2 := fnd_api.g_miss_char
1101 , p10_a2 VARCHAR2 := fnd_api.g_miss_char
1102 , p10_a3 NUMBER := 0-1962.0724
1103 , p10_a4 DATE := fnd_api.g_miss_date
1104 , p10_a5 NUMBER := 0-1962.0724
1105 , p10_a6 NUMBER := 0-1962.0724
1106 , p10_a7 NUMBER := 0-1962.0724
1107 , p10_a8 NUMBER := 0-1962.0724
1108 , p10_a9 DATE := fnd_api.g_miss_date
1109 , p10_a10 NUMBER := 0-1962.0724
1110 , p10_a11 NUMBER := 0-1962.0724
1111 , p10_a12 NUMBER := 0-1962.0724
1112 , p10_a13 NUMBER := 0-1962.0724
1113 , p10_a14 NUMBER := 0-1962.0724
1114 , p10_a15 NUMBER := 0-1962.0724
1115 , p10_a16 NUMBER := 0-1962.0724
1116 , p10_a17 NUMBER := 0-1962.0724
1117 , p10_a18 NUMBER := 0-1962.0724
1118 , p10_a19 NUMBER := 0-1962.0724
1119 , p10_a20 VARCHAR2 := fnd_api.g_miss_char
1120 , p10_a21 NUMBER := 0-1962.0724
1121 , p10_a22 VARCHAR2 := fnd_api.g_miss_char
1122 , p10_a23 VARCHAR2 := fnd_api.g_miss_char
1123 , p10_a24 VARCHAR2 := fnd_api.g_miss_char
1124 , p10_a25 VARCHAR2 := fnd_api.g_miss_char
1125 , p10_a26 VARCHAR2 := fnd_api.g_miss_char
1126 , p10_a27 VARCHAR2 := fnd_api.g_miss_char
1127 , p10_a28 VARCHAR2 := fnd_api.g_miss_char
1131 , p10_a32 VARCHAR2 := fnd_api.g_miss_char
1128 , p10_a29 VARCHAR2 := fnd_api.g_miss_char
1129 , p10_a30 VARCHAR2 := fnd_api.g_miss_char
1130 , p10_a31 VARCHAR2 := fnd_api.g_miss_char
1132 , p10_a33 VARCHAR2 := fnd_api.g_miss_char
1133 , p10_a34 VARCHAR2 := fnd_api.g_miss_char
1134 , p10_a35 VARCHAR2 := fnd_api.g_miss_char
1135 , p10_a36 VARCHAR2 := fnd_api.g_miss_char
1136 , p10_a37 VARCHAR2 := fnd_api.g_miss_char
1137 , p10_a38 VARCHAR2 := fnd_api.g_miss_char
1138 , p10_a39 VARCHAR2 := 'PARTY'
1139 , p10_a40 VARCHAR2 := 'RS_EMPLOYEE'
1140 , p10_a41 VARCHAR2 := fnd_api.g_miss_char
1141 , p10_a42 VARCHAR2 := fnd_api.g_miss_char
1142 , p10_a43 VARCHAR2 := fnd_api.g_miss_char
1143 , p10_a44 NUMBER := 0-1962.0724
1144 , p10_a45 NUMBER := 0-1962.0724
1145 , p10_a46 NUMBER := 0-1962.0724
1146 , p10_a47 NUMBER := 0-1962.0724
1147 , p10_a48 NUMBER := 0-1962.0724
1148 )
1149
1150 as
1151 ddp_interaction_rec jtf_ih_pub.interaction_rec_type;
1152 ddindx binary_integer; indx binary_integer;
1153 begin
1154
1155 -- copy data to the local IN or IN-OUT args, if any
1156
1157
1158
1159
1160
1161
1162
1163
1164
1165
1166 ddp_interaction_rec.interaction_id := rosetta_g_miss_num_map(p10_a0);
1167 ddp_interaction_rec.reference_form := p10_a1;
1168 ddp_interaction_rec.follow_up_action := p10_a2;
1169 ddp_interaction_rec.duration := rosetta_g_miss_num_map(p10_a3);
1170 ddp_interaction_rec.end_date_time := rosetta_g_miss_date_in_map(p10_a4);
1171 ddp_interaction_rec.inter_interaction_duration := rosetta_g_miss_num_map(p10_a5);
1172 ddp_interaction_rec.non_productive_time_amount := rosetta_g_miss_num_map(p10_a6);
1173 ddp_interaction_rec.preview_time_amount := rosetta_g_miss_num_map(p10_a7);
1174 ddp_interaction_rec.productive_time_amount := rosetta_g_miss_num_map(p10_a8);
1175 ddp_interaction_rec.start_date_time := rosetta_g_miss_date_in_map(p10_a9);
1176 ddp_interaction_rec.wrapup_time_amount := rosetta_g_miss_num_map(p10_a10);
1177 ddp_interaction_rec.handler_id := rosetta_g_miss_num_map(p10_a11);
1178 ddp_interaction_rec.script_id := rosetta_g_miss_num_map(p10_a12);
1179 ddp_interaction_rec.outcome_id := rosetta_g_miss_num_map(p10_a13);
1180 ddp_interaction_rec.result_id := rosetta_g_miss_num_map(p10_a14);
1181 ddp_interaction_rec.reason_id := rosetta_g_miss_num_map(p10_a15);
1182 ddp_interaction_rec.resource_id := rosetta_g_miss_num_map(p10_a16);
1183 ddp_interaction_rec.party_id := rosetta_g_miss_num_map(p10_a17);
1184 ddp_interaction_rec.parent_id := rosetta_g_miss_num_map(p10_a18);
1185 ddp_interaction_rec.object_id := rosetta_g_miss_num_map(p10_a19);
1186 ddp_interaction_rec.object_type := p10_a20;
1187 ddp_interaction_rec.source_code_id := rosetta_g_miss_num_map(p10_a21);
1188 ddp_interaction_rec.source_code := p10_a22;
1189 ddp_interaction_rec.attribute1 := p10_a23;
1190 ddp_interaction_rec.attribute2 := p10_a24;
1191 ddp_interaction_rec.attribute3 := p10_a25;
1192 ddp_interaction_rec.attribute4 := p10_a26;
1193 ddp_interaction_rec.attribute5 := p10_a27;
1194 ddp_interaction_rec.attribute6 := p10_a28;
1195 ddp_interaction_rec.attribute7 := p10_a29;
1196 ddp_interaction_rec.attribute8 := p10_a30;
1197 ddp_interaction_rec.attribute9 := p10_a31;
1198 ddp_interaction_rec.attribute10 := p10_a32;
1199 ddp_interaction_rec.attribute11 := p10_a33;
1200 ddp_interaction_rec.attribute12 := p10_a34;
1201 ddp_interaction_rec.attribute13 := p10_a35;
1202 ddp_interaction_rec.attribute14 := p10_a36;
1203 ddp_interaction_rec.attribute15 := p10_a37;
1204 ddp_interaction_rec.attribute_category := p10_a38;
1205 ddp_interaction_rec.touchpoint1_type := p10_a39;
1206 ddp_interaction_rec.touchpoint2_type := p10_a40;
1207 ddp_interaction_rec.method_code := p10_a41;
1208 ddp_interaction_rec.bulk_writer_code := p10_a42;
1209 ddp_interaction_rec.bulk_batch_type := p10_a43;
1210 ddp_interaction_rec.bulk_batch_id := rosetta_g_miss_num_map(p10_a44);
1211 ddp_interaction_rec.bulk_interaction_id := rosetta_g_miss_num_map(p10_a45);
1212 ddp_interaction_rec.primary_party_id := rosetta_g_miss_num_map(p10_a46);
1213 ddp_interaction_rec.contact_rel_party_id := rosetta_g_miss_num_map(p10_a47);
1214 ddp_interaction_rec.contact_party_id := rosetta_g_miss_num_map(p10_a48);
1215
1216
1217 -- here's the delegated call to the old PL/SQL routine
1218 jtf_ih_pub.open_interaction(p_api_version,
1219 p_init_msg_list,
1220 p_commit,
1221 p_resp_appl_id,
1222 p_resp_id,
1223 p_user_id,
1224 p_login_id,
1225 x_return_status,
1226 x_msg_count,
1227 x_msg_data,
1228 ddp_interaction_rec,
1229 x_interaction_id);
1230
1231 -- copy data back from the local variables to OUT or IN-OUT args, if any
1232
1233
1234
1235
1236
1237
1238
1239
1240
1241
1242
1243 end;
1244
1245 procedure update_interaction(p_api_version NUMBER
1246 , p_init_msg_list VARCHAR2
1247 , p_commit VARCHAR2
1248 , p_resp_appl_id NUMBER
1249 , p_resp_id NUMBER
1250 , p_user_id NUMBER
1251 , p_login_id NUMBER
1252 , x_return_status out nocopy VARCHAR2
1253 , x_msg_count out nocopy NUMBER
1254 , x_msg_data out nocopy VARCHAR2
1258 , p10_a2 VARCHAR2 := fnd_api.g_miss_char
1255 , p_object_version NUMBER
1256 , p10_a0 NUMBER := 0-1962.0724
1257 , p10_a1 VARCHAR2 := fnd_api.g_miss_char
1259 , p10_a3 NUMBER := 0-1962.0724
1260 , p10_a4 DATE := fnd_api.g_miss_date
1261 , p10_a5 NUMBER := 0-1962.0724
1262 , p10_a6 NUMBER := 0-1962.0724
1263 , p10_a7 NUMBER := 0-1962.0724
1264 , p10_a8 NUMBER := 0-1962.0724
1265 , p10_a9 DATE := fnd_api.g_miss_date
1266 , p10_a10 NUMBER := 0-1962.0724
1267 , p10_a11 NUMBER := 0-1962.0724
1268 , p10_a12 NUMBER := 0-1962.0724
1269 , p10_a13 NUMBER := 0-1962.0724
1270 , p10_a14 NUMBER := 0-1962.0724
1271 , p10_a15 NUMBER := 0-1962.0724
1272 , p10_a16 NUMBER := 0-1962.0724
1273 , p10_a17 NUMBER := 0-1962.0724
1274 , p10_a18 NUMBER := 0-1962.0724
1275 , p10_a19 NUMBER := 0-1962.0724
1276 , p10_a20 VARCHAR2 := fnd_api.g_miss_char
1277 , p10_a21 NUMBER := 0-1962.0724
1278 , p10_a22 VARCHAR2 := fnd_api.g_miss_char
1279 , p10_a23 VARCHAR2 := fnd_api.g_miss_char
1280 , p10_a24 VARCHAR2 := fnd_api.g_miss_char
1281 , p10_a25 VARCHAR2 := fnd_api.g_miss_char
1282 , p10_a26 VARCHAR2 := fnd_api.g_miss_char
1283 , p10_a27 VARCHAR2 := fnd_api.g_miss_char
1284 , p10_a28 VARCHAR2 := fnd_api.g_miss_char
1285 , p10_a29 VARCHAR2 := fnd_api.g_miss_char
1286 , p10_a30 VARCHAR2 := fnd_api.g_miss_char
1287 , p10_a31 VARCHAR2 := fnd_api.g_miss_char
1288 , p10_a32 VARCHAR2 := fnd_api.g_miss_char
1289 , p10_a33 VARCHAR2 := fnd_api.g_miss_char
1290 , p10_a34 VARCHAR2 := fnd_api.g_miss_char
1291 , p10_a35 VARCHAR2 := fnd_api.g_miss_char
1292 , p10_a36 VARCHAR2 := fnd_api.g_miss_char
1293 , p10_a37 VARCHAR2 := fnd_api.g_miss_char
1294 , p10_a38 VARCHAR2 := fnd_api.g_miss_char
1295 , p10_a39 VARCHAR2 := 'PARTY'
1296 , p10_a40 VARCHAR2 := 'RS_EMPLOYEE'
1297 , p10_a41 VARCHAR2 := fnd_api.g_miss_char
1298 , p10_a42 VARCHAR2 := fnd_api.g_miss_char
1299 , p10_a43 VARCHAR2 := fnd_api.g_miss_char
1300 , p10_a44 NUMBER := 0-1962.0724
1301 , p10_a45 NUMBER := 0-1962.0724
1302 , p10_a46 NUMBER := 0-1962.0724
1303 , p10_a47 NUMBER := 0-1962.0724
1304 , p10_a48 NUMBER := 0-1962.0724
1305 )
1306
1307 as
1308 ddp_interaction_rec jtf_ih_pub.interaction_rec_type;
1309 ddindx binary_integer; indx binary_integer;
1310 begin
1311
1312 -- copy data to the local IN or IN-OUT args, if any
1313
1314
1315
1316
1317
1318
1319
1320
1321
1322
1323 ddp_interaction_rec.interaction_id := rosetta_g_miss_num_map(p10_a0);
1324 ddp_interaction_rec.reference_form := p10_a1;
1325 ddp_interaction_rec.follow_up_action := p10_a2;
1326 ddp_interaction_rec.duration := rosetta_g_miss_num_map(p10_a3);
1327 ddp_interaction_rec.end_date_time := rosetta_g_miss_date_in_map(p10_a4);
1328 ddp_interaction_rec.inter_interaction_duration := rosetta_g_miss_num_map(p10_a5);
1329 ddp_interaction_rec.non_productive_time_amount := rosetta_g_miss_num_map(p10_a6);
1330 ddp_interaction_rec.preview_time_amount := rosetta_g_miss_num_map(p10_a7);
1331 ddp_interaction_rec.productive_time_amount := rosetta_g_miss_num_map(p10_a8);
1332 ddp_interaction_rec.start_date_time := rosetta_g_miss_date_in_map(p10_a9);
1333 ddp_interaction_rec.wrapup_time_amount := rosetta_g_miss_num_map(p10_a10);
1334 ddp_interaction_rec.handler_id := rosetta_g_miss_num_map(p10_a11);
1335 ddp_interaction_rec.script_id := rosetta_g_miss_num_map(p10_a12);
1336 ddp_interaction_rec.outcome_id := rosetta_g_miss_num_map(p10_a13);
1337 ddp_interaction_rec.result_id := rosetta_g_miss_num_map(p10_a14);
1338 ddp_interaction_rec.reason_id := rosetta_g_miss_num_map(p10_a15);
1339 ddp_interaction_rec.resource_id := rosetta_g_miss_num_map(p10_a16);
1340 ddp_interaction_rec.party_id := rosetta_g_miss_num_map(p10_a17);
1341 ddp_interaction_rec.parent_id := rosetta_g_miss_num_map(p10_a18);
1342 ddp_interaction_rec.object_id := rosetta_g_miss_num_map(p10_a19);
1343 ddp_interaction_rec.object_type := p10_a20;
1344 ddp_interaction_rec.source_code_id := rosetta_g_miss_num_map(p10_a21);
1345 ddp_interaction_rec.source_code := p10_a22;
1346 ddp_interaction_rec.attribute1 := p10_a23;
1347 ddp_interaction_rec.attribute2 := p10_a24;
1348 ddp_interaction_rec.attribute3 := p10_a25;
1349 ddp_interaction_rec.attribute4 := p10_a26;
1350 ddp_interaction_rec.attribute5 := p10_a27;
1351 ddp_interaction_rec.attribute6 := p10_a28;
1352 ddp_interaction_rec.attribute7 := p10_a29;
1353 ddp_interaction_rec.attribute8 := p10_a30;
1354 ddp_interaction_rec.attribute9 := p10_a31;
1355 ddp_interaction_rec.attribute10 := p10_a32;
1356 ddp_interaction_rec.attribute11 := p10_a33;
1357 ddp_interaction_rec.attribute12 := p10_a34;
1358 ddp_interaction_rec.attribute13 := p10_a35;
1359 ddp_interaction_rec.attribute14 := p10_a36;
1360 ddp_interaction_rec.attribute15 := p10_a37;
1361 ddp_interaction_rec.attribute_category := p10_a38;
1362 ddp_interaction_rec.touchpoint1_type := p10_a39;
1363 ddp_interaction_rec.touchpoint2_type := p10_a40;
1364 ddp_interaction_rec.method_code := p10_a41;
1365 ddp_interaction_rec.bulk_writer_code := p10_a42;
1366 ddp_interaction_rec.bulk_batch_type := p10_a43;
1370 ddp_interaction_rec.contact_rel_party_id := rosetta_g_miss_num_map(p10_a47);
1367 ddp_interaction_rec.bulk_batch_id := rosetta_g_miss_num_map(p10_a44);
1368 ddp_interaction_rec.bulk_interaction_id := rosetta_g_miss_num_map(p10_a45);
1369 ddp_interaction_rec.primary_party_id := rosetta_g_miss_num_map(p10_a46);
1371 ddp_interaction_rec.contact_party_id := rosetta_g_miss_num_map(p10_a48);
1372
1373
1374 -- here's the delegated call to the old PL/SQL routine
1375 jtf_ih_pub.update_interaction(p_api_version,
1376 p_init_msg_list,
1377 p_commit,
1378 p_resp_appl_id,
1379 p_resp_id,
1380 p_user_id,
1381 p_login_id,
1382 x_return_status,
1383 x_msg_count,
1384 x_msg_data,
1385 ddp_interaction_rec,
1386 p_object_version);
1387
1388 -- copy data back from the local variables to OUT or IN-OUT args, if any
1389
1390
1391
1392
1393
1394
1395
1396
1397
1398
1399
1400 end;
1401
1402 procedure close_interaction(p_api_version NUMBER
1403 , p_init_msg_list VARCHAR2
1404 , p_commit VARCHAR2
1405 , p_resp_appl_id NUMBER
1406 , p_resp_id NUMBER
1407 , p_user_id NUMBER
1408 , p_login_id NUMBER
1409 , x_return_status out nocopy VARCHAR2
1410 , x_msg_count out nocopy NUMBER
1411 , x_msg_data out nocopy VARCHAR2
1412 , p_object_version NUMBER
1413 , p10_a0 NUMBER := 0-1962.0724
1414 , p10_a1 VARCHAR2 := fnd_api.g_miss_char
1415 , p10_a2 VARCHAR2 := fnd_api.g_miss_char
1416 , p10_a3 NUMBER := 0-1962.0724
1417 , p10_a4 DATE := fnd_api.g_miss_date
1418 , p10_a5 NUMBER := 0-1962.0724
1419 , p10_a6 NUMBER := 0-1962.0724
1420 , p10_a7 NUMBER := 0-1962.0724
1421 , p10_a8 NUMBER := 0-1962.0724
1422 , p10_a9 DATE := fnd_api.g_miss_date
1423 , p10_a10 NUMBER := 0-1962.0724
1424 , p10_a11 NUMBER := 0-1962.0724
1425 , p10_a12 NUMBER := 0-1962.0724
1426 , p10_a13 NUMBER := 0-1962.0724
1427 , p10_a14 NUMBER := 0-1962.0724
1428 , p10_a15 NUMBER := 0-1962.0724
1429 , p10_a16 NUMBER := 0-1962.0724
1430 , p10_a17 NUMBER := 0-1962.0724
1431 , p10_a18 NUMBER := 0-1962.0724
1432 , p10_a19 NUMBER := 0-1962.0724
1433 , p10_a20 VARCHAR2 := fnd_api.g_miss_char
1434 , p10_a21 NUMBER := 0-1962.0724
1435 , p10_a22 VARCHAR2 := fnd_api.g_miss_char
1436 , p10_a23 VARCHAR2 := fnd_api.g_miss_char
1437 , p10_a24 VARCHAR2 := fnd_api.g_miss_char
1438 , p10_a25 VARCHAR2 := fnd_api.g_miss_char
1439 , p10_a26 VARCHAR2 := fnd_api.g_miss_char
1440 , p10_a27 VARCHAR2 := fnd_api.g_miss_char
1441 , p10_a28 VARCHAR2 := fnd_api.g_miss_char
1442 , p10_a29 VARCHAR2 := fnd_api.g_miss_char
1443 , p10_a30 VARCHAR2 := fnd_api.g_miss_char
1444 , p10_a31 VARCHAR2 := fnd_api.g_miss_char
1445 , p10_a32 VARCHAR2 := fnd_api.g_miss_char
1446 , p10_a33 VARCHAR2 := fnd_api.g_miss_char
1447 , p10_a34 VARCHAR2 := fnd_api.g_miss_char
1448 , p10_a35 VARCHAR2 := fnd_api.g_miss_char
1449 , p10_a36 VARCHAR2 := fnd_api.g_miss_char
1450 , p10_a37 VARCHAR2 := fnd_api.g_miss_char
1451 , p10_a38 VARCHAR2 := fnd_api.g_miss_char
1452 , p10_a39 VARCHAR2 := 'PARTY'
1453 , p10_a40 VARCHAR2 := 'RS_EMPLOYEE'
1454 , p10_a41 VARCHAR2 := fnd_api.g_miss_char
1455 , p10_a42 VARCHAR2 := fnd_api.g_miss_char
1456 , p10_a43 VARCHAR2 := fnd_api.g_miss_char
1457 , p10_a44 NUMBER := 0-1962.0724
1458 , p10_a45 NUMBER := 0-1962.0724
1459 , p10_a46 NUMBER := 0-1962.0724
1460 , p10_a47 NUMBER := 0-1962.0724
1461 , p10_a48 NUMBER := 0-1962.0724
1462 )
1463
1464 as
1465 ddp_interaction_rec jtf_ih_pub.interaction_rec_type;
1466 ddindx binary_integer; indx binary_integer;
1467 begin
1468
1469 -- copy data to the local IN or IN-OUT args, if any
1470
1471
1472
1473
1474
1475
1476
1477
1478
1479
1480 ddp_interaction_rec.interaction_id := rosetta_g_miss_num_map(p10_a0);
1481 ddp_interaction_rec.reference_form := p10_a1;
1482 ddp_interaction_rec.follow_up_action := p10_a2;
1483 ddp_interaction_rec.duration := rosetta_g_miss_num_map(p10_a3);
1484 ddp_interaction_rec.end_date_time := rosetta_g_miss_date_in_map(p10_a4);
1485 ddp_interaction_rec.inter_interaction_duration := rosetta_g_miss_num_map(p10_a5);
1486 ddp_interaction_rec.non_productive_time_amount := rosetta_g_miss_num_map(p10_a6);
1487 ddp_interaction_rec.preview_time_amount := rosetta_g_miss_num_map(p10_a7);
1488 ddp_interaction_rec.productive_time_amount := rosetta_g_miss_num_map(p10_a8);
1489 ddp_interaction_rec.start_date_time := rosetta_g_miss_date_in_map(p10_a9);
1490 ddp_interaction_rec.wrapup_time_amount := rosetta_g_miss_num_map(p10_a10);
1491 ddp_interaction_rec.handler_id := rosetta_g_miss_num_map(p10_a11);
1492 ddp_interaction_rec.script_id := rosetta_g_miss_num_map(p10_a12);
1493 ddp_interaction_rec.outcome_id := rosetta_g_miss_num_map(p10_a13);
1494 ddp_interaction_rec.result_id := rosetta_g_miss_num_map(p10_a14);
1495 ddp_interaction_rec.reason_id := rosetta_g_miss_num_map(p10_a15);
1496 ddp_interaction_rec.resource_id := rosetta_g_miss_num_map(p10_a16);
1500 ddp_interaction_rec.object_type := p10_a20;
1497 ddp_interaction_rec.party_id := rosetta_g_miss_num_map(p10_a17);
1498 ddp_interaction_rec.parent_id := rosetta_g_miss_num_map(p10_a18);
1499 ddp_interaction_rec.object_id := rosetta_g_miss_num_map(p10_a19);
1501 ddp_interaction_rec.source_code_id := rosetta_g_miss_num_map(p10_a21);
1502 ddp_interaction_rec.source_code := p10_a22;
1503 ddp_interaction_rec.attribute1 := p10_a23;
1504 ddp_interaction_rec.attribute2 := p10_a24;
1505 ddp_interaction_rec.attribute3 := p10_a25;
1506 ddp_interaction_rec.attribute4 := p10_a26;
1507 ddp_interaction_rec.attribute5 := p10_a27;
1508 ddp_interaction_rec.attribute6 := p10_a28;
1509 ddp_interaction_rec.attribute7 := p10_a29;
1510 ddp_interaction_rec.attribute8 := p10_a30;
1511 ddp_interaction_rec.attribute9 := p10_a31;
1512 ddp_interaction_rec.attribute10 := p10_a32;
1513 ddp_interaction_rec.attribute11 := p10_a33;
1514 ddp_interaction_rec.attribute12 := p10_a34;
1515 ddp_interaction_rec.attribute13 := p10_a35;
1516 ddp_interaction_rec.attribute14 := p10_a36;
1517 ddp_interaction_rec.attribute15 := p10_a37;
1518 ddp_interaction_rec.attribute_category := p10_a38;
1519 ddp_interaction_rec.touchpoint1_type := p10_a39;
1520 ddp_interaction_rec.touchpoint2_type := p10_a40;
1521 ddp_interaction_rec.method_code := p10_a41;
1522 ddp_interaction_rec.bulk_writer_code := p10_a42;
1523 ddp_interaction_rec.bulk_batch_type := p10_a43;
1524 ddp_interaction_rec.bulk_batch_id := rosetta_g_miss_num_map(p10_a44);
1525 ddp_interaction_rec.bulk_interaction_id := rosetta_g_miss_num_map(p10_a45);
1526 ddp_interaction_rec.primary_party_id := rosetta_g_miss_num_map(p10_a46);
1527 ddp_interaction_rec.contact_rel_party_id := rosetta_g_miss_num_map(p10_a47);
1528 ddp_interaction_rec.contact_party_id := rosetta_g_miss_num_map(p10_a48);
1529
1530
1531 -- here's the delegated call to the old PL/SQL routine
1532 jtf_ih_pub.close_interaction(p_api_version,
1533 p_init_msg_list,
1534 p_commit,
1535 p_resp_appl_id,
1536 p_resp_id,
1537 p_user_id,
1538 p_login_id,
1539 x_return_status,
1540 x_msg_count,
1541 x_msg_data,
1542 ddp_interaction_rec,
1543 p_object_version);
1544
1545 -- copy data back from the local variables to OUT or IN-OUT args, if any
1546
1547
1548
1549
1550
1551
1552
1553
1554
1555
1556
1557 end;
1558
1559 procedure add_activity(p_api_version NUMBER
1560 , p_init_msg_list VARCHAR2
1561 , p_commit VARCHAR2
1562 , p_resp_appl_id NUMBER
1563 , p_resp_id NUMBER
1564 , p_user_id NUMBER
1565 , p_login_id NUMBER
1566 , x_return_status out nocopy VARCHAR2
1567 , x_msg_count out nocopy NUMBER
1568 , x_msg_data out nocopy VARCHAR2
1569 , x_activity_id out nocopy NUMBER
1570 , p10_a0 NUMBER := 0-1962.0724
1571 , p10_a1 NUMBER := 0-1962.0724
1572 , p10_a2 NUMBER := 0-1962.0724
1573 , p10_a3 NUMBER := 0-1962.0724
1574 , p10_a4 VARCHAR2 := fnd_api.g_miss_char
1575 , p10_a5 DATE := fnd_api.g_miss_date
1576 , p10_a6 DATE := fnd_api.g_miss_date
1577 , p10_a7 NUMBER := 0-1962.0724
1578 , p10_a8 NUMBER := 0-1962.0724
1579 , p10_a9 VARCHAR2 := fnd_api.g_miss_char
1580 , p10_a10 VARCHAR2 := fnd_api.g_miss_char
1581 , p10_a11 NUMBER := 0-1962.0724
1582 , p10_a12 NUMBER := 0-1962.0724
1583 , p10_a13 NUMBER := 0-1962.0724
1584 , p10_a14 NUMBER := 0-1962.0724
1585 , p10_a15 NUMBER := 0-1962.0724
1586 , p10_a16 NUMBER := 0-1962.0724
1587 , p10_a17 VARCHAR2 := fnd_api.g_miss_char
1588 , p10_a18 NUMBER := 0-1962.0724
1589 , p10_a19 VARCHAR2 := fnd_api.g_miss_char
1590 , p10_a20 NUMBER := 0-1962.0724
1591 , p10_a21 VARCHAR2 := fnd_api.g_miss_char
1592 , p10_a22 NUMBER := 0-1962.0724
1593 , p10_a23 VARCHAR2 := fnd_api.g_miss_char
1594 , p10_a24 NUMBER := 0-1962.0724
1595 , p10_a25 VARCHAR2 := fnd_api.g_miss_char
1596 , p10_a26 VARCHAR2 := fnd_api.g_miss_char
1597 , p10_a27 VARCHAR2 := fnd_api.g_miss_char
1598 , p10_a28 VARCHAR2 := fnd_api.g_miss_char
1599 , p10_a29 VARCHAR2 := fnd_api.g_miss_char
1600 , p10_a30 VARCHAR2 := fnd_api.g_miss_char
1601 , p10_a31 VARCHAR2 := fnd_api.g_miss_char
1602 , p10_a32 VARCHAR2 := fnd_api.g_miss_char
1603 , p10_a33 VARCHAR2 := fnd_api.g_miss_char
1604 , p10_a34 VARCHAR2 := fnd_api.g_miss_char
1605 , p10_a35 VARCHAR2 := fnd_api.g_miss_char
1606 , p10_a36 VARCHAR2 := fnd_api.g_miss_char
1607 , p10_a37 VARCHAR2 := fnd_api.g_miss_char
1608 , p10_a38 VARCHAR2 := fnd_api.g_miss_char
1609 , p10_a39 VARCHAR2 := fnd_api.g_miss_char
1610 , p10_a40 VARCHAR2 := fnd_api.g_miss_char
1611 , p10_a41 VARCHAR2 := fnd_api.g_miss_char
1612 , p10_a42 VARCHAR2 := fnd_api.g_miss_char
1613 , p10_a43 NUMBER := 0-1962.0724
1614 , p10_a44 NUMBER := 0-1962.0724
1615 )
1616
1617 as
1618 ddp_activity_rec jtf_ih_pub.activity_rec_type;
1619 ddindx binary_integer; indx binary_integer;
1620 begin
1621
1622 -- copy data to the local IN or IN-OUT args, if any
1623
1624
1625
1626
1627
1628
1629
1630
1631
1632
1633 ddp_activity_rec.activity_id := rosetta_g_miss_num_map(p10_a0);
1637 ddp_activity_rec.role := p10_a4;
1634 ddp_activity_rec.duration := rosetta_g_miss_num_map(p10_a1);
1635 ddp_activity_rec.cust_account_id := rosetta_g_miss_num_map(p10_a2);
1636 ddp_activity_rec.cust_org_id := rosetta_g_miss_num_map(p10_a3);
1638 ddp_activity_rec.end_date_time := rosetta_g_miss_date_in_map(p10_a5);
1639 ddp_activity_rec.start_date_time := rosetta_g_miss_date_in_map(p10_a6);
1640 ddp_activity_rec.task_id := rosetta_g_miss_num_map(p10_a7);
1641 ddp_activity_rec.doc_id := rosetta_g_miss_num_map(p10_a8);
1642 ddp_activity_rec.doc_ref := p10_a9;
1643 ddp_activity_rec.doc_source_object_name := p10_a10;
1644 ddp_activity_rec.media_id := rosetta_g_miss_num_map(p10_a11);
1645 ddp_activity_rec.action_item_id := rosetta_g_miss_num_map(p10_a12);
1646 ddp_activity_rec.interaction_id := rosetta_g_miss_num_map(p10_a13);
1647 ddp_activity_rec.outcome_id := rosetta_g_miss_num_map(p10_a14);
1648 ddp_activity_rec.result_id := rosetta_g_miss_num_map(p10_a15);
1649 ddp_activity_rec.reason_id := rosetta_g_miss_num_map(p10_a16);
1650 ddp_activity_rec.description := p10_a17;
1651 ddp_activity_rec.action_id := rosetta_g_miss_num_map(p10_a18);
1652 ddp_activity_rec.interaction_action_type := p10_a19;
1653 ddp_activity_rec.object_id := rosetta_g_miss_num_map(p10_a20);
1654 ddp_activity_rec.object_type := p10_a21;
1655 ddp_activity_rec.source_code_id := rosetta_g_miss_num_map(p10_a22);
1656 ddp_activity_rec.source_code := p10_a23;
1657 ddp_activity_rec.script_trans_id := rosetta_g_miss_num_map(p10_a24);
1658 ddp_activity_rec.attribute1 := p10_a25;
1659 ddp_activity_rec.attribute2 := p10_a26;
1660 ddp_activity_rec.attribute3 := p10_a27;
1661 ddp_activity_rec.attribute4 := p10_a28;
1662 ddp_activity_rec.attribute5 := p10_a29;
1663 ddp_activity_rec.attribute6 := p10_a30;
1664 ddp_activity_rec.attribute7 := p10_a31;
1665 ddp_activity_rec.attribute8 := p10_a32;
1666 ddp_activity_rec.attribute9 := p10_a33;
1667 ddp_activity_rec.attribute10 := p10_a34;
1668 ddp_activity_rec.attribute11 := p10_a35;
1669 ddp_activity_rec.attribute12 := p10_a36;
1670 ddp_activity_rec.attribute13 := p10_a37;
1671 ddp_activity_rec.attribute14 := p10_a38;
1672 ddp_activity_rec.attribute15 := p10_a39;
1673 ddp_activity_rec.attribute_category := p10_a40;
1674 ddp_activity_rec.bulk_writer_code := p10_a41;
1675 ddp_activity_rec.bulk_batch_type := p10_a42;
1676 ddp_activity_rec.bulk_batch_id := rosetta_g_miss_num_map(p10_a43);
1677 ddp_activity_rec.bulk_interaction_id := rosetta_g_miss_num_map(p10_a44);
1678
1679
1680 -- here's the delegated call to the old PL/SQL routine
1681 jtf_ih_pub.add_activity(p_api_version,
1682 p_init_msg_list,
1683 p_commit,
1684 p_resp_appl_id,
1685 p_resp_id,
1686 p_user_id,
1687 p_login_id,
1688 x_return_status,
1689 x_msg_count,
1690 x_msg_data,
1691 ddp_activity_rec,
1692 x_activity_id);
1693
1694 -- copy data back from the local variables to OUT or IN-OUT args, if any
1695
1696
1697
1698
1699
1700
1701
1702
1703
1704
1705
1706 end;
1707
1708 procedure update_activity(p_api_version NUMBER
1709 , p_init_msg_list VARCHAR2
1710 , p_commit VARCHAR2
1711 , p_resp_appl_id NUMBER
1712 , p_resp_id NUMBER
1713 , p_user_id NUMBER
1714 , p_login_id NUMBER
1715 , x_return_status out nocopy VARCHAR2
1716 , x_msg_count out nocopy NUMBER
1717 , x_msg_data out nocopy VARCHAR2
1718 , p_object_version NUMBER
1719 , p10_a0 NUMBER := 0-1962.0724
1720 , p10_a1 NUMBER := 0-1962.0724
1721 , p10_a2 NUMBER := 0-1962.0724
1722 , p10_a3 NUMBER := 0-1962.0724
1723 , p10_a4 VARCHAR2 := fnd_api.g_miss_char
1724 , p10_a5 DATE := fnd_api.g_miss_date
1725 , p10_a6 DATE := fnd_api.g_miss_date
1726 , p10_a7 NUMBER := 0-1962.0724
1727 , p10_a8 NUMBER := 0-1962.0724
1728 , p10_a9 VARCHAR2 := fnd_api.g_miss_char
1729 , p10_a10 VARCHAR2 := fnd_api.g_miss_char
1730 , p10_a11 NUMBER := 0-1962.0724
1731 , p10_a12 NUMBER := 0-1962.0724
1732 , p10_a13 NUMBER := 0-1962.0724
1733 , p10_a14 NUMBER := 0-1962.0724
1734 , p10_a15 NUMBER := 0-1962.0724
1735 , p10_a16 NUMBER := 0-1962.0724
1736 , p10_a17 VARCHAR2 := fnd_api.g_miss_char
1737 , p10_a18 NUMBER := 0-1962.0724
1738 , p10_a19 VARCHAR2 := fnd_api.g_miss_char
1739 , p10_a20 NUMBER := 0-1962.0724
1740 , p10_a21 VARCHAR2 := fnd_api.g_miss_char
1741 , p10_a22 NUMBER := 0-1962.0724
1742 , p10_a23 VARCHAR2 := fnd_api.g_miss_char
1743 , p10_a24 NUMBER := 0-1962.0724
1744 , p10_a25 VARCHAR2 := fnd_api.g_miss_char
1745 , p10_a26 VARCHAR2 := fnd_api.g_miss_char
1746 , p10_a27 VARCHAR2 := fnd_api.g_miss_char
1747 , p10_a28 VARCHAR2 := fnd_api.g_miss_char
1748 , p10_a29 VARCHAR2 := fnd_api.g_miss_char
1749 , p10_a30 VARCHAR2 := fnd_api.g_miss_char
1750 , p10_a31 VARCHAR2 := fnd_api.g_miss_char
1751 , p10_a32 VARCHAR2 := fnd_api.g_miss_char
1752 , p10_a33 VARCHAR2 := fnd_api.g_miss_char
1753 , p10_a34 VARCHAR2 := fnd_api.g_miss_char
1754 , p10_a35 VARCHAR2 := fnd_api.g_miss_char
1755 , p10_a36 VARCHAR2 := fnd_api.g_miss_char
1756 , p10_a37 VARCHAR2 := fnd_api.g_miss_char
1757 , p10_a38 VARCHAR2 := fnd_api.g_miss_char
1761 , p10_a42 VARCHAR2 := fnd_api.g_miss_char
1758 , p10_a39 VARCHAR2 := fnd_api.g_miss_char
1759 , p10_a40 VARCHAR2 := fnd_api.g_miss_char
1760 , p10_a41 VARCHAR2 := fnd_api.g_miss_char
1762 , p10_a43 NUMBER := 0-1962.0724
1763 , p10_a44 NUMBER := 0-1962.0724
1764 )
1765
1766 as
1767 ddp_activity_rec jtf_ih_pub.activity_rec_type;
1768 ddindx binary_integer; indx binary_integer;
1769 begin
1770
1771 -- copy data to the local IN or IN-OUT args, if any
1772
1773
1774
1775
1776
1777
1778
1779
1780
1781
1782 ddp_activity_rec.activity_id := rosetta_g_miss_num_map(p10_a0);
1783 ddp_activity_rec.duration := rosetta_g_miss_num_map(p10_a1);
1784 ddp_activity_rec.cust_account_id := rosetta_g_miss_num_map(p10_a2);
1785 ddp_activity_rec.cust_org_id := rosetta_g_miss_num_map(p10_a3);
1786 ddp_activity_rec.role := p10_a4;
1787 ddp_activity_rec.end_date_time := rosetta_g_miss_date_in_map(p10_a5);
1788 ddp_activity_rec.start_date_time := rosetta_g_miss_date_in_map(p10_a6);
1789 ddp_activity_rec.task_id := rosetta_g_miss_num_map(p10_a7);
1790 ddp_activity_rec.doc_id := rosetta_g_miss_num_map(p10_a8);
1791 ddp_activity_rec.doc_ref := p10_a9;
1792 ddp_activity_rec.doc_source_object_name := p10_a10;
1793 ddp_activity_rec.media_id := rosetta_g_miss_num_map(p10_a11);
1794 ddp_activity_rec.action_item_id := rosetta_g_miss_num_map(p10_a12);
1795 ddp_activity_rec.interaction_id := rosetta_g_miss_num_map(p10_a13);
1796 ddp_activity_rec.outcome_id := rosetta_g_miss_num_map(p10_a14);
1797 ddp_activity_rec.result_id := rosetta_g_miss_num_map(p10_a15);
1798 ddp_activity_rec.reason_id := rosetta_g_miss_num_map(p10_a16);
1799 ddp_activity_rec.description := p10_a17;
1800 ddp_activity_rec.action_id := rosetta_g_miss_num_map(p10_a18);
1801 ddp_activity_rec.interaction_action_type := p10_a19;
1802 ddp_activity_rec.object_id := rosetta_g_miss_num_map(p10_a20);
1803 ddp_activity_rec.object_type := p10_a21;
1804 ddp_activity_rec.source_code_id := rosetta_g_miss_num_map(p10_a22);
1805 ddp_activity_rec.source_code := p10_a23;
1806 ddp_activity_rec.script_trans_id := rosetta_g_miss_num_map(p10_a24);
1807 ddp_activity_rec.attribute1 := p10_a25;
1808 ddp_activity_rec.attribute2 := p10_a26;
1809 ddp_activity_rec.attribute3 := p10_a27;
1810 ddp_activity_rec.attribute4 := p10_a28;
1811 ddp_activity_rec.attribute5 := p10_a29;
1812 ddp_activity_rec.attribute6 := p10_a30;
1813 ddp_activity_rec.attribute7 := p10_a31;
1814 ddp_activity_rec.attribute8 := p10_a32;
1815 ddp_activity_rec.attribute9 := p10_a33;
1816 ddp_activity_rec.attribute10 := p10_a34;
1817 ddp_activity_rec.attribute11 := p10_a35;
1818 ddp_activity_rec.attribute12 := p10_a36;
1819 ddp_activity_rec.attribute13 := p10_a37;
1820 ddp_activity_rec.attribute14 := p10_a38;
1821 ddp_activity_rec.attribute15 := p10_a39;
1822 ddp_activity_rec.attribute_category := p10_a40;
1823 ddp_activity_rec.bulk_writer_code := p10_a41;
1824 ddp_activity_rec.bulk_batch_type := p10_a42;
1825 ddp_activity_rec.bulk_batch_id := rosetta_g_miss_num_map(p10_a43);
1826 ddp_activity_rec.bulk_interaction_id := rosetta_g_miss_num_map(p10_a44);
1827
1828
1829 -- here's the delegated call to the old PL/SQL routine
1830 jtf_ih_pub.update_activity(p_api_version,
1831 p_init_msg_list,
1832 p_commit,
1833 p_resp_appl_id,
1834 p_resp_id,
1835 p_user_id,
1836 p_login_id,
1837 x_return_status,
1838 x_msg_count,
1839 x_msg_data,
1840 ddp_activity_rec,
1841 p_object_version);
1842
1843 -- copy data back from the local variables to OUT or IN-OUT args, if any
1844
1845
1846
1847
1848
1849
1850
1851
1852
1853
1854
1855 end;
1856
1857 procedure update_activityduration(p_api_version NUMBER
1858 , p_init_msg_list VARCHAR2
1859 , p_commit VARCHAR2
1860 , p_resp_appl_id NUMBER
1861 , p_resp_id NUMBER
1862 , p_user_id NUMBER
1863 , p_login_id NUMBER
1864 , x_return_status out nocopy VARCHAR2
1865 , x_msg_count out nocopy NUMBER
1866 , x_msg_data out nocopy VARCHAR2
1867 , p_activity_id NUMBER
1868 , p_end_date_time date
1869 , p_duration NUMBER
1870 , p_object_version NUMBER
1871 )
1872
1873 as
1874 ddp_end_date_time date;
1875 ddindx binary_integer; indx binary_integer;
1876 begin
1877
1878 -- copy data to the local IN or IN-OUT args, if any
1879
1880
1881
1882
1883
1884
1885
1886
1887
1888
1889
1890 ddp_end_date_time := rosetta_g_miss_date_in_map(p_end_date_time);
1891
1892
1893
1894 -- here's the delegated call to the old PL/SQL routine
1895 jtf_ih_pub.update_activityduration(p_api_version,
1896 p_init_msg_list,
1897 p_commit,
1898 p_resp_appl_id,
1899 p_resp_id,
1900 p_user_id,
1901 p_login_id,
1902 x_return_status,
1903 x_msg_count,
1904 x_msg_data,
1905 p_activity_id,
1906 ddp_end_date_time,
1907 p_duration,
1908 p_object_version);
1909
1913
1910 -- copy data back from the local variables to OUT or IN-OUT args, if any
1911
1912
1914
1915
1916
1917
1918
1919
1920
1921
1922
1923
1924 end;
1925
1926 procedure open_mediaitem(p_api_version NUMBER
1927 , p_init_msg_list VARCHAR2
1928 , p_commit VARCHAR2
1929 , p_resp_appl_id NUMBER
1930 , p_resp_id NUMBER
1931 , p_user_id NUMBER
1932 , p_login_id NUMBER
1933 , x_return_status out nocopy VARCHAR2
1934 , x_msg_count out nocopy NUMBER
1935 , x_msg_data out nocopy VARCHAR2
1936 , x_media_id out nocopy NUMBER
1937 , p10_a0 NUMBER := 0-1962.0724
1938 , p10_a1 NUMBER := 0-1962.0724
1939 , p10_a2 VARCHAR2 := fnd_api.g_miss_char
1940 , p10_a3 NUMBER := 0-1962.0724
1941 , p10_a4 DATE := fnd_api.g_miss_date
1942 , p10_a5 VARCHAR2 := fnd_api.g_miss_char
1943 , p10_a6 DATE := fnd_api.g_miss_date
1944 , p10_a7 VARCHAR2 := fnd_api.g_miss_char
1945 , p10_a8 DATE := fnd_api.g_miss_date
1946 , p10_a9 NUMBER := 0-1962.0724
1947 , p10_a10 VARCHAR2 := fnd_api.g_miss_char
1948 , p10_a11 VARCHAR2 := fnd_api.g_miss_char
1949 , p10_a12 VARCHAR2 := fnd_api.g_miss_char
1950 , p10_a13 VARCHAR2 := fnd_api.g_miss_char
1951 , p10_a14 NUMBER := 0-1962.0724
1952 , p10_a15 VARCHAR2 := fnd_api.g_miss_char
1953 , p10_a16 VARCHAR2 := fnd_api.g_miss_char
1954 , p10_a17 VARCHAR2 := fnd_api.g_miss_char
1955 , p10_a18 VARCHAR2 := fnd_api.g_miss_char
1956 , p10_a19 VARCHAR2 := fnd_api.g_miss_char
1957 , p10_a20 NUMBER := 0-1962.0724
1958 , p10_a21 NUMBER := 0-1962.0724
1959 , p10_a22 VARCHAR2 := fnd_api.g_miss_char
1960 )
1961
1962 as
1963 ddp_media_rec jtf_ih_pub.media_rec_type;
1964 ddindx binary_integer; indx binary_integer;
1965 begin
1966
1967 -- copy data to the local IN or IN-OUT args, if any
1968
1969
1970
1971
1972
1973
1974
1975
1976
1977
1978 ddp_media_rec.media_id := rosetta_g_miss_num_map(p10_a0);
1979 ddp_media_rec.source_id := rosetta_g_miss_num_map(p10_a1);
1980 ddp_media_rec.direction := p10_a2;
1981 ddp_media_rec.duration := rosetta_g_miss_num_map(p10_a3);
1982 ddp_media_rec.end_date_time := rosetta_g_miss_date_in_map(p10_a4);
1983 ddp_media_rec.interaction_performed := p10_a5;
1984 ddp_media_rec.start_date_time := rosetta_g_miss_date_in_map(p10_a6);
1985 ddp_media_rec.media_data := p10_a7;
1986 ddp_media_rec.source_item_create_date_time := rosetta_g_miss_date_in_map(p10_a8);
1987 ddp_media_rec.source_item_id := rosetta_g_miss_num_map(p10_a9);
1988 ddp_media_rec.media_item_type := p10_a10;
1989 ddp_media_rec.media_item_ref := p10_a11;
1990 ddp_media_rec.media_abandon_flag := p10_a12;
1991 ddp_media_rec.media_transferred_flag := p10_a13;
1992 ddp_media_rec.server_group_id := rosetta_g_miss_num_map(p10_a14);
1993 ddp_media_rec.dnis := p10_a15;
1994 ddp_media_rec.ani := p10_a16;
1995 ddp_media_rec.classification := p10_a17;
1996 ddp_media_rec.bulk_writer_code := p10_a18;
1997 ddp_media_rec.bulk_batch_type := p10_a19;
1998 ddp_media_rec.bulk_batch_id := rosetta_g_miss_num_map(p10_a20);
1999 ddp_media_rec.bulk_interaction_id := rosetta_g_miss_num_map(p10_a21);
2000 ddp_media_rec.address := p10_a22;
2001
2002
2003 -- here's the delegated call to the old PL/SQL routine
2004 jtf_ih_pub.open_mediaitem(p_api_version,
2005 p_init_msg_list,
2006 p_commit,
2007 p_resp_appl_id,
2008 p_resp_id,
2009 p_user_id,
2010 p_login_id,
2011 x_return_status,
2012 x_msg_count,
2013 x_msg_data,
2014 ddp_media_rec,
2015 x_media_id);
2016
2017 -- copy data back from the local variables to OUT or IN-OUT args, if any
2018
2019
2020
2021
2022
2023
2024
2025
2026
2027
2028
2029 end;
2030
2031 procedure update_mediaitem(p_api_version NUMBER
2032 , p_init_msg_list VARCHAR2
2033 , p_commit VARCHAR2
2034 , p_resp_appl_id NUMBER
2035 , p_resp_id NUMBER
2036 , p_user_id NUMBER
2037 , p_login_id NUMBER
2038 , x_return_status out nocopy VARCHAR2
2039 , x_msg_count out nocopy NUMBER
2040 , x_msg_data out nocopy VARCHAR2
2041 , p_object_version NUMBER
2042 , p10_a0 NUMBER := 0-1962.0724
2043 , p10_a1 NUMBER := 0-1962.0724
2044 , p10_a2 VARCHAR2 := fnd_api.g_miss_char
2045 , p10_a3 NUMBER := 0-1962.0724
2046 , p10_a4 DATE := fnd_api.g_miss_date
2047 , p10_a5 VARCHAR2 := fnd_api.g_miss_char
2048 , p10_a6 DATE := fnd_api.g_miss_date
2049 , p10_a7 VARCHAR2 := fnd_api.g_miss_char
2050 , p10_a8 DATE := fnd_api.g_miss_date
2051 , p10_a9 NUMBER := 0-1962.0724
2052 , p10_a10 VARCHAR2 := fnd_api.g_miss_char
2053 , p10_a11 VARCHAR2 := fnd_api.g_miss_char
2054 , p10_a12 VARCHAR2 := fnd_api.g_miss_char
2055 , p10_a13 VARCHAR2 := fnd_api.g_miss_char
2056 , p10_a14 NUMBER := 0-1962.0724
2057 , p10_a15 VARCHAR2 := fnd_api.g_miss_char
2058 , p10_a16 VARCHAR2 := fnd_api.g_miss_char
2059 , p10_a17 VARCHAR2 := fnd_api.g_miss_char
2060 , p10_a18 VARCHAR2 := fnd_api.g_miss_char
2064 , p10_a22 VARCHAR2 := fnd_api.g_miss_char
2061 , p10_a19 VARCHAR2 := fnd_api.g_miss_char
2062 , p10_a20 NUMBER := 0-1962.0724
2063 , p10_a21 NUMBER := 0-1962.0724
2065 )
2066
2067 as
2068 ddp_media_rec jtf_ih_pub.media_rec_type;
2069 ddindx binary_integer; indx binary_integer;
2070 begin
2071
2072 -- copy data to the local IN or IN-OUT args, if any
2073
2074
2075
2076
2077
2078
2079
2080
2081
2082
2083 ddp_media_rec.media_id := rosetta_g_miss_num_map(p10_a0);
2084 ddp_media_rec.source_id := rosetta_g_miss_num_map(p10_a1);
2085 ddp_media_rec.direction := p10_a2;
2086 ddp_media_rec.duration := rosetta_g_miss_num_map(p10_a3);
2087 ddp_media_rec.end_date_time := rosetta_g_miss_date_in_map(p10_a4);
2088 ddp_media_rec.interaction_performed := p10_a5;
2089 ddp_media_rec.start_date_time := rosetta_g_miss_date_in_map(p10_a6);
2090 ddp_media_rec.media_data := p10_a7;
2091 ddp_media_rec.source_item_create_date_time := rosetta_g_miss_date_in_map(p10_a8);
2092 ddp_media_rec.source_item_id := rosetta_g_miss_num_map(p10_a9);
2093 ddp_media_rec.media_item_type := p10_a10;
2094 ddp_media_rec.media_item_ref := p10_a11;
2095 ddp_media_rec.media_abandon_flag := p10_a12;
2096 ddp_media_rec.media_transferred_flag := p10_a13;
2097 ddp_media_rec.server_group_id := rosetta_g_miss_num_map(p10_a14);
2098 ddp_media_rec.dnis := p10_a15;
2099 ddp_media_rec.ani := p10_a16;
2100 ddp_media_rec.classification := p10_a17;
2101 ddp_media_rec.bulk_writer_code := p10_a18;
2102 ddp_media_rec.bulk_batch_type := p10_a19;
2103 ddp_media_rec.bulk_batch_id := rosetta_g_miss_num_map(p10_a20);
2104 ddp_media_rec.bulk_interaction_id := rosetta_g_miss_num_map(p10_a21);
2105 ddp_media_rec.address := p10_a22;
2106
2107
2108 -- here's the delegated call to the old PL/SQL routine
2109 jtf_ih_pub.update_mediaitem(p_api_version,
2110 p_init_msg_list,
2111 p_commit,
2112 p_resp_appl_id,
2113 p_resp_id,
2114 p_user_id,
2115 p_login_id,
2116 x_return_status,
2117 x_msg_count,
2118 x_msg_data,
2119 ddp_media_rec,
2120 p_object_version);
2121
2122 -- copy data back from the local variables to OUT or IN-OUT args, if any
2123
2124
2125
2126
2127
2128
2129
2130
2131
2132
2133
2134 end;
2135
2136 procedure close_mediaitem(p_api_version NUMBER
2137 , p_init_msg_list VARCHAR2
2138 , p_commit VARCHAR2
2139 , p_resp_appl_id NUMBER
2140 , p_resp_id NUMBER
2141 , p_user_id NUMBER
2142 , p_login_id NUMBER
2143 , x_return_status out nocopy VARCHAR2
2144 , x_msg_count out nocopy NUMBER
2145 , x_msg_data out nocopy VARCHAR2
2146 , p_object_version NUMBER
2147 , p10_a0 NUMBER := 0-1962.0724
2148 , p10_a1 NUMBER := 0-1962.0724
2149 , p10_a2 VARCHAR2 := fnd_api.g_miss_char
2150 , p10_a3 NUMBER := 0-1962.0724
2151 , p10_a4 DATE := fnd_api.g_miss_date
2152 , p10_a5 VARCHAR2 := fnd_api.g_miss_char
2153 , p10_a6 DATE := fnd_api.g_miss_date
2154 , p10_a7 VARCHAR2 := fnd_api.g_miss_char
2155 , p10_a8 DATE := fnd_api.g_miss_date
2156 , p10_a9 NUMBER := 0-1962.0724
2157 , p10_a10 VARCHAR2 := fnd_api.g_miss_char
2158 , p10_a11 VARCHAR2 := fnd_api.g_miss_char
2159 , p10_a12 VARCHAR2 := fnd_api.g_miss_char
2160 , p10_a13 VARCHAR2 := fnd_api.g_miss_char
2161 , p10_a14 NUMBER := 0-1962.0724
2162 , p10_a15 VARCHAR2 := fnd_api.g_miss_char
2163 , p10_a16 VARCHAR2 := fnd_api.g_miss_char
2164 , p10_a17 VARCHAR2 := fnd_api.g_miss_char
2165 , p10_a18 VARCHAR2 := fnd_api.g_miss_char
2166 , p10_a19 VARCHAR2 := fnd_api.g_miss_char
2167 , p10_a20 NUMBER := 0-1962.0724
2168 , p10_a21 NUMBER := 0-1962.0724
2169 , p10_a22 VARCHAR2 := fnd_api.g_miss_char
2170 )
2171
2172 as
2173 ddp_media_rec jtf_ih_pub.media_rec_type;
2174 ddindx binary_integer; indx binary_integer;
2175 begin
2176
2177 -- copy data to the local IN or IN-OUT args, if any
2178
2179
2180
2181
2182
2183
2184
2185
2186
2187
2188 ddp_media_rec.media_id := rosetta_g_miss_num_map(p10_a0);
2189 ddp_media_rec.source_id := rosetta_g_miss_num_map(p10_a1);
2190 ddp_media_rec.direction := p10_a2;
2191 ddp_media_rec.duration := rosetta_g_miss_num_map(p10_a3);
2192 ddp_media_rec.end_date_time := rosetta_g_miss_date_in_map(p10_a4);
2193 ddp_media_rec.interaction_performed := p10_a5;
2194 ddp_media_rec.start_date_time := rosetta_g_miss_date_in_map(p10_a6);
2195 ddp_media_rec.media_data := p10_a7;
2196 ddp_media_rec.source_item_create_date_time := rosetta_g_miss_date_in_map(p10_a8);
2197 ddp_media_rec.source_item_id := rosetta_g_miss_num_map(p10_a9);
2198 ddp_media_rec.media_item_type := p10_a10;
2199 ddp_media_rec.media_item_ref := p10_a11;
2200 ddp_media_rec.media_abandon_flag := p10_a12;
2201 ddp_media_rec.media_transferred_flag := p10_a13;
2202 ddp_media_rec.server_group_id := rosetta_g_miss_num_map(p10_a14);
2203 ddp_media_rec.dnis := p10_a15;
2204 ddp_media_rec.ani := p10_a16;
2205 ddp_media_rec.classification := p10_a17;
2206 ddp_media_rec.bulk_writer_code := p10_a18;
2210 ddp_media_rec.address := p10_a22;
2207 ddp_media_rec.bulk_batch_type := p10_a19;
2208 ddp_media_rec.bulk_batch_id := rosetta_g_miss_num_map(p10_a20);
2209 ddp_media_rec.bulk_interaction_id := rosetta_g_miss_num_map(p10_a21);
2211
2212
2213 -- here's the delegated call to the old PL/SQL routine
2214 jtf_ih_pub.close_mediaitem(p_api_version,
2215 p_init_msg_list,
2216 p_commit,
2217 p_resp_appl_id,
2218 p_resp_id,
2219 p_user_id,
2220 p_login_id,
2221 x_return_status,
2222 x_msg_count,
2223 x_msg_data,
2224 ddp_media_rec,
2225 p_object_version);
2226
2227 -- copy data back from the local variables to OUT or IN-OUT args, if any
2228
2229
2230
2231
2232
2233
2234
2235
2236
2237
2238
2239 end;
2240
2241 procedure add_medialifecycle(p_api_version NUMBER
2242 , p_init_msg_list VARCHAR2
2243 , p_commit VARCHAR2
2244 , p_resp_appl_id NUMBER
2245 , p_resp_id NUMBER
2246 , p_user_id NUMBER
2247 , p_login_id NUMBER
2248 , x_return_status out nocopy VARCHAR2
2249 , x_msg_count out nocopy NUMBER
2250 , x_msg_data out nocopy VARCHAR2
2251 , x_milcs_id out nocopy NUMBER
2252 , p10_a0 DATE := fnd_api.g_miss_date
2253 , p10_a1 VARCHAR2 := fnd_api.g_miss_char
2254 , p10_a2 NUMBER := 0-1962.0724
2255 , p10_a3 NUMBER := 0-1962.0724
2256 , p10_a4 DATE := fnd_api.g_miss_date
2257 , p10_a5 NUMBER := 0-1962.0724
2258 , p10_a6 NUMBER := 0-1962.0724
2259 , p10_a7 NUMBER := 0-1962.0724
2260 , p10_a8 NUMBER := 0-1962.0724
2261 , p10_a9 NUMBER := 0-1962.0724
2262 , p10_a10 VARCHAR2 := fnd_api.g_miss_char
2263 , p10_a11 VARCHAR2 := fnd_api.g_miss_char
2264 , p10_a12 VARCHAR2 := fnd_api.g_miss_char
2265 , p10_a13 NUMBER := 0-1962.0724
2266 , p10_a14 NUMBER := 0-1962.0724
2267 )
2268
2269 as
2270 ddp_media_lc_rec jtf_ih_pub.media_lc_rec_type;
2271 ddindx binary_integer; indx binary_integer;
2272 begin
2273
2274 -- copy data to the local IN or IN-OUT args, if any
2275
2276
2277
2278
2279
2280
2281
2282
2283
2284
2285 ddp_media_lc_rec.start_date_time := rosetta_g_miss_date_in_map(p10_a0);
2286 ddp_media_lc_rec.type_type := p10_a1;
2287 ddp_media_lc_rec.type_id := rosetta_g_miss_num_map(p10_a2);
2288 ddp_media_lc_rec.duration := rosetta_g_miss_num_map(p10_a3);
2289 ddp_media_lc_rec.end_date_time := rosetta_g_miss_date_in_map(p10_a4);
2290 ddp_media_lc_rec.milcs_id := rosetta_g_miss_num_map(p10_a5);
2291 ddp_media_lc_rec.milcs_type_id := rosetta_g_miss_num_map(p10_a6);
2292 ddp_media_lc_rec.media_id := rosetta_g_miss_num_map(p10_a7);
2293 ddp_media_lc_rec.handler_id := rosetta_g_miss_num_map(p10_a8);
2294 ddp_media_lc_rec.resource_id := rosetta_g_miss_num_map(p10_a9);
2295 ddp_media_lc_rec.milcs_code := p10_a10;
2296 ddp_media_lc_rec.bulk_writer_code := p10_a11;
2297 ddp_media_lc_rec.bulk_batch_type := p10_a12;
2298 ddp_media_lc_rec.bulk_batch_id := rosetta_g_miss_num_map(p10_a13);
2299 ddp_media_lc_rec.bulk_interaction_id := rosetta_g_miss_num_map(p10_a14);
2300
2301
2302 -- here's the delegated call to the old PL/SQL routine
2303 jtf_ih_pub.add_medialifecycle(p_api_version,
2304 p_init_msg_list,
2305 p_commit,
2306 p_resp_appl_id,
2307 p_resp_id,
2308 p_user_id,
2309 p_login_id,
2310 x_return_status,
2311 x_msg_count,
2312 x_msg_data,
2313 ddp_media_lc_rec,
2314 x_milcs_id);
2315
2316 -- copy data back from the local variables to OUT or IN-OUT args, if any
2317
2318
2319
2320
2321
2322
2323
2324
2325
2326
2327
2328 end;
2329
2333 , p_resp_appl_id NUMBER
2330 procedure update_medialifecycle(p_api_version NUMBER
2331 , p_init_msg_list VARCHAR2
2332 , p_commit VARCHAR2
2334 , p_resp_id NUMBER
2335 , p_user_id NUMBER
2336 , p_login_id NUMBER
2337 , x_return_status out nocopy VARCHAR2
2338 , x_msg_count out nocopy NUMBER
2339 , x_msg_data out nocopy VARCHAR2
2340 , p_object_version NUMBER
2341 , p10_a0 DATE := fnd_api.g_miss_date
2342 , p10_a1 VARCHAR2 := fnd_api.g_miss_char
2343 , p10_a2 NUMBER := 0-1962.0724
2344 , p10_a3 NUMBER := 0-1962.0724
2345 , p10_a4 DATE := fnd_api.g_miss_date
2346 , p10_a5 NUMBER := 0-1962.0724
2347 , p10_a6 NUMBER := 0-1962.0724
2348 , p10_a7 NUMBER := 0-1962.0724
2349 , p10_a8 NUMBER := 0-1962.0724
2350 , p10_a9 NUMBER := 0-1962.0724
2351 , p10_a10 VARCHAR2 := fnd_api.g_miss_char
2352 , p10_a11 VARCHAR2 := fnd_api.g_miss_char
2353 , p10_a12 VARCHAR2 := fnd_api.g_miss_char
2354 , p10_a13 NUMBER := 0-1962.0724
2355 , p10_a14 NUMBER := 0-1962.0724
2356 )
2357
2358 as
2359 ddp_media_lc_rec jtf_ih_pub.media_lc_rec_type;
2360 ddindx binary_integer; indx binary_integer;
2361 begin
2362
2363 -- copy data to the local IN or IN-OUT args, if any
2364
2365
2366
2367
2368
2369
2370
2371
2372
2373
2374 ddp_media_lc_rec.start_date_time := rosetta_g_miss_date_in_map(p10_a0);
2375 ddp_media_lc_rec.type_type := p10_a1;
2376 ddp_media_lc_rec.type_id := rosetta_g_miss_num_map(p10_a2);
2377 ddp_media_lc_rec.duration := rosetta_g_miss_num_map(p10_a3);
2378 ddp_media_lc_rec.end_date_time := rosetta_g_miss_date_in_map(p10_a4);
2379 ddp_media_lc_rec.milcs_id := rosetta_g_miss_num_map(p10_a5);
2380 ddp_media_lc_rec.milcs_type_id := rosetta_g_miss_num_map(p10_a6);
2381 ddp_media_lc_rec.media_id := rosetta_g_miss_num_map(p10_a7);
2382 ddp_media_lc_rec.handler_id := rosetta_g_miss_num_map(p10_a8);
2383 ddp_media_lc_rec.resource_id := rosetta_g_miss_num_map(p10_a9);
2384 ddp_media_lc_rec.milcs_code := p10_a10;
2385 ddp_media_lc_rec.bulk_writer_code := p10_a11;
2386 ddp_media_lc_rec.bulk_batch_type := p10_a12;
2387 ddp_media_lc_rec.bulk_batch_id := rosetta_g_miss_num_map(p10_a13);
2388 ddp_media_lc_rec.bulk_interaction_id := rosetta_g_miss_num_map(p10_a14);
2389
2390
2391 -- here's the delegated call to the old PL/SQL routine
2392 jtf_ih_pub.update_medialifecycle(p_api_version,
2393 p_init_msg_list,
2394 p_commit,
2395 p_resp_appl_id,
2396 p_resp_id,
2397 p_user_id,
2398 p_login_id,
2399 x_return_status,
2400 x_msg_count,
2401 x_msg_data,
2402 ddp_media_lc_rec,
2403 p_object_version);
2404
2405 -- copy data back from the local variables to OUT or IN-OUT args, if any
2406
2407
2408
2409
2410
2411
2412
2413
2414
2415
2416
2417 end;
2418
2419 end jtf_ih_pub_w;