DBA Data[Home] [Help]

APPS.AHL_COMPLEX_MX_RWSC_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 6: , a3 JTF_VARCHAR2_TABLE_100

2: /* $Header: AHLWRWSB.pls 120.0.12020000.2 2012/12/14 06:14:55 shnatu noship $ */
3: procedure rosetta_table_copy_in_p5(t out nocopy ahl_complex_mx_rwsc_pvt.visit_ir_uc_details_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE

Line 15: , a12 JTF_VARCHAR2_TABLE_100

11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_VARCHAR2_TABLE_300
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_VARCHAR2_TABLE_300
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_VARCHAR2_TABLE_100

Line 17: , a14 JTF_VARCHAR2_TABLE_100

13: , a10 JTF_VARCHAR2_TABLE_300
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_VARCHAR2_TABLE_300
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_100

Line 19: , a16 JTF_VARCHAR2_TABLE_100

15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_VARCHAR2_TABLE_300
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_100

Line 20: , a17 JTF_VARCHAR2_TABLE_100

16: , a13 JTF_VARCHAR2_TABLE_300
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_VARCHAR2_TABLE_100

Line 21: , a18 JTF_VARCHAR2_TABLE_100

17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_NUMBER_TABLE

Line 22: , a19 JTF_VARCHAR2_TABLE_100

18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_NUMBER_TABLE

Line 23: , a20 JTF_VARCHAR2_TABLE_100

19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_VARCHAR2_TABLE_100

Line 24: , a21 JTF_VARCHAR2_TABLE_100

20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_VARCHAR2_TABLE_100
28: , a25 JTF_NUMBER_TABLE

Line 27: , a24 JTF_VARCHAR2_TABLE_100

23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_VARCHAR2_TABLE_100
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_VARCHAR2_TABLE_100
30: , a27 JTF_VARCHAR2_TABLE_100
31: , a28 JTF_NUMBER_TABLE

Line 29: , a26 JTF_VARCHAR2_TABLE_100

25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_VARCHAR2_TABLE_100
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_VARCHAR2_TABLE_100
30: , a27 JTF_VARCHAR2_TABLE_100
31: , a28 JTF_NUMBER_TABLE
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_VARCHAR2_TABLE_100

Line 30: , a27 JTF_VARCHAR2_TABLE_100

26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_VARCHAR2_TABLE_100
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_VARCHAR2_TABLE_100
30: , a27 JTF_VARCHAR2_TABLE_100
31: , a28 JTF_NUMBER_TABLE
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_VARCHAR2_TABLE_100
34: , a31 JTF_NUMBER_TABLE

Line 33: , a30 JTF_VARCHAR2_TABLE_100

29: , a26 JTF_VARCHAR2_TABLE_100
30: , a27 JTF_VARCHAR2_TABLE_100
31: , a28 JTF_NUMBER_TABLE
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_VARCHAR2_TABLE_100
34: , a31 JTF_NUMBER_TABLE
35: , a32 JTF_NUMBER_TABLE
36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_NUMBER_TABLE

Line 39: , a36 JTF_VARCHAR2_TABLE_100

35: , a32 JTF_NUMBER_TABLE
36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_NUMBER_TABLE
38: , a35 JTF_NUMBER_TABLE
39: , a36 JTF_VARCHAR2_TABLE_100
40: , a37 JTF_VARCHAR2_TABLE_100
41: , a38 JTF_VARCHAR2_TABLE_100
42: , a39 JTF_NUMBER_TABLE
43: , a40 JTF_NUMBER_TABLE

Line 40: , a37 JTF_VARCHAR2_TABLE_100

36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_NUMBER_TABLE
38: , a35 JTF_NUMBER_TABLE
39: , a36 JTF_VARCHAR2_TABLE_100
40: , a37 JTF_VARCHAR2_TABLE_100
41: , a38 JTF_VARCHAR2_TABLE_100
42: , a39 JTF_NUMBER_TABLE
43: , a40 JTF_NUMBER_TABLE
44: , a41 JTF_VARCHAR2_TABLE_100

Line 41: , a38 JTF_VARCHAR2_TABLE_100

37: , a34 JTF_NUMBER_TABLE
38: , a35 JTF_NUMBER_TABLE
39: , a36 JTF_VARCHAR2_TABLE_100
40: , a37 JTF_VARCHAR2_TABLE_100
41: , a38 JTF_VARCHAR2_TABLE_100
42: , a39 JTF_NUMBER_TABLE
43: , a40 JTF_NUMBER_TABLE
44: , a41 JTF_VARCHAR2_TABLE_100
45: , a42 JTF_NUMBER_TABLE

Line 44: , a41 JTF_VARCHAR2_TABLE_100

40: , a37 JTF_VARCHAR2_TABLE_100
41: , a38 JTF_VARCHAR2_TABLE_100
42: , a39 JTF_NUMBER_TABLE
43: , a40 JTF_NUMBER_TABLE
44: , a41 JTF_VARCHAR2_TABLE_100
45: , a42 JTF_NUMBER_TABLE
46: , a43 JTF_VARCHAR2_TABLE_100
47: ) as
48: ddindx binary_integer; indx binary_integer;

Line 46: , a43 JTF_VARCHAR2_TABLE_100

42: , a39 JTF_NUMBER_TABLE
43: , a40 JTF_NUMBER_TABLE
44: , a41 JTF_VARCHAR2_TABLE_100
45: , a42 JTF_NUMBER_TABLE
46: , a43 JTF_VARCHAR2_TABLE_100
47: ) as
48: ddindx binary_integer; indx binary_integer;
49: begin
50: if a0 is not null and a0.count > 0 then

Line 111: , a3 out nocopy JTF_VARCHAR2_TABLE_100

