APPS.JTS_SETUP_FLOW_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 23: , a1 JTF_VARCHAR2_TABLE_100

19: return d;
20: end;
21:
22: procedure rosetta_table_copy_in_p7(t out jts_setup_flow_pvt.setup_flow_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_NUMBER_TABLE

Line 24: , a2 JTF_VARCHAR2_TABLE_100

20: end;
21:
22: procedure rosetta_table_copy_in_p7(t out jts_setup_flow_pvt.setup_flow_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_VARCHAR2_TABLE_300

Line 30: , a8 JTF_VARCHAR2_TABLE_100

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

Line 31: , a9 JTF_VARCHAR2_TABLE_100

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

Line 33: , a11 JTF_VARCHAR2_TABLE_100

29: , a7 JTF_VARCHAR2_TABLE_300
30: , a8 JTF_VARCHAR2_TABLE_100
31: , a9 JTF_VARCHAR2_TABLE_100
32: , a10 JTF_NUMBER_TABLE
33: , a11 JTF_VARCHAR2_TABLE_100
34: , a12 JTF_VARCHAR2_TABLE_100
35: ) as
36: ddindx binary_integer; indx binary_integer;
37: begin

Line 34: , a12 JTF_VARCHAR2_TABLE_100

30: , a8 JTF_VARCHAR2_TABLE_100
31: , a9 JTF_VARCHAR2_TABLE_100
32: , a10 JTF_NUMBER_TABLE
33: , a11 JTF_VARCHAR2_TABLE_100
34: , a12 JTF_VARCHAR2_TABLE_100
35: ) as
36: ddindx binary_integer; indx binary_integer;
37: begin
38: if a0 is not null and a0.count > 0 then

Line 66: , a1 out JTF_VARCHAR2_TABLE_100

62: end if;
63: end if;
64: end rosetta_table_copy_in_p7;
65: procedure rosetta_table_copy_out_p7(t jts_setup_flow_pvt.setup_flow_tbl_type, a0 out JTF_NUMBER_TABLE
66: , a1 out JTF_VARCHAR2_TABLE_100
67: , a2 out JTF_VARCHAR2_TABLE_100
68: , a3 out JTF_NUMBER_TABLE
69: , a4 out JTF_NUMBER_TABLE
70: , a5 out JTF_NUMBER_TABLE

Line 67: , a2 out JTF_VARCHAR2_TABLE_100

63: end if;
64: end rosetta_table_copy_in_p7;
65: procedure rosetta_table_copy_out_p7(t jts_setup_flow_pvt.setup_flow_tbl_type, a0 out JTF_NUMBER_TABLE
66: , a1 out JTF_VARCHAR2_TABLE_100
67: , a2 out JTF_VARCHAR2_TABLE_100
68: , a3 out JTF_NUMBER_TABLE
69: , a4 out JTF_NUMBER_TABLE
70: , a5 out JTF_NUMBER_TABLE
71: , a6 out JTF_VARCHAR2_TABLE_300

Line 73: , a8 out JTF_VARCHAR2_TABLE_100

69: , a4 out JTF_NUMBER_TABLE
70: , a5 out JTF_NUMBER_TABLE
71: , a6 out JTF_VARCHAR2_TABLE_300
72: , a7 out JTF_VARCHAR2_TABLE_300
73: , a8 out JTF_VARCHAR2_TABLE_100
74: , a9 out JTF_VARCHAR2_TABLE_100
75: , a10 out JTF_NUMBER_TABLE
76: , a11 out JTF_VARCHAR2_TABLE_100
77: , a12 out JTF_VARCHAR2_TABLE_100

Line 74: , a9 out JTF_VARCHAR2_TABLE_100

70: , a5 out JTF_NUMBER_TABLE
71: , a6 out JTF_VARCHAR2_TABLE_300
72: , a7 out JTF_VARCHAR2_TABLE_300
73: , a8 out JTF_VARCHAR2_TABLE_100
74: , a9 out JTF_VARCHAR2_TABLE_100
75: , a10 out JTF_NUMBER_TABLE
76: , a11 out JTF_VARCHAR2_TABLE_100
77: , a12 out JTF_VARCHAR2_TABLE_100
78: ) as

Line 76: , a11 out JTF_VARCHAR2_TABLE_100

72: , a7 out JTF_VARCHAR2_TABLE_300
73: , a8 out JTF_VARCHAR2_TABLE_100
74: , a9 out JTF_VARCHAR2_TABLE_100
75: , a10 out JTF_NUMBER_TABLE
76: , a11 out JTF_VARCHAR2_TABLE_100
77: , a12 out JTF_VARCHAR2_TABLE_100
78: ) as
79: ddindx binary_integer; indx binary_integer;
80: begin

Line 77: , a12 out JTF_VARCHAR2_TABLE_100

73: , a8 out JTF_VARCHAR2_TABLE_100
74: , a9 out JTF_VARCHAR2_TABLE_100
75: , a10 out JTF_NUMBER_TABLE
76: , a11 out JTF_VARCHAR2_TABLE_100
77: , a12 out JTF_VARCHAR2_TABLE_100
78: ) as
79: ddindx binary_integer; indx binary_integer;
80: begin
81: if t is null or t.count = 0 then

Line 83: a1 := JTF_VARCHAR2_TABLE_100();

79: ddindx binary_integer; indx binary_integer;
80: begin
81: if t is null or t.count = 0 then
82: a0 := JTF_NUMBER_TABLE();
83: a1 := JTF_VARCHAR2_TABLE_100();
84: a2 := JTF_VARCHAR2_TABLE_100();
85: a3 := JTF_NUMBER_TABLE();
86: a4 := JTF_NUMBER_TABLE();
87: a5 := JTF_NUMBER_TABLE();

Line 84: a2 := JTF_VARCHAR2_TABLE_100();

80: begin
81: if t is null or t.count = 0 then
82: a0 := JTF_NUMBER_TABLE();
83: a1 := JTF_VARCHAR2_TABLE_100();
84: a2 := JTF_VARCHAR2_TABLE_100();
85: a3 := JTF_NUMBER_TABLE();
86: a4 := JTF_NUMBER_TABLE();
87: a5 := JTF_NUMBER_TABLE();
88: a6 := JTF_VARCHAR2_TABLE_300();

