DBA Data[Home] [Help]

APPS.CAC_VIEW_PVT_W dependencies on JTF_VARCHAR2_TABLE_2000

Line 70: , a3 JTF_VARCHAR2_TABLE_2000

66:
67: procedure rosetta_table_copy_in_p4(t out nocopy cac_view_pvt.queryouttab, a0 JTF_NUMBER_TABLE
68: , a1 JTF_NUMBER_TABLE
69: , a2 JTF_VARCHAR2_TABLE_100
70: , a3 JTF_VARCHAR2_TABLE_2000
71: , a4 JTF_VARCHAR2_TABLE_2000
72: , a5 JTF_VARCHAR2_TABLE_100
73: , a6 JTF_NUMBER_TABLE
74: , a7 JTF_NUMBER_TABLE

Line 71: , a4 JTF_VARCHAR2_TABLE_2000

67: procedure rosetta_table_copy_in_p4(t out nocopy cac_view_pvt.queryouttab, a0 JTF_NUMBER_TABLE
68: , a1 JTF_NUMBER_TABLE
69: , a2 JTF_VARCHAR2_TABLE_100
70: , a3 JTF_VARCHAR2_TABLE_2000
71: , a4 JTF_VARCHAR2_TABLE_2000
72: , a5 JTF_VARCHAR2_TABLE_100
73: , a6 JTF_NUMBER_TABLE
74: , a7 JTF_NUMBER_TABLE
75: , a8 JTF_NUMBER_TABLE

Line 81: , a14 JTF_VARCHAR2_TABLE_2000

77: , a10 JTF_NUMBER_TABLE
78: , a11 JTF_DATE_TABLE
79: , a12 JTF_VARCHAR2_TABLE_100
80: , a13 JTF_DATE_TABLE
81: , a14 JTF_VARCHAR2_TABLE_2000
82: , a15 JTF_VARCHAR2_TABLE_2000
83: , a16 JTF_VARCHAR2_TABLE_2000
84: , a17 JTF_VARCHAR2_TABLE_4000
85: , a18 JTF_VARCHAR2_TABLE_100

Line 82: , a15 JTF_VARCHAR2_TABLE_2000

78: , a11 JTF_DATE_TABLE
79: , a12 JTF_VARCHAR2_TABLE_100
80: , a13 JTF_DATE_TABLE
81: , a14 JTF_VARCHAR2_TABLE_2000
82: , a15 JTF_VARCHAR2_TABLE_2000
83: , a16 JTF_VARCHAR2_TABLE_2000
84: , a17 JTF_VARCHAR2_TABLE_4000
85: , a18 JTF_VARCHAR2_TABLE_100
86: , a19 JTF_VARCHAR2_TABLE_100

Line 83: , a16 JTF_VARCHAR2_TABLE_2000

79: , a12 JTF_VARCHAR2_TABLE_100
80: , a13 JTF_DATE_TABLE
81: , a14 JTF_VARCHAR2_TABLE_2000
82: , a15 JTF_VARCHAR2_TABLE_2000
83: , a16 JTF_VARCHAR2_TABLE_2000
84: , a17 JTF_VARCHAR2_TABLE_4000
85: , a18 JTF_VARCHAR2_TABLE_100
86: , a19 JTF_VARCHAR2_TABLE_100
87: , a20 JTF_VARCHAR2_TABLE_100

Line 143: , a3 out nocopy JTF_VARCHAR2_TABLE_2000

139: end rosetta_table_copy_in_p4;
140: procedure rosetta_table_copy_out_p4(t cac_view_pvt.queryouttab, a0 out nocopy JTF_NUMBER_TABLE
141: , a1 out nocopy JTF_NUMBER_TABLE
142: , a2 out nocopy JTF_VARCHAR2_TABLE_100
143: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
144: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
145: , a5 out nocopy JTF_VARCHAR2_TABLE_100
146: , a6 out nocopy JTF_NUMBER_TABLE
147: , a7 out nocopy JTF_NUMBER_TABLE

Line 144: , a4 out nocopy JTF_VARCHAR2_TABLE_2000

140: procedure rosetta_table_copy_out_p4(t cac_view_pvt.queryouttab, a0 out nocopy JTF_NUMBER_TABLE
141: , a1 out nocopy JTF_NUMBER_TABLE
142: , a2 out nocopy JTF_VARCHAR2_TABLE_100
143: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
144: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
145: , a5 out nocopy JTF_VARCHAR2_TABLE_100
146: , a6 out nocopy JTF_NUMBER_TABLE
147: , a7 out nocopy JTF_NUMBER_TABLE
148: , a8 out nocopy JTF_NUMBER_TABLE

Line 154: , a14 out nocopy JTF_VARCHAR2_TABLE_2000

150: , a10 out nocopy JTF_NUMBER_TABLE
151: , a11 out nocopy JTF_DATE_TABLE
152: , a12 out nocopy JTF_VARCHAR2_TABLE_100
153: , a13 out nocopy JTF_DATE_TABLE
154: , a14 out nocopy JTF_VARCHAR2_TABLE_2000
155: , a15 out nocopy JTF_VARCHAR2_TABLE_2000
156: , a16 out nocopy JTF_VARCHAR2_TABLE_2000
157: , a17 out nocopy JTF_VARCHAR2_TABLE_4000
158: , a18 out nocopy JTF_VARCHAR2_TABLE_100

Line 155: , a15 out nocopy JTF_VARCHAR2_TABLE_2000

151: , a11 out nocopy JTF_DATE_TABLE
152: , a12 out nocopy JTF_VARCHAR2_TABLE_100
153: , a13 out nocopy JTF_DATE_TABLE
154: , a14 out nocopy JTF_VARCHAR2_TABLE_2000
155: , a15 out nocopy JTF_VARCHAR2_TABLE_2000
156: , a16 out nocopy JTF_VARCHAR2_TABLE_2000
157: , a17 out nocopy JTF_VARCHAR2_TABLE_4000
158: , a18 out nocopy JTF_VARCHAR2_TABLE_100
159: , a19 out nocopy JTF_VARCHAR2_TABLE_100

Line 156: , a16 out nocopy JTF_VARCHAR2_TABLE_2000

152: , a12 out nocopy JTF_VARCHAR2_TABLE_100
153: , a13 out nocopy JTF_DATE_TABLE
154: , a14 out nocopy JTF_VARCHAR2_TABLE_2000
155: , a15 out nocopy JTF_VARCHAR2_TABLE_2000
156: , a16 out nocopy JTF_VARCHAR2_TABLE_2000
157: , a17 out nocopy JTF_VARCHAR2_TABLE_4000
158: , a18 out nocopy JTF_VARCHAR2_TABLE_100
159: , a19 out nocopy JTF_VARCHAR2_TABLE_100
160: , a20 out nocopy JTF_VARCHAR2_TABLE_100

Line 175: a3 := JTF_VARCHAR2_TABLE_2000();

171: if t is null or t.count = 0 then
172: a0 := JTF_NUMBER_TABLE();
173: a1 := JTF_NUMBER_TABLE();
174: a2 := JTF_VARCHAR2_TABLE_100();
175: a3 := JTF_VARCHAR2_TABLE_2000();
176: a4 := JTF_VARCHAR2_TABLE_2000();
177: a5 := JTF_VARCHAR2_TABLE_100();
178: a6 := JTF_NUMBER_TABLE();
179: a7 := JTF_NUMBER_TABLE();

Line 176: a4 := JTF_VARCHAR2_TABLE_2000();

172: a0 := JTF_NUMBER_TABLE();
173: a1 := JTF_NUMBER_TABLE();
174: a2 := JTF_VARCHAR2_TABLE_100();
175: a3 := JTF_VARCHAR2_TABLE_2000();
176: a4 := JTF_VARCHAR2_TABLE_2000();
177: a5 := JTF_VARCHAR2_TABLE_100();
178: a6 := JTF_NUMBER_TABLE();
179: a7 := JTF_NUMBER_TABLE();
180: a8 := JTF_NUMBER_TABLE();

Line 186: a14 := JTF_VARCHAR2_TABLE_2000();

182: a10 := JTF_NUMBER_TABLE();
183: a11 := JTF_DATE_TABLE();
184: a12 := JTF_VARCHAR2_TABLE_100();
185: a13 := JTF_DATE_TABLE();
186: a14 := JTF_VARCHAR2_TABLE_2000();
187: a15 := JTF_VARCHAR2_TABLE_2000();
188: a16 := JTF_VARCHAR2_TABLE_2000();
189: a17 := JTF_VARCHAR2_TABLE_4000();
190: a18 := JTF_VARCHAR2_TABLE_100();

Line 187: a15 := JTF_VARCHAR2_TABLE_2000();

183: a11 := JTF_DATE_TABLE();
184: a12 := JTF_VARCHAR2_TABLE_100();
185: a13 := JTF_DATE_TABLE();
186: a14 := JTF_VARCHAR2_TABLE_2000();
187: a15 := JTF_VARCHAR2_TABLE_2000();
188: a16 := JTF_VARCHAR2_TABLE_2000();
189: a17 := JTF_VARCHAR2_TABLE_4000();
190: a18 := JTF_VARCHAR2_TABLE_100();
191: a19 := JTF_VARCHAR2_TABLE_100();

Line 188: a16 := JTF_VARCHAR2_TABLE_2000();

184: a12 := JTF_VARCHAR2_TABLE_100();
185: a13 := JTF_DATE_TABLE();
186: a14 := JTF_VARCHAR2_TABLE_2000();
187: a15 := JTF_VARCHAR2_TABLE_2000();
188: a16 := JTF_VARCHAR2_TABLE_2000();
189: a17 := JTF_VARCHAR2_TABLE_4000();
190: a18 := JTF_VARCHAR2_TABLE_100();
191: a19 := JTF_VARCHAR2_TABLE_100();
192: a20 := JTF_VARCHAR2_TABLE_100();

Line 204: a3 := JTF_VARCHAR2_TABLE_2000();

200: else
201: a0 := JTF_NUMBER_TABLE();
202: a1 := JTF_NUMBER_TABLE();
203: a2 := JTF_VARCHAR2_TABLE_100();
204: a3 := JTF_VARCHAR2_TABLE_2000();
205: a4 := JTF_VARCHAR2_TABLE_2000();
206: a5 := JTF_VARCHAR2_TABLE_100();
207: a6 := JTF_NUMBER_TABLE();
208: a7 := JTF_NUMBER_TABLE();

Line 205: a4 := JTF_VARCHAR2_TABLE_2000();

201: a0 := JTF_NUMBER_TABLE();
202: a1 := JTF_NUMBER_TABLE();
203: a2 := JTF_VARCHAR2_TABLE_100();
204: a3 := JTF_VARCHAR2_TABLE_2000();
205: a4 := JTF_VARCHAR2_TABLE_2000();
206: a5 := JTF_VARCHAR2_TABLE_100();
207: a6 := JTF_NUMBER_TABLE();
208: a7 := JTF_NUMBER_TABLE();
209: a8 := JTF_NUMBER_TABLE();

Line 215: a14 := JTF_VARCHAR2_TABLE_2000();

211: a10 := JTF_NUMBER_TABLE();
212: a11 := JTF_DATE_TABLE();
213: a12 := JTF_VARCHAR2_TABLE_100();
214: a13 := JTF_DATE_TABLE();
215: a14 := JTF_VARCHAR2_TABLE_2000();
216: a15 := JTF_VARCHAR2_TABLE_2000();
217: a16 := JTF_VARCHAR2_TABLE_2000();
218: a17 := JTF_VARCHAR2_TABLE_4000();
219: a18 := JTF_VARCHAR2_TABLE_100();

Line 216: a15 := JTF_VARCHAR2_TABLE_2000();

212: a11 := JTF_DATE_TABLE();
213: a12 := JTF_VARCHAR2_TABLE_100();
214: a13 := JTF_DATE_TABLE();
215: a14 := JTF_VARCHAR2_TABLE_2000();
216: a15 := JTF_VARCHAR2_TABLE_2000();
217: a16 := JTF_VARCHAR2_TABLE_2000();
218: a17 := JTF_VARCHAR2_TABLE_4000();
219: a18 := JTF_VARCHAR2_TABLE_100();
220: a19 := JTF_VARCHAR2_TABLE_100();

Line 217: a16 := JTF_VARCHAR2_TABLE_2000();

213: a12 := JTF_VARCHAR2_TABLE_100();
214: a13 := JTF_DATE_TABLE();
215: a14 := JTF_VARCHAR2_TABLE_2000();
216: a15 := JTF_VARCHAR2_TABLE_2000();
217: a16 := JTF_VARCHAR2_TABLE_2000();
218: a17 := JTF_VARCHAR2_TABLE_4000();
219: a18 := JTF_VARCHAR2_TABLE_100();
220: a19 := JTF_VARCHAR2_TABLE_100();
221: a20 := JTF_VARCHAR2_TABLE_100();

Line 402: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_2000

398: , p6_a33 NUMBER
399: , p7_a0 out nocopy JTF_NUMBER_TABLE
400: , p7_a1 out nocopy JTF_NUMBER_TABLE
401: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
402: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_2000
403: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_2000
404: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
405: , p7_a6 out nocopy JTF_NUMBER_TABLE
406: , p7_a7 out nocopy JTF_NUMBER_TABLE

Line 403: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_2000

399: , p7_a0 out nocopy JTF_NUMBER_TABLE
400: , p7_a1 out nocopy JTF_NUMBER_TABLE
401: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
402: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_2000
403: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_2000
404: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
405: , p7_a6 out nocopy JTF_NUMBER_TABLE
406: , p7_a7 out nocopy JTF_NUMBER_TABLE
407: , p7_a8 out nocopy JTF_NUMBER_TABLE

Line 413: , p7_a14 out nocopy JTF_VARCHAR2_TABLE_2000

409: , p7_a10 out nocopy JTF_NUMBER_TABLE
410: , p7_a11 out nocopy JTF_DATE_TABLE
411: , p7_a12 out nocopy JTF_VARCHAR2_TABLE_100
412: , p7_a13 out nocopy JTF_DATE_TABLE
413: , p7_a14 out nocopy JTF_VARCHAR2_TABLE_2000
414: , p7_a15 out nocopy JTF_VARCHAR2_TABLE_2000
415: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_2000
416: , p7_a17 out nocopy JTF_VARCHAR2_TABLE_4000
417: , p7_a18 out nocopy JTF_VARCHAR2_TABLE_100

Line 414: , p7_a15 out nocopy JTF_VARCHAR2_TABLE_2000

410: , p7_a11 out nocopy JTF_DATE_TABLE
411: , p7_a12 out nocopy JTF_VARCHAR2_TABLE_100
412: , p7_a13 out nocopy JTF_DATE_TABLE
413: , p7_a14 out nocopy JTF_VARCHAR2_TABLE_2000
414: , p7_a15 out nocopy JTF_VARCHAR2_TABLE_2000
415: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_2000
416: , p7_a17 out nocopy JTF_VARCHAR2_TABLE_4000
417: , p7_a18 out nocopy JTF_VARCHAR2_TABLE_100
418: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_100

Line 415: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_2000

411: , p7_a12 out nocopy JTF_VARCHAR2_TABLE_100
412: , p7_a13 out nocopy JTF_DATE_TABLE
413: , p7_a14 out nocopy JTF_VARCHAR2_TABLE_2000
414: , p7_a15 out nocopy JTF_VARCHAR2_TABLE_2000
415: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_2000
416: , p7_a17 out nocopy JTF_VARCHAR2_TABLE_4000
417: , p7_a18 out nocopy JTF_VARCHAR2_TABLE_100
418: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_100
419: , p7_a20 out nocopy JTF_VARCHAR2_TABLE_100