107: end rosetta_table_copy_in_p5;
108: procedure rosetta_table_copy_out_p5(t ahl_complex_mx_rwsc_pvt.visit_ir_uc_details_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
109: , a1 out nocopy JTF_NUMBER_TABLE
110: , a2 out nocopy JTF_NUMBER_TABLE
111: , a3 out nocopy JTF_VARCHAR2_TABLE_100
112: , a4 out nocopy JTF_NUMBER_TABLE
113: , a5 out nocopy JTF_NUMBER_TABLE
114: , a6 out nocopy JTF_NUMBER_TABLE
115: , a7 out nocopy JTF_NUMBER_TABLE

Line 120: , a12 out nocopy JTF_VARCHAR2_TABLE_100

116: , a8 out nocopy JTF_NUMBER_TABLE
117: , a9 out nocopy JTF_NUMBER_TABLE
118: , a10 out nocopy JTF_VARCHAR2_TABLE_300
119: , a11 out nocopy JTF_NUMBER_TABLE
120: , a12 out nocopy JTF_VARCHAR2_TABLE_100
121: , a13 out nocopy JTF_VARCHAR2_TABLE_300
122: , a14 out nocopy JTF_VARCHAR2_TABLE_100
123: , a15 out nocopy JTF_NUMBER_TABLE
124: , a16 out nocopy JTF_VARCHAR2_TABLE_100

Line 122: , a14 out nocopy JTF_VARCHAR2_TABLE_100

118: , a10 out nocopy JTF_VARCHAR2_TABLE_300
119: , a11 out nocopy JTF_NUMBER_TABLE
120: , a12 out nocopy JTF_VARCHAR2_TABLE_100
121: , a13 out nocopy JTF_VARCHAR2_TABLE_300
122: , a14 out nocopy JTF_VARCHAR2_TABLE_100
123: , a15 out nocopy JTF_NUMBER_TABLE
124: , a16 out nocopy JTF_VARCHAR2_TABLE_100
125: , a17 out nocopy JTF_VARCHAR2_TABLE_100
126: , a18 out nocopy JTF_VARCHAR2_TABLE_100

Line 124: , a16 out nocopy JTF_VARCHAR2_TABLE_100

120: , a12 out nocopy JTF_VARCHAR2_TABLE_100
121: , a13 out nocopy JTF_VARCHAR2_TABLE_300
122: , a14 out nocopy JTF_VARCHAR2_TABLE_100
123: , a15 out nocopy JTF_NUMBER_TABLE
124: , a16 out nocopy JTF_VARCHAR2_TABLE_100
125: , a17 out nocopy JTF_VARCHAR2_TABLE_100
126: , a18 out nocopy JTF_VARCHAR2_TABLE_100
127: , a19 out nocopy JTF_VARCHAR2_TABLE_100
128: , a20 out nocopy JTF_VARCHAR2_TABLE_100

Line 125: , a17 out nocopy JTF_VARCHAR2_TABLE_100

121: , a13 out nocopy JTF_VARCHAR2_TABLE_300
122: , a14 out nocopy JTF_VARCHAR2_TABLE_100
123: , a15 out nocopy JTF_NUMBER_TABLE
124: , a16 out nocopy JTF_VARCHAR2_TABLE_100
125: , a17 out nocopy JTF_VARCHAR2_TABLE_100
126: , a18 out nocopy JTF_VARCHAR2_TABLE_100
127: , a19 out nocopy JTF_VARCHAR2_TABLE_100
128: , a20 out nocopy JTF_VARCHAR2_TABLE_100
129: , a21 out nocopy JTF_VARCHAR2_TABLE_100

Line 126: , a18 out nocopy JTF_VARCHAR2_TABLE_100

122: , a14 out nocopy JTF_VARCHAR2_TABLE_100
123: , a15 out nocopy JTF_NUMBER_TABLE
124: , a16 out nocopy JTF_VARCHAR2_TABLE_100
125: , a17 out nocopy JTF_VARCHAR2_TABLE_100
126: , a18 out nocopy JTF_VARCHAR2_TABLE_100
127: , a19 out nocopy JTF_VARCHAR2_TABLE_100
128: , a20 out nocopy JTF_VARCHAR2_TABLE_100
129: , a21 out nocopy JTF_VARCHAR2_TABLE_100
130: , a22 out nocopy JTF_NUMBER_TABLE

Line 127: , a19 out nocopy JTF_VARCHAR2_TABLE_100

123: , a15 out nocopy JTF_NUMBER_TABLE
124: , a16 out nocopy JTF_VARCHAR2_TABLE_100
125: , a17 out nocopy JTF_VARCHAR2_TABLE_100
126: , a18 out nocopy JTF_VARCHAR2_TABLE_100
127: , a19 out nocopy JTF_VARCHAR2_TABLE_100
128: , a20 out nocopy JTF_VARCHAR2_TABLE_100
129: , a21 out nocopy JTF_VARCHAR2_TABLE_100
130: , a22 out nocopy JTF_NUMBER_TABLE
131: , a23 out nocopy JTF_NUMBER_TABLE

Line 128: , a20 out nocopy JTF_VARCHAR2_TABLE_100

124: , a16 out nocopy JTF_VARCHAR2_TABLE_100
125: , a17 out nocopy JTF_VARCHAR2_TABLE_100
126: , a18 out nocopy JTF_VARCHAR2_TABLE_100
127: , a19 out nocopy JTF_VARCHAR2_TABLE_100
128: , a20 out nocopy JTF_VARCHAR2_TABLE_100
129: , a21 out nocopy JTF_VARCHAR2_TABLE_100
130: , a22 out nocopy JTF_NUMBER_TABLE
131: , a23 out nocopy JTF_NUMBER_TABLE
132: , a24 out nocopy JTF_VARCHAR2_TABLE_100

Line 129: , a21 out nocopy JTF_VARCHAR2_TABLE_100

125: , a17 out nocopy JTF_VARCHAR2_TABLE_100
126: , a18 out nocopy JTF_VARCHAR2_TABLE_100
127: , a19 out nocopy JTF_VARCHAR2_TABLE_100
128: , a20 out nocopy JTF_VARCHAR2_TABLE_100
129: , a21 out nocopy JTF_VARCHAR2_TABLE_100
130: , a22 out nocopy JTF_NUMBER_TABLE
131: , a23 out nocopy JTF_NUMBER_TABLE
132: , a24 out nocopy JTF_VARCHAR2_TABLE_100
133: , a25 out nocopy JTF_NUMBER_TABLE

Line 132: , a24 out nocopy JTF_VARCHAR2_TABLE_100

128: , a20 out nocopy JTF_VARCHAR2_TABLE_100
129: , a21 out nocopy JTF_VARCHAR2_TABLE_100
130: , a22 out nocopy JTF_NUMBER_TABLE
131: , a23 out nocopy JTF_NUMBER_TABLE
132: , a24 out nocopy JTF_VARCHAR2_TABLE_100
133: , a25 out nocopy JTF_NUMBER_TABLE
134: , a26 out nocopy JTF_VARCHAR2_TABLE_100
135: , a27 out nocopy JTF_VARCHAR2_TABLE_100
136: , a28 out nocopy JTF_NUMBER_TABLE

Line 134: , a26 out nocopy JTF_VARCHAR2_TABLE_100

130: , a22 out nocopy JTF_NUMBER_TABLE
131: , a23 out nocopy JTF_NUMBER_TABLE
132: , a24 out nocopy JTF_VARCHAR2_TABLE_100
133: , a25 out nocopy JTF_NUMBER_TABLE
134: , a26 out nocopy JTF_VARCHAR2_TABLE_100
135: , a27 out nocopy JTF_VARCHAR2_TABLE_100
136: , a28 out nocopy JTF_NUMBER_TABLE
137: , a29 out nocopy JTF_NUMBER_TABLE
138: , a30 out nocopy JTF_VARCHAR2_TABLE_100

Line 135: , a27 out nocopy JTF_VARCHAR2_TABLE_100

131: , a23 out nocopy JTF_NUMBER_TABLE
132: , a24 out nocopy JTF_VARCHAR2_TABLE_100
133: , a25 out nocopy JTF_NUMBER_TABLE
134: , a26 out nocopy JTF_VARCHAR2_TABLE_100
135: , a27 out nocopy JTF_VARCHAR2_TABLE_100
136: , a28 out nocopy JTF_NUMBER_TABLE
137: , a29 out nocopy JTF_NUMBER_TABLE
138: , a30 out nocopy JTF_VARCHAR2_TABLE_100
139: , a31 out nocopy JTF_NUMBER_TABLE

Line 138: , a30 out nocopy JTF_VARCHAR2_TABLE_100

134: , a26 out nocopy JTF_VARCHAR2_TABLE_100
135: , a27 out nocopy JTF_VARCHAR2_TABLE_100
136: , a28 out nocopy JTF_NUMBER_TABLE
137: , a29 out nocopy JTF_NUMBER_TABLE
138: , a30 out nocopy JTF_VARCHAR2_TABLE_100
139: , a31 out nocopy JTF_NUMBER_TABLE
140: , a32 out nocopy JTF_NUMBER_TABLE
141: , a33 out nocopy JTF_NUMBER_TABLE
142: , a34 out nocopy JTF_NUMBER_TABLE

Line 144: , a36 out nocopy JTF_VARCHAR2_TABLE_100

140: , a32 out nocopy JTF_NUMBER_TABLE
141: , a33 out nocopy JTF_NUMBER_TABLE
142: , a34 out nocopy JTF_NUMBER_TABLE
143: , a35 out nocopy JTF_NUMBER_TABLE
144: , a36 out nocopy JTF_VARCHAR2_TABLE_100
145: , a37 out nocopy JTF_VARCHAR2_TABLE_100
146: , a38 out nocopy JTF_VARCHAR2_TABLE_100
147: , a39 out nocopy JTF_NUMBER_TABLE
148: , a40 out nocopy JTF_NUMBER_TABLE

Line 145: , a37 out nocopy JTF_VARCHAR2_TABLE_100

141: , a33 out nocopy JTF_NUMBER_TABLE
142: , a34 out nocopy JTF_NUMBER_TABLE
143: , a35 out nocopy JTF_NUMBER_TABLE
144: , a36 out nocopy JTF_VARCHAR2_TABLE_100
145: , a37 out nocopy JTF_VARCHAR2_TABLE_100
146: , a38 out nocopy JTF_VARCHAR2_TABLE_100
147: , a39 out nocopy JTF_NUMBER_TABLE
148: , a40 out nocopy JTF_NUMBER_TABLE
149: , a41 out nocopy JTF_VARCHAR2_TABLE_100

Line 146: , a38 out nocopy JTF_VARCHAR2_TABLE_100

142: , a34 out nocopy JTF_NUMBER_TABLE
143: , a35 out nocopy JTF_NUMBER_TABLE
144: , a36 out nocopy JTF_VARCHAR2_TABLE_100
145: , a37 out nocopy JTF_VARCHAR2_TABLE_100
146: , a38 out nocopy JTF_VARCHAR2_TABLE_100
147: , a39 out nocopy JTF_NUMBER_TABLE
148: , a40 out nocopy JTF_NUMBER_TABLE
149: , a41 out nocopy JTF_VARCHAR2_TABLE_100
150: , a42 out nocopy JTF_NUMBER_TABLE

Line 149: , a41 out nocopy JTF_VARCHAR2_TABLE_100

145: , a37 out nocopy JTF_VARCHAR2_TABLE_100
146: , a38 out nocopy JTF_VARCHAR2_TABLE_100
147: , a39 out nocopy JTF_NUMBER_TABLE
148: , a40 out nocopy JTF_NUMBER_TABLE
149: , a41 out nocopy JTF_VARCHAR2_TABLE_100
150: , a42 out nocopy JTF_NUMBER_TABLE
151: , a43 out nocopy JTF_VARCHAR2_TABLE_100
152: ) as
153: ddindx binary_integer; indx binary_integer;

