DBA Data[Home] [Help]

APPS.JTF_ATTACHMENT_GRP_W dependencies on JTF_VARCHAR2_TABLE_100

Line 26: , a4 JTF_VARCHAR2_TABLE_100

22: procedure rosetta_table_copy_in_p1(t out jtf_attachment_grp.attachment_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_300
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_VARCHAR2_TABLE_100
29: , a7 JTF_VARCHAR2_TABLE_100
30: , a8 JTF_NUMBER_TABLE

Line 27: , a5 JTF_VARCHAR2_TABLE_100

23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_300
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_VARCHAR2_TABLE_100
29: , a7 JTF_VARCHAR2_TABLE_100
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_VARCHAR2_TABLE_100

Line 28: , a6 JTF_VARCHAR2_TABLE_100

24: , a2 JTF_VARCHAR2_TABLE_300
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_VARCHAR2_TABLE_100
29: , a7 JTF_VARCHAR2_TABLE_100
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_VARCHAR2_TABLE_100
32: , a10 JTF_VARCHAR2_TABLE_300

Line 29: , a7 JTF_VARCHAR2_TABLE_100

25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_VARCHAR2_TABLE_100
29: , a7 JTF_VARCHAR2_TABLE_100
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_VARCHAR2_TABLE_100
32: , a10 JTF_VARCHAR2_TABLE_300
33: , a11 JTF_NUMBER_TABLE

Line 31: , a9 JTF_VARCHAR2_TABLE_100

27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_VARCHAR2_TABLE_100
29: , a7 JTF_VARCHAR2_TABLE_100
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_VARCHAR2_TABLE_100
32: , a10 JTF_VARCHAR2_TABLE_300
33: , a11 JTF_NUMBER_TABLE
34: , a12 JTF_NUMBER_TABLE
35: , a13 JTF_VARCHAR2_TABLE_2000

Line 38: , a16 JTF_VARCHAR2_TABLE_100

34: , a12 JTF_NUMBER_TABLE
35: , a13 JTF_VARCHAR2_TABLE_2000
36: , a14 JTF_VARCHAR2_TABLE_2000
37: , a15 JTF_VARCHAR2_TABLE_2000
38: , a16 JTF_VARCHAR2_TABLE_100
39: , a17 JTF_VARCHAR2_TABLE_100
40: , a18 JTF_VARCHAR2_TABLE_100
41: , a19 JTF_NUMBER_TABLE
42: , a20 JTF_VARCHAR2_TABLE_2000

Line 39: , a17 JTF_VARCHAR2_TABLE_100

35: , a13 JTF_VARCHAR2_TABLE_2000
36: , a14 JTF_VARCHAR2_TABLE_2000
37: , a15 JTF_VARCHAR2_TABLE_2000
38: , a16 JTF_VARCHAR2_TABLE_100
39: , a17 JTF_VARCHAR2_TABLE_100
40: , a18 JTF_VARCHAR2_TABLE_100
41: , a19 JTF_NUMBER_TABLE
42: , a20 JTF_VARCHAR2_TABLE_2000
43: , a21 JTF_VARCHAR2_TABLE_300

Line 40: , a18 JTF_VARCHAR2_TABLE_100

36: , a14 JTF_VARCHAR2_TABLE_2000
37: , a15 JTF_VARCHAR2_TABLE_2000
38: , a16 JTF_VARCHAR2_TABLE_100
39: , a17 JTF_VARCHAR2_TABLE_100
40: , a18 JTF_VARCHAR2_TABLE_100
41: , a19 JTF_NUMBER_TABLE
42: , a20 JTF_VARCHAR2_TABLE_2000
43: , a21 JTF_VARCHAR2_TABLE_300
44: , a22 JTF_VARCHAR2_TABLE_1100

Line 47: , a25 JTF_VARCHAR2_TABLE_100

43: , a21 JTF_VARCHAR2_TABLE_300
44: , a22 JTF_VARCHAR2_TABLE_1100
45: , a23 JTF_NUMBER_TABLE
46: , a24 JTF_VARCHAR2_TABLE_300
47: , a25 JTF_VARCHAR2_TABLE_100
48: , a26 JTF_VARCHAR2_TABLE_200
49: , a27 JTF_VARCHAR2_TABLE_200
50: , a28 JTF_VARCHAR2_TABLE_200
51: , a29 JTF_VARCHAR2_TABLE_200

Line 64: , a42 JTF_VARCHAR2_TABLE_1000

60: , a38 JTF_VARCHAR2_TABLE_200
61: , a39 JTF_VARCHAR2_TABLE_200
62: , a40 JTF_VARCHAR2_TABLE_200
63: , a41 JTF_VARCHAR2_TABLE_2000
64: , a42 JTF_VARCHAR2_TABLE_1000
65: , a43 JTF_VARCHAR2_TABLE_100
66: ) as
67: ddindx binary_integer; indx binary_integer;
68: begin

