9: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
10: return d;
11: end;
12:
13: procedure rosetta_table_copy_in_p2(t out nocopy ahl_vwp_visits_stages_pvt.visit_stages_tbl_type, a0 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_VARCHAR2_TABLE_100
16: , a3 JTF_NUMBER_TABLE
17: , a4 JTF_DATE_TABLE
10: return d;
11: end;
12:
13: procedure rosetta_table_copy_in_p2(t out nocopy ahl_vwp_visits_stages_pvt.visit_stages_tbl_type, a0 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_VARCHAR2_TABLE_100
16: , a3 JTF_NUMBER_TABLE
17: , a4 JTF_DATE_TABLE
18: , a5 JTF_DATE_TABLE
12:
13: procedure rosetta_table_copy_in_p2(t out nocopy ahl_vwp_visits_stages_pvt.visit_stages_tbl_type, a0 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_VARCHAR2_TABLE_100
16: , a3 JTF_NUMBER_TABLE
17: , a4 JTF_DATE_TABLE
18: , a5 JTF_DATE_TABLE
19: , a6 JTF_DATE_TABLE
20: , a7 JTF_NUMBER_TABLE
16: , a3 JTF_NUMBER_TABLE
17: , a4 JTF_DATE_TABLE
18: , a5 JTF_DATE_TABLE
19: , a6 JTF_DATE_TABLE
20: , a7 JTF_NUMBER_TABLE
21: , a8 JTF_VARCHAR2_TABLE_100
22: , a9 JTF_VARCHAR2_TABLE_200
23: , a10 JTF_VARCHAR2_TABLE_200
24: , a11 JTF_VARCHAR2_TABLE_200
74: end loop;
75: end if;
76: end if;
77: end rosetta_table_copy_in_p2;
78: procedure rosetta_table_copy_out_p2(t ahl_vwp_visits_stages_pvt.visit_stages_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
79: , a1 out nocopy JTF_NUMBER_TABLE
80: , a2 out nocopy JTF_VARCHAR2_TABLE_100
81: , a3 out nocopy JTF_NUMBER_TABLE
82: , a4 out nocopy JTF_DATE_TABLE
75: end if;
76: end if;
77: end rosetta_table_copy_in_p2;
78: procedure rosetta_table_copy_out_p2(t ahl_vwp_visits_stages_pvt.visit_stages_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
79: , a1 out nocopy JTF_NUMBER_TABLE
80: , a2 out nocopy JTF_VARCHAR2_TABLE_100
81: , a3 out nocopy JTF_NUMBER_TABLE
82: , a4 out nocopy JTF_DATE_TABLE
83: , a5 out nocopy JTF_DATE_TABLE
77: end rosetta_table_copy_in_p2;
78: procedure rosetta_table_copy_out_p2(t ahl_vwp_visits_stages_pvt.visit_stages_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
79: , a1 out nocopy JTF_NUMBER_TABLE
80: , a2 out nocopy JTF_VARCHAR2_TABLE_100
81: , a3 out nocopy JTF_NUMBER_TABLE
82: , a4 out nocopy JTF_DATE_TABLE
83: , a5 out nocopy JTF_DATE_TABLE
84: , a6 out nocopy JTF_DATE_TABLE
85: , a7 out nocopy JTF_NUMBER_TABLE
81: , a3 out nocopy JTF_NUMBER_TABLE
82: , a4 out nocopy JTF_DATE_TABLE
83: , a5 out nocopy JTF_DATE_TABLE
84: , a6 out nocopy JTF_DATE_TABLE
85: , a7 out nocopy JTF_NUMBER_TABLE
86: , a8 out nocopy JTF_VARCHAR2_TABLE_100
87: , a9 out nocopy JTF_VARCHAR2_TABLE_200
88: , a10 out nocopy JTF_VARCHAR2_TABLE_200
89: , a11 out nocopy JTF_VARCHAR2_TABLE_200
102: ) as
103: ddindx binary_integer; indx binary_integer;
104: begin
105: if t is null or t.count = 0 then
106: a0 := JTF_NUMBER_TABLE();
107: a1 := JTF_NUMBER_TABLE();
108: a2 := JTF_VARCHAR2_TABLE_100();
109: a3 := JTF_NUMBER_TABLE();
110: a4 := JTF_DATE_TABLE();
103: ddindx binary_integer; indx binary_integer;
104: begin
105: if t is null or t.count = 0 then
106: a0 := JTF_NUMBER_TABLE();
107: a1 := JTF_NUMBER_TABLE();
108: a2 := JTF_VARCHAR2_TABLE_100();
109: a3 := JTF_NUMBER_TABLE();
110: a4 := JTF_DATE_TABLE();
111: a5 := JTF_DATE_TABLE();
105: if t is null or t.count = 0 then
106: a0 := JTF_NUMBER_TABLE();
107: a1 := JTF_NUMBER_TABLE();
108: a2 := JTF_VARCHAR2_TABLE_100();
109: a3 := JTF_NUMBER_TABLE();
110: a4 := JTF_DATE_TABLE();
111: a5 := JTF_DATE_TABLE();
112: a6 := JTF_DATE_TABLE();
113: a7 := JTF_NUMBER_TABLE();
109: a3 := JTF_NUMBER_TABLE();
110: a4 := JTF_DATE_TABLE();
111: a5 := JTF_DATE_TABLE();
112: a6 := JTF_DATE_TABLE();
113: a7 := JTF_NUMBER_TABLE();
114: a8 := JTF_VARCHAR2_TABLE_100();
115: a9 := JTF_VARCHAR2_TABLE_200();
116: a10 := JTF_VARCHAR2_TABLE_200();
117: a11 := JTF_VARCHAR2_TABLE_200();
127: a21 := JTF_VARCHAR2_TABLE_200();
128: a22 := JTF_VARCHAR2_TABLE_200();
129: a23 := JTF_VARCHAR2_TABLE_200();
130: else
131: a0 := JTF_NUMBER_TABLE();
132: a1 := JTF_NUMBER_TABLE();
133: a2 := JTF_VARCHAR2_TABLE_100();
134: a3 := JTF_NUMBER_TABLE();
135: a4 := JTF_DATE_TABLE();
128: a22 := JTF_VARCHAR2_TABLE_200();
129: a23 := JTF_VARCHAR2_TABLE_200();
130: else
131: a0 := JTF_NUMBER_TABLE();
132: a1 := JTF_NUMBER_TABLE();
133: a2 := JTF_VARCHAR2_TABLE_100();
134: a3 := JTF_NUMBER_TABLE();
135: a4 := JTF_DATE_TABLE();
136: a5 := JTF_DATE_TABLE();
130: else
131: a0 := JTF_NUMBER_TABLE();
132: a1 := JTF_NUMBER_TABLE();
133: a2 := JTF_VARCHAR2_TABLE_100();
134: a3 := JTF_NUMBER_TABLE();
135: a4 := JTF_DATE_TABLE();
136: a5 := JTF_DATE_TABLE();
137: a6 := JTF_DATE_TABLE();
138: a7 := JTF_NUMBER_TABLE();
134: a3 := JTF_NUMBER_TABLE();
135: a4 := JTF_DATE_TABLE();
136: a5 := JTF_DATE_TABLE();
137: a6 := JTF_DATE_TABLE();
138: a7 := JTF_NUMBER_TABLE();
139: a8 := JTF_VARCHAR2_TABLE_100();
140: a9 := JTF_VARCHAR2_TABLE_200();
141: a10 := JTF_VARCHAR2_TABLE_200();
142: a11 := JTF_VARCHAR2_TABLE_200();
213: end if;
214: end if;
215: end rosetta_table_copy_out_p2;
216:
217: procedure rosetta_table_copy_in_p3(t out nocopy ahl_vwp_visits_stages_pvt.visit_stages_times_tbl_type, a0 JTF_NUMBER_TABLE
218: , a1 JTF_NUMBER_TABLE
219: , a2 JTF_VARCHAR2_TABLE_100
220: , a3 JTF_NUMBER_TABLE
221: , a4 JTF_NUMBER_TABLE
214: end if;
215: end rosetta_table_copy_out_p2;
216:
217: procedure rosetta_table_copy_in_p3(t out nocopy ahl_vwp_visits_stages_pvt.visit_stages_times_tbl_type, a0 JTF_NUMBER_TABLE
218: , a1 JTF_NUMBER_TABLE
219: , a2 JTF_VARCHAR2_TABLE_100
220: , a3 JTF_NUMBER_TABLE
221: , a4 JTF_NUMBER_TABLE
222: , a5 JTF_NUMBER_TABLE
216:
217: procedure rosetta_table_copy_in_p3(t out nocopy ahl_vwp_visits_stages_pvt.visit_stages_times_tbl_type, a0 JTF_NUMBER_TABLE
218: , a1 JTF_NUMBER_TABLE
219: , a2 JTF_VARCHAR2_TABLE_100
220: , a3 JTF_NUMBER_TABLE
221: , a4 JTF_NUMBER_TABLE
222: , a5 JTF_NUMBER_TABLE
223: , a6 JTF_DATE_TABLE
224: , a7 JTF_DATE_TABLE
217: procedure rosetta_table_copy_in_p3(t out nocopy ahl_vwp_visits_stages_pvt.visit_stages_times_tbl_type, a0 JTF_NUMBER_TABLE
218: , a1 JTF_NUMBER_TABLE
219: , a2 JTF_VARCHAR2_TABLE_100
220: , a3 JTF_NUMBER_TABLE
221: , a4 JTF_NUMBER_TABLE
222: , a5 JTF_NUMBER_TABLE
223: , a6 JTF_DATE_TABLE
224: , a7 JTF_DATE_TABLE
225: , a8 JTF_DATE_TABLE
218: , a1 JTF_NUMBER_TABLE
219: , a2 JTF_VARCHAR2_TABLE_100
220: , a3 JTF_NUMBER_TABLE
221: , a4 JTF_NUMBER_TABLE
222: , a5 JTF_NUMBER_TABLE
223: , a6 JTF_DATE_TABLE
224: , a7 JTF_DATE_TABLE
225: , a8 JTF_DATE_TABLE
226: ) as
248: end loop;
249: end if;
250: end if;
251: end rosetta_table_copy_in_p3;
252: procedure rosetta_table_copy_out_p3(t ahl_vwp_visits_stages_pvt.visit_stages_times_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
253: , a1 out nocopy JTF_NUMBER_TABLE
254: , a2 out nocopy JTF_VARCHAR2_TABLE_100
255: , a3 out nocopy JTF_NUMBER_TABLE
256: , a4 out nocopy JTF_NUMBER_TABLE
249: end if;
250: end if;
251: end rosetta_table_copy_in_p3;
252: procedure rosetta_table_copy_out_p3(t ahl_vwp_visits_stages_pvt.visit_stages_times_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
253: , a1 out nocopy JTF_NUMBER_TABLE
254: , a2 out nocopy JTF_VARCHAR2_TABLE_100
255: , a3 out nocopy JTF_NUMBER_TABLE
256: , a4 out nocopy JTF_NUMBER_TABLE
257: , a5 out nocopy JTF_NUMBER_TABLE
251: end rosetta_table_copy_in_p3;
252: procedure rosetta_table_copy_out_p3(t ahl_vwp_visits_stages_pvt.visit_stages_times_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
253: , a1 out nocopy JTF_NUMBER_TABLE
254: , a2 out nocopy JTF_VARCHAR2_TABLE_100
255: , a3 out nocopy JTF_NUMBER_TABLE
256: , a4 out nocopy JTF_NUMBER_TABLE
257: , a5 out nocopy JTF_NUMBER_TABLE
258: , a6 out nocopy JTF_DATE_TABLE
259: , a7 out nocopy JTF_DATE_TABLE
252: procedure rosetta_table_copy_out_p3(t ahl_vwp_visits_stages_pvt.visit_stages_times_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
253: , a1 out nocopy JTF_NUMBER_TABLE
254: , a2 out nocopy JTF_VARCHAR2_TABLE_100
255: , a3 out nocopy JTF_NUMBER_TABLE
256: , a4 out nocopy JTF_NUMBER_TABLE
257: , a5 out nocopy JTF_NUMBER_TABLE
258: , a6 out nocopy JTF_DATE_TABLE
259: , a7 out nocopy JTF_DATE_TABLE
260: , a8 out nocopy JTF_DATE_TABLE
253: , a1 out nocopy JTF_NUMBER_TABLE
254: , a2 out nocopy JTF_VARCHAR2_TABLE_100
255: , a3 out nocopy JTF_NUMBER_TABLE
256: , a4 out nocopy JTF_NUMBER_TABLE
257: , a5 out nocopy JTF_NUMBER_TABLE
258: , a6 out nocopy JTF_DATE_TABLE
259: , a7 out nocopy JTF_DATE_TABLE
260: , a8 out nocopy JTF_DATE_TABLE
261: ) as
261: ) as
262: ddindx binary_integer; indx binary_integer;
263: begin
264: if t is null or t.count = 0 then
265: a0 := JTF_NUMBER_TABLE();
266: a1 := JTF_NUMBER_TABLE();
267: a2 := JTF_VARCHAR2_TABLE_100();
268: a3 := JTF_NUMBER_TABLE();
269: a4 := JTF_NUMBER_TABLE();
262: ddindx binary_integer; indx binary_integer;
263: begin
264: if t is null or t.count = 0 then
265: a0 := JTF_NUMBER_TABLE();
266: a1 := JTF_NUMBER_TABLE();
267: a2 := JTF_VARCHAR2_TABLE_100();
268: a3 := JTF_NUMBER_TABLE();
269: a4 := JTF_NUMBER_TABLE();
270: a5 := JTF_NUMBER_TABLE();
264: if t is null or t.count = 0 then
265: a0 := JTF_NUMBER_TABLE();
266: a1 := JTF_NUMBER_TABLE();
267: a2 := JTF_VARCHAR2_TABLE_100();
268: a3 := JTF_NUMBER_TABLE();
269: a4 := JTF_NUMBER_TABLE();
270: a5 := JTF_NUMBER_TABLE();
271: a6 := JTF_DATE_TABLE();
272: a7 := JTF_DATE_TABLE();
265: a0 := JTF_NUMBER_TABLE();
266: a1 := JTF_NUMBER_TABLE();
267: a2 := JTF_VARCHAR2_TABLE_100();
268: a3 := JTF_NUMBER_TABLE();
269: a4 := JTF_NUMBER_TABLE();
270: a5 := JTF_NUMBER_TABLE();
271: a6 := JTF_DATE_TABLE();
272: a7 := JTF_DATE_TABLE();
273: a8 := JTF_DATE_TABLE();
266: a1 := JTF_NUMBER_TABLE();
267: a2 := JTF_VARCHAR2_TABLE_100();
268: a3 := JTF_NUMBER_TABLE();
269: a4 := JTF_NUMBER_TABLE();
270: a5 := JTF_NUMBER_TABLE();
271: a6 := JTF_DATE_TABLE();
272: a7 := JTF_DATE_TABLE();
273: a8 := JTF_DATE_TABLE();
274: else
271: a6 := JTF_DATE_TABLE();
272: a7 := JTF_DATE_TABLE();
273: a8 := JTF_DATE_TABLE();
274: else
275: a0 := JTF_NUMBER_TABLE();
276: a1 := JTF_NUMBER_TABLE();
277: a2 := JTF_VARCHAR2_TABLE_100();
278: a3 := JTF_NUMBER_TABLE();
279: a4 := JTF_NUMBER_TABLE();
272: a7 := JTF_DATE_TABLE();
273: a8 := JTF_DATE_TABLE();
274: else
275: a0 := JTF_NUMBER_TABLE();
276: a1 := JTF_NUMBER_TABLE();
277: a2 := JTF_VARCHAR2_TABLE_100();
278: a3 := JTF_NUMBER_TABLE();
279: a4 := JTF_NUMBER_TABLE();
280: a5 := JTF_NUMBER_TABLE();
274: else
275: a0 := JTF_NUMBER_TABLE();
276: a1 := JTF_NUMBER_TABLE();
277: a2 := JTF_VARCHAR2_TABLE_100();
278: a3 := JTF_NUMBER_TABLE();
279: a4 := JTF_NUMBER_TABLE();
280: a5 := JTF_NUMBER_TABLE();
281: a6 := JTF_DATE_TABLE();
282: a7 := JTF_DATE_TABLE();
275: a0 := JTF_NUMBER_TABLE();
276: a1 := JTF_NUMBER_TABLE();
277: a2 := JTF_VARCHAR2_TABLE_100();
278: a3 := JTF_NUMBER_TABLE();
279: a4 := JTF_NUMBER_TABLE();
280: a5 := JTF_NUMBER_TABLE();
281: a6 := JTF_DATE_TABLE();
282: a7 := JTF_DATE_TABLE();
283: a8 := JTF_DATE_TABLE();
276: a1 := JTF_NUMBER_TABLE();
277: a2 := JTF_VARCHAR2_TABLE_100();
278: a3 := JTF_NUMBER_TABLE();
279: a4 := JTF_NUMBER_TABLE();
280: a5 := JTF_NUMBER_TABLE();
281: a6 := JTF_DATE_TABLE();
282: a7 := JTF_DATE_TABLE();
283: a8 := JTF_DATE_TABLE();
284: if t.count > 0 then
318: , p_commit VARCHAR2
319: , p_validation_level NUMBER
320: , p_module_type VARCHAR2
321: , p_visit_id NUMBER
322: , p6_a0 in out nocopy JTF_NUMBER_TABLE
323: , p6_a1 in out nocopy JTF_NUMBER_TABLE
324: , p6_a2 in out nocopy JTF_VARCHAR2_TABLE_100
325: , p6_a3 in out nocopy JTF_NUMBER_TABLE
326: , p6_a4 in out nocopy JTF_DATE_TABLE
319: , p_validation_level NUMBER
320: , p_module_type VARCHAR2
321: , p_visit_id NUMBER
322: , p6_a0 in out nocopy JTF_NUMBER_TABLE
323: , p6_a1 in out nocopy JTF_NUMBER_TABLE
324: , p6_a2 in out nocopy JTF_VARCHAR2_TABLE_100
325: , p6_a3 in out nocopy JTF_NUMBER_TABLE
326: , p6_a4 in out nocopy JTF_DATE_TABLE
327: , p6_a5 in out nocopy JTF_DATE_TABLE
321: , p_visit_id NUMBER
322: , p6_a0 in out nocopy JTF_NUMBER_TABLE
323: , p6_a1 in out nocopy JTF_NUMBER_TABLE
324: , p6_a2 in out nocopy JTF_VARCHAR2_TABLE_100
325: , p6_a3 in out nocopy JTF_NUMBER_TABLE
326: , p6_a4 in out nocopy JTF_DATE_TABLE
327: , p6_a5 in out nocopy JTF_DATE_TABLE
328: , p6_a6 in out nocopy JTF_DATE_TABLE
329: , p6_a7 in out nocopy JTF_NUMBER_TABLE
325: , p6_a3 in out nocopy JTF_NUMBER_TABLE
326: , p6_a4 in out nocopy JTF_DATE_TABLE
327: , p6_a5 in out nocopy JTF_DATE_TABLE
328: , p6_a6 in out nocopy JTF_DATE_TABLE
329: , p6_a7 in out nocopy JTF_NUMBER_TABLE
330: , p6_a8 in out nocopy JTF_VARCHAR2_TABLE_100
331: , p6_a9 in out nocopy JTF_VARCHAR2_TABLE_200
332: , p6_a10 in out nocopy JTF_VARCHAR2_TABLE_200
333: , p6_a11 in out nocopy JTF_VARCHAR2_TABLE_200
445: , p_module_type VARCHAR2
446: , p_visit_id NUMBER
447: , p_start_row NUMBER
448: , p_rows_per_page NUMBER
449: , p8_a0 out nocopy JTF_NUMBER_TABLE
450: , p8_a1 out nocopy JTF_NUMBER_TABLE
451: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
452: , p8_a3 out nocopy JTF_NUMBER_TABLE
453: , p8_a4 out nocopy JTF_DATE_TABLE
446: , p_visit_id NUMBER
447: , p_start_row NUMBER
448: , p_rows_per_page NUMBER
449: , p8_a0 out nocopy JTF_NUMBER_TABLE
450: , p8_a1 out nocopy JTF_NUMBER_TABLE
451: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
452: , p8_a3 out nocopy JTF_NUMBER_TABLE
453: , p8_a4 out nocopy JTF_DATE_TABLE
454: , p8_a5 out nocopy JTF_DATE_TABLE
448: , p_rows_per_page NUMBER
449: , p8_a0 out nocopy JTF_NUMBER_TABLE
450: , p8_a1 out nocopy JTF_NUMBER_TABLE
451: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
452: , p8_a3 out nocopy JTF_NUMBER_TABLE
453: , p8_a4 out nocopy JTF_DATE_TABLE
454: , p8_a5 out nocopy JTF_DATE_TABLE
455: , p8_a6 out nocopy JTF_DATE_TABLE
456: , p8_a7 out nocopy JTF_NUMBER_TABLE
452: , p8_a3 out nocopy JTF_NUMBER_TABLE
453: , p8_a4 out nocopy JTF_DATE_TABLE
454: , p8_a5 out nocopy JTF_DATE_TABLE
455: , p8_a6 out nocopy JTF_DATE_TABLE
456: , p8_a7 out nocopy JTF_NUMBER_TABLE
457: , p8_a8 out nocopy JTF_VARCHAR2_TABLE_100
458: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_200
459: , p8_a10 out nocopy JTF_VARCHAR2_TABLE_200
460: , p8_a11 out nocopy JTF_VARCHAR2_TABLE_200