DBA Data[Home] [Help]

APPS.CS_TP_TEMPLATES_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 23: , a1 JTF_VARCHAR2_TABLE_1000

19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p1(t out nocopy cs_tp_templates_pvt.template_list, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_1000
24: , a2 JTF_VARCHAR2_TABLE_200
25: , a3 JTF_VARCHAR2_TABLE_200
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_600

Line 26: , a4 JTF_VARCHAR2_TABLE_100

22: procedure rosetta_table_copy_in_p1(t out nocopy cs_tp_templates_pvt.template_list, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_1000
24: , a2 JTF_VARCHAR2_TABLE_200
25: , a3 JTF_VARCHAR2_TABLE_200
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_600
28: , a6 JTF_VARCHAR2_TABLE_200
29: , a7 JTF_VARCHAR2_TABLE_100
30: , a8 JTF_VARCHAR2_TABLE_100

Line 29: , a7 JTF_VARCHAR2_TABLE_100

25: , a3 JTF_VARCHAR2_TABLE_200
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_600
28: , a6 JTF_VARCHAR2_TABLE_200
29: , a7 JTF_VARCHAR2_TABLE_100
30: , a8 JTF_VARCHAR2_TABLE_100
31: ) as
32: ddindx binary_integer; indx binary_integer;
33: begin

Line 30: , a8 JTF_VARCHAR2_TABLE_100

26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_600
28: , a6 JTF_VARCHAR2_TABLE_200
29: , a7 JTF_VARCHAR2_TABLE_100
30: , a8 JTF_VARCHAR2_TABLE_100
31: ) as
32: ddindx binary_integer; indx binary_integer;
33: begin
34: if a0 is not null and a0.count > 0 then

Line 58: , a1 out nocopy JTF_VARCHAR2_TABLE_1000

54: end if;
55: end if;
56: end rosetta_table_copy_in_p1;
57: procedure rosetta_table_copy_out_p1(t cs_tp_templates_pvt.template_list, a0 out nocopy JTF_NUMBER_TABLE
58: , a1 out nocopy JTF_VARCHAR2_TABLE_1000
59: , a2 out nocopy JTF_VARCHAR2_TABLE_200
60: , a3 out nocopy JTF_VARCHAR2_TABLE_200
61: , a4 out nocopy JTF_VARCHAR2_TABLE_100
62: , a5 out nocopy JTF_VARCHAR2_TABLE_600

Line 61: , a4 out nocopy JTF_VARCHAR2_TABLE_100

57: procedure rosetta_table_copy_out_p1(t cs_tp_templates_pvt.template_list, a0 out nocopy JTF_NUMBER_TABLE
58: , a1 out nocopy JTF_VARCHAR2_TABLE_1000
59: , a2 out nocopy JTF_VARCHAR2_TABLE_200
60: , a3 out nocopy JTF_VARCHAR2_TABLE_200
61: , a4 out nocopy JTF_VARCHAR2_TABLE_100
62: , a5 out nocopy JTF_VARCHAR2_TABLE_600
63: , a6 out nocopy JTF_VARCHAR2_TABLE_200
64: , a7 out nocopy JTF_VARCHAR2_TABLE_100
65: , a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 64: , a7 out nocopy JTF_VARCHAR2_TABLE_100

60: , a3 out nocopy JTF_VARCHAR2_TABLE_200
61: , a4 out nocopy JTF_VARCHAR2_TABLE_100
62: , a5 out nocopy JTF_VARCHAR2_TABLE_600
63: , a6 out nocopy JTF_VARCHAR2_TABLE_200
64: , a7 out nocopy JTF_VARCHAR2_TABLE_100
65: , a8 out nocopy JTF_VARCHAR2_TABLE_100
66: ) as
67: ddindx binary_integer; indx binary_integer;
68: begin

Line 65: , a8 out nocopy JTF_VARCHAR2_TABLE_100

61: , a4 out nocopy JTF_VARCHAR2_TABLE_100
62: , a5 out nocopy JTF_VARCHAR2_TABLE_600
63: , a6 out nocopy JTF_VARCHAR2_TABLE_200
64: , a7 out nocopy JTF_VARCHAR2_TABLE_100
65: , a8 out nocopy JTF_VARCHAR2_TABLE_100
66: ) as
67: ddindx binary_integer; indx binary_integer;
68: begin
69: if t is null or t.count = 0 then

Line 71: a1 := JTF_VARCHAR2_TABLE_1000();

67: ddindx binary_integer; indx binary_integer;
68: begin
69: if t is null or t.count = 0 then
70: a0 := JTF_NUMBER_TABLE();
71: a1 := JTF_VARCHAR2_TABLE_1000();
72: a2 := JTF_VARCHAR2_TABLE_200();
73: a3 := JTF_VARCHAR2_TABLE_200();
74: a4 := JTF_VARCHAR2_TABLE_100();
75: a5 := JTF_VARCHAR2_TABLE_600();

Line 74: a4 := JTF_VARCHAR2_TABLE_100();

70: a0 := JTF_NUMBER_TABLE();
71: a1 := JTF_VARCHAR2_TABLE_1000();
72: a2 := JTF_VARCHAR2_TABLE_200();
73: a3 := JTF_VARCHAR2_TABLE_200();
74: a4 := JTF_VARCHAR2_TABLE_100();
75: a5 := JTF_VARCHAR2_TABLE_600();
76: a6 := JTF_VARCHAR2_TABLE_200();
77: a7 := JTF_VARCHAR2_TABLE_100();
78: a8 := JTF_VARCHAR2_TABLE_100();

Line 77: a7 := JTF_VARCHAR2_TABLE_100();

73: a3 := JTF_VARCHAR2_TABLE_200();
74: a4 := JTF_VARCHAR2_TABLE_100();
75: a5 := JTF_VARCHAR2_TABLE_600();
76: a6 := JTF_VARCHAR2_TABLE_200();
77: a7 := JTF_VARCHAR2_TABLE_100();
78: a8 := JTF_VARCHAR2_TABLE_100();
79: else
80: a0 := JTF_NUMBER_TABLE();
81: a1 := JTF_VARCHAR2_TABLE_1000();

Line 78: a8 := JTF_VARCHAR2_TABLE_100();