Line 65: , a43 JTF_VARCHAR2_TABLE_100

61: , a39 JTF_VARCHAR2_TABLE_200
62: , a40 JTF_VARCHAR2_TABLE_200
63: , a41 JTF_VARCHAR2_TABLE_2000
64: , a42 JTF_VARCHAR2_TABLE_1000
65: , a43 JTF_VARCHAR2_TABLE_100
66: ) as
67: ddindx binary_integer; indx binary_integer;
68: begin
69: if a0 is not null and a0.count > 0 then

Line 131: , a4 out JTF_VARCHAR2_TABLE_100

127: procedure rosetta_table_copy_out_p1(t jtf_attachment_grp.attachment_tbl_type, a0 out JTF_NUMBER_TABLE
128: , a1 out JTF_NUMBER_TABLE
129: , a2 out JTF_VARCHAR2_TABLE_300
130: , a3 out JTF_NUMBER_TABLE
131: , a4 out JTF_VARCHAR2_TABLE_100
132: , a5 out JTF_VARCHAR2_TABLE_100
133: , a6 out JTF_VARCHAR2_TABLE_100
134: , a7 out JTF_VARCHAR2_TABLE_100
135: , a8 out JTF_NUMBER_TABLE

Line 132: , a5 out JTF_VARCHAR2_TABLE_100

128: , a1 out JTF_NUMBER_TABLE
129: , a2 out JTF_VARCHAR2_TABLE_300
130: , a3 out JTF_NUMBER_TABLE
131: , a4 out JTF_VARCHAR2_TABLE_100
132: , a5 out JTF_VARCHAR2_TABLE_100
133: , a6 out JTF_VARCHAR2_TABLE_100
134: , a7 out JTF_VARCHAR2_TABLE_100
135: , a8 out JTF_NUMBER_TABLE
136: , a9 out JTF_VARCHAR2_TABLE_100

Line 133: , a6 out JTF_VARCHAR2_TABLE_100

129: , a2 out JTF_VARCHAR2_TABLE_300
130: , a3 out JTF_NUMBER_TABLE
131: , a4 out JTF_VARCHAR2_TABLE_100
132: , a5 out JTF_VARCHAR2_TABLE_100
133: , a6 out JTF_VARCHAR2_TABLE_100
134: , a7 out JTF_VARCHAR2_TABLE_100
135: , a8 out JTF_NUMBER_TABLE
136: , a9 out JTF_VARCHAR2_TABLE_100
137: , a10 out JTF_VARCHAR2_TABLE_300

Line 134: , a7 out JTF_VARCHAR2_TABLE_100

130: , a3 out JTF_NUMBER_TABLE
131: , a4 out JTF_VARCHAR2_TABLE_100
132: , a5 out JTF_VARCHAR2_TABLE_100
133: , a6 out JTF_VARCHAR2_TABLE_100
134: , a7 out JTF_VARCHAR2_TABLE_100
135: , a8 out JTF_NUMBER_TABLE
136: , a9 out JTF_VARCHAR2_TABLE_100
137: , a10 out JTF_VARCHAR2_TABLE_300
138: , a11 out JTF_NUMBER_TABLE

Line 136: , a9 out JTF_VARCHAR2_TABLE_100

132: , a5 out JTF_VARCHAR2_TABLE_100
133: , a6 out JTF_VARCHAR2_TABLE_100
134: , a7 out JTF_VARCHAR2_TABLE_100
135: , a8 out JTF_NUMBER_TABLE
136: , a9 out JTF_VARCHAR2_TABLE_100
137: , a10 out JTF_VARCHAR2_TABLE_300
138: , a11 out JTF_NUMBER_TABLE
139: , a12 out JTF_NUMBER_TABLE
140: , a13 out JTF_VARCHAR2_TABLE_2000

Line 143: , a16 out JTF_VARCHAR2_TABLE_100

139: , a12 out JTF_NUMBER_TABLE
140: , a13 out JTF_VARCHAR2_TABLE_2000
141: , a14 out JTF_VARCHAR2_TABLE_2000
142: , a15 out JTF_VARCHAR2_TABLE_2000
143: , a16 out JTF_VARCHAR2_TABLE_100
144: , a17 out JTF_VARCHAR2_TABLE_100
145: , a18 out JTF_VARCHAR2_TABLE_100
146: , a19 out JTF_NUMBER_TABLE
147: , a20 out JTF_VARCHAR2_TABLE_2000

Line 144: , a17 out JTF_VARCHAR2_TABLE_100

140: , a13 out JTF_VARCHAR2_TABLE_2000
141: , a14 out JTF_VARCHAR2_TABLE_2000
142: , a15 out JTF_VARCHAR2_TABLE_2000
143: , a16 out JTF_VARCHAR2_TABLE_100
144: , a17 out JTF_VARCHAR2_TABLE_100
145: , a18 out JTF_VARCHAR2_TABLE_100
146: , a19 out JTF_NUMBER_TABLE
147: , a20 out JTF_VARCHAR2_TABLE_2000
148: , a21 out JTF_VARCHAR2_TABLE_300

Line 145: , a18 out JTF_VARCHAR2_TABLE_100

141: , a14 out JTF_VARCHAR2_TABLE_2000
142: , a15 out JTF_VARCHAR2_TABLE_2000
143: , a16 out JTF_VARCHAR2_TABLE_100
144: , a17 out JTF_VARCHAR2_TABLE_100
145: , a18 out JTF_VARCHAR2_TABLE_100
146: , a19 out JTF_NUMBER_TABLE
147: , a20 out JTF_VARCHAR2_TABLE_2000
148: , a21 out JTF_VARCHAR2_TABLE_300
149: , a22 out JTF_VARCHAR2_TABLE_1100

Line 152: , a25 out JTF_VARCHAR2_TABLE_100

148: , a21 out JTF_VARCHAR2_TABLE_300
149: , a22 out JTF_VARCHAR2_TABLE_1100
150: , a23 out JTF_NUMBER_TABLE
151: , a24 out JTF_VARCHAR2_TABLE_300
152: , a25 out JTF_VARCHAR2_TABLE_100
153: , a26 out JTF_VARCHAR2_TABLE_200
154: , a27 out JTF_VARCHAR2_TABLE_200
155: , a28 out JTF_VARCHAR2_TABLE_200
156: , a29 out JTF_VARCHAR2_TABLE_200

Line 169: , a42 out JTF_VARCHAR2_TABLE_1000

165: , a38 out JTF_VARCHAR2_TABLE_200
166: , a39 out JTF_VARCHAR2_TABLE_200
167: , a40 out JTF_VARCHAR2_TABLE_200
168: , a41 out JTF_VARCHAR2_TABLE_2000
169: , a42 out JTF_VARCHAR2_TABLE_1000
170: , a43 out JTF_VARCHAR2_TABLE_100
171: ) as
172: ddindx binary_integer; indx binary_integer;
173: begin

