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_p5(t out nocopy ahl_vwp_visits_stages_pvt.visit_stages_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_VARCHAR2_TABLE_100
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_DATE_TABLE
13: return d;
14: end;
15:
16: procedure rosetta_table_copy_in_p5(t out nocopy ahl_vwp_visits_stages_pvt.visit_stages_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_VARCHAR2_TABLE_100
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_DATE_TABLE
21: , a5 JTF_DATE_TABLE
15:
16: procedure rosetta_table_copy_in_p5(t out nocopy ahl_vwp_visits_stages_pvt.visit_stages_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_VARCHAR2_TABLE_100
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_DATE_TABLE
21: , a5 JTF_DATE_TABLE
22: , a6 JTF_DATE_TABLE
23: , a7 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_DATE_TABLE
21: , a5 JTF_DATE_TABLE
22: , a6 JTF_DATE_TABLE
23: , a7 JTF_VARCHAR2_TABLE_100
24: , a8 JTF_NUMBER_TABLE
25: , a9 JTF_DATE_TABLE
26: , a10 JTF_NUMBER_TABLE
27: , a11 JTF_VARCHAR2_TABLE_100
28: , a12 JTF_VARCHAR2_TABLE_200
22: , a6 JTF_DATE_TABLE
23: , a7 JTF_VARCHAR2_TABLE_100
24: , a8 JTF_NUMBER_TABLE
25: , a9 JTF_DATE_TABLE
26: , a10 JTF_NUMBER_TABLE
27: , a11 JTF_VARCHAR2_TABLE_100
28: , a12 JTF_VARCHAR2_TABLE_200
29: , a13 JTF_VARCHAR2_TABLE_200
30: , a14 JTF_VARCHAR2_TABLE_200
83: end loop;
84: end if;
85: end if;
86: end rosetta_table_copy_in_p5;
87: procedure rosetta_table_copy_out_p5(t ahl_vwp_visits_stages_pvt.visit_stages_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
88: , a1 out nocopy JTF_NUMBER_TABLE
89: , a2 out nocopy JTF_VARCHAR2_TABLE_100
90: , a3 out nocopy JTF_NUMBER_TABLE
91: , a4 out nocopy JTF_DATE_TABLE
84: end if;
85: end if;
86: end rosetta_table_copy_in_p5;
87: procedure rosetta_table_copy_out_p5(t ahl_vwp_visits_stages_pvt.visit_stages_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
88: , a1 out nocopy JTF_NUMBER_TABLE
89: , a2 out nocopy JTF_VARCHAR2_TABLE_100
90: , a3 out nocopy JTF_NUMBER_TABLE
91: , a4 out nocopy JTF_DATE_TABLE
92: , a5 out nocopy JTF_DATE_TABLE
86: end rosetta_table_copy_in_p5;
87: procedure rosetta_table_copy_out_p5(t ahl_vwp_visits_stages_pvt.visit_stages_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
88: , a1 out nocopy JTF_NUMBER_TABLE
89: , a2 out nocopy JTF_VARCHAR2_TABLE_100
90: , a3 out nocopy JTF_NUMBER_TABLE
91: , a4 out nocopy JTF_DATE_TABLE
92: , a5 out nocopy JTF_DATE_TABLE
93: , a6 out nocopy JTF_DATE_TABLE
94: , a7 out nocopy JTF_VARCHAR2_TABLE_100
91: , a4 out nocopy JTF_DATE_TABLE
92: , a5 out nocopy JTF_DATE_TABLE
93: , a6 out nocopy JTF_DATE_TABLE
94: , a7 out nocopy JTF_VARCHAR2_TABLE_100
95: , a8 out nocopy JTF_NUMBER_TABLE
96: , a9 out nocopy JTF_DATE_TABLE
97: , a10 out nocopy JTF_NUMBER_TABLE
98: , a11 out nocopy JTF_VARCHAR2_TABLE_100
99: , a12 out nocopy JTF_VARCHAR2_TABLE_200
93: , a6 out nocopy JTF_DATE_TABLE
94: , a7 out nocopy JTF_VARCHAR2_TABLE_100
95: , a8 out nocopy JTF_NUMBER_TABLE
96: , a9 out nocopy JTF_DATE_TABLE
97: , a10 out nocopy JTF_NUMBER_TABLE
98: , a11 out nocopy JTF_VARCHAR2_TABLE_100
99: , a12 out nocopy JTF_VARCHAR2_TABLE_200
100: , a13 out nocopy JTF_VARCHAR2_TABLE_200
101: , a14 out nocopy JTF_VARCHAR2_TABLE_200
114: ) as
115: ddindx binary_integer; indx binary_integer;
116: begin
117: if t is null or t.count = 0 then
118: a0 := JTF_NUMBER_TABLE();
119: a1 := JTF_NUMBER_TABLE();
120: a2 := JTF_VARCHAR2_TABLE_100();
121: a3 := JTF_NUMBER_TABLE();
122: a4 := JTF_DATE_TABLE();
115: ddindx binary_integer; indx binary_integer;
116: begin
117: if t is null or t.count = 0 then
118: a0 := JTF_NUMBER_TABLE();
119: a1 := JTF_NUMBER_TABLE();
120: a2 := JTF_VARCHAR2_TABLE_100();
121: a3 := JTF_NUMBER_TABLE();
122: a4 := JTF_DATE_TABLE();
123: a5 := JTF_DATE_TABLE();
117: if t is null or t.count = 0 then
118: a0 := JTF_NUMBER_TABLE();
119: a1 := JTF_NUMBER_TABLE();
120: a2 := JTF_VARCHAR2_TABLE_100();
121: a3 := JTF_NUMBER_TABLE();
122: a4 := JTF_DATE_TABLE();
123: a5 := JTF_DATE_TABLE();
124: a6 := JTF_DATE_TABLE();
125: a7 := JTF_VARCHAR2_TABLE_100();
122: a4 := JTF_DATE_TABLE();
123: a5 := JTF_DATE_TABLE();
124: a6 := JTF_DATE_TABLE();
125: a7 := JTF_VARCHAR2_TABLE_100();
126: a8 := JTF_NUMBER_TABLE();
127: a9 := JTF_DATE_TABLE();
128: a10 := JTF_NUMBER_TABLE();
129: a11 := JTF_VARCHAR2_TABLE_100();
130: a12 := JTF_VARCHAR2_TABLE_200();
124: a6 := JTF_DATE_TABLE();
125: a7 := JTF_VARCHAR2_TABLE_100();
126: a8 := JTF_NUMBER_TABLE();
127: a9 := JTF_DATE_TABLE();
128: a10 := JTF_NUMBER_TABLE();
129: a11 := JTF_VARCHAR2_TABLE_100();
130: a12 := JTF_VARCHAR2_TABLE_200();
131: a13 := JTF_VARCHAR2_TABLE_200();
132: a14 := JTF_VARCHAR2_TABLE_200();
142: a24 := JTF_VARCHAR2_TABLE_200();
143: a25 := JTF_VARCHAR2_TABLE_200();
144: a26 := JTF_VARCHAR2_TABLE_200();
145: else
146: a0 := JTF_NUMBER_TABLE();
147: a1 := JTF_NUMBER_TABLE();
148: a2 := JTF_VARCHAR2_TABLE_100();
149: a3 := JTF_NUMBER_TABLE();
150: a4 := JTF_DATE_TABLE();
143: a25 := JTF_VARCHAR2_TABLE_200();
144: a26 := JTF_VARCHAR2_TABLE_200();
145: else
146: a0 := JTF_NUMBER_TABLE();
147: a1 := JTF_NUMBER_TABLE();
148: a2 := JTF_VARCHAR2_TABLE_100();
149: a3 := JTF_NUMBER_TABLE();
150: a4 := JTF_DATE_TABLE();
151: a5 := JTF_DATE_TABLE();
145: else
146: a0 := JTF_NUMBER_TABLE();
147: a1 := JTF_NUMBER_TABLE();
148: a2 := JTF_VARCHAR2_TABLE_100();
149: a3 := JTF_NUMBER_TABLE();
150: a4 := JTF_DATE_TABLE();
151: a5 := JTF_DATE_TABLE();
152: a6 := JTF_DATE_TABLE();
153: a7 := JTF_VARCHAR2_TABLE_100();
150: a4 := JTF_DATE_TABLE();
151: a5 := JTF_DATE_TABLE();
152: a6 := JTF_DATE_TABLE();
153: a7 := JTF_VARCHAR2_TABLE_100();
154: a8 := JTF_NUMBER_TABLE();
155: a9 := JTF_DATE_TABLE();
156: a10 := JTF_NUMBER_TABLE();
157: a11 := JTF_VARCHAR2_TABLE_100();
158: a12 := JTF_VARCHAR2_TABLE_200();
152: a6 := JTF_DATE_TABLE();
153: a7 := JTF_VARCHAR2_TABLE_100();
154: a8 := JTF_NUMBER_TABLE();
155: a9 := JTF_DATE_TABLE();
156: a10 := JTF_NUMBER_TABLE();
157: a11 := JTF_VARCHAR2_TABLE_100();
158: a12 := JTF_VARCHAR2_TABLE_200();
159: a13 := JTF_VARCHAR2_TABLE_200();
160: a14 := JTF_VARCHAR2_TABLE_200();
237: end if;
238: end if;
239: end rosetta_table_copy_out_p5;
240:
241: procedure rosetta_table_copy_in_p6(t out nocopy ahl_vwp_visits_stages_pvt.visit_stages_times_tbl_type, a0 JTF_NUMBER_TABLE
242: , a1 JTF_NUMBER_TABLE
243: , a2 JTF_VARCHAR2_TABLE_100
244: , a3 JTF_NUMBER_TABLE
245: , a4 JTF_NUMBER_TABLE
238: end if;
239: end rosetta_table_copy_out_p5;
240:
241: procedure rosetta_table_copy_in_p6(t out nocopy ahl_vwp_visits_stages_pvt.visit_stages_times_tbl_type, a0 JTF_NUMBER_TABLE
242: , a1 JTF_NUMBER_TABLE
243: , a2 JTF_VARCHAR2_TABLE_100
244: , a3 JTF_NUMBER_TABLE
245: , a4 JTF_NUMBER_TABLE
246: , a5 JTF_NUMBER_TABLE
240:
241: procedure rosetta_table_copy_in_p6(t out nocopy ahl_vwp_visits_stages_pvt.visit_stages_times_tbl_type, a0 JTF_NUMBER_TABLE
242: , a1 JTF_NUMBER_TABLE
243: , a2 JTF_VARCHAR2_TABLE_100
244: , a3 JTF_NUMBER_TABLE
245: , a4 JTF_NUMBER_TABLE
246: , a5 JTF_NUMBER_TABLE
247: , a6 JTF_DATE_TABLE
248: , a7 JTF_DATE_TABLE
241: procedure rosetta_table_copy_in_p6(t out nocopy ahl_vwp_visits_stages_pvt.visit_stages_times_tbl_type, a0 JTF_NUMBER_TABLE
242: , a1 JTF_NUMBER_TABLE
243: , a2 JTF_VARCHAR2_TABLE_100
244: , a3 JTF_NUMBER_TABLE
245: , a4 JTF_NUMBER_TABLE
246: , a5 JTF_NUMBER_TABLE
247: , a6 JTF_DATE_TABLE
248: , a7 JTF_DATE_TABLE
249: , a8 JTF_DATE_TABLE
242: , a1 JTF_NUMBER_TABLE
243: , a2 JTF_VARCHAR2_TABLE_100
244: , a3 JTF_NUMBER_TABLE
245: , a4 JTF_NUMBER_TABLE
246: , a5 JTF_NUMBER_TABLE
247: , a6 JTF_DATE_TABLE
248: , a7 JTF_DATE_TABLE
249: , a8 JTF_DATE_TABLE
250: ) as
272: end loop;
273: end if;
274: end if;
275: end rosetta_table_copy_in_p6;
276: procedure rosetta_table_copy_out_p6(t ahl_vwp_visits_stages_pvt.visit_stages_times_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
277: , a1 out nocopy JTF_NUMBER_TABLE
278: , a2 out nocopy JTF_VARCHAR2_TABLE_100
279: , a3 out nocopy JTF_NUMBER_TABLE
280: , a4 out nocopy JTF_NUMBER_TABLE
273: end if;
274: end if;
275: end rosetta_table_copy_in_p6;
276: procedure rosetta_table_copy_out_p6(t ahl_vwp_visits_stages_pvt.visit_stages_times_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
277: , a1 out nocopy JTF_NUMBER_TABLE
278: , a2 out nocopy JTF_VARCHAR2_TABLE_100
279: , a3 out nocopy JTF_NUMBER_TABLE
280: , a4 out nocopy JTF_NUMBER_TABLE
281: , a5 out nocopy JTF_NUMBER_TABLE
275: end rosetta_table_copy_in_p6;
276: procedure rosetta_table_copy_out_p6(t ahl_vwp_visits_stages_pvt.visit_stages_times_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
277: , a1 out nocopy JTF_NUMBER_TABLE
278: , a2 out nocopy JTF_VARCHAR2_TABLE_100
279: , a3 out nocopy JTF_NUMBER_TABLE
280: , a4 out nocopy JTF_NUMBER_TABLE
281: , a5 out nocopy JTF_NUMBER_TABLE
282: , a6 out nocopy JTF_DATE_TABLE
283: , a7 out nocopy JTF_DATE_TABLE
276: procedure rosetta_table_copy_out_p6(t ahl_vwp_visits_stages_pvt.visit_stages_times_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
277: , a1 out nocopy JTF_NUMBER_TABLE
278: , a2 out nocopy JTF_VARCHAR2_TABLE_100
279: , a3 out nocopy JTF_NUMBER_TABLE
280: , a4 out nocopy JTF_NUMBER_TABLE
281: , a5 out nocopy JTF_NUMBER_TABLE
282: , a6 out nocopy JTF_DATE_TABLE
283: , a7 out nocopy JTF_DATE_TABLE
284: , a8 out nocopy JTF_DATE_TABLE
277: , a1 out nocopy JTF_NUMBER_TABLE
278: , a2 out nocopy JTF_VARCHAR2_TABLE_100
279: , a3 out nocopy JTF_NUMBER_TABLE
280: , a4 out nocopy JTF_NUMBER_TABLE
281: , a5 out nocopy JTF_NUMBER_TABLE
282: , a6 out nocopy JTF_DATE_TABLE
283: , a7 out nocopy JTF_DATE_TABLE
284: , a8 out nocopy JTF_DATE_TABLE
285: ) as
285: ) as
286: ddindx binary_integer; indx binary_integer;
287: begin
288: if t is null or t.count = 0 then
289: a0 := JTF_NUMBER_TABLE();
290: a1 := JTF_NUMBER_TABLE();
291: a2 := JTF_VARCHAR2_TABLE_100();
292: a3 := JTF_NUMBER_TABLE();
293: a4 := JTF_NUMBER_TABLE();
286: ddindx binary_integer; indx binary_integer;
287: begin
288: if t is null or t.count = 0 then
289: a0 := JTF_NUMBER_TABLE();
290: a1 := JTF_NUMBER_TABLE();
291: a2 := JTF_VARCHAR2_TABLE_100();
292: a3 := JTF_NUMBER_TABLE();
293: a4 := JTF_NUMBER_TABLE();
294: a5 := JTF_NUMBER_TABLE();
288: if t is null or t.count = 0 then
289: a0 := JTF_NUMBER_TABLE();
290: a1 := JTF_NUMBER_TABLE();
291: a2 := JTF_VARCHAR2_TABLE_100();
292: a3 := JTF_NUMBER_TABLE();
293: a4 := JTF_NUMBER_TABLE();
294: a5 := JTF_NUMBER_TABLE();
295: a6 := JTF_DATE_TABLE();
296: a7 := JTF_DATE_TABLE();
289: a0 := JTF_NUMBER_TABLE();
290: a1 := JTF_NUMBER_TABLE();
291: a2 := JTF_VARCHAR2_TABLE_100();
292: a3 := JTF_NUMBER_TABLE();
293: a4 := JTF_NUMBER_TABLE();
294: a5 := JTF_NUMBER_TABLE();
295: a6 := JTF_DATE_TABLE();
296: a7 := JTF_DATE_TABLE();
297: a8 := JTF_DATE_TABLE();
290: a1 := JTF_NUMBER_TABLE();
291: a2 := JTF_VARCHAR2_TABLE_100();
292: a3 := JTF_NUMBER_TABLE();
293: a4 := JTF_NUMBER_TABLE();
294: a5 := JTF_NUMBER_TABLE();
295: a6 := JTF_DATE_TABLE();
296: a7 := JTF_DATE_TABLE();
297: a8 := JTF_DATE_TABLE();
298: else
295: a6 := JTF_DATE_TABLE();
296: a7 := JTF_DATE_TABLE();
297: a8 := JTF_DATE_TABLE();
298: else
299: a0 := JTF_NUMBER_TABLE();
300: a1 := JTF_NUMBER_TABLE();
301: a2 := JTF_VARCHAR2_TABLE_100();
302: a3 := JTF_NUMBER_TABLE();
303: a4 := JTF_NUMBER_TABLE();
296: a7 := JTF_DATE_TABLE();
297: a8 := JTF_DATE_TABLE();
298: else
299: a0 := JTF_NUMBER_TABLE();
300: a1 := JTF_NUMBER_TABLE();
301: a2 := JTF_VARCHAR2_TABLE_100();
302: a3 := JTF_NUMBER_TABLE();
303: a4 := JTF_NUMBER_TABLE();
304: a5 := JTF_NUMBER_TABLE();
298: else
299: a0 := JTF_NUMBER_TABLE();
300: a1 := JTF_NUMBER_TABLE();
301: a2 := JTF_VARCHAR2_TABLE_100();
302: a3 := JTF_NUMBER_TABLE();
303: a4 := JTF_NUMBER_TABLE();
304: a5 := JTF_NUMBER_TABLE();
305: a6 := JTF_DATE_TABLE();
306: a7 := JTF_DATE_TABLE();
299: a0 := JTF_NUMBER_TABLE();
300: a1 := JTF_NUMBER_TABLE();
301: a2 := JTF_VARCHAR2_TABLE_100();
302: a3 := JTF_NUMBER_TABLE();
303: a4 := JTF_NUMBER_TABLE();
304: a5 := JTF_NUMBER_TABLE();
305: a6 := JTF_DATE_TABLE();
306: a7 := JTF_DATE_TABLE();
307: a8 := JTF_DATE_TABLE();
300: a1 := JTF_NUMBER_TABLE();
301: a2 := JTF_VARCHAR2_TABLE_100();
302: a3 := JTF_NUMBER_TABLE();
303: a4 := JTF_NUMBER_TABLE();
304: a5 := JTF_NUMBER_TABLE();
305: a6 := JTF_DATE_TABLE();
306: a7 := JTF_DATE_TABLE();
307: a8 := JTF_DATE_TABLE();
308: if t.count > 0 then
336: end if;
337: end if;
338: end rosetta_table_copy_out_p6;
339:
340: procedure rosetta_table_copy_in_p7(t out nocopy ahl_vwp_visits_stages_pvt.stage_type_assoc_tbl_type, a0 JTF_NUMBER_TABLE
341: , a1 JTF_NUMBER_TABLE
342: , a2 JTF_VARCHAR2_TABLE_100
343: , a3 JTF_VARCHAR2_TABLE_100
344: ) as
337: end if;
338: end rosetta_table_copy_out_p6;
339:
340: procedure rosetta_table_copy_in_p7(t out nocopy ahl_vwp_visits_stages_pvt.stage_type_assoc_tbl_type, a0 JTF_NUMBER_TABLE
341: , a1 JTF_NUMBER_TABLE
342: , a2 JTF_VARCHAR2_TABLE_100
343: , a3 JTF_VARCHAR2_TABLE_100
344: ) as
345: ddindx binary_integer; indx binary_integer;
361: end loop;
362: end if;
363: end if;
364: end rosetta_table_copy_in_p7;
365: procedure rosetta_table_copy_out_p7(t ahl_vwp_visits_stages_pvt.stage_type_assoc_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
366: , a1 out nocopy JTF_NUMBER_TABLE
367: , a2 out nocopy JTF_VARCHAR2_TABLE_100
368: , a3 out nocopy JTF_VARCHAR2_TABLE_100
369: ) as
362: end if;
363: end if;
364: end rosetta_table_copy_in_p7;
365: procedure rosetta_table_copy_out_p7(t ahl_vwp_visits_stages_pvt.stage_type_assoc_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
366: , a1 out nocopy JTF_NUMBER_TABLE
367: , a2 out nocopy JTF_VARCHAR2_TABLE_100
368: , a3 out nocopy JTF_VARCHAR2_TABLE_100
369: ) as
370: ddindx binary_integer; indx binary_integer;
369: ) as
370: ddindx binary_integer; indx binary_integer;
371: begin
372: if t is null or t.count = 0 then
373: a0 := JTF_NUMBER_TABLE();
374: a1 := JTF_NUMBER_TABLE();
375: a2 := JTF_VARCHAR2_TABLE_100();
376: a3 := JTF_VARCHAR2_TABLE_100();
377: else
370: ddindx binary_integer; indx binary_integer;
371: begin
372: if t is null or t.count = 0 then
373: a0 := JTF_NUMBER_TABLE();
374: a1 := JTF_NUMBER_TABLE();
375: a2 := JTF_VARCHAR2_TABLE_100();
376: a3 := JTF_VARCHAR2_TABLE_100();
377: else
378: a0 := JTF_NUMBER_TABLE();
374: a1 := JTF_NUMBER_TABLE();
375: a2 := JTF_VARCHAR2_TABLE_100();
376: a3 := JTF_VARCHAR2_TABLE_100();
377: else
378: a0 := JTF_NUMBER_TABLE();
379: a1 := JTF_NUMBER_TABLE();
380: a2 := JTF_VARCHAR2_TABLE_100();
381: a3 := JTF_VARCHAR2_TABLE_100();
382: if t.count > 0 then
375: a2 := JTF_VARCHAR2_TABLE_100();
376: a3 := JTF_VARCHAR2_TABLE_100();
377: else
378: a0 := JTF_NUMBER_TABLE();
379: a1 := JTF_NUMBER_TABLE();
380: a2 := JTF_VARCHAR2_TABLE_100();
381: a3 := JTF_VARCHAR2_TABLE_100();
382: if t.count > 0 then
383: a0.extend(t.count);
400: end if;
401: end if;
402: end rosetta_table_copy_out_p7;
403:
404: procedure rosetta_table_copy_in_p8(t out nocopy ahl_vwp_visits_stages_pvt.stage_rule_tbl_type, a0 JTF_NUMBER_TABLE
405: , a1 JTF_NUMBER_TABLE
406: , a2 JTF_VARCHAR2_TABLE_100
407: ) as
408: ddindx binary_integer; indx binary_integer;
401: end if;
402: end rosetta_table_copy_out_p7;
403:
404: procedure rosetta_table_copy_in_p8(t out nocopy ahl_vwp_visits_stages_pvt.stage_rule_tbl_type, a0 JTF_NUMBER_TABLE
405: , a1 JTF_NUMBER_TABLE
406: , a2 JTF_VARCHAR2_TABLE_100
407: ) as
408: ddindx binary_integer; indx binary_integer;
409: begin
423: end loop;
424: end if;
425: end if;
426: end rosetta_table_copy_in_p8;
427: procedure rosetta_table_copy_out_p8(t ahl_vwp_visits_stages_pvt.stage_rule_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
428: , a1 out nocopy JTF_NUMBER_TABLE
429: , a2 out nocopy JTF_VARCHAR2_TABLE_100
430: ) as
431: ddindx binary_integer; indx binary_integer;
424: end if;
425: end if;
426: end rosetta_table_copy_in_p8;
427: procedure rosetta_table_copy_out_p8(t ahl_vwp_visits_stages_pvt.stage_rule_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
428: , a1 out nocopy JTF_NUMBER_TABLE
429: , a2 out nocopy JTF_VARCHAR2_TABLE_100
430: ) as
431: ddindx binary_integer; indx binary_integer;
432: begin
430: ) as
431: ddindx binary_integer; indx binary_integer;
432: begin
433: if t is null or t.count = 0 then
434: a0 := JTF_NUMBER_TABLE();
435: a1 := JTF_NUMBER_TABLE();
436: a2 := JTF_VARCHAR2_TABLE_100();
437: else
438: a0 := JTF_NUMBER_TABLE();
431: ddindx binary_integer; indx binary_integer;
432: begin
433: if t is null or t.count = 0 then
434: a0 := JTF_NUMBER_TABLE();
435: a1 := JTF_NUMBER_TABLE();
436: a2 := JTF_VARCHAR2_TABLE_100();
437: else
438: a0 := JTF_NUMBER_TABLE();
439: a1 := JTF_NUMBER_TABLE();
434: a0 := JTF_NUMBER_TABLE();
435: a1 := JTF_NUMBER_TABLE();
436: a2 := JTF_VARCHAR2_TABLE_100();
437: else
438: a0 := JTF_NUMBER_TABLE();
439: a1 := JTF_NUMBER_TABLE();
440: a2 := JTF_VARCHAR2_TABLE_100();
441: if t.count > 0 then
442: a0.extend(t.count);
435: a1 := JTF_NUMBER_TABLE();
436: a2 := JTF_VARCHAR2_TABLE_100();
437: else
438: a0 := JTF_NUMBER_TABLE();
439: a1 := JTF_NUMBER_TABLE();
440: a2 := JTF_VARCHAR2_TABLE_100();
441: if t.count > 0 then
442: a0.extend(t.count);
443: a1.extend(t.count);
457: end if;
458: end if;
459: end rosetta_table_copy_out_p8;
460:
461: procedure rosetta_table_copy_in_p9(t out nocopy ahl_vwp_visits_stages_pvt.visit_stages_ovn_tbl_type, a0 JTF_NUMBER_TABLE
462: , a1 JTF_NUMBER_TABLE
463: ) as
464: ddindx binary_integer; indx binary_integer;
465: begin
458: end if;
459: end rosetta_table_copy_out_p8;
460:
461: procedure rosetta_table_copy_in_p9(t out nocopy ahl_vwp_visits_stages_pvt.visit_stages_ovn_tbl_type, a0 JTF_NUMBER_TABLE
462: , a1 JTF_NUMBER_TABLE
463: ) as
464: ddindx binary_integer; indx binary_integer;
465: begin
466: if a0 is not null and a0.count > 0 then
478: end loop;
479: end if;
480: end if;
481: end rosetta_table_copy_in_p9;
482: procedure rosetta_table_copy_out_p9(t ahl_vwp_visits_stages_pvt.visit_stages_ovn_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
483: , a1 out nocopy JTF_NUMBER_TABLE
484: ) as
485: ddindx binary_integer; indx binary_integer;
486: begin
479: end if;
480: end if;
481: end rosetta_table_copy_in_p9;
482: procedure rosetta_table_copy_out_p9(t ahl_vwp_visits_stages_pvt.visit_stages_ovn_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
483: , a1 out nocopy JTF_NUMBER_TABLE
484: ) as
485: ddindx binary_integer; indx binary_integer;
486: begin
487: if t is null or t.count = 0 then
484: ) as
485: ddindx binary_integer; indx binary_integer;
486: begin
487: if t is null or t.count = 0 then
488: a0 := JTF_NUMBER_TABLE();
489: a1 := JTF_NUMBER_TABLE();
490: else
491: a0 := JTF_NUMBER_TABLE();
492: a1 := JTF_NUMBER_TABLE();
485: ddindx binary_integer; indx binary_integer;
486: begin
487: if t is null or t.count = 0 then
488: a0 := JTF_NUMBER_TABLE();
489: a1 := JTF_NUMBER_TABLE();
490: else
491: a0 := JTF_NUMBER_TABLE();
492: a1 := JTF_NUMBER_TABLE();
493: if t.count > 0 then
487: if t is null or t.count = 0 then
488: a0 := JTF_NUMBER_TABLE();
489: a1 := JTF_NUMBER_TABLE();
490: else
491: a0 := JTF_NUMBER_TABLE();
492: a1 := JTF_NUMBER_TABLE();
493: if t.count > 0 then
494: a0.extend(t.count);
495: a1.extend(t.count);
488: a0 := JTF_NUMBER_TABLE();
489: a1 := JTF_NUMBER_TABLE();
490: else
491: a0 := JTF_NUMBER_TABLE();
492: a1 := JTF_NUMBER_TABLE();
493: if t.count > 0 then
494: a0.extend(t.count);
495: a1.extend(t.count);
496: ddindx := t.first;
513: , p_commit VARCHAR2
514: , p_validation_level NUMBER
515: , p_module_type VARCHAR2
516: , p_visit_id NUMBER
517: , p6_a0 in out nocopy JTF_NUMBER_TABLE
518: , p6_a1 in out nocopy JTF_NUMBER_TABLE
519: , p6_a2 in out nocopy JTF_VARCHAR2_TABLE_100
520: , p6_a3 in out nocopy JTF_NUMBER_TABLE
521: , p6_a4 in out nocopy JTF_DATE_TABLE
514: , p_validation_level NUMBER
515: , p_module_type VARCHAR2
516: , p_visit_id NUMBER
517: , p6_a0 in out nocopy JTF_NUMBER_TABLE
518: , p6_a1 in out nocopy JTF_NUMBER_TABLE
519: , p6_a2 in out nocopy JTF_VARCHAR2_TABLE_100
520: , p6_a3 in out nocopy JTF_NUMBER_TABLE
521: , p6_a4 in out nocopy JTF_DATE_TABLE
522: , p6_a5 in out nocopy JTF_DATE_TABLE
516: , p_visit_id NUMBER
517: , p6_a0 in out nocopy JTF_NUMBER_TABLE
518: , p6_a1 in out nocopy JTF_NUMBER_TABLE
519: , p6_a2 in out nocopy JTF_VARCHAR2_TABLE_100
520: , p6_a3 in out nocopy JTF_NUMBER_TABLE
521: , p6_a4 in out nocopy JTF_DATE_TABLE
522: , p6_a5 in out nocopy JTF_DATE_TABLE
523: , p6_a6 in out nocopy JTF_DATE_TABLE
524: , p6_a7 in out nocopy JTF_VARCHAR2_TABLE_100
521: , p6_a4 in out nocopy JTF_DATE_TABLE
522: , p6_a5 in out nocopy JTF_DATE_TABLE
523: , p6_a6 in out nocopy JTF_DATE_TABLE
524: , p6_a7 in out nocopy JTF_VARCHAR2_TABLE_100
525: , p6_a8 in out nocopy JTF_NUMBER_TABLE
526: , p6_a9 in out nocopy JTF_DATE_TABLE
527: , p6_a10 in out nocopy JTF_NUMBER_TABLE
528: , p6_a11 in out nocopy JTF_VARCHAR2_TABLE_100
529: , p6_a12 in out nocopy JTF_VARCHAR2_TABLE_200
523: , p6_a6 in out nocopy JTF_DATE_TABLE
524: , p6_a7 in out nocopy JTF_VARCHAR2_TABLE_100
525: , p6_a8 in out nocopy JTF_NUMBER_TABLE
526: , p6_a9 in out nocopy JTF_DATE_TABLE
527: , p6_a10 in out nocopy JTF_NUMBER_TABLE
528: , p6_a11 in out nocopy JTF_VARCHAR2_TABLE_100
529: , p6_a12 in out nocopy JTF_VARCHAR2_TABLE_200
530: , p6_a13 in out nocopy JTF_VARCHAR2_TABLE_200
531: , p6_a14 in out nocopy JTF_VARCHAR2_TABLE_200
540: , p6_a23 in out nocopy JTF_VARCHAR2_TABLE_200
541: , p6_a24 in out nocopy JTF_VARCHAR2_TABLE_200
542: , p6_a25 in out nocopy JTF_VARCHAR2_TABLE_200
543: , p6_a26 in out nocopy JTF_VARCHAR2_TABLE_200
544: , p7_a0 in out nocopy JTF_NUMBER_TABLE
545: , p7_a1 in out nocopy JTF_NUMBER_TABLE
546: , x_return_status out nocopy VARCHAR2
547: , x_msg_count out nocopy NUMBER
548: , x_msg_data out nocopy VARCHAR2
541: , p6_a24 in out nocopy JTF_VARCHAR2_TABLE_200
542: , p6_a25 in out nocopy JTF_VARCHAR2_TABLE_200
543: , p6_a26 in out nocopy JTF_VARCHAR2_TABLE_200
544: , p7_a0 in out nocopy JTF_NUMBER_TABLE
545: , p7_a1 in out nocopy JTF_NUMBER_TABLE
546: , x_return_status out nocopy VARCHAR2
547: , x_msg_count out nocopy NUMBER
548: , x_msg_data out nocopy VARCHAR2
549: )
661: , p_module_type VARCHAR2
662: , p_visit_id NUMBER
663: , p_start_row NUMBER
664: , p_rows_per_page NUMBER
665: , p8_a0 out nocopy JTF_NUMBER_TABLE
666: , p8_a1 out nocopy JTF_NUMBER_TABLE
667: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
668: , p8_a3 out nocopy JTF_NUMBER_TABLE
669: , p8_a4 out nocopy JTF_DATE_TABLE
662: , p_visit_id NUMBER
663: , p_start_row NUMBER
664: , p_rows_per_page NUMBER
665: , p8_a0 out nocopy JTF_NUMBER_TABLE
666: , p8_a1 out nocopy JTF_NUMBER_TABLE
667: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
668: , p8_a3 out nocopy JTF_NUMBER_TABLE
669: , p8_a4 out nocopy JTF_DATE_TABLE
670: , p8_a5 out nocopy JTF_DATE_TABLE
664: , p_rows_per_page NUMBER
665: , p8_a0 out nocopy JTF_NUMBER_TABLE
666: , p8_a1 out nocopy JTF_NUMBER_TABLE
667: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
668: , p8_a3 out nocopy JTF_NUMBER_TABLE
669: , p8_a4 out nocopy JTF_DATE_TABLE
670: , p8_a5 out nocopy JTF_DATE_TABLE
671: , p8_a6 out nocopy JTF_DATE_TABLE
672: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
669: , p8_a4 out nocopy JTF_DATE_TABLE
670: , p8_a5 out nocopy JTF_DATE_TABLE
671: , p8_a6 out nocopy JTF_DATE_TABLE
672: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
673: , p8_a8 out nocopy JTF_NUMBER_TABLE
674: , p8_a9 out nocopy JTF_DATE_TABLE
675: , p8_a10 out nocopy JTF_NUMBER_TABLE
676: , p8_a11 out nocopy JTF_VARCHAR2_TABLE_100
677: , p8_a12 out nocopy JTF_VARCHAR2_TABLE_200
671: , p8_a6 out nocopy JTF_DATE_TABLE
672: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
673: , p8_a8 out nocopy JTF_NUMBER_TABLE
674: , p8_a9 out nocopy JTF_DATE_TABLE
675: , p8_a10 out nocopy JTF_NUMBER_TABLE
676: , p8_a11 out nocopy JTF_VARCHAR2_TABLE_100
677: , p8_a12 out nocopy JTF_VARCHAR2_TABLE_200
678: , p8_a13 out nocopy JTF_VARCHAR2_TABLE_200
679: , p8_a14 out nocopy JTF_VARCHAR2_TABLE_200
777: , p_commit VARCHAR2
778: , p_validation_level NUMBER
779: , p_module_type VARCHAR2
780: , p_visit_id NUMBER
781: , p6_a0 in out nocopy JTF_NUMBER_TABLE
782: , p6_a1 in out nocopy JTF_NUMBER_TABLE
783: , p6_a2 in out nocopy JTF_VARCHAR2_TABLE_100
784: , p6_a3 in out nocopy JTF_NUMBER_TABLE
785: , p6_a4 in out nocopy JTF_DATE_TABLE
778: , p_validation_level NUMBER
779: , p_module_type VARCHAR2
780: , p_visit_id NUMBER
781: , p6_a0 in out nocopy JTF_NUMBER_TABLE
782: , p6_a1 in out nocopy JTF_NUMBER_TABLE
783: , p6_a2 in out nocopy JTF_VARCHAR2_TABLE_100
784: , p6_a3 in out nocopy JTF_NUMBER_TABLE
785: , p6_a4 in out nocopy JTF_DATE_TABLE
786: , p6_a5 in out nocopy JTF_DATE_TABLE
780: , p_visit_id NUMBER
781: , p6_a0 in out nocopy JTF_NUMBER_TABLE
782: , p6_a1 in out nocopy JTF_NUMBER_TABLE
783: , p6_a2 in out nocopy JTF_VARCHAR2_TABLE_100
784: , p6_a3 in out nocopy JTF_NUMBER_TABLE
785: , p6_a4 in out nocopy JTF_DATE_TABLE
786: , p6_a5 in out nocopy JTF_DATE_TABLE
787: , p6_a6 in out nocopy JTF_DATE_TABLE
788: , p6_a7 in out nocopy JTF_VARCHAR2_TABLE_100
785: , p6_a4 in out nocopy JTF_DATE_TABLE
786: , p6_a5 in out nocopy JTF_DATE_TABLE
787: , p6_a6 in out nocopy JTF_DATE_TABLE
788: , p6_a7 in out nocopy JTF_VARCHAR2_TABLE_100
789: , p6_a8 in out nocopy JTF_NUMBER_TABLE
790: , p6_a9 in out nocopy JTF_DATE_TABLE
791: , p6_a10 in out nocopy JTF_NUMBER_TABLE
792: , p6_a11 in out nocopy JTF_VARCHAR2_TABLE_100
793: , p6_a12 in out nocopy JTF_VARCHAR2_TABLE_200
787: , p6_a6 in out nocopy JTF_DATE_TABLE
788: , p6_a7 in out nocopy JTF_VARCHAR2_TABLE_100
789: , p6_a8 in out nocopy JTF_NUMBER_TABLE
790: , p6_a9 in out nocopy JTF_DATE_TABLE
791: , p6_a10 in out nocopy JTF_NUMBER_TABLE
792: , p6_a11 in out nocopy JTF_VARCHAR2_TABLE_100
793: , p6_a12 in out nocopy JTF_VARCHAR2_TABLE_200
794: , p6_a13 in out nocopy JTF_VARCHAR2_TABLE_200
795: , p6_a14 in out nocopy JTF_VARCHAR2_TABLE_200
911: , p_commit VARCHAR2
912: , p_validation_level NUMBER
913: , p_module_type VARCHAR2
914: , p_visit_id NUMBER
915: , p6_a0 in out nocopy JTF_NUMBER_TABLE
916: , p6_a1 in out nocopy JTF_NUMBER_TABLE
917: , p6_a2 in out nocopy JTF_VARCHAR2_TABLE_100
918: , p6_a3 in out nocopy JTF_NUMBER_TABLE
919: , p6_a4 in out nocopy JTF_DATE_TABLE
912: , p_validation_level NUMBER
913: , p_module_type VARCHAR2
914: , p_visit_id NUMBER
915: , p6_a0 in out nocopy JTF_NUMBER_TABLE
916: , p6_a1 in out nocopy JTF_NUMBER_TABLE
917: , p6_a2 in out nocopy JTF_VARCHAR2_TABLE_100
918: , p6_a3 in out nocopy JTF_NUMBER_TABLE
919: , p6_a4 in out nocopy JTF_DATE_TABLE
920: , p6_a5 in out nocopy JTF_DATE_TABLE
914: , p_visit_id NUMBER
915: , p6_a0 in out nocopy JTF_NUMBER_TABLE
916: , p6_a1 in out nocopy JTF_NUMBER_TABLE
917: , p6_a2 in out nocopy JTF_VARCHAR2_TABLE_100
918: , p6_a3 in out nocopy JTF_NUMBER_TABLE
919: , p6_a4 in out nocopy JTF_DATE_TABLE
920: , p6_a5 in out nocopy JTF_DATE_TABLE
921: , p6_a6 in out nocopy JTF_DATE_TABLE
922: , p6_a7 in out nocopy JTF_VARCHAR2_TABLE_100
919: , p6_a4 in out nocopy JTF_DATE_TABLE
920: , p6_a5 in out nocopy JTF_DATE_TABLE
921: , p6_a6 in out nocopy JTF_DATE_TABLE
922: , p6_a7 in out nocopy JTF_VARCHAR2_TABLE_100
923: , p6_a8 in out nocopy JTF_NUMBER_TABLE
924: , p6_a9 in out nocopy JTF_DATE_TABLE
925: , p6_a10 in out nocopy JTF_NUMBER_TABLE
926: , p6_a11 in out nocopy JTF_VARCHAR2_TABLE_100
927: , p6_a12 in out nocopy JTF_VARCHAR2_TABLE_200
921: , p6_a6 in out nocopy JTF_DATE_TABLE
922: , p6_a7 in out nocopy JTF_VARCHAR2_TABLE_100
923: , p6_a8 in out nocopy JTF_NUMBER_TABLE
924: , p6_a9 in out nocopy JTF_DATE_TABLE
925: , p6_a10 in out nocopy JTF_NUMBER_TABLE
926: , p6_a11 in out nocopy JTF_VARCHAR2_TABLE_100
927: , p6_a12 in out nocopy JTF_VARCHAR2_TABLE_200
928: , p6_a13 in out nocopy JTF_VARCHAR2_TABLE_200
929: , p6_a14 in out nocopy JTF_VARCHAR2_TABLE_200
1043: procedure process_stagetyp_assoc(p_api_version NUMBER
1044: , p_init_msg_list VARCHAR2
1045: , p_commit VARCHAR2
1046: , p_validation_level NUMBER
1047: , p4_a0 JTF_NUMBER_TABLE
1048: , p4_a1 JTF_NUMBER_TABLE
1049: , p4_a2 JTF_VARCHAR2_TABLE_100
1050: , p4_a3 JTF_VARCHAR2_TABLE_100
1051: , x_return_status out nocopy VARCHAR2
1044: , p_init_msg_list VARCHAR2
1045: , p_commit VARCHAR2
1046: , p_validation_level NUMBER
1047: , p4_a0 JTF_NUMBER_TABLE
1048: , p4_a1 JTF_NUMBER_TABLE
1049: , p4_a2 JTF_VARCHAR2_TABLE_100
1050: , p4_a3 JTF_VARCHAR2_TABLE_100
1051: , x_return_status out nocopy VARCHAR2
1052: , x_msg_count out nocopy NUMBER