Line 90: a8 := JTF_VARCHAR2_TABLE_100();

86: a4 := JTF_NUMBER_TABLE();
87: a5 := JTF_NUMBER_TABLE();
88: a6 := JTF_VARCHAR2_TABLE_300();
89: a7 := JTF_VARCHAR2_TABLE_300();
90: a8 := JTF_VARCHAR2_TABLE_100();
91: a9 := JTF_VARCHAR2_TABLE_100();
92: a10 := JTF_NUMBER_TABLE();
93: a11 := JTF_VARCHAR2_TABLE_100();
94: a12 := JTF_VARCHAR2_TABLE_100();

Line 91: a9 := JTF_VARCHAR2_TABLE_100();

87: a5 := JTF_NUMBER_TABLE();
88: a6 := JTF_VARCHAR2_TABLE_300();
89: a7 := JTF_VARCHAR2_TABLE_300();
90: a8 := JTF_VARCHAR2_TABLE_100();
91: a9 := JTF_VARCHAR2_TABLE_100();
92: a10 := JTF_NUMBER_TABLE();
93: a11 := JTF_VARCHAR2_TABLE_100();
94: a12 := JTF_VARCHAR2_TABLE_100();
95: else

Line 93: a11 := JTF_VARCHAR2_TABLE_100();

89: a7 := JTF_VARCHAR2_TABLE_300();
90: a8 := JTF_VARCHAR2_TABLE_100();
91: a9 := JTF_VARCHAR2_TABLE_100();
92: a10 := JTF_NUMBER_TABLE();
93: a11 := JTF_VARCHAR2_TABLE_100();
94: a12 := JTF_VARCHAR2_TABLE_100();
95: else
96: a0 := JTF_NUMBER_TABLE();
97: a1 := JTF_VARCHAR2_TABLE_100();

Line 94: a12 := JTF_VARCHAR2_TABLE_100();

90: a8 := JTF_VARCHAR2_TABLE_100();
91: a9 := JTF_VARCHAR2_TABLE_100();
92: a10 := JTF_NUMBER_TABLE();
93: a11 := JTF_VARCHAR2_TABLE_100();
94: a12 := JTF_VARCHAR2_TABLE_100();
95: else
96: a0 := JTF_NUMBER_TABLE();
97: a1 := JTF_VARCHAR2_TABLE_100();
98: a2 := JTF_VARCHAR2_TABLE_100();

Line 97: a1 := JTF_VARCHAR2_TABLE_100();

93: a11 := JTF_VARCHAR2_TABLE_100();
94: a12 := JTF_VARCHAR2_TABLE_100();
95: else
96: a0 := JTF_NUMBER_TABLE();
97: a1 := JTF_VARCHAR2_TABLE_100();
98: a2 := JTF_VARCHAR2_TABLE_100();
99: a3 := JTF_NUMBER_TABLE();
100: a4 := JTF_NUMBER_TABLE();
101: a5 := JTF_NUMBER_TABLE();

Line 98: a2 := JTF_VARCHAR2_TABLE_100();

94: a12 := JTF_VARCHAR2_TABLE_100();
95: else
96: a0 := JTF_NUMBER_TABLE();
97: a1 := JTF_VARCHAR2_TABLE_100();
98: a2 := JTF_VARCHAR2_TABLE_100();
99: a3 := JTF_NUMBER_TABLE();
100: a4 := JTF_NUMBER_TABLE();
101: a5 := JTF_NUMBER_TABLE();
102: a6 := JTF_VARCHAR2_TABLE_300();

Line 104: a8 := JTF_VARCHAR2_TABLE_100();

100: a4 := JTF_NUMBER_TABLE();
101: a5 := JTF_NUMBER_TABLE();
102: a6 := JTF_VARCHAR2_TABLE_300();
103: a7 := JTF_VARCHAR2_TABLE_300();
104: a8 := JTF_VARCHAR2_TABLE_100();
105: a9 := JTF_VARCHAR2_TABLE_100();
106: a10 := JTF_NUMBER_TABLE();
107: a11 := JTF_VARCHAR2_TABLE_100();
108: a12 := JTF_VARCHAR2_TABLE_100();

Line 105: a9 := JTF_VARCHAR2_TABLE_100();

101: a5 := JTF_NUMBER_TABLE();
102: a6 := JTF_VARCHAR2_TABLE_300();
103: a7 := JTF_VARCHAR2_TABLE_300();
104: a8 := JTF_VARCHAR2_TABLE_100();
105: a9 := JTF_VARCHAR2_TABLE_100();
106: a10 := JTF_NUMBER_TABLE();
107: a11 := JTF_VARCHAR2_TABLE_100();
108: a12 := JTF_VARCHAR2_TABLE_100();
109: if t.count > 0 then

Line 107: a11 := JTF_VARCHAR2_TABLE_100();

103: a7 := JTF_VARCHAR2_TABLE_300();
104: a8 := JTF_VARCHAR2_TABLE_100();
105: a9 := JTF_VARCHAR2_TABLE_100();
106: a10 := JTF_NUMBER_TABLE();
107: a11 := JTF_VARCHAR2_TABLE_100();
108: a12 := JTF_VARCHAR2_TABLE_100();
109: if t.count > 0 then
110: a0.extend(t.count);
111: a1.extend(t.count);

Line 108: a12 := JTF_VARCHAR2_TABLE_100();

104: a8 := JTF_VARCHAR2_TABLE_100();
105: a9 := JTF_VARCHAR2_TABLE_100();
106: a10 := JTF_NUMBER_TABLE();
107: a11 := JTF_VARCHAR2_TABLE_100();
108: a12 := JTF_VARCHAR2_TABLE_100();
109: if t.count > 0 then
110: a0.extend(t.count);
111: a1.extend(t.count);
112: a2.extend(t.count);

