DBA Data[Home] [Help]

APPS.OKL_SRV_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p1(t out nocopy okl_srv_pvt.okl_srv_tbl, a0 JTF_NUMBER_TABLE

1: package body okl_srv_pvt_w as
2: /* $Header: OKLISRVB.pls 120.0 2005/07/07 10:40:54 viselvar noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_srv_pvt.okl_srv_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE

Line 4: , a1 JTF_NUMBER_TABLE

1: package body okl_srv_pvt_w as
2: /* $Header: OKLISRVB.pls 120.0 2005/07/07 10:40:54 viselvar noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_srv_pvt.okl_srv_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_DATE_TABLE

Line 6: , a3 JTF_NUMBER_TABLE

2: /* $Header: OKLISRVB.pls 120.0 2005/07/07 10:40:54 viselvar noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_srv_pvt.okl_srv_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_NUMBER_TABLE

Line 10: , a7 JTF_NUMBER_TABLE

6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_NUMBER_TABLE

Line 11: , a8 JTF_NUMBER_TABLE

7: , a4 JTF_DATE_TABLE
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE

Line 12: , a9 JTF_NUMBER_TABLE

8: , a5 JTF_DATE_TABLE
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_VARCHAR2_TABLE_100

Line 14: , a11 JTF_NUMBER_TABLE

10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_VARCHAR2_TABLE_500
18: , a15 JTF_VARCHAR2_TABLE_500

Line 15: , a12 JTF_NUMBER_TABLE

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

Line 32: , a29 JTF_NUMBER_TABLE

28: , a25 JTF_VARCHAR2_TABLE_500
29: , a26 JTF_VARCHAR2_TABLE_500
30: , a27 JTF_VARCHAR2_TABLE_500
31: , a28 JTF_VARCHAR2_TABLE_500
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_DATE_TABLE
34: , a31 JTF_NUMBER_TABLE
35: , a32 JTF_DATE_TABLE
36: , a33 JTF_NUMBER_TABLE

Line 34: , a31 JTF_NUMBER_TABLE

30: , a27 JTF_VARCHAR2_TABLE_500
31: , a28 JTF_VARCHAR2_TABLE_500
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_DATE_TABLE
34: , a31 JTF_NUMBER_TABLE
35: , a32 JTF_DATE_TABLE
36: , a33 JTF_NUMBER_TABLE
37: ) as
38: ddindx binary_integer; indx binary_integer;

Line 36: , a33 JTF_NUMBER_TABLE

32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_DATE_TABLE
34: , a31 JTF_NUMBER_TABLE
35: , a32 JTF_DATE_TABLE
36: , a33 JTF_NUMBER_TABLE
37: ) as
38: ddindx binary_integer; indx binary_integer;
39: begin
40: if a0 is not null and a0.count > 0 then

Line 88: procedure rosetta_table_copy_out_p1(t okl_srv_pvt.okl_srv_tbl, a0 out nocopy JTF_NUMBER_TABLE

84: end loop;
85: end if;
86: end if;
87: end rosetta_table_copy_in_p1;
88: procedure rosetta_table_copy_out_p1(t okl_srv_pvt.okl_srv_tbl, a0 out nocopy JTF_NUMBER_TABLE
89: , a1 out nocopy JTF_NUMBER_TABLE
90: , a2 out nocopy JTF_VARCHAR2_TABLE_100
91: , a3 out nocopy JTF_NUMBER_TABLE
92: , a4 out nocopy JTF_DATE_TABLE

Line 89: , a1 out nocopy JTF_NUMBER_TABLE

85: end if;
86: end if;
87: end rosetta_table_copy_in_p1;
88: procedure rosetta_table_copy_out_p1(t okl_srv_pvt.okl_srv_tbl, a0 out nocopy JTF_NUMBER_TABLE
89: , a1 out nocopy JTF_NUMBER_TABLE
90: , a2 out nocopy JTF_VARCHAR2_TABLE_100
91: , a3 out nocopy JTF_NUMBER_TABLE
92: , a4 out nocopy JTF_DATE_TABLE
93: , a5 out nocopy JTF_DATE_TABLE

Line 91: , a3 out nocopy JTF_NUMBER_TABLE

87: end rosetta_table_copy_in_p1;
88: procedure rosetta_table_copy_out_p1(t okl_srv_pvt.okl_srv_tbl, a0 out nocopy JTF_NUMBER_TABLE
89: , a1 out nocopy JTF_NUMBER_TABLE
90: , a2 out nocopy JTF_VARCHAR2_TABLE_100
91: , a3 out nocopy JTF_NUMBER_TABLE
92: , a4 out nocopy JTF_DATE_TABLE
93: , a5 out nocopy JTF_DATE_TABLE
94: , a6 out nocopy JTF_VARCHAR2_TABLE_100
95: , a7 out nocopy JTF_NUMBER_TABLE

Line 95: , a7 out nocopy JTF_NUMBER_TABLE

91: , a3 out nocopy JTF_NUMBER_TABLE
92: , a4 out nocopy JTF_DATE_TABLE
93: , a5 out nocopy JTF_DATE_TABLE
94: , a6 out nocopy JTF_VARCHAR2_TABLE_100
95: , a7 out nocopy JTF_NUMBER_TABLE
96: , a8 out nocopy JTF_NUMBER_TABLE
97: , a9 out nocopy JTF_NUMBER_TABLE
98: , a10 out nocopy JTF_VARCHAR2_TABLE_100
99: , a11 out nocopy JTF_NUMBER_TABLE

Line 96: , a8 out nocopy JTF_NUMBER_TABLE

92: , a4 out nocopy JTF_DATE_TABLE
93: , a5 out nocopy JTF_DATE_TABLE
94: , a6 out nocopy JTF_VARCHAR2_TABLE_100
95: , a7 out nocopy JTF_NUMBER_TABLE
96: , a8 out nocopy JTF_NUMBER_TABLE
97: , a9 out nocopy JTF_NUMBER_TABLE
98: , a10 out nocopy JTF_VARCHAR2_TABLE_100
99: , a11 out nocopy JTF_NUMBER_TABLE
100: , a12 out nocopy JTF_NUMBER_TABLE

Line 97: , a9 out nocopy JTF_NUMBER_TABLE

93: , a5 out nocopy JTF_DATE_TABLE
94: , a6 out nocopy JTF_VARCHAR2_TABLE_100
95: , a7 out nocopy JTF_NUMBER_TABLE
96: , a8 out nocopy JTF_NUMBER_TABLE
97: , a9 out nocopy JTF_NUMBER_TABLE
98: , a10 out nocopy JTF_VARCHAR2_TABLE_100
99: , a11 out nocopy JTF_NUMBER_TABLE
100: , a12 out nocopy JTF_NUMBER_TABLE
101: , a13 out nocopy JTF_VARCHAR2_TABLE_100

Line 99: , a11 out nocopy JTF_NUMBER_TABLE

95: , a7 out nocopy JTF_NUMBER_TABLE
96: , a8 out nocopy JTF_NUMBER_TABLE
97: , a9 out nocopy JTF_NUMBER_TABLE
98: , a10 out nocopy JTF_VARCHAR2_TABLE_100
99: , a11 out nocopy JTF_NUMBER_TABLE
100: , a12 out nocopy JTF_NUMBER_TABLE
101: , a13 out nocopy JTF_VARCHAR2_TABLE_100
102: , a14 out nocopy JTF_VARCHAR2_TABLE_500
103: , a15 out nocopy JTF_VARCHAR2_TABLE_500

Line 100: , a12 out nocopy JTF_NUMBER_TABLE

96: , a8 out nocopy JTF_NUMBER_TABLE
97: , a9 out nocopy JTF_NUMBER_TABLE
98: , a10 out nocopy JTF_VARCHAR2_TABLE_100
99: , a11 out nocopy JTF_NUMBER_TABLE
100: , a12 out nocopy JTF_NUMBER_TABLE
101: , a13 out nocopy JTF_VARCHAR2_TABLE_100
102: , a14 out nocopy JTF_VARCHAR2_TABLE_500
103: , a15 out nocopy JTF_VARCHAR2_TABLE_500
104: , a16 out nocopy JTF_VARCHAR2_TABLE_500

Line 117: , a29 out nocopy JTF_NUMBER_TABLE

113: , a25 out nocopy JTF_VARCHAR2_TABLE_500
114: , a26 out nocopy JTF_VARCHAR2_TABLE_500
115: , a27 out nocopy JTF_VARCHAR2_TABLE_500
116: , a28 out nocopy JTF_VARCHAR2_TABLE_500
117: , a29 out nocopy JTF_NUMBER_TABLE
118: , a30 out nocopy JTF_DATE_TABLE
119: , a31 out nocopy JTF_NUMBER_TABLE
120: , a32 out nocopy JTF_DATE_TABLE
121: , a33 out nocopy JTF_NUMBER_TABLE

Line 119: , a31 out nocopy JTF_NUMBER_TABLE

115: , a27 out nocopy JTF_VARCHAR2_TABLE_500
116: , a28 out nocopy JTF_VARCHAR2_TABLE_500
117: , a29 out nocopy JTF_NUMBER_TABLE
118: , a30 out nocopy JTF_DATE_TABLE
119: , a31 out nocopy JTF_NUMBER_TABLE
120: , a32 out nocopy JTF_DATE_TABLE
121: , a33 out nocopy JTF_NUMBER_TABLE
122: ) as
123: ddindx binary_integer; indx binary_integer;

Line 121: , a33 out nocopy JTF_NUMBER_TABLE

117: , a29 out nocopy JTF_NUMBER_TABLE
118: , a30 out nocopy JTF_DATE_TABLE
119: , a31 out nocopy JTF_NUMBER_TABLE
120: , a32 out nocopy JTF_DATE_TABLE
121: , a33 out nocopy JTF_NUMBER_TABLE
122: ) as
123: ddindx binary_integer; indx binary_integer;
124: begin
125: if t is null or t.count = 0 then

Line 126: a0 := JTF_NUMBER_TABLE();

122: ) as
123: ddindx binary_integer; indx binary_integer;
124: begin
125: if t is null or t.count = 0 then
126: a0 := JTF_NUMBER_TABLE();
127: a1 := JTF_NUMBER_TABLE();
128: a2 := JTF_VARCHAR2_TABLE_100();
129: a3 := JTF_NUMBER_TABLE();
130: a4 := JTF_DATE_TABLE();

Line 127: a1 := JTF_NUMBER_TABLE();

123: ddindx binary_integer; indx binary_integer;
124: begin
125: if t is null or t.count = 0 then
126: a0 := JTF_NUMBER_TABLE();
127: a1 := JTF_NUMBER_TABLE();
128: a2 := JTF_VARCHAR2_TABLE_100();
129: a3 := JTF_NUMBER_TABLE();
130: a4 := JTF_DATE_TABLE();
131: a5 := JTF_DATE_TABLE();

Line 129: a3 := JTF_NUMBER_TABLE();

125: if t is null or t.count = 0 then
126: a0 := JTF_NUMBER_TABLE();
127: a1 := JTF_NUMBER_TABLE();
128: a2 := JTF_VARCHAR2_TABLE_100();
129: a3 := JTF_NUMBER_TABLE();
130: a4 := JTF_DATE_TABLE();
131: a5 := JTF_DATE_TABLE();
132: a6 := JTF_VARCHAR2_TABLE_100();
133: a7 := JTF_NUMBER_TABLE();

Line 133: a7 := JTF_NUMBER_TABLE();

129: a3 := JTF_NUMBER_TABLE();
130: a4 := JTF_DATE_TABLE();
131: a5 := JTF_DATE_TABLE();
132: a6 := JTF_VARCHAR2_TABLE_100();
133: a7 := JTF_NUMBER_TABLE();
134: a8 := JTF_NUMBER_TABLE();
135: a9 := JTF_NUMBER_TABLE();
136: a10 := JTF_VARCHAR2_TABLE_100();
137: a11 := JTF_NUMBER_TABLE();

Line 134: a8 := JTF_NUMBER_TABLE();

130: a4 := JTF_DATE_TABLE();
131: a5 := JTF_DATE_TABLE();
132: a6 := JTF_VARCHAR2_TABLE_100();
133: a7 := JTF_NUMBER_TABLE();
134: a8 := JTF_NUMBER_TABLE();
135: a9 := JTF_NUMBER_TABLE();
136: a10 := JTF_VARCHAR2_TABLE_100();
137: a11 := JTF_NUMBER_TABLE();
138: a12 := JTF_NUMBER_TABLE();

Line 135: a9 := JTF_NUMBER_TABLE();

131: a5 := JTF_DATE_TABLE();
132: a6 := JTF_VARCHAR2_TABLE_100();
133: a7 := JTF_NUMBER_TABLE();
134: a8 := JTF_NUMBER_TABLE();
135: a9 := JTF_NUMBER_TABLE();
136: a10 := JTF_VARCHAR2_TABLE_100();
137: a11 := JTF_NUMBER_TABLE();
138: a12 := JTF_NUMBER_TABLE();
139: a13 := JTF_VARCHAR2_TABLE_100();

Line 137: a11 := JTF_NUMBER_TABLE();

133: a7 := JTF_NUMBER_TABLE();
134: a8 := JTF_NUMBER_TABLE();
135: a9 := JTF_NUMBER_TABLE();
136: a10 := JTF_VARCHAR2_TABLE_100();
137: a11 := JTF_NUMBER_TABLE();
138: a12 := JTF_NUMBER_TABLE();
139: a13 := JTF_VARCHAR2_TABLE_100();
140: a14 := JTF_VARCHAR2_TABLE_500();
141: a15 := JTF_VARCHAR2_TABLE_500();

Line 138: a12 := JTF_NUMBER_TABLE();

134: a8 := JTF_NUMBER_TABLE();
135: a9 := JTF_NUMBER_TABLE();
136: a10 := JTF_VARCHAR2_TABLE_100();
137: a11 := JTF_NUMBER_TABLE();
138: a12 := JTF_NUMBER_TABLE();
139: a13 := JTF_VARCHAR2_TABLE_100();
140: a14 := JTF_VARCHAR2_TABLE_500();
141: a15 := JTF_VARCHAR2_TABLE_500();
142: a16 := JTF_VARCHAR2_TABLE_500();

Line 155: a29 := JTF_NUMBER_TABLE();

151: a25 := JTF_VARCHAR2_TABLE_500();
152: a26 := JTF_VARCHAR2_TABLE_500();
153: a27 := JTF_VARCHAR2_TABLE_500();
154: a28 := JTF_VARCHAR2_TABLE_500();
155: a29 := JTF_NUMBER_TABLE();
156: a30 := JTF_DATE_TABLE();
157: a31 := JTF_NUMBER_TABLE();
158: a32 := JTF_DATE_TABLE();
159: a33 := JTF_NUMBER_TABLE();

Line 157: a31 := JTF_NUMBER_TABLE();

153: a27 := JTF_VARCHAR2_TABLE_500();
154: a28 := JTF_VARCHAR2_TABLE_500();
155: a29 := JTF_NUMBER_TABLE();
156: a30 := JTF_DATE_TABLE();
157: a31 := JTF_NUMBER_TABLE();
158: a32 := JTF_DATE_TABLE();
159: a33 := JTF_NUMBER_TABLE();
160: else
161: a0 := JTF_NUMBER_TABLE();

Line 159: a33 := JTF_NUMBER_TABLE();

155: a29 := JTF_NUMBER_TABLE();
156: a30 := JTF_DATE_TABLE();
157: a31 := JTF_NUMBER_TABLE();
158: a32 := JTF_DATE_TABLE();
159: a33 := JTF_NUMBER_TABLE();
160: else
161: a0 := JTF_NUMBER_TABLE();
162: a1 := JTF_NUMBER_TABLE();
163: a2 := JTF_VARCHAR2_TABLE_100();

Line 161: a0 := JTF_NUMBER_TABLE();

157: a31 := JTF_NUMBER_TABLE();
158: a32 := JTF_DATE_TABLE();
159: a33 := JTF_NUMBER_TABLE();
160: else
161: a0 := JTF_NUMBER_TABLE();
162: a1 := JTF_NUMBER_TABLE();
163: a2 := JTF_VARCHAR2_TABLE_100();
164: a3 := JTF_NUMBER_TABLE();
165: a4 := JTF_DATE_TABLE();

Line 162: a1 := JTF_NUMBER_TABLE();

158: a32 := JTF_DATE_TABLE();
159: a33 := JTF_NUMBER_TABLE();
160: else
161: a0 := JTF_NUMBER_TABLE();
162: a1 := JTF_NUMBER_TABLE();
163: a2 := JTF_VARCHAR2_TABLE_100();
164: a3 := JTF_NUMBER_TABLE();
165: a4 := JTF_DATE_TABLE();
166: a5 := JTF_DATE_TABLE();

Line 164: a3 := JTF_NUMBER_TABLE();

160: else
161: a0 := JTF_NUMBER_TABLE();
162: a1 := JTF_NUMBER_TABLE();
163: a2 := JTF_VARCHAR2_TABLE_100();
164: a3 := JTF_NUMBER_TABLE();
165: a4 := JTF_DATE_TABLE();
166: a5 := JTF_DATE_TABLE();
167: a6 := JTF_VARCHAR2_TABLE_100();
168: a7 := JTF_NUMBER_TABLE();

Line 168: a7 := JTF_NUMBER_TABLE();

164: a3 := JTF_NUMBER_TABLE();
165: a4 := JTF_DATE_TABLE();
166: a5 := JTF_DATE_TABLE();
167: a6 := JTF_VARCHAR2_TABLE_100();
168: a7 := JTF_NUMBER_TABLE();
169: a8 := JTF_NUMBER_TABLE();
170: a9 := JTF_NUMBER_TABLE();
171: a10 := JTF_VARCHAR2_TABLE_100();
172: a11 := JTF_NUMBER_TABLE();

Line 169: a8 := JTF_NUMBER_TABLE();

165: a4 := JTF_DATE_TABLE();
166: a5 := JTF_DATE_TABLE();
167: a6 := JTF_VARCHAR2_TABLE_100();
168: a7 := JTF_NUMBER_TABLE();
169: a8 := JTF_NUMBER_TABLE();
170: a9 := JTF_NUMBER_TABLE();
171: a10 := JTF_VARCHAR2_TABLE_100();
172: a11 := JTF_NUMBER_TABLE();
173: a12 := JTF_NUMBER_TABLE();

Line 170: a9 := JTF_NUMBER_TABLE();

166: a5 := JTF_DATE_TABLE();
167: a6 := JTF_VARCHAR2_TABLE_100();
168: a7 := JTF_NUMBER_TABLE();
169: a8 := JTF_NUMBER_TABLE();
170: a9 := JTF_NUMBER_TABLE();
171: a10 := JTF_VARCHAR2_TABLE_100();
172: a11 := JTF_NUMBER_TABLE();
173: a12 := JTF_NUMBER_TABLE();
174: a13 := JTF_VARCHAR2_TABLE_100();

Line 172: a11 := JTF_NUMBER_TABLE();

168: a7 := JTF_NUMBER_TABLE();
169: a8 := JTF_NUMBER_TABLE();
170: a9 := JTF_NUMBER_TABLE();
171: a10 := JTF_VARCHAR2_TABLE_100();
172: a11 := JTF_NUMBER_TABLE();
173: a12 := JTF_NUMBER_TABLE();
174: a13 := JTF_VARCHAR2_TABLE_100();
175: a14 := JTF_VARCHAR2_TABLE_500();
176: a15 := JTF_VARCHAR2_TABLE_500();

Line 173: a12 := JTF_NUMBER_TABLE();

169: a8 := JTF_NUMBER_TABLE();
170: a9 := JTF_NUMBER_TABLE();
171: a10 := JTF_VARCHAR2_TABLE_100();
172: a11 := JTF_NUMBER_TABLE();
173: a12 := JTF_NUMBER_TABLE();
174: a13 := JTF_VARCHAR2_TABLE_100();
175: a14 := JTF_VARCHAR2_TABLE_500();
176: a15 := JTF_VARCHAR2_TABLE_500();
177: a16 := JTF_VARCHAR2_TABLE_500();

Line 190: a29 := JTF_NUMBER_TABLE();

186: a25 := JTF_VARCHAR2_TABLE_500();
187: a26 := JTF_VARCHAR2_TABLE_500();
188: a27 := JTF_VARCHAR2_TABLE_500();
189: a28 := JTF_VARCHAR2_TABLE_500();
190: a29 := JTF_NUMBER_TABLE();
191: a30 := JTF_DATE_TABLE();
192: a31 := JTF_NUMBER_TABLE();
193: a32 := JTF_DATE_TABLE();
194: a33 := JTF_NUMBER_TABLE();

Line 192: a31 := JTF_NUMBER_TABLE();

188: a27 := JTF_VARCHAR2_TABLE_500();
189: a28 := JTF_VARCHAR2_TABLE_500();
190: a29 := JTF_NUMBER_TABLE();
191: a30 := JTF_DATE_TABLE();
192: a31 := JTF_NUMBER_TABLE();
193: a32 := JTF_DATE_TABLE();
194: a33 := JTF_NUMBER_TABLE();
195: if t.count > 0 then
196: a0.extend(t.count);

Line 194: a33 := JTF_NUMBER_TABLE();

190: a29 := JTF_NUMBER_TABLE();
191: a30 := JTF_DATE_TABLE();
192: a31 := JTF_NUMBER_TABLE();
193: a32 := JTF_DATE_TABLE();
194: a33 := JTF_NUMBER_TABLE();
195: if t.count > 0 then
196: a0.extend(t.count);
197: a1.extend(t.count);
198: a2.extend(t.count);

Line 457: , p5_a0 JTF_NUMBER_TABLE

453: , p_init_msg_list VARCHAR2
454: , x_return_status out nocopy VARCHAR2
455: , x_msg_count out nocopy NUMBER
456: , x_msg_data out nocopy VARCHAR2
457: , p5_a0 JTF_NUMBER_TABLE
458: , p5_a1 JTF_NUMBER_TABLE
459: , p5_a2 JTF_VARCHAR2_TABLE_100
460: , p5_a3 JTF_NUMBER_TABLE
461: , p5_a4 JTF_DATE_TABLE

Line 458: , p5_a1 JTF_NUMBER_TABLE

454: , x_return_status out nocopy VARCHAR2
455: , x_msg_count out nocopy NUMBER
456: , x_msg_data out nocopy VARCHAR2
457: , p5_a0 JTF_NUMBER_TABLE
458: , p5_a1 JTF_NUMBER_TABLE
459: , p5_a2 JTF_VARCHAR2_TABLE_100
460: , p5_a3 JTF_NUMBER_TABLE
461: , p5_a4 JTF_DATE_TABLE
462: , p5_a5 JTF_DATE_TABLE

Line 460: , p5_a3 JTF_NUMBER_TABLE

456: , x_msg_data out nocopy VARCHAR2
457: , p5_a0 JTF_NUMBER_TABLE
458: , p5_a1 JTF_NUMBER_TABLE
459: , p5_a2 JTF_VARCHAR2_TABLE_100
460: , p5_a3 JTF_NUMBER_TABLE
461: , p5_a4 JTF_DATE_TABLE
462: , p5_a5 JTF_DATE_TABLE
463: , p5_a6 JTF_VARCHAR2_TABLE_100
464: , p5_a7 JTF_NUMBER_TABLE

Line 464: , p5_a7 JTF_NUMBER_TABLE

460: , p5_a3 JTF_NUMBER_TABLE
461: , p5_a4 JTF_DATE_TABLE
462: , p5_a5 JTF_DATE_TABLE
463: , p5_a6 JTF_VARCHAR2_TABLE_100
464: , p5_a7 JTF_NUMBER_TABLE
465: , p5_a8 JTF_NUMBER_TABLE
466: , p5_a9 JTF_NUMBER_TABLE
467: , p5_a10 JTF_VARCHAR2_TABLE_100
468: , p5_a11 JTF_NUMBER_TABLE

Line 465: , p5_a8 JTF_NUMBER_TABLE

461: , p5_a4 JTF_DATE_TABLE
462: , p5_a5 JTF_DATE_TABLE
463: , p5_a6 JTF_VARCHAR2_TABLE_100
464: , p5_a7 JTF_NUMBER_TABLE
465: , p5_a8 JTF_NUMBER_TABLE
466: , p5_a9 JTF_NUMBER_TABLE
467: , p5_a10 JTF_VARCHAR2_TABLE_100
468: , p5_a11 JTF_NUMBER_TABLE
469: , p5_a12 JTF_NUMBER_TABLE

Line 466: , p5_a9 JTF_NUMBER_TABLE

462: , p5_a5 JTF_DATE_TABLE
463: , p5_a6 JTF_VARCHAR2_TABLE_100
464: , p5_a7 JTF_NUMBER_TABLE
465: , p5_a8 JTF_NUMBER_TABLE
466: , p5_a9 JTF_NUMBER_TABLE
467: , p5_a10 JTF_VARCHAR2_TABLE_100
468: , p5_a11 JTF_NUMBER_TABLE
469: , p5_a12 JTF_NUMBER_TABLE
470: , p5_a13 JTF_VARCHAR2_TABLE_100

Line 468: , p5_a11 JTF_NUMBER_TABLE

464: , p5_a7 JTF_NUMBER_TABLE
465: , p5_a8 JTF_NUMBER_TABLE
466: , p5_a9 JTF_NUMBER_TABLE
467: , p5_a10 JTF_VARCHAR2_TABLE_100
468: , p5_a11 JTF_NUMBER_TABLE
469: , p5_a12 JTF_NUMBER_TABLE
470: , p5_a13 JTF_VARCHAR2_TABLE_100
471: , p5_a14 JTF_VARCHAR2_TABLE_500
472: , p5_a15 JTF_VARCHAR2_TABLE_500

Line 469: , p5_a12 JTF_NUMBER_TABLE

465: , p5_a8 JTF_NUMBER_TABLE
466: , p5_a9 JTF_NUMBER_TABLE
467: , p5_a10 JTF_VARCHAR2_TABLE_100
468: , p5_a11 JTF_NUMBER_TABLE
469: , p5_a12 JTF_NUMBER_TABLE
470: , p5_a13 JTF_VARCHAR2_TABLE_100
471: , p5_a14 JTF_VARCHAR2_TABLE_500
472: , p5_a15 JTF_VARCHAR2_TABLE_500
473: , p5_a16 JTF_VARCHAR2_TABLE_500

Line 486: , p5_a29 JTF_NUMBER_TABLE

482: , p5_a25 JTF_VARCHAR2_TABLE_500
483: , p5_a26 JTF_VARCHAR2_TABLE_500
484: , p5_a27 JTF_VARCHAR2_TABLE_500
485: , p5_a28 JTF_VARCHAR2_TABLE_500
486: , p5_a29 JTF_NUMBER_TABLE
487: , p5_a30 JTF_DATE_TABLE
488: , p5_a31 JTF_NUMBER_TABLE
489: , p5_a32 JTF_DATE_TABLE
490: , p5_a33 JTF_NUMBER_TABLE

Line 488: , p5_a31 JTF_NUMBER_TABLE

484: , p5_a27 JTF_VARCHAR2_TABLE_500
485: , p5_a28 JTF_VARCHAR2_TABLE_500
486: , p5_a29 JTF_NUMBER_TABLE
487: , p5_a30 JTF_DATE_TABLE
488: , p5_a31 JTF_NUMBER_TABLE
489: , p5_a32 JTF_DATE_TABLE
490: , p5_a33 JTF_NUMBER_TABLE
491: , p6_a0 out nocopy JTF_NUMBER_TABLE
492: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 490: , p5_a33 JTF_NUMBER_TABLE

486: , p5_a29 JTF_NUMBER_TABLE
487: , p5_a30 JTF_DATE_TABLE
488: , p5_a31 JTF_NUMBER_TABLE
489: , p5_a32 JTF_DATE_TABLE
490: , p5_a33 JTF_NUMBER_TABLE
491: , p6_a0 out nocopy JTF_NUMBER_TABLE
492: , p6_a1 out nocopy JTF_NUMBER_TABLE
493: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
494: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 491: , p6_a0 out nocopy JTF_NUMBER_TABLE

487: , p5_a30 JTF_DATE_TABLE
488: , p5_a31 JTF_NUMBER_TABLE
489: , p5_a32 JTF_DATE_TABLE
490: , p5_a33 JTF_NUMBER_TABLE
491: , p6_a0 out nocopy JTF_NUMBER_TABLE
492: , p6_a1 out nocopy JTF_NUMBER_TABLE
493: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
494: , p6_a3 out nocopy JTF_NUMBER_TABLE
495: , p6_a4 out nocopy JTF_DATE_TABLE

Line 492: , p6_a1 out nocopy JTF_NUMBER_TABLE

488: , p5_a31 JTF_NUMBER_TABLE
489: , p5_a32 JTF_DATE_TABLE
490: , p5_a33 JTF_NUMBER_TABLE
491: , p6_a0 out nocopy JTF_NUMBER_TABLE
492: , p6_a1 out nocopy JTF_NUMBER_TABLE
493: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
494: , p6_a3 out nocopy JTF_NUMBER_TABLE
495: , p6_a4 out nocopy JTF_DATE_TABLE
496: , p6_a5 out nocopy JTF_DATE_TABLE

Line 494: , p6_a3 out nocopy JTF_NUMBER_TABLE

490: , p5_a33 JTF_NUMBER_TABLE
491: , p6_a0 out nocopy JTF_NUMBER_TABLE
492: , p6_a1 out nocopy JTF_NUMBER_TABLE
493: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
494: , p6_a3 out nocopy JTF_NUMBER_TABLE
495: , p6_a4 out nocopy JTF_DATE_TABLE
496: , p6_a5 out nocopy JTF_DATE_TABLE
497: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
498: , p6_a7 out nocopy JTF_NUMBER_TABLE

Line 498: , p6_a7 out nocopy JTF_NUMBER_TABLE

494: , p6_a3 out nocopy JTF_NUMBER_TABLE
495: , p6_a4 out nocopy JTF_DATE_TABLE
496: , p6_a5 out nocopy JTF_DATE_TABLE
497: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
498: , p6_a7 out nocopy JTF_NUMBER_TABLE
499: , p6_a8 out nocopy JTF_NUMBER_TABLE
500: , p6_a9 out nocopy JTF_NUMBER_TABLE
501: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
502: , p6_a11 out nocopy JTF_NUMBER_TABLE

Line 499: , p6_a8 out nocopy JTF_NUMBER_TABLE

495: , p6_a4 out nocopy JTF_DATE_TABLE
496: , p6_a5 out nocopy JTF_DATE_TABLE
497: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
498: , p6_a7 out nocopy JTF_NUMBER_TABLE
499: , p6_a8 out nocopy JTF_NUMBER_TABLE
500: , p6_a9 out nocopy JTF_NUMBER_TABLE
501: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
502: , p6_a11 out nocopy JTF_NUMBER_TABLE
503: , p6_a12 out nocopy JTF_NUMBER_TABLE

Line 500: , p6_a9 out nocopy JTF_NUMBER_TABLE

496: , p6_a5 out nocopy JTF_DATE_TABLE
497: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
498: , p6_a7 out nocopy JTF_NUMBER_TABLE
499: , p6_a8 out nocopy JTF_NUMBER_TABLE
500: , p6_a9 out nocopy JTF_NUMBER_TABLE
501: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
502: , p6_a11 out nocopy JTF_NUMBER_TABLE
503: , p6_a12 out nocopy JTF_NUMBER_TABLE
504: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100

Line 502: , p6_a11 out nocopy JTF_NUMBER_TABLE

498: , p6_a7 out nocopy JTF_NUMBER_TABLE
499: , p6_a8 out nocopy JTF_NUMBER_TABLE
500: , p6_a9 out nocopy JTF_NUMBER_TABLE
501: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
502: , p6_a11 out nocopy JTF_NUMBER_TABLE
503: , p6_a12 out nocopy JTF_NUMBER_TABLE
504: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
505: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
506: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500

Line 503: , p6_a12 out nocopy JTF_NUMBER_TABLE

499: , p6_a8 out nocopy JTF_NUMBER_TABLE
500: , p6_a9 out nocopy JTF_NUMBER_TABLE
501: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
502: , p6_a11 out nocopy JTF_NUMBER_TABLE
503: , p6_a12 out nocopy JTF_NUMBER_TABLE
504: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
505: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
506: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
507: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500

Line 520: , p6_a29 out nocopy JTF_NUMBER_TABLE

516: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
517: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
518: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
519: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
520: , p6_a29 out nocopy JTF_NUMBER_TABLE
521: , p6_a30 out nocopy JTF_DATE_TABLE
522: , p6_a31 out nocopy JTF_NUMBER_TABLE
523: , p6_a32 out nocopy JTF_DATE_TABLE
524: , p6_a33 out nocopy JTF_NUMBER_TABLE

Line 522: , p6_a31 out nocopy JTF_NUMBER_TABLE

518: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
519: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
520: , p6_a29 out nocopy JTF_NUMBER_TABLE
521: , p6_a30 out nocopy JTF_DATE_TABLE
522: , p6_a31 out nocopy JTF_NUMBER_TABLE
523: , p6_a32 out nocopy JTF_DATE_TABLE
524: , p6_a33 out nocopy JTF_NUMBER_TABLE
525: )
526:

Line 524: , p6_a33 out nocopy JTF_NUMBER_TABLE

520: , p6_a29 out nocopy JTF_NUMBER_TABLE
521: , p6_a30 out nocopy JTF_DATE_TABLE
522: , p6_a31 out nocopy JTF_NUMBER_TABLE
523: , p6_a32 out nocopy JTF_DATE_TABLE
524: , p6_a33 out nocopy JTF_NUMBER_TABLE
525: )
526:
527: as
528: ddp_srv_tbl okl_srv_pvt.okl_srv_tbl;

Line 809: , p5_a0 JTF_NUMBER_TABLE

805: , p_init_msg_list VARCHAR2
806: , x_return_status out nocopy VARCHAR2
807: , x_msg_count out nocopy NUMBER
808: , x_msg_data out nocopy VARCHAR2
809: , p5_a0 JTF_NUMBER_TABLE
810: , p5_a1 JTF_NUMBER_TABLE
811: , p5_a2 JTF_VARCHAR2_TABLE_100
812: , p5_a3 JTF_NUMBER_TABLE
813: , p5_a4 JTF_DATE_TABLE

Line 810: , p5_a1 JTF_NUMBER_TABLE

806: , x_return_status out nocopy VARCHAR2
807: , x_msg_count out nocopy NUMBER
808: , x_msg_data out nocopy VARCHAR2
809: , p5_a0 JTF_NUMBER_TABLE
810: , p5_a1 JTF_NUMBER_TABLE
811: , p5_a2 JTF_VARCHAR2_TABLE_100
812: , p5_a3 JTF_NUMBER_TABLE
813: , p5_a4 JTF_DATE_TABLE
814: , p5_a5 JTF_DATE_TABLE

Line 812: , p5_a3 JTF_NUMBER_TABLE

808: , x_msg_data out nocopy VARCHAR2
809: , p5_a0 JTF_NUMBER_TABLE
810: , p5_a1 JTF_NUMBER_TABLE
811: , p5_a2 JTF_VARCHAR2_TABLE_100
812: , p5_a3 JTF_NUMBER_TABLE
813: , p5_a4 JTF_DATE_TABLE
814: , p5_a5 JTF_DATE_TABLE
815: , p5_a6 JTF_VARCHAR2_TABLE_100
816: , p5_a7 JTF_NUMBER_TABLE

Line 816: , p5_a7 JTF_NUMBER_TABLE

812: , p5_a3 JTF_NUMBER_TABLE
813: , p5_a4 JTF_DATE_TABLE
814: , p5_a5 JTF_DATE_TABLE
815: , p5_a6 JTF_VARCHAR2_TABLE_100
816: , p5_a7 JTF_NUMBER_TABLE
817: , p5_a8 JTF_NUMBER_TABLE
818: , p5_a9 JTF_NUMBER_TABLE
819: , p5_a10 JTF_VARCHAR2_TABLE_100
820: , p5_a11 JTF_NUMBER_TABLE

Line 817: , p5_a8 JTF_NUMBER_TABLE

813: , p5_a4 JTF_DATE_TABLE
814: , p5_a5 JTF_DATE_TABLE
815: , p5_a6 JTF_VARCHAR2_TABLE_100
816: , p5_a7 JTF_NUMBER_TABLE
817: , p5_a8 JTF_NUMBER_TABLE
818: , p5_a9 JTF_NUMBER_TABLE
819: , p5_a10 JTF_VARCHAR2_TABLE_100
820: , p5_a11 JTF_NUMBER_TABLE
821: , p5_a12 JTF_NUMBER_TABLE

Line 818: , p5_a9 JTF_NUMBER_TABLE

814: , p5_a5 JTF_DATE_TABLE
815: , p5_a6 JTF_VARCHAR2_TABLE_100
816: , p5_a7 JTF_NUMBER_TABLE
817: , p5_a8 JTF_NUMBER_TABLE
818: , p5_a9 JTF_NUMBER_TABLE
819: , p5_a10 JTF_VARCHAR2_TABLE_100
820: , p5_a11 JTF_NUMBER_TABLE
821: , p5_a12 JTF_NUMBER_TABLE
822: , p5_a13 JTF_VARCHAR2_TABLE_100

Line 820: , p5_a11 JTF_NUMBER_TABLE

816: , p5_a7 JTF_NUMBER_TABLE
817: , p5_a8 JTF_NUMBER_TABLE
818: , p5_a9 JTF_NUMBER_TABLE
819: , p5_a10 JTF_VARCHAR2_TABLE_100
820: , p5_a11 JTF_NUMBER_TABLE
821: , p5_a12 JTF_NUMBER_TABLE
822: , p5_a13 JTF_VARCHAR2_TABLE_100
823: , p5_a14 JTF_VARCHAR2_TABLE_500
824: , p5_a15 JTF_VARCHAR2_TABLE_500

Line 821: , p5_a12 JTF_NUMBER_TABLE

817: , p5_a8 JTF_NUMBER_TABLE
818: , p5_a9 JTF_NUMBER_TABLE
819: , p5_a10 JTF_VARCHAR2_TABLE_100
820: , p5_a11 JTF_NUMBER_TABLE
821: , p5_a12 JTF_NUMBER_TABLE
822: , p5_a13 JTF_VARCHAR2_TABLE_100
823: , p5_a14 JTF_VARCHAR2_TABLE_500
824: , p5_a15 JTF_VARCHAR2_TABLE_500
825: , p5_a16 JTF_VARCHAR2_TABLE_500

Line 838: , p5_a29 JTF_NUMBER_TABLE

834: , p5_a25 JTF_VARCHAR2_TABLE_500
835: , p5_a26 JTF_VARCHAR2_TABLE_500
836: , p5_a27 JTF_VARCHAR2_TABLE_500
837: , p5_a28 JTF_VARCHAR2_TABLE_500
838: , p5_a29 JTF_NUMBER_TABLE
839: , p5_a30 JTF_DATE_TABLE
840: , p5_a31 JTF_NUMBER_TABLE
841: , p5_a32 JTF_DATE_TABLE
842: , p5_a33 JTF_NUMBER_TABLE

Line 840: , p5_a31 JTF_NUMBER_TABLE

836: , p5_a27 JTF_VARCHAR2_TABLE_500
837: , p5_a28 JTF_VARCHAR2_TABLE_500
838: , p5_a29 JTF_NUMBER_TABLE
839: , p5_a30 JTF_DATE_TABLE
840: , p5_a31 JTF_NUMBER_TABLE
841: , p5_a32 JTF_DATE_TABLE
842: , p5_a33 JTF_NUMBER_TABLE
843: , p6_a0 out nocopy JTF_NUMBER_TABLE
844: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 842: , p5_a33 JTF_NUMBER_TABLE

838: , p5_a29 JTF_NUMBER_TABLE
839: , p5_a30 JTF_DATE_TABLE
840: , p5_a31 JTF_NUMBER_TABLE
841: , p5_a32 JTF_DATE_TABLE
842: , p5_a33 JTF_NUMBER_TABLE
843: , p6_a0 out nocopy JTF_NUMBER_TABLE
844: , p6_a1 out nocopy JTF_NUMBER_TABLE
845: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
846: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 843: , p6_a0 out nocopy JTF_NUMBER_TABLE

839: , p5_a30 JTF_DATE_TABLE
840: , p5_a31 JTF_NUMBER_TABLE
841: , p5_a32 JTF_DATE_TABLE
842: , p5_a33 JTF_NUMBER_TABLE
843: , p6_a0 out nocopy JTF_NUMBER_TABLE
844: , p6_a1 out nocopy JTF_NUMBER_TABLE
845: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
846: , p6_a3 out nocopy JTF_NUMBER_TABLE
847: , p6_a4 out nocopy JTF_DATE_TABLE

Line 844: , p6_a1 out nocopy JTF_NUMBER_TABLE

840: , p5_a31 JTF_NUMBER_TABLE
841: , p5_a32 JTF_DATE_TABLE
842: , p5_a33 JTF_NUMBER_TABLE
843: , p6_a0 out nocopy JTF_NUMBER_TABLE
844: , p6_a1 out nocopy JTF_NUMBER_TABLE
845: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
846: , p6_a3 out nocopy JTF_NUMBER_TABLE
847: , p6_a4 out nocopy JTF_DATE_TABLE
848: , p6_a5 out nocopy JTF_DATE_TABLE

Line 846: , p6_a3 out nocopy JTF_NUMBER_TABLE

842: , p5_a33 JTF_NUMBER_TABLE
843: , p6_a0 out nocopy JTF_NUMBER_TABLE
844: , p6_a1 out nocopy JTF_NUMBER_TABLE
845: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
846: , p6_a3 out nocopy JTF_NUMBER_TABLE
847: , p6_a4 out nocopy JTF_DATE_TABLE
848: , p6_a5 out nocopy JTF_DATE_TABLE
849: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
850: , p6_a7 out nocopy JTF_NUMBER_TABLE

Line 850: , p6_a7 out nocopy JTF_NUMBER_TABLE

846: , p6_a3 out nocopy JTF_NUMBER_TABLE
847: , p6_a4 out nocopy JTF_DATE_TABLE
848: , p6_a5 out nocopy JTF_DATE_TABLE
849: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
850: , p6_a7 out nocopy JTF_NUMBER_TABLE
851: , p6_a8 out nocopy JTF_NUMBER_TABLE
852: , p6_a9 out nocopy JTF_NUMBER_TABLE
853: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
854: , p6_a11 out nocopy JTF_NUMBER_TABLE

Line 851: , p6_a8 out nocopy JTF_NUMBER_TABLE

847: , p6_a4 out nocopy JTF_DATE_TABLE
848: , p6_a5 out nocopy JTF_DATE_TABLE
849: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
850: , p6_a7 out nocopy JTF_NUMBER_TABLE
851: , p6_a8 out nocopy JTF_NUMBER_TABLE
852: , p6_a9 out nocopy JTF_NUMBER_TABLE
853: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
854: , p6_a11 out nocopy JTF_NUMBER_TABLE
855: , p6_a12 out nocopy JTF_NUMBER_TABLE

Line 852: , p6_a9 out nocopy JTF_NUMBER_TABLE

848: , p6_a5 out nocopy JTF_DATE_TABLE
849: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
850: , p6_a7 out nocopy JTF_NUMBER_TABLE
851: , p6_a8 out nocopy JTF_NUMBER_TABLE
852: , p6_a9 out nocopy JTF_NUMBER_TABLE
853: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
854: , p6_a11 out nocopy JTF_NUMBER_TABLE
855: , p6_a12 out nocopy JTF_NUMBER_TABLE
856: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100

Line 854: , p6_a11 out nocopy JTF_NUMBER_TABLE

850: , p6_a7 out nocopy JTF_NUMBER_TABLE
851: , p6_a8 out nocopy JTF_NUMBER_TABLE
852: , p6_a9 out nocopy JTF_NUMBER_TABLE
853: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
854: , p6_a11 out nocopy JTF_NUMBER_TABLE
855: , p6_a12 out nocopy JTF_NUMBER_TABLE
856: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
857: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
858: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500

Line 855: , p6_a12 out nocopy JTF_NUMBER_TABLE

851: , p6_a8 out nocopy JTF_NUMBER_TABLE
852: , p6_a9 out nocopy JTF_NUMBER_TABLE
853: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
854: , p6_a11 out nocopy JTF_NUMBER_TABLE
855: , p6_a12 out nocopy JTF_NUMBER_TABLE
856: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
857: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
858: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
859: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500

Line 872: , p6_a29 out nocopy JTF_NUMBER_TABLE

868: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
869: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
870: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
871: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
872: , p6_a29 out nocopy JTF_NUMBER_TABLE
873: , p6_a30 out nocopy JTF_DATE_TABLE
874: , p6_a31 out nocopy JTF_NUMBER_TABLE
875: , p6_a32 out nocopy JTF_DATE_TABLE
876: , p6_a33 out nocopy JTF_NUMBER_TABLE

Line 874: , p6_a31 out nocopy JTF_NUMBER_TABLE

870: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
871: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
872: , p6_a29 out nocopy JTF_NUMBER_TABLE
873: , p6_a30 out nocopy JTF_DATE_TABLE
874: , p6_a31 out nocopy JTF_NUMBER_TABLE
875: , p6_a32 out nocopy JTF_DATE_TABLE
876: , p6_a33 out nocopy JTF_NUMBER_TABLE
877: )
878:

Line 876: , p6_a33 out nocopy JTF_NUMBER_TABLE

872: , p6_a29 out nocopy JTF_NUMBER_TABLE
873: , p6_a30 out nocopy JTF_DATE_TABLE
874: , p6_a31 out nocopy JTF_NUMBER_TABLE
875: , p6_a32 out nocopy JTF_DATE_TABLE
876: , p6_a33 out nocopy JTF_NUMBER_TABLE
877: )
878:
879: as
880: ddp_srv_tbl okl_srv_pvt.okl_srv_tbl;

Line 1089: , p5_a0 JTF_NUMBER_TABLE

1085: , p_init_msg_list VARCHAR2
1086: , x_return_status out nocopy VARCHAR2
1087: , x_msg_count out nocopy NUMBER
1088: , x_msg_data out nocopy VARCHAR2
1089: , p5_a0 JTF_NUMBER_TABLE
1090: , p5_a1 JTF_NUMBER_TABLE
1091: , p5_a2 JTF_VARCHAR2_TABLE_100
1092: , p5_a3 JTF_NUMBER_TABLE
1093: , p5_a4 JTF_DATE_TABLE

Line 1090: , p5_a1 JTF_NUMBER_TABLE

1086: , x_return_status out nocopy VARCHAR2
1087: , x_msg_count out nocopy NUMBER
1088: , x_msg_data out nocopy VARCHAR2
1089: , p5_a0 JTF_NUMBER_TABLE
1090: , p5_a1 JTF_NUMBER_TABLE
1091: , p5_a2 JTF_VARCHAR2_TABLE_100
1092: , p5_a3 JTF_NUMBER_TABLE
1093: , p5_a4 JTF_DATE_TABLE
1094: , p5_a5 JTF_DATE_TABLE

Line 1092: , p5_a3 JTF_NUMBER_TABLE

1088: , x_msg_data out nocopy VARCHAR2
1089: , p5_a0 JTF_NUMBER_TABLE
1090: , p5_a1 JTF_NUMBER_TABLE
1091: , p5_a2 JTF_VARCHAR2_TABLE_100
1092: , p5_a3 JTF_NUMBER_TABLE
1093: , p5_a4 JTF_DATE_TABLE
1094: , p5_a5 JTF_DATE_TABLE
1095: , p5_a6 JTF_VARCHAR2_TABLE_100
1096: , p5_a7 JTF_NUMBER_TABLE

Line 1096: , p5_a7 JTF_NUMBER_TABLE

1092: , p5_a3 JTF_NUMBER_TABLE
1093: , p5_a4 JTF_DATE_TABLE
1094: , p5_a5 JTF_DATE_TABLE
1095: , p5_a6 JTF_VARCHAR2_TABLE_100
1096: , p5_a7 JTF_NUMBER_TABLE
1097: , p5_a8 JTF_NUMBER_TABLE
1098: , p5_a9 JTF_NUMBER_TABLE
1099: , p5_a10 JTF_VARCHAR2_TABLE_100
1100: , p5_a11 JTF_NUMBER_TABLE

Line 1097: , p5_a8 JTF_NUMBER_TABLE

1093: , p5_a4 JTF_DATE_TABLE
1094: , p5_a5 JTF_DATE_TABLE
1095: , p5_a6 JTF_VARCHAR2_TABLE_100
1096: , p5_a7 JTF_NUMBER_TABLE
1097: , p5_a8 JTF_NUMBER_TABLE
1098: , p5_a9 JTF_NUMBER_TABLE
1099: , p5_a10 JTF_VARCHAR2_TABLE_100
1100: , p5_a11 JTF_NUMBER_TABLE
1101: , p5_a12 JTF_NUMBER_TABLE

Line 1098: , p5_a9 JTF_NUMBER_TABLE

1094: , p5_a5 JTF_DATE_TABLE
1095: , p5_a6 JTF_VARCHAR2_TABLE_100
1096: , p5_a7 JTF_NUMBER_TABLE
1097: , p5_a8 JTF_NUMBER_TABLE
1098: , p5_a9 JTF_NUMBER_TABLE
1099: , p5_a10 JTF_VARCHAR2_TABLE_100
1100: , p5_a11 JTF_NUMBER_TABLE
1101: , p5_a12 JTF_NUMBER_TABLE
1102: , p5_a13 JTF_VARCHAR2_TABLE_100

Line 1100: , p5_a11 JTF_NUMBER_TABLE

1096: , p5_a7 JTF_NUMBER_TABLE
1097: , p5_a8 JTF_NUMBER_TABLE
1098: , p5_a9 JTF_NUMBER_TABLE
1099: , p5_a10 JTF_VARCHAR2_TABLE_100
1100: , p5_a11 JTF_NUMBER_TABLE
1101: , p5_a12 JTF_NUMBER_TABLE
1102: , p5_a13 JTF_VARCHAR2_TABLE_100
1103: , p5_a14 JTF_VARCHAR2_TABLE_500
1104: , p5_a15 JTF_VARCHAR2_TABLE_500

Line 1101: , p5_a12 JTF_NUMBER_TABLE

1097: , p5_a8 JTF_NUMBER_TABLE
1098: , p5_a9 JTF_NUMBER_TABLE
1099: , p5_a10 JTF_VARCHAR2_TABLE_100
1100: , p5_a11 JTF_NUMBER_TABLE
1101: , p5_a12 JTF_NUMBER_TABLE
1102: , p5_a13 JTF_VARCHAR2_TABLE_100
1103: , p5_a14 JTF_VARCHAR2_TABLE_500
1104: , p5_a15 JTF_VARCHAR2_TABLE_500
1105: , p5_a16 JTF_VARCHAR2_TABLE_500

Line 1118: , p5_a29 JTF_NUMBER_TABLE

1114: , p5_a25 JTF_VARCHAR2_TABLE_500
1115: , p5_a26 JTF_VARCHAR2_TABLE_500
1116: , p5_a27 JTF_VARCHAR2_TABLE_500
1117: , p5_a28 JTF_VARCHAR2_TABLE_500
1118: , p5_a29 JTF_NUMBER_TABLE
1119: , p5_a30 JTF_DATE_TABLE
1120: , p5_a31 JTF_NUMBER_TABLE
1121: , p5_a32 JTF_DATE_TABLE
1122: , p5_a33 JTF_NUMBER_TABLE

Line 1120: , p5_a31 JTF_NUMBER_TABLE

1116: , p5_a27 JTF_VARCHAR2_TABLE_500
1117: , p5_a28 JTF_VARCHAR2_TABLE_500
1118: , p5_a29 JTF_NUMBER_TABLE
1119: , p5_a30 JTF_DATE_TABLE
1120: , p5_a31 JTF_NUMBER_TABLE
1121: , p5_a32 JTF_DATE_TABLE
1122: , p5_a33 JTF_NUMBER_TABLE
1123: )
1124:

Line 1122: , p5_a33 JTF_NUMBER_TABLE

1118: , p5_a29 JTF_NUMBER_TABLE
1119: , p5_a30 JTF_DATE_TABLE
1120: , p5_a31 JTF_NUMBER_TABLE
1121: , p5_a32 JTF_DATE_TABLE
1122: , p5_a33 JTF_NUMBER_TABLE
1123: )
1124:
1125: as
1126: ddp_srv_tbl okl_srv_pvt.okl_srv_tbl;