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
28: , a6 JTF_VARCHAR2_TABLE_200
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
28: , a6 JTF_VARCHAR2_TABLE_200
29: , a7 JTF_VARCHAR2_TABLE_100
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
31: ) as
32: ddindx binary_integer; indx binary_integer;
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
63: , a6 out nocopy JTF_VARCHAR2_TABLE_200
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
63: , a6 out nocopy JTF_VARCHAR2_TABLE_200
64: , a7 out nocopy JTF_VARCHAR2_TABLE_100
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
66: ) as
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();
76: a6 := JTF_VARCHAR2_TABLE_200();
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();
76: a6 := JTF_VARCHAR2_TABLE_200();
77: a7 := JTF_VARCHAR2_TABLE_100();
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();
79: else
80: a0 := JTF_NUMBER_TABLE();
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();
86: a6 := JTF_VARCHAR2_TABLE_200();
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();
86: a6 := JTF_VARCHAR2_TABLE_200();
87: a7 := JTF_VARCHAR2_TABLE_100();
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();
89: if t.count > 0 then
90: a0.extend(t.count);
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
127: , a6 JTF_VARCHAR2_TABLE_200
128: , a7 JTF_VARCHAR2_TABLE_200
129: ) as
123: , a2 JTF_NUMBER_TABLE
124: , a3 JTF_NUMBER_TABLE
125: , a4 JTF_VARCHAR2_TABLE_200
126: , a5 JTF_NUMBER_TABLE
127: , a6 JTF_VARCHAR2_TABLE_200
128: , a7 JTF_VARCHAR2_TABLE_200
129: ) as
130: ddindx binary_integer; indx binary_integer;
131: begin
124: , a3 JTF_NUMBER_TABLE
125: , a4 JTF_VARCHAR2_TABLE_200
126: , a5 JTF_NUMBER_TABLE
127: , a6 JTF_VARCHAR2_TABLE_200
128: , a7 JTF_VARCHAR2_TABLE_200
129: ) as
130: ddindx binary_integer; indx binary_integer;
131: begin
132: if a0 is not null and a0.count > 0 then
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
160: , a6 out nocopy JTF_VARCHAR2_TABLE_200
161: , a7 out nocopy JTF_VARCHAR2_TABLE_200
162: ) as
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
160: , a6 out nocopy JTF_VARCHAR2_TABLE_200
161: , a7 out nocopy JTF_VARCHAR2_TABLE_200
162: ) as
163: ddindx binary_integer; indx binary_integer;
164: begin
157: , a3 out nocopy JTF_NUMBER_TABLE
158: , a4 out nocopy JTF_VARCHAR2_TABLE_200
159: , a5 out nocopy JTF_NUMBER_TABLE
160: , a6 out nocopy JTF_VARCHAR2_TABLE_200
161: , a7 out nocopy JTF_VARCHAR2_TABLE_200
162: ) as
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
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();
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();
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();
181: a6 := JTF_VARCHAR2_TABLE_200();
182: a7 := JTF_VARCHAR2_TABLE_200();
183: if t.count > 0 then
177: a2 := JTF_NUMBER_TABLE();
178: a3 := JTF_NUMBER_TABLE();
179: a4 := JTF_VARCHAR2_TABLE_200();
180: a5 := JTF_NUMBER_TABLE();
181: a6 := JTF_VARCHAR2_TABLE_200();
182: a7 := JTF_VARCHAR2_TABLE_200();
183: if t.count > 0 then
184: a0.extend(t.count);
185: a1.extend(t.count);
178: a3 := JTF_NUMBER_TABLE();
179: a4 := JTF_VARCHAR2_TABLE_200();
180: a5 := JTF_NUMBER_TABLE();
181: a6 := JTF_VARCHAR2_TABLE_200();
182: a7 := JTF_VARCHAR2_TABLE_200();
183: if t.count > 0 then
184: a0.extend(t.count);
185: a1.extend(t.count);
186: a2.extend(t.count);
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
220: , a7 JTF_VARCHAR2_TABLE_200
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
224: if a0 is not null and a0.count > 0 then
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
253: , a7 out nocopy JTF_VARCHAR2_TABLE_200
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
257: if t is null or t.count = 0 then
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();
265: a7 := JTF_VARCHAR2_TABLE_200();
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();
269: a2 := JTF_VARCHAR2_TABLE_1000();
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();
274: a7 := JTF_VARCHAR2_TABLE_200();
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);
278: a2.extend(t.count);
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
540: , p4_a6 JTF_VARCHAR2_TABLE_200
541: , p4_a7 JTF_VARCHAR2_TABLE_200
542: , x_msg_count out nocopy NUMBER
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
540: , p4_a6 JTF_VARCHAR2_TABLE_200
541: , p4_a7 JTF_VARCHAR2_TABLE_200
542: , x_msg_count out nocopy NUMBER
543: , x_msg_data out nocopy VARCHAR2
544: , x_return_status out nocopy VARCHAR2
537: , p4_a3 JTF_NUMBER_TABLE
538: , p4_a4 JTF_VARCHAR2_TABLE_200
539: , p4_a5 JTF_NUMBER_TABLE
540: , p4_a6 JTF_VARCHAR2_TABLE_200
541: , p4_a7 JTF_VARCHAR2_TABLE_200
542: , x_msg_count out nocopy NUMBER
543: , x_msg_data out nocopy VARCHAR2
544: , x_return_status out nocopy VARCHAR2
545: )
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
602: , p5_a7 JTF_VARCHAR2_TABLE_200
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
606: )
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
670: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_200
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
670: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_200
671: , p10_a7 out nocopy JTF_VARCHAR2_TABLE_100
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
673: , x_total_templates out nocopy NUMBER
674: , x_retrieved_template_num 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
812: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_200
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
812: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_200
813: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_100
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
815: )
816:
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
880: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_200
881: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_200
882: )
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
880: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_200
881: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_200
882: )
883:
884: as
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
880: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_200
881: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_200
882: )
883:
884: as
885: ddx_template_attributes cs_tp_templates_pvt.template_attribute_list;
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
945: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_200
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
949: ddx_template_links cs_tp_templates_pvt.template_link_list;
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
1009: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_200
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
1013: ddx_template_link_list cs_tp_templates_pvt.template_link_list;
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
1224: , p10_a7 out nocopy JTF_VARCHAR2_TABLE_200
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: )
1228:
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
1305: , p11_a7 out nocopy JTF_VARCHAR2_TABLE_200
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: )
1309:
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
1383: , p5_a7 JTF_VARCHAR2_TABLE_200
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
1387: )
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
1447: , p5_a7 JTF_VARCHAR2_TABLE_200
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
1451: )