18: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
19: return d;
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t OUT NOCOPY ams_web_track_pvt.web_track_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_NUMBER_TABLE
19: return d;
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t OUT NOCOPY ams_web_track_pvt.web_track_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_NUMBER_TABLE
21:
22: procedure rosetta_table_copy_in_p2(t OUT NOCOPY ams_web_track_pvt.web_track_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_DATE_TABLE
29: , a7 JTF_NUMBER_TABLE
22: procedure rosetta_table_copy_in_p2(t OUT NOCOPY ams_web_track_pvt.web_track_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_DATE_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_DATE_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_DATE_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_DATE_TABLE
31: , a9 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_DATE_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_DATE_TABLE
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_NUMBER_TABLE
33: , a11 JTF_NUMBER_TABLE
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_DATE_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_DATE_TABLE
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_NUMBER_TABLE
33: , a11 JTF_NUMBER_TABLE
34: , a12 JTF_VARCHAR2_TABLE_100
35: , a13 JTF_VARCHAR2_TABLE_200
28: , a6 JTF_DATE_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_DATE_TABLE
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_NUMBER_TABLE
33: , a11 JTF_NUMBER_TABLE
34: , a12 JTF_VARCHAR2_TABLE_100
35: , a13 JTF_VARCHAR2_TABLE_200
36: , a14 JTF_VARCHAR2_TABLE_200
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_DATE_TABLE
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_NUMBER_TABLE
33: , a11 JTF_NUMBER_TABLE
34: , a12 JTF_VARCHAR2_TABLE_100
35: , a13 JTF_VARCHAR2_TABLE_200
36: , a14 JTF_VARCHAR2_TABLE_200
37: , a15 JTF_VARCHAR2_TABLE_200
91: end loop;
92: end if;
93: end if;
94: end rosetta_table_copy_in_p2;
95: procedure rosetta_table_copy_out_p2(t ams_web_track_pvt.web_track_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
96: , a1 OUT NOCOPY JTF_NUMBER_TABLE
97: , a2 OUT NOCOPY JTF_VARCHAR2_TABLE_100
98: , a3 OUT NOCOPY JTF_NUMBER_TABLE
99: , a4 OUT NOCOPY JTF_NUMBER_TABLE
92: end if;
93: end if;
94: end rosetta_table_copy_in_p2;
95: procedure rosetta_table_copy_out_p2(t ams_web_track_pvt.web_track_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
96: , a1 OUT NOCOPY JTF_NUMBER_TABLE
97: , a2 OUT NOCOPY JTF_VARCHAR2_TABLE_100
98: , a3 OUT NOCOPY JTF_NUMBER_TABLE
99: , a4 OUT NOCOPY JTF_NUMBER_TABLE
100: , a5 OUT NOCOPY JTF_NUMBER_TABLE
94: end rosetta_table_copy_in_p2;
95: procedure rosetta_table_copy_out_p2(t ams_web_track_pvt.web_track_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
96: , a1 OUT NOCOPY JTF_NUMBER_TABLE
97: , a2 OUT NOCOPY JTF_VARCHAR2_TABLE_100
98: , a3 OUT NOCOPY JTF_NUMBER_TABLE
99: , a4 OUT NOCOPY JTF_NUMBER_TABLE
100: , a5 OUT NOCOPY JTF_NUMBER_TABLE
101: , a6 OUT NOCOPY JTF_DATE_TABLE
102: , a7 OUT NOCOPY JTF_NUMBER_TABLE
95: procedure rosetta_table_copy_out_p2(t ams_web_track_pvt.web_track_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
96: , a1 OUT NOCOPY JTF_NUMBER_TABLE
97: , a2 OUT NOCOPY JTF_VARCHAR2_TABLE_100
98: , a3 OUT NOCOPY JTF_NUMBER_TABLE
99: , a4 OUT NOCOPY JTF_NUMBER_TABLE
100: , a5 OUT NOCOPY JTF_NUMBER_TABLE
101: , a6 OUT NOCOPY JTF_DATE_TABLE
102: , a7 OUT NOCOPY JTF_NUMBER_TABLE
103: , a8 OUT NOCOPY JTF_DATE_TABLE
96: , a1 OUT NOCOPY JTF_NUMBER_TABLE
97: , a2 OUT NOCOPY JTF_VARCHAR2_TABLE_100
98: , a3 OUT NOCOPY JTF_NUMBER_TABLE
99: , a4 OUT NOCOPY JTF_NUMBER_TABLE
100: , a5 OUT NOCOPY JTF_NUMBER_TABLE
101: , a6 OUT NOCOPY JTF_DATE_TABLE
102: , a7 OUT NOCOPY JTF_NUMBER_TABLE
103: , a8 OUT NOCOPY JTF_DATE_TABLE
104: , a9 OUT NOCOPY JTF_NUMBER_TABLE
98: , a3 OUT NOCOPY JTF_NUMBER_TABLE
99: , a4 OUT NOCOPY JTF_NUMBER_TABLE
100: , a5 OUT NOCOPY JTF_NUMBER_TABLE
101: , a6 OUT NOCOPY JTF_DATE_TABLE
102: , a7 OUT NOCOPY JTF_NUMBER_TABLE
103: , a8 OUT NOCOPY JTF_DATE_TABLE
104: , a9 OUT NOCOPY JTF_NUMBER_TABLE
105: , a10 OUT NOCOPY JTF_NUMBER_TABLE
106: , a11 OUT NOCOPY JTF_NUMBER_TABLE
100: , a5 OUT NOCOPY JTF_NUMBER_TABLE
101: , a6 OUT NOCOPY JTF_DATE_TABLE
102: , a7 OUT NOCOPY JTF_NUMBER_TABLE
103: , a8 OUT NOCOPY JTF_DATE_TABLE
104: , a9 OUT NOCOPY JTF_NUMBER_TABLE
105: , a10 OUT NOCOPY JTF_NUMBER_TABLE
106: , a11 OUT NOCOPY JTF_NUMBER_TABLE
107: , a12 OUT NOCOPY JTF_VARCHAR2_TABLE_100
108: , a13 OUT NOCOPY JTF_VARCHAR2_TABLE_200
101: , a6 OUT NOCOPY JTF_DATE_TABLE
102: , a7 OUT NOCOPY JTF_NUMBER_TABLE
103: , a8 OUT NOCOPY JTF_DATE_TABLE
104: , a9 OUT NOCOPY JTF_NUMBER_TABLE
105: , a10 OUT NOCOPY JTF_NUMBER_TABLE
106: , a11 OUT NOCOPY JTF_NUMBER_TABLE
107: , a12 OUT NOCOPY JTF_VARCHAR2_TABLE_100
108: , a13 OUT NOCOPY JTF_VARCHAR2_TABLE_200
109: , a14 OUT NOCOPY JTF_VARCHAR2_TABLE_200
102: , a7 OUT NOCOPY JTF_NUMBER_TABLE
103: , a8 OUT NOCOPY JTF_DATE_TABLE
104: , a9 OUT NOCOPY JTF_NUMBER_TABLE
105: , a10 OUT NOCOPY JTF_NUMBER_TABLE
106: , a11 OUT NOCOPY JTF_NUMBER_TABLE
107: , a12 OUT NOCOPY JTF_VARCHAR2_TABLE_100
108: , a13 OUT NOCOPY JTF_VARCHAR2_TABLE_200
109: , a14 OUT NOCOPY JTF_VARCHAR2_TABLE_200
110: , a15 OUT NOCOPY JTF_VARCHAR2_TABLE_200
123: ) as
124: ddindx binary_integer; indx binary_integer;
125: begin
126: if t is null or t.count = 0 then
127: a0 := JTF_NUMBER_TABLE();
128: a1 := JTF_NUMBER_TABLE();
129: a2 := JTF_VARCHAR2_TABLE_100();
130: a3 := JTF_NUMBER_TABLE();
131: a4 := JTF_NUMBER_TABLE();
124: ddindx binary_integer; indx binary_integer;
125: begin
126: if t is null or t.count = 0 then
127: a0 := JTF_NUMBER_TABLE();
128: a1 := JTF_NUMBER_TABLE();
129: a2 := JTF_VARCHAR2_TABLE_100();
130: a3 := JTF_NUMBER_TABLE();
131: a4 := JTF_NUMBER_TABLE();
132: a5 := JTF_NUMBER_TABLE();
126: if t is null or t.count = 0 then
127: a0 := JTF_NUMBER_TABLE();
128: a1 := JTF_NUMBER_TABLE();
129: a2 := JTF_VARCHAR2_TABLE_100();
130: a3 := JTF_NUMBER_TABLE();
131: a4 := JTF_NUMBER_TABLE();
132: a5 := JTF_NUMBER_TABLE();
133: a6 := JTF_DATE_TABLE();
134: a7 := JTF_NUMBER_TABLE();
127: a0 := JTF_NUMBER_TABLE();
128: a1 := JTF_NUMBER_TABLE();
129: a2 := JTF_VARCHAR2_TABLE_100();
130: a3 := JTF_NUMBER_TABLE();
131: a4 := JTF_NUMBER_TABLE();
132: a5 := JTF_NUMBER_TABLE();
133: a6 := JTF_DATE_TABLE();
134: a7 := JTF_NUMBER_TABLE();
135: a8 := JTF_DATE_TABLE();
128: a1 := JTF_NUMBER_TABLE();
129: a2 := JTF_VARCHAR2_TABLE_100();
130: a3 := JTF_NUMBER_TABLE();
131: a4 := JTF_NUMBER_TABLE();
132: a5 := JTF_NUMBER_TABLE();
133: a6 := JTF_DATE_TABLE();
134: a7 := JTF_NUMBER_TABLE();
135: a8 := JTF_DATE_TABLE();
136: a9 := JTF_NUMBER_TABLE();
130: a3 := JTF_NUMBER_TABLE();
131: a4 := JTF_NUMBER_TABLE();
132: a5 := JTF_NUMBER_TABLE();
133: a6 := JTF_DATE_TABLE();
134: a7 := JTF_NUMBER_TABLE();
135: a8 := JTF_DATE_TABLE();
136: a9 := JTF_NUMBER_TABLE();
137: a10 := JTF_NUMBER_TABLE();
138: a11 := JTF_NUMBER_TABLE();
132: a5 := JTF_NUMBER_TABLE();
133: a6 := JTF_DATE_TABLE();
134: a7 := JTF_NUMBER_TABLE();
135: a8 := JTF_DATE_TABLE();
136: a9 := JTF_NUMBER_TABLE();
137: a10 := JTF_NUMBER_TABLE();
138: a11 := JTF_NUMBER_TABLE();
139: a12 := JTF_VARCHAR2_TABLE_100();
140: a13 := JTF_VARCHAR2_TABLE_200();
133: a6 := JTF_DATE_TABLE();
134: a7 := JTF_NUMBER_TABLE();
135: a8 := JTF_DATE_TABLE();
136: a9 := JTF_NUMBER_TABLE();
137: a10 := JTF_NUMBER_TABLE();
138: a11 := JTF_NUMBER_TABLE();
139: a12 := JTF_VARCHAR2_TABLE_100();
140: a13 := JTF_VARCHAR2_TABLE_200();
141: a14 := JTF_VARCHAR2_TABLE_200();
134: a7 := JTF_NUMBER_TABLE();
135: a8 := JTF_DATE_TABLE();
136: a9 := JTF_NUMBER_TABLE();
137: a10 := JTF_NUMBER_TABLE();
138: a11 := JTF_NUMBER_TABLE();
139: a12 := JTF_VARCHAR2_TABLE_100();
140: a13 := JTF_VARCHAR2_TABLE_200();
141: a14 := JTF_VARCHAR2_TABLE_200();
142: a15 := JTF_VARCHAR2_TABLE_200();
152: a25 := JTF_VARCHAR2_TABLE_200();
153: a26 := JTF_VARCHAR2_TABLE_200();
154: a27 := JTF_VARCHAR2_TABLE_200();
155: else
156: a0 := JTF_NUMBER_TABLE();
157: a1 := JTF_NUMBER_TABLE();
158: a2 := JTF_VARCHAR2_TABLE_100();
159: a3 := JTF_NUMBER_TABLE();
160: a4 := JTF_NUMBER_TABLE();
153: a26 := JTF_VARCHAR2_TABLE_200();
154: a27 := JTF_VARCHAR2_TABLE_200();
155: else
156: a0 := JTF_NUMBER_TABLE();
157: a1 := JTF_NUMBER_TABLE();
158: a2 := JTF_VARCHAR2_TABLE_100();
159: a3 := JTF_NUMBER_TABLE();
160: a4 := JTF_NUMBER_TABLE();
161: a5 := JTF_NUMBER_TABLE();
155: else
156: a0 := JTF_NUMBER_TABLE();
157: a1 := JTF_NUMBER_TABLE();
158: a2 := JTF_VARCHAR2_TABLE_100();
159: a3 := JTF_NUMBER_TABLE();
160: a4 := JTF_NUMBER_TABLE();
161: a5 := JTF_NUMBER_TABLE();
162: a6 := JTF_DATE_TABLE();
163: a7 := JTF_NUMBER_TABLE();
156: a0 := JTF_NUMBER_TABLE();
157: a1 := JTF_NUMBER_TABLE();
158: a2 := JTF_VARCHAR2_TABLE_100();
159: a3 := JTF_NUMBER_TABLE();
160: a4 := JTF_NUMBER_TABLE();
161: a5 := JTF_NUMBER_TABLE();
162: a6 := JTF_DATE_TABLE();
163: a7 := JTF_NUMBER_TABLE();
164: a8 := JTF_DATE_TABLE();
157: a1 := JTF_NUMBER_TABLE();
158: a2 := JTF_VARCHAR2_TABLE_100();
159: a3 := JTF_NUMBER_TABLE();
160: a4 := JTF_NUMBER_TABLE();
161: a5 := JTF_NUMBER_TABLE();
162: a6 := JTF_DATE_TABLE();
163: a7 := JTF_NUMBER_TABLE();
164: a8 := JTF_DATE_TABLE();
165: a9 := JTF_NUMBER_TABLE();
159: a3 := JTF_NUMBER_TABLE();
160: a4 := JTF_NUMBER_TABLE();
161: a5 := JTF_NUMBER_TABLE();
162: a6 := JTF_DATE_TABLE();
163: a7 := JTF_NUMBER_TABLE();
164: a8 := JTF_DATE_TABLE();
165: a9 := JTF_NUMBER_TABLE();
166: a10 := JTF_NUMBER_TABLE();
167: a11 := JTF_NUMBER_TABLE();
161: a5 := JTF_NUMBER_TABLE();
162: a6 := JTF_DATE_TABLE();
163: a7 := JTF_NUMBER_TABLE();
164: a8 := JTF_DATE_TABLE();
165: a9 := JTF_NUMBER_TABLE();
166: a10 := JTF_NUMBER_TABLE();
167: a11 := JTF_NUMBER_TABLE();
168: a12 := JTF_VARCHAR2_TABLE_100();
169: a13 := JTF_VARCHAR2_TABLE_200();
162: a6 := JTF_DATE_TABLE();
163: a7 := JTF_NUMBER_TABLE();
164: a8 := JTF_DATE_TABLE();
165: a9 := JTF_NUMBER_TABLE();
166: a10 := JTF_NUMBER_TABLE();
167: a11 := JTF_NUMBER_TABLE();
168: a12 := JTF_VARCHAR2_TABLE_100();
169: a13 := JTF_VARCHAR2_TABLE_200();
170: a14 := JTF_VARCHAR2_TABLE_200();
163: a7 := JTF_NUMBER_TABLE();
164: a8 := JTF_DATE_TABLE();
165: a9 := JTF_NUMBER_TABLE();
166: a10 := JTF_NUMBER_TABLE();
167: a11 := JTF_NUMBER_TABLE();
168: a12 := JTF_VARCHAR2_TABLE_100();
169: a13 := JTF_VARCHAR2_TABLE_200();
170: a14 := JTF_VARCHAR2_TABLE_200();
171: a15 := JTF_VARCHAR2_TABLE_200();
250: end if;
251: end if;
252: end rosetta_table_copy_out_p2;
253:
254: procedure rosetta_table_copy_in_p13(t OUT NOCOPY ams_web_track_pvt.web_recomms_tbl_type, a0 JTF_NUMBER_TABLE
255: , a1 JTF_NUMBER_TABLE
256: , a2 JTF_NUMBER_TABLE
257: , a3 JTF_VARCHAR2_TABLE_100
258: , a4 JTF_NUMBER_TABLE
251: end if;
252: end rosetta_table_copy_out_p2;
253:
254: procedure rosetta_table_copy_in_p13(t OUT NOCOPY ams_web_track_pvt.web_recomms_tbl_type, a0 JTF_NUMBER_TABLE
255: , a1 JTF_NUMBER_TABLE
256: , a2 JTF_NUMBER_TABLE
257: , a3 JTF_VARCHAR2_TABLE_100
258: , a4 JTF_NUMBER_TABLE
259: , a5 JTF_NUMBER_TABLE
252: end rosetta_table_copy_out_p2;
253:
254: procedure rosetta_table_copy_in_p13(t OUT NOCOPY ams_web_track_pvt.web_recomms_tbl_type, a0 JTF_NUMBER_TABLE
255: , a1 JTF_NUMBER_TABLE
256: , a2 JTF_NUMBER_TABLE
257: , a3 JTF_VARCHAR2_TABLE_100
258: , a4 JTF_NUMBER_TABLE
259: , a5 JTF_NUMBER_TABLE
260: , a6 JTF_VARCHAR2_TABLE_100
254: procedure rosetta_table_copy_in_p13(t OUT NOCOPY ams_web_track_pvt.web_recomms_tbl_type, a0 JTF_NUMBER_TABLE
255: , a1 JTF_NUMBER_TABLE
256: , a2 JTF_NUMBER_TABLE
257: , a3 JTF_VARCHAR2_TABLE_100
258: , a4 JTF_NUMBER_TABLE
259: , a5 JTF_NUMBER_TABLE
260: , a6 JTF_VARCHAR2_TABLE_100
261: , a7 JTF_DATE_TABLE
262: , a8 JTF_NUMBER_TABLE
255: , a1 JTF_NUMBER_TABLE
256: , a2 JTF_NUMBER_TABLE
257: , a3 JTF_VARCHAR2_TABLE_100
258: , a4 JTF_NUMBER_TABLE
259: , a5 JTF_NUMBER_TABLE
260: , a6 JTF_VARCHAR2_TABLE_100
261: , a7 JTF_DATE_TABLE
262: , a8 JTF_NUMBER_TABLE
263: , a9 JTF_DATE_TABLE
258: , a4 JTF_NUMBER_TABLE
259: , a5 JTF_NUMBER_TABLE
260: , a6 JTF_VARCHAR2_TABLE_100
261: , a7 JTF_DATE_TABLE
262: , a8 JTF_NUMBER_TABLE
263: , a9 JTF_DATE_TABLE
264: , a10 JTF_NUMBER_TABLE
265: , a11 JTF_NUMBER_TABLE
266: , a12 JTF_NUMBER_TABLE
260: , a6 JTF_VARCHAR2_TABLE_100
261: , a7 JTF_DATE_TABLE
262: , a8 JTF_NUMBER_TABLE
263: , a9 JTF_DATE_TABLE
264: , a10 JTF_NUMBER_TABLE
265: , a11 JTF_NUMBER_TABLE
266: , a12 JTF_NUMBER_TABLE
267: , a13 JTF_VARCHAR2_TABLE_100
268: , a14 JTF_VARCHAR2_TABLE_200
261: , a7 JTF_DATE_TABLE
262: , a8 JTF_NUMBER_TABLE
263: , a9 JTF_DATE_TABLE
264: , a10 JTF_NUMBER_TABLE
265: , a11 JTF_NUMBER_TABLE
266: , a12 JTF_NUMBER_TABLE
267: , a13 JTF_VARCHAR2_TABLE_100
268: , a14 JTF_VARCHAR2_TABLE_200
269: , a15 JTF_VARCHAR2_TABLE_200
262: , a8 JTF_NUMBER_TABLE
263: , a9 JTF_DATE_TABLE
264: , a10 JTF_NUMBER_TABLE
265: , a11 JTF_NUMBER_TABLE
266: , a12 JTF_NUMBER_TABLE
267: , a13 JTF_VARCHAR2_TABLE_100
268: , a14 JTF_VARCHAR2_TABLE_200
269: , a15 JTF_VARCHAR2_TABLE_200
270: , a16 JTF_VARCHAR2_TABLE_200
325: end loop;
326: end if;
327: end if;
328: end rosetta_table_copy_in_p13;
329: procedure rosetta_table_copy_out_p13(t ams_web_track_pvt.web_recomms_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
330: , a1 OUT NOCOPY JTF_NUMBER_TABLE
331: , a2 OUT NOCOPY JTF_NUMBER_TABLE
332: , a3 OUT NOCOPY JTF_VARCHAR2_TABLE_100
333: , a4 OUT NOCOPY JTF_NUMBER_TABLE
326: end if;
327: end if;
328: end rosetta_table_copy_in_p13;
329: procedure rosetta_table_copy_out_p13(t ams_web_track_pvt.web_recomms_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
330: , a1 OUT NOCOPY JTF_NUMBER_TABLE
331: , a2 OUT NOCOPY JTF_NUMBER_TABLE
332: , a3 OUT NOCOPY JTF_VARCHAR2_TABLE_100
333: , a4 OUT NOCOPY JTF_NUMBER_TABLE
334: , a5 OUT NOCOPY JTF_NUMBER_TABLE
327: end if;
328: end rosetta_table_copy_in_p13;
329: procedure rosetta_table_copy_out_p13(t ams_web_track_pvt.web_recomms_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
330: , a1 OUT NOCOPY JTF_NUMBER_TABLE
331: , a2 OUT NOCOPY JTF_NUMBER_TABLE
332: , a3 OUT NOCOPY JTF_VARCHAR2_TABLE_100
333: , a4 OUT NOCOPY JTF_NUMBER_TABLE
334: , a5 OUT NOCOPY JTF_NUMBER_TABLE
335: , a6 OUT NOCOPY JTF_VARCHAR2_TABLE_100
329: procedure rosetta_table_copy_out_p13(t ams_web_track_pvt.web_recomms_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
330: , a1 OUT NOCOPY JTF_NUMBER_TABLE
331: , a2 OUT NOCOPY JTF_NUMBER_TABLE
332: , a3 OUT NOCOPY JTF_VARCHAR2_TABLE_100
333: , a4 OUT NOCOPY JTF_NUMBER_TABLE
334: , a5 OUT NOCOPY JTF_NUMBER_TABLE
335: , a6 OUT NOCOPY JTF_VARCHAR2_TABLE_100
336: , a7 OUT NOCOPY JTF_DATE_TABLE
337: , a8 OUT NOCOPY JTF_NUMBER_TABLE
330: , a1 OUT NOCOPY JTF_NUMBER_TABLE
331: , a2 OUT NOCOPY JTF_NUMBER_TABLE
332: , a3 OUT NOCOPY JTF_VARCHAR2_TABLE_100
333: , a4 OUT NOCOPY JTF_NUMBER_TABLE
334: , a5 OUT NOCOPY JTF_NUMBER_TABLE
335: , a6 OUT NOCOPY JTF_VARCHAR2_TABLE_100
336: , a7 OUT NOCOPY JTF_DATE_TABLE
337: , a8 OUT NOCOPY JTF_NUMBER_TABLE
338: , a9 OUT NOCOPY JTF_DATE_TABLE
333: , a4 OUT NOCOPY JTF_NUMBER_TABLE
334: , a5 OUT NOCOPY JTF_NUMBER_TABLE
335: , a6 OUT NOCOPY JTF_VARCHAR2_TABLE_100
336: , a7 OUT NOCOPY JTF_DATE_TABLE
337: , a8 OUT NOCOPY JTF_NUMBER_TABLE
338: , a9 OUT NOCOPY JTF_DATE_TABLE
339: , a10 OUT NOCOPY JTF_NUMBER_TABLE
340: , a11 OUT NOCOPY JTF_NUMBER_TABLE
341: , a12 OUT NOCOPY JTF_NUMBER_TABLE
335: , a6 OUT NOCOPY JTF_VARCHAR2_TABLE_100
336: , a7 OUT NOCOPY JTF_DATE_TABLE
337: , a8 OUT NOCOPY JTF_NUMBER_TABLE
338: , a9 OUT NOCOPY JTF_DATE_TABLE
339: , a10 OUT NOCOPY JTF_NUMBER_TABLE
340: , a11 OUT NOCOPY JTF_NUMBER_TABLE
341: , a12 OUT NOCOPY JTF_NUMBER_TABLE
342: , a13 OUT NOCOPY JTF_VARCHAR2_TABLE_100
343: , a14 OUT NOCOPY JTF_VARCHAR2_TABLE_200
336: , a7 OUT NOCOPY JTF_DATE_TABLE
337: , a8 OUT NOCOPY JTF_NUMBER_TABLE
338: , a9 OUT NOCOPY JTF_DATE_TABLE
339: , a10 OUT NOCOPY JTF_NUMBER_TABLE
340: , a11 OUT NOCOPY JTF_NUMBER_TABLE
341: , a12 OUT NOCOPY JTF_NUMBER_TABLE
342: , a13 OUT NOCOPY JTF_VARCHAR2_TABLE_100
343: , a14 OUT NOCOPY JTF_VARCHAR2_TABLE_200
344: , a15 OUT NOCOPY JTF_VARCHAR2_TABLE_200
337: , a8 OUT NOCOPY JTF_NUMBER_TABLE
338: , a9 OUT NOCOPY JTF_DATE_TABLE
339: , a10 OUT NOCOPY JTF_NUMBER_TABLE
340: , a11 OUT NOCOPY JTF_NUMBER_TABLE
341: , a12 OUT NOCOPY JTF_NUMBER_TABLE
342: , a13 OUT NOCOPY JTF_VARCHAR2_TABLE_100
343: , a14 OUT NOCOPY JTF_VARCHAR2_TABLE_200
344: , a15 OUT NOCOPY JTF_VARCHAR2_TABLE_200
345: , a16 OUT NOCOPY JTF_VARCHAR2_TABLE_200
358: ) as
359: ddindx binary_integer; indx binary_integer;
360: begin
361: if t is null or t.count = 0 then
362: a0 := JTF_NUMBER_TABLE();
363: a1 := JTF_NUMBER_TABLE();
364: a2 := JTF_NUMBER_TABLE();
365: a3 := JTF_VARCHAR2_TABLE_100();
366: a4 := JTF_NUMBER_TABLE();
359: ddindx binary_integer; indx binary_integer;
360: begin
361: if t is null or t.count = 0 then
362: a0 := JTF_NUMBER_TABLE();
363: a1 := JTF_NUMBER_TABLE();
364: a2 := JTF_NUMBER_TABLE();
365: a3 := JTF_VARCHAR2_TABLE_100();
366: a4 := JTF_NUMBER_TABLE();
367: a5 := JTF_NUMBER_TABLE();
360: begin
361: if t is null or t.count = 0 then
362: a0 := JTF_NUMBER_TABLE();
363: a1 := JTF_NUMBER_TABLE();
364: a2 := JTF_NUMBER_TABLE();
365: a3 := JTF_VARCHAR2_TABLE_100();
366: a4 := JTF_NUMBER_TABLE();
367: a5 := JTF_NUMBER_TABLE();
368: a6 := JTF_VARCHAR2_TABLE_100();
362: a0 := JTF_NUMBER_TABLE();
363: a1 := JTF_NUMBER_TABLE();
364: a2 := JTF_NUMBER_TABLE();
365: a3 := JTF_VARCHAR2_TABLE_100();
366: a4 := JTF_NUMBER_TABLE();
367: a5 := JTF_NUMBER_TABLE();
368: a6 := JTF_VARCHAR2_TABLE_100();
369: a7 := JTF_DATE_TABLE();
370: a8 := JTF_NUMBER_TABLE();
363: a1 := JTF_NUMBER_TABLE();
364: a2 := JTF_NUMBER_TABLE();
365: a3 := JTF_VARCHAR2_TABLE_100();
366: a4 := JTF_NUMBER_TABLE();
367: a5 := JTF_NUMBER_TABLE();
368: a6 := JTF_VARCHAR2_TABLE_100();
369: a7 := JTF_DATE_TABLE();
370: a8 := JTF_NUMBER_TABLE();
371: a9 := JTF_DATE_TABLE();
366: a4 := JTF_NUMBER_TABLE();
367: a5 := JTF_NUMBER_TABLE();
368: a6 := JTF_VARCHAR2_TABLE_100();
369: a7 := JTF_DATE_TABLE();
370: a8 := JTF_NUMBER_TABLE();
371: a9 := JTF_DATE_TABLE();
372: a10 := JTF_NUMBER_TABLE();
373: a11 := JTF_NUMBER_TABLE();
374: a12 := JTF_NUMBER_TABLE();
368: a6 := JTF_VARCHAR2_TABLE_100();
369: a7 := JTF_DATE_TABLE();
370: a8 := JTF_NUMBER_TABLE();
371: a9 := JTF_DATE_TABLE();
372: a10 := JTF_NUMBER_TABLE();
373: a11 := JTF_NUMBER_TABLE();
374: a12 := JTF_NUMBER_TABLE();
375: a13 := JTF_VARCHAR2_TABLE_100();
376: a14 := JTF_VARCHAR2_TABLE_200();
369: a7 := JTF_DATE_TABLE();
370: a8 := JTF_NUMBER_TABLE();
371: a9 := JTF_DATE_TABLE();
372: a10 := JTF_NUMBER_TABLE();
373: a11 := JTF_NUMBER_TABLE();
374: a12 := JTF_NUMBER_TABLE();
375: a13 := JTF_VARCHAR2_TABLE_100();
376: a14 := JTF_VARCHAR2_TABLE_200();
377: a15 := JTF_VARCHAR2_TABLE_200();
370: a8 := JTF_NUMBER_TABLE();
371: a9 := JTF_DATE_TABLE();
372: a10 := JTF_NUMBER_TABLE();
373: a11 := JTF_NUMBER_TABLE();
374: a12 := JTF_NUMBER_TABLE();
375: a13 := JTF_VARCHAR2_TABLE_100();
376: a14 := JTF_VARCHAR2_TABLE_200();
377: a15 := JTF_VARCHAR2_TABLE_200();
378: a16 := JTF_VARCHAR2_TABLE_200();
388: a26 := JTF_VARCHAR2_TABLE_200();
389: a27 := JTF_VARCHAR2_TABLE_200();
390: a28 := JTF_VARCHAR2_TABLE_200();
391: else
392: a0 := JTF_NUMBER_TABLE();
393: a1 := JTF_NUMBER_TABLE();
394: a2 := JTF_NUMBER_TABLE();
395: a3 := JTF_VARCHAR2_TABLE_100();
396: a4 := JTF_NUMBER_TABLE();
389: a27 := JTF_VARCHAR2_TABLE_200();
390: a28 := JTF_VARCHAR2_TABLE_200();
391: else
392: a0 := JTF_NUMBER_TABLE();
393: a1 := JTF_NUMBER_TABLE();
394: a2 := JTF_NUMBER_TABLE();
395: a3 := JTF_VARCHAR2_TABLE_100();
396: a4 := JTF_NUMBER_TABLE();
397: a5 := JTF_NUMBER_TABLE();
390: a28 := JTF_VARCHAR2_TABLE_200();
391: else
392: a0 := JTF_NUMBER_TABLE();
393: a1 := JTF_NUMBER_TABLE();
394: a2 := JTF_NUMBER_TABLE();
395: a3 := JTF_VARCHAR2_TABLE_100();
396: a4 := JTF_NUMBER_TABLE();
397: a5 := JTF_NUMBER_TABLE();
398: a6 := JTF_VARCHAR2_TABLE_100();
392: a0 := JTF_NUMBER_TABLE();
393: a1 := JTF_NUMBER_TABLE();
394: a2 := JTF_NUMBER_TABLE();
395: a3 := JTF_VARCHAR2_TABLE_100();
396: a4 := JTF_NUMBER_TABLE();
397: a5 := JTF_NUMBER_TABLE();
398: a6 := JTF_VARCHAR2_TABLE_100();
399: a7 := JTF_DATE_TABLE();
400: a8 := JTF_NUMBER_TABLE();
393: a1 := JTF_NUMBER_TABLE();
394: a2 := JTF_NUMBER_TABLE();
395: a3 := JTF_VARCHAR2_TABLE_100();
396: a4 := JTF_NUMBER_TABLE();
397: a5 := JTF_NUMBER_TABLE();
398: a6 := JTF_VARCHAR2_TABLE_100();
399: a7 := JTF_DATE_TABLE();
400: a8 := JTF_NUMBER_TABLE();
401: a9 := JTF_DATE_TABLE();
396: a4 := JTF_NUMBER_TABLE();
397: a5 := JTF_NUMBER_TABLE();
398: a6 := JTF_VARCHAR2_TABLE_100();
399: a7 := JTF_DATE_TABLE();
400: a8 := JTF_NUMBER_TABLE();
401: a9 := JTF_DATE_TABLE();
402: a10 := JTF_NUMBER_TABLE();
403: a11 := JTF_NUMBER_TABLE();
404: a12 := JTF_NUMBER_TABLE();
398: a6 := JTF_VARCHAR2_TABLE_100();
399: a7 := JTF_DATE_TABLE();
400: a8 := JTF_NUMBER_TABLE();
401: a9 := JTF_DATE_TABLE();
402: a10 := JTF_NUMBER_TABLE();
403: a11 := JTF_NUMBER_TABLE();
404: a12 := JTF_NUMBER_TABLE();
405: a13 := JTF_VARCHAR2_TABLE_100();
406: a14 := JTF_VARCHAR2_TABLE_200();
399: a7 := JTF_DATE_TABLE();
400: a8 := JTF_NUMBER_TABLE();
401: a9 := JTF_DATE_TABLE();
402: a10 := JTF_NUMBER_TABLE();
403: a11 := JTF_NUMBER_TABLE();
404: a12 := JTF_NUMBER_TABLE();
405: a13 := JTF_VARCHAR2_TABLE_100();
406: a14 := JTF_VARCHAR2_TABLE_200();
407: a15 := JTF_VARCHAR2_TABLE_200();
400: a8 := JTF_NUMBER_TABLE();
401: a9 := JTF_DATE_TABLE();
402: a10 := JTF_NUMBER_TABLE();
403: a11 := JTF_NUMBER_TABLE();
404: a12 := JTF_NUMBER_TABLE();
405: a13 := JTF_VARCHAR2_TABLE_100();
406: a14 := JTF_VARCHAR2_TABLE_200();
407: a15 := JTF_VARCHAR2_TABLE_200();
408: a16 := JTF_VARCHAR2_TABLE_200();
489: end if;
490: end if;
491: end rosetta_table_copy_out_p13;
492:
493: procedure rosetta_table_copy_in_p23(t OUT NOCOPY ams_web_track_pvt.impr_obj_id_tbl_type, a0 JTF_NUMBER_TABLE
494: , a1 JTF_NUMBER_TABLE
495: ) as
496: ddindx binary_integer; indx binary_integer;
497: begin
490: end if;
491: end rosetta_table_copy_out_p13;
492:
493: procedure rosetta_table_copy_in_p23(t OUT NOCOPY ams_web_track_pvt.impr_obj_id_tbl_type, a0 JTF_NUMBER_TABLE
494: , a1 JTF_NUMBER_TABLE
495: ) as
496: ddindx binary_integer; indx binary_integer;
497: begin
498: if a0 is not null and a0.count > 0 then
510: end loop;
511: end if;
512: end if;
513: end rosetta_table_copy_in_p23;
514: procedure rosetta_table_copy_out_p23(t ams_web_track_pvt.impr_obj_id_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
515: , a1 OUT NOCOPY JTF_NUMBER_TABLE
516: ) as
517: ddindx binary_integer; indx binary_integer;
518: begin
511: end if;
512: end if;
513: end rosetta_table_copy_in_p23;
514: procedure rosetta_table_copy_out_p23(t ams_web_track_pvt.impr_obj_id_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
515: , a1 OUT NOCOPY JTF_NUMBER_TABLE
516: ) as
517: ddindx binary_integer; indx binary_integer;
518: begin
519: if t is null or t.count = 0 then
516: ) as
517: ddindx binary_integer; indx binary_integer;
518: begin
519: if t is null or t.count = 0 then
520: a0 := JTF_NUMBER_TABLE();
521: a1 := JTF_NUMBER_TABLE();
522: else
523: a0 := JTF_NUMBER_TABLE();
524: a1 := JTF_NUMBER_TABLE();
517: ddindx binary_integer; indx binary_integer;
518: begin
519: if t is null or t.count = 0 then
520: a0 := JTF_NUMBER_TABLE();
521: a1 := JTF_NUMBER_TABLE();
522: else
523: a0 := JTF_NUMBER_TABLE();
524: a1 := JTF_NUMBER_TABLE();
525: if t.count > 0 then
519: if t is null or t.count = 0 then
520: a0 := JTF_NUMBER_TABLE();
521: a1 := JTF_NUMBER_TABLE();
522: else
523: a0 := JTF_NUMBER_TABLE();
524: a1 := JTF_NUMBER_TABLE();
525: if t.count > 0 then
526: a0.extend(t.count);
527: a1.extend(t.count);
520: a0 := JTF_NUMBER_TABLE();
521: a1 := JTF_NUMBER_TABLE();
522: else
523: a0 := JTF_NUMBER_TABLE();
524: a1 := JTF_NUMBER_TABLE();
525: if t.count > 0 then
526: a0.extend(t.count);
527: a1.extend(t.count);
528: ddindx := t.first;
1485: procedure create_web_imp_track(p_api_version_number NUMBER
1486: , p_init_msg_list VARCHAR2
1487: , p_commit VARCHAR2
1488: , p_validation_level NUMBER
1489: , p5_a0 JTF_NUMBER_TABLE
1490: , p5_a1 JTF_NUMBER_TABLE
1491: , p5_a2 JTF_NUMBER_TABLE
1492: , p5_a3 JTF_VARCHAR2_TABLE_100
1493: , p5_a4 JTF_NUMBER_TABLE
1486: , p_init_msg_list VARCHAR2
1487: , p_commit VARCHAR2
1488: , p_validation_level NUMBER
1489: , p5_a0 JTF_NUMBER_TABLE
1490: , p5_a1 JTF_NUMBER_TABLE
1491: , p5_a2 JTF_NUMBER_TABLE
1492: , p5_a3 JTF_VARCHAR2_TABLE_100
1493: , p5_a4 JTF_NUMBER_TABLE
1494: , p5_a5 JTF_NUMBER_TABLE
1487: , p_commit VARCHAR2
1488: , p_validation_level NUMBER
1489: , p5_a0 JTF_NUMBER_TABLE
1490: , p5_a1 JTF_NUMBER_TABLE
1491: , p5_a2 JTF_NUMBER_TABLE
1492: , p5_a3 JTF_VARCHAR2_TABLE_100
1493: , p5_a4 JTF_NUMBER_TABLE
1494: , p5_a5 JTF_NUMBER_TABLE
1495: , p5_a6 JTF_VARCHAR2_TABLE_100
1489: , p5_a0 JTF_NUMBER_TABLE
1490: , p5_a1 JTF_NUMBER_TABLE
1491: , p5_a2 JTF_NUMBER_TABLE
1492: , p5_a3 JTF_VARCHAR2_TABLE_100
1493: , p5_a4 JTF_NUMBER_TABLE
1494: , p5_a5 JTF_NUMBER_TABLE
1495: , p5_a6 JTF_VARCHAR2_TABLE_100
1496: , p5_a7 JTF_DATE_TABLE
1497: , p5_a8 JTF_NUMBER_TABLE
1490: , p5_a1 JTF_NUMBER_TABLE
1491: , p5_a2 JTF_NUMBER_TABLE
1492: , p5_a3 JTF_VARCHAR2_TABLE_100
1493: , p5_a4 JTF_NUMBER_TABLE
1494: , p5_a5 JTF_NUMBER_TABLE
1495: , p5_a6 JTF_VARCHAR2_TABLE_100
1496: , p5_a7 JTF_DATE_TABLE
1497: , p5_a8 JTF_NUMBER_TABLE
1498: , p5_a9 JTF_DATE_TABLE
1493: , p5_a4 JTF_NUMBER_TABLE
1494: , p5_a5 JTF_NUMBER_TABLE
1495: , p5_a6 JTF_VARCHAR2_TABLE_100
1496: , p5_a7 JTF_DATE_TABLE
1497: , p5_a8 JTF_NUMBER_TABLE
1498: , p5_a9 JTF_DATE_TABLE
1499: , p5_a10 JTF_NUMBER_TABLE
1500: , p5_a11 JTF_NUMBER_TABLE
1501: , p5_a12 JTF_NUMBER_TABLE
1495: , p5_a6 JTF_VARCHAR2_TABLE_100
1496: , p5_a7 JTF_DATE_TABLE
1497: , p5_a8 JTF_NUMBER_TABLE
1498: , p5_a9 JTF_DATE_TABLE
1499: , p5_a10 JTF_NUMBER_TABLE
1500: , p5_a11 JTF_NUMBER_TABLE
1501: , p5_a12 JTF_NUMBER_TABLE
1502: , p5_a13 JTF_VARCHAR2_TABLE_100
1503: , p5_a14 JTF_VARCHAR2_TABLE_200
1496: , p5_a7 JTF_DATE_TABLE
1497: , p5_a8 JTF_NUMBER_TABLE
1498: , p5_a9 JTF_DATE_TABLE
1499: , p5_a10 JTF_NUMBER_TABLE
1500: , p5_a11 JTF_NUMBER_TABLE
1501: , p5_a12 JTF_NUMBER_TABLE
1502: , p5_a13 JTF_VARCHAR2_TABLE_100
1503: , p5_a14 JTF_VARCHAR2_TABLE_200
1504: , p5_a15 JTF_VARCHAR2_TABLE_200
1497: , p5_a8 JTF_NUMBER_TABLE
1498: , p5_a9 JTF_DATE_TABLE
1499: , p5_a10 JTF_NUMBER_TABLE
1500: , p5_a11 JTF_NUMBER_TABLE
1501: , p5_a12 JTF_NUMBER_TABLE
1502: , p5_a13 JTF_VARCHAR2_TABLE_100
1503: , p5_a14 JTF_VARCHAR2_TABLE_200
1504: , p5_a15 JTF_VARCHAR2_TABLE_200
1505: , p5_a16 JTF_VARCHAR2_TABLE_200
1514: , p5_a25 JTF_VARCHAR2_TABLE_200
1515: , p5_a26 JTF_VARCHAR2_TABLE_200
1516: , p5_a27 JTF_VARCHAR2_TABLE_200
1517: , p5_a28 JTF_VARCHAR2_TABLE_200
1518: , p6_a0 OUT NOCOPY JTF_NUMBER_TABLE
1519: , p6_a1 OUT NOCOPY JTF_NUMBER_TABLE
1520: , x_return_status OUT NOCOPY VARCHAR2
1521: , x_msg_count OUT NOCOPY NUMBER
1522: , x_msg_data OUT NOCOPY VARCHAR2
1515: , p5_a26 JTF_VARCHAR2_TABLE_200
1516: , p5_a27 JTF_VARCHAR2_TABLE_200
1517: , p5_a28 JTF_VARCHAR2_TABLE_200
1518: , p6_a0 OUT NOCOPY JTF_NUMBER_TABLE
1519: , p6_a1 OUT NOCOPY JTF_NUMBER_TABLE
1520: , x_return_status OUT NOCOPY VARCHAR2
1521: , x_msg_count OUT NOCOPY NUMBER
1522: , x_msg_data OUT NOCOPY VARCHAR2
1523: , p4_a0 NUMBER := 0-1962.0724