DBA Data[Home] [Help]

APPS.CS_TP_TEMPLATES_PVT_W dependencies on JTF_VARCHAR2_TABLE_200

Line 24: , a2 JTF_VARCHAR2_TABLE_200

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

Line 25: , a3 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

Line 28: , a6 JTF_VARCHAR2_TABLE_200

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;

Line 59: , a2 out nocopy JTF_VARCHAR2_TABLE_200

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

Line 60: , a3 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

Line 63: , a6 out nocopy JTF_VARCHAR2_TABLE_200

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;

Line 72: a2 := JTF_VARCHAR2_TABLE_200();

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

Line 73: a3 := 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();

Line 76: a6 := JTF_VARCHAR2_TABLE_200();

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

Line 82: a2 := JTF_VARCHAR2_TABLE_200();

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

Line 83: a3 := 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();

Line 86: a6 := JTF_VARCHAR2_TABLE_200();

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

Line 125: , a4 JTF_VARCHAR2_TABLE_200

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

Line 127: , a6 JTF_VARCHAR2_TABLE_200

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

Line 128: , a7 JTF_VARCHAR2_TABLE_200

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

Line 158: , a4 out nocopy JTF_VARCHAR2_TABLE_200

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

Line 160: , a6 out nocopy JTF_VARCHAR2_TABLE_200

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

Line 161: , a7 out nocopy JTF_VARCHAR2_TABLE_200

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

Line 170: a4 := JTF_VARCHAR2_TABLE_200();

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

Line 172: a6 := JTF_VARCHAR2_TABLE_200();

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

Line 173: a7 := JTF_VARCHAR2_TABLE_200();

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

Line 179: a4 := JTF_VARCHAR2_TABLE_200();

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

Line 181: a6 := JTF_VARCHAR2_TABLE_200();

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

Line 182: a7 := JTF_VARCHAR2_TABLE_200();

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

Line 216: , a3 JTF_VARCHAR2_TABLE_200

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

Line 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

Line 249: , a3 out nocopy JTF_VARCHAR2_TABLE_200

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

Line 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

Line 261: a3 := JTF_VARCHAR2_TABLE_200();

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

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

Line 270: a3 := 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();
274: a7 := JTF_VARCHAR2_TABLE_200();

Line 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);

Line 538: , p4_a4 JTF_VARCHAR2_TABLE_200

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

Line 540: , p4_a6 JTF_VARCHAR2_TABLE_200

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

Line 541: , p4_a7 JTF_VARCHAR2_TABLE_200

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

Line 598: , p5_a3 JTF_VARCHAR2_TABLE_200

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

Line 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: )

Line 666: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_200

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

Line 667: , p10_a3 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

Line 670: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_200

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

Line 808: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_200

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

Line 809: , p7_a3 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

Line 812: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_200

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:

Line 878: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_200

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

Line 880: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_200

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

Line 881: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_200

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;

Line 941: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_200

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

Line 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;

Line 1005: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_200

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

Line 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;

Line 1220: , p10_a3 out nocopy JTF_VARCHAR2_TABLE_200

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

Line 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:

Line 1301: , p11_a3 out nocopy JTF_VARCHAR2_TABLE_200

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

Line 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:

Line 1379: , p5_a3 JTF_VARCHAR2_TABLE_200

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

Line 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: )

Line 1443: , p5_a3 JTF_VARCHAR2_TABLE_200

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

Line 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: )