Line 151: , a43 out nocopy JTF_VARCHAR2_TABLE_100

147: , a39 out nocopy JTF_NUMBER_TABLE
148: , a40 out nocopy JTF_NUMBER_TABLE
149: , a41 out nocopy JTF_VARCHAR2_TABLE_100
150: , a42 out nocopy JTF_NUMBER_TABLE
151: , a43 out nocopy JTF_VARCHAR2_TABLE_100
152: ) as
153: ddindx binary_integer; indx binary_integer;
154: begin
155: if t is null or t.count = 0 then

Line 159: a3 := JTF_VARCHAR2_TABLE_100();

155: if t is null or t.count = 0 then
156: a0 := JTF_NUMBER_TABLE();
157: a1 := JTF_NUMBER_TABLE();
158: a2 := JTF_NUMBER_TABLE();
159: a3 := JTF_VARCHAR2_TABLE_100();
160: a4 := JTF_NUMBER_TABLE();
161: a5 := JTF_NUMBER_TABLE();
162: a6 := JTF_NUMBER_TABLE();
163: a7 := JTF_NUMBER_TABLE();

Line 168: a12 := JTF_VARCHAR2_TABLE_100();

164: a8 := JTF_NUMBER_TABLE();
165: a9 := JTF_NUMBER_TABLE();
166: a10 := JTF_VARCHAR2_TABLE_300();
167: a11 := JTF_NUMBER_TABLE();
168: a12 := JTF_VARCHAR2_TABLE_100();
169: a13 := JTF_VARCHAR2_TABLE_300();
170: a14 := JTF_VARCHAR2_TABLE_100();
171: a15 := JTF_NUMBER_TABLE();
172: a16 := JTF_VARCHAR2_TABLE_100();

Line 170: a14 := JTF_VARCHAR2_TABLE_100();

166: a10 := JTF_VARCHAR2_TABLE_300();
167: a11 := JTF_NUMBER_TABLE();
168: a12 := JTF_VARCHAR2_TABLE_100();
169: a13 := JTF_VARCHAR2_TABLE_300();
170: a14 := JTF_VARCHAR2_TABLE_100();
171: a15 := JTF_NUMBER_TABLE();
172: a16 := JTF_VARCHAR2_TABLE_100();
173: a17 := JTF_VARCHAR2_TABLE_100();
174: a18 := JTF_VARCHAR2_TABLE_100();

Line 172: a16 := JTF_VARCHAR2_TABLE_100();

168: a12 := JTF_VARCHAR2_TABLE_100();
169: a13 := JTF_VARCHAR2_TABLE_300();
170: a14 := JTF_VARCHAR2_TABLE_100();
171: a15 := JTF_NUMBER_TABLE();
172: a16 := JTF_VARCHAR2_TABLE_100();
173: a17 := JTF_VARCHAR2_TABLE_100();
174: a18 := JTF_VARCHAR2_TABLE_100();
175: a19 := JTF_VARCHAR2_TABLE_100();
176: a20 := JTF_VARCHAR2_TABLE_100();

Line 173: a17 := JTF_VARCHAR2_TABLE_100();

169: a13 := JTF_VARCHAR2_TABLE_300();
170: a14 := JTF_VARCHAR2_TABLE_100();
171: a15 := JTF_NUMBER_TABLE();
172: a16 := JTF_VARCHAR2_TABLE_100();
173: a17 := JTF_VARCHAR2_TABLE_100();
174: a18 := JTF_VARCHAR2_TABLE_100();
175: a19 := JTF_VARCHAR2_TABLE_100();
176: a20 := JTF_VARCHAR2_TABLE_100();
177: a21 := JTF_VARCHAR2_TABLE_100();

Line 174: a18 := JTF_VARCHAR2_TABLE_100();

170: a14 := JTF_VARCHAR2_TABLE_100();
171: a15 := JTF_NUMBER_TABLE();
172: a16 := JTF_VARCHAR2_TABLE_100();
173: a17 := JTF_VARCHAR2_TABLE_100();
174: a18 := JTF_VARCHAR2_TABLE_100();
175: a19 := JTF_VARCHAR2_TABLE_100();
176: a20 := JTF_VARCHAR2_TABLE_100();
177: a21 := JTF_VARCHAR2_TABLE_100();
178: a22 := JTF_NUMBER_TABLE();

Line 175: a19 := JTF_VARCHAR2_TABLE_100();