Line 170: , a43 out JTF_VARCHAR2_TABLE_100

166: , a39 out JTF_VARCHAR2_TABLE_200
167: , a40 out JTF_VARCHAR2_TABLE_200
168: , a41 out JTF_VARCHAR2_TABLE_2000
169: , a42 out JTF_VARCHAR2_TABLE_1000
170: , a43 out JTF_VARCHAR2_TABLE_100
171: ) as
172: ddindx binary_integer; indx binary_integer;
173: begin
174: if t is null or t.count = 0 then

Line 179: a4 := JTF_VARCHAR2_TABLE_100();

175: a0 := JTF_NUMBER_TABLE();
176: a1 := JTF_NUMBER_TABLE();
177: a2 := JTF_VARCHAR2_TABLE_300();
178: a3 := JTF_NUMBER_TABLE();
179: a4 := JTF_VARCHAR2_TABLE_100();
180: a5 := JTF_VARCHAR2_TABLE_100();
181: a6 := JTF_VARCHAR2_TABLE_100();
182: a7 := JTF_VARCHAR2_TABLE_100();
183: a8 := JTF_NUMBER_TABLE();

Line 180: a5 := JTF_VARCHAR2_TABLE_100();

176: a1 := JTF_NUMBER_TABLE();
177: a2 := JTF_VARCHAR2_TABLE_300();
178: a3 := JTF_NUMBER_TABLE();
179: a4 := JTF_VARCHAR2_TABLE_100();
180: a5 := JTF_VARCHAR2_TABLE_100();
181: a6 := JTF_VARCHAR2_TABLE_100();
182: a7 := JTF_VARCHAR2_TABLE_100();
183: a8 := JTF_NUMBER_TABLE();
184: a9 := JTF_VARCHAR2_TABLE_100();

Line 181: a6 := JTF_VARCHAR2_TABLE_100();

177: a2 := JTF_VARCHAR2_TABLE_300();
178: a3 := JTF_NUMBER_TABLE();
179: a4 := JTF_VARCHAR2_TABLE_100();
180: a5 := JTF_VARCHAR2_TABLE_100();
181: a6 := JTF_VARCHAR2_TABLE_100();
182: a7 := JTF_VARCHAR2_TABLE_100();
183: a8 := JTF_NUMBER_TABLE();
184: a9 := JTF_VARCHAR2_TABLE_100();
185: a10 := JTF_VARCHAR2_TABLE_300();

Line 182: a7 := JTF_VARCHAR2_TABLE_100();

178: a3 := JTF_NUMBER_TABLE();
179: a4 := JTF_VARCHAR2_TABLE_100();
180: a5 := JTF_VARCHAR2_TABLE_100();
181: a6 := JTF_VARCHAR2_TABLE_100();
182: a7 := JTF_VARCHAR2_TABLE_100();
183: a8 := JTF_NUMBER_TABLE();
184: a9 := JTF_VARCHAR2_TABLE_100();
185: a10 := JTF_VARCHAR2_TABLE_300();
186: a11 := JTF_NUMBER_TABLE();