74: a4 := JTF_VARCHAR2_TABLE_100();
75: a5 := JTF_VARCHAR2_TABLE_600();
76: a6 := JTF_VARCHAR2_TABLE_200();
77: a7 := JTF_VARCHAR2_TABLE_100();
78: a8 := JTF_VARCHAR2_TABLE_100();
79: else
80: a0 := JTF_NUMBER_TABLE();
81: a1 := JTF_VARCHAR2_TABLE_1000();
82: a2 := JTF_VARCHAR2_TABLE_200();

Line 81: a1 := JTF_VARCHAR2_TABLE_1000();

77: a7 := JTF_VARCHAR2_TABLE_100();
78: a8 := JTF_VARCHAR2_TABLE_100();
79: else
80: a0 := JTF_NUMBER_TABLE();
81: a1 := JTF_VARCHAR2_TABLE_1000();
82: a2 := JTF_VARCHAR2_TABLE_200();
83: a3 := JTF_VARCHAR2_TABLE_200();
84: a4 := JTF_VARCHAR2_TABLE_100();
85: a5 := JTF_VARCHAR2_TABLE_600();

Line 84: a4 := JTF_VARCHAR2_TABLE_100();

80: a0 := JTF_NUMBER_TABLE();
81: a1 := JTF_VARCHAR2_TABLE_1000();
82: a2 := JTF_VARCHAR2_TABLE_200();
83: a3 := JTF_VARCHAR2_TABLE_200();
84: a4 := JTF_VARCHAR2_TABLE_100();
85: a5 := JTF_VARCHAR2_TABLE_600();
86: a6 := JTF_VARCHAR2_TABLE_200();
87: a7 := JTF_VARCHAR2_TABLE_100();
88: a8 := JTF_VARCHAR2_TABLE_100();

Line 87: a7 := JTF_VARCHAR2_TABLE_100();

83: a3 := JTF_VARCHAR2_TABLE_200();
84: a4 := JTF_VARCHAR2_TABLE_100();
85: a5 := JTF_VARCHAR2_TABLE_600();
86: a6 := JTF_VARCHAR2_TABLE_200();
87: a7 := JTF_VARCHAR2_TABLE_100();
88: a8 := JTF_VARCHAR2_TABLE_100();
89: if t.count > 0 then
90: a0.extend(t.count);
91: a1.extend(t.count);

Line 88: a8 := JTF_VARCHAR2_TABLE_100();

84: a4 := JTF_VARCHAR2_TABLE_100();
85: a5 := JTF_VARCHAR2_TABLE_600();
86: a6 := JTF_VARCHAR2_TABLE_200();
87: a7 := JTF_VARCHAR2_TABLE_100();
88: a8 := JTF_VARCHAR2_TABLE_100();
89: if t.count > 0 then
90: a0.extend(t.count);
91: a1.extend(t.count);
92: a2.extend(t.count);

Line 122: , a1 JTF_VARCHAR2_TABLE_1000