171: a15 := JTF_NUMBER_TABLE();
172: a16 := JTF_VARCHAR2_TABLE_100();
173: a17 := JTF_VARCHAR2_TABLE_100();
174: a18 := JTF_VARCHAR2_TABLE_100();
175: a19 := JTF_VARCHAR2_TABLE_100();
176: a20 := JTF_VARCHAR2_TABLE_100();
177: a21 := JTF_VARCHAR2_TABLE_100();
178: a22 := JTF_NUMBER_TABLE();
179: a23 := JTF_NUMBER_TABLE();

Line 176: a20 := JTF_VARCHAR2_TABLE_100();

172: a16 := JTF_VARCHAR2_TABLE_100();
173: a17 := JTF_VARCHAR2_TABLE_100();
174: a18 := JTF_VARCHAR2_TABLE_100();
175: a19 := JTF_VARCHAR2_TABLE_100();
176: a20 := JTF_VARCHAR2_TABLE_100();
177: a21 := JTF_VARCHAR2_TABLE_100();
178: a22 := JTF_NUMBER_TABLE();
179: a23 := JTF_NUMBER_TABLE();
180: a24 := JTF_VARCHAR2_TABLE_100();

Line 177: a21 := JTF_VARCHAR2_TABLE_100();

173: a17 := JTF_VARCHAR2_TABLE_100();
174: a18 := JTF_VARCHAR2_TABLE_100();
175: a19 := JTF_VARCHAR2_TABLE_100();
176: a20 := JTF_VARCHAR2_TABLE_100();
177: a21 := JTF_VARCHAR2_TABLE_100();
178: a22 := JTF_NUMBER_TABLE();
179: a23 := JTF_NUMBER_TABLE();
180: a24 := JTF_VARCHAR2_TABLE_100();
181: a25 := JTF_NUMBER_TABLE();

Line 180: a24 := JTF_VARCHAR2_TABLE_100();

176: a20 := JTF_VARCHAR2_TABLE_100();
177: a21 := JTF_VARCHAR2_TABLE_100();
178: a22 := JTF_NUMBER_TABLE();
179: a23 := JTF_NUMBER_TABLE();
180: a24 := JTF_VARCHAR2_TABLE_100();
181: a25 := JTF_NUMBER_TABLE();
182: a26 := JTF_VARCHAR2_TABLE_100();
183: a27 := JTF_VARCHAR2_TABLE_100();
184: a28 := JTF_NUMBER_TABLE();

Line 182: a26 := JTF_VARCHAR2_TABLE_100();

178: a22 := JTF_NUMBER_TABLE();
179: a23 := JTF_NUMBER_TABLE();
180: a24 := JTF_VARCHAR2_TABLE_100();
181: a25 := JTF_NUMBER_TABLE();
182: a26 := JTF_VARCHAR2_TABLE_100();
183: a27 := JTF_VARCHAR2_TABLE_100();
184: a28 := JTF_NUMBER_TABLE();
185: a29 := JTF_NUMBER_TABLE();
186: a30 := JTF_VARCHAR2_TABLE_100();

Line 183: a27 := JTF_VARCHAR2_TABLE_100();

179: a23 := JTF_NUMBER_TABLE();
180: a24 := JTF_VARCHAR2_TABLE_100();
181: a25 := JTF_NUMBER_TABLE();
182: a26 := JTF_VARCHAR2_TABLE_100();
183: a27 := JTF_VARCHAR2_TABLE_100();
184: a28 := JTF_NUMBER_TABLE();
185: a29 := JTF_NUMBER_TABLE();
186: a30 := JTF_VARCHAR2_TABLE_100();
187: a31 := JTF_NUMBER_TABLE();

Line 186: a30 := JTF_VARCHAR2_TABLE_100();

182: a26 := JTF_VARCHAR2_TABLE_100();
183: a27 := JTF_VARCHAR2_TABLE_100();
184: a28 := JTF_NUMBER_TABLE();
185: a29 := JTF_NUMBER_TABLE();
186: a30 := JTF_VARCHAR2_TABLE_100();
187: a31 := JTF_NUMBER_TABLE();
188: a32 := JTF_NUMBER_TABLE();
189: a33 := JTF_NUMBER_TABLE();
190: a34 := JTF_NUMBER_TABLE();

Line 192: a36 := JTF_VARCHAR2_TABLE_100();

188: a32 := JTF_NUMBER_TABLE();
189: a33 := JTF_NUMBER_TABLE();
190: a34 := JTF_NUMBER_TABLE();
191: a35 := JTF_NUMBER_TABLE();
192: a36 := JTF_VARCHAR2_TABLE_100();
193: a37 := JTF_VARCHAR2_TABLE_100();
194: a38 := JTF_VARCHAR2_TABLE_100();
195: a39 := JTF_NUMBER_TABLE();
196: a40 := JTF_NUMBER_TABLE();

Line 193: a37 := JTF_VARCHAR2_TABLE_100();

189: a33 := JTF_NUMBER_TABLE();
190: a34 := JTF_NUMBER_TABLE();
191: a35 := JTF_NUMBER_TABLE();
192: a36 := JTF_VARCHAR2_TABLE_100();
193: a37 := JTF_VARCHAR2_TABLE_100();
194: a38 := JTF_VARCHAR2_TABLE_100();
195: a39 := JTF_NUMBER_TABLE();
196: a40 := JTF_NUMBER_TABLE();
197: a41 := JTF_VARCHAR2_TABLE_100();

Line 194: a38 := JTF_VARCHAR2_TABLE_100();

190: a34 := JTF_NUMBER_TABLE();
191: a35 := JTF_NUMBER_TABLE();
192: a36 := JTF_VARCHAR2_TABLE_100();
193: a37 := JTF_VARCHAR2_TABLE_100();
194: a38 := JTF_VARCHAR2_TABLE_100();
195: a39 := JTF_NUMBER_TABLE();
196: a40 := JTF_NUMBER_TABLE();
197: a41 := JTF_VARCHAR2_TABLE_100();
198: a42 := JTF_NUMBER_TABLE();

Line 197: a41 := JTF_VARCHAR2_TABLE_100();

193: a37 := JTF_VARCHAR2_TABLE_100();
194: a38 := JTF_VARCHAR2_TABLE_100();
195: a39 := JTF_NUMBER_TABLE();
196: a40 := JTF_NUMBER_TABLE();
197: a41 := JTF_VARCHAR2_TABLE_100();
198: a42 := JTF_NUMBER_TABLE();
199: a43 := JTF_VARCHAR2_TABLE_100();
200: else
201: a0 := JTF_NUMBER_TABLE();

Line 199: a43 := JTF_VARCHAR2_TABLE_100();

195: a39 := JTF_NUMBER_TABLE();
196: a40 := JTF_NUMBER_TABLE();
197: a41 := JTF_VARCHAR2_TABLE_100();
198: a42 := JTF_NUMBER_TABLE();
199: a43 := JTF_VARCHAR2_TABLE_100();
200: else
201: a0 := JTF_NUMBER_TABLE();
202: a1 := JTF_NUMBER_TABLE();
203: a2 := JTF_NUMBER_TABLE();

Line 204: a3 := JTF_VARCHAR2_TABLE_100();

200: else
201: a0 := JTF_NUMBER_TABLE();
202: a1 := JTF_NUMBER_TABLE();
203: a2 := JTF_NUMBER_TABLE();
204: a3 := JTF_VARCHAR2_TABLE_100();
205: a4 := JTF_NUMBER_TABLE();
206: a5 := JTF_NUMBER_TABLE();
207: a6 := JTF_NUMBER_TABLE();
208: a7 := JTF_NUMBER_TABLE();

