DBA Data[Home] [Help]

APPS.AMS_WEB_TRACK_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 24: , a2 JTF_VARCHAR2_TABLE_100

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
28: , a6 JTF_DATE_TABLE

Line 34: , a12 JTF_VARCHAR2_TABLE_100

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
38: , a16 JTF_VARCHAR2_TABLE_200

Line 97: , a2 OUT NOCOPY JTF_VARCHAR2_TABLE_100

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
101: , a6 OUT NOCOPY JTF_DATE_TABLE

Line 107: , a12 OUT NOCOPY JTF_VARCHAR2_TABLE_100

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
111: , a16 OUT NOCOPY JTF_VARCHAR2_TABLE_200

Line 129: a2 := JTF_VARCHAR2_TABLE_100();

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();
133: a6 := JTF_DATE_TABLE();

Line 139: a12 := JTF_VARCHAR2_TABLE_100();

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();
143: a16 := JTF_VARCHAR2_TABLE_200();

Line 158: a2 := JTF_VARCHAR2_TABLE_100();

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();
162: a6 := JTF_DATE_TABLE();

Line 168: a12 := JTF_VARCHAR2_TABLE_100();

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();
172: a16 := JTF_VARCHAR2_TABLE_200();

Line 257: , a3 JTF_VARCHAR2_TABLE_100

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
261: , a7 JTF_DATE_TABLE

Line 260: , a6 JTF_VARCHAR2_TABLE_100

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
264: , a10 JTF_NUMBER_TABLE

Line 267: , a13 JTF_VARCHAR2_TABLE_100

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
271: , a17 JTF_VARCHAR2_TABLE_200

Line 332: , a3 OUT NOCOPY JTF_VARCHAR2_TABLE_100

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
336: , a7 OUT NOCOPY JTF_DATE_TABLE

Line 335: , a6 OUT NOCOPY JTF_VARCHAR2_TABLE_100

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
339: , a10 OUT NOCOPY JTF_NUMBER_TABLE

Line 342: , a13 OUT NOCOPY JTF_VARCHAR2_TABLE_100

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
346: , a17 OUT NOCOPY JTF_VARCHAR2_TABLE_200

Line 365: a3 := JTF_VARCHAR2_TABLE_100();

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();
369: a7 := JTF_DATE_TABLE();

Line 368: a6 := JTF_VARCHAR2_TABLE_100();

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();
372: a10 := JTF_NUMBER_TABLE();

Line 375: a13 := JTF_VARCHAR2_TABLE_100();

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();
379: a17 := JTF_VARCHAR2_TABLE_200();

Line 395: a3 := JTF_VARCHAR2_TABLE_100();

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();
399: a7 := JTF_DATE_TABLE();

Line 398: a6 := JTF_VARCHAR2_TABLE_100();

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();
402: a10 := JTF_NUMBER_TABLE();

Line 405: a13 := JTF_VARCHAR2_TABLE_100();

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();
409: a17 := JTF_VARCHAR2_TABLE_200();

Line 1492: , p5_a3 JTF_VARCHAR2_TABLE_100

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
1496: , p5_a7 JTF_DATE_TABLE

Line 1495: , p5_a6 JTF_VARCHAR2_TABLE_100

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
1499: , p5_a10 JTF_NUMBER_TABLE

Line 1502: , p5_a13 JTF_VARCHAR2_TABLE_100

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
1506: , p5_a17 JTF_VARCHAR2_TABLE_200