118: end if;
119: end rosetta_table_copy_out_p1;
120:
121: procedure rosetta_table_copy_in_p3(t out nocopy cs_tp_templates_pvt.template_attribute_list, a0 JTF_NUMBER_TABLE
122: , a1 JTF_VARCHAR2_TABLE_1000
123: , a2 JTF_NUMBER_TABLE
124: , a3 JTF_NUMBER_TABLE
125: , a4 JTF_VARCHAR2_TABLE_200
126: , a5 JTF_NUMBER_TABLE

Line 155: , a1 out nocopy JTF_VARCHAR2_TABLE_1000

151: end if;
152: end if;
153: end rosetta_table_copy_in_p3;
154: procedure rosetta_table_copy_out_p3(t cs_tp_templates_pvt.template_attribute_list, a0 out nocopy JTF_NUMBER_TABLE
155: , a1 out nocopy JTF_VARCHAR2_TABLE_1000
156: , a2 out nocopy JTF_NUMBER_TABLE
157: , a3 out nocopy JTF_NUMBER_TABLE
158: , a4 out nocopy JTF_VARCHAR2_TABLE_200
159: , a5 out nocopy JTF_NUMBER_TABLE

Line 167: a1 := JTF_VARCHAR2_TABLE_1000();

163: ddindx binary_integer; indx binary_integer;
164: begin
165: if t is null or t.count = 0 then
166: a0 := JTF_NUMBER_TABLE();
167: a1 := JTF_VARCHAR2_TABLE_1000();
168: a2 := JTF_NUMBER_TABLE();
169: a3 := JTF_NUMBER_TABLE();
170: a4 := JTF_VARCHAR2_TABLE_200();
171: a5 := JTF_NUMBER_TABLE();

Line 176: a1 := JTF_VARCHAR2_TABLE_1000();

172: a6 := JTF_VARCHAR2_TABLE_200();
173: a7 := JTF_VARCHAR2_TABLE_200();
174: else
175: a0 := JTF_NUMBER_TABLE();
176: a1 := JTF_VARCHAR2_TABLE_1000();
177: a2 := JTF_NUMBER_TABLE();
178: a3 := JTF_NUMBER_TABLE();
179: a4 := JTF_VARCHAR2_TABLE_200();
180: a5 := JTF_NUMBER_TABLE();

Line 214: , a1 JTF_VARCHAR2_TABLE_1000

210: end if;
211: end rosetta_table_copy_out_p3;
212:
213: procedure rosetta_table_copy_in_p5(t out nocopy cs_tp_templates_pvt.template_link_list, a0 JTF_NUMBER_TABLE
214: , a1 JTF_VARCHAR2_TABLE_1000
215: , a2 JTF_VARCHAR2_TABLE_1000
216: , a3 JTF_VARCHAR2_TABLE_200
217: , a4 JTF_NUMBER_TABLE
218: , a5 JTF_VARCHAR2_TABLE_100

Line 215: , a2 JTF_VARCHAR2_TABLE_1000

211: end rosetta_table_copy_out_p3;
212:
213: procedure rosetta_table_copy_in_p5(t out nocopy cs_tp_templates_pvt.template_link_list, a0 JTF_NUMBER_TABLE
214: , a1 JTF_VARCHAR2_TABLE_1000
215: , a2 JTF_VARCHAR2_TABLE_1000
216: , a3 JTF_VARCHAR2_TABLE_200
217: , a4 JTF_NUMBER_TABLE
218: , a5 JTF_VARCHAR2_TABLE_100
219: , a6 JTF_VARCHAR2_TABLE_100

Line 218: , a5 JTF_VARCHAR2_TABLE_100

214: , a1 JTF_VARCHAR2_TABLE_1000
215: , a2 JTF_VARCHAR2_TABLE_1000
216: , a3 JTF_VARCHAR2_TABLE_200
217: , a4 JTF_NUMBER_TABLE
218: , a5 JTF_VARCHAR2_TABLE_100
219: , a6 JTF_VARCHAR2_TABLE_100
220: , a7 JTF_VARCHAR2_TABLE_200
221: ) as
222: ddindx binary_integer; indx binary_integer;

Line 219: , a6 JTF_VARCHAR2_TABLE_100

215: , a2 JTF_VARCHAR2_TABLE_1000
216: , a3 JTF_VARCHAR2_TABLE_200
217: , a4 JTF_NUMBER_TABLE
218: , a5 JTF_VARCHAR2_TABLE_100
219: , a6 JTF_VARCHAR2_TABLE_100
220: , a7 JTF_VARCHAR2_TABLE_200
221: ) as
222: ddindx binary_integer; indx binary_integer;
223: begin

Line 247: , a1 out nocopy JTF_VARCHAR2_TABLE_1000

243: end if;
244: end if;
245: end rosetta_table_copy_in_p5;
246: procedure rosetta_table_copy_out_p5(t cs_tp_templates_pvt.template_link_list, a0 out nocopy JTF_NUMBER_TABLE
247: , a1 out nocopy JTF_VARCHAR2_TABLE_1000
248: , a2 out nocopy JTF_VARCHAR2_TABLE_1000
249: , a3 out nocopy JTF_VARCHAR2_TABLE_200
250: , a4 out nocopy JTF_NUMBER_TABLE
251: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 248: , a2 out nocopy JTF_VARCHAR2_TABLE_1000

244: end if;
245: end rosetta_table_copy_in_p5;
246: procedure rosetta_table_copy_out_p5(t cs_tp_templates_pvt.template_link_list, a0 out nocopy JTF_NUMBER_TABLE
247: , a1 out nocopy JTF_VARCHAR2_TABLE_1000
248: , a2 out nocopy JTF_VARCHAR2_TABLE_1000
249: , a3 out nocopy JTF_VARCHAR2_TABLE_200
250: , a4 out nocopy JTF_NUMBER_TABLE
251: , a5 out nocopy JTF_VARCHAR2_TABLE_100
252: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 251: , a5 out nocopy JTF_VARCHAR2_TABLE_100

247: , a1 out nocopy JTF_VARCHAR2_TABLE_1000
248: , a2 out nocopy JTF_VARCHAR2_TABLE_1000
249: , a3 out nocopy JTF_VARCHAR2_TABLE_200
250: , a4 out nocopy JTF_NUMBER_TABLE
251: , a5 out nocopy JTF_VARCHAR2_TABLE_100
252: , a6 out nocopy JTF_VARCHAR2_TABLE_100
253: , a7 out nocopy JTF_VARCHAR2_TABLE_200
254: ) as
255: ddindx binary_integer; indx binary_integer;

Line 252: , a6 out nocopy JTF_VARCHAR2_TABLE_100

248: , a2 out nocopy JTF_VARCHAR2_TABLE_1000
249: , a3 out nocopy JTF_VARCHAR2_TABLE_200
250: , a4 out nocopy JTF_NUMBER_TABLE
251: , a5 out nocopy JTF_VARCHAR2_TABLE_100
252: , a6 out nocopy JTF_VARCHAR2_TABLE_100
253: , a7 out nocopy JTF_VARCHAR2_TABLE_200
254: ) as
255: ddindx binary_integer; indx binary_integer;
256: begin

Line 259: a1 := JTF_VARCHAR2_TABLE_1000();

255: ddindx binary_integer; indx binary_integer;
256: begin
257: if t is null or t.count = 0 then
258: a0 := JTF_NUMBER_TABLE();
259: a1 := JTF_VARCHAR2_TABLE_1000();
260: a2 := JTF_VARCHAR2_TABLE_1000();
261: a3 := JTF_VARCHAR2_TABLE_200();
262: a4 := JTF_NUMBER_TABLE();
263: a5 := JTF_VARCHAR2_TABLE_100();

Line 260: a2 := JTF_VARCHAR2_TABLE_1000();

256: begin
257: if t is null or t.count = 0 then
258: a0 := JTF_NUMBER_TABLE();
259: a1 := JTF_VARCHAR2_TABLE_1000();
260: a2 := JTF_VARCHAR2_TABLE_1000();
261: a3 := JTF_VARCHAR2_TABLE_200();
262: a4 := JTF_NUMBER_TABLE();
263: a5 := JTF_VARCHAR2_TABLE_100();
264: a6 := JTF_VARCHAR2_TABLE_100();

Line 263: a5 := JTF_VARCHAR2_TABLE_100();

259: a1 := JTF_VARCHAR2_TABLE_1000();
260: a2 := JTF_VARCHAR2_TABLE_1000();
261: a3 := JTF_VARCHAR2_TABLE_200();
262: a4 := JTF_NUMBER_TABLE();
263: a5 := JTF_VARCHAR2_TABLE_100();
264: a6 := JTF_VARCHAR2_TABLE_100();
265: a7 := JTF_VARCHAR2_TABLE_200();
266: else
267: a0 := JTF_NUMBER_TABLE();

Line 264: a6 := JTF_VARCHAR2_TABLE_100();

260: a2 := JTF_VARCHAR2_TABLE_1000();
261: a3 := JTF_VARCHAR2_TABLE_200();
262: a4 := JTF_NUMBER_TABLE();
263: a5 := JTF_VARCHAR2_TABLE_100();
264: a6 := JTF_VARCHAR2_TABLE_100();
265: a7 := JTF_VARCHAR2_TABLE_200();
266: else
267: a0 := JTF_NUMBER_TABLE();
268: a1 := JTF_VARCHAR2_TABLE_1000();

Line 268: a1 := JTF_VARCHAR2_TABLE_1000();

264: a6 := JTF_VARCHAR2_TABLE_100();
265: a7 := JTF_VARCHAR2_TABLE_200();
266: else
267: a0 := JTF_NUMBER_TABLE();
268: a1 := JTF_VARCHAR2_TABLE_1000();
269: a2 := JTF_VARCHAR2_TABLE_1000();
270: a3 := JTF_VARCHAR2_TABLE_200();
271: a4 := JTF_NUMBER_TABLE();
272: a5 := JTF_VARCHAR2_TABLE_100();

Line 269: a2 := JTF_VARCHAR2_TABLE_1000();

265: a7 := JTF_VARCHAR2_TABLE_200();
266: else
267: a0 := JTF_NUMBER_TABLE();
268: a1 := JTF_VARCHAR2_TABLE_1000();
269: a2 := JTF_VARCHAR2_TABLE_1000();
270: a3 := JTF_VARCHAR2_TABLE_200();
271: a4 := JTF_NUMBER_TABLE();
272: a5 := JTF_VARCHAR2_TABLE_100();
273: a6 := JTF_VARCHAR2_TABLE_100();

Line 272: a5 := JTF_VARCHAR2_TABLE_100();

268: a1 := JTF_VARCHAR2_TABLE_1000();
269: a2 := JTF_VARCHAR2_TABLE_1000();
270: a3 := JTF_VARCHAR2_TABLE_200();
271: a4 := JTF_NUMBER_TABLE();
272: a5 := JTF_VARCHAR2_TABLE_100();
273: a6 := JTF_VARCHAR2_TABLE_100();
274: a7 := JTF_VARCHAR2_TABLE_200();
275: if t.count > 0 then
276: a0.extend(t.count);

Line 273: a6 := JTF_VARCHAR2_TABLE_100();

269: a2 := JTF_VARCHAR2_TABLE_1000();
270: a3 := JTF_VARCHAR2_TABLE_200();
271: a4 := JTF_NUMBER_TABLE();
272: a5 := JTF_VARCHAR2_TABLE_100();
273: a6 := JTF_VARCHAR2_TABLE_100();
274: a7 := JTF_VARCHAR2_TABLE_200();
275: if t.count > 0 then
276: a0.extend(t.count);
277: a1.extend(t.count);

Line 305: procedure rosetta_table_copy_in_p7(t out nocopy cs_tp_templates_pvt.id_name_pairs, a0 JTF_VARCHAR2_TABLE_1000

301: end if;
302: end if;
303: end rosetta_table_copy_out_p5;
304:
305: procedure rosetta_table_copy_in_p7(t out nocopy cs_tp_templates_pvt.id_name_pairs, a0 JTF_VARCHAR2_TABLE_1000
306: , a1 JTF_VARCHAR2_TABLE_1000
307: ) as
308: ddindx binary_integer; indx binary_integer;
309: begin

Line 306: , a1 JTF_VARCHAR2_TABLE_1000

302: end if;
303: end rosetta_table_copy_out_p5;
304:
305: procedure rosetta_table_copy_in_p7(t out nocopy cs_tp_templates_pvt.id_name_pairs, a0 JTF_VARCHAR2_TABLE_1000
306: , a1 JTF_VARCHAR2_TABLE_1000
307: ) as
308: ddindx binary_integer; indx binary_integer;
309: begin
310: if a0 is not null and a0.count > 0 then

Line 326: procedure rosetta_table_copy_out_p7(t cs_tp_templates_pvt.id_name_pairs, a0 out nocopy JTF_VARCHAR2_TABLE_1000

322: end loop;
323: end if;
324: end if;
325: end rosetta_table_copy_in_p7;
326: procedure rosetta_table_copy_out_p7(t cs_tp_templates_pvt.id_name_pairs, a0 out nocopy JTF_VARCHAR2_TABLE_1000
327: , a1 out nocopy JTF_VARCHAR2_TABLE_1000
328: ) as
329: ddindx binary_integer; indx binary_integer;
330: begin

Line 327: , a1 out nocopy JTF_VARCHAR2_TABLE_1000

323: end if;
324: end if;
325: end rosetta_table_copy_in_p7;
326: procedure rosetta_table_copy_out_p7(t cs_tp_templates_pvt.id_name_pairs, a0 out nocopy JTF_VARCHAR2_TABLE_1000
327: , a1 out nocopy JTF_VARCHAR2_TABLE_1000
328: ) as
329: ddindx binary_integer; indx binary_integer;
330: begin
331: if t is null or t.count = 0 then

Line 332: a0 := JTF_VARCHAR2_TABLE_1000();

328: ) as
329: ddindx binary_integer; indx binary_integer;
330: begin
331: if t is null or t.count = 0 then
332: a0 := JTF_VARCHAR2_TABLE_1000();
333: a1 := JTF_VARCHAR2_TABLE_1000();
334: else
335: a0 := JTF_VARCHAR2_TABLE_1000();
336: a1 := JTF_VARCHAR2_TABLE_1000();

Line 333: a1 := JTF_VARCHAR2_TABLE_1000();

329: ddindx binary_integer; indx binary_integer;
330: begin
331: if t is null or t.count = 0 then
332: a0 := JTF_VARCHAR2_TABLE_1000();
333: a1 := JTF_VARCHAR2_TABLE_1000();
334: else
335: a0 := JTF_VARCHAR2_TABLE_1000();
336: a1 := JTF_VARCHAR2_TABLE_1000();
337: if t.count > 0 then

Line 335: a0 := JTF_VARCHAR2_TABLE_1000();

331: if t is null or t.count = 0 then
332: a0 := JTF_VARCHAR2_TABLE_1000();
333: a1 := JTF_VARCHAR2_TABLE_1000();
334: else
335: a0 := JTF_VARCHAR2_TABLE_1000();
336: a1 := JTF_VARCHAR2_TABLE_1000();
337: if t.count > 0 then
338: a0.extend(t.count);
339: a1.extend(t.count);

Line 336: a1 := JTF_VARCHAR2_TABLE_1000();

332: a0 := JTF_VARCHAR2_TABLE_1000();
333: a1 := JTF_VARCHAR2_TABLE_1000();
334: else
335: a0 := JTF_VARCHAR2_TABLE_1000();
336: a1 := JTF_VARCHAR2_TABLE_1000();
337: if t.count > 0 then
338: a0.extend(t.count);
339: a1.extend(t.count);
340: ddindx := t.first;

Line 356: , a1 JTF_VARCHAR2_TABLE_100

352: end if;
353: end rosetta_table_copy_out_p7;
354:
355: procedure rosetta_table_copy_in_p9(t out nocopy cs_tp_templates_pvt.object_other_id_pairs, a0 JTF_NUMBER_TABLE
356: , a1 JTF_VARCHAR2_TABLE_100
357: , a2 JTF_VARCHAR2_TABLE_1000
358: ) as
359: ddindx binary_integer; indx binary_integer;
360: begin

Line 357: , a2 JTF_VARCHAR2_TABLE_1000

353: end rosetta_table_copy_out_p7;
354:
355: procedure rosetta_table_copy_in_p9(t out nocopy cs_tp_templates_pvt.object_other_id_pairs, a0 JTF_NUMBER_TABLE
356: , a1 JTF_VARCHAR2_TABLE_100
357: , a2 JTF_VARCHAR2_TABLE_1000
358: ) as
359: ddindx binary_integer; indx binary_integer;
360: begin
361: if a0 is not null and a0.count > 0 then

Line 379: , a1 out nocopy JTF_VARCHAR2_TABLE_100

375: end if;
376: end if;
377: end rosetta_table_copy_in_p9;
378: procedure rosetta_table_copy_out_p9(t cs_tp_templates_pvt.object_other_id_pairs, a0 out nocopy JTF_NUMBER_TABLE
379: , a1 out nocopy JTF_VARCHAR2_TABLE_100
380: , a2 out nocopy JTF_VARCHAR2_TABLE_1000
381: ) as
382: ddindx binary_integer; indx binary_integer;
383: begin

Line 380: , a2 out nocopy JTF_VARCHAR2_TABLE_1000

376: end if;
377: end rosetta_table_copy_in_p9;
378: procedure rosetta_table_copy_out_p9(t cs_tp_templates_pvt.object_other_id_pairs, a0 out nocopy JTF_NUMBER_TABLE
379: , a1 out nocopy JTF_VARCHAR2_TABLE_100
380: , a2 out nocopy JTF_VARCHAR2_TABLE_1000
381: ) as
382: ddindx binary_integer; indx binary_integer;
383: begin
384: if t is null or t.count = 0 then

Line 386: a1 := JTF_VARCHAR2_TABLE_100();

382: ddindx binary_integer; indx binary_integer;
383: begin
384: if t is null or t.count = 0 then
385: a0 := JTF_NUMBER_TABLE();
386: a1 := JTF_VARCHAR2_TABLE_100();
387: a2 := JTF_VARCHAR2_TABLE_1000();
388: else
389: a0 := JTF_NUMBER_TABLE();
390: a1 := JTF_VARCHAR2_TABLE_100();

Line 387: a2 := JTF_VARCHAR2_TABLE_1000();

383: begin
384: if t is null or t.count = 0 then
385: a0 := JTF_NUMBER_TABLE();
386: a1 := JTF_VARCHAR2_TABLE_100();
387: a2 := JTF_VARCHAR2_TABLE_1000();
388: else
389: a0 := JTF_NUMBER_TABLE();
390: a1 := JTF_VARCHAR2_TABLE_100();
391: a2 := JTF_VARCHAR2_TABLE_1000();

Line 390: a1 := JTF_VARCHAR2_TABLE_100();

386: a1 := JTF_VARCHAR2_TABLE_100();
387: a2 := JTF_VARCHAR2_TABLE_1000();
388: else
389: a0 := JTF_NUMBER_TABLE();
390: a1 := JTF_VARCHAR2_TABLE_100();
391: a2 := JTF_VARCHAR2_TABLE_1000();
392: if t.count > 0 then
393: a0.extend(t.count);
394: a1.extend(t.count);

Line 391: a2 := JTF_VARCHAR2_TABLE_1000();

387: a2 := JTF_VARCHAR2_TABLE_1000();
388: else
389: a0 := JTF_NUMBER_TABLE();
390: a1 := JTF_VARCHAR2_TABLE_100();
391: a2 := JTF_VARCHAR2_TABLE_1000();
392: if t.count > 0 then
393: a0.extend(t.count);
394: a1.extend(t.count);
395: a2.extend(t.count);

Line 535: , p4_a1 JTF_VARCHAR2_TABLE_1000

531: , p_init_msg_list VARCHAR2
532: , p_commit VARCHAR
533: , p_template_id NUMBER
534: , p4_a0 JTF_NUMBER_TABLE
535: , p4_a1 JTF_VARCHAR2_TABLE_1000
536: , p4_a2 JTF_NUMBER_TABLE
537: , p4_a3 JTF_NUMBER_TABLE
538: , p4_a4 JTF_VARCHAR2_TABLE_200
539: , p4_a5 JTF_NUMBER_TABLE

Line 596: , p5_a1 JTF_VARCHAR2_TABLE_1000

592: , p_commit VARCHAR
593: , p_template_id NUMBER
594: , p_jtf_object_code VARCHAR2
595: , p5_a0 JTF_NUMBER_TABLE
596: , p5_a1 JTF_VARCHAR2_TABLE_1000
597: , p5_a2 JTF_VARCHAR2_TABLE_1000
598: , p5_a3 JTF_VARCHAR2_TABLE_200
599: , p5_a4 JTF_NUMBER_TABLE
600: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 597: , p5_a2 JTF_VARCHAR2_TABLE_1000

593: , p_template_id NUMBER
594: , p_jtf_object_code VARCHAR2
595: , p5_a0 JTF_NUMBER_TABLE
596: , p5_a1 JTF_VARCHAR2_TABLE_1000
597: , p5_a2 JTF_VARCHAR2_TABLE_1000
598: , p5_a3 JTF_VARCHAR2_TABLE_200
599: , p5_a4 JTF_NUMBER_TABLE
600: , p5_a5 JTF_VARCHAR2_TABLE_100
601: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 600: , p5_a5 JTF_VARCHAR2_TABLE_100

596: , p5_a1 JTF_VARCHAR2_TABLE_1000
597: , p5_a2 JTF_VARCHAR2_TABLE_1000
598: , p5_a3 JTF_VARCHAR2_TABLE_200
599: , p5_a4 JTF_NUMBER_TABLE
600: , p5_a5 JTF_VARCHAR2_TABLE_100
601: , p5_a6 JTF_VARCHAR2_TABLE_100
602: , p5_a7 JTF_VARCHAR2_TABLE_200
603: , x_msg_count out nocopy NUMBER
604: , x_msg_data out nocopy VARCHAR2

Line 601: , p5_a6 JTF_VARCHAR2_TABLE_100

597: , p5_a2 JTF_VARCHAR2_TABLE_1000
598: , p5_a3 JTF_VARCHAR2_TABLE_200
599: , p5_a4 JTF_NUMBER_TABLE
600: , p5_a5 JTF_VARCHAR2_TABLE_100
601: , p5_a6 JTF_VARCHAR2_TABLE_100
602: , p5_a7 JTF_VARCHAR2_TABLE_200
603: , x_msg_count out nocopy NUMBER
604: , x_msg_data out nocopy VARCHAR2
605: , x_return_status out nocopy VARCHAR2

Line 665: , p10_a1 out nocopy JTF_VARCHAR2_TABLE_1000

661: , x_msg_count out nocopy NUMBER
662: , x_msg_data out nocopy VARCHAR2
663: , x_return_status out nocopy VARCHAR2
664: , p10_a0 out nocopy JTF_NUMBER_TABLE
665: , p10_a1 out nocopy JTF_VARCHAR2_TABLE_1000
666: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_200
667: , p10_a3 out nocopy JTF_VARCHAR2_TABLE_200
668: , p10_a4 out nocopy JTF_VARCHAR2_TABLE_100
669: , p10_a5 out nocopy JTF_VARCHAR2_TABLE_600

Line 668: , p10_a4 out nocopy JTF_VARCHAR2_TABLE_100

664: , p10_a0 out nocopy JTF_NUMBER_TABLE
665: , p10_a1 out nocopy JTF_VARCHAR2_TABLE_1000
666: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_200
667: , p10_a3 out nocopy JTF_VARCHAR2_TABLE_200
668: , p10_a4 out nocopy JTF_VARCHAR2_TABLE_100
669: , p10_a5 out nocopy JTF_VARCHAR2_TABLE_600
670: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_200
671: , p10_a7 out nocopy JTF_VARCHAR2_TABLE_100
672: , p10_a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 671: , p10_a7 out nocopy JTF_VARCHAR2_TABLE_100

667: , p10_a3 out nocopy JTF_VARCHAR2_TABLE_200
668: , p10_a4 out nocopy JTF_VARCHAR2_TABLE_100
669: , p10_a5 out nocopy JTF_VARCHAR2_TABLE_600
670: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_200
671: , p10_a7 out nocopy JTF_VARCHAR2_TABLE_100
672: , p10_a8 out nocopy JTF_VARCHAR2_TABLE_100
673: , x_total_templates out nocopy NUMBER
674: , x_retrieved_template_num out nocopy NUMBER
675: )

Line 672: , p10_a8 out nocopy JTF_VARCHAR2_TABLE_100

668: , p10_a4 out nocopy JTF_VARCHAR2_TABLE_100
669: , p10_a5 out nocopy JTF_VARCHAR2_TABLE_600
670: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_200
671: , p10_a7 out nocopy JTF_VARCHAR2_TABLE_100
672: , p10_a8 out nocopy JTF_VARCHAR2_TABLE_100
673: , x_total_templates out nocopy NUMBER
674: , x_retrieved_template_num out nocopy NUMBER
675: )
676:

Line 801: , p3_a1 JTF_VARCHAR2_TABLE_100

797: procedure show_templates_with_link(p_api_version_number NUMBER
798: , p_init_msg_list VARCHAR2
799: , p_commit VARCHAR
800: , p3_a0 JTF_NUMBER_TABLE
801: , p3_a1 JTF_VARCHAR2_TABLE_100
802: , p3_a2 JTF_VARCHAR2_TABLE_1000
803: , x_msg_count out nocopy NUMBER
804: , x_msg_data out nocopy VARCHAR2
805: , x_return_status out nocopy VARCHAR2

Line 802: , p3_a2 JTF_VARCHAR2_TABLE_1000

798: , p_init_msg_list VARCHAR2
799: , p_commit VARCHAR
800: , p3_a0 JTF_NUMBER_TABLE
801: , p3_a1 JTF_VARCHAR2_TABLE_100
802: , p3_a2 JTF_VARCHAR2_TABLE_1000
803: , x_msg_count out nocopy NUMBER
804: , x_msg_data out nocopy VARCHAR2
805: , x_return_status out nocopy VARCHAR2
806: , p7_a0 out nocopy JTF_NUMBER_TABLE

Line 807: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_1000

803: , x_msg_count out nocopy NUMBER
804: , x_msg_data out nocopy VARCHAR2
805: , x_return_status out nocopy VARCHAR2
806: , p7_a0 out nocopy JTF_NUMBER_TABLE
807: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_1000
808: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_200
809: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_200
810: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
811: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_600

Line 810: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100

806: , p7_a0 out nocopy JTF_NUMBER_TABLE
807: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_1000
808: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_200
809: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_200
810: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
811: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_600
812: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_200
813: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_100
814: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 813: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_100

809: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_200
810: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
811: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_600
812: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_200
813: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_100
814: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100
815: )
816:
817: as

Line 814: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100

810: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
811: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_600
812: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_200
813: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_100
814: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100
815: )
816:
817: as
818: ddp_object_other_list cs_tp_templates_pvt.object_other_id_pairs;