Line 213: a12 := JTF_VARCHAR2_TABLE_100();

209: a8 := JTF_NUMBER_TABLE();
210: a9 := JTF_NUMBER_TABLE();
211: a10 := JTF_VARCHAR2_TABLE_300();
212: a11 := JTF_NUMBER_TABLE();
213: a12 := JTF_VARCHAR2_TABLE_100();
214: a13 := JTF_VARCHAR2_TABLE_300();
215: a14 := JTF_VARCHAR2_TABLE_100();
216: a15 := JTF_NUMBER_TABLE();
217: a16 := JTF_VARCHAR2_TABLE_100();

Line 215: a14 := JTF_VARCHAR2_TABLE_100();

211: a10 := JTF_VARCHAR2_TABLE_300();
212: a11 := JTF_NUMBER_TABLE();
213: a12 := JTF_VARCHAR2_TABLE_100();
214: a13 := JTF_VARCHAR2_TABLE_300();
215: a14 := JTF_VARCHAR2_TABLE_100();
216: a15 := JTF_NUMBER_TABLE();
217: a16 := JTF_VARCHAR2_TABLE_100();
218: a17 := JTF_VARCHAR2_TABLE_100();
219: a18 := JTF_VARCHAR2_TABLE_100();

Line 217: a16 := JTF_VARCHAR2_TABLE_100();

213: a12 := JTF_VARCHAR2_TABLE_100();
214: a13 := JTF_VARCHAR2_TABLE_300();
215: a14 := JTF_VARCHAR2_TABLE_100();
216: a15 := JTF_NUMBER_TABLE();
217: a16 := JTF_VARCHAR2_TABLE_100();
218: a17 := JTF_VARCHAR2_TABLE_100();
219: a18 := JTF_VARCHAR2_TABLE_100();
220: a19 := JTF_VARCHAR2_TABLE_100();
221: a20 := JTF_VARCHAR2_TABLE_100();

Line 218: a17 := JTF_VARCHAR2_TABLE_100();

214: a13 := JTF_VARCHAR2_TABLE_300();
215: a14 := JTF_VARCHAR2_TABLE_100();
216: a15 := JTF_NUMBER_TABLE();
217: a16 := JTF_VARCHAR2_TABLE_100();
218: a17 := JTF_VARCHAR2_TABLE_100();
219: a18 := JTF_VARCHAR2_TABLE_100();
220: a19 := JTF_VARCHAR2_TABLE_100();
221: a20 := JTF_VARCHAR2_TABLE_100();
222: a21 := JTF_VARCHAR2_TABLE_100();

Line 219: a18 := JTF_VARCHAR2_TABLE_100();

215: a14 := JTF_VARCHAR2_TABLE_100();
216: a15 := JTF_NUMBER_TABLE();
217: a16 := JTF_VARCHAR2_TABLE_100();
218: a17 := JTF_VARCHAR2_TABLE_100();
219: a18 := JTF_VARCHAR2_TABLE_100();
220: a19 := JTF_VARCHAR2_TABLE_100();
221: a20 := JTF_VARCHAR2_TABLE_100();
222: a21 := JTF_VARCHAR2_TABLE_100();
223: a22 := JTF_NUMBER_TABLE();

Line 220: a19 := JTF_VARCHAR2_TABLE_100();

216: a15 := JTF_NUMBER_TABLE();
217: a16 := JTF_VARCHAR2_TABLE_100();
218: a17 := JTF_VARCHAR2_TABLE_100();
219: a18 := JTF_VARCHAR2_TABLE_100();
220: a19 := JTF_VARCHAR2_TABLE_100();
221: a20 := JTF_VARCHAR2_TABLE_100();
222: a21 := JTF_VARCHAR2_TABLE_100();
223: a22 := JTF_NUMBER_TABLE();
224: a23 := JTF_NUMBER_TABLE();

Line 221: a20 := JTF_VARCHAR2_TABLE_100();

217: a16 := JTF_VARCHAR2_TABLE_100();
218: a17 := JTF_VARCHAR2_TABLE_100();
219: a18 := JTF_VARCHAR2_TABLE_100();
220: a19 := JTF_VARCHAR2_TABLE_100();
221: a20 := JTF_VARCHAR2_TABLE_100();
222: a21 := JTF_VARCHAR2_TABLE_100();
223: a22 := JTF_NUMBER_TABLE();
224: a23 := JTF_NUMBER_TABLE();
225: a24 := JTF_VARCHAR2_TABLE_100();

Line 222: a21 := JTF_VARCHAR2_TABLE_100();

218: a17 := JTF_VARCHAR2_TABLE_100();
219: a18 := JTF_VARCHAR2_TABLE_100();
220: a19 := JTF_VARCHAR2_TABLE_100();
221: a20 := JTF_VARCHAR2_TABLE_100();
222: a21 := JTF_VARCHAR2_TABLE_100();
223: a22 := JTF_NUMBER_TABLE();
224: a23 := JTF_NUMBER_TABLE();
225: a24 := JTF_VARCHAR2_TABLE_100();
226: a25 := JTF_NUMBER_TABLE();

Line 225: a24 := JTF_VARCHAR2_TABLE_100();

221: a20 := JTF_VARCHAR2_TABLE_100();
222: a21 := JTF_VARCHAR2_TABLE_100();
223: a22 := JTF_NUMBER_TABLE();
224: a23 := JTF_NUMBER_TABLE();
225: a24 := JTF_VARCHAR2_TABLE_100();
226: a25 := JTF_NUMBER_TABLE();
227: a26 := JTF_VARCHAR2_TABLE_100();
228: a27 := JTF_VARCHAR2_TABLE_100();
229: a28 := JTF_NUMBER_TABLE();

Line 227: a26 := JTF_VARCHAR2_TABLE_100();

223: a22 := JTF_NUMBER_TABLE();
224: a23 := JTF_NUMBER_TABLE();
225: a24 := JTF_VARCHAR2_TABLE_100();
226: a25 := JTF_NUMBER_TABLE();
227: a26 := JTF_VARCHAR2_TABLE_100();
228: a27 := JTF_VARCHAR2_TABLE_100();
229: a28 := JTF_NUMBER_TABLE();
230: a29 := JTF_NUMBER_TABLE();
231: a30 := JTF_VARCHAR2_TABLE_100();

Line 228: a27 := JTF_VARCHAR2_TABLE_100();

224: a23 := JTF_NUMBER_TABLE();
225: a24 := JTF_VARCHAR2_TABLE_100();
226: a25 := JTF_NUMBER_TABLE();
227: a26 := JTF_VARCHAR2_TABLE_100();
228: a27 := JTF_VARCHAR2_TABLE_100();
229: a28 := JTF_NUMBER_TABLE();
230: a29 := JTF_NUMBER_TABLE();
231: a30 := JTF_VARCHAR2_TABLE_100();
232: a31 := JTF_NUMBER_TABLE();

Line 231: a30 := JTF_VARCHAR2_TABLE_100();

227: a26 := JTF_VARCHAR2_TABLE_100();
228: a27 := JTF_VARCHAR2_TABLE_100();
229: a28 := JTF_NUMBER_TABLE();
230: a29 := JTF_NUMBER_TABLE();
231: a30 := JTF_VARCHAR2_TABLE_100();
232: a31 := JTF_NUMBER_TABLE();
233: a32 := JTF_NUMBER_TABLE();
234: a33 := JTF_NUMBER_TABLE();
235: a34 := JTF_NUMBER_TABLE();

Line 237: a36 := JTF_VARCHAR2_TABLE_100();

233: a32 := JTF_NUMBER_TABLE();
234: a33 := JTF_NUMBER_TABLE();
235: a34 := JTF_NUMBER_TABLE();
236: a35 := JTF_NUMBER_TABLE();
237: a36 := JTF_VARCHAR2_TABLE_100();
238: a37 := JTF_VARCHAR2_TABLE_100();
239: a38 := JTF_VARCHAR2_TABLE_100();
240: a39 := JTF_NUMBER_TABLE();
241: a40 := JTF_NUMBER_TABLE();

Line 238: a37 := JTF_VARCHAR2_TABLE_100();

234: a33 := JTF_NUMBER_TABLE();
235: a34 := JTF_NUMBER_TABLE();
236: a35 := JTF_NUMBER_TABLE();
237: a36 := JTF_VARCHAR2_TABLE_100();
238: a37 := JTF_VARCHAR2_TABLE_100();
239: a38 := JTF_VARCHAR2_TABLE_100();
240: a39 := JTF_NUMBER_TABLE();
241: a40 := JTF_NUMBER_TABLE();
242: a41 := JTF_VARCHAR2_TABLE_100();

Line 239: a38 := JTF_VARCHAR2_TABLE_100();

235: a34 := JTF_NUMBER_TABLE();
236: a35 := JTF_NUMBER_TABLE();
237: a36 := JTF_VARCHAR2_TABLE_100();
238: a37 := JTF_VARCHAR2_TABLE_100();
239: a38 := JTF_VARCHAR2_TABLE_100();
240: a39 := JTF_NUMBER_TABLE();
241: a40 := JTF_NUMBER_TABLE();
242: a41 := JTF_VARCHAR2_TABLE_100();
243: a42 := JTF_NUMBER_TABLE();

Line 242: a41 := JTF_VARCHAR2_TABLE_100();

238: a37 := JTF_VARCHAR2_TABLE_100();
239: a38 := JTF_VARCHAR2_TABLE_100();
240: a39 := JTF_NUMBER_TABLE();
241: a40 := JTF_NUMBER_TABLE();
242: a41 := JTF_VARCHAR2_TABLE_100();
243: a42 := JTF_NUMBER_TABLE();
244: a43 := JTF_VARCHAR2_TABLE_100();
245: if t.count > 0 then
246: a0.extend(t.count);

Line 244: a43 := JTF_VARCHAR2_TABLE_100();

240: a39 := JTF_NUMBER_TABLE();
241: a40 := JTF_NUMBER_TABLE();
242: a41 := JTF_VARCHAR2_TABLE_100();
243: a42 := JTF_NUMBER_TABLE();
244: a43 := JTF_VARCHAR2_TABLE_100();
245: if t.count > 0 then
246: a0.extend(t.count);
247: a1.extend(t.count);
248: a2.extend(t.count);

Line 351: , a4 JTF_VARCHAR2_TABLE_100

347: procedure rosetta_table_copy_in_p8(t out nocopy ahl_complex_mx_rwsc_pvt.instance_routings_tbl_type, a0 JTF_NUMBER_TABLE
348: , a1 JTF_NUMBER_TABLE
349: , a2 JTF_NUMBER_TABLE
350: , a3 JTF_NUMBER_TABLE
351: , a4 JTF_VARCHAR2_TABLE_100
352: , a5 JTF_VARCHAR2_TABLE_100
353: ) as
354: ddindx binary_integer; indx binary_integer;
355: begin

Line 352: , a5 JTF_VARCHAR2_TABLE_100

348: , a1 JTF_NUMBER_TABLE
349: , a2 JTF_NUMBER_TABLE
350: , a3 JTF_NUMBER_TABLE
351: , a4 JTF_VARCHAR2_TABLE_100
352: , a5 JTF_VARCHAR2_TABLE_100
353: ) as
354: ddindx binary_integer; indx binary_integer;
355: begin
356: if a0 is not null and a0.count > 0 then

Line 380: , a4 out nocopy JTF_VARCHAR2_TABLE_100

376: procedure rosetta_table_copy_out_p8(t ahl_complex_mx_rwsc_pvt.instance_routings_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
377: , a1 out nocopy JTF_NUMBER_TABLE
378: , a2 out nocopy JTF_NUMBER_TABLE
379: , a3 out nocopy JTF_NUMBER_TABLE
380: , a4 out nocopy JTF_VARCHAR2_TABLE_100
381: , a5 out nocopy JTF_VARCHAR2_TABLE_100
382: ) as
383: ddindx binary_integer; indx binary_integer;
384: begin

Line 381: , a5 out nocopy JTF_VARCHAR2_TABLE_100

377: , a1 out nocopy JTF_NUMBER_TABLE
378: , a2 out nocopy JTF_NUMBER_TABLE
379: , a3 out nocopy JTF_NUMBER_TABLE
380: , a4 out nocopy JTF_VARCHAR2_TABLE_100
381: , a5 out nocopy JTF_VARCHAR2_TABLE_100
382: ) as
383: ddindx binary_integer; indx binary_integer;
384: begin
385: if t is null or t.count = 0 then

Line 390: a4 := JTF_VARCHAR2_TABLE_100();

386: a0 := JTF_NUMBER_TABLE();
387: a1 := JTF_NUMBER_TABLE();
388: a2 := JTF_NUMBER_TABLE();
389: a3 := JTF_NUMBER_TABLE();
390: a4 := JTF_VARCHAR2_TABLE_100();
391: a5 := JTF_VARCHAR2_TABLE_100();
392: else
393: a0 := JTF_NUMBER_TABLE();
394: a1 := JTF_NUMBER_TABLE();

Line 391: a5 := JTF_VARCHAR2_TABLE_100();

387: a1 := JTF_NUMBER_TABLE();
388: a2 := JTF_NUMBER_TABLE();
389: a3 := JTF_NUMBER_TABLE();
390: a4 := JTF_VARCHAR2_TABLE_100();
391: a5 := JTF_VARCHAR2_TABLE_100();
392: else
393: a0 := JTF_NUMBER_TABLE();
394: a1 := JTF_NUMBER_TABLE();
395: a2 := JTF_NUMBER_TABLE();

Line 397: a4 := JTF_VARCHAR2_TABLE_100();

393: a0 := JTF_NUMBER_TABLE();
394: a1 := JTF_NUMBER_TABLE();
395: a2 := JTF_NUMBER_TABLE();
396: a3 := JTF_NUMBER_TABLE();
397: a4 := JTF_VARCHAR2_TABLE_100();
398: a5 := JTF_VARCHAR2_TABLE_100();
399: if t.count > 0 then
400: a0.extend(t.count);
401: a1.extend(t.count);

Line 398: a5 := JTF_VARCHAR2_TABLE_100();

394: a1 := JTF_NUMBER_TABLE();
395: a2 := JTF_NUMBER_TABLE();
396: a3 := JTF_NUMBER_TABLE();
397: a4 := JTF_VARCHAR2_TABLE_100();
398: a5 := JTF_VARCHAR2_TABLE_100();
399: if t.count > 0 then
400: a0.extend(t.count);
401: a1.extend(t.count);
402: a2.extend(t.count);

Line 437: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100

433: , p_visit_id NUMBER
434: , p9_a0 out nocopy JTF_NUMBER_TABLE
435: , p9_a1 out nocopy JTF_NUMBER_TABLE
436: , p9_a2 out nocopy JTF_NUMBER_TABLE
437: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
438: , p9_a4 out nocopy JTF_NUMBER_TABLE
439: , p9_a5 out nocopy JTF_NUMBER_TABLE
440: , p9_a6 out nocopy JTF_NUMBER_TABLE
441: , p9_a7 out nocopy JTF_NUMBER_TABLE

Line 446: , p9_a12 out nocopy JTF_VARCHAR2_TABLE_100

442: , p9_a8 out nocopy JTF_NUMBER_TABLE
443: , p9_a9 out nocopy JTF_NUMBER_TABLE
444: , p9_a10 out nocopy JTF_VARCHAR2_TABLE_300
445: , p9_a11 out nocopy JTF_NUMBER_TABLE
446: , p9_a12 out nocopy JTF_VARCHAR2_TABLE_100
447: , p9_a13 out nocopy JTF_VARCHAR2_TABLE_300
448: , p9_a14 out nocopy JTF_VARCHAR2_TABLE_100
449: , p9_a15 out nocopy JTF_NUMBER_TABLE
450: , p9_a16 out nocopy JTF_VARCHAR2_TABLE_100

Line 448: , p9_a14 out nocopy JTF_VARCHAR2_TABLE_100

444: , p9_a10 out nocopy JTF_VARCHAR2_TABLE_300
445: , p9_a11 out nocopy JTF_NUMBER_TABLE
446: , p9_a12 out nocopy JTF_VARCHAR2_TABLE_100
447: , p9_a13 out nocopy JTF_VARCHAR2_TABLE_300
448: , p9_a14 out nocopy JTF_VARCHAR2_TABLE_100
449: , p9_a15 out nocopy JTF_NUMBER_TABLE
450: , p9_a16 out nocopy JTF_VARCHAR2_TABLE_100
451: , p9_a17 out nocopy JTF_VARCHAR2_TABLE_100
452: , p9_a18 out nocopy JTF_VARCHAR2_TABLE_100

Line 450: , p9_a16 out nocopy JTF_VARCHAR2_TABLE_100

446: , p9_a12 out nocopy JTF_VARCHAR2_TABLE_100
447: , p9_a13 out nocopy JTF_VARCHAR2_TABLE_300
448: , p9_a14 out nocopy JTF_VARCHAR2_TABLE_100
449: , p9_a15 out nocopy JTF_NUMBER_TABLE
450: , p9_a16 out nocopy JTF_VARCHAR2_TABLE_100
451: , p9_a17 out nocopy JTF_VARCHAR2_TABLE_100
452: , p9_a18 out nocopy JTF_VARCHAR2_TABLE_100
453: , p9_a19 out nocopy JTF_VARCHAR2_TABLE_100
454: , p9_a20 out nocopy JTF_VARCHAR2_TABLE_100

Line 451: , p9_a17 out nocopy JTF_VARCHAR2_TABLE_100

447: , p9_a13 out nocopy JTF_VARCHAR2_TABLE_300
448: , p9_a14 out nocopy JTF_VARCHAR2_TABLE_100
449: , p9_a15 out nocopy JTF_NUMBER_TABLE
450: , p9_a16 out nocopy JTF_VARCHAR2_TABLE_100
451: , p9_a17 out nocopy JTF_VARCHAR2_TABLE_100
452: , p9_a18 out nocopy JTF_VARCHAR2_TABLE_100
453: , p9_a19 out nocopy JTF_VARCHAR2_TABLE_100
454: , p9_a20 out nocopy JTF_VARCHAR2_TABLE_100
455: , p9_a21 out nocopy JTF_VARCHAR2_TABLE_100

Line 452: , p9_a18 out nocopy JTF_VARCHAR2_TABLE_100

448: , p9_a14 out nocopy JTF_VARCHAR2_TABLE_100
449: , p9_a15 out nocopy JTF_NUMBER_TABLE
450: , p9_a16 out nocopy JTF_VARCHAR2_TABLE_100
451: , p9_a17 out nocopy JTF_VARCHAR2_TABLE_100
452: , p9_a18 out nocopy JTF_VARCHAR2_TABLE_100
453: , p9_a19 out nocopy JTF_VARCHAR2_TABLE_100
454: , p9_a20 out nocopy JTF_VARCHAR2_TABLE_100
455: , p9_a21 out nocopy JTF_VARCHAR2_TABLE_100
456: , p9_a22 out nocopy JTF_NUMBER_TABLE

Line 453: , p9_a19 out nocopy JTF_VARCHAR2_TABLE_100

449: , p9_a15 out nocopy JTF_NUMBER_TABLE
450: , p9_a16 out nocopy JTF_VARCHAR2_TABLE_100
451: , p9_a17 out nocopy JTF_VARCHAR2_TABLE_100
452: , p9_a18 out nocopy JTF_VARCHAR2_TABLE_100
453: , p9_a19 out nocopy JTF_VARCHAR2_TABLE_100
454: , p9_a20 out nocopy JTF_VARCHAR2_TABLE_100
455: , p9_a21 out nocopy JTF_VARCHAR2_TABLE_100
456: , p9_a22 out nocopy JTF_NUMBER_TABLE
457: , p9_a23 out nocopy JTF_NUMBER_TABLE

Line 454: , p9_a20 out nocopy JTF_VARCHAR2_TABLE_100

450: , p9_a16 out nocopy JTF_VARCHAR2_TABLE_100
451: , p9_a17 out nocopy JTF_VARCHAR2_TABLE_100
452: , p9_a18 out nocopy JTF_VARCHAR2_TABLE_100
453: , p9_a19 out nocopy JTF_VARCHAR2_TABLE_100
454: , p9_a20 out nocopy JTF_VARCHAR2_TABLE_100
455: , p9_a21 out nocopy JTF_VARCHAR2_TABLE_100
456: , p9_a22 out nocopy JTF_NUMBER_TABLE
457: , p9_a23 out nocopy JTF_NUMBER_TABLE
458: , p9_a24 out nocopy JTF_VARCHAR2_TABLE_100

Line 455: , p9_a21 out nocopy JTF_VARCHAR2_TABLE_100

451: , p9_a17 out nocopy JTF_VARCHAR2_TABLE_100
452: , p9_a18 out nocopy JTF_VARCHAR2_TABLE_100
453: , p9_a19 out nocopy JTF_VARCHAR2_TABLE_100
454: , p9_a20 out nocopy JTF_VARCHAR2_TABLE_100
455: , p9_a21 out nocopy JTF_VARCHAR2_TABLE_100
456: , p9_a22 out nocopy JTF_NUMBER_TABLE
457: , p9_a23 out nocopy JTF_NUMBER_TABLE
458: , p9_a24 out nocopy JTF_VARCHAR2_TABLE_100
459: , p9_a25 out nocopy JTF_NUMBER_TABLE

Line 458: , p9_a24 out nocopy JTF_VARCHAR2_TABLE_100

454: , p9_a20 out nocopy JTF_VARCHAR2_TABLE_100
455: , p9_a21 out nocopy JTF_VARCHAR2_TABLE_100
456: , p9_a22 out nocopy JTF_NUMBER_TABLE
457: , p9_a23 out nocopy JTF_NUMBER_TABLE
458: , p9_a24 out nocopy JTF_VARCHAR2_TABLE_100
459: , p9_a25 out nocopy JTF_NUMBER_TABLE
460: , p9_a26 out nocopy JTF_VARCHAR2_TABLE_100
461: , p9_a27 out nocopy JTF_VARCHAR2_TABLE_100
462: , p9_a28 out nocopy JTF_NUMBER_TABLE

Line 460: , p9_a26 out nocopy JTF_VARCHAR2_TABLE_100

456: , p9_a22 out nocopy JTF_NUMBER_TABLE
457: , p9_a23 out nocopy JTF_NUMBER_TABLE
458: , p9_a24 out nocopy JTF_VARCHAR2_TABLE_100
459: , p9_a25 out nocopy JTF_NUMBER_TABLE
460: , p9_a26 out nocopy JTF_VARCHAR2_TABLE_100
461: , p9_a27 out nocopy JTF_VARCHAR2_TABLE_100
462: , p9_a28 out nocopy JTF_NUMBER_TABLE
463: , p9_a29 out nocopy JTF_NUMBER_TABLE
464: , p9_a30 out nocopy JTF_VARCHAR2_TABLE_100

Line 461: , p9_a27 out nocopy JTF_VARCHAR2_TABLE_100

457: , p9_a23 out nocopy JTF_NUMBER_TABLE
458: , p9_a24 out nocopy JTF_VARCHAR2_TABLE_100
459: , p9_a25 out nocopy JTF_NUMBER_TABLE
460: , p9_a26 out nocopy JTF_VARCHAR2_TABLE_100
461: , p9_a27 out nocopy JTF_VARCHAR2_TABLE_100
462: , p9_a28 out nocopy JTF_NUMBER_TABLE
463: , p9_a29 out nocopy JTF_NUMBER_TABLE
464: , p9_a30 out nocopy JTF_VARCHAR2_TABLE_100
465: , p9_a31 out nocopy JTF_NUMBER_TABLE

Line 464: , p9_a30 out nocopy JTF_VARCHAR2_TABLE_100

460: , p9_a26 out nocopy JTF_VARCHAR2_TABLE_100
461: , p9_a27 out nocopy JTF_VARCHAR2_TABLE_100
462: , p9_a28 out nocopy JTF_NUMBER_TABLE
463: , p9_a29 out nocopy JTF_NUMBER_TABLE
464: , p9_a30 out nocopy JTF_VARCHAR2_TABLE_100
465: , p9_a31 out nocopy JTF_NUMBER_TABLE
466: , p9_a32 out nocopy JTF_NUMBER_TABLE
467: , p9_a33 out nocopy JTF_NUMBER_TABLE
468: , p9_a34 out nocopy JTF_NUMBER_TABLE

Line 470: , p9_a36 out nocopy JTF_VARCHAR2_TABLE_100

466: , p9_a32 out nocopy JTF_NUMBER_TABLE
467: , p9_a33 out nocopy JTF_NUMBER_TABLE
468: , p9_a34 out nocopy JTF_NUMBER_TABLE
469: , p9_a35 out nocopy JTF_NUMBER_TABLE
470: , p9_a36 out nocopy JTF_VARCHAR2_TABLE_100
471: , p9_a37 out nocopy JTF_VARCHAR2_TABLE_100
472: , p9_a38 out nocopy JTF_VARCHAR2_TABLE_100
473: , p9_a39 out nocopy JTF_NUMBER_TABLE
474: , p9_a40 out nocopy JTF_NUMBER_TABLE

Line 471: , p9_a37 out nocopy JTF_VARCHAR2_TABLE_100

467: , p9_a33 out nocopy JTF_NUMBER_TABLE
468: , p9_a34 out nocopy JTF_NUMBER_TABLE
469: , p9_a35 out nocopy JTF_NUMBER_TABLE
470: , p9_a36 out nocopy JTF_VARCHAR2_TABLE_100
471: , p9_a37 out nocopy JTF_VARCHAR2_TABLE_100
472: , p9_a38 out nocopy JTF_VARCHAR2_TABLE_100
473: , p9_a39 out nocopy JTF_NUMBER_TABLE
474: , p9_a40 out nocopy JTF_NUMBER_TABLE
475: , p9_a41 out nocopy JTF_VARCHAR2_TABLE_100

Line 472: , p9_a38 out nocopy JTF_VARCHAR2_TABLE_100

468: , p9_a34 out nocopy JTF_NUMBER_TABLE
469: , p9_a35 out nocopy JTF_NUMBER_TABLE
470: , p9_a36 out nocopy JTF_VARCHAR2_TABLE_100
471: , p9_a37 out nocopy JTF_VARCHAR2_TABLE_100
472: , p9_a38 out nocopy JTF_VARCHAR2_TABLE_100
473: , p9_a39 out nocopy JTF_NUMBER_TABLE
474: , p9_a40 out nocopy JTF_NUMBER_TABLE
475: , p9_a41 out nocopy JTF_VARCHAR2_TABLE_100
476: , p9_a42 out nocopy JTF_NUMBER_TABLE

Line 475: , p9_a41 out nocopy JTF_VARCHAR2_TABLE_100

471: , p9_a37 out nocopy JTF_VARCHAR2_TABLE_100
472: , p9_a38 out nocopy JTF_VARCHAR2_TABLE_100
473: , p9_a39 out nocopy JTF_NUMBER_TABLE
474: , p9_a40 out nocopy JTF_NUMBER_TABLE
475: , p9_a41 out nocopy JTF_VARCHAR2_TABLE_100
476: , p9_a42 out nocopy JTF_NUMBER_TABLE
477: , p9_a43 out nocopy JTF_VARCHAR2_TABLE_100
478: , x_return_status out nocopy VARCHAR2
479: , x_msg_count out nocopy NUMBER

Line 477: , p9_a43 out nocopy JTF_VARCHAR2_TABLE_100

473: , p9_a39 out nocopy JTF_NUMBER_TABLE
474: , p9_a40 out nocopy JTF_NUMBER_TABLE
475: , p9_a41 out nocopy JTF_VARCHAR2_TABLE_100
476: , p9_a42 out nocopy JTF_NUMBER_TABLE
477: , p9_a43 out nocopy JTF_VARCHAR2_TABLE_100
478: , x_return_status out nocopy VARCHAR2
479: , x_msg_count out nocopy NUMBER
480: , x_msg_data out nocopy VARCHAR2
481: )

Line 587: , p6_a4 in out nocopy JTF_VARCHAR2_TABLE_100

583: , p6_a0 in out nocopy JTF_NUMBER_TABLE
584: , p6_a1 in out nocopy JTF_NUMBER_TABLE
585: , p6_a2 in out nocopy JTF_NUMBER_TABLE
586: , p6_a3 in out nocopy JTF_NUMBER_TABLE
587: , p6_a4 in out nocopy JTF_VARCHAR2_TABLE_100
588: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
589: , x_return_status out nocopy VARCHAR2
590: , x_msg_count out nocopy NUMBER
591: , x_msg_data out nocopy VARCHAR2

Line 588: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100

584: , p6_a1 in out nocopy JTF_NUMBER_TABLE
585: , p6_a2 in out nocopy JTF_NUMBER_TABLE
586: , p6_a3 in out nocopy JTF_NUMBER_TABLE
587: , p6_a4 in out nocopy JTF_VARCHAR2_TABLE_100
588: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
589: , x_return_status out nocopy VARCHAR2
590: , x_msg_count out nocopy NUMBER
591: , x_msg_data out nocopy VARCHAR2
592: )