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
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
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
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
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
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
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
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
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();
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();
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();
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();
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();
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();
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);
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);
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
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
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();
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();
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
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
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;
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
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
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
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;
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
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();
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();
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();
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();
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();
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();
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);
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);
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
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
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
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
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();
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
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);
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;
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
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
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
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
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();
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();
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);
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);
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
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
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
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
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
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
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
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: )
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:
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
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
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
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
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
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;
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
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
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
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:
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
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
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
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:
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
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
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;
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
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;
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
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
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
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: )
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
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
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
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: )
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
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
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
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
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
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
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
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