Line 875: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_1000

871: , x_msg_count out nocopy NUMBER
872: , x_msg_data out nocopy VARCHAR2
873: , x_return_status out nocopy VARCHAR2
874: , p8_a0 out nocopy JTF_NUMBER_TABLE
875: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_1000
876: , p8_a2 out nocopy JTF_NUMBER_TABLE
877: , p8_a3 out nocopy JTF_NUMBER_TABLE
878: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_200
879: , p8_a5 out nocopy JTF_NUMBER_TABLE

Line 939: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_1000

935: , x_msg_count out nocopy NUMBER
936: , x_msg_data out nocopy VARCHAR2
937: , x_return_status out nocopy VARCHAR2
938: , p8_a0 out nocopy JTF_NUMBER_TABLE
939: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_1000
940: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_1000
941: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_200
942: , p8_a4 out nocopy JTF_NUMBER_TABLE
943: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 940: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_1000

936: , x_msg_data out nocopy VARCHAR2
937: , x_return_status out nocopy VARCHAR2
938: , p8_a0 out nocopy JTF_NUMBER_TABLE
939: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_1000
940: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_1000
941: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_200
942: , p8_a4 out nocopy JTF_NUMBER_TABLE
943: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
944: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 943: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100

939: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_1000
940: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_1000
941: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_200
942: , p8_a4 out nocopy JTF_NUMBER_TABLE
943: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
944: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
945: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_200
946: )
947:

Line 944: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100

940: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_1000
941: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_200
942: , p8_a4 out nocopy JTF_NUMBER_TABLE
943: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
944: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
945: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_200
946: )
947:
948: as

Line 1003: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_1000

999: , x_msg_count out nocopy NUMBER
1000: , x_msg_data out nocopy VARCHAR2
1001: , x_return_status out nocopy VARCHAR2
1002: , p8_a0 out nocopy JTF_NUMBER_TABLE
1003: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_1000
1004: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_1000
1005: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_200
1006: , p8_a4 out nocopy JTF_NUMBER_TABLE
1007: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 1004: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_1000

1000: , x_msg_data out nocopy VARCHAR2
1001: , x_return_status out nocopy VARCHAR2
1002: , p8_a0 out nocopy JTF_NUMBER_TABLE
1003: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_1000
1004: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_1000
1005: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_200
1006: , p8_a4 out nocopy JTF_NUMBER_TABLE
1007: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
1008: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 1007: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100

1003: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_1000
1004: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_1000
1005: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_200
1006: , p8_a4 out nocopy JTF_NUMBER_TABLE
1007: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
1008: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
1009: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_200
1010: )
1011:

Line 1008: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100

1004: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_1000
1005: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_200
1006: , p8_a4 out nocopy JTF_NUMBER_TABLE
1007: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
1008: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
1009: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_200
1010: )
1011:
1012: as

