1: package body okl_lrf_pvt_w as
2: /* $Header: OKLILRFB.pls 120.1 2005/07/05 12:28:54 asawanka noship $ */
3: procedure rosetta_table_copy_in_p28(t out nocopy okl_lrf_pvt.lrfv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
1: package body okl_lrf_pvt_w as
2: /* $Header: OKLILRFB.pls 120.1 2005/07/05 12:28:54 asawanka noship $ */
3: procedure rosetta_table_copy_in_p28(t out nocopy okl_lrf_pvt.lrfv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
1: package body okl_lrf_pvt_w as
2: /* $Header: OKLILRFB.pls 120.1 2005/07/05 12:28:54 asawanka noship $ */
3: procedure rosetta_table_copy_in_p28(t out nocopy okl_lrf_pvt.lrfv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
2: /* $Header: OKLILRFB.pls 120.1 2005/07/05 12:28:54 asawanka noship $ */
3: procedure rosetta_table_copy_in_p28(t out nocopy okl_lrf_pvt.lrfv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
3: procedure rosetta_table_copy_in_p28(t out nocopy okl_lrf_pvt.lrfv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_DATE_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_DATE_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_DATE_TABLE
14: , a11 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_DATE_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_VARCHAR2_TABLE_500
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_DATE_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_VARCHAR2_TABLE_500
17: , a14 JTF_VARCHAR2_TABLE_500
18: , a15 JTF_VARCHAR2_TABLE_500
28: , a25 JTF_VARCHAR2_TABLE_500
29: , a26 JTF_VARCHAR2_TABLE_500
30: , a27 JTF_VARCHAR2_TABLE_500
31: , a28 JTF_VARCHAR2_TABLE_100
32: , a29 JTF_NUMBER_TABLE
33: ) as
34: ddindx binary_integer; indx binary_integer;
35: begin
36: if a0 is not null and a0.count > 0 then
76: end loop;
77: end if;
78: end if;
79: end rosetta_table_copy_in_p28;
80: procedure rosetta_table_copy_out_p28(t okl_lrf_pvt.lrfv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
81: , a1 out nocopy JTF_NUMBER_TABLE
82: , a2 out nocopy JTF_NUMBER_TABLE
83: , a3 out nocopy JTF_NUMBER_TABLE
84: , a4 out nocopy JTF_NUMBER_TABLE
77: end if;
78: end if;
79: end rosetta_table_copy_in_p28;
80: procedure rosetta_table_copy_out_p28(t okl_lrf_pvt.lrfv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
81: , a1 out nocopy JTF_NUMBER_TABLE
82: , a2 out nocopy JTF_NUMBER_TABLE
83: , a3 out nocopy JTF_NUMBER_TABLE
84: , a4 out nocopy JTF_NUMBER_TABLE
85: , a5 out nocopy JTF_NUMBER_TABLE
78: end if;
79: end rosetta_table_copy_in_p28;
80: procedure rosetta_table_copy_out_p28(t okl_lrf_pvt.lrfv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
81: , a1 out nocopy JTF_NUMBER_TABLE
82: , a2 out nocopy JTF_NUMBER_TABLE
83: , a3 out nocopy JTF_NUMBER_TABLE
84: , a4 out nocopy JTF_NUMBER_TABLE
85: , a5 out nocopy JTF_NUMBER_TABLE
86: , a6 out nocopy JTF_NUMBER_TABLE
79: end rosetta_table_copy_in_p28;
80: procedure rosetta_table_copy_out_p28(t okl_lrf_pvt.lrfv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
81: , a1 out nocopy JTF_NUMBER_TABLE
82: , a2 out nocopy JTF_NUMBER_TABLE
83: , a3 out nocopy JTF_NUMBER_TABLE
84: , a4 out nocopy JTF_NUMBER_TABLE
85: , a5 out nocopy JTF_NUMBER_TABLE
86: , a6 out nocopy JTF_NUMBER_TABLE
87: , a7 out nocopy JTF_NUMBER_TABLE
80: procedure rosetta_table_copy_out_p28(t okl_lrf_pvt.lrfv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
81: , a1 out nocopy JTF_NUMBER_TABLE
82: , a2 out nocopy JTF_NUMBER_TABLE
83: , a3 out nocopy JTF_NUMBER_TABLE
84: , a4 out nocopy JTF_NUMBER_TABLE
85: , a5 out nocopy JTF_NUMBER_TABLE
86: , a6 out nocopy JTF_NUMBER_TABLE
87: , a7 out nocopy JTF_NUMBER_TABLE
88: , a8 out nocopy JTF_DATE_TABLE
81: , a1 out nocopy JTF_NUMBER_TABLE
82: , a2 out nocopy JTF_NUMBER_TABLE
83: , a3 out nocopy JTF_NUMBER_TABLE
84: , a4 out nocopy JTF_NUMBER_TABLE
85: , a5 out nocopy JTF_NUMBER_TABLE
86: , a6 out nocopy JTF_NUMBER_TABLE
87: , a7 out nocopy JTF_NUMBER_TABLE
88: , a8 out nocopy JTF_DATE_TABLE
89: , a9 out nocopy JTF_NUMBER_TABLE
82: , a2 out nocopy JTF_NUMBER_TABLE
83: , a3 out nocopy JTF_NUMBER_TABLE
84: , a4 out nocopy JTF_NUMBER_TABLE
85: , a5 out nocopy JTF_NUMBER_TABLE
86: , a6 out nocopy JTF_NUMBER_TABLE
87: , a7 out nocopy JTF_NUMBER_TABLE
88: , a8 out nocopy JTF_DATE_TABLE
89: , a9 out nocopy JTF_NUMBER_TABLE
90: , a10 out nocopy JTF_DATE_TABLE
83: , a3 out nocopy JTF_NUMBER_TABLE
84: , a4 out nocopy JTF_NUMBER_TABLE
85: , a5 out nocopy JTF_NUMBER_TABLE
86: , a6 out nocopy JTF_NUMBER_TABLE
87: , a7 out nocopy JTF_NUMBER_TABLE
88: , a8 out nocopy JTF_DATE_TABLE
89: , a9 out nocopy JTF_NUMBER_TABLE
90: , a10 out nocopy JTF_DATE_TABLE
91: , a11 out nocopy JTF_NUMBER_TABLE
85: , a5 out nocopy JTF_NUMBER_TABLE
86: , a6 out nocopy JTF_NUMBER_TABLE
87: , a7 out nocopy JTF_NUMBER_TABLE
88: , a8 out nocopy JTF_DATE_TABLE
89: , a9 out nocopy JTF_NUMBER_TABLE
90: , a10 out nocopy JTF_DATE_TABLE
91: , a11 out nocopy JTF_NUMBER_TABLE
92: , a12 out nocopy JTF_VARCHAR2_TABLE_100
93: , a13 out nocopy JTF_VARCHAR2_TABLE_500
87: , a7 out nocopy JTF_NUMBER_TABLE
88: , a8 out nocopy JTF_DATE_TABLE
89: , a9 out nocopy JTF_NUMBER_TABLE
90: , a10 out nocopy JTF_DATE_TABLE
91: , a11 out nocopy JTF_NUMBER_TABLE
92: , a12 out nocopy JTF_VARCHAR2_TABLE_100
93: , a13 out nocopy JTF_VARCHAR2_TABLE_500
94: , a14 out nocopy JTF_VARCHAR2_TABLE_500
95: , a15 out nocopy JTF_VARCHAR2_TABLE_500
105: , a25 out nocopy JTF_VARCHAR2_TABLE_500
106: , a26 out nocopy JTF_VARCHAR2_TABLE_500
107: , a27 out nocopy JTF_VARCHAR2_TABLE_500
108: , a28 out nocopy JTF_VARCHAR2_TABLE_100
109: , a29 out nocopy JTF_NUMBER_TABLE
110: ) as
111: ddindx binary_integer; indx binary_integer;
112: begin
113: if t is null or t.count = 0 then
110: ) as
111: ddindx binary_integer; indx binary_integer;
112: begin
113: if t is null or t.count = 0 then
114: a0 := JTF_NUMBER_TABLE();
115: a1 := JTF_NUMBER_TABLE();
116: a2 := JTF_NUMBER_TABLE();
117: a3 := JTF_NUMBER_TABLE();
118: a4 := JTF_NUMBER_TABLE();
111: ddindx binary_integer; indx binary_integer;
112: begin
113: if t is null or t.count = 0 then
114: a0 := JTF_NUMBER_TABLE();
115: a1 := JTF_NUMBER_TABLE();
116: a2 := JTF_NUMBER_TABLE();
117: a3 := JTF_NUMBER_TABLE();
118: a4 := JTF_NUMBER_TABLE();
119: a5 := JTF_NUMBER_TABLE();
112: begin
113: if t is null or t.count = 0 then
114: a0 := JTF_NUMBER_TABLE();
115: a1 := JTF_NUMBER_TABLE();
116: a2 := JTF_NUMBER_TABLE();
117: a3 := JTF_NUMBER_TABLE();
118: a4 := JTF_NUMBER_TABLE();
119: a5 := JTF_NUMBER_TABLE();
120: a6 := JTF_NUMBER_TABLE();
113: if t is null or t.count = 0 then
114: a0 := JTF_NUMBER_TABLE();
115: a1 := JTF_NUMBER_TABLE();
116: a2 := JTF_NUMBER_TABLE();
117: a3 := JTF_NUMBER_TABLE();
118: a4 := JTF_NUMBER_TABLE();
119: a5 := JTF_NUMBER_TABLE();
120: a6 := JTF_NUMBER_TABLE();
121: a7 := JTF_NUMBER_TABLE();
114: a0 := JTF_NUMBER_TABLE();
115: a1 := JTF_NUMBER_TABLE();
116: a2 := JTF_NUMBER_TABLE();
117: a3 := JTF_NUMBER_TABLE();
118: a4 := JTF_NUMBER_TABLE();
119: a5 := JTF_NUMBER_TABLE();
120: a6 := JTF_NUMBER_TABLE();
121: a7 := JTF_NUMBER_TABLE();
122: a8 := JTF_DATE_TABLE();
115: a1 := JTF_NUMBER_TABLE();
116: a2 := JTF_NUMBER_TABLE();
117: a3 := JTF_NUMBER_TABLE();
118: a4 := JTF_NUMBER_TABLE();
119: a5 := JTF_NUMBER_TABLE();
120: a6 := JTF_NUMBER_TABLE();
121: a7 := JTF_NUMBER_TABLE();
122: a8 := JTF_DATE_TABLE();
123: a9 := JTF_NUMBER_TABLE();
116: a2 := JTF_NUMBER_TABLE();
117: a3 := JTF_NUMBER_TABLE();
118: a4 := JTF_NUMBER_TABLE();
119: a5 := JTF_NUMBER_TABLE();
120: a6 := JTF_NUMBER_TABLE();
121: a7 := JTF_NUMBER_TABLE();
122: a8 := JTF_DATE_TABLE();
123: a9 := JTF_NUMBER_TABLE();
124: a10 := JTF_DATE_TABLE();
117: a3 := JTF_NUMBER_TABLE();
118: a4 := JTF_NUMBER_TABLE();
119: a5 := JTF_NUMBER_TABLE();
120: a6 := JTF_NUMBER_TABLE();
121: a7 := JTF_NUMBER_TABLE();
122: a8 := JTF_DATE_TABLE();
123: a9 := JTF_NUMBER_TABLE();
124: a10 := JTF_DATE_TABLE();
125: a11 := JTF_NUMBER_TABLE();
119: a5 := JTF_NUMBER_TABLE();
120: a6 := JTF_NUMBER_TABLE();
121: a7 := JTF_NUMBER_TABLE();
122: a8 := JTF_DATE_TABLE();
123: a9 := JTF_NUMBER_TABLE();
124: a10 := JTF_DATE_TABLE();
125: a11 := JTF_NUMBER_TABLE();
126: a12 := JTF_VARCHAR2_TABLE_100();
127: a13 := JTF_VARCHAR2_TABLE_500();
121: a7 := JTF_NUMBER_TABLE();
122: a8 := JTF_DATE_TABLE();
123: a9 := JTF_NUMBER_TABLE();
124: a10 := JTF_DATE_TABLE();
125: a11 := JTF_NUMBER_TABLE();
126: a12 := JTF_VARCHAR2_TABLE_100();
127: a13 := JTF_VARCHAR2_TABLE_500();
128: a14 := JTF_VARCHAR2_TABLE_500();
129: a15 := JTF_VARCHAR2_TABLE_500();
139: a25 := JTF_VARCHAR2_TABLE_500();
140: a26 := JTF_VARCHAR2_TABLE_500();
141: a27 := JTF_VARCHAR2_TABLE_500();
142: a28 := JTF_VARCHAR2_TABLE_100();
143: a29 := JTF_NUMBER_TABLE();
144: else
145: a0 := JTF_NUMBER_TABLE();
146: a1 := JTF_NUMBER_TABLE();
147: a2 := JTF_NUMBER_TABLE();
141: a27 := JTF_VARCHAR2_TABLE_500();
142: a28 := JTF_VARCHAR2_TABLE_100();
143: a29 := JTF_NUMBER_TABLE();
144: else
145: a0 := JTF_NUMBER_TABLE();
146: a1 := JTF_NUMBER_TABLE();
147: a2 := JTF_NUMBER_TABLE();
148: a3 := JTF_NUMBER_TABLE();
149: a4 := JTF_NUMBER_TABLE();
142: a28 := JTF_VARCHAR2_TABLE_100();
143: a29 := JTF_NUMBER_TABLE();
144: else
145: a0 := JTF_NUMBER_TABLE();
146: a1 := JTF_NUMBER_TABLE();
147: a2 := JTF_NUMBER_TABLE();
148: a3 := JTF_NUMBER_TABLE();
149: a4 := JTF_NUMBER_TABLE();
150: a5 := JTF_NUMBER_TABLE();
143: a29 := JTF_NUMBER_TABLE();
144: else
145: a0 := JTF_NUMBER_TABLE();
146: a1 := JTF_NUMBER_TABLE();
147: a2 := JTF_NUMBER_TABLE();
148: a3 := JTF_NUMBER_TABLE();
149: a4 := JTF_NUMBER_TABLE();
150: a5 := JTF_NUMBER_TABLE();
151: a6 := JTF_NUMBER_TABLE();
144: else
145: a0 := JTF_NUMBER_TABLE();
146: a1 := JTF_NUMBER_TABLE();
147: a2 := JTF_NUMBER_TABLE();
148: a3 := JTF_NUMBER_TABLE();
149: a4 := JTF_NUMBER_TABLE();
150: a5 := JTF_NUMBER_TABLE();
151: a6 := JTF_NUMBER_TABLE();
152: a7 := JTF_NUMBER_TABLE();
145: a0 := JTF_NUMBER_TABLE();
146: a1 := JTF_NUMBER_TABLE();
147: a2 := JTF_NUMBER_TABLE();
148: a3 := JTF_NUMBER_TABLE();
149: a4 := JTF_NUMBER_TABLE();
150: a5 := JTF_NUMBER_TABLE();
151: a6 := JTF_NUMBER_TABLE();
152: a7 := JTF_NUMBER_TABLE();
153: a8 := JTF_DATE_TABLE();
146: a1 := JTF_NUMBER_TABLE();
147: a2 := JTF_NUMBER_TABLE();
148: a3 := JTF_NUMBER_TABLE();
149: a4 := JTF_NUMBER_TABLE();
150: a5 := JTF_NUMBER_TABLE();
151: a6 := JTF_NUMBER_TABLE();
152: a7 := JTF_NUMBER_TABLE();
153: a8 := JTF_DATE_TABLE();
154: a9 := JTF_NUMBER_TABLE();
147: a2 := JTF_NUMBER_TABLE();
148: a3 := JTF_NUMBER_TABLE();
149: a4 := JTF_NUMBER_TABLE();
150: a5 := JTF_NUMBER_TABLE();
151: a6 := JTF_NUMBER_TABLE();
152: a7 := JTF_NUMBER_TABLE();
153: a8 := JTF_DATE_TABLE();
154: a9 := JTF_NUMBER_TABLE();
155: a10 := JTF_DATE_TABLE();
148: a3 := JTF_NUMBER_TABLE();
149: a4 := JTF_NUMBER_TABLE();
150: a5 := JTF_NUMBER_TABLE();
151: a6 := JTF_NUMBER_TABLE();
152: a7 := JTF_NUMBER_TABLE();
153: a8 := JTF_DATE_TABLE();
154: a9 := JTF_NUMBER_TABLE();
155: a10 := JTF_DATE_TABLE();
156: a11 := JTF_NUMBER_TABLE();
150: a5 := JTF_NUMBER_TABLE();
151: a6 := JTF_NUMBER_TABLE();
152: a7 := JTF_NUMBER_TABLE();
153: a8 := JTF_DATE_TABLE();
154: a9 := JTF_NUMBER_TABLE();
155: a10 := JTF_DATE_TABLE();
156: a11 := JTF_NUMBER_TABLE();
157: a12 := JTF_VARCHAR2_TABLE_100();
158: a13 := JTF_VARCHAR2_TABLE_500();
152: a7 := JTF_NUMBER_TABLE();
153: a8 := JTF_DATE_TABLE();
154: a9 := JTF_NUMBER_TABLE();
155: a10 := JTF_DATE_TABLE();
156: a11 := JTF_NUMBER_TABLE();
157: a12 := JTF_VARCHAR2_TABLE_100();
158: a13 := JTF_VARCHAR2_TABLE_500();
159: a14 := JTF_VARCHAR2_TABLE_500();
160: a15 := JTF_VARCHAR2_TABLE_500();
170: a25 := JTF_VARCHAR2_TABLE_500();
171: a26 := JTF_VARCHAR2_TABLE_500();
172: a27 := JTF_VARCHAR2_TABLE_500();
173: a28 := JTF_VARCHAR2_TABLE_100();
174: a29 := JTF_NUMBER_TABLE();
175: if t.count > 0 then
176: a0.extend(t.count);
177: a1.extend(t.count);
178: a2.extend(t.count);
245: end if;
246: end if;
247: end rosetta_table_copy_out_p28;
248:
249: procedure rosetta_table_copy_in_p31(t out nocopy okl_lrf_pvt.lrf_tbl_type, a0 JTF_NUMBER_TABLE
250: , a1 JTF_NUMBER_TABLE
251: , a2 JTF_NUMBER_TABLE
252: , a3 JTF_NUMBER_TABLE
253: , a4 JTF_NUMBER_TABLE
246: end if;
247: end rosetta_table_copy_out_p28;
248:
249: procedure rosetta_table_copy_in_p31(t out nocopy okl_lrf_pvt.lrf_tbl_type, a0 JTF_NUMBER_TABLE
250: , a1 JTF_NUMBER_TABLE
251: , a2 JTF_NUMBER_TABLE
252: , a3 JTF_NUMBER_TABLE
253: , a4 JTF_NUMBER_TABLE
254: , a5 JTF_NUMBER_TABLE
247: end rosetta_table_copy_out_p28;
248:
249: procedure rosetta_table_copy_in_p31(t out nocopy okl_lrf_pvt.lrf_tbl_type, a0 JTF_NUMBER_TABLE
250: , a1 JTF_NUMBER_TABLE
251: , a2 JTF_NUMBER_TABLE
252: , a3 JTF_NUMBER_TABLE
253: , a4 JTF_NUMBER_TABLE
254: , a5 JTF_NUMBER_TABLE
255: , a6 JTF_NUMBER_TABLE
248:
249: procedure rosetta_table_copy_in_p31(t out nocopy okl_lrf_pvt.lrf_tbl_type, a0 JTF_NUMBER_TABLE
250: , a1 JTF_NUMBER_TABLE
251: , a2 JTF_NUMBER_TABLE
252: , a3 JTF_NUMBER_TABLE
253: , a4 JTF_NUMBER_TABLE
254: , a5 JTF_NUMBER_TABLE
255: , a6 JTF_NUMBER_TABLE
256: , a7 JTF_NUMBER_TABLE
249: procedure rosetta_table_copy_in_p31(t out nocopy okl_lrf_pvt.lrf_tbl_type, a0 JTF_NUMBER_TABLE
250: , a1 JTF_NUMBER_TABLE
251: , a2 JTF_NUMBER_TABLE
252: , a3 JTF_NUMBER_TABLE
253: , a4 JTF_NUMBER_TABLE
254: , a5 JTF_NUMBER_TABLE
255: , a6 JTF_NUMBER_TABLE
256: , a7 JTF_NUMBER_TABLE
257: , a8 JTF_DATE_TABLE
250: , a1 JTF_NUMBER_TABLE
251: , a2 JTF_NUMBER_TABLE
252: , a3 JTF_NUMBER_TABLE
253: , a4 JTF_NUMBER_TABLE
254: , a5 JTF_NUMBER_TABLE
255: , a6 JTF_NUMBER_TABLE
256: , a7 JTF_NUMBER_TABLE
257: , a8 JTF_DATE_TABLE
258: , a9 JTF_NUMBER_TABLE
251: , a2 JTF_NUMBER_TABLE
252: , a3 JTF_NUMBER_TABLE
253: , a4 JTF_NUMBER_TABLE
254: , a5 JTF_NUMBER_TABLE
255: , a6 JTF_NUMBER_TABLE
256: , a7 JTF_NUMBER_TABLE
257: , a8 JTF_DATE_TABLE
258: , a9 JTF_NUMBER_TABLE
259: , a10 JTF_DATE_TABLE
252: , a3 JTF_NUMBER_TABLE
253: , a4 JTF_NUMBER_TABLE
254: , a5 JTF_NUMBER_TABLE
255: , a6 JTF_NUMBER_TABLE
256: , a7 JTF_NUMBER_TABLE
257: , a8 JTF_DATE_TABLE
258: , a9 JTF_NUMBER_TABLE
259: , a10 JTF_DATE_TABLE
260: , a11 JTF_NUMBER_TABLE
254: , a5 JTF_NUMBER_TABLE
255: , a6 JTF_NUMBER_TABLE
256: , a7 JTF_NUMBER_TABLE
257: , a8 JTF_DATE_TABLE
258: , a9 JTF_NUMBER_TABLE
259: , a10 JTF_DATE_TABLE
260: , a11 JTF_NUMBER_TABLE
261: , a12 JTF_VARCHAR2_TABLE_100
262: , a13 JTF_VARCHAR2_TABLE_500
256: , a7 JTF_NUMBER_TABLE
257: , a8 JTF_DATE_TABLE
258: , a9 JTF_NUMBER_TABLE
259: , a10 JTF_DATE_TABLE
260: , a11 JTF_NUMBER_TABLE
261: , a12 JTF_VARCHAR2_TABLE_100
262: , a13 JTF_VARCHAR2_TABLE_500
263: , a14 JTF_VARCHAR2_TABLE_500
264: , a15 JTF_VARCHAR2_TABLE_500
274: , a25 JTF_VARCHAR2_TABLE_500
275: , a26 JTF_VARCHAR2_TABLE_500
276: , a27 JTF_VARCHAR2_TABLE_500
277: , a28 JTF_VARCHAR2_TABLE_100
278: , a29 JTF_NUMBER_TABLE
279: ) as
280: ddindx binary_integer; indx binary_integer;
281: begin
282: if a0 is not null and a0.count > 0 then
322: end loop;
323: end if;
324: end if;
325: end rosetta_table_copy_in_p31;
326: procedure rosetta_table_copy_out_p31(t okl_lrf_pvt.lrf_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
327: , a1 out nocopy JTF_NUMBER_TABLE
328: , a2 out nocopy JTF_NUMBER_TABLE
329: , a3 out nocopy JTF_NUMBER_TABLE
330: , a4 out nocopy JTF_NUMBER_TABLE
323: end if;
324: end if;
325: end rosetta_table_copy_in_p31;
326: procedure rosetta_table_copy_out_p31(t okl_lrf_pvt.lrf_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
327: , a1 out nocopy JTF_NUMBER_TABLE
328: , a2 out nocopy JTF_NUMBER_TABLE
329: , a3 out nocopy JTF_NUMBER_TABLE
330: , a4 out nocopy JTF_NUMBER_TABLE
331: , a5 out nocopy JTF_NUMBER_TABLE
324: end if;
325: end rosetta_table_copy_in_p31;
326: procedure rosetta_table_copy_out_p31(t okl_lrf_pvt.lrf_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
327: , a1 out nocopy JTF_NUMBER_TABLE
328: , a2 out nocopy JTF_NUMBER_TABLE
329: , a3 out nocopy JTF_NUMBER_TABLE
330: , a4 out nocopy JTF_NUMBER_TABLE
331: , a5 out nocopy JTF_NUMBER_TABLE
332: , a6 out nocopy JTF_NUMBER_TABLE
325: end rosetta_table_copy_in_p31;
326: procedure rosetta_table_copy_out_p31(t okl_lrf_pvt.lrf_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
327: , a1 out nocopy JTF_NUMBER_TABLE
328: , a2 out nocopy JTF_NUMBER_TABLE
329: , a3 out nocopy JTF_NUMBER_TABLE
330: , a4 out nocopy JTF_NUMBER_TABLE
331: , a5 out nocopy JTF_NUMBER_TABLE
332: , a6 out nocopy JTF_NUMBER_TABLE
333: , a7 out nocopy JTF_NUMBER_TABLE
326: procedure rosetta_table_copy_out_p31(t okl_lrf_pvt.lrf_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
327: , a1 out nocopy JTF_NUMBER_TABLE
328: , a2 out nocopy JTF_NUMBER_TABLE
329: , a3 out nocopy JTF_NUMBER_TABLE
330: , a4 out nocopy JTF_NUMBER_TABLE
331: , a5 out nocopy JTF_NUMBER_TABLE
332: , a6 out nocopy JTF_NUMBER_TABLE
333: , a7 out nocopy JTF_NUMBER_TABLE
334: , a8 out nocopy JTF_DATE_TABLE
327: , a1 out nocopy JTF_NUMBER_TABLE
328: , a2 out nocopy JTF_NUMBER_TABLE
329: , a3 out nocopy JTF_NUMBER_TABLE
330: , a4 out nocopy JTF_NUMBER_TABLE
331: , a5 out nocopy JTF_NUMBER_TABLE
332: , a6 out nocopy JTF_NUMBER_TABLE
333: , a7 out nocopy JTF_NUMBER_TABLE
334: , a8 out nocopy JTF_DATE_TABLE
335: , a9 out nocopy JTF_NUMBER_TABLE
328: , a2 out nocopy JTF_NUMBER_TABLE
329: , a3 out nocopy JTF_NUMBER_TABLE
330: , a4 out nocopy JTF_NUMBER_TABLE
331: , a5 out nocopy JTF_NUMBER_TABLE
332: , a6 out nocopy JTF_NUMBER_TABLE
333: , a7 out nocopy JTF_NUMBER_TABLE
334: , a8 out nocopy JTF_DATE_TABLE
335: , a9 out nocopy JTF_NUMBER_TABLE
336: , a10 out nocopy JTF_DATE_TABLE
329: , a3 out nocopy JTF_NUMBER_TABLE
330: , a4 out nocopy JTF_NUMBER_TABLE
331: , a5 out nocopy JTF_NUMBER_TABLE
332: , a6 out nocopy JTF_NUMBER_TABLE
333: , a7 out nocopy JTF_NUMBER_TABLE
334: , a8 out nocopy JTF_DATE_TABLE
335: , a9 out nocopy JTF_NUMBER_TABLE
336: , a10 out nocopy JTF_DATE_TABLE
337: , a11 out nocopy JTF_NUMBER_TABLE
331: , a5 out nocopy JTF_NUMBER_TABLE
332: , a6 out nocopy JTF_NUMBER_TABLE
333: , a7 out nocopy JTF_NUMBER_TABLE
334: , a8 out nocopy JTF_DATE_TABLE
335: , a9 out nocopy JTF_NUMBER_TABLE
336: , a10 out nocopy JTF_DATE_TABLE
337: , a11 out nocopy JTF_NUMBER_TABLE
338: , a12 out nocopy JTF_VARCHAR2_TABLE_100
339: , a13 out nocopy JTF_VARCHAR2_TABLE_500
333: , a7 out nocopy JTF_NUMBER_TABLE
334: , a8 out nocopy JTF_DATE_TABLE
335: , a9 out nocopy JTF_NUMBER_TABLE
336: , a10 out nocopy JTF_DATE_TABLE
337: , a11 out nocopy JTF_NUMBER_TABLE
338: , a12 out nocopy JTF_VARCHAR2_TABLE_100
339: , a13 out nocopy JTF_VARCHAR2_TABLE_500
340: , a14 out nocopy JTF_VARCHAR2_TABLE_500
341: , a15 out nocopy JTF_VARCHAR2_TABLE_500
351: , a25 out nocopy JTF_VARCHAR2_TABLE_500
352: , a26 out nocopy JTF_VARCHAR2_TABLE_500
353: , a27 out nocopy JTF_VARCHAR2_TABLE_500
354: , a28 out nocopy JTF_VARCHAR2_TABLE_100
355: , a29 out nocopy JTF_NUMBER_TABLE
356: ) as
357: ddindx binary_integer; indx binary_integer;
358: begin
359: if t is null or t.count = 0 then
356: ) as
357: ddindx binary_integer; indx binary_integer;
358: begin
359: if t is null or t.count = 0 then
360: a0 := JTF_NUMBER_TABLE();
361: a1 := JTF_NUMBER_TABLE();
362: a2 := JTF_NUMBER_TABLE();
363: a3 := JTF_NUMBER_TABLE();
364: a4 := JTF_NUMBER_TABLE();
357: ddindx binary_integer; indx binary_integer;
358: begin
359: if t is null or t.count = 0 then
360: a0 := JTF_NUMBER_TABLE();
361: a1 := JTF_NUMBER_TABLE();
362: a2 := JTF_NUMBER_TABLE();
363: a3 := JTF_NUMBER_TABLE();
364: a4 := JTF_NUMBER_TABLE();
365: a5 := JTF_NUMBER_TABLE();
358: begin
359: if t is null or t.count = 0 then
360: a0 := JTF_NUMBER_TABLE();
361: a1 := JTF_NUMBER_TABLE();
362: a2 := JTF_NUMBER_TABLE();
363: a3 := JTF_NUMBER_TABLE();
364: a4 := JTF_NUMBER_TABLE();
365: a5 := JTF_NUMBER_TABLE();
366: a6 := JTF_NUMBER_TABLE();
359: if t is null or t.count = 0 then
360: a0 := JTF_NUMBER_TABLE();
361: a1 := JTF_NUMBER_TABLE();
362: a2 := JTF_NUMBER_TABLE();
363: a3 := JTF_NUMBER_TABLE();
364: a4 := JTF_NUMBER_TABLE();
365: a5 := JTF_NUMBER_TABLE();
366: a6 := JTF_NUMBER_TABLE();
367: a7 := JTF_NUMBER_TABLE();
360: a0 := JTF_NUMBER_TABLE();
361: a1 := JTF_NUMBER_TABLE();
362: a2 := JTF_NUMBER_TABLE();
363: a3 := JTF_NUMBER_TABLE();
364: a4 := JTF_NUMBER_TABLE();
365: a5 := JTF_NUMBER_TABLE();
366: a6 := JTF_NUMBER_TABLE();
367: a7 := JTF_NUMBER_TABLE();
368: a8 := JTF_DATE_TABLE();
361: a1 := JTF_NUMBER_TABLE();
362: a2 := JTF_NUMBER_TABLE();
363: a3 := JTF_NUMBER_TABLE();
364: a4 := JTF_NUMBER_TABLE();
365: a5 := JTF_NUMBER_TABLE();
366: a6 := JTF_NUMBER_TABLE();
367: a7 := JTF_NUMBER_TABLE();
368: a8 := JTF_DATE_TABLE();
369: a9 := JTF_NUMBER_TABLE();
362: a2 := JTF_NUMBER_TABLE();
363: a3 := JTF_NUMBER_TABLE();
364: a4 := JTF_NUMBER_TABLE();
365: a5 := JTF_NUMBER_TABLE();
366: a6 := JTF_NUMBER_TABLE();
367: a7 := JTF_NUMBER_TABLE();
368: a8 := JTF_DATE_TABLE();
369: a9 := JTF_NUMBER_TABLE();
370: a10 := JTF_DATE_TABLE();
363: a3 := JTF_NUMBER_TABLE();
364: a4 := JTF_NUMBER_TABLE();
365: a5 := JTF_NUMBER_TABLE();
366: a6 := JTF_NUMBER_TABLE();
367: a7 := JTF_NUMBER_TABLE();
368: a8 := JTF_DATE_TABLE();
369: a9 := JTF_NUMBER_TABLE();
370: a10 := JTF_DATE_TABLE();
371: a11 := JTF_NUMBER_TABLE();
365: a5 := JTF_NUMBER_TABLE();
366: a6 := JTF_NUMBER_TABLE();
367: a7 := JTF_NUMBER_TABLE();
368: a8 := JTF_DATE_TABLE();
369: a9 := JTF_NUMBER_TABLE();
370: a10 := JTF_DATE_TABLE();
371: a11 := JTF_NUMBER_TABLE();
372: a12 := JTF_VARCHAR2_TABLE_100();
373: a13 := JTF_VARCHAR2_TABLE_500();
367: a7 := JTF_NUMBER_TABLE();
368: a8 := JTF_DATE_TABLE();
369: a9 := JTF_NUMBER_TABLE();
370: a10 := JTF_DATE_TABLE();
371: a11 := JTF_NUMBER_TABLE();
372: a12 := JTF_VARCHAR2_TABLE_100();
373: a13 := JTF_VARCHAR2_TABLE_500();
374: a14 := JTF_VARCHAR2_TABLE_500();
375: a15 := JTF_VARCHAR2_TABLE_500();
385: a25 := JTF_VARCHAR2_TABLE_500();
386: a26 := JTF_VARCHAR2_TABLE_500();
387: a27 := JTF_VARCHAR2_TABLE_500();
388: a28 := JTF_VARCHAR2_TABLE_100();
389: a29 := JTF_NUMBER_TABLE();
390: else
391: a0 := JTF_NUMBER_TABLE();
392: a1 := JTF_NUMBER_TABLE();
393: a2 := JTF_NUMBER_TABLE();
387: a27 := JTF_VARCHAR2_TABLE_500();
388: a28 := JTF_VARCHAR2_TABLE_100();
389: a29 := JTF_NUMBER_TABLE();
390: else
391: a0 := JTF_NUMBER_TABLE();
392: a1 := JTF_NUMBER_TABLE();
393: a2 := JTF_NUMBER_TABLE();
394: a3 := JTF_NUMBER_TABLE();
395: a4 := JTF_NUMBER_TABLE();
388: a28 := JTF_VARCHAR2_TABLE_100();
389: a29 := JTF_NUMBER_TABLE();
390: else
391: a0 := JTF_NUMBER_TABLE();
392: a1 := JTF_NUMBER_TABLE();
393: a2 := JTF_NUMBER_TABLE();
394: a3 := JTF_NUMBER_TABLE();
395: a4 := JTF_NUMBER_TABLE();
396: a5 := JTF_NUMBER_TABLE();
389: a29 := JTF_NUMBER_TABLE();
390: else
391: a0 := JTF_NUMBER_TABLE();
392: a1 := JTF_NUMBER_TABLE();
393: a2 := JTF_NUMBER_TABLE();
394: a3 := JTF_NUMBER_TABLE();
395: a4 := JTF_NUMBER_TABLE();
396: a5 := JTF_NUMBER_TABLE();
397: a6 := JTF_NUMBER_TABLE();
390: else
391: a0 := JTF_NUMBER_TABLE();
392: a1 := JTF_NUMBER_TABLE();
393: a2 := JTF_NUMBER_TABLE();
394: a3 := JTF_NUMBER_TABLE();
395: a4 := JTF_NUMBER_TABLE();
396: a5 := JTF_NUMBER_TABLE();
397: a6 := JTF_NUMBER_TABLE();
398: a7 := JTF_NUMBER_TABLE();
391: a0 := JTF_NUMBER_TABLE();
392: a1 := JTF_NUMBER_TABLE();
393: a2 := JTF_NUMBER_TABLE();
394: a3 := JTF_NUMBER_TABLE();
395: a4 := JTF_NUMBER_TABLE();
396: a5 := JTF_NUMBER_TABLE();
397: a6 := JTF_NUMBER_TABLE();
398: a7 := JTF_NUMBER_TABLE();
399: a8 := JTF_DATE_TABLE();
392: a1 := JTF_NUMBER_TABLE();
393: a2 := JTF_NUMBER_TABLE();
394: a3 := JTF_NUMBER_TABLE();
395: a4 := JTF_NUMBER_TABLE();
396: a5 := JTF_NUMBER_TABLE();
397: a6 := JTF_NUMBER_TABLE();
398: a7 := JTF_NUMBER_TABLE();
399: a8 := JTF_DATE_TABLE();
400: a9 := JTF_NUMBER_TABLE();
393: a2 := JTF_NUMBER_TABLE();
394: a3 := JTF_NUMBER_TABLE();
395: a4 := JTF_NUMBER_TABLE();
396: a5 := JTF_NUMBER_TABLE();
397: a6 := JTF_NUMBER_TABLE();
398: a7 := JTF_NUMBER_TABLE();
399: a8 := JTF_DATE_TABLE();
400: a9 := JTF_NUMBER_TABLE();
401: a10 := JTF_DATE_TABLE();
394: a3 := JTF_NUMBER_TABLE();
395: a4 := JTF_NUMBER_TABLE();
396: a5 := JTF_NUMBER_TABLE();
397: a6 := JTF_NUMBER_TABLE();
398: a7 := JTF_NUMBER_TABLE();
399: a8 := JTF_DATE_TABLE();
400: a9 := JTF_NUMBER_TABLE();
401: a10 := JTF_DATE_TABLE();
402: a11 := JTF_NUMBER_TABLE();
396: a5 := JTF_NUMBER_TABLE();
397: a6 := JTF_NUMBER_TABLE();
398: a7 := JTF_NUMBER_TABLE();
399: a8 := JTF_DATE_TABLE();
400: a9 := JTF_NUMBER_TABLE();
401: a10 := JTF_DATE_TABLE();
402: a11 := JTF_NUMBER_TABLE();
403: a12 := JTF_VARCHAR2_TABLE_100();
404: a13 := JTF_VARCHAR2_TABLE_500();
398: a7 := JTF_NUMBER_TABLE();
399: a8 := JTF_DATE_TABLE();
400: a9 := JTF_NUMBER_TABLE();
401: a10 := JTF_DATE_TABLE();
402: a11 := JTF_NUMBER_TABLE();
403: a12 := JTF_VARCHAR2_TABLE_100();
404: a13 := JTF_VARCHAR2_TABLE_500();
405: a14 := JTF_VARCHAR2_TABLE_500();
406: a15 := JTF_VARCHAR2_TABLE_500();
416: a25 := JTF_VARCHAR2_TABLE_500();
417: a26 := JTF_VARCHAR2_TABLE_500();
418: a27 := JTF_VARCHAR2_TABLE_500();
419: a28 := JTF_VARCHAR2_TABLE_100();
420: a29 := JTF_NUMBER_TABLE();
421: if t.count > 0 then
422: a0.extend(t.count);
423: a1.extend(t.count);
424: a2.extend(t.count);
655: , p_init_msg_list VARCHAR2
656: , x_return_status out nocopy VARCHAR2
657: , x_msg_count out nocopy NUMBER
658: , x_msg_data out nocopy VARCHAR2
659: , p5_a0 JTF_NUMBER_TABLE
660: , p5_a1 JTF_NUMBER_TABLE
661: , p5_a2 JTF_NUMBER_TABLE
662: , p5_a3 JTF_NUMBER_TABLE
663: , p5_a4 JTF_NUMBER_TABLE
656: , x_return_status out nocopy VARCHAR2
657: , x_msg_count out nocopy NUMBER
658: , x_msg_data out nocopy VARCHAR2
659: , p5_a0 JTF_NUMBER_TABLE
660: , p5_a1 JTF_NUMBER_TABLE
661: , p5_a2 JTF_NUMBER_TABLE
662: , p5_a3 JTF_NUMBER_TABLE
663: , p5_a4 JTF_NUMBER_TABLE
664: , p5_a5 JTF_NUMBER_TABLE
657: , x_msg_count out nocopy NUMBER
658: , x_msg_data out nocopy VARCHAR2
659: , p5_a0 JTF_NUMBER_TABLE
660: , p5_a1 JTF_NUMBER_TABLE
661: , p5_a2 JTF_NUMBER_TABLE
662: , p5_a3 JTF_NUMBER_TABLE
663: , p5_a4 JTF_NUMBER_TABLE
664: , p5_a5 JTF_NUMBER_TABLE
665: , p5_a6 JTF_NUMBER_TABLE
658: , x_msg_data out nocopy VARCHAR2
659: , p5_a0 JTF_NUMBER_TABLE
660: , p5_a1 JTF_NUMBER_TABLE
661: , p5_a2 JTF_NUMBER_TABLE
662: , p5_a3 JTF_NUMBER_TABLE
663: , p5_a4 JTF_NUMBER_TABLE
664: , p5_a5 JTF_NUMBER_TABLE
665: , p5_a6 JTF_NUMBER_TABLE
666: , p5_a7 JTF_NUMBER_TABLE
659: , p5_a0 JTF_NUMBER_TABLE
660: , p5_a1 JTF_NUMBER_TABLE
661: , p5_a2 JTF_NUMBER_TABLE
662: , p5_a3 JTF_NUMBER_TABLE
663: , p5_a4 JTF_NUMBER_TABLE
664: , p5_a5 JTF_NUMBER_TABLE
665: , p5_a6 JTF_NUMBER_TABLE
666: , p5_a7 JTF_NUMBER_TABLE
667: , p5_a8 JTF_DATE_TABLE
660: , p5_a1 JTF_NUMBER_TABLE
661: , p5_a2 JTF_NUMBER_TABLE
662: , p5_a3 JTF_NUMBER_TABLE
663: , p5_a4 JTF_NUMBER_TABLE
664: , p5_a5 JTF_NUMBER_TABLE
665: , p5_a6 JTF_NUMBER_TABLE
666: , p5_a7 JTF_NUMBER_TABLE
667: , p5_a8 JTF_DATE_TABLE
668: , p5_a9 JTF_NUMBER_TABLE
661: , p5_a2 JTF_NUMBER_TABLE
662: , p5_a3 JTF_NUMBER_TABLE
663: , p5_a4 JTF_NUMBER_TABLE
664: , p5_a5 JTF_NUMBER_TABLE
665: , p5_a6 JTF_NUMBER_TABLE
666: , p5_a7 JTF_NUMBER_TABLE
667: , p5_a8 JTF_DATE_TABLE
668: , p5_a9 JTF_NUMBER_TABLE
669: , p5_a10 JTF_DATE_TABLE
662: , p5_a3 JTF_NUMBER_TABLE
663: , p5_a4 JTF_NUMBER_TABLE
664: , p5_a5 JTF_NUMBER_TABLE
665: , p5_a6 JTF_NUMBER_TABLE
666: , p5_a7 JTF_NUMBER_TABLE
667: , p5_a8 JTF_DATE_TABLE
668: , p5_a9 JTF_NUMBER_TABLE
669: , p5_a10 JTF_DATE_TABLE
670: , p5_a11 JTF_NUMBER_TABLE
664: , p5_a5 JTF_NUMBER_TABLE
665: , p5_a6 JTF_NUMBER_TABLE
666: , p5_a7 JTF_NUMBER_TABLE
667: , p5_a8 JTF_DATE_TABLE
668: , p5_a9 JTF_NUMBER_TABLE
669: , p5_a10 JTF_DATE_TABLE
670: , p5_a11 JTF_NUMBER_TABLE
671: , p5_a12 JTF_VARCHAR2_TABLE_100
672: , p5_a13 JTF_VARCHAR2_TABLE_500
666: , p5_a7 JTF_NUMBER_TABLE
667: , p5_a8 JTF_DATE_TABLE
668: , p5_a9 JTF_NUMBER_TABLE
669: , p5_a10 JTF_DATE_TABLE
670: , p5_a11 JTF_NUMBER_TABLE
671: , p5_a12 JTF_VARCHAR2_TABLE_100
672: , p5_a13 JTF_VARCHAR2_TABLE_500
673: , p5_a14 JTF_VARCHAR2_TABLE_500
674: , p5_a15 JTF_VARCHAR2_TABLE_500
684: , p5_a25 JTF_VARCHAR2_TABLE_500
685: , p5_a26 JTF_VARCHAR2_TABLE_500
686: , p5_a27 JTF_VARCHAR2_TABLE_500
687: , p5_a28 JTF_VARCHAR2_TABLE_100
688: , p5_a29 JTF_NUMBER_TABLE
689: , p6_a0 out nocopy JTF_NUMBER_TABLE
690: , p6_a1 out nocopy JTF_NUMBER_TABLE
691: , p6_a2 out nocopy JTF_NUMBER_TABLE
692: , p6_a3 out nocopy JTF_NUMBER_TABLE
685: , p5_a26 JTF_VARCHAR2_TABLE_500
686: , p5_a27 JTF_VARCHAR2_TABLE_500
687: , p5_a28 JTF_VARCHAR2_TABLE_100
688: , p5_a29 JTF_NUMBER_TABLE
689: , p6_a0 out nocopy JTF_NUMBER_TABLE
690: , p6_a1 out nocopy JTF_NUMBER_TABLE
691: , p6_a2 out nocopy JTF_NUMBER_TABLE
692: , p6_a3 out nocopy JTF_NUMBER_TABLE
693: , p6_a4 out nocopy JTF_NUMBER_TABLE
686: , p5_a27 JTF_VARCHAR2_TABLE_500
687: , p5_a28 JTF_VARCHAR2_TABLE_100
688: , p5_a29 JTF_NUMBER_TABLE
689: , p6_a0 out nocopy JTF_NUMBER_TABLE
690: , p6_a1 out nocopy JTF_NUMBER_TABLE
691: , p6_a2 out nocopy JTF_NUMBER_TABLE
692: , p6_a3 out nocopy JTF_NUMBER_TABLE
693: , p6_a4 out nocopy JTF_NUMBER_TABLE
694: , p6_a5 out nocopy JTF_NUMBER_TABLE
687: , p5_a28 JTF_VARCHAR2_TABLE_100
688: , p5_a29 JTF_NUMBER_TABLE
689: , p6_a0 out nocopy JTF_NUMBER_TABLE
690: , p6_a1 out nocopy JTF_NUMBER_TABLE
691: , p6_a2 out nocopy JTF_NUMBER_TABLE
692: , p6_a3 out nocopy JTF_NUMBER_TABLE
693: , p6_a4 out nocopy JTF_NUMBER_TABLE
694: , p6_a5 out nocopy JTF_NUMBER_TABLE
695: , p6_a6 out nocopy JTF_NUMBER_TABLE
688: , p5_a29 JTF_NUMBER_TABLE
689: , p6_a0 out nocopy JTF_NUMBER_TABLE
690: , p6_a1 out nocopy JTF_NUMBER_TABLE
691: , p6_a2 out nocopy JTF_NUMBER_TABLE
692: , p6_a3 out nocopy JTF_NUMBER_TABLE
693: , p6_a4 out nocopy JTF_NUMBER_TABLE
694: , p6_a5 out nocopy JTF_NUMBER_TABLE
695: , p6_a6 out nocopy JTF_NUMBER_TABLE
696: , p6_a7 out nocopy JTF_NUMBER_TABLE
689: , p6_a0 out nocopy JTF_NUMBER_TABLE
690: , p6_a1 out nocopy JTF_NUMBER_TABLE
691: , p6_a2 out nocopy JTF_NUMBER_TABLE
692: , p6_a3 out nocopy JTF_NUMBER_TABLE
693: , p6_a4 out nocopy JTF_NUMBER_TABLE
694: , p6_a5 out nocopy JTF_NUMBER_TABLE
695: , p6_a6 out nocopy JTF_NUMBER_TABLE
696: , p6_a7 out nocopy JTF_NUMBER_TABLE
697: , p6_a8 out nocopy JTF_DATE_TABLE
690: , p6_a1 out nocopy JTF_NUMBER_TABLE
691: , p6_a2 out nocopy JTF_NUMBER_TABLE
692: , p6_a3 out nocopy JTF_NUMBER_TABLE
693: , p6_a4 out nocopy JTF_NUMBER_TABLE
694: , p6_a5 out nocopy JTF_NUMBER_TABLE
695: , p6_a6 out nocopy JTF_NUMBER_TABLE
696: , p6_a7 out nocopy JTF_NUMBER_TABLE
697: , p6_a8 out nocopy JTF_DATE_TABLE
698: , p6_a9 out nocopy JTF_NUMBER_TABLE
691: , p6_a2 out nocopy JTF_NUMBER_TABLE
692: , p6_a3 out nocopy JTF_NUMBER_TABLE
693: , p6_a4 out nocopy JTF_NUMBER_TABLE
694: , p6_a5 out nocopy JTF_NUMBER_TABLE
695: , p6_a6 out nocopy JTF_NUMBER_TABLE
696: , p6_a7 out nocopy JTF_NUMBER_TABLE
697: , p6_a8 out nocopy JTF_DATE_TABLE
698: , p6_a9 out nocopy JTF_NUMBER_TABLE
699: , p6_a10 out nocopy JTF_DATE_TABLE
692: , p6_a3 out nocopy JTF_NUMBER_TABLE
693: , p6_a4 out nocopy JTF_NUMBER_TABLE
694: , p6_a5 out nocopy JTF_NUMBER_TABLE
695: , p6_a6 out nocopy JTF_NUMBER_TABLE
696: , p6_a7 out nocopy JTF_NUMBER_TABLE
697: , p6_a8 out nocopy JTF_DATE_TABLE
698: , p6_a9 out nocopy JTF_NUMBER_TABLE
699: , p6_a10 out nocopy JTF_DATE_TABLE
700: , p6_a11 out nocopy JTF_NUMBER_TABLE
694: , p6_a5 out nocopy JTF_NUMBER_TABLE
695: , p6_a6 out nocopy JTF_NUMBER_TABLE
696: , p6_a7 out nocopy JTF_NUMBER_TABLE
697: , p6_a8 out nocopy JTF_DATE_TABLE
698: , p6_a9 out nocopy JTF_NUMBER_TABLE
699: , p6_a10 out nocopy JTF_DATE_TABLE
700: , p6_a11 out nocopy JTF_NUMBER_TABLE
701: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
702: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
696: , p6_a7 out nocopy JTF_NUMBER_TABLE
697: , p6_a8 out nocopy JTF_DATE_TABLE
698: , p6_a9 out nocopy JTF_NUMBER_TABLE
699: , p6_a10 out nocopy JTF_DATE_TABLE
700: , p6_a11 out nocopy JTF_NUMBER_TABLE
701: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
702: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
703: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
704: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
714: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
715: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
716: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
717: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_100
718: , p6_a29 out nocopy JTF_NUMBER_TABLE
719: )
720:
721: as
722: ddp_lrfv_tbl okl_lrf_pvt.lrfv_tbl_type;
911: , p_init_msg_list VARCHAR2
912: , x_return_status out nocopy VARCHAR2
913: , x_msg_count out nocopy NUMBER
914: , x_msg_data out nocopy VARCHAR2
915: , p5_a0 JTF_NUMBER_TABLE
916: , p5_a1 JTF_NUMBER_TABLE
917: , p5_a2 JTF_NUMBER_TABLE
918: , p5_a3 JTF_NUMBER_TABLE
919: , p5_a4 JTF_NUMBER_TABLE
912: , x_return_status out nocopy VARCHAR2
913: , x_msg_count out nocopy NUMBER
914: , x_msg_data out nocopy VARCHAR2
915: , p5_a0 JTF_NUMBER_TABLE
916: , p5_a1 JTF_NUMBER_TABLE
917: , p5_a2 JTF_NUMBER_TABLE
918: , p5_a3 JTF_NUMBER_TABLE
919: , p5_a4 JTF_NUMBER_TABLE
920: , p5_a5 JTF_NUMBER_TABLE
913: , x_msg_count out nocopy NUMBER
914: , x_msg_data out nocopy VARCHAR2
915: , p5_a0 JTF_NUMBER_TABLE
916: , p5_a1 JTF_NUMBER_TABLE
917: , p5_a2 JTF_NUMBER_TABLE
918: , p5_a3 JTF_NUMBER_TABLE
919: , p5_a4 JTF_NUMBER_TABLE
920: , p5_a5 JTF_NUMBER_TABLE
921: , p5_a6 JTF_NUMBER_TABLE
914: , x_msg_data out nocopy VARCHAR2
915: , p5_a0 JTF_NUMBER_TABLE
916: , p5_a1 JTF_NUMBER_TABLE
917: , p5_a2 JTF_NUMBER_TABLE
918: , p5_a3 JTF_NUMBER_TABLE
919: , p5_a4 JTF_NUMBER_TABLE
920: , p5_a5 JTF_NUMBER_TABLE
921: , p5_a6 JTF_NUMBER_TABLE
922: , p5_a7 JTF_NUMBER_TABLE
915: , p5_a0 JTF_NUMBER_TABLE
916: , p5_a1 JTF_NUMBER_TABLE
917: , p5_a2 JTF_NUMBER_TABLE
918: , p5_a3 JTF_NUMBER_TABLE
919: , p5_a4 JTF_NUMBER_TABLE
920: , p5_a5 JTF_NUMBER_TABLE
921: , p5_a6 JTF_NUMBER_TABLE
922: , p5_a7 JTF_NUMBER_TABLE
923: , p5_a8 JTF_DATE_TABLE
916: , p5_a1 JTF_NUMBER_TABLE
917: , p5_a2 JTF_NUMBER_TABLE
918: , p5_a3 JTF_NUMBER_TABLE
919: , p5_a4 JTF_NUMBER_TABLE
920: , p5_a5 JTF_NUMBER_TABLE
921: , p5_a6 JTF_NUMBER_TABLE
922: , p5_a7 JTF_NUMBER_TABLE
923: , p5_a8 JTF_DATE_TABLE
924: , p5_a9 JTF_NUMBER_TABLE
917: , p5_a2 JTF_NUMBER_TABLE
918: , p5_a3 JTF_NUMBER_TABLE
919: , p5_a4 JTF_NUMBER_TABLE
920: , p5_a5 JTF_NUMBER_TABLE
921: , p5_a6 JTF_NUMBER_TABLE
922: , p5_a7 JTF_NUMBER_TABLE
923: , p5_a8 JTF_DATE_TABLE
924: , p5_a9 JTF_NUMBER_TABLE
925: , p5_a10 JTF_DATE_TABLE
918: , p5_a3 JTF_NUMBER_TABLE
919: , p5_a4 JTF_NUMBER_TABLE
920: , p5_a5 JTF_NUMBER_TABLE
921: , p5_a6 JTF_NUMBER_TABLE
922: , p5_a7 JTF_NUMBER_TABLE
923: , p5_a8 JTF_DATE_TABLE
924: , p5_a9 JTF_NUMBER_TABLE
925: , p5_a10 JTF_DATE_TABLE
926: , p5_a11 JTF_NUMBER_TABLE
920: , p5_a5 JTF_NUMBER_TABLE
921: , p5_a6 JTF_NUMBER_TABLE
922: , p5_a7 JTF_NUMBER_TABLE
923: , p5_a8 JTF_DATE_TABLE
924: , p5_a9 JTF_NUMBER_TABLE
925: , p5_a10 JTF_DATE_TABLE
926: , p5_a11 JTF_NUMBER_TABLE
927: , p5_a12 JTF_VARCHAR2_TABLE_100
928: , p5_a13 JTF_VARCHAR2_TABLE_500
922: , p5_a7 JTF_NUMBER_TABLE
923: , p5_a8 JTF_DATE_TABLE
924: , p5_a9 JTF_NUMBER_TABLE
925: , p5_a10 JTF_DATE_TABLE
926: , p5_a11 JTF_NUMBER_TABLE
927: , p5_a12 JTF_VARCHAR2_TABLE_100
928: , p5_a13 JTF_VARCHAR2_TABLE_500
929: , p5_a14 JTF_VARCHAR2_TABLE_500
930: , p5_a15 JTF_VARCHAR2_TABLE_500
940: , p5_a25 JTF_VARCHAR2_TABLE_500
941: , p5_a26 JTF_VARCHAR2_TABLE_500
942: , p5_a27 JTF_VARCHAR2_TABLE_500
943: , p5_a28 JTF_VARCHAR2_TABLE_100
944: , p5_a29 JTF_NUMBER_TABLE
945: )
946:
947: as
948: ddp_lrfv_tbl okl_lrf_pvt.lrfv_tbl_type;
1166: , p_init_msg_list VARCHAR2
1167: , x_return_status out nocopy VARCHAR2
1168: , x_msg_count out nocopy NUMBER
1169: , x_msg_data out nocopy VARCHAR2
1170: , p5_a0 JTF_NUMBER_TABLE
1171: , p5_a1 JTF_NUMBER_TABLE
1172: , p5_a2 JTF_NUMBER_TABLE
1173: , p5_a3 JTF_NUMBER_TABLE
1174: , p5_a4 JTF_NUMBER_TABLE
1167: , x_return_status out nocopy VARCHAR2
1168: , x_msg_count out nocopy NUMBER
1169: , x_msg_data out nocopy VARCHAR2
1170: , p5_a0 JTF_NUMBER_TABLE
1171: , p5_a1 JTF_NUMBER_TABLE
1172: , p5_a2 JTF_NUMBER_TABLE
1173: , p5_a3 JTF_NUMBER_TABLE
1174: , p5_a4 JTF_NUMBER_TABLE
1175: , p5_a5 JTF_NUMBER_TABLE
1168: , x_msg_count out nocopy NUMBER
1169: , x_msg_data out nocopy VARCHAR2
1170: , p5_a0 JTF_NUMBER_TABLE
1171: , p5_a1 JTF_NUMBER_TABLE
1172: , p5_a2 JTF_NUMBER_TABLE
1173: , p5_a3 JTF_NUMBER_TABLE
1174: , p5_a4 JTF_NUMBER_TABLE
1175: , p5_a5 JTF_NUMBER_TABLE
1176: , p5_a6 JTF_NUMBER_TABLE
1169: , x_msg_data out nocopy VARCHAR2
1170: , p5_a0 JTF_NUMBER_TABLE
1171: , p5_a1 JTF_NUMBER_TABLE
1172: , p5_a2 JTF_NUMBER_TABLE
1173: , p5_a3 JTF_NUMBER_TABLE
1174: , p5_a4 JTF_NUMBER_TABLE
1175: , p5_a5 JTF_NUMBER_TABLE
1176: , p5_a6 JTF_NUMBER_TABLE
1177: , p5_a7 JTF_NUMBER_TABLE
1170: , p5_a0 JTF_NUMBER_TABLE
1171: , p5_a1 JTF_NUMBER_TABLE
1172: , p5_a2 JTF_NUMBER_TABLE
1173: , p5_a3 JTF_NUMBER_TABLE
1174: , p5_a4 JTF_NUMBER_TABLE
1175: , p5_a5 JTF_NUMBER_TABLE
1176: , p5_a6 JTF_NUMBER_TABLE
1177: , p5_a7 JTF_NUMBER_TABLE
1178: , p5_a8 JTF_DATE_TABLE
1171: , p5_a1 JTF_NUMBER_TABLE
1172: , p5_a2 JTF_NUMBER_TABLE
1173: , p5_a3 JTF_NUMBER_TABLE
1174: , p5_a4 JTF_NUMBER_TABLE
1175: , p5_a5 JTF_NUMBER_TABLE
1176: , p5_a6 JTF_NUMBER_TABLE
1177: , p5_a7 JTF_NUMBER_TABLE
1178: , p5_a8 JTF_DATE_TABLE
1179: , p5_a9 JTF_NUMBER_TABLE
1172: , p5_a2 JTF_NUMBER_TABLE
1173: , p5_a3 JTF_NUMBER_TABLE
1174: , p5_a4 JTF_NUMBER_TABLE
1175: , p5_a5 JTF_NUMBER_TABLE
1176: , p5_a6 JTF_NUMBER_TABLE
1177: , p5_a7 JTF_NUMBER_TABLE
1178: , p5_a8 JTF_DATE_TABLE
1179: , p5_a9 JTF_NUMBER_TABLE
1180: , p5_a10 JTF_DATE_TABLE
1173: , p5_a3 JTF_NUMBER_TABLE
1174: , p5_a4 JTF_NUMBER_TABLE
1175: , p5_a5 JTF_NUMBER_TABLE
1176: , p5_a6 JTF_NUMBER_TABLE
1177: , p5_a7 JTF_NUMBER_TABLE
1178: , p5_a8 JTF_DATE_TABLE
1179: , p5_a9 JTF_NUMBER_TABLE
1180: , p5_a10 JTF_DATE_TABLE
1181: , p5_a11 JTF_NUMBER_TABLE
1175: , p5_a5 JTF_NUMBER_TABLE
1176: , p5_a6 JTF_NUMBER_TABLE
1177: , p5_a7 JTF_NUMBER_TABLE
1178: , p5_a8 JTF_DATE_TABLE
1179: , p5_a9 JTF_NUMBER_TABLE
1180: , p5_a10 JTF_DATE_TABLE
1181: , p5_a11 JTF_NUMBER_TABLE
1182: , p5_a12 JTF_VARCHAR2_TABLE_100
1183: , p5_a13 JTF_VARCHAR2_TABLE_500
1177: , p5_a7 JTF_NUMBER_TABLE
1178: , p5_a8 JTF_DATE_TABLE
1179: , p5_a9 JTF_NUMBER_TABLE
1180: , p5_a10 JTF_DATE_TABLE
1181: , p5_a11 JTF_NUMBER_TABLE
1182: , p5_a12 JTF_VARCHAR2_TABLE_100
1183: , p5_a13 JTF_VARCHAR2_TABLE_500
1184: , p5_a14 JTF_VARCHAR2_TABLE_500
1185: , p5_a15 JTF_VARCHAR2_TABLE_500
1195: , p5_a25 JTF_VARCHAR2_TABLE_500
1196: , p5_a26 JTF_VARCHAR2_TABLE_500
1197: , p5_a27 JTF_VARCHAR2_TABLE_500
1198: , p5_a28 JTF_VARCHAR2_TABLE_100
1199: , p5_a29 JTF_NUMBER_TABLE
1200: , p6_a0 out nocopy JTF_NUMBER_TABLE
1201: , p6_a1 out nocopy JTF_NUMBER_TABLE
1202: , p6_a2 out nocopy JTF_NUMBER_TABLE
1203: , p6_a3 out nocopy JTF_NUMBER_TABLE
1196: , p5_a26 JTF_VARCHAR2_TABLE_500
1197: , p5_a27 JTF_VARCHAR2_TABLE_500
1198: , p5_a28 JTF_VARCHAR2_TABLE_100
1199: , p5_a29 JTF_NUMBER_TABLE
1200: , p6_a0 out nocopy JTF_NUMBER_TABLE
1201: , p6_a1 out nocopy JTF_NUMBER_TABLE
1202: , p6_a2 out nocopy JTF_NUMBER_TABLE
1203: , p6_a3 out nocopy JTF_NUMBER_TABLE
1204: , p6_a4 out nocopy JTF_NUMBER_TABLE
1197: , p5_a27 JTF_VARCHAR2_TABLE_500
1198: , p5_a28 JTF_VARCHAR2_TABLE_100
1199: , p5_a29 JTF_NUMBER_TABLE
1200: , p6_a0 out nocopy JTF_NUMBER_TABLE
1201: , p6_a1 out nocopy JTF_NUMBER_TABLE
1202: , p6_a2 out nocopy JTF_NUMBER_TABLE
1203: , p6_a3 out nocopy JTF_NUMBER_TABLE
1204: , p6_a4 out nocopy JTF_NUMBER_TABLE
1205: , p6_a5 out nocopy JTF_NUMBER_TABLE
1198: , p5_a28 JTF_VARCHAR2_TABLE_100
1199: , p5_a29 JTF_NUMBER_TABLE
1200: , p6_a0 out nocopy JTF_NUMBER_TABLE
1201: , p6_a1 out nocopy JTF_NUMBER_TABLE
1202: , p6_a2 out nocopy JTF_NUMBER_TABLE
1203: , p6_a3 out nocopy JTF_NUMBER_TABLE
1204: , p6_a4 out nocopy JTF_NUMBER_TABLE
1205: , p6_a5 out nocopy JTF_NUMBER_TABLE
1206: , p6_a6 out nocopy JTF_NUMBER_TABLE
1199: , p5_a29 JTF_NUMBER_TABLE
1200: , p6_a0 out nocopy JTF_NUMBER_TABLE
1201: , p6_a1 out nocopy JTF_NUMBER_TABLE
1202: , p6_a2 out nocopy JTF_NUMBER_TABLE
1203: , p6_a3 out nocopy JTF_NUMBER_TABLE
1204: , p6_a4 out nocopy JTF_NUMBER_TABLE
1205: , p6_a5 out nocopy JTF_NUMBER_TABLE
1206: , p6_a6 out nocopy JTF_NUMBER_TABLE
1207: , p6_a7 out nocopy JTF_NUMBER_TABLE
1200: , p6_a0 out nocopy JTF_NUMBER_TABLE
1201: , p6_a1 out nocopy JTF_NUMBER_TABLE
1202: , p6_a2 out nocopy JTF_NUMBER_TABLE
1203: , p6_a3 out nocopy JTF_NUMBER_TABLE
1204: , p6_a4 out nocopy JTF_NUMBER_TABLE
1205: , p6_a5 out nocopy JTF_NUMBER_TABLE
1206: , p6_a6 out nocopy JTF_NUMBER_TABLE
1207: , p6_a7 out nocopy JTF_NUMBER_TABLE
1208: , p6_a8 out nocopy JTF_DATE_TABLE
1201: , p6_a1 out nocopy JTF_NUMBER_TABLE
1202: , p6_a2 out nocopy JTF_NUMBER_TABLE
1203: , p6_a3 out nocopy JTF_NUMBER_TABLE
1204: , p6_a4 out nocopy JTF_NUMBER_TABLE
1205: , p6_a5 out nocopy JTF_NUMBER_TABLE
1206: , p6_a6 out nocopy JTF_NUMBER_TABLE
1207: , p6_a7 out nocopy JTF_NUMBER_TABLE
1208: , p6_a8 out nocopy JTF_DATE_TABLE
1209: , p6_a9 out nocopy JTF_NUMBER_TABLE
1202: , p6_a2 out nocopy JTF_NUMBER_TABLE
1203: , p6_a3 out nocopy JTF_NUMBER_TABLE
1204: , p6_a4 out nocopy JTF_NUMBER_TABLE
1205: , p6_a5 out nocopy JTF_NUMBER_TABLE
1206: , p6_a6 out nocopy JTF_NUMBER_TABLE
1207: , p6_a7 out nocopy JTF_NUMBER_TABLE
1208: , p6_a8 out nocopy JTF_DATE_TABLE
1209: , p6_a9 out nocopy JTF_NUMBER_TABLE
1210: , p6_a10 out nocopy JTF_DATE_TABLE
1203: , p6_a3 out nocopy JTF_NUMBER_TABLE
1204: , p6_a4 out nocopy JTF_NUMBER_TABLE
1205: , p6_a5 out nocopy JTF_NUMBER_TABLE
1206: , p6_a6 out nocopy JTF_NUMBER_TABLE
1207: , p6_a7 out nocopy JTF_NUMBER_TABLE
1208: , p6_a8 out nocopy JTF_DATE_TABLE
1209: , p6_a9 out nocopy JTF_NUMBER_TABLE
1210: , p6_a10 out nocopy JTF_DATE_TABLE
1211: , p6_a11 out nocopy JTF_NUMBER_TABLE
1205: , p6_a5 out nocopy JTF_NUMBER_TABLE
1206: , p6_a6 out nocopy JTF_NUMBER_TABLE
1207: , p6_a7 out nocopy JTF_NUMBER_TABLE
1208: , p6_a8 out nocopy JTF_DATE_TABLE
1209: , p6_a9 out nocopy JTF_NUMBER_TABLE
1210: , p6_a10 out nocopy JTF_DATE_TABLE
1211: , p6_a11 out nocopy JTF_NUMBER_TABLE
1212: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
1213: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
1207: , p6_a7 out nocopy JTF_NUMBER_TABLE
1208: , p6_a8 out nocopy JTF_DATE_TABLE
1209: , p6_a9 out nocopy JTF_NUMBER_TABLE
1210: , p6_a10 out nocopy JTF_DATE_TABLE
1211: , p6_a11 out nocopy JTF_NUMBER_TABLE
1212: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
1213: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
1214: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
1215: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
1225: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
1226: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
1227: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
1228: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_100
1229: , p6_a29 out nocopy JTF_NUMBER_TABLE
1230: )
1231:
1232: as
1233: ddp_lrfv_tbl okl_lrf_pvt.lrfv_tbl_type;
1422: , p_init_msg_list VARCHAR2
1423: , x_return_status out nocopy VARCHAR2
1424: , x_msg_count out nocopy NUMBER
1425: , x_msg_data out nocopy VARCHAR2
1426: , p5_a0 JTF_NUMBER_TABLE
1427: , p5_a1 JTF_NUMBER_TABLE
1428: , p5_a2 JTF_NUMBER_TABLE
1429: , p5_a3 JTF_NUMBER_TABLE
1430: , p5_a4 JTF_NUMBER_TABLE
1423: , x_return_status out nocopy VARCHAR2
1424: , x_msg_count out nocopy NUMBER
1425: , x_msg_data out nocopy VARCHAR2
1426: , p5_a0 JTF_NUMBER_TABLE
1427: , p5_a1 JTF_NUMBER_TABLE
1428: , p5_a2 JTF_NUMBER_TABLE
1429: , p5_a3 JTF_NUMBER_TABLE
1430: , p5_a4 JTF_NUMBER_TABLE
1431: , p5_a5 JTF_NUMBER_TABLE
1424: , x_msg_count out nocopy NUMBER
1425: , x_msg_data out nocopy VARCHAR2
1426: , p5_a0 JTF_NUMBER_TABLE
1427: , p5_a1 JTF_NUMBER_TABLE
1428: , p5_a2 JTF_NUMBER_TABLE
1429: , p5_a3 JTF_NUMBER_TABLE
1430: , p5_a4 JTF_NUMBER_TABLE
1431: , p5_a5 JTF_NUMBER_TABLE
1432: , p5_a6 JTF_NUMBER_TABLE
1425: , x_msg_data out nocopy VARCHAR2
1426: , p5_a0 JTF_NUMBER_TABLE
1427: , p5_a1 JTF_NUMBER_TABLE
1428: , p5_a2 JTF_NUMBER_TABLE
1429: , p5_a3 JTF_NUMBER_TABLE
1430: , p5_a4 JTF_NUMBER_TABLE
1431: , p5_a5 JTF_NUMBER_TABLE
1432: , p5_a6 JTF_NUMBER_TABLE
1433: , p5_a7 JTF_NUMBER_TABLE
1426: , p5_a0 JTF_NUMBER_TABLE
1427: , p5_a1 JTF_NUMBER_TABLE
1428: , p5_a2 JTF_NUMBER_TABLE
1429: , p5_a3 JTF_NUMBER_TABLE
1430: , p5_a4 JTF_NUMBER_TABLE
1431: , p5_a5 JTF_NUMBER_TABLE
1432: , p5_a6 JTF_NUMBER_TABLE
1433: , p5_a7 JTF_NUMBER_TABLE
1434: , p5_a8 JTF_DATE_TABLE
1427: , p5_a1 JTF_NUMBER_TABLE
1428: , p5_a2 JTF_NUMBER_TABLE
1429: , p5_a3 JTF_NUMBER_TABLE
1430: , p5_a4 JTF_NUMBER_TABLE
1431: , p5_a5 JTF_NUMBER_TABLE
1432: , p5_a6 JTF_NUMBER_TABLE
1433: , p5_a7 JTF_NUMBER_TABLE
1434: , p5_a8 JTF_DATE_TABLE
1435: , p5_a9 JTF_NUMBER_TABLE
1428: , p5_a2 JTF_NUMBER_TABLE
1429: , p5_a3 JTF_NUMBER_TABLE
1430: , p5_a4 JTF_NUMBER_TABLE
1431: , p5_a5 JTF_NUMBER_TABLE
1432: , p5_a6 JTF_NUMBER_TABLE
1433: , p5_a7 JTF_NUMBER_TABLE
1434: , p5_a8 JTF_DATE_TABLE
1435: , p5_a9 JTF_NUMBER_TABLE
1436: , p5_a10 JTF_DATE_TABLE
1429: , p5_a3 JTF_NUMBER_TABLE
1430: , p5_a4 JTF_NUMBER_TABLE
1431: , p5_a5 JTF_NUMBER_TABLE
1432: , p5_a6 JTF_NUMBER_TABLE
1433: , p5_a7 JTF_NUMBER_TABLE
1434: , p5_a8 JTF_DATE_TABLE
1435: , p5_a9 JTF_NUMBER_TABLE
1436: , p5_a10 JTF_DATE_TABLE
1437: , p5_a11 JTF_NUMBER_TABLE
1431: , p5_a5 JTF_NUMBER_TABLE
1432: , p5_a6 JTF_NUMBER_TABLE
1433: , p5_a7 JTF_NUMBER_TABLE
1434: , p5_a8 JTF_DATE_TABLE
1435: , p5_a9 JTF_NUMBER_TABLE
1436: , p5_a10 JTF_DATE_TABLE
1437: , p5_a11 JTF_NUMBER_TABLE
1438: , p5_a12 JTF_VARCHAR2_TABLE_100
1439: , p5_a13 JTF_VARCHAR2_TABLE_500
1433: , p5_a7 JTF_NUMBER_TABLE
1434: , p5_a8 JTF_DATE_TABLE
1435: , p5_a9 JTF_NUMBER_TABLE
1436: , p5_a10 JTF_DATE_TABLE
1437: , p5_a11 JTF_NUMBER_TABLE
1438: , p5_a12 JTF_VARCHAR2_TABLE_100
1439: , p5_a13 JTF_VARCHAR2_TABLE_500
1440: , p5_a14 JTF_VARCHAR2_TABLE_500
1441: , p5_a15 JTF_VARCHAR2_TABLE_500
1451: , p5_a25 JTF_VARCHAR2_TABLE_500
1452: , p5_a26 JTF_VARCHAR2_TABLE_500
1453: , p5_a27 JTF_VARCHAR2_TABLE_500
1454: , p5_a28 JTF_VARCHAR2_TABLE_100
1455: , p5_a29 JTF_NUMBER_TABLE
1456: )
1457:
1458: as
1459: ddp_lrfv_tbl okl_lrf_pvt.lrfv_tbl_type;
1613: , p_init_msg_list VARCHAR2
1614: , x_return_status out nocopy VARCHAR2
1615: , x_msg_count out nocopy NUMBER
1616: , x_msg_data out nocopy VARCHAR2
1617: , p5_a0 JTF_NUMBER_TABLE
1618: , p5_a1 JTF_NUMBER_TABLE
1619: , p5_a2 JTF_NUMBER_TABLE
1620: , p5_a3 JTF_NUMBER_TABLE
1621: , p5_a4 JTF_NUMBER_TABLE
1614: , x_return_status out nocopy VARCHAR2
1615: , x_msg_count out nocopy NUMBER
1616: , x_msg_data out nocopy VARCHAR2
1617: , p5_a0 JTF_NUMBER_TABLE
1618: , p5_a1 JTF_NUMBER_TABLE
1619: , p5_a2 JTF_NUMBER_TABLE
1620: , p5_a3 JTF_NUMBER_TABLE
1621: , p5_a4 JTF_NUMBER_TABLE
1622: , p5_a5 JTF_NUMBER_TABLE
1615: , x_msg_count out nocopy NUMBER
1616: , x_msg_data out nocopy VARCHAR2
1617: , p5_a0 JTF_NUMBER_TABLE
1618: , p5_a1 JTF_NUMBER_TABLE
1619: , p5_a2 JTF_NUMBER_TABLE
1620: , p5_a3 JTF_NUMBER_TABLE
1621: , p5_a4 JTF_NUMBER_TABLE
1622: , p5_a5 JTF_NUMBER_TABLE
1623: , p5_a6 JTF_NUMBER_TABLE
1616: , x_msg_data out nocopy VARCHAR2
1617: , p5_a0 JTF_NUMBER_TABLE
1618: , p5_a1 JTF_NUMBER_TABLE
1619: , p5_a2 JTF_NUMBER_TABLE
1620: , p5_a3 JTF_NUMBER_TABLE
1621: , p5_a4 JTF_NUMBER_TABLE
1622: , p5_a5 JTF_NUMBER_TABLE
1623: , p5_a6 JTF_NUMBER_TABLE
1624: , p5_a7 JTF_NUMBER_TABLE
1617: , p5_a0 JTF_NUMBER_TABLE
1618: , p5_a1 JTF_NUMBER_TABLE
1619: , p5_a2 JTF_NUMBER_TABLE
1620: , p5_a3 JTF_NUMBER_TABLE
1621: , p5_a4 JTF_NUMBER_TABLE
1622: , p5_a5 JTF_NUMBER_TABLE
1623: , p5_a6 JTF_NUMBER_TABLE
1624: , p5_a7 JTF_NUMBER_TABLE
1625: , p5_a8 JTF_DATE_TABLE
1618: , p5_a1 JTF_NUMBER_TABLE
1619: , p5_a2 JTF_NUMBER_TABLE
1620: , p5_a3 JTF_NUMBER_TABLE
1621: , p5_a4 JTF_NUMBER_TABLE
1622: , p5_a5 JTF_NUMBER_TABLE
1623: , p5_a6 JTF_NUMBER_TABLE
1624: , p5_a7 JTF_NUMBER_TABLE
1625: , p5_a8 JTF_DATE_TABLE
1626: , p5_a9 JTF_NUMBER_TABLE
1619: , p5_a2 JTF_NUMBER_TABLE
1620: , p5_a3 JTF_NUMBER_TABLE
1621: , p5_a4 JTF_NUMBER_TABLE
1622: , p5_a5 JTF_NUMBER_TABLE
1623: , p5_a6 JTF_NUMBER_TABLE
1624: , p5_a7 JTF_NUMBER_TABLE
1625: , p5_a8 JTF_DATE_TABLE
1626: , p5_a9 JTF_NUMBER_TABLE
1627: , p5_a10 JTF_DATE_TABLE
1620: , p5_a3 JTF_NUMBER_TABLE
1621: , p5_a4 JTF_NUMBER_TABLE
1622: , p5_a5 JTF_NUMBER_TABLE
1623: , p5_a6 JTF_NUMBER_TABLE
1624: , p5_a7 JTF_NUMBER_TABLE
1625: , p5_a8 JTF_DATE_TABLE
1626: , p5_a9 JTF_NUMBER_TABLE
1627: , p5_a10 JTF_DATE_TABLE
1628: , p5_a11 JTF_NUMBER_TABLE
1622: , p5_a5 JTF_NUMBER_TABLE
1623: , p5_a6 JTF_NUMBER_TABLE
1624: , p5_a7 JTF_NUMBER_TABLE
1625: , p5_a8 JTF_DATE_TABLE
1626: , p5_a9 JTF_NUMBER_TABLE
1627: , p5_a10 JTF_DATE_TABLE
1628: , p5_a11 JTF_NUMBER_TABLE
1629: , p5_a12 JTF_VARCHAR2_TABLE_100
1630: , p5_a13 JTF_VARCHAR2_TABLE_500
1624: , p5_a7 JTF_NUMBER_TABLE
1625: , p5_a8 JTF_DATE_TABLE
1626: , p5_a9 JTF_NUMBER_TABLE
1627: , p5_a10 JTF_DATE_TABLE
1628: , p5_a11 JTF_NUMBER_TABLE
1629: , p5_a12 JTF_VARCHAR2_TABLE_100
1630: , p5_a13 JTF_VARCHAR2_TABLE_500
1631: , p5_a14 JTF_VARCHAR2_TABLE_500
1632: , p5_a15 JTF_VARCHAR2_TABLE_500
1642: , p5_a25 JTF_VARCHAR2_TABLE_500
1643: , p5_a26 JTF_VARCHAR2_TABLE_500
1644: , p5_a27 JTF_VARCHAR2_TABLE_500
1645: , p5_a28 JTF_VARCHAR2_TABLE_100
1646: , p5_a29 JTF_NUMBER_TABLE
1647: )
1648:
1649: as
1650: ddp_lrfv_tbl okl_lrf_pvt.lrfv_tbl_type;