Line 150: , a1 JTF_VARCHAR2_TABLE_100

146: end if;
147: end rosetta_table_copy_out_p7;
148:
149: procedure rosetta_table_copy_in_p8(t out jts_setup_flow_pvt.flow_tbl_type, a0 JTF_NUMBER_TABLE
150: , a1 JTF_VARCHAR2_TABLE_100
151: , a2 JTF_VARCHAR2_TABLE_100
152: , a3 JTF_NUMBER_TABLE
153: , a4 JTF_NUMBER_TABLE
154: , a5 JTF_NUMBER_TABLE

Line 151: , a2 JTF_VARCHAR2_TABLE_100

147: end rosetta_table_copy_out_p7;
148:
149: procedure rosetta_table_copy_in_p8(t out jts_setup_flow_pvt.flow_tbl_type, a0 JTF_NUMBER_TABLE
150: , a1 JTF_VARCHAR2_TABLE_100
151: , a2 JTF_VARCHAR2_TABLE_100
152: , a3 JTF_NUMBER_TABLE
153: , a4 JTF_NUMBER_TABLE
154: , a5 JTF_NUMBER_TABLE
155: , a6 JTF_VARCHAR2_TABLE_300

Line 157: , a8 JTF_VARCHAR2_TABLE_100

153: , a4 JTF_NUMBER_TABLE
154: , a5 JTF_NUMBER_TABLE
155: , a6 JTF_VARCHAR2_TABLE_300
156: , a7 JTF_VARCHAR2_TABLE_300
157: , a8 JTF_VARCHAR2_TABLE_100
158: , a9 JTF_VARCHAR2_TABLE_100
159: , a10 JTF_NUMBER_TABLE
160: , a11 JTF_VARCHAR2_TABLE_100
161: , a12 JTF_VARCHAR2_TABLE_100

Line 158: , a9 JTF_VARCHAR2_TABLE_100

154: , a5 JTF_NUMBER_TABLE
155: , a6 JTF_VARCHAR2_TABLE_300
156: , a7 JTF_VARCHAR2_TABLE_300
157: , a8 JTF_VARCHAR2_TABLE_100
158: , a9 JTF_VARCHAR2_TABLE_100
159: , a10 JTF_NUMBER_TABLE
160: , a11 JTF_VARCHAR2_TABLE_100
161: , a12 JTF_VARCHAR2_TABLE_100
162: , a13 JTF_NUMBER_TABLE

Line 160: , a11 JTF_VARCHAR2_TABLE_100

156: , a7 JTF_VARCHAR2_TABLE_300
157: , a8 JTF_VARCHAR2_TABLE_100
158: , a9 JTF_VARCHAR2_TABLE_100
159: , a10 JTF_NUMBER_TABLE
160: , a11 JTF_VARCHAR2_TABLE_100
161: , a12 JTF_VARCHAR2_TABLE_100
162: , a13 JTF_NUMBER_TABLE
163: , a14 JTF_VARCHAR2_TABLE_100
164: , a15 JTF_DATE_TABLE

Line 161: , a12 JTF_VARCHAR2_TABLE_100

157: , a8 JTF_VARCHAR2_TABLE_100
158: , a9 JTF_VARCHAR2_TABLE_100
159: , a10 JTF_NUMBER_TABLE
160: , a11 JTF_VARCHAR2_TABLE_100
161: , a12 JTF_VARCHAR2_TABLE_100
162: , a13 JTF_NUMBER_TABLE
163: , a14 JTF_VARCHAR2_TABLE_100
164: , a15 JTF_DATE_TABLE
165: , a16 JTF_DATE_TABLE

Line 163: , a14 JTF_VARCHAR2_TABLE_100

159: , a10 JTF_NUMBER_TABLE
160: , a11 JTF_VARCHAR2_TABLE_100
161: , a12 JTF_VARCHAR2_TABLE_100
162: , a13 JTF_NUMBER_TABLE
163: , a14 JTF_VARCHAR2_TABLE_100
164: , a15 JTF_DATE_TABLE
165: , a16 JTF_DATE_TABLE
166: , a17 JTF_VARCHAR2_TABLE_100
167: , a18 JTF_VARCHAR2_TABLE_100

Line 166: , a17 JTF_VARCHAR2_TABLE_100

162: , a13 JTF_NUMBER_TABLE
163: , a14 JTF_VARCHAR2_TABLE_100
164: , a15 JTF_DATE_TABLE
165: , a16 JTF_DATE_TABLE
166: , a17 JTF_VARCHAR2_TABLE_100
167: , a18 JTF_VARCHAR2_TABLE_100
168: ) as
169: ddindx binary_integer; indx binary_integer;
170: begin

Line 167: , a18 JTF_VARCHAR2_TABLE_100

163: , a14 JTF_VARCHAR2_TABLE_100
164: , a15 JTF_DATE_TABLE
165: , a16 JTF_DATE_TABLE
166: , a17 JTF_VARCHAR2_TABLE_100
167: , a18 JTF_VARCHAR2_TABLE_100
168: ) as
169: ddindx binary_integer; indx binary_integer;
170: begin
171: if a0 is not null and a0.count > 0 then

Line 205: , a1 out JTF_VARCHAR2_TABLE_100

201: end if;
202: end if;
203: end rosetta_table_copy_in_p8;
204: procedure rosetta_table_copy_out_p8(t jts_setup_flow_pvt.flow_tbl_type, a0 out JTF_NUMBER_TABLE
205: , a1 out JTF_VARCHAR2_TABLE_100
206: , a2 out JTF_VARCHAR2_TABLE_100
207: , a3 out JTF_NUMBER_TABLE
208: , a4 out JTF_NUMBER_TABLE
209: , a5 out JTF_NUMBER_TABLE

Line 206: , a2 out JTF_VARCHAR2_TABLE_100

202: end if;
203: end rosetta_table_copy_in_p8;
204: procedure rosetta_table_copy_out_p8(t jts_setup_flow_pvt.flow_tbl_type, a0 out JTF_NUMBER_TABLE
205: , a1 out JTF_VARCHAR2_TABLE_100
206: , a2 out JTF_VARCHAR2_TABLE_100
207: , a3 out JTF_NUMBER_TABLE
208: , a4 out JTF_NUMBER_TABLE
209: , a5 out JTF_NUMBER_TABLE
210: , a6 out JTF_VARCHAR2_TABLE_300

Line 212: , a8 out JTF_VARCHAR2_TABLE_100

208: , a4 out JTF_NUMBER_TABLE
209: , a5 out JTF_NUMBER_TABLE
210: , a6 out JTF_VARCHAR2_TABLE_300
211: , a7 out JTF_VARCHAR2_TABLE_300
212: , a8 out JTF_VARCHAR2_TABLE_100
213: , a9 out JTF_VARCHAR2_TABLE_100
214: , a10 out JTF_NUMBER_TABLE
215: , a11 out JTF_VARCHAR2_TABLE_100
216: , a12 out JTF_VARCHAR2_TABLE_100

Line 213: , a9 out JTF_VARCHAR2_TABLE_100

209: , a5 out JTF_NUMBER_TABLE
210: , a6 out JTF_VARCHAR2_TABLE_300
211: , a7 out JTF_VARCHAR2_TABLE_300
212: , a8 out JTF_VARCHAR2_TABLE_100
213: , a9 out JTF_VARCHAR2_TABLE_100
214: , a10 out JTF_NUMBER_TABLE
215: , a11 out JTF_VARCHAR2_TABLE_100
216: , a12 out JTF_VARCHAR2_TABLE_100
217: , a13 out JTF_NUMBER_TABLE

Line 215: , a11 out JTF_VARCHAR2_TABLE_100

211: , a7 out JTF_VARCHAR2_TABLE_300
212: , a8 out JTF_VARCHAR2_TABLE_100
213: , a9 out JTF_VARCHAR2_TABLE_100
214: , a10 out JTF_NUMBER_TABLE
215: , a11 out JTF_VARCHAR2_TABLE_100
216: , a12 out JTF_VARCHAR2_TABLE_100
217: , a13 out JTF_NUMBER_TABLE
218: , a14 out JTF_VARCHAR2_TABLE_100
219: , a15 out JTF_DATE_TABLE

Line 216: , a12 out JTF_VARCHAR2_TABLE_100

212: , a8 out JTF_VARCHAR2_TABLE_100
213: , a9 out JTF_VARCHAR2_TABLE_100
214: , a10 out JTF_NUMBER_TABLE
215: , a11 out JTF_VARCHAR2_TABLE_100
216: , a12 out JTF_VARCHAR2_TABLE_100
217: , a13 out JTF_NUMBER_TABLE
218: , a14 out JTF_VARCHAR2_TABLE_100
219: , a15 out JTF_DATE_TABLE
220: , a16 out JTF_DATE_TABLE

Line 218: , a14 out JTF_VARCHAR2_TABLE_100

214: , a10 out JTF_NUMBER_TABLE
215: , a11 out JTF_VARCHAR2_TABLE_100
216: , a12 out JTF_VARCHAR2_TABLE_100
217: , a13 out JTF_NUMBER_TABLE
218: , a14 out JTF_VARCHAR2_TABLE_100
219: , a15 out JTF_DATE_TABLE
220: , a16 out JTF_DATE_TABLE
221: , a17 out JTF_VARCHAR2_TABLE_100
222: , a18 out JTF_VARCHAR2_TABLE_100

Line 221: , a17 out JTF_VARCHAR2_TABLE_100

217: , a13 out JTF_NUMBER_TABLE
218: , a14 out JTF_VARCHAR2_TABLE_100
219: , a15 out JTF_DATE_TABLE
220: , a16 out JTF_DATE_TABLE
221: , a17 out JTF_VARCHAR2_TABLE_100
222: , a18 out JTF_VARCHAR2_TABLE_100
223: ) as
224: ddindx binary_integer; indx binary_integer;
225: begin

Line 222: , a18 out JTF_VARCHAR2_TABLE_100

218: , a14 out JTF_VARCHAR2_TABLE_100
219: , a15 out JTF_DATE_TABLE
220: , a16 out JTF_DATE_TABLE
221: , a17 out JTF_VARCHAR2_TABLE_100
222: , a18 out JTF_VARCHAR2_TABLE_100
223: ) as
224: ddindx binary_integer; indx binary_integer;
225: begin
226: if t is null or t.count = 0 then

Line 228: a1 := JTF_VARCHAR2_TABLE_100();

224: ddindx binary_integer; indx binary_integer;
225: begin
226: if t is null or t.count = 0 then
227: a0 := JTF_NUMBER_TABLE();
228: a1 := JTF_VARCHAR2_TABLE_100();
229: a2 := JTF_VARCHAR2_TABLE_100();
230: a3 := JTF_NUMBER_TABLE();
231: a4 := JTF_NUMBER_TABLE();
232: a5 := JTF_NUMBER_TABLE();

Line 229: a2 := JTF_VARCHAR2_TABLE_100();

225: begin
226: if t is null or t.count = 0 then
227: a0 := JTF_NUMBER_TABLE();
228: a1 := JTF_VARCHAR2_TABLE_100();
229: a2 := JTF_VARCHAR2_TABLE_100();
230: a3 := JTF_NUMBER_TABLE();
231: a4 := JTF_NUMBER_TABLE();
232: a5 := JTF_NUMBER_TABLE();
233: a6 := JTF_VARCHAR2_TABLE_300();

Line 235: a8 := JTF_VARCHAR2_TABLE_100();

231: a4 := JTF_NUMBER_TABLE();
232: a5 := JTF_NUMBER_TABLE();
233: a6 := JTF_VARCHAR2_TABLE_300();
234: a7 := JTF_VARCHAR2_TABLE_300();
235: a8 := JTF_VARCHAR2_TABLE_100();
236: a9 := JTF_VARCHAR2_TABLE_100();
237: a10 := JTF_NUMBER_TABLE();
238: a11 := JTF_VARCHAR2_TABLE_100();
239: a12 := JTF_VARCHAR2_TABLE_100();

Line 236: a9 := JTF_VARCHAR2_TABLE_100();

232: a5 := JTF_NUMBER_TABLE();
233: a6 := JTF_VARCHAR2_TABLE_300();
234: a7 := JTF_VARCHAR2_TABLE_300();
235: a8 := JTF_VARCHAR2_TABLE_100();
236: a9 := JTF_VARCHAR2_TABLE_100();
237: a10 := JTF_NUMBER_TABLE();
238: a11 := JTF_VARCHAR2_TABLE_100();
239: a12 := JTF_VARCHAR2_TABLE_100();
240: a13 := JTF_NUMBER_TABLE();

Line 238: a11 := JTF_VARCHAR2_TABLE_100();

234: a7 := JTF_VARCHAR2_TABLE_300();
235: a8 := JTF_VARCHAR2_TABLE_100();
236: a9 := JTF_VARCHAR2_TABLE_100();
237: a10 := JTF_NUMBER_TABLE();
238: a11 := JTF_VARCHAR2_TABLE_100();
239: a12 := JTF_VARCHAR2_TABLE_100();
240: a13 := JTF_NUMBER_TABLE();
241: a14 := JTF_VARCHAR2_TABLE_100();
242: a15 := JTF_DATE_TABLE();

Line 239: a12 := JTF_VARCHAR2_TABLE_100();

235: a8 := JTF_VARCHAR2_TABLE_100();
236: a9 := JTF_VARCHAR2_TABLE_100();
237: a10 := JTF_NUMBER_TABLE();
238: a11 := JTF_VARCHAR2_TABLE_100();
239: a12 := JTF_VARCHAR2_TABLE_100();
240: a13 := JTF_NUMBER_TABLE();
241: a14 := JTF_VARCHAR2_TABLE_100();
242: a15 := JTF_DATE_TABLE();
243: a16 := JTF_DATE_TABLE();

Line 241: a14 := JTF_VARCHAR2_TABLE_100();

237: a10 := JTF_NUMBER_TABLE();
238: a11 := JTF_VARCHAR2_TABLE_100();
239: a12 := JTF_VARCHAR2_TABLE_100();
240: a13 := JTF_NUMBER_TABLE();
241: a14 := JTF_VARCHAR2_TABLE_100();
242: a15 := JTF_DATE_TABLE();
243: a16 := JTF_DATE_TABLE();
244: a17 := JTF_VARCHAR2_TABLE_100();
245: a18 := JTF_VARCHAR2_TABLE_100();

Line 244: a17 := JTF_VARCHAR2_TABLE_100();

240: a13 := JTF_NUMBER_TABLE();
241: a14 := JTF_VARCHAR2_TABLE_100();
242: a15 := JTF_DATE_TABLE();
243: a16 := JTF_DATE_TABLE();
244: a17 := JTF_VARCHAR2_TABLE_100();
245: a18 := JTF_VARCHAR2_TABLE_100();
246: else
247: a0 := JTF_NUMBER_TABLE();
248: a1 := JTF_VARCHAR2_TABLE_100();

Line 245: a18 := JTF_VARCHAR2_TABLE_100();

241: a14 := JTF_VARCHAR2_TABLE_100();
242: a15 := JTF_DATE_TABLE();
243: a16 := JTF_DATE_TABLE();
244: a17 := JTF_VARCHAR2_TABLE_100();
245: a18 := JTF_VARCHAR2_TABLE_100();
246: else
247: a0 := JTF_NUMBER_TABLE();
248: a1 := JTF_VARCHAR2_TABLE_100();
249: a2 := JTF_VARCHAR2_TABLE_100();

Line 248: a1 := JTF_VARCHAR2_TABLE_100();

244: a17 := JTF_VARCHAR2_TABLE_100();
245: a18 := JTF_VARCHAR2_TABLE_100();
246: else
247: a0 := JTF_NUMBER_TABLE();
248: a1 := JTF_VARCHAR2_TABLE_100();
249: a2 := JTF_VARCHAR2_TABLE_100();
250: a3 := JTF_NUMBER_TABLE();
251: a4 := JTF_NUMBER_TABLE();
252: a5 := JTF_NUMBER_TABLE();

Line 249: a2 := JTF_VARCHAR2_TABLE_100();

245: a18 := JTF_VARCHAR2_TABLE_100();
246: else
247: a0 := JTF_NUMBER_TABLE();
248: a1 := JTF_VARCHAR2_TABLE_100();
249: a2 := JTF_VARCHAR2_TABLE_100();
250: a3 := JTF_NUMBER_TABLE();
251: a4 := JTF_NUMBER_TABLE();
252: a5 := JTF_NUMBER_TABLE();
253: a6 := JTF_VARCHAR2_TABLE_300();

Line 255: a8 := JTF_VARCHAR2_TABLE_100();

251: a4 := JTF_NUMBER_TABLE();
252: a5 := JTF_NUMBER_TABLE();
253: a6 := JTF_VARCHAR2_TABLE_300();
254: a7 := JTF_VARCHAR2_TABLE_300();
255: a8 := JTF_VARCHAR2_TABLE_100();
256: a9 := JTF_VARCHAR2_TABLE_100();
257: a10 := JTF_NUMBER_TABLE();
258: a11 := JTF_VARCHAR2_TABLE_100();
259: a12 := JTF_VARCHAR2_TABLE_100();

Line 256: a9 := JTF_VARCHAR2_TABLE_100();

252: a5 := JTF_NUMBER_TABLE();
253: a6 := JTF_VARCHAR2_TABLE_300();
254: a7 := JTF_VARCHAR2_TABLE_300();
255: a8 := JTF_VARCHAR2_TABLE_100();
256: a9 := JTF_VARCHAR2_TABLE_100();
257: a10 := JTF_NUMBER_TABLE();
258: a11 := JTF_VARCHAR2_TABLE_100();
259: a12 := JTF_VARCHAR2_TABLE_100();
260: a13 := JTF_NUMBER_TABLE();

Line 258: a11 := JTF_VARCHAR2_TABLE_100();

254: a7 := JTF_VARCHAR2_TABLE_300();
255: a8 := JTF_VARCHAR2_TABLE_100();
256: a9 := JTF_VARCHAR2_TABLE_100();
257: a10 := JTF_NUMBER_TABLE();
258: a11 := JTF_VARCHAR2_TABLE_100();
259: a12 := JTF_VARCHAR2_TABLE_100();
260: a13 := JTF_NUMBER_TABLE();
261: a14 := JTF_VARCHAR2_TABLE_100();
262: a15 := JTF_DATE_TABLE();

Line 259: a12 := JTF_VARCHAR2_TABLE_100();

255: a8 := JTF_VARCHAR2_TABLE_100();
256: a9 := JTF_VARCHAR2_TABLE_100();
257: a10 := JTF_NUMBER_TABLE();
258: a11 := JTF_VARCHAR2_TABLE_100();
259: a12 := JTF_VARCHAR2_TABLE_100();
260: a13 := JTF_NUMBER_TABLE();
261: a14 := JTF_VARCHAR2_TABLE_100();
262: a15 := JTF_DATE_TABLE();
263: a16 := JTF_DATE_TABLE();

Line 261: a14 := JTF_VARCHAR2_TABLE_100();

257: a10 := JTF_NUMBER_TABLE();
258: a11 := JTF_VARCHAR2_TABLE_100();
259: a12 := JTF_VARCHAR2_TABLE_100();
260: a13 := JTF_NUMBER_TABLE();
261: a14 := JTF_VARCHAR2_TABLE_100();
262: a15 := JTF_DATE_TABLE();
263: a16 := JTF_DATE_TABLE();
264: a17 := JTF_VARCHAR2_TABLE_100();
265: a18 := JTF_VARCHAR2_TABLE_100();

Line 264: a17 := JTF_VARCHAR2_TABLE_100();

260: a13 := JTF_NUMBER_TABLE();
261: a14 := JTF_VARCHAR2_TABLE_100();
262: a15 := JTF_DATE_TABLE();
263: a16 := JTF_DATE_TABLE();
264: a17 := JTF_VARCHAR2_TABLE_100();
265: a18 := JTF_VARCHAR2_TABLE_100();
266: if t.count > 0 then
267: a0.extend(t.count);
268: a1.extend(t.count);

Line 265: a18 := JTF_VARCHAR2_TABLE_100();

261: a14 := JTF_VARCHAR2_TABLE_100();
262: a15 := JTF_DATE_TABLE();
263: a16 := JTF_DATE_TABLE();
264: a17 := JTF_VARCHAR2_TABLE_100();
265: a18 := JTF_VARCHAR2_TABLE_100();
266: if t.count > 0 then
267: a0.extend(t.count);
268: a1.extend(t.count);
269: a2.extend(t.count);

Line 319: , a1 JTF_VARCHAR2_TABLE_100

315: end if;
316: end rosetta_table_copy_out_p8;
317:
318: procedure rosetta_table_copy_in_p9(t out jts_setup_flow_pvt.root_setup_flow_tbl_type, a0 JTF_NUMBER_TABLE
319: , a1 JTF_VARCHAR2_TABLE_100
320: , a2 JTF_VARCHAR2_TABLE_100
321: ) as
322: ddindx binary_integer; indx binary_integer;
323: begin

Line 320: , a2 JTF_VARCHAR2_TABLE_100

316: end rosetta_table_copy_out_p8;
317:
318: procedure rosetta_table_copy_in_p9(t out jts_setup_flow_pvt.root_setup_flow_tbl_type, a0 JTF_NUMBER_TABLE
319: , a1 JTF_VARCHAR2_TABLE_100
320: , a2 JTF_VARCHAR2_TABLE_100
321: ) as
322: ddindx binary_integer; indx binary_integer;
323: begin
324: if a0 is not null and a0.count > 0 then

Line 342: , a1 out JTF_VARCHAR2_TABLE_100

338: end if;
339: end if;
340: end rosetta_table_copy_in_p9;
341: procedure rosetta_table_copy_out_p9(t jts_setup_flow_pvt.root_setup_flow_tbl_type, a0 out JTF_NUMBER_TABLE
342: , a1 out JTF_VARCHAR2_TABLE_100
343: , a2 out JTF_VARCHAR2_TABLE_100
344: ) as
345: ddindx binary_integer; indx binary_integer;
346: begin

Line 343: , a2 out JTF_VARCHAR2_TABLE_100

339: end if;
340: end rosetta_table_copy_in_p9;
341: procedure rosetta_table_copy_out_p9(t jts_setup_flow_pvt.root_setup_flow_tbl_type, a0 out JTF_NUMBER_TABLE
342: , a1 out JTF_VARCHAR2_TABLE_100
343: , a2 out JTF_VARCHAR2_TABLE_100
344: ) as
345: ddindx binary_integer; indx binary_integer;
346: begin
347: if t is null or t.count = 0 then

Line 349: a1 := JTF_VARCHAR2_TABLE_100();

345: ddindx binary_integer; indx binary_integer;
346: begin
347: if t is null or t.count = 0 then
348: a0 := JTF_NUMBER_TABLE();
349: a1 := JTF_VARCHAR2_TABLE_100();
350: a2 := JTF_VARCHAR2_TABLE_100();
351: else
352: a0 := JTF_NUMBER_TABLE();
353: a1 := JTF_VARCHAR2_TABLE_100();

Line 350: a2 := JTF_VARCHAR2_TABLE_100();

346: begin
347: if t is null or t.count = 0 then
348: a0 := JTF_NUMBER_TABLE();
349: a1 := JTF_VARCHAR2_TABLE_100();
350: a2 := JTF_VARCHAR2_TABLE_100();
351: else
352: a0 := JTF_NUMBER_TABLE();
353: a1 := JTF_VARCHAR2_TABLE_100();
354: a2 := JTF_VARCHAR2_TABLE_100();

Line 353: a1 := JTF_VARCHAR2_TABLE_100();

349: a1 := JTF_VARCHAR2_TABLE_100();
350: a2 := JTF_VARCHAR2_TABLE_100();
351: else
352: a0 := JTF_NUMBER_TABLE();
353: a1 := JTF_VARCHAR2_TABLE_100();
354: a2 := JTF_VARCHAR2_TABLE_100();
355: if t.count > 0 then
356: a0.extend(t.count);
357: a1.extend(t.count);

Line 354: a2 := JTF_VARCHAR2_TABLE_100();

350: a2 := JTF_VARCHAR2_TABLE_100();
351: else
352: a0 := JTF_NUMBER_TABLE();
353: a1 := JTF_VARCHAR2_TABLE_100();
354: a2 := JTF_VARCHAR2_TABLE_100();
355: if t.count > 0 then
356: a0.extend(t.count);
357: a1.extend(t.count);
358: a2.extend(t.count);

Line 377: , p1_a1 out JTF_VARCHAR2_TABLE_100

373: end rosetta_table_copy_out_p9;
374:
375: procedure get_flow_root_flows(p_api_version NUMBER
376: , p1_a0 out JTF_NUMBER_TABLE
377: , p1_a1 out JTF_VARCHAR2_TABLE_100
378: , p1_a2 out JTF_VARCHAR2_TABLE_100
379: )
380:
381: as

Line 378: , p1_a2 out JTF_VARCHAR2_TABLE_100

374:
375: procedure get_flow_root_flows(p_api_version NUMBER
376: , p1_a0 out JTF_NUMBER_TABLE
377: , p1_a1 out JTF_VARCHAR2_TABLE_100
378: , p1_a2 out JTF_VARCHAR2_TABLE_100
379: )
380:
381: as
382: ddx_flow_tbl jts_setup_flow_pvt.root_setup_flow_tbl_type;

Line 403: , p1_a1 out JTF_VARCHAR2_TABLE_100

399: end;
400:
401: procedure get_module_root_flows(p_api_version NUMBER
402: , p1_a0 out JTF_NUMBER_TABLE
403: , p1_a1 out JTF_VARCHAR2_TABLE_100
404: , p1_a2 out JTF_VARCHAR2_TABLE_100
405: )
406:
407: as

Line 404: , p1_a2 out JTF_VARCHAR2_TABLE_100

400:
401: procedure get_module_root_flows(p_api_version NUMBER
402: , p1_a0 out JTF_NUMBER_TABLE
403: , p1_a1 out JTF_VARCHAR2_TABLE_100
404: , p1_a2 out JTF_VARCHAR2_TABLE_100
405: )
406:
407: as
408: ddx_flow_tbl jts_setup_flow_pvt.root_setup_flow_tbl_type;

Line 430: , p2_a1 out JTF_VARCHAR2_TABLE_100

426:
427: procedure get_flow_hiearchy(p_api_version NUMBER
428: , p_flow_id NUMBER
429: , p2_a0 out JTF_NUMBER_TABLE
430: , p2_a1 out JTF_VARCHAR2_TABLE_100
431: , p2_a2 out JTF_VARCHAR2_TABLE_100
432: , p2_a3 out JTF_NUMBER_TABLE
433: , p2_a4 out JTF_NUMBER_TABLE
434: , p2_a5 out JTF_NUMBER_TABLE

Line 431: , p2_a2 out JTF_VARCHAR2_TABLE_100

427: procedure get_flow_hiearchy(p_api_version NUMBER
428: , p_flow_id NUMBER
429: , p2_a0 out JTF_NUMBER_TABLE
430: , p2_a1 out JTF_VARCHAR2_TABLE_100
431: , p2_a2 out JTF_VARCHAR2_TABLE_100
432: , p2_a3 out JTF_NUMBER_TABLE
433: , p2_a4 out JTF_NUMBER_TABLE
434: , p2_a5 out JTF_NUMBER_TABLE
435: , p2_a6 out JTF_VARCHAR2_TABLE_300

Line 437: , p2_a8 out JTF_VARCHAR2_TABLE_100

433: , p2_a4 out JTF_NUMBER_TABLE
434: , p2_a5 out JTF_NUMBER_TABLE
435: , p2_a6 out JTF_VARCHAR2_TABLE_300
436: , p2_a7 out JTF_VARCHAR2_TABLE_300
437: , p2_a8 out JTF_VARCHAR2_TABLE_100
438: , p2_a9 out JTF_VARCHAR2_TABLE_100
439: , p2_a10 out JTF_NUMBER_TABLE
440: , p2_a11 out JTF_VARCHAR2_TABLE_100
441: , p2_a12 out JTF_VARCHAR2_TABLE_100

Line 438: , p2_a9 out JTF_VARCHAR2_TABLE_100

434: , p2_a5 out JTF_NUMBER_TABLE
435: , p2_a6 out JTF_VARCHAR2_TABLE_300
436: , p2_a7 out JTF_VARCHAR2_TABLE_300
437: , p2_a8 out JTF_VARCHAR2_TABLE_100
438: , p2_a9 out JTF_VARCHAR2_TABLE_100
439: , p2_a10 out JTF_NUMBER_TABLE
440: , p2_a11 out JTF_VARCHAR2_TABLE_100
441: , p2_a12 out JTF_VARCHAR2_TABLE_100
442: )

Line 440: , p2_a11 out JTF_VARCHAR2_TABLE_100

436: , p2_a7 out JTF_VARCHAR2_TABLE_300
437: , p2_a8 out JTF_VARCHAR2_TABLE_100
438: , p2_a9 out JTF_VARCHAR2_TABLE_100
439: , p2_a10 out JTF_NUMBER_TABLE
440: , p2_a11 out JTF_VARCHAR2_TABLE_100
441: , p2_a12 out JTF_VARCHAR2_TABLE_100
442: )
443:
444: as

Line 441: , p2_a12 out JTF_VARCHAR2_TABLE_100

437: , p2_a8 out JTF_VARCHAR2_TABLE_100
438: , p2_a9 out JTF_VARCHAR2_TABLE_100
439: , p2_a10 out JTF_NUMBER_TABLE
440: , p2_a11 out JTF_VARCHAR2_TABLE_100
441: , p2_a12 out JTF_VARCHAR2_TABLE_100
442: )
443:
444: as
445: ddx_flow_tbl jts_setup_flow_pvt.setup_flow_tbl_type;

Line 481: , p3_a1 out JTF_VARCHAR2_TABLE_100

477: procedure get_flow_data_hiearchy(p_api_version NUMBER
478: , p_flow_id NUMBER
479: , p_version_id NUMBER
480: , p3_a0 out JTF_NUMBER_TABLE
481: , p3_a1 out JTF_VARCHAR2_TABLE_100
482: , p3_a2 out JTF_VARCHAR2_TABLE_100
483: , p3_a3 out JTF_NUMBER_TABLE
484: , p3_a4 out JTF_NUMBER_TABLE
485: , p3_a5 out JTF_NUMBER_TABLE

Line 482: , p3_a2 out JTF_VARCHAR2_TABLE_100

478: , p_flow_id NUMBER
479: , p_version_id NUMBER
480: , p3_a0 out JTF_NUMBER_TABLE
481: , p3_a1 out JTF_VARCHAR2_TABLE_100
482: , p3_a2 out JTF_VARCHAR2_TABLE_100
483: , p3_a3 out JTF_NUMBER_TABLE
484: , p3_a4 out JTF_NUMBER_TABLE
485: , p3_a5 out JTF_NUMBER_TABLE
486: , p3_a6 out JTF_VARCHAR2_TABLE_300

Line 488: , p3_a8 out JTF_VARCHAR2_TABLE_100

484: , p3_a4 out JTF_NUMBER_TABLE
485: , p3_a5 out JTF_NUMBER_TABLE
486: , p3_a6 out JTF_VARCHAR2_TABLE_300
487: , p3_a7 out JTF_VARCHAR2_TABLE_300
488: , p3_a8 out JTF_VARCHAR2_TABLE_100
489: , p3_a9 out JTF_VARCHAR2_TABLE_100
490: , p3_a10 out JTF_NUMBER_TABLE
491: , p3_a11 out JTF_VARCHAR2_TABLE_100
492: , p3_a12 out JTF_VARCHAR2_TABLE_100

Line 489: , p3_a9 out JTF_VARCHAR2_TABLE_100

485: , p3_a5 out JTF_NUMBER_TABLE
486: , p3_a6 out JTF_VARCHAR2_TABLE_300
487: , p3_a7 out JTF_VARCHAR2_TABLE_300
488: , p3_a8 out JTF_VARCHAR2_TABLE_100
489: , p3_a9 out JTF_VARCHAR2_TABLE_100
490: , p3_a10 out JTF_NUMBER_TABLE
491: , p3_a11 out JTF_VARCHAR2_TABLE_100
492: , p3_a12 out JTF_VARCHAR2_TABLE_100
493: , p3_a13 out JTF_NUMBER_TABLE

Line 491: , p3_a11 out JTF_VARCHAR2_TABLE_100

487: , p3_a7 out JTF_VARCHAR2_TABLE_300
488: , p3_a8 out JTF_VARCHAR2_TABLE_100
489: , p3_a9 out JTF_VARCHAR2_TABLE_100
490: , p3_a10 out JTF_NUMBER_TABLE
491: , p3_a11 out JTF_VARCHAR2_TABLE_100
492: , p3_a12 out JTF_VARCHAR2_TABLE_100
493: , p3_a13 out JTF_NUMBER_TABLE
494: , p3_a14 out JTF_VARCHAR2_TABLE_100
495: , p3_a15 out JTF_DATE_TABLE

Line 492: , p3_a12 out JTF_VARCHAR2_TABLE_100

488: , p3_a8 out JTF_VARCHAR2_TABLE_100
489: , p3_a9 out JTF_VARCHAR2_TABLE_100
490: , p3_a10 out JTF_NUMBER_TABLE
491: , p3_a11 out JTF_VARCHAR2_TABLE_100
492: , p3_a12 out JTF_VARCHAR2_TABLE_100
493: , p3_a13 out JTF_NUMBER_TABLE
494: , p3_a14 out JTF_VARCHAR2_TABLE_100
495: , p3_a15 out JTF_DATE_TABLE
496: , p3_a16 out JTF_DATE_TABLE

Line 494: , p3_a14 out JTF_VARCHAR2_TABLE_100

490: , p3_a10 out JTF_NUMBER_TABLE
491: , p3_a11 out JTF_VARCHAR2_TABLE_100
492: , p3_a12 out JTF_VARCHAR2_TABLE_100
493: , p3_a13 out JTF_NUMBER_TABLE
494: , p3_a14 out JTF_VARCHAR2_TABLE_100
495: , p3_a15 out JTF_DATE_TABLE
496: , p3_a16 out JTF_DATE_TABLE
497: , p3_a17 out JTF_VARCHAR2_TABLE_100
498: , p3_a18 out JTF_VARCHAR2_TABLE_100

Line 497: , p3_a17 out JTF_VARCHAR2_TABLE_100

493: , p3_a13 out JTF_NUMBER_TABLE
494: , p3_a14 out JTF_VARCHAR2_TABLE_100
495: , p3_a15 out JTF_DATE_TABLE
496: , p3_a16 out JTF_DATE_TABLE
497: , p3_a17 out JTF_VARCHAR2_TABLE_100
498: , p3_a18 out JTF_VARCHAR2_TABLE_100
499: )
500:
501: as

Line 498: , p3_a18 out JTF_VARCHAR2_TABLE_100

494: , p3_a14 out JTF_VARCHAR2_TABLE_100
495: , p3_a15 out JTF_DATE_TABLE
496: , p3_a16 out JTF_DATE_TABLE
497: , p3_a17 out JTF_VARCHAR2_TABLE_100
498: , p3_a18 out JTF_VARCHAR2_TABLE_100
499: )
500:
501: as
502: ddx_flow_tbl jts_setup_flow_pvt.flow_tbl_type;