Line 1065: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_1000

1061: , p_identify VARCHAR2
1062: , x_msg_count out nocopy NUMBER
1063: , x_msg_data out nocopy VARCHAR2
1064: , x_return_status out nocopy VARCHAR2
1065: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_1000
1066: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_1000
1067: )
1068:
1069: as

Line 1066: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_1000

1062: , x_msg_count out nocopy NUMBER
1063: , x_msg_data out nocopy VARCHAR2
1064: , x_return_status out nocopy VARCHAR2
1065: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_1000
1066: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_1000
1067: )
1068:
1069: as
1070: ddx_idname_pairs cs_tp_templates_pvt.id_name_pairs;

Line 1112: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_1000

1108: , p_commit VARCHAR2
1109: , x_msg_count out nocopy NUMBER
1110: , x_msg_data out nocopy VARCHAR2
1111: , x_return_status out nocopy VARCHAR2
1112: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_1000
1113: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_1000
1114: )
1115:
1116: as

Line 1113: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_1000

1109: , x_msg_count out nocopy NUMBER
1110: , x_msg_data out nocopy VARCHAR2
1111: , x_return_status out nocopy VARCHAR2
1112: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_1000
1113: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_1000
1114: )
1115:
1116: as
1117: ddx_idname_pairs cs_tp_templates_pvt.id_name_pairs;

Line 1218: , p10_a1 out nocopy JTF_VARCHAR2_TABLE_1000

1214: , x_msg_count out nocopy NUMBER
1215: , x_msg_data out nocopy VARCHAR2
1216: , x_return_status out nocopy VARCHAR2
1217: , p10_a0 out nocopy JTF_NUMBER_TABLE
1218: , p10_a1 out nocopy JTF_VARCHAR2_TABLE_1000
1219: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_1000
1220: , p10_a3 out nocopy JTF_VARCHAR2_TABLE_200
1221: , p10_a4 out nocopy JTF_NUMBER_TABLE
1222: , p10_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 1219: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_1000

1215: , x_msg_data out nocopy VARCHAR2
1216: , x_return_status out nocopy VARCHAR2
1217: , p10_a0 out nocopy JTF_NUMBER_TABLE
1218: , p10_a1 out nocopy JTF_VARCHAR2_TABLE_1000
1219: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_1000
1220: , p10_a3 out nocopy JTF_VARCHAR2_TABLE_200
1221: , p10_a4 out nocopy JTF_NUMBER_TABLE
1222: , p10_a5 out nocopy JTF_VARCHAR2_TABLE_100
1223: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 1222: , p10_a5 out nocopy JTF_VARCHAR2_TABLE_100

1218: , p10_a1 out nocopy JTF_VARCHAR2_TABLE_1000
1219: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_1000
1220: , p10_a3 out nocopy JTF_VARCHAR2_TABLE_200
1221: , p10_a4 out nocopy JTF_NUMBER_TABLE
1222: , p10_a5 out nocopy JTF_VARCHAR2_TABLE_100
1223: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_100
1224: , p10_a7 out nocopy JTF_VARCHAR2_TABLE_200
1225: , x_total_link_number out nocopy NUMBER
1226: , x_retrieved_link_number out nocopy NUMBER

Line 1223: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_100

1219: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_1000
1220: , p10_a3 out nocopy JTF_VARCHAR2_TABLE_200
1221: , p10_a4 out nocopy JTF_NUMBER_TABLE
1222: , p10_a5 out nocopy JTF_VARCHAR2_TABLE_100
1223: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_100
1224: , p10_a7 out nocopy JTF_VARCHAR2_TABLE_200
1225: , x_total_link_number out nocopy NUMBER
1226: , x_retrieved_link_number out nocopy NUMBER
1227: )

Line 1299: , p11_a1 out nocopy JTF_VARCHAR2_TABLE_1000

1295: , x_msg_count out nocopy NUMBER
1296: , x_msg_data out nocopy VARCHAR2
1297: , x_return_status out nocopy VARCHAR2
1298: , p11_a0 out nocopy JTF_NUMBER_TABLE
1299: , p11_a1 out nocopy JTF_VARCHAR2_TABLE_1000
1300: , p11_a2 out nocopy JTF_VARCHAR2_TABLE_1000
1301: , p11_a3 out nocopy JTF_VARCHAR2_TABLE_200
1302: , p11_a4 out nocopy JTF_NUMBER_TABLE
1303: , p11_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 1300: , p11_a2 out nocopy JTF_VARCHAR2_TABLE_1000

1296: , x_msg_data out nocopy VARCHAR2
1297: , x_return_status out nocopy VARCHAR2
1298: , p11_a0 out nocopy JTF_NUMBER_TABLE
1299: , p11_a1 out nocopy JTF_VARCHAR2_TABLE_1000
1300: , p11_a2 out nocopy JTF_VARCHAR2_TABLE_1000
1301: , p11_a3 out nocopy JTF_VARCHAR2_TABLE_200
1302: , p11_a4 out nocopy JTF_NUMBER_TABLE
1303: , p11_a5 out nocopy JTF_VARCHAR2_TABLE_100
1304: , p11_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 1303: , p11_a5 out nocopy JTF_VARCHAR2_TABLE_100