Line 184: a9 := JTF_VARCHAR2_TABLE_100();

180: a5 := JTF_VARCHAR2_TABLE_100();
181: a6 := JTF_VARCHAR2_TABLE_100();
182: a7 := JTF_VARCHAR2_TABLE_100();
183: a8 := JTF_NUMBER_TABLE();
184: a9 := JTF_VARCHAR2_TABLE_100();
185: a10 := JTF_VARCHAR2_TABLE_300();
186: a11 := JTF_NUMBER_TABLE();
187: a12 := JTF_NUMBER_TABLE();
188: a13 := JTF_VARCHAR2_TABLE_2000();

Line 191: a16 := JTF_VARCHAR2_TABLE_100();

187: a12 := JTF_NUMBER_TABLE();
188: a13 := JTF_VARCHAR2_TABLE_2000();
189: a14 := JTF_VARCHAR2_TABLE_2000();
190: a15 := JTF_VARCHAR2_TABLE_2000();
191: a16 := JTF_VARCHAR2_TABLE_100();
192: a17 := JTF_VARCHAR2_TABLE_100();
193: a18 := JTF_VARCHAR2_TABLE_100();
194: a19 := JTF_NUMBER_TABLE();
195: a20 := JTF_VARCHAR2_TABLE_2000();

Line 192: a17 := JTF_VARCHAR2_TABLE_100();

188: a13 := JTF_VARCHAR2_TABLE_2000();
189: a14 := JTF_VARCHAR2_TABLE_2000();
190: a15 := JTF_VARCHAR2_TABLE_2000();
191: a16 := JTF_VARCHAR2_TABLE_100();
192: a17 := JTF_VARCHAR2_TABLE_100();
193: a18 := JTF_VARCHAR2_TABLE_100();
194: a19 := JTF_NUMBER_TABLE();
195: a20 := JTF_VARCHAR2_TABLE_2000();
196: a21 := JTF_VARCHAR2_TABLE_300();

Line 193: a18 := JTF_VARCHAR2_TABLE_100();

189: a14 := JTF_VARCHAR2_TABLE_2000();
190: a15 := JTF_VARCHAR2_TABLE_2000();
191: a16 := JTF_VARCHAR2_TABLE_100();
192: a17 := JTF_VARCHAR2_TABLE_100();
193: a18 := JTF_VARCHAR2_TABLE_100();
194: a19 := JTF_NUMBER_TABLE();
195: a20 := JTF_VARCHAR2_TABLE_2000();
196: a21 := JTF_VARCHAR2_TABLE_300();
197: a22 := JTF_VARCHAR2_TABLE_1100();

Line 200: a25 := JTF_VARCHAR2_TABLE_100();

196: a21 := JTF_VARCHAR2_TABLE_300();
197: a22 := JTF_VARCHAR2_TABLE_1100();
198: a23 := JTF_NUMBER_TABLE();
199: a24 := JTF_VARCHAR2_TABLE_300();
200: a25 := JTF_VARCHAR2_TABLE_100();
201: a26 := JTF_VARCHAR2_TABLE_200();
202: a27 := JTF_VARCHAR2_TABLE_200();
203: a28 := JTF_VARCHAR2_TABLE_200();
204: a29 := JTF_VARCHAR2_TABLE_200();

Line 217: a42 := JTF_VARCHAR2_TABLE_1000();

213: a38 := JTF_VARCHAR2_TABLE_200();
214: a39 := JTF_VARCHAR2_TABLE_200();
215: a40 := JTF_VARCHAR2_TABLE_200();
216: a41 := JTF_VARCHAR2_TABLE_2000();
217: a42 := JTF_VARCHAR2_TABLE_1000();
218: a43 := JTF_VARCHAR2_TABLE_100();
219: else
220: a0 := JTF_NUMBER_TABLE();
221: a1 := JTF_NUMBER_TABLE();

Line 218: a43 := JTF_VARCHAR2_TABLE_100();

214: a39 := JTF_VARCHAR2_TABLE_200();
215: a40 := JTF_VARCHAR2_TABLE_200();
216: a41 := JTF_VARCHAR2_TABLE_2000();
217: a42 := JTF_VARCHAR2_TABLE_1000();
218: a43 := JTF_VARCHAR2_TABLE_100();
219: else
220: a0 := JTF_NUMBER_TABLE();
221: a1 := JTF_NUMBER_TABLE();
222: a2 := JTF_VARCHAR2_TABLE_300();

Line 224: a4 := JTF_VARCHAR2_TABLE_100();

220: a0 := JTF_NUMBER_TABLE();
221: a1 := JTF_NUMBER_TABLE();
222: a2 := JTF_VARCHAR2_TABLE_300();
223: a3 := JTF_NUMBER_TABLE();
224: a4 := JTF_VARCHAR2_TABLE_100();
225: a5 := JTF_VARCHAR2_TABLE_100();
226: a6 := JTF_VARCHAR2_TABLE_100();
227: a7 := JTF_VARCHAR2_TABLE_100();
228: a8 := JTF_NUMBER_TABLE();

