APPS.OKL_POOL_PVT_W dependencies on JTF_NUMBER_TABLE

Line 25: procedure rosetta_table_copy_in_p46(t out nocopy okl_pool_pvt.polsrch_tbl_type, a0 JTF_NUMBER_TABLE

21: if n=b then return a; end if;
22: return n;
23: end;
24:
25: procedure rosetta_table_copy_in_p46(t out nocopy okl_pool_pvt.polsrch_tbl_type, a0 JTF_NUMBER_TABLE
26: , a1 JTF_VARCHAR2_TABLE_400
27: , a2 JTF_VARCHAR2_TABLE_100
28: , a3 JTF_NUMBER_TABLE
29: , a4 JTF_VARCHAR2_TABLE_200

Line 28: , a3 JTF_NUMBER_TABLE

24:
25: procedure rosetta_table_copy_in_p46(t out nocopy okl_pool_pvt.polsrch_tbl_type, a0 JTF_NUMBER_TABLE
26: , a1 JTF_VARCHAR2_TABLE_400
27: , a2 JTF_VARCHAR2_TABLE_100
28: , a3 JTF_NUMBER_TABLE
29: , a4 JTF_VARCHAR2_TABLE_200
30: , a5 JTF_NUMBER_TABLE
31: , a6 JTF_NUMBER_TABLE
32: , a7 JTF_VARCHAR2_TABLE_100

Line 30: , a5 JTF_NUMBER_TABLE

26: , a1 JTF_VARCHAR2_TABLE_400
27: , a2 JTF_VARCHAR2_TABLE_100
28: , a3 JTF_NUMBER_TABLE
29: , a4 JTF_VARCHAR2_TABLE_200
30: , a5 JTF_NUMBER_TABLE
31: , a6 JTF_NUMBER_TABLE
32: , a7 JTF_VARCHAR2_TABLE_100
33: , a8 JTF_NUMBER_TABLE
34: , a9 JTF_DATE_TABLE

Line 31: , a6 JTF_NUMBER_TABLE

27: , a2 JTF_VARCHAR2_TABLE_100
28: , a3 JTF_NUMBER_TABLE
29: , a4 JTF_VARCHAR2_TABLE_200
30: , a5 JTF_NUMBER_TABLE
31: , a6 JTF_NUMBER_TABLE
32: , a7 JTF_VARCHAR2_TABLE_100
33: , a8 JTF_NUMBER_TABLE
34: , a9 JTF_DATE_TABLE
35: , a10 JTF_DATE_TABLE

Line 33: , a8 JTF_NUMBER_TABLE

29: , a4 JTF_VARCHAR2_TABLE_200
30: , a5 JTF_NUMBER_TABLE
31: , a6 JTF_NUMBER_TABLE
32: , a7 JTF_VARCHAR2_TABLE_100
33: , a8 JTF_NUMBER_TABLE
34: , a9 JTF_DATE_TABLE
35: , a10 JTF_DATE_TABLE
36: , a11 JTF_DATE_TABLE
37: , a12 JTF_DATE_TABLE

Line 38: , a13 JTF_NUMBER_TABLE

34: , a9 JTF_DATE_TABLE
35: , a10 JTF_DATE_TABLE
36: , a11 JTF_DATE_TABLE
37: , a12 JTF_DATE_TABLE
38: , a13 JTF_NUMBER_TABLE
39: , a14 JTF_VARCHAR2_TABLE_100
40: , a15 JTF_VARCHAR2_TABLE_500
41: , a16 JTF_NUMBER_TABLE
42: , a17 JTF_NUMBER_TABLE

Line 41: , a16 JTF_NUMBER_TABLE

37: , a12 JTF_DATE_TABLE
38: , a13 JTF_NUMBER_TABLE
39: , a14 JTF_VARCHAR2_TABLE_100
40: , a15 JTF_VARCHAR2_TABLE_500
41: , a16 JTF_NUMBER_TABLE
42: , a17 JTF_NUMBER_TABLE
43: , a18 JTF_VARCHAR2_TABLE_100
44: , a19 JTF_VARCHAR2_TABLE_100
45: , a20 JTF_VARCHAR2_TABLE_100

Line 42: , a17 JTF_NUMBER_TABLE

38: , a13 JTF_NUMBER_TABLE
39: , a14 JTF_VARCHAR2_TABLE_100
40: , a15 JTF_VARCHAR2_TABLE_500
41: , a16 JTF_NUMBER_TABLE
42: , a17 JTF_NUMBER_TABLE
43: , a18 JTF_VARCHAR2_TABLE_100
44: , a19 JTF_VARCHAR2_TABLE_100
45: , a20 JTF_VARCHAR2_TABLE_100
46: , a21 JTF_NUMBER_TABLE

Line 46: , a21 JTF_NUMBER_TABLE

42: , a17 JTF_NUMBER_TABLE
43: , a18 JTF_VARCHAR2_TABLE_100
44: , a19 JTF_VARCHAR2_TABLE_100
45: , a20 JTF_VARCHAR2_TABLE_100
46: , a21 JTF_NUMBER_TABLE
47: , a22 JTF_NUMBER_TABLE
48: , a23 JTF_NUMBER_TABLE
49: , a24 JTF_NUMBER_TABLE
50: , a25 JTF_NUMBER_TABLE

Line 47: , a22 JTF_NUMBER_TABLE

43: , a18 JTF_VARCHAR2_TABLE_100
44: , a19 JTF_VARCHAR2_TABLE_100
45: , a20 JTF_VARCHAR2_TABLE_100
46: , a21 JTF_NUMBER_TABLE
47: , a22 JTF_NUMBER_TABLE
48: , a23 JTF_NUMBER_TABLE
49: , a24 JTF_NUMBER_TABLE
50: , a25 JTF_NUMBER_TABLE
51: , a26 JTF_NUMBER_TABLE

Line 48: , a23 JTF_NUMBER_TABLE

44: , a19 JTF_VARCHAR2_TABLE_100
45: , a20 JTF_VARCHAR2_TABLE_100
46: , a21 JTF_NUMBER_TABLE
47: , a22 JTF_NUMBER_TABLE
48: , a23 JTF_NUMBER_TABLE
49: , a24 JTF_NUMBER_TABLE
50: , a25 JTF_NUMBER_TABLE
51: , a26 JTF_NUMBER_TABLE
52: , a27 JTF_NUMBER_TABLE

Line 49: , a24 JTF_NUMBER_TABLE

45: , a20 JTF_VARCHAR2_TABLE_100
46: , a21 JTF_NUMBER_TABLE
47: , a22 JTF_NUMBER_TABLE
48: , a23 JTF_NUMBER_TABLE
49: , a24 JTF_NUMBER_TABLE
50: , a25 JTF_NUMBER_TABLE
51: , a26 JTF_NUMBER_TABLE
52: , a27 JTF_NUMBER_TABLE
53: , a28 JTF_VARCHAR2_TABLE_200

Line 50: , a25 JTF_NUMBER_TABLE

46: , a21 JTF_NUMBER_TABLE
47: , a22 JTF_NUMBER_TABLE
48: , a23 JTF_NUMBER_TABLE
49: , a24 JTF_NUMBER_TABLE
50: , a25 JTF_NUMBER_TABLE
51: , a26 JTF_NUMBER_TABLE
52: , a27 JTF_NUMBER_TABLE
53: , a28 JTF_VARCHAR2_TABLE_200
54: , a29 JTF_VARCHAR2_TABLE_200

Line 51: , a26 JTF_NUMBER_TABLE

47: , a22 JTF_NUMBER_TABLE
48: , a23 JTF_NUMBER_TABLE
49: , a24 JTF_NUMBER_TABLE
50: , a25 JTF_NUMBER_TABLE
51: , a26 JTF_NUMBER_TABLE
52: , a27 JTF_NUMBER_TABLE
53: , a28 JTF_VARCHAR2_TABLE_200
54: , a29 JTF_VARCHAR2_TABLE_200
55: , a30 JTF_VARCHAR2_TABLE_100

Line 52: , a27 JTF_NUMBER_TABLE

48: , a23 JTF_NUMBER_TABLE
49: , a24 JTF_NUMBER_TABLE
50: , a25 JTF_NUMBER_TABLE
51: , a26 JTF_NUMBER_TABLE
52: , a27 JTF_NUMBER_TABLE
53: , a28 JTF_VARCHAR2_TABLE_200
54: , a29 JTF_VARCHAR2_TABLE_200
55: , a30 JTF_VARCHAR2_TABLE_100
56: , a31 JTF_VARCHAR2_TABLE_100

Line 59: , a34 JTF_NUMBER_TABLE

55: , a30 JTF_VARCHAR2_TABLE_100
56: , a31 JTF_VARCHAR2_TABLE_100
57: , a32 JTF_DATE_TABLE
58: , a33 JTF_DATE_TABLE
59: , a34 JTF_NUMBER_TABLE
60: , a35 JTF_NUMBER_TABLE
61: , a36 JTF_DATE_TABLE
62: , a37 JTF_DATE_TABLE
63: , a38 JTF_VARCHAR2_TABLE_100

Line 60: , a35 JTF_NUMBER_TABLE

56: , a31 JTF_VARCHAR2_TABLE_100
57: , a32 JTF_DATE_TABLE
58: , a33 JTF_DATE_TABLE
59: , a34 JTF_NUMBER_TABLE
60: , a35 JTF_NUMBER_TABLE
61: , a36 JTF_DATE_TABLE
62: , a37 JTF_DATE_TABLE
63: , a38 JTF_VARCHAR2_TABLE_100
64: , a39 JTF_VARCHAR2_TABLE_100

Line 122: procedure rosetta_table_copy_out_p46(t okl_pool_pvt.polsrch_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

118: end loop;
119: end if;
120: end if;
121: end rosetta_table_copy_in_p46;
122: procedure rosetta_table_copy_out_p46(t okl_pool_pvt.polsrch_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
123: , a1 out nocopy JTF_VARCHAR2_TABLE_400
124: , a2 out nocopy JTF_VARCHAR2_TABLE_100
125: , a3 out nocopy JTF_NUMBER_TABLE
126: , a4 out nocopy JTF_VARCHAR2_TABLE_200

Line 125: , a3 out nocopy JTF_NUMBER_TABLE

121: end rosetta_table_copy_in_p46;
122: procedure rosetta_table_copy_out_p46(t okl_pool_pvt.polsrch_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
123: , a1 out nocopy JTF_VARCHAR2_TABLE_400
124: , a2 out nocopy JTF_VARCHAR2_TABLE_100
125: , a3 out nocopy JTF_NUMBER_TABLE
126: , a4 out nocopy JTF_VARCHAR2_TABLE_200
127: , a5 out nocopy JTF_NUMBER_TABLE
128: , a6 out nocopy JTF_NUMBER_TABLE
129: , a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 127: , a5 out nocopy JTF_NUMBER_TABLE

123: , a1 out nocopy JTF_VARCHAR2_TABLE_400
124: , a2 out nocopy JTF_VARCHAR2_TABLE_100
125: , a3 out nocopy JTF_NUMBER_TABLE
126: , a4 out nocopy JTF_VARCHAR2_TABLE_200
127: , a5 out nocopy JTF_NUMBER_TABLE
128: , a6 out nocopy JTF_NUMBER_TABLE
129: , a7 out nocopy JTF_VARCHAR2_TABLE_100
130: , a8 out nocopy JTF_NUMBER_TABLE
131: , a9 out nocopy JTF_DATE_TABLE

Line 128: , a6 out nocopy JTF_NUMBER_TABLE

124: , a2 out nocopy JTF_VARCHAR2_TABLE_100
125: , a3 out nocopy JTF_NUMBER_TABLE
126: , a4 out nocopy JTF_VARCHAR2_TABLE_200
127: , a5 out nocopy JTF_NUMBER_TABLE
128: , a6 out nocopy JTF_NUMBER_TABLE
129: , a7 out nocopy JTF_VARCHAR2_TABLE_100
130: , a8 out nocopy JTF_NUMBER_TABLE
131: , a9 out nocopy JTF_DATE_TABLE
132: , a10 out nocopy JTF_DATE_TABLE

Line 130: , a8 out nocopy JTF_NUMBER_TABLE

126: , a4 out nocopy JTF_VARCHAR2_TABLE_200
127: , a5 out nocopy JTF_NUMBER_TABLE
128: , a6 out nocopy JTF_NUMBER_TABLE
129: , a7 out nocopy JTF_VARCHAR2_TABLE_100
130: , a8 out nocopy JTF_NUMBER_TABLE
131: , a9 out nocopy JTF_DATE_TABLE
132: , a10 out nocopy JTF_DATE_TABLE
133: , a11 out nocopy JTF_DATE_TABLE
134: , a12 out nocopy JTF_DATE_TABLE

Line 135: , a13 out nocopy JTF_NUMBER_TABLE

131: , a9 out nocopy JTF_DATE_TABLE
132: , a10 out nocopy JTF_DATE_TABLE
133: , a11 out nocopy JTF_DATE_TABLE
134: , a12 out nocopy JTF_DATE_TABLE
135: , a13 out nocopy JTF_NUMBER_TABLE
136: , a14 out nocopy JTF_VARCHAR2_TABLE_100
137: , a15 out nocopy JTF_VARCHAR2_TABLE_500
138: , a16 out nocopy JTF_NUMBER_TABLE
139: , a17 out nocopy JTF_NUMBER_TABLE

Line 138: , a16 out nocopy JTF_NUMBER_TABLE

134: , a12 out nocopy JTF_DATE_TABLE
135: , a13 out nocopy JTF_NUMBER_TABLE
136: , a14 out nocopy JTF_VARCHAR2_TABLE_100
137: , a15 out nocopy JTF_VARCHAR2_TABLE_500
138: , a16 out nocopy JTF_NUMBER_TABLE
139: , a17 out nocopy JTF_NUMBER_TABLE
140: , a18 out nocopy JTF_VARCHAR2_TABLE_100
141: , a19 out nocopy JTF_VARCHAR2_TABLE_100
142: , a20 out nocopy JTF_VARCHAR2_TABLE_100

Line 139: , a17 out nocopy JTF_NUMBER_TABLE

135: , a13 out nocopy JTF_NUMBER_TABLE
136: , a14 out nocopy JTF_VARCHAR2_TABLE_100
137: , a15 out nocopy JTF_VARCHAR2_TABLE_500
138: , a16 out nocopy JTF_NUMBER_TABLE
139: , a17 out nocopy JTF_NUMBER_TABLE
140: , a18 out nocopy JTF_VARCHAR2_TABLE_100
141: , a19 out nocopy JTF_VARCHAR2_TABLE_100
142: , a20 out nocopy JTF_VARCHAR2_TABLE_100
143: , a21 out nocopy JTF_NUMBER_TABLE

Line 143: , a21 out nocopy JTF_NUMBER_TABLE

139: , a17 out nocopy JTF_NUMBER_TABLE
140: , a18 out nocopy JTF_VARCHAR2_TABLE_100
141: , a19 out nocopy JTF_VARCHAR2_TABLE_100
142: , a20 out nocopy JTF_VARCHAR2_TABLE_100
143: , a21 out nocopy JTF_NUMBER_TABLE
144: , a22 out nocopy JTF_NUMBER_TABLE
145: , a23 out nocopy JTF_NUMBER_TABLE
146: , a24 out nocopy JTF_NUMBER_TABLE
147: , a25 out nocopy JTF_NUMBER_TABLE

Line 144: , a22 out nocopy JTF_NUMBER_TABLE

140: , a18 out nocopy JTF_VARCHAR2_TABLE_100
141: , a19 out nocopy JTF_VARCHAR2_TABLE_100
142: , a20 out nocopy JTF_VARCHAR2_TABLE_100
143: , a21 out nocopy JTF_NUMBER_TABLE
144: , a22 out nocopy JTF_NUMBER_TABLE
145: , a23 out nocopy JTF_NUMBER_TABLE
146: , a24 out nocopy JTF_NUMBER_TABLE
147: , a25 out nocopy JTF_NUMBER_TABLE
148: , a26 out nocopy JTF_NUMBER_TABLE

Line 145: , a23 out nocopy JTF_NUMBER_TABLE

141: , a19 out nocopy JTF_VARCHAR2_TABLE_100
142: , a20 out nocopy JTF_VARCHAR2_TABLE_100
143: , a21 out nocopy JTF_NUMBER_TABLE
144: , a22 out nocopy JTF_NUMBER_TABLE
145: , a23 out nocopy JTF_NUMBER_TABLE
146: , a24 out nocopy JTF_NUMBER_TABLE
147: , a25 out nocopy JTF_NUMBER_TABLE
148: , a26 out nocopy JTF_NUMBER_TABLE
149: , a27 out nocopy JTF_NUMBER_TABLE

Line 146: , a24 out nocopy JTF_NUMBER_TABLE

142: , a20 out nocopy JTF_VARCHAR2_TABLE_100
143: , a21 out nocopy JTF_NUMBER_TABLE
144: , a22 out nocopy JTF_NUMBER_TABLE
145: , a23 out nocopy JTF_NUMBER_TABLE
146: , a24 out nocopy JTF_NUMBER_TABLE
147: , a25 out nocopy JTF_NUMBER_TABLE
148: , a26 out nocopy JTF_NUMBER_TABLE
149: , a27 out nocopy JTF_NUMBER_TABLE
150: , a28 out nocopy JTF_VARCHAR2_TABLE_200

Line 147: , a25 out nocopy JTF_NUMBER_TABLE

143: , a21 out nocopy JTF_NUMBER_TABLE
144: , a22 out nocopy JTF_NUMBER_TABLE
145: , a23 out nocopy JTF_NUMBER_TABLE
146: , a24 out nocopy JTF_NUMBER_TABLE
147: , a25 out nocopy JTF_NUMBER_TABLE
148: , a26 out nocopy JTF_NUMBER_TABLE
149: , a27 out nocopy JTF_NUMBER_TABLE
150: , a28 out nocopy JTF_VARCHAR2_TABLE_200
151: , a29 out nocopy JTF_VARCHAR2_TABLE_200

Line 148: , a26 out nocopy JTF_NUMBER_TABLE

144: , a22 out nocopy JTF_NUMBER_TABLE
145: , a23 out nocopy JTF_NUMBER_TABLE
146: , a24 out nocopy JTF_NUMBER_TABLE
147: , a25 out nocopy JTF_NUMBER_TABLE
148: , a26 out nocopy JTF_NUMBER_TABLE
149: , a27 out nocopy JTF_NUMBER_TABLE
150: , a28 out nocopy JTF_VARCHAR2_TABLE_200
151: , a29 out nocopy JTF_VARCHAR2_TABLE_200
152: , a30 out nocopy JTF_VARCHAR2_TABLE_100

Line 149: , a27 out nocopy JTF_NUMBER_TABLE

145: , a23 out nocopy JTF_NUMBER_TABLE
146: , a24 out nocopy JTF_NUMBER_TABLE
147: , a25 out nocopy JTF_NUMBER_TABLE
148: , a26 out nocopy JTF_NUMBER_TABLE
149: , a27 out nocopy JTF_NUMBER_TABLE
150: , a28 out nocopy JTF_VARCHAR2_TABLE_200
151: , a29 out nocopy JTF_VARCHAR2_TABLE_200
152: , a30 out nocopy JTF_VARCHAR2_TABLE_100
153: , a31 out nocopy JTF_VARCHAR2_TABLE_100

Line 156: , a34 out nocopy JTF_NUMBER_TABLE

152: , a30 out nocopy JTF_VARCHAR2_TABLE_100
153: , a31 out nocopy JTF_VARCHAR2_TABLE_100
154: , a32 out nocopy JTF_DATE_TABLE
155: , a33 out nocopy JTF_DATE_TABLE
156: , a34 out nocopy JTF_NUMBER_TABLE
157: , a35 out nocopy JTF_NUMBER_TABLE
158: , a36 out nocopy JTF_DATE_TABLE
159: , a37 out nocopy JTF_DATE_TABLE
160: , a38 out nocopy JTF_VARCHAR2_TABLE_100

Line 157: , a35 out nocopy JTF_NUMBER_TABLE

153: , a31 out nocopy JTF_VARCHAR2_TABLE_100
154: , a32 out nocopy JTF_DATE_TABLE
155: , a33 out nocopy JTF_DATE_TABLE
156: , a34 out nocopy JTF_NUMBER_TABLE
157: , a35 out nocopy JTF_NUMBER_TABLE
158: , a36 out nocopy JTF_DATE_TABLE
159: , a37 out nocopy JTF_DATE_TABLE
160: , a38 out nocopy JTF_VARCHAR2_TABLE_100
161: , a39 out nocopy JTF_VARCHAR2_TABLE_100

Line 166: a0 := JTF_NUMBER_TABLE();

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_400();
168: a2 := JTF_VARCHAR2_TABLE_100();
169: a3 := JTF_NUMBER_TABLE();
170: a4 := JTF_VARCHAR2_TABLE_200();

Line 169: a3 := JTF_NUMBER_TABLE();

165: if t is null or t.count = 0 then
166: a0 := JTF_NUMBER_TABLE();
167: a1 := JTF_VARCHAR2_TABLE_400();
168: a2 := JTF_VARCHAR2_TABLE_100();
169: a3 := JTF_NUMBER_TABLE();
170: a4 := JTF_VARCHAR2_TABLE_200();
171: a5 := JTF_NUMBER_TABLE();
172: a6 := JTF_NUMBER_TABLE();
173: a7 := JTF_VARCHAR2_TABLE_100();

Line 171: a5 := JTF_NUMBER_TABLE();

167: a1 := JTF_VARCHAR2_TABLE_400();
168: a2 := JTF_VARCHAR2_TABLE_100();
169: a3 := JTF_NUMBER_TABLE();
170: a4 := JTF_VARCHAR2_TABLE_200();
171: a5 := JTF_NUMBER_TABLE();
172: a6 := JTF_NUMBER_TABLE();
173: a7 := JTF_VARCHAR2_TABLE_100();
174: a8 := JTF_NUMBER_TABLE();
175: a9 := JTF_DATE_TABLE();

Line 172: a6 := JTF_NUMBER_TABLE();

168: a2 := JTF_VARCHAR2_TABLE_100();
169: a3 := JTF_NUMBER_TABLE();
170: a4 := JTF_VARCHAR2_TABLE_200();
171: a5 := JTF_NUMBER_TABLE();
172: a6 := JTF_NUMBER_TABLE();
173: a7 := JTF_VARCHAR2_TABLE_100();
174: a8 := JTF_NUMBER_TABLE();
175: a9 := JTF_DATE_TABLE();
176: a10 := JTF_DATE_TABLE();

Line 174: a8 := JTF_NUMBER_TABLE();

170: a4 := JTF_VARCHAR2_TABLE_200();
171: a5 := JTF_NUMBER_TABLE();
172: a6 := JTF_NUMBER_TABLE();
173: a7 := JTF_VARCHAR2_TABLE_100();
174: a8 := JTF_NUMBER_TABLE();
175: a9 := JTF_DATE_TABLE();
176: a10 := JTF_DATE_TABLE();
177: a11 := JTF_DATE_TABLE();
178: a12 := JTF_DATE_TABLE();

Line 179: a13 := JTF_NUMBER_TABLE();

175: a9 := JTF_DATE_TABLE();
176: a10 := JTF_DATE_TABLE();
177: a11 := JTF_DATE_TABLE();
178: a12 := JTF_DATE_TABLE();
179: a13 := JTF_NUMBER_TABLE();
180: a14 := JTF_VARCHAR2_TABLE_100();
181: a15 := JTF_VARCHAR2_TABLE_500();
182: a16 := JTF_NUMBER_TABLE();
183: a17 := JTF_NUMBER_TABLE();

Line 182: a16 := JTF_NUMBER_TABLE();

178: a12 := JTF_DATE_TABLE();
179: a13 := JTF_NUMBER_TABLE();
180: a14 := JTF_VARCHAR2_TABLE_100();
181: a15 := JTF_VARCHAR2_TABLE_500();
182: a16 := JTF_NUMBER_TABLE();
183: a17 := JTF_NUMBER_TABLE();
184: a18 := JTF_VARCHAR2_TABLE_100();
185: a19 := JTF_VARCHAR2_TABLE_100();
186: a20 := JTF_VARCHAR2_TABLE_100();

Line 183: a17 := JTF_NUMBER_TABLE();

179: a13 := JTF_NUMBER_TABLE();
180: a14 := JTF_VARCHAR2_TABLE_100();
181: a15 := JTF_VARCHAR2_TABLE_500();
182: a16 := JTF_NUMBER_TABLE();
183: a17 := JTF_NUMBER_TABLE();
184: a18 := JTF_VARCHAR2_TABLE_100();
185: a19 := JTF_VARCHAR2_TABLE_100();
186: a20 := JTF_VARCHAR2_TABLE_100();
187: a21 := JTF_NUMBER_TABLE();

Line 187: a21 := JTF_NUMBER_TABLE();

183: a17 := JTF_NUMBER_TABLE();
184: a18 := JTF_VARCHAR2_TABLE_100();
185: a19 := JTF_VARCHAR2_TABLE_100();
186: a20 := JTF_VARCHAR2_TABLE_100();
187: a21 := JTF_NUMBER_TABLE();
188: a22 := JTF_NUMBER_TABLE();
189: a23 := JTF_NUMBER_TABLE();
190: a24 := JTF_NUMBER_TABLE();
191: a25 := JTF_NUMBER_TABLE();

Line 188: a22 := JTF_NUMBER_TABLE();

184: a18 := JTF_VARCHAR2_TABLE_100();
185: a19 := JTF_VARCHAR2_TABLE_100();
186: a20 := JTF_VARCHAR2_TABLE_100();
187: a21 := JTF_NUMBER_TABLE();
188: a22 := JTF_NUMBER_TABLE();
189: a23 := JTF_NUMBER_TABLE();
190: a24 := JTF_NUMBER_TABLE();
191: a25 := JTF_NUMBER_TABLE();
192: a26 := JTF_NUMBER_TABLE();

Line 189: a23 := JTF_NUMBER_TABLE();

185: a19 := JTF_VARCHAR2_TABLE_100();
186: a20 := JTF_VARCHAR2_TABLE_100();
187: a21 := JTF_NUMBER_TABLE();
188: a22 := JTF_NUMBER_TABLE();
189: a23 := JTF_NUMBER_TABLE();
190: a24 := JTF_NUMBER_TABLE();
191: a25 := JTF_NUMBER_TABLE();
192: a26 := JTF_NUMBER_TABLE();
193: a27 := JTF_NUMBER_TABLE();

Line 190: a24 := JTF_NUMBER_TABLE();

186: a20 := JTF_VARCHAR2_TABLE_100();
187: a21 := JTF_NUMBER_TABLE();
188: a22 := JTF_NUMBER_TABLE();
189: a23 := JTF_NUMBER_TABLE();
190: a24 := JTF_NUMBER_TABLE();
191: a25 := JTF_NUMBER_TABLE();
192: a26 := JTF_NUMBER_TABLE();
193: a27 := JTF_NUMBER_TABLE();
194: a28 := JTF_VARCHAR2_TABLE_200();

Line 191: a25 := JTF_NUMBER_TABLE();

187: a21 := JTF_NUMBER_TABLE();
188: a22 := JTF_NUMBER_TABLE();
189: a23 := JTF_NUMBER_TABLE();
190: a24 := JTF_NUMBER_TABLE();
191: a25 := JTF_NUMBER_TABLE();
192: a26 := JTF_NUMBER_TABLE();
193: a27 := JTF_NUMBER_TABLE();
194: a28 := JTF_VARCHAR2_TABLE_200();
195: a29 := JTF_VARCHAR2_TABLE_200();

Line 192: a26 := JTF_NUMBER_TABLE();

188: a22 := JTF_NUMBER_TABLE();
189: a23 := JTF_NUMBER_TABLE();
190: a24 := JTF_NUMBER_TABLE();
191: a25 := JTF_NUMBER_TABLE();
192: a26 := JTF_NUMBER_TABLE();
193: a27 := JTF_NUMBER_TABLE();
194: a28 := JTF_VARCHAR2_TABLE_200();
195: a29 := JTF_VARCHAR2_TABLE_200();
196: a30 := JTF_VARCHAR2_TABLE_100();

Line 193: a27 := JTF_NUMBER_TABLE();

189: a23 := JTF_NUMBER_TABLE();
190: a24 := JTF_NUMBER_TABLE();
191: a25 := JTF_NUMBER_TABLE();
192: a26 := JTF_NUMBER_TABLE();
193: a27 := JTF_NUMBER_TABLE();
194: a28 := JTF_VARCHAR2_TABLE_200();
195: a29 := JTF_VARCHAR2_TABLE_200();
196: a30 := JTF_VARCHAR2_TABLE_100();
197: a31 := JTF_VARCHAR2_TABLE_100();

Line 200: a34 := JTF_NUMBER_TABLE();

196: a30 := JTF_VARCHAR2_TABLE_100();
197: a31 := JTF_VARCHAR2_TABLE_100();
198: a32 := JTF_DATE_TABLE();
199: a33 := JTF_DATE_TABLE();
200: a34 := JTF_NUMBER_TABLE();
201: a35 := JTF_NUMBER_TABLE();
202: a36 := JTF_DATE_TABLE();
203: a37 := JTF_DATE_TABLE();
204: a38 := JTF_VARCHAR2_TABLE_100();

Line 201: a35 := JTF_NUMBER_TABLE();

197: a31 := JTF_VARCHAR2_TABLE_100();
198: a32 := JTF_DATE_TABLE();
199: a33 := JTF_DATE_TABLE();
200: a34 := JTF_NUMBER_TABLE();
201: a35 := JTF_NUMBER_TABLE();
202: a36 := JTF_DATE_TABLE();
203: a37 := JTF_DATE_TABLE();
204: a38 := JTF_VARCHAR2_TABLE_100();
205: a39 := JTF_VARCHAR2_TABLE_100();

Line 207: a0 := JTF_NUMBER_TABLE();

203: a37 := JTF_DATE_TABLE();
204: a38 := JTF_VARCHAR2_TABLE_100();
205: a39 := JTF_VARCHAR2_TABLE_100();
206: else
207: a0 := JTF_NUMBER_TABLE();
208: a1 := JTF_VARCHAR2_TABLE_400();
209: a2 := JTF_VARCHAR2_TABLE_100();
210: a3 := JTF_NUMBER_TABLE();
211: a4 := JTF_VARCHAR2_TABLE_200();

Line 210: a3 := JTF_NUMBER_TABLE();

206: else
207: a0 := JTF_NUMBER_TABLE();
208: a1 := JTF_VARCHAR2_TABLE_400();
209: a2 := JTF_VARCHAR2_TABLE_100();
210: a3 := JTF_NUMBER_TABLE();
211: a4 := JTF_VARCHAR2_TABLE_200();
212: a5 := JTF_NUMBER_TABLE();
213: a6 := JTF_NUMBER_TABLE();
214: a7 := JTF_VARCHAR2_TABLE_100();

Line 212: a5 := JTF_NUMBER_TABLE();

208: a1 := JTF_VARCHAR2_TABLE_400();
209: a2 := JTF_VARCHAR2_TABLE_100();
210: a3 := JTF_NUMBER_TABLE();
211: a4 := JTF_VARCHAR2_TABLE_200();
212: a5 := JTF_NUMBER_TABLE();
213: a6 := JTF_NUMBER_TABLE();
214: a7 := JTF_VARCHAR2_TABLE_100();
215: a8 := JTF_NUMBER_TABLE();
216: a9 := JTF_DATE_TABLE();

Line 213: a6 := JTF_NUMBER_TABLE();

209: a2 := JTF_VARCHAR2_TABLE_100();
210: a3 := JTF_NUMBER_TABLE();
211: a4 := JTF_VARCHAR2_TABLE_200();
212: a5 := JTF_NUMBER_TABLE();
213: a6 := JTF_NUMBER_TABLE();
214: a7 := JTF_VARCHAR2_TABLE_100();
215: a8 := JTF_NUMBER_TABLE();
216: a9 := JTF_DATE_TABLE();
217: a10 := JTF_DATE_TABLE();

Line 215: a8 := JTF_NUMBER_TABLE();

211: a4 := JTF_VARCHAR2_TABLE_200();
212: a5 := JTF_NUMBER_TABLE();
213: a6 := JTF_NUMBER_TABLE();
214: a7 := JTF_VARCHAR2_TABLE_100();
215: a8 := JTF_NUMBER_TABLE();
216: a9 := JTF_DATE_TABLE();
217: a10 := JTF_DATE_TABLE();
218: a11 := JTF_DATE_TABLE();
219: a12 := JTF_DATE_TABLE();

Line 220: a13 := JTF_NUMBER_TABLE();

216: a9 := JTF_DATE_TABLE();
217: a10 := JTF_DATE_TABLE();
218: a11 := JTF_DATE_TABLE();
219: a12 := JTF_DATE_TABLE();
220: a13 := JTF_NUMBER_TABLE();
221: a14 := JTF_VARCHAR2_TABLE_100();
222: a15 := JTF_VARCHAR2_TABLE_500();
223: a16 := JTF_NUMBER_TABLE();
224: a17 := JTF_NUMBER_TABLE();

Line 223: a16 := JTF_NUMBER_TABLE();

219: a12 := JTF_DATE_TABLE();
220: a13 := JTF_NUMBER_TABLE();
221: a14 := JTF_VARCHAR2_TABLE_100();
222: a15 := JTF_VARCHAR2_TABLE_500();
223: a16 := JTF_NUMBER_TABLE();
224: a17 := JTF_NUMBER_TABLE();
225: a18 := JTF_VARCHAR2_TABLE_100();
226: a19 := JTF_VARCHAR2_TABLE_100();
227: a20 := JTF_VARCHAR2_TABLE_100();

Line 224: a17 := JTF_NUMBER_TABLE();

220: a13 := JTF_NUMBER_TABLE();
221: a14 := JTF_VARCHAR2_TABLE_100();
222: a15 := JTF_VARCHAR2_TABLE_500();
223: a16 := JTF_NUMBER_TABLE();
224: a17 := JTF_NUMBER_TABLE();
225: a18 := JTF_VARCHAR2_TABLE_100();
226: a19 := JTF_VARCHAR2_TABLE_100();
227: a20 := JTF_VARCHAR2_TABLE_100();
228: a21 := JTF_NUMBER_TABLE();

Line 228: a21 := JTF_NUMBER_TABLE();

224: a17 := JTF_NUMBER_TABLE();
225: a18 := JTF_VARCHAR2_TABLE_100();
226: a19 := JTF_VARCHAR2_TABLE_100();
227: a20 := JTF_VARCHAR2_TABLE_100();
228: a21 := JTF_NUMBER_TABLE();
229: a22 := JTF_NUMBER_TABLE();
230: a23 := JTF_NUMBER_TABLE();
231: a24 := JTF_NUMBER_TABLE();
232: a25 := JTF_NUMBER_TABLE();

Line 229: a22 := JTF_NUMBER_TABLE();

225: a18 := JTF_VARCHAR2_TABLE_100();
226: a19 := JTF_VARCHAR2_TABLE_100();
227: a20 := JTF_VARCHAR2_TABLE_100();
228: a21 := JTF_NUMBER_TABLE();
229: a22 := JTF_NUMBER_TABLE();
230: a23 := JTF_NUMBER_TABLE();
231: a24 := JTF_NUMBER_TABLE();
232: a25 := JTF_NUMBER_TABLE();
233: a26 := JTF_NUMBER_TABLE();

Line 230: a23 := JTF_NUMBER_TABLE();

226: a19 := JTF_VARCHAR2_TABLE_100();
227: a20 := JTF_VARCHAR2_TABLE_100();
228: a21 := JTF_NUMBER_TABLE();
229: a22 := JTF_NUMBER_TABLE();
230: a23 := JTF_NUMBER_TABLE();
231: a24 := JTF_NUMBER_TABLE();
232: a25 := JTF_NUMBER_TABLE();
233: a26 := JTF_NUMBER_TABLE();
234: a27 := JTF_NUMBER_TABLE();

Line 231: a24 := JTF_NUMBER_TABLE();

227: a20 := JTF_VARCHAR2_TABLE_100();
228: a21 := JTF_NUMBER_TABLE();
229: a22 := JTF_NUMBER_TABLE();
230: a23 := JTF_NUMBER_TABLE();
231: a24 := JTF_NUMBER_TABLE();
232: a25 := JTF_NUMBER_TABLE();
233: a26 := JTF_NUMBER_TABLE();
234: a27 := JTF_NUMBER_TABLE();
235: a28 := JTF_VARCHAR2_TABLE_200();

Line 232: a25 := JTF_NUMBER_TABLE();

228: a21 := JTF_NUMBER_TABLE();
229: a22 := JTF_NUMBER_TABLE();
230: a23 := JTF_NUMBER_TABLE();
231: a24 := JTF_NUMBER_TABLE();
232: a25 := JTF_NUMBER_TABLE();
233: a26 := JTF_NUMBER_TABLE();
234: a27 := JTF_NUMBER_TABLE();
235: a28 := JTF_VARCHAR2_TABLE_200();
236: a29 := JTF_VARCHAR2_TABLE_200();

Line 233: a26 := JTF_NUMBER_TABLE();

229: a22 := JTF_NUMBER_TABLE();
230: a23 := JTF_NUMBER_TABLE();
231: a24 := JTF_NUMBER_TABLE();
232: a25 := JTF_NUMBER_TABLE();
233: a26 := JTF_NUMBER_TABLE();
234: a27 := JTF_NUMBER_TABLE();
235: a28 := JTF_VARCHAR2_TABLE_200();
236: a29 := JTF_VARCHAR2_TABLE_200();
237: a30 := JTF_VARCHAR2_TABLE_100();

Line 234: a27 := JTF_NUMBER_TABLE();

230: a23 := JTF_NUMBER_TABLE();
231: a24 := JTF_NUMBER_TABLE();
232: a25 := JTF_NUMBER_TABLE();
233: a26 := JTF_NUMBER_TABLE();
234: a27 := JTF_NUMBER_TABLE();
235: a28 := JTF_VARCHAR2_TABLE_200();
236: a29 := JTF_VARCHAR2_TABLE_200();
237: a30 := JTF_VARCHAR2_TABLE_100();
238: a31 := JTF_VARCHAR2_TABLE_100();

Line 241: a34 := JTF_NUMBER_TABLE();

237: a30 := JTF_VARCHAR2_TABLE_100();
238: a31 := JTF_VARCHAR2_TABLE_100();
239: a32 := JTF_DATE_TABLE();
240: a33 := JTF_DATE_TABLE();
241: a34 := JTF_NUMBER_TABLE();
242: a35 := JTF_NUMBER_TABLE();
243: a36 := JTF_DATE_TABLE();
244: a37 := JTF_DATE_TABLE();
245: a38 := JTF_VARCHAR2_TABLE_100();

Line 242: a35 := JTF_NUMBER_TABLE();

238: a31 := JTF_VARCHAR2_TABLE_100();
239: a32 := JTF_DATE_TABLE();
240: a33 := JTF_DATE_TABLE();
241: a34 := JTF_NUMBER_TABLE();
242: a35 := JTF_NUMBER_TABLE();
243: a36 := JTF_DATE_TABLE();
244: a37 := JTF_DATE_TABLE();
245: a38 := JTF_VARCHAR2_TABLE_100();
246: a39 := JTF_VARCHAR2_TABLE_100();

Line 341: procedure rosetta_table_copy_in_p48(t out nocopy okl_pool_pvt.poc_uv_tbl_type, a0 JTF_NUMBER_TABLE

337: end if;
338: end if;
339: end rosetta_table_copy_out_p46;
340:
341: procedure rosetta_table_copy_in_p48(t out nocopy okl_pool_pvt.poc_uv_tbl_type, a0 JTF_NUMBER_TABLE
342: , a1 JTF_VARCHAR2_TABLE_200
343: , a2 JTF_VARCHAR2_TABLE_200
344: , a3 JTF_VARCHAR2_TABLE_400
345: , a4 JTF_VARCHAR2_TABLE_200

Line 346: , a5 JTF_NUMBER_TABLE

342: , a1 JTF_VARCHAR2_TABLE_200
343: , a2 JTF_VARCHAR2_TABLE_200
344: , a3 JTF_VARCHAR2_TABLE_400
345: , a4 JTF_VARCHAR2_TABLE_200
346: , a5 JTF_NUMBER_TABLE
347: , a6 JTF_VARCHAR2_TABLE_100
348: , a7 JTF_VARCHAR2_TABLE_100
349: , a8 JTF_VARCHAR2_TABLE_100
350: ) as

Line 376: procedure rosetta_table_copy_out_p48(t okl_pool_pvt.poc_uv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

372: end loop;
373: end if;
374: end if;
375: end rosetta_table_copy_in_p48;
376: procedure rosetta_table_copy_out_p48(t okl_pool_pvt.poc_uv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
377: , a1 out nocopy JTF_VARCHAR2_TABLE_200
378: , a2 out nocopy JTF_VARCHAR2_TABLE_200
379: , a3 out nocopy JTF_VARCHAR2_TABLE_400
380: , a4 out nocopy JTF_VARCHAR2_TABLE_200

Line 381: , a5 out nocopy JTF_NUMBER_TABLE

377: , a1 out nocopy JTF_VARCHAR2_TABLE_200
378: , a2 out nocopy JTF_VARCHAR2_TABLE_200
379: , a3 out nocopy JTF_VARCHAR2_TABLE_400
380: , a4 out nocopy JTF_VARCHAR2_TABLE_200
381: , a5 out nocopy JTF_NUMBER_TABLE
382: , a6 out nocopy JTF_VARCHAR2_TABLE_100
383: , a7 out nocopy JTF_VARCHAR2_TABLE_100
384: , a8 out nocopy JTF_VARCHAR2_TABLE_100
385: ) as

Line 389: a0 := JTF_NUMBER_TABLE();

385: ) as
386: ddindx binary_integer; indx binary_integer;
387: begin
388: if t is null or t.count = 0 then
389: a0 := JTF_NUMBER_TABLE();
390: a1 := JTF_VARCHAR2_TABLE_200();
391: a2 := JTF_VARCHAR2_TABLE_200();
392: a3 := JTF_VARCHAR2_TABLE_400();
393: a4 := JTF_VARCHAR2_TABLE_200();

Line 394: a5 := JTF_NUMBER_TABLE();

390: a1 := JTF_VARCHAR2_TABLE_200();
391: a2 := JTF_VARCHAR2_TABLE_200();
392: a3 := JTF_VARCHAR2_TABLE_400();
393: a4 := JTF_VARCHAR2_TABLE_200();
394: a5 := JTF_NUMBER_TABLE();
395: a6 := JTF_VARCHAR2_TABLE_100();
396: a7 := JTF_VARCHAR2_TABLE_100();
397: a8 := JTF_VARCHAR2_TABLE_100();
398: else

Line 399: a0 := JTF_NUMBER_TABLE();

395: a6 := JTF_VARCHAR2_TABLE_100();
396: a7 := JTF_VARCHAR2_TABLE_100();
397: a8 := JTF_VARCHAR2_TABLE_100();
398: else
399: a0 := JTF_NUMBER_TABLE();
400: a1 := JTF_VARCHAR2_TABLE_200();
401: a2 := JTF_VARCHAR2_TABLE_200();
402: a3 := JTF_VARCHAR2_TABLE_400();
403: a4 := JTF_VARCHAR2_TABLE_200();

Line 404: a5 := JTF_NUMBER_TABLE();

400: a1 := JTF_VARCHAR2_TABLE_200();
401: a2 := JTF_VARCHAR2_TABLE_200();
402: a3 := JTF_VARCHAR2_TABLE_400();
403: a4 := JTF_VARCHAR2_TABLE_200();
404: a5 := JTF_NUMBER_TABLE();
405: a6 := JTF_VARCHAR2_TABLE_100();
406: a7 := JTF_VARCHAR2_TABLE_100();
407: a8 := JTF_VARCHAR2_TABLE_100();
408: if t.count > 0 then

Line 1197: , p5_a0 JTF_NUMBER_TABLE

1193: , p_init_msg_list VARCHAR2
1194: , x_return_status out nocopy VARCHAR2
1195: , x_msg_count out nocopy NUMBER
1196: , x_msg_data out nocopy VARCHAR2
1197: , p5_a0 JTF_NUMBER_TABLE
1198: , p5_a1 JTF_NUMBER_TABLE
1199: , p5_a2 JTF_NUMBER_TABLE
1200: , p5_a3 JTF_NUMBER_TABLE
1201: , p5_a4 JTF_NUMBER_TABLE

Line 1198: , p5_a1 JTF_NUMBER_TABLE

1194: , x_return_status out nocopy VARCHAR2
1195: , x_msg_count out nocopy NUMBER
1196: , x_msg_data out nocopy VARCHAR2
1197: , p5_a0 JTF_NUMBER_TABLE
1198: , p5_a1 JTF_NUMBER_TABLE
1199: , p5_a2 JTF_NUMBER_TABLE
1200: , p5_a3 JTF_NUMBER_TABLE
1201: , p5_a4 JTF_NUMBER_TABLE
1202: , p5_a5 JTF_NUMBER_TABLE

Line 1199: , p5_a2 JTF_NUMBER_TABLE

1195: , x_msg_count out nocopy NUMBER
1196: , x_msg_data out nocopy VARCHAR2
1197: , p5_a0 JTF_NUMBER_TABLE
1198: , p5_a1 JTF_NUMBER_TABLE
1199: , p5_a2 JTF_NUMBER_TABLE
1200: , p5_a3 JTF_NUMBER_TABLE
1201: , p5_a4 JTF_NUMBER_TABLE
1202: , p5_a5 JTF_NUMBER_TABLE
1203: , p5_a6 JTF_NUMBER_TABLE

Line 1200: , p5_a3 JTF_NUMBER_TABLE

1196: , x_msg_data out nocopy VARCHAR2
1197: , p5_a0 JTF_NUMBER_TABLE
1198: , p5_a1 JTF_NUMBER_TABLE
1199: , p5_a2 JTF_NUMBER_TABLE
1200: , p5_a3 JTF_NUMBER_TABLE
1201: , p5_a4 JTF_NUMBER_TABLE
1202: , p5_a5 JTF_NUMBER_TABLE
1203: , p5_a6 JTF_NUMBER_TABLE
1204: , p5_a7 JTF_VARCHAR2_TABLE_200

Line 1201: , p5_a4 JTF_NUMBER_TABLE

1197: , p5_a0 JTF_NUMBER_TABLE
1198: , p5_a1 JTF_NUMBER_TABLE
1199: , p5_a2 JTF_NUMBER_TABLE
1200: , p5_a3 JTF_NUMBER_TABLE
1201: , p5_a4 JTF_NUMBER_TABLE
1202: , p5_a5 JTF_NUMBER_TABLE
1203: , p5_a6 JTF_NUMBER_TABLE
1204: , p5_a7 JTF_VARCHAR2_TABLE_200
1205: , p5_a8 JTF_NUMBER_TABLE

Line 1202: , p5_a5 JTF_NUMBER_TABLE

1198: , p5_a1 JTF_NUMBER_TABLE
1199: , p5_a2 JTF_NUMBER_TABLE
1200: , p5_a3 JTF_NUMBER_TABLE
1201: , p5_a4 JTF_NUMBER_TABLE
1202: , p5_a5 JTF_NUMBER_TABLE
1203: , p5_a6 JTF_NUMBER_TABLE
1204: , p5_a7 JTF_VARCHAR2_TABLE_200
1205: , p5_a8 JTF_NUMBER_TABLE
1206: , p5_a9 JTF_DATE_TABLE

Line 1203: , p5_a6 JTF_NUMBER_TABLE

1199: , p5_a2 JTF_NUMBER_TABLE
1200: , p5_a3 JTF_NUMBER_TABLE
1201: , p5_a4 JTF_NUMBER_TABLE
1202: , p5_a5 JTF_NUMBER_TABLE
1203: , p5_a6 JTF_NUMBER_TABLE
1204: , p5_a7 JTF_VARCHAR2_TABLE_200
1205: , p5_a8 JTF_NUMBER_TABLE
1206: , p5_a9 JTF_DATE_TABLE
1207: , p5_a10 JTF_DATE_TABLE

Line 1205: , p5_a8 JTF_NUMBER_TABLE

1201: , p5_a4 JTF_NUMBER_TABLE
1202: , p5_a5 JTF_NUMBER_TABLE
1203: , p5_a6 JTF_NUMBER_TABLE
1204: , p5_a7 JTF_VARCHAR2_TABLE_200
1205: , p5_a8 JTF_NUMBER_TABLE
1206: , p5_a9 JTF_DATE_TABLE
1207: , p5_a10 JTF_DATE_TABLE
1208: , p5_a11 JTF_NUMBER_TABLE
1209: , p5_a12 JTF_NUMBER_TABLE

Line 1208: , p5_a11 JTF_NUMBER_TABLE

1204: , p5_a7 JTF_VARCHAR2_TABLE_200
1205: , p5_a8 JTF_NUMBER_TABLE
1206: , p5_a9 JTF_DATE_TABLE
1207: , p5_a10 JTF_DATE_TABLE
1208: , p5_a11 JTF_NUMBER_TABLE
1209: , p5_a12 JTF_NUMBER_TABLE
1210: , p5_a13 JTF_DATE_TABLE
1211: , p5_a14 JTF_VARCHAR2_TABLE_100
1212: , p5_a15 JTF_VARCHAR2_TABLE_100

Line 1209: , p5_a12 JTF_NUMBER_TABLE

1205: , p5_a8 JTF_NUMBER_TABLE
1206: , p5_a9 JTF_DATE_TABLE
1207: , p5_a10 JTF_DATE_TABLE
1208: , p5_a11 JTF_NUMBER_TABLE
1209: , p5_a12 JTF_NUMBER_TABLE
1210: , p5_a13 JTF_DATE_TABLE
1211: , p5_a14 JTF_VARCHAR2_TABLE_100
1212: , p5_a15 JTF_VARCHAR2_TABLE_100
1213: , p5_a16 JTF_VARCHAR2_TABLE_500

Line 1228: , p5_a31 JTF_NUMBER_TABLE

1224: , p5_a27 JTF_VARCHAR2_TABLE_500
1225: , p5_a28 JTF_VARCHAR2_TABLE_500
1226: , p5_a29 JTF_VARCHAR2_TABLE_500
1227: , p5_a30 JTF_VARCHAR2_TABLE_500
1228: , p5_a31 JTF_NUMBER_TABLE
1229: , p5_a32 JTF_NUMBER_TABLE
1230: , p5_a33 JTF_NUMBER_TABLE
1231: , p5_a34 JTF_DATE_TABLE
1232: , p5_a35 JTF_NUMBER_TABLE

Line 1229: , p5_a32 JTF_NUMBER_TABLE

1225: , p5_a28 JTF_VARCHAR2_TABLE_500
1226: , p5_a29 JTF_VARCHAR2_TABLE_500
1227: , p5_a30 JTF_VARCHAR2_TABLE_500
1228: , p5_a31 JTF_NUMBER_TABLE
1229: , p5_a32 JTF_NUMBER_TABLE
1230: , p5_a33 JTF_NUMBER_TABLE
1231: , p5_a34 JTF_DATE_TABLE
1232: , p5_a35 JTF_NUMBER_TABLE
1233: , p5_a36 JTF_DATE_TABLE

Line 1230: , p5_a33 JTF_NUMBER_TABLE

1226: , p5_a29 JTF_VARCHAR2_TABLE_500
1227: , p5_a30 JTF_VARCHAR2_TABLE_500
1228: , p5_a31 JTF_NUMBER_TABLE
1229: , p5_a32 JTF_NUMBER_TABLE
1230: , p5_a33 JTF_NUMBER_TABLE
1231: , p5_a34 JTF_DATE_TABLE
1232: , p5_a35 JTF_NUMBER_TABLE
1233: , p5_a36 JTF_DATE_TABLE
1234: , p5_a37 JTF_NUMBER_TABLE

Line 1232: , p5_a35 JTF_NUMBER_TABLE

1228: , p5_a31 JTF_NUMBER_TABLE
1229: , p5_a32 JTF_NUMBER_TABLE
1230: , p5_a33 JTF_NUMBER_TABLE
1231: , p5_a34 JTF_DATE_TABLE
1232: , p5_a35 JTF_NUMBER_TABLE
1233: , p5_a36 JTF_DATE_TABLE
1234: , p5_a37 JTF_NUMBER_TABLE
1235: , p5_a38 JTF_DATE_TABLE
1236: , p5_a39 JTF_NUMBER_TABLE

Line 1234: , p5_a37 JTF_NUMBER_TABLE

1230: , p5_a33 JTF_NUMBER_TABLE
1231: , p5_a34 JTF_DATE_TABLE
1232: , p5_a35 JTF_NUMBER_TABLE
1233: , p5_a36 JTF_DATE_TABLE
1234: , p5_a37 JTF_NUMBER_TABLE
1235: , p5_a38 JTF_DATE_TABLE
1236: , p5_a39 JTF_NUMBER_TABLE
1237: , p6_a0 out nocopy JTF_NUMBER_TABLE
1238: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 1236: , p5_a39 JTF_NUMBER_TABLE

1232: , p5_a35 JTF_NUMBER_TABLE
1233: , p5_a36 JTF_DATE_TABLE
1234: , p5_a37 JTF_NUMBER_TABLE
1235: , p5_a38 JTF_DATE_TABLE
1236: , p5_a39 JTF_NUMBER_TABLE
1237: , p6_a0 out nocopy JTF_NUMBER_TABLE
1238: , p6_a1 out nocopy JTF_NUMBER_TABLE
1239: , p6_a2 out nocopy JTF_NUMBER_TABLE
1240: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 1237: , p6_a0 out nocopy JTF_NUMBER_TABLE

1233: , p5_a36 JTF_DATE_TABLE
1234: , p5_a37 JTF_NUMBER_TABLE
1235: , p5_a38 JTF_DATE_TABLE
1236: , p5_a39 JTF_NUMBER_TABLE
1237: , p6_a0 out nocopy JTF_NUMBER_TABLE
1238: , p6_a1 out nocopy JTF_NUMBER_TABLE
1239: , p6_a2 out nocopy JTF_NUMBER_TABLE
1240: , p6_a3 out nocopy JTF_NUMBER_TABLE
1241: , p6_a4 out nocopy JTF_NUMBER_TABLE

Line 1238: , p6_a1 out nocopy JTF_NUMBER_TABLE

1234: , p5_a37 JTF_NUMBER_TABLE
1235: , p5_a38 JTF_DATE_TABLE
1236: , p5_a39 JTF_NUMBER_TABLE
1237: , p6_a0 out nocopy JTF_NUMBER_TABLE
1238: , p6_a1 out nocopy JTF_NUMBER_TABLE
1239: , p6_a2 out nocopy JTF_NUMBER_TABLE
1240: , p6_a3 out nocopy JTF_NUMBER_TABLE
1241: , p6_a4 out nocopy JTF_NUMBER_TABLE
1242: , p6_a5 out nocopy JTF_NUMBER_TABLE

Line 1239: , p6_a2 out nocopy JTF_NUMBER_TABLE

1235: , p5_a38 JTF_DATE_TABLE
1236: , p5_a39 JTF_NUMBER_TABLE
1237: , p6_a0 out nocopy JTF_NUMBER_TABLE
1238: , p6_a1 out nocopy JTF_NUMBER_TABLE
1239: , p6_a2 out nocopy JTF_NUMBER_TABLE
1240: , p6_a3 out nocopy JTF_NUMBER_TABLE
1241: , p6_a4 out nocopy JTF_NUMBER_TABLE
1242: , p6_a5 out nocopy JTF_NUMBER_TABLE
1243: , p6_a6 out nocopy JTF_NUMBER_TABLE

Line 1240: , p6_a3 out nocopy JTF_NUMBER_TABLE

1236: , p5_a39 JTF_NUMBER_TABLE
1237: , p6_a0 out nocopy JTF_NUMBER_TABLE
1238: , p6_a1 out nocopy JTF_NUMBER_TABLE
1239: , p6_a2 out nocopy JTF_NUMBER_TABLE
1240: , p6_a3 out nocopy JTF_NUMBER_TABLE
1241: , p6_a4 out nocopy JTF_NUMBER_TABLE
1242: , p6_a5 out nocopy JTF_NUMBER_TABLE
1243: , p6_a6 out nocopy JTF_NUMBER_TABLE
1244: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_200

Line 1241: , p6_a4 out nocopy JTF_NUMBER_TABLE

1237: , p6_a0 out nocopy JTF_NUMBER_TABLE
1238: , p6_a1 out nocopy JTF_NUMBER_TABLE
1239: , p6_a2 out nocopy JTF_NUMBER_TABLE
1240: , p6_a3 out nocopy JTF_NUMBER_TABLE
1241: , p6_a4 out nocopy JTF_NUMBER_TABLE
1242: , p6_a5 out nocopy JTF_NUMBER_TABLE
1243: , p6_a6 out nocopy JTF_NUMBER_TABLE
1244: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_200
1245: , p6_a8 out nocopy JTF_NUMBER_TABLE

Line 1242: , p6_a5 out nocopy JTF_NUMBER_TABLE

1238: , p6_a1 out nocopy JTF_NUMBER_TABLE
1239: , p6_a2 out nocopy JTF_NUMBER_TABLE
1240: , p6_a3 out nocopy JTF_NUMBER_TABLE
1241: , p6_a4 out nocopy JTF_NUMBER_TABLE
1242: , p6_a5 out nocopy JTF_NUMBER_TABLE
1243: , p6_a6 out nocopy JTF_NUMBER_TABLE
1244: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_200
1245: , p6_a8 out nocopy JTF_NUMBER_TABLE
1246: , p6_a9 out nocopy JTF_DATE_TABLE

Line 1243: , p6_a6 out nocopy JTF_NUMBER_TABLE

1239: , p6_a2 out nocopy JTF_NUMBER_TABLE
1240: , p6_a3 out nocopy JTF_NUMBER_TABLE
1241: , p6_a4 out nocopy JTF_NUMBER_TABLE
1242: , p6_a5 out nocopy JTF_NUMBER_TABLE
1243: , p6_a6 out nocopy JTF_NUMBER_TABLE
1244: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_200
1245: , p6_a8 out nocopy JTF_NUMBER_TABLE
1246: , p6_a9 out nocopy JTF_DATE_TABLE
1247: , p6_a10 out nocopy JTF_DATE_TABLE

Line 1245: , p6_a8 out nocopy JTF_NUMBER_TABLE

1241: , p6_a4 out nocopy JTF_NUMBER_TABLE
1242: , p6_a5 out nocopy JTF_NUMBER_TABLE
1243: , p6_a6 out nocopy JTF_NUMBER_TABLE
1244: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_200
1245: , p6_a8 out nocopy JTF_NUMBER_TABLE
1246: , p6_a9 out nocopy JTF_DATE_TABLE
1247: , p6_a10 out nocopy JTF_DATE_TABLE
1248: , p6_a11 out nocopy JTF_NUMBER_TABLE
1249: , p6_a12 out nocopy JTF_NUMBER_TABLE

Line 1248: , p6_a11 out nocopy JTF_NUMBER_TABLE

1244: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_200
1245: , p6_a8 out nocopy JTF_NUMBER_TABLE
1246: , p6_a9 out nocopy JTF_DATE_TABLE
1247: , p6_a10 out nocopy JTF_DATE_TABLE
1248: , p6_a11 out nocopy JTF_NUMBER_TABLE
1249: , p6_a12 out nocopy JTF_NUMBER_TABLE
1250: , p6_a13 out nocopy JTF_DATE_TABLE
1251: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
1252: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100

Line 1249: , p6_a12 out nocopy JTF_NUMBER_TABLE

1245: , p6_a8 out nocopy JTF_NUMBER_TABLE
1246: , p6_a9 out nocopy JTF_DATE_TABLE
1247: , p6_a10 out nocopy JTF_DATE_TABLE
1248: , p6_a11 out nocopy JTF_NUMBER_TABLE
1249: , p6_a12 out nocopy JTF_NUMBER_TABLE
1250: , p6_a13 out nocopy JTF_DATE_TABLE
1251: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
1252: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
1253: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500

Line 1268: , p6_a31 out nocopy JTF_NUMBER_TABLE

1264: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
1265: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
1266: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_500
1267: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_500
1268: , p6_a31 out nocopy JTF_NUMBER_TABLE
1269: , p6_a32 out nocopy JTF_NUMBER_TABLE
1270: , p6_a33 out nocopy JTF_NUMBER_TABLE
1271: , p6_a34 out nocopy JTF_DATE_TABLE
1272: , p6_a35 out nocopy JTF_NUMBER_TABLE

Line 1269: , p6_a32 out nocopy JTF_NUMBER_TABLE

1265: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
1266: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_500
1267: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_500
1268: , p6_a31 out nocopy JTF_NUMBER_TABLE
1269: , p6_a32 out nocopy JTF_NUMBER_TABLE
1270: , p6_a33 out nocopy JTF_NUMBER_TABLE
1271: , p6_a34 out nocopy JTF_DATE_TABLE
1272: , p6_a35 out nocopy JTF_NUMBER_TABLE
1273: , p6_a36 out nocopy JTF_DATE_TABLE

Line 1270: , p6_a33 out nocopy JTF_NUMBER_TABLE

1266: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_500
1267: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_500
1268: , p6_a31 out nocopy JTF_NUMBER_TABLE
1269: , p6_a32 out nocopy JTF_NUMBER_TABLE
1270: , p6_a33 out nocopy JTF_NUMBER_TABLE
1271: , p6_a34 out nocopy JTF_DATE_TABLE
1272: , p6_a35 out nocopy JTF_NUMBER_TABLE
1273: , p6_a36 out nocopy JTF_DATE_TABLE
1274: , p6_a37 out nocopy JTF_NUMBER_TABLE

Line 1272: , p6_a35 out nocopy JTF_NUMBER_TABLE

1268: , p6_a31 out nocopy JTF_NUMBER_TABLE
1269: , p6_a32 out nocopy JTF_NUMBER_TABLE
1270: , p6_a33 out nocopy JTF_NUMBER_TABLE
1271: , p6_a34 out nocopy JTF_DATE_TABLE
1272: , p6_a35 out nocopy JTF_NUMBER_TABLE
1273: , p6_a36 out nocopy JTF_DATE_TABLE
1274: , p6_a37 out nocopy JTF_NUMBER_TABLE
1275: , p6_a38 out nocopy JTF_DATE_TABLE
1276: , p6_a39 out nocopy JTF_NUMBER_TABLE

Line 1274: , p6_a37 out nocopy JTF_NUMBER_TABLE

1270: , p6_a33 out nocopy JTF_NUMBER_TABLE
1271: , p6_a34 out nocopy JTF_DATE_TABLE
1272: , p6_a35 out nocopy JTF_NUMBER_TABLE
1273: , p6_a36 out nocopy JTF_DATE_TABLE
1274: , p6_a37 out nocopy JTF_NUMBER_TABLE
1275: , p6_a38 out nocopy JTF_DATE_TABLE
1276: , p6_a39 out nocopy JTF_NUMBER_TABLE
1277: )
1278:

Line 1276: , p6_a39 out nocopy JTF_NUMBER_TABLE

1272: , p6_a35 out nocopy JTF_NUMBER_TABLE
1273: , p6_a36 out nocopy JTF_DATE_TABLE
1274: , p6_a37 out nocopy JTF_NUMBER_TABLE
1275: , p6_a38 out nocopy JTF_DATE_TABLE
1276: , p6_a39 out nocopy JTF_NUMBER_TABLE
1277: )
1278:
1279: as
1280: ddp_pocv_tbl okl_pool_pvt.pocv_tbl_type;

Line 1597: , p5_a0 JTF_NUMBER_TABLE

1593: , p_init_msg_list VARCHAR2
1594: , x_return_status out nocopy VARCHAR2
1595: , x_msg_count out nocopy NUMBER
1596: , x_msg_data out nocopy VARCHAR2
1597: , p5_a0 JTF_NUMBER_TABLE
1598: , p5_a1 JTF_NUMBER_TABLE
1599: , p5_a2 JTF_NUMBER_TABLE
1600: , p5_a3 JTF_NUMBER_TABLE
1601: , p5_a4 JTF_NUMBER_TABLE

Line 1598: , p5_a1 JTF_NUMBER_TABLE

1594: , x_return_status out nocopy VARCHAR2
1595: , x_msg_count out nocopy NUMBER
1596: , x_msg_data out nocopy VARCHAR2
1597: , p5_a0 JTF_NUMBER_TABLE
1598: , p5_a1 JTF_NUMBER_TABLE
1599: , p5_a2 JTF_NUMBER_TABLE
1600: , p5_a3 JTF_NUMBER_TABLE
1601: , p5_a4 JTF_NUMBER_TABLE
1602: , p5_a5 JTF_NUMBER_TABLE

Line 1599: , p5_a2 JTF_NUMBER_TABLE

1595: , x_msg_count out nocopy NUMBER
1596: , x_msg_data out nocopy VARCHAR2
1597: , p5_a0 JTF_NUMBER_TABLE
1598: , p5_a1 JTF_NUMBER_TABLE
1599: , p5_a2 JTF_NUMBER_TABLE
1600: , p5_a3 JTF_NUMBER_TABLE
1601: , p5_a4 JTF_NUMBER_TABLE
1602: , p5_a5 JTF_NUMBER_TABLE
1603: , p5_a6 JTF_NUMBER_TABLE

Line 1600: , p5_a3 JTF_NUMBER_TABLE

1596: , x_msg_data out nocopy VARCHAR2
1597: , p5_a0 JTF_NUMBER_TABLE
1598: , p5_a1 JTF_NUMBER_TABLE
1599: , p5_a2 JTF_NUMBER_TABLE
1600: , p5_a3 JTF_NUMBER_TABLE
1601: , p5_a4 JTF_NUMBER_TABLE
1602: , p5_a5 JTF_NUMBER_TABLE
1603: , p5_a6 JTF_NUMBER_TABLE
1604: , p5_a7 JTF_VARCHAR2_TABLE_200

Line 1601: , p5_a4 JTF_NUMBER_TABLE

1597: , p5_a0 JTF_NUMBER_TABLE
1598: , p5_a1 JTF_NUMBER_TABLE
1599: , p5_a2 JTF_NUMBER_TABLE
1600: , p5_a3 JTF_NUMBER_TABLE
1601: , p5_a4 JTF_NUMBER_TABLE
1602: , p5_a5 JTF_NUMBER_TABLE
1603: , p5_a6 JTF_NUMBER_TABLE
1604: , p5_a7 JTF_VARCHAR2_TABLE_200
1605: , p5_a8 JTF_NUMBER_TABLE

Line 1602: , p5_a5 JTF_NUMBER_TABLE

1598: , p5_a1 JTF_NUMBER_TABLE
1599: , p5_a2 JTF_NUMBER_TABLE
1600: , p5_a3 JTF_NUMBER_TABLE
1601: , p5_a4 JTF_NUMBER_TABLE
1602: , p5_a5 JTF_NUMBER_TABLE
1603: , p5_a6 JTF_NUMBER_TABLE
1604: , p5_a7 JTF_VARCHAR2_TABLE_200
1605: , p5_a8 JTF_NUMBER_TABLE
1606: , p5_a9 JTF_DATE_TABLE

Line 1603: , p5_a6 JTF_NUMBER_TABLE

1599: , p5_a2 JTF_NUMBER_TABLE
1600: , p5_a3 JTF_NUMBER_TABLE
1601: , p5_a4 JTF_NUMBER_TABLE
1602: , p5_a5 JTF_NUMBER_TABLE
1603: , p5_a6 JTF_NUMBER_TABLE
1604: , p5_a7 JTF_VARCHAR2_TABLE_200
1605: , p5_a8 JTF_NUMBER_TABLE
1606: , p5_a9 JTF_DATE_TABLE
1607: , p5_a10 JTF_DATE_TABLE

Line 1605: , p5_a8 JTF_NUMBER_TABLE

1601: , p5_a4 JTF_NUMBER_TABLE
1602: , p5_a5 JTF_NUMBER_TABLE
1603: , p5_a6 JTF_NUMBER_TABLE
1604: , p5_a7 JTF_VARCHAR2_TABLE_200
1605: , p5_a8 JTF_NUMBER_TABLE
1606: , p5_a9 JTF_DATE_TABLE
1607: , p5_a10 JTF_DATE_TABLE
1608: , p5_a11 JTF_NUMBER_TABLE
1609: , p5_a12 JTF_NUMBER_TABLE

Line 1608: , p5_a11 JTF_NUMBER_TABLE

1604: , p5_a7 JTF_VARCHAR2_TABLE_200
1605: , p5_a8 JTF_NUMBER_TABLE
1606: , p5_a9 JTF_DATE_TABLE
1607: , p5_a10 JTF_DATE_TABLE
1608: , p5_a11 JTF_NUMBER_TABLE
1609: , p5_a12 JTF_NUMBER_TABLE
1610: , p5_a13 JTF_DATE_TABLE
1611: , p5_a14 JTF_VARCHAR2_TABLE_100
1612: , p5_a15 JTF_VARCHAR2_TABLE_100

Line 1609: , p5_a12 JTF_NUMBER_TABLE

1605: , p5_a8 JTF_NUMBER_TABLE
1606: , p5_a9 JTF_DATE_TABLE
1607: , p5_a10 JTF_DATE_TABLE
1608: , p5_a11 JTF_NUMBER_TABLE
1609: , p5_a12 JTF_NUMBER_TABLE
1610: , p5_a13 JTF_DATE_TABLE
1611: , p5_a14 JTF_VARCHAR2_TABLE_100
1612: , p5_a15 JTF_VARCHAR2_TABLE_100
1613: , p5_a16 JTF_VARCHAR2_TABLE_500

Line 1628: , p5_a31 JTF_NUMBER_TABLE

1624: , p5_a27 JTF_VARCHAR2_TABLE_500
1625: , p5_a28 JTF_VARCHAR2_TABLE_500
1626: , p5_a29 JTF_VARCHAR2_TABLE_500
1627: , p5_a30 JTF_VARCHAR2_TABLE_500
1628: , p5_a31 JTF_NUMBER_TABLE
1629: , p5_a32 JTF_NUMBER_TABLE
1630: , p5_a33 JTF_NUMBER_TABLE
1631: , p5_a34 JTF_DATE_TABLE
1632: , p5_a35 JTF_NUMBER_TABLE

Line 1629: , p5_a32 JTF_NUMBER_TABLE

1625: , p5_a28 JTF_VARCHAR2_TABLE_500
1626: , p5_a29 JTF_VARCHAR2_TABLE_500
1627: , p5_a30 JTF_VARCHAR2_TABLE_500
1628: , p5_a31 JTF_NUMBER_TABLE
1629: , p5_a32 JTF_NUMBER_TABLE
1630: , p5_a33 JTF_NUMBER_TABLE
1631: , p5_a34 JTF_DATE_TABLE
1632: , p5_a35 JTF_NUMBER_TABLE
1633: , p5_a36 JTF_DATE_TABLE

Line 1630: , p5_a33 JTF_NUMBER_TABLE

1626: , p5_a29 JTF_VARCHAR2_TABLE_500
1627: , p5_a30 JTF_VARCHAR2_TABLE_500
1628: , p5_a31 JTF_NUMBER_TABLE
1629: , p5_a32 JTF_NUMBER_TABLE
1630: , p5_a33 JTF_NUMBER_TABLE
1631: , p5_a34 JTF_DATE_TABLE
1632: , p5_a35 JTF_NUMBER_TABLE
1633: , p5_a36 JTF_DATE_TABLE
1634: , p5_a37 JTF_NUMBER_TABLE

Line 1632: , p5_a35 JTF_NUMBER_TABLE

1628: , p5_a31 JTF_NUMBER_TABLE
1629: , p5_a32 JTF_NUMBER_TABLE
1630: , p5_a33 JTF_NUMBER_TABLE
1631: , p5_a34 JTF_DATE_TABLE
1632: , p5_a35 JTF_NUMBER_TABLE
1633: , p5_a36 JTF_DATE_TABLE
1634: , p5_a37 JTF_NUMBER_TABLE
1635: , p5_a38 JTF_DATE_TABLE
1636: , p5_a39 JTF_NUMBER_TABLE

Line 1634: , p5_a37 JTF_NUMBER_TABLE

1630: , p5_a33 JTF_NUMBER_TABLE
1631: , p5_a34 JTF_DATE_TABLE
1632: , p5_a35 JTF_NUMBER_TABLE
1633: , p5_a36 JTF_DATE_TABLE
1634: , p5_a37 JTF_NUMBER_TABLE
1635: , p5_a38 JTF_DATE_TABLE
1636: , p5_a39 JTF_NUMBER_TABLE
1637: , p6_a0 out nocopy JTF_NUMBER_TABLE
1638: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 1636: , p5_a39 JTF_NUMBER_TABLE

1632: , p5_a35 JTF_NUMBER_TABLE
1633: , p5_a36 JTF_DATE_TABLE
1634: , p5_a37 JTF_NUMBER_TABLE
1635: , p5_a38 JTF_DATE_TABLE
1636: , p5_a39 JTF_NUMBER_TABLE
1637: , p6_a0 out nocopy JTF_NUMBER_TABLE
1638: , p6_a1 out nocopy JTF_NUMBER_TABLE
1639: , p6_a2 out nocopy JTF_NUMBER_TABLE
1640: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 1637: , p6_a0 out nocopy JTF_NUMBER_TABLE

1633: , p5_a36 JTF_DATE_TABLE
1634: , p5_a37 JTF_NUMBER_TABLE
1635: , p5_a38 JTF_DATE_TABLE
1636: , p5_a39 JTF_NUMBER_TABLE
1637: , p6_a0 out nocopy JTF_NUMBER_TABLE
1638: , p6_a1 out nocopy JTF_NUMBER_TABLE
1639: , p6_a2 out nocopy JTF_NUMBER_TABLE
1640: , p6_a3 out nocopy JTF_NUMBER_TABLE
1641: , p6_a4 out nocopy JTF_NUMBER_TABLE

Line 1638: , p6_a1 out nocopy JTF_NUMBER_TABLE

1634: , p5_a37 JTF_NUMBER_TABLE
1635: , p5_a38 JTF_DATE_TABLE
1636: , p5_a39 JTF_NUMBER_TABLE
1637: , p6_a0 out nocopy JTF_NUMBER_TABLE
1638: , p6_a1 out nocopy JTF_NUMBER_TABLE
1639: , p6_a2 out nocopy JTF_NUMBER_TABLE
1640: , p6_a3 out nocopy JTF_NUMBER_TABLE
1641: , p6_a4 out nocopy JTF_NUMBER_TABLE
1642: , p6_a5 out nocopy JTF_NUMBER_TABLE

Line 1639: , p6_a2 out nocopy JTF_NUMBER_TABLE

1635: , p5_a38 JTF_DATE_TABLE
1636: , p5_a39 JTF_NUMBER_TABLE
1637: , p6_a0 out nocopy JTF_NUMBER_TABLE
1638: , p6_a1 out nocopy JTF_NUMBER_TABLE
1639: , p6_a2 out nocopy JTF_NUMBER_TABLE
1640: , p6_a3 out nocopy JTF_NUMBER_TABLE
1641: , p6_a4 out nocopy JTF_NUMBER_TABLE
1642: , p6_a5 out nocopy JTF_NUMBER_TABLE
1643: , p6_a6 out nocopy JTF_NUMBER_TABLE

Line 1640: , p6_a3 out nocopy JTF_NUMBER_TABLE

1636: , p5_a39 JTF_NUMBER_TABLE
1637: , p6_a0 out nocopy JTF_NUMBER_TABLE
1638: , p6_a1 out nocopy JTF_NUMBER_TABLE
1639: , p6_a2 out nocopy JTF_NUMBER_TABLE
1640: , p6_a3 out nocopy JTF_NUMBER_TABLE
1641: , p6_a4 out nocopy JTF_NUMBER_TABLE
1642: , p6_a5 out nocopy JTF_NUMBER_TABLE
1643: , p6_a6 out nocopy JTF_NUMBER_TABLE
1644: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_200

Line 1641: , p6_a4 out nocopy JTF_NUMBER_TABLE

1637: , p6_a0 out nocopy JTF_NUMBER_TABLE
1638: , p6_a1 out nocopy JTF_NUMBER_TABLE
1639: , p6_a2 out nocopy JTF_NUMBER_TABLE
1640: , p6_a3 out nocopy JTF_NUMBER_TABLE
1641: , p6_a4 out nocopy JTF_NUMBER_TABLE
1642: , p6_a5 out nocopy JTF_NUMBER_TABLE
1643: , p6_a6 out nocopy JTF_NUMBER_TABLE
1644: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_200
1645: , p6_a8 out nocopy JTF_NUMBER_TABLE

Line 1642: , p6_a5 out nocopy JTF_NUMBER_TABLE

1638: , p6_a1 out nocopy JTF_NUMBER_TABLE
1639: , p6_a2 out nocopy JTF_NUMBER_TABLE
1640: , p6_a3 out nocopy JTF_NUMBER_TABLE
1641: , p6_a4 out nocopy JTF_NUMBER_TABLE
1642: , p6_a5 out nocopy JTF_NUMBER_TABLE
1643: , p6_a6 out nocopy JTF_NUMBER_TABLE
1644: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_200
1645: , p6_a8 out nocopy JTF_NUMBER_TABLE
1646: , p6_a9 out nocopy JTF_DATE_TABLE

Line 1643: , p6_a6 out nocopy JTF_NUMBER_TABLE

1639: , p6_a2 out nocopy JTF_NUMBER_TABLE
1640: , p6_a3 out nocopy JTF_NUMBER_TABLE
1641: , p6_a4 out nocopy JTF_NUMBER_TABLE
1642: , p6_a5 out nocopy JTF_NUMBER_TABLE
1643: , p6_a6 out nocopy JTF_NUMBER_TABLE
1644: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_200
1645: , p6_a8 out nocopy JTF_NUMBER_TABLE
1646: , p6_a9 out nocopy JTF_DATE_TABLE
1647: , p6_a10 out nocopy JTF_DATE_TABLE

Line 1645: , p6_a8 out nocopy JTF_NUMBER_TABLE

1641: , p6_a4 out nocopy JTF_NUMBER_TABLE
1642: , p6_a5 out nocopy JTF_NUMBER_TABLE
1643: , p6_a6 out nocopy JTF_NUMBER_TABLE
1644: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_200
1645: , p6_a8 out nocopy JTF_NUMBER_TABLE
1646: , p6_a9 out nocopy JTF_DATE_TABLE
1647: , p6_a10 out nocopy JTF_DATE_TABLE
1648: , p6_a11 out nocopy JTF_NUMBER_TABLE
1649: , p6_a12 out nocopy JTF_NUMBER_TABLE

Line 1648: , p6_a11 out nocopy JTF_NUMBER_TABLE

1644: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_200
1645: , p6_a8 out nocopy JTF_NUMBER_TABLE
1646: , p6_a9 out nocopy JTF_DATE_TABLE
1647: , p6_a10 out nocopy JTF_DATE_TABLE
1648: , p6_a11 out nocopy JTF_NUMBER_TABLE
1649: , p6_a12 out nocopy JTF_NUMBER_TABLE
1650: , p6_a13 out nocopy JTF_DATE_TABLE
1651: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
1652: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100

Line 1649: , p6_a12 out nocopy JTF_NUMBER_TABLE

1645: , p6_a8 out nocopy JTF_NUMBER_TABLE
1646: , p6_a9 out nocopy JTF_DATE_TABLE
1647: , p6_a10 out nocopy JTF_DATE_TABLE
1648: , p6_a11 out nocopy JTF_NUMBER_TABLE
1649: , p6_a12 out nocopy JTF_NUMBER_TABLE
1650: , p6_a13 out nocopy JTF_DATE_TABLE
1651: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
1652: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
1653: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500

Line 1668: , p6_a31 out nocopy JTF_NUMBER_TABLE

1664: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
1665: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
1666: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_500
1667: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_500
1668: , p6_a31 out nocopy JTF_NUMBER_TABLE
1669: , p6_a32 out nocopy JTF_NUMBER_TABLE
1670: , p6_a33 out nocopy JTF_NUMBER_TABLE
1671: , p6_a34 out nocopy JTF_DATE_TABLE
1672: , p6_a35 out nocopy JTF_NUMBER_TABLE

Line 1669: , p6_a32 out nocopy JTF_NUMBER_TABLE

1665: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
1666: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_500
1667: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_500
1668: , p6_a31 out nocopy JTF_NUMBER_TABLE
1669: , p6_a32 out nocopy JTF_NUMBER_TABLE
1670: , p6_a33 out nocopy JTF_NUMBER_TABLE
1671: , p6_a34 out nocopy JTF_DATE_TABLE
1672: , p6_a35 out nocopy JTF_NUMBER_TABLE
1673: , p6_a36 out nocopy JTF_DATE_TABLE

Line 1670: , p6_a33 out nocopy JTF_NUMBER_TABLE

1666: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_500
1667: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_500
1668: , p6_a31 out nocopy JTF_NUMBER_TABLE
1669: , p6_a32 out nocopy JTF_NUMBER_TABLE
1670: , p6_a33 out nocopy JTF_NUMBER_TABLE
1671: , p6_a34 out nocopy JTF_DATE_TABLE
1672: , p6_a35 out nocopy JTF_NUMBER_TABLE
1673: , p6_a36 out nocopy JTF_DATE_TABLE
1674: , p6_a37 out nocopy JTF_NUMBER_TABLE

Line 1672: , p6_a35 out nocopy JTF_NUMBER_TABLE

1668: , p6_a31 out nocopy JTF_NUMBER_TABLE
1669: , p6_a32 out nocopy JTF_NUMBER_TABLE
1670: , p6_a33 out nocopy JTF_NUMBER_TABLE
1671: , p6_a34 out nocopy JTF_DATE_TABLE
1672: , p6_a35 out nocopy JTF_NUMBER_TABLE
1673: , p6_a36 out nocopy JTF_DATE_TABLE
1674: , p6_a37 out nocopy JTF_NUMBER_TABLE
1675: , p6_a38 out nocopy JTF_DATE_TABLE
1676: , p6_a39 out nocopy JTF_NUMBER_TABLE

Line 1674: , p6_a37 out nocopy JTF_NUMBER_TABLE

1670: , p6_a33 out nocopy JTF_NUMBER_TABLE
1671: , p6_a34 out nocopy JTF_DATE_TABLE
1672: , p6_a35 out nocopy JTF_NUMBER_TABLE
1673: , p6_a36 out nocopy JTF_DATE_TABLE
1674: , p6_a37 out nocopy JTF_NUMBER_TABLE
1675: , p6_a38 out nocopy JTF_DATE_TABLE
1676: , p6_a39 out nocopy JTF_NUMBER_TABLE
1677: )
1678:

Line 1676: , p6_a39 out nocopy JTF_NUMBER_TABLE

1672: , p6_a35 out nocopy JTF_NUMBER_TABLE
1673: , p6_a36 out nocopy JTF_DATE_TABLE
1674: , p6_a37 out nocopy JTF_NUMBER_TABLE
1675: , p6_a38 out nocopy JTF_DATE_TABLE
1676: , p6_a39 out nocopy JTF_NUMBER_TABLE
1677: )
1678:
1679: as
1680: ddp_pocv_tbl okl_pool_pvt.pocv_tbl_type;

Line 1913: , p5_a0 JTF_NUMBER_TABLE

1909: , p_init_msg_list VARCHAR2
1910: , x_return_status out nocopy VARCHAR2
1911: , x_msg_count out nocopy NUMBER
1912: , x_msg_data out nocopy VARCHAR2
1913: , p5_a0 JTF_NUMBER_TABLE
1914: , p5_a1 JTF_NUMBER_TABLE
1915: , p5_a2 JTF_NUMBER_TABLE
1916: , p5_a3 JTF_NUMBER_TABLE
1917: , p5_a4 JTF_NUMBER_TABLE

Line 1914: , p5_a1 JTF_NUMBER_TABLE

1910: , x_return_status out nocopy VARCHAR2
1911: , x_msg_count out nocopy NUMBER
1912: , x_msg_data out nocopy VARCHAR2
1913: , p5_a0 JTF_NUMBER_TABLE
1914: , p5_a1 JTF_NUMBER_TABLE
1915: , p5_a2 JTF_NUMBER_TABLE
1916: , p5_a3 JTF_NUMBER_TABLE
1917: , p5_a4 JTF_NUMBER_TABLE
1918: , p5_a5 JTF_NUMBER_TABLE

Line 1915: , p5_a2 JTF_NUMBER_TABLE

1911: , x_msg_count out nocopy NUMBER
1912: , x_msg_data out nocopy VARCHAR2
1913: , p5_a0 JTF_NUMBER_TABLE
1914: , p5_a1 JTF_NUMBER_TABLE
1915: , p5_a2 JTF_NUMBER_TABLE
1916: , p5_a3 JTF_NUMBER_TABLE
1917: , p5_a4 JTF_NUMBER_TABLE
1918: , p5_a5 JTF_NUMBER_TABLE
1919: , p5_a6 JTF_NUMBER_TABLE

Line 1916: , p5_a3 JTF_NUMBER_TABLE

1912: , x_msg_data out nocopy VARCHAR2
1913: , p5_a0 JTF_NUMBER_TABLE
1914: , p5_a1 JTF_NUMBER_TABLE
1915: , p5_a2 JTF_NUMBER_TABLE
1916: , p5_a3 JTF_NUMBER_TABLE
1917: , p5_a4 JTF_NUMBER_TABLE
1918: , p5_a5 JTF_NUMBER_TABLE
1919: , p5_a6 JTF_NUMBER_TABLE
1920: , p5_a7 JTF_VARCHAR2_TABLE_200

Line 1917: , p5_a4 JTF_NUMBER_TABLE

1913: , p5_a0 JTF_NUMBER_TABLE
1914: , p5_a1 JTF_NUMBER_TABLE
1915: , p5_a2 JTF_NUMBER_TABLE
1916: , p5_a3 JTF_NUMBER_TABLE
1917: , p5_a4 JTF_NUMBER_TABLE
1918: , p5_a5 JTF_NUMBER_TABLE
1919: , p5_a6 JTF_NUMBER_TABLE
1920: , p5_a7 JTF_VARCHAR2_TABLE_200
1921: , p5_a8 JTF_NUMBER_TABLE

Line 1918: , p5_a5 JTF_NUMBER_TABLE

1914: , p5_a1 JTF_NUMBER_TABLE
1915: , p5_a2 JTF_NUMBER_TABLE
1916: , p5_a3 JTF_NUMBER_TABLE
1917: , p5_a4 JTF_NUMBER_TABLE
1918: , p5_a5 JTF_NUMBER_TABLE
1919: , p5_a6 JTF_NUMBER_TABLE
1920: , p5_a7 JTF_VARCHAR2_TABLE_200
1921: , p5_a8 JTF_NUMBER_TABLE
1922: , p5_a9 JTF_DATE_TABLE

Line 1919: , p5_a6 JTF_NUMBER_TABLE

1915: , p5_a2 JTF_NUMBER_TABLE
1916: , p5_a3 JTF_NUMBER_TABLE
1917: , p5_a4 JTF_NUMBER_TABLE
1918: , p5_a5 JTF_NUMBER_TABLE
1919: , p5_a6 JTF_NUMBER_TABLE
1920: , p5_a7 JTF_VARCHAR2_TABLE_200
1921: , p5_a8 JTF_NUMBER_TABLE
1922: , p5_a9 JTF_DATE_TABLE
1923: , p5_a10 JTF_DATE_TABLE

Line 1921: , p5_a8 JTF_NUMBER_TABLE

1917: , p5_a4 JTF_NUMBER_TABLE
1918: , p5_a5 JTF_NUMBER_TABLE
1919: , p5_a6 JTF_NUMBER_TABLE
1920: , p5_a7 JTF_VARCHAR2_TABLE_200
1921: , p5_a8 JTF_NUMBER_TABLE
1922: , p5_a9 JTF_DATE_TABLE
1923: , p5_a10 JTF_DATE_TABLE
1924: , p5_a11 JTF_NUMBER_TABLE
1925: , p5_a12 JTF_NUMBER_TABLE

Line 1924: , p5_a11 JTF_NUMBER_TABLE

1920: , p5_a7 JTF_VARCHAR2_TABLE_200
1921: , p5_a8 JTF_NUMBER_TABLE
1922: , p5_a9 JTF_DATE_TABLE
1923: , p5_a10 JTF_DATE_TABLE
1924: , p5_a11 JTF_NUMBER_TABLE
1925: , p5_a12 JTF_NUMBER_TABLE
1926: , p5_a13 JTF_DATE_TABLE
1927: , p5_a14 JTF_VARCHAR2_TABLE_100
1928: , p5_a15 JTF_VARCHAR2_TABLE_100

Line 1925: , p5_a12 JTF_NUMBER_TABLE

1921: , p5_a8 JTF_NUMBER_TABLE
1922: , p5_a9 JTF_DATE_TABLE
1923: , p5_a10 JTF_DATE_TABLE
1924: , p5_a11 JTF_NUMBER_TABLE
1925: , p5_a12 JTF_NUMBER_TABLE
1926: , p5_a13 JTF_DATE_TABLE
1927: , p5_a14 JTF_VARCHAR2_TABLE_100
1928: , p5_a15 JTF_VARCHAR2_TABLE_100
1929: , p5_a16 JTF_VARCHAR2_TABLE_500

Line 1944: , p5_a31 JTF_NUMBER_TABLE

1940: , p5_a27 JTF_VARCHAR2_TABLE_500
1941: , p5_a28 JTF_VARCHAR2_TABLE_500
1942: , p5_a29 JTF_VARCHAR2_TABLE_500
1943: , p5_a30 JTF_VARCHAR2_TABLE_500
1944: , p5_a31 JTF_NUMBER_TABLE
1945: , p5_a32 JTF_NUMBER_TABLE
1946: , p5_a33 JTF_NUMBER_TABLE
1947: , p5_a34 JTF_DATE_TABLE
1948: , p5_a35 JTF_NUMBER_TABLE

Line 1945: , p5_a32 JTF_NUMBER_TABLE

1941: , p5_a28 JTF_VARCHAR2_TABLE_500
1942: , p5_a29 JTF_VARCHAR2_TABLE_500
1943: , p5_a30 JTF_VARCHAR2_TABLE_500
1944: , p5_a31 JTF_NUMBER_TABLE
1945: , p5_a32 JTF_NUMBER_TABLE
1946: , p5_a33 JTF_NUMBER_TABLE
1947: , p5_a34 JTF_DATE_TABLE
1948: , p5_a35 JTF_NUMBER_TABLE
1949: , p5_a36 JTF_DATE_TABLE

Line 1946: , p5_a33 JTF_NUMBER_TABLE

1942: , p5_a29 JTF_VARCHAR2_TABLE_500
1943: , p5_a30 JTF_VARCHAR2_TABLE_500
1944: , p5_a31 JTF_NUMBER_TABLE
1945: , p5_a32 JTF_NUMBER_TABLE
1946: , p5_a33 JTF_NUMBER_TABLE
1947: , p5_a34 JTF_DATE_TABLE
1948: , p5_a35 JTF_NUMBER_TABLE
1949: , p5_a36 JTF_DATE_TABLE
1950: , p5_a37 JTF_NUMBER_TABLE

Line 1948: , p5_a35 JTF_NUMBER_TABLE

1944: , p5_a31 JTF_NUMBER_TABLE
1945: , p5_a32 JTF_NUMBER_TABLE
1946: , p5_a33 JTF_NUMBER_TABLE
1947: , p5_a34 JTF_DATE_TABLE
1948: , p5_a35 JTF_NUMBER_TABLE
1949: , p5_a36 JTF_DATE_TABLE
1950: , p5_a37 JTF_NUMBER_TABLE
1951: , p5_a38 JTF_DATE_TABLE
1952: , p5_a39 JTF_NUMBER_TABLE

Line 1950: , p5_a37 JTF_NUMBER_TABLE

1946: , p5_a33 JTF_NUMBER_TABLE
1947: , p5_a34 JTF_DATE_TABLE
1948: , p5_a35 JTF_NUMBER_TABLE
1949: , p5_a36 JTF_DATE_TABLE
1950: , p5_a37 JTF_NUMBER_TABLE
1951: , p5_a38 JTF_DATE_TABLE
1952: , p5_a39 JTF_NUMBER_TABLE
1953: )
1954:

Line 1952: , p5_a39 JTF_NUMBER_TABLE

1948: , p5_a35 JTF_NUMBER_TABLE
1949: , p5_a36 JTF_DATE_TABLE
1950: , p5_a37 JTF_NUMBER_TABLE
1951: , p5_a38 JTF_DATE_TABLE
1952: , p5_a39 JTF_NUMBER_TABLE
1953: )
1954:
1955: as
1956: ddp_pocv_tbl okl_pool_pvt.pocv_tbl_type;

Line 2737: , p33_a0 out nocopy JTF_NUMBER_TABLE

2733: , p_stream_type_subclass VARCHAR2
2734: , p_streams_from_date date
2735: , p_streams_to_date date
2736: , p_action_code VARCHAR2
2737: , p33_a0 out nocopy JTF_NUMBER_TABLE
2738: , p33_a1 out nocopy JTF_VARCHAR2_TABLE_200
2739: , p33_a2 out nocopy JTF_VARCHAR2_TABLE_200
2740: , p33_a3 out nocopy JTF_VARCHAR2_TABLE_400
2741: , p33_a4 out nocopy JTF_VARCHAR2_TABLE_200

Line 2742: , p33_a5 out nocopy JTF_NUMBER_TABLE

2738: , p33_a1 out nocopy JTF_VARCHAR2_TABLE_200
2739: , p33_a2 out nocopy JTF_VARCHAR2_TABLE_200
2740: , p33_a3 out nocopy JTF_VARCHAR2_TABLE_400
2741: , p33_a4 out nocopy JTF_VARCHAR2_TABLE_200
2742: , p33_a5 out nocopy JTF_NUMBER_TABLE
2743: , p33_a6 out nocopy JTF_VARCHAR2_TABLE_100
2744: , p33_a7 out nocopy JTF_VARCHAR2_TABLE_100
2745: , p33_a8 out nocopy JTF_VARCHAR2_TABLE_100
2746: )