1299: , p11_a1 out nocopy JTF_VARCHAR2_TABLE_1000
1300: , p11_a2 out nocopy JTF_VARCHAR2_TABLE_1000
1301: , p11_a3 out nocopy JTF_VARCHAR2_TABLE_200
1302: , p11_a4 out nocopy JTF_NUMBER_TABLE
1303: , p11_a5 out nocopy JTF_VARCHAR2_TABLE_100
1304: , p11_a6 out nocopy JTF_VARCHAR2_TABLE_100
1305: , p11_a7 out nocopy JTF_VARCHAR2_TABLE_200
1306: , x_total_link_number out nocopy NUMBER
1307: , x_retrieved_link_number out nocopy NUMBER

Line 1304: , p11_a6 out nocopy JTF_VARCHAR2_TABLE_100

1300: , p11_a2 out nocopy JTF_VARCHAR2_TABLE_1000
1301: , p11_a3 out nocopy JTF_VARCHAR2_TABLE_200
1302: , p11_a4 out nocopy JTF_NUMBER_TABLE
1303: , p11_a5 out nocopy JTF_VARCHAR2_TABLE_100
1304: , p11_a6 out nocopy JTF_VARCHAR2_TABLE_100
1305: , p11_a7 out nocopy JTF_VARCHAR2_TABLE_200
1306: , x_total_link_number out nocopy NUMBER
1307: , x_retrieved_link_number out nocopy NUMBER
1308: )

Line 1377: , p5_a1 JTF_VARCHAR2_TABLE_1000

1373: , p_commit VARCHAR
1374: , p_template_id NUMBER
1375: , p_jtf_object_code VARCHAR2
1376: , p5_a0 JTF_NUMBER_TABLE
1377: , p5_a1 JTF_VARCHAR2_TABLE_1000
1378: , p5_a2 JTF_VARCHAR2_TABLE_1000
1379: , p5_a3 JTF_VARCHAR2_TABLE_200
1380: , p5_a4 JTF_NUMBER_TABLE
1381: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 1378: , p5_a2 JTF_VARCHAR2_TABLE_1000

1374: , p_template_id NUMBER
1375: , p_jtf_object_code VARCHAR2
1376: , p5_a0 JTF_NUMBER_TABLE
1377: , p5_a1 JTF_VARCHAR2_TABLE_1000
1378: , p5_a2 JTF_VARCHAR2_TABLE_1000
1379: , p5_a3 JTF_VARCHAR2_TABLE_200
1380: , p5_a4 JTF_NUMBER_TABLE
1381: , p5_a5 JTF_VARCHAR2_TABLE_100
1382: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 1381: , p5_a5 JTF_VARCHAR2_TABLE_100

1377: , p5_a1 JTF_VARCHAR2_TABLE_1000
1378: , p5_a2 JTF_VARCHAR2_TABLE_1000
1379: , p5_a3 JTF_VARCHAR2_TABLE_200
1380: , p5_a4 JTF_NUMBER_TABLE
1381: , p5_a5 JTF_VARCHAR2_TABLE_100
1382: , p5_a6 JTF_VARCHAR2_TABLE_100
1383: , p5_a7 JTF_VARCHAR2_TABLE_200
1384: , x_msg_count out nocopy NUMBER
1385: , x_msg_data out nocopy VARCHAR2

Line 1382: , p5_a6 JTF_VARCHAR2_TABLE_100

1378: , p5_a2 JTF_VARCHAR2_TABLE_1000
1379: , p5_a3 JTF_VARCHAR2_TABLE_200
1380: , p5_a4 JTF_NUMBER_TABLE
1381: , p5_a5 JTF_VARCHAR2_TABLE_100
1382: , p5_a6 JTF_VARCHAR2_TABLE_100
1383: , p5_a7 JTF_VARCHAR2_TABLE_200
1384: , x_msg_count out nocopy NUMBER
1385: , x_msg_data out nocopy VARCHAR2
1386: , x_return_status out nocopy VARCHAR2

Line 1441: , p5_a1 JTF_VARCHAR2_TABLE_1000

1437: , p_commit VARCHAR
1438: , p_template_id NUMBER
1439: , p_jtf_object_code VARCHAR2
1440: , p5_a0 JTF_NUMBER_TABLE
1441: , p5_a1 JTF_VARCHAR2_TABLE_1000
1442: , p5_a2 JTF_VARCHAR2_TABLE_1000
1443: , p5_a3 JTF_VARCHAR2_TABLE_200
1444: , p5_a4 JTF_NUMBER_TABLE
1445: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 1442: , p5_a2 JTF_VARCHAR2_TABLE_1000

1438: , p_template_id NUMBER
1439: , p_jtf_object_code VARCHAR2
1440: , p5_a0 JTF_NUMBER_TABLE
1441: , p5_a1 JTF_VARCHAR2_TABLE_1000
1442: , p5_a2 JTF_VARCHAR2_TABLE_1000
1443: , p5_a3 JTF_VARCHAR2_TABLE_200
1444: , p5_a4 JTF_NUMBER_TABLE
1445: , p5_a5 JTF_VARCHAR2_TABLE_100
1446: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 1445: , p5_a5 JTF_VARCHAR2_TABLE_100

1441: , p5_a1 JTF_VARCHAR2_TABLE_1000
1442: , p5_a2 JTF_VARCHAR2_TABLE_1000
1443: , p5_a3 JTF_VARCHAR2_TABLE_200
1444: , p5_a4 JTF_NUMBER_TABLE
1445: , p5_a5 JTF_VARCHAR2_TABLE_100
1446: , p5_a6 JTF_VARCHAR2_TABLE_100
1447: , p5_a7 JTF_VARCHAR2_TABLE_200
1448: , x_msg_count out nocopy NUMBER
1449: , x_msg_data out nocopy VARCHAR2

Line 1446: , p5_a6 JTF_VARCHAR2_TABLE_100

1442: , p5_a2 JTF_VARCHAR2_TABLE_1000
1443: , p5_a3 JTF_VARCHAR2_TABLE_200
1444: , p5_a4 JTF_NUMBER_TABLE
1445: , p5_a5 JTF_VARCHAR2_TABLE_100
1446: , p5_a6 JTF_VARCHAR2_TABLE_100
1447: , p5_a7 JTF_VARCHAR2_TABLE_200
1448: , x_msg_count out nocopy NUMBER
1449: , x_msg_data out nocopy VARCHAR2
1450: , x_return_status out nocopy VARCHAR2