Line 225: a5 := JTF_VARCHAR2_TABLE_100();

221: a1 := JTF_NUMBER_TABLE();
222: a2 := JTF_VARCHAR2_TABLE_300();
223: a3 := JTF_NUMBER_TABLE();
224: a4 := JTF_VARCHAR2_TABLE_100();
225: a5 := JTF_VARCHAR2_TABLE_100();
226: a6 := JTF_VARCHAR2_TABLE_100();
227: a7 := JTF_VARCHAR2_TABLE_100();
228: a8 := JTF_NUMBER_TABLE();
229: a9 := JTF_VARCHAR2_TABLE_100();

Line 226: a6 := JTF_VARCHAR2_TABLE_100();

222: a2 := JTF_VARCHAR2_TABLE_300();
223: a3 := JTF_NUMBER_TABLE();
224: a4 := JTF_VARCHAR2_TABLE_100();
225: a5 := JTF_VARCHAR2_TABLE_100();
226: a6 := JTF_VARCHAR2_TABLE_100();
227: a7 := JTF_VARCHAR2_TABLE_100();
228: a8 := JTF_NUMBER_TABLE();
229: a9 := JTF_VARCHAR2_TABLE_100();
230: a10 := JTF_VARCHAR2_TABLE_300();

Line 227: a7 := JTF_VARCHAR2_TABLE_100();

223: a3 := JTF_NUMBER_TABLE();
224: a4 := JTF_VARCHAR2_TABLE_100();
225: a5 := JTF_VARCHAR2_TABLE_100();
226: a6 := JTF_VARCHAR2_TABLE_100();
227: a7 := JTF_VARCHAR2_TABLE_100();
228: a8 := JTF_NUMBER_TABLE();
229: a9 := JTF_VARCHAR2_TABLE_100();
230: a10 := JTF_VARCHAR2_TABLE_300();
231: a11 := JTF_NUMBER_TABLE();

Line 229: a9 := JTF_VARCHAR2_TABLE_100();

225: a5 := JTF_VARCHAR2_TABLE_100();
226: a6 := JTF_VARCHAR2_TABLE_100();
227: a7 := JTF_VARCHAR2_TABLE_100();
228: a8 := JTF_NUMBER_TABLE();
229: a9 := JTF_VARCHAR2_TABLE_100();
230: a10 := JTF_VARCHAR2_TABLE_300();
231: a11 := JTF_NUMBER_TABLE();
232: a12 := JTF_NUMBER_TABLE();
233: a13 := JTF_VARCHAR2_TABLE_2000();

Line 236: a16 := JTF_VARCHAR2_TABLE_100();

232: a12 := JTF_NUMBER_TABLE();
233: a13 := JTF_VARCHAR2_TABLE_2000();
234: a14 := JTF_VARCHAR2_TABLE_2000();
235: a15 := JTF_VARCHAR2_TABLE_2000();
236: a16 := JTF_VARCHAR2_TABLE_100();
237: a17 := JTF_VARCHAR2_TABLE_100();
238: a18 := JTF_VARCHAR2_TABLE_100();
239: a19 := JTF_NUMBER_TABLE();
240: a20 := JTF_VARCHAR2_TABLE_2000();

Line 237: a17 := JTF_VARCHAR2_TABLE_100();

233: a13 := JTF_VARCHAR2_TABLE_2000();
234: a14 := JTF_VARCHAR2_TABLE_2000();
235: a15 := JTF_VARCHAR2_TABLE_2000();
236: a16 := JTF_VARCHAR2_TABLE_100();
237: a17 := JTF_VARCHAR2_TABLE_100();
238: a18 := JTF_VARCHAR2_TABLE_100();
239: a19 := JTF_NUMBER_TABLE();
240: a20 := JTF_VARCHAR2_TABLE_2000();
241: a21 := JTF_VARCHAR2_TABLE_300();

Line 238: a18 := JTF_VARCHAR2_TABLE_100();

234: a14 := JTF_VARCHAR2_TABLE_2000();
235: a15 := JTF_VARCHAR2_TABLE_2000();
236: a16 := JTF_VARCHAR2_TABLE_100();
237: a17 := JTF_VARCHAR2_TABLE_100();
238: a18 := JTF_VARCHAR2_TABLE_100();
239: a19 := JTF_NUMBER_TABLE();
240: a20 := JTF_VARCHAR2_TABLE_2000();
241: a21 := JTF_VARCHAR2_TABLE_300();
242: a22 := JTF_VARCHAR2_TABLE_1100();

Line 245: a25 := JTF_VARCHAR2_TABLE_100();

241: a21 := JTF_VARCHAR2_TABLE_300();
242: a22 := JTF_VARCHAR2_TABLE_1100();
243: a23 := JTF_NUMBER_TABLE();
244: a24 := JTF_VARCHAR2_TABLE_300();
245: a25 := JTF_VARCHAR2_TABLE_100();
246: a26 := JTF_VARCHAR2_TABLE_200();
247: a27 := JTF_VARCHAR2_TABLE_200();
248: a28 := JTF_VARCHAR2_TABLE_200();
249: a29 := JTF_VARCHAR2_TABLE_200();

Line 262: a42 := JTF_VARCHAR2_TABLE_1000();

258: a38 := JTF_VARCHAR2_TABLE_200();
259: a39 := JTF_VARCHAR2_TABLE_200();
260: a40 := JTF_VARCHAR2_TABLE_200();
261: a41 := JTF_VARCHAR2_TABLE_2000();
262: a42 := JTF_VARCHAR2_TABLE_1000();
263: a43 := JTF_VARCHAR2_TABLE_100();
264: if t.count > 0 then
265: a0.extend(t.count);
266: a1.extend(t.count);

Line 263: a43 := JTF_VARCHAR2_TABLE_100();

259: a39 := JTF_VARCHAR2_TABLE_200();
260: a40 := JTF_VARCHAR2_TABLE_200();
261: a41 := JTF_VARCHAR2_TABLE_2000();
262: a42 := JTF_VARCHAR2_TABLE_1000();
263: a43 := JTF_VARCHAR2_TABLE_100();
264: if t.count > 0 then
265: a0.extend(t.count);
266: a1.extend(t.count);
267: a2.extend(t.count);

Line 369: , a3 JTF_VARCHAR2_TABLE_100

365:
366: procedure rosetta_table_copy_in_p3(t out jtf_attachment_grp.ath_id_ver_tbl_type, a0 JTF_NUMBER_TABLE
367: , a1 JTF_VARCHAR2_TABLE_300
368: , a2 JTF_NUMBER_TABLE
369: , a3 JTF_VARCHAR2_TABLE_100
370: ) as
371: ddindx binary_integer; indx binary_integer;
372: begin
373: if a0 is not null and a0.count > 0 then

Line 394: , a3 out JTF_VARCHAR2_TABLE_100

390: end rosetta_table_copy_in_p3;
391: procedure rosetta_table_copy_out_p3(t jtf_attachment_grp.ath_id_ver_tbl_type, a0 out JTF_NUMBER_TABLE
392: , a1 out JTF_VARCHAR2_TABLE_300
393: , a2 out JTF_NUMBER_TABLE
394: , a3 out JTF_VARCHAR2_TABLE_100
395: ) as
396: ddindx binary_integer; indx binary_integer;
397: begin
398: if t is null or t.count = 0 then

Line 402: a3 := JTF_VARCHAR2_TABLE_100();

398: if t is null or t.count = 0 then
399: a0 := JTF_NUMBER_TABLE();
400: a1 := JTF_VARCHAR2_TABLE_300();
401: a2 := JTF_NUMBER_TABLE();
402: a3 := JTF_VARCHAR2_TABLE_100();
403: else
404: a0 := JTF_NUMBER_TABLE();
405: a1 := JTF_VARCHAR2_TABLE_300();
406: a2 := JTF_NUMBER_TABLE();

Line 407: a3 := JTF_VARCHAR2_TABLE_100();

403: else
404: a0 := JTF_NUMBER_TABLE();
405: a1 := JTF_VARCHAR2_TABLE_300();
406: a2 := JTF_NUMBER_TABLE();
407: a3 := JTF_VARCHAR2_TABLE_100();
408: if t.count > 0 then
409: a0.extend(t.count);
410: a1.extend(t.count);
411: a2.extend(t.count);

Line 528: procedure rosetta_table_copy_in_p6(t out jtf_attachment_grp.varchar2_table_20, a0 JTF_VARCHAR2_TABLE_100) as

524: end if;
525: end if;
526: end rosetta_table_copy_out_p5;
527:
528: procedure rosetta_table_copy_in_p6(t out jtf_attachment_grp.varchar2_table_20, a0 JTF_VARCHAR2_TABLE_100) as
529: ddindx binary_integer; indx binary_integer;
530: begin
531: if a0 is null then
532: t := null;

Line 552: procedure rosetta_table_copy_out_p6(t jtf_attachment_grp.varchar2_table_20, a0 out JTF_VARCHAR2_TABLE_100) as

548: end loop;
549: end if;
550: end if;
551: end rosetta_table_copy_in_p6;
552: procedure rosetta_table_copy_out_p6(t jtf_attachment_grp.varchar2_table_20, a0 out JTF_VARCHAR2_TABLE_100) as
553: ddindx binary_integer; indx binary_integer;
554: begin
555: if t is null then
556: a0 := null;

Line 558: a0 := JTF_VARCHAR2_TABLE_100();

554: begin
555: if t is null then
556: a0 := null;
557: elsif t.count = 0 then
558: a0 := JTF_VARCHAR2_TABLE_100();
559: else
560: a0 := JTF_VARCHAR2_TABLE_100();
561: if t.count > 0 then
562: a0.extend(t.count);

Line 560: a0 := JTF_VARCHAR2_TABLE_100();

556: a0 := null;
557: elsif t.count = 0 then
558: a0 := JTF_VARCHAR2_TABLE_100();
559: else
560: a0 := JTF_VARCHAR2_TABLE_100();
561: if t.count > 0 then
562: a0.extend(t.count);
563: ddindx := t.first;
564: indx := 1;

Line 591: , x_file_ext_tbl out JTF_VARCHAR2_TABLE_100

587: , x_ath_id_tbl out JTF_NUMBER_TABLE
588: , x_dlv_id_tbl out JTF_NUMBER_TABLE
589: , x_file_name_tbl out JTF_VARCHAR2_TABLE_300
590: , x_file_id_tbl out JTF_NUMBER_TABLE
591: , x_file_ext_tbl out JTF_VARCHAR2_TABLE_100
592: , x_dsp_width_tbl out JTF_NUMBER_TABLE
593: , x_dsp_height_tbl out JTF_NUMBER_TABLE
594: , x_version_tbl out JTF_NUMBER_TABLE
595: )

Line 855: , p6_a4 in out JTF_VARCHAR2_TABLE_100

851: , p6_a0 in out JTF_NUMBER_TABLE
852: , p6_a1 in out JTF_NUMBER_TABLE
853: , p6_a2 in out JTF_VARCHAR2_TABLE_300
854: , p6_a3 in out JTF_NUMBER_TABLE
855: , p6_a4 in out JTF_VARCHAR2_TABLE_100
856: , p6_a5 in out JTF_VARCHAR2_TABLE_100
857: , p6_a6 in out JTF_VARCHAR2_TABLE_100
858: , p6_a7 in out JTF_VARCHAR2_TABLE_100
859: , p6_a8 in out JTF_NUMBER_TABLE

Line 856: , p6_a5 in out JTF_VARCHAR2_TABLE_100

852: , p6_a1 in out JTF_NUMBER_TABLE
853: , p6_a2 in out JTF_VARCHAR2_TABLE_300
854: , p6_a3 in out JTF_NUMBER_TABLE
855: , p6_a4 in out JTF_VARCHAR2_TABLE_100
856: , p6_a5 in out JTF_VARCHAR2_TABLE_100
857: , p6_a6 in out JTF_VARCHAR2_TABLE_100
858: , p6_a7 in out JTF_VARCHAR2_TABLE_100
859: , p6_a8 in out JTF_NUMBER_TABLE
860: , p6_a9 in out JTF_VARCHAR2_TABLE_100

Line 857: , p6_a6 in out JTF_VARCHAR2_TABLE_100

853: , p6_a2 in out JTF_VARCHAR2_TABLE_300
854: , p6_a3 in out JTF_NUMBER_TABLE
855: , p6_a4 in out JTF_VARCHAR2_TABLE_100
856: , p6_a5 in out JTF_VARCHAR2_TABLE_100
857: , p6_a6 in out JTF_VARCHAR2_TABLE_100
858: , p6_a7 in out JTF_VARCHAR2_TABLE_100
859: , p6_a8 in out JTF_NUMBER_TABLE
860: , p6_a9 in out JTF_VARCHAR2_TABLE_100
861: , p6_a10 in out JTF_VARCHAR2_TABLE_300

Line 858: , p6_a7 in out JTF_VARCHAR2_TABLE_100

854: , p6_a3 in out JTF_NUMBER_TABLE
855: , p6_a4 in out JTF_VARCHAR2_TABLE_100
856: , p6_a5 in out JTF_VARCHAR2_TABLE_100
857: , p6_a6 in out JTF_VARCHAR2_TABLE_100
858: , p6_a7 in out JTF_VARCHAR2_TABLE_100
859: , p6_a8 in out JTF_NUMBER_TABLE
860: , p6_a9 in out JTF_VARCHAR2_TABLE_100
861: , p6_a10 in out JTF_VARCHAR2_TABLE_300
862: , p6_a11 in out JTF_NUMBER_TABLE

Line 860: , p6_a9 in out JTF_VARCHAR2_TABLE_100

856: , p6_a5 in out JTF_VARCHAR2_TABLE_100
857: , p6_a6 in out JTF_VARCHAR2_TABLE_100
858: , p6_a7 in out JTF_VARCHAR2_TABLE_100
859: , p6_a8 in out JTF_NUMBER_TABLE
860: , p6_a9 in out JTF_VARCHAR2_TABLE_100
861: , p6_a10 in out JTF_VARCHAR2_TABLE_300
862: , p6_a11 in out JTF_NUMBER_TABLE
863: , p6_a12 in out JTF_NUMBER_TABLE
864: , p6_a13 in out JTF_VARCHAR2_TABLE_2000

Line 867: , p6_a16 in out JTF_VARCHAR2_TABLE_100

863: , p6_a12 in out JTF_NUMBER_TABLE
864: , p6_a13 in out JTF_VARCHAR2_TABLE_2000
865: , p6_a14 in out JTF_VARCHAR2_TABLE_2000
866: , p6_a15 in out JTF_VARCHAR2_TABLE_2000
867: , p6_a16 in out JTF_VARCHAR2_TABLE_100
868: , p6_a17 in out JTF_VARCHAR2_TABLE_100
869: , p6_a18 in out JTF_VARCHAR2_TABLE_100
870: , p6_a19 in out JTF_NUMBER_TABLE
871: , p6_a20 in out JTF_VARCHAR2_TABLE_2000

Line 868: , p6_a17 in out JTF_VARCHAR2_TABLE_100

864: , p6_a13 in out JTF_VARCHAR2_TABLE_2000
865: , p6_a14 in out JTF_VARCHAR2_TABLE_2000
866: , p6_a15 in out JTF_VARCHAR2_TABLE_2000
867: , p6_a16 in out JTF_VARCHAR2_TABLE_100
868: , p6_a17 in out JTF_VARCHAR2_TABLE_100
869: , p6_a18 in out JTF_VARCHAR2_TABLE_100
870: , p6_a19 in out JTF_NUMBER_TABLE
871: , p6_a20 in out JTF_VARCHAR2_TABLE_2000
872: , p6_a21 in out JTF_VARCHAR2_TABLE_300

Line 869: , p6_a18 in out JTF_VARCHAR2_TABLE_100

865: , p6_a14 in out JTF_VARCHAR2_TABLE_2000
866: , p6_a15 in out JTF_VARCHAR2_TABLE_2000
867: , p6_a16 in out JTF_VARCHAR2_TABLE_100
868: , p6_a17 in out JTF_VARCHAR2_TABLE_100
869: , p6_a18 in out JTF_VARCHAR2_TABLE_100
870: , p6_a19 in out JTF_NUMBER_TABLE
871: , p6_a20 in out JTF_VARCHAR2_TABLE_2000
872: , p6_a21 in out JTF_VARCHAR2_TABLE_300
873: , p6_a22 in out JTF_VARCHAR2_TABLE_1100

Line 876: , p6_a25 in out JTF_VARCHAR2_TABLE_100

872: , p6_a21 in out JTF_VARCHAR2_TABLE_300
873: , p6_a22 in out JTF_VARCHAR2_TABLE_1100
874: , p6_a23 in out JTF_NUMBER_TABLE
875: , p6_a24 in out JTF_VARCHAR2_TABLE_300
876: , p6_a25 in out JTF_VARCHAR2_TABLE_100
877: , p6_a26 in out JTF_VARCHAR2_TABLE_200
878: , p6_a27 in out JTF_VARCHAR2_TABLE_200
879: , p6_a28 in out JTF_VARCHAR2_TABLE_200
880: , p6_a29 in out JTF_VARCHAR2_TABLE_200

Line 893: , p6_a42 in out JTF_VARCHAR2_TABLE_1000

889: , p6_a38 in out JTF_VARCHAR2_TABLE_200
890: , p6_a39 in out JTF_VARCHAR2_TABLE_200
891: , p6_a40 in out JTF_VARCHAR2_TABLE_200
892: , p6_a41 in out JTF_VARCHAR2_TABLE_2000
893: , p6_a42 in out JTF_VARCHAR2_TABLE_1000
894: , p6_a43 in out JTF_VARCHAR2_TABLE_100
895: )
896: as
897: ddp_attachment_tbl jtf_attachment_grp.attachment_tbl_type;

Line 894: , p6_a43 in out JTF_VARCHAR2_TABLE_100

890: , p6_a39 in out JTF_VARCHAR2_TABLE_200
891: , p6_a40 in out JTF_VARCHAR2_TABLE_200
892: , p6_a41 in out JTF_VARCHAR2_TABLE_2000
893: , p6_a42 in out JTF_VARCHAR2_TABLE_1000
894: , p6_a43 in out JTF_VARCHAR2_TABLE_100
895: )
896: as
897: ddp_attachment_tbl jtf_attachment_grp.attachment_tbl_type;
898: ddindx binary_integer; indx binary_integer;

Line 1026: , p6_a3 in out JTF_VARCHAR2_TABLE_100

1022: , x_msg_data out VARCHAR2
1023: , p6_a0 in out JTF_NUMBER_TABLE
1024: , p6_a1 in out JTF_VARCHAR2_TABLE_300
1025: , p6_a2 in out JTF_NUMBER_TABLE
1026: , p6_a3 in out JTF_VARCHAR2_TABLE_100
1027: )
1028: as
1029: ddp_ath_id_ver_tbl jtf_attachment_grp.ath_id_ver_tbl_type;
1030: ddindx binary_integer; indx binary_integer;