1: package body okl_irh_pvt_w as
2: /* $Header: OKLIIRHB.pls 120.1 2005/07/11 10:25:40 smadhava noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_irh_pvt.okl_irhv_tbl, 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_irh_pvt_w as
2: /* $Header: OKLIIRHB.pls 120.1 2005/07/11 10:25:40 smadhava noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_irh_pvt.okl_irhv_tbl, 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_irh_pvt_w as
2: /* $Header: OKLIIRHB.pls 120.1 2005/07/11 10:25:40 smadhava noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_irh_pvt.okl_irhv_tbl, 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: OKLIIRHB.pls 120.1 2005/07/11 10:25:40 smadhava noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_irh_pvt.okl_irhv_tbl, 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_p1(t out nocopy okl_irh_pvt.okl_irhv_tbl, 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_VARCHAR2_TABLE_100
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_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
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_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
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_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_DATE_TABLE
16: , a13 JTF_DATE_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_DATE_TABLE
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_DATE_TABLE
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_DATE_TABLE
16: , a13 JTF_DATE_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_DATE_TABLE
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_DATE_TABLE
22: , a19 JTF_NUMBER_TABLE
16: , a13 JTF_DATE_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_DATE_TABLE
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_DATE_TABLE
22: , a19 JTF_NUMBER_TABLE
23: ) as
24: ddindx binary_integer; indx binary_integer;
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_DATE_TABLE
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_DATE_TABLE
22: , a19 JTF_NUMBER_TABLE
23: ) as
24: ddindx binary_integer; indx binary_integer;
25: begin
26: if a0 is not null and a0.count > 0 then
56: end loop;
57: end if;
58: end if;
59: end rosetta_table_copy_in_p1;
60: procedure rosetta_table_copy_out_p1(t okl_irh_pvt.okl_irhv_tbl, a0 out nocopy JTF_NUMBER_TABLE
61: , a1 out nocopy JTF_NUMBER_TABLE
62: , a2 out nocopy JTF_NUMBER_TABLE
63: , a3 out nocopy JTF_NUMBER_TABLE
64: , a4 out nocopy JTF_NUMBER_TABLE
57: end if;
58: end if;
59: end rosetta_table_copy_in_p1;
60: procedure rosetta_table_copy_out_p1(t okl_irh_pvt.okl_irhv_tbl, a0 out nocopy JTF_NUMBER_TABLE
61: , a1 out nocopy JTF_NUMBER_TABLE
62: , a2 out nocopy JTF_NUMBER_TABLE
63: , a3 out nocopy JTF_NUMBER_TABLE
64: , a4 out nocopy JTF_NUMBER_TABLE
65: , a5 out nocopy JTF_NUMBER_TABLE
58: end if;
59: end rosetta_table_copy_in_p1;
60: procedure rosetta_table_copy_out_p1(t okl_irh_pvt.okl_irhv_tbl, a0 out nocopy JTF_NUMBER_TABLE
61: , a1 out nocopy JTF_NUMBER_TABLE
62: , a2 out nocopy JTF_NUMBER_TABLE
63: , a3 out nocopy JTF_NUMBER_TABLE
64: , a4 out nocopy JTF_NUMBER_TABLE
65: , a5 out nocopy JTF_NUMBER_TABLE
66: , a6 out nocopy JTF_NUMBER_TABLE
59: end rosetta_table_copy_in_p1;
60: procedure rosetta_table_copy_out_p1(t okl_irh_pvt.okl_irhv_tbl, a0 out nocopy JTF_NUMBER_TABLE
61: , a1 out nocopy JTF_NUMBER_TABLE
62: , a2 out nocopy JTF_NUMBER_TABLE
63: , a3 out nocopy JTF_NUMBER_TABLE
64: , a4 out nocopy JTF_NUMBER_TABLE
65: , a5 out nocopy JTF_NUMBER_TABLE
66: , a6 out nocopy JTF_NUMBER_TABLE
67: , a7 out nocopy JTF_NUMBER_TABLE
60: procedure rosetta_table_copy_out_p1(t okl_irh_pvt.okl_irhv_tbl, a0 out nocopy JTF_NUMBER_TABLE
61: , a1 out nocopy JTF_NUMBER_TABLE
62: , a2 out nocopy JTF_NUMBER_TABLE
63: , a3 out nocopy JTF_NUMBER_TABLE
64: , a4 out nocopy JTF_NUMBER_TABLE
65: , a5 out nocopy JTF_NUMBER_TABLE
66: , a6 out nocopy JTF_NUMBER_TABLE
67: , a7 out nocopy JTF_NUMBER_TABLE
68: , a8 out nocopy JTF_VARCHAR2_TABLE_100
61: , a1 out nocopy JTF_NUMBER_TABLE
62: , a2 out nocopy JTF_NUMBER_TABLE
63: , a3 out nocopy JTF_NUMBER_TABLE
64: , a4 out nocopy JTF_NUMBER_TABLE
65: , a5 out nocopy JTF_NUMBER_TABLE
66: , a6 out nocopy JTF_NUMBER_TABLE
67: , a7 out nocopy JTF_NUMBER_TABLE
68: , a8 out nocopy JTF_VARCHAR2_TABLE_100
69: , a9 out nocopy JTF_VARCHAR2_TABLE_100
62: , a2 out nocopy JTF_NUMBER_TABLE
63: , a3 out nocopy JTF_NUMBER_TABLE
64: , a4 out nocopy JTF_NUMBER_TABLE
65: , a5 out nocopy JTF_NUMBER_TABLE
66: , a6 out nocopy JTF_NUMBER_TABLE
67: , a7 out nocopy JTF_NUMBER_TABLE
68: , a8 out nocopy JTF_VARCHAR2_TABLE_100
69: , a9 out nocopy JTF_VARCHAR2_TABLE_100
70: , a10 out nocopy JTF_VARCHAR2_TABLE_100
63: , a3 out nocopy JTF_NUMBER_TABLE
64: , a4 out nocopy JTF_NUMBER_TABLE
65: , a5 out nocopy JTF_NUMBER_TABLE
66: , a6 out nocopy JTF_NUMBER_TABLE
67: , a7 out nocopy JTF_NUMBER_TABLE
68: , a8 out nocopy JTF_VARCHAR2_TABLE_100
69: , a9 out nocopy JTF_VARCHAR2_TABLE_100
70: , a10 out nocopy JTF_VARCHAR2_TABLE_100
71: , a11 out nocopy JTF_VARCHAR2_TABLE_100
70: , a10 out nocopy JTF_VARCHAR2_TABLE_100
71: , a11 out nocopy JTF_VARCHAR2_TABLE_100
72: , a12 out nocopy JTF_DATE_TABLE
73: , a13 out nocopy JTF_DATE_TABLE
74: , a14 out nocopy JTF_NUMBER_TABLE
75: , a15 out nocopy JTF_NUMBER_TABLE
76: , a16 out nocopy JTF_DATE_TABLE
77: , a17 out nocopy JTF_NUMBER_TABLE
78: , a18 out nocopy JTF_DATE_TABLE
71: , a11 out nocopy JTF_VARCHAR2_TABLE_100
72: , a12 out nocopy JTF_DATE_TABLE
73: , a13 out nocopy JTF_DATE_TABLE
74: , a14 out nocopy JTF_NUMBER_TABLE
75: , a15 out nocopy JTF_NUMBER_TABLE
76: , a16 out nocopy JTF_DATE_TABLE
77: , a17 out nocopy JTF_NUMBER_TABLE
78: , a18 out nocopy JTF_DATE_TABLE
79: , a19 out nocopy JTF_NUMBER_TABLE
73: , a13 out nocopy JTF_DATE_TABLE
74: , a14 out nocopy JTF_NUMBER_TABLE
75: , a15 out nocopy JTF_NUMBER_TABLE
76: , a16 out nocopy JTF_DATE_TABLE
77: , a17 out nocopy JTF_NUMBER_TABLE
78: , a18 out nocopy JTF_DATE_TABLE
79: , a19 out nocopy JTF_NUMBER_TABLE
80: ) as
81: ddindx binary_integer; indx binary_integer;
75: , a15 out nocopy JTF_NUMBER_TABLE
76: , a16 out nocopy JTF_DATE_TABLE
77: , a17 out nocopy JTF_NUMBER_TABLE
78: , a18 out nocopy JTF_DATE_TABLE
79: , a19 out nocopy JTF_NUMBER_TABLE
80: ) as
81: ddindx binary_integer; indx binary_integer;
82: begin
83: if t is null or t.count = 0 then
80: ) as
81: ddindx binary_integer; indx binary_integer;
82: begin
83: if t is null or t.count = 0 then
84: a0 := JTF_NUMBER_TABLE();
85: a1 := JTF_NUMBER_TABLE();
86: a2 := JTF_NUMBER_TABLE();
87: a3 := JTF_NUMBER_TABLE();
88: a4 := JTF_NUMBER_TABLE();
81: ddindx binary_integer; indx binary_integer;
82: begin
83: if t is null or t.count = 0 then
84: a0 := JTF_NUMBER_TABLE();
85: a1 := JTF_NUMBER_TABLE();
86: a2 := JTF_NUMBER_TABLE();
87: a3 := JTF_NUMBER_TABLE();
88: a4 := JTF_NUMBER_TABLE();
89: a5 := JTF_NUMBER_TABLE();
82: begin
83: if t is null or t.count = 0 then
84: a0 := JTF_NUMBER_TABLE();
85: a1 := JTF_NUMBER_TABLE();
86: a2 := JTF_NUMBER_TABLE();
87: a3 := JTF_NUMBER_TABLE();
88: a4 := JTF_NUMBER_TABLE();
89: a5 := JTF_NUMBER_TABLE();
90: a6 := JTF_NUMBER_TABLE();
83: if t is null or t.count = 0 then
84: a0 := JTF_NUMBER_TABLE();
85: a1 := JTF_NUMBER_TABLE();
86: a2 := JTF_NUMBER_TABLE();
87: a3 := JTF_NUMBER_TABLE();
88: a4 := JTF_NUMBER_TABLE();
89: a5 := JTF_NUMBER_TABLE();
90: a6 := JTF_NUMBER_TABLE();
91: a7 := JTF_NUMBER_TABLE();
84: a0 := JTF_NUMBER_TABLE();
85: a1 := JTF_NUMBER_TABLE();
86: a2 := JTF_NUMBER_TABLE();
87: a3 := JTF_NUMBER_TABLE();
88: a4 := JTF_NUMBER_TABLE();
89: a5 := JTF_NUMBER_TABLE();
90: a6 := JTF_NUMBER_TABLE();
91: a7 := JTF_NUMBER_TABLE();
92: a8 := JTF_VARCHAR2_TABLE_100();
85: a1 := JTF_NUMBER_TABLE();
86: a2 := JTF_NUMBER_TABLE();
87: a3 := JTF_NUMBER_TABLE();
88: a4 := JTF_NUMBER_TABLE();
89: a5 := JTF_NUMBER_TABLE();
90: a6 := JTF_NUMBER_TABLE();
91: a7 := JTF_NUMBER_TABLE();
92: a8 := JTF_VARCHAR2_TABLE_100();
93: a9 := JTF_VARCHAR2_TABLE_100();
86: a2 := JTF_NUMBER_TABLE();
87: a3 := JTF_NUMBER_TABLE();
88: a4 := JTF_NUMBER_TABLE();
89: a5 := JTF_NUMBER_TABLE();
90: a6 := JTF_NUMBER_TABLE();
91: a7 := JTF_NUMBER_TABLE();
92: a8 := JTF_VARCHAR2_TABLE_100();
93: a9 := JTF_VARCHAR2_TABLE_100();
94: a10 := JTF_VARCHAR2_TABLE_100();
87: a3 := JTF_NUMBER_TABLE();
88: a4 := JTF_NUMBER_TABLE();
89: a5 := JTF_NUMBER_TABLE();
90: a6 := JTF_NUMBER_TABLE();
91: a7 := JTF_NUMBER_TABLE();
92: a8 := JTF_VARCHAR2_TABLE_100();
93: a9 := JTF_VARCHAR2_TABLE_100();
94: a10 := JTF_VARCHAR2_TABLE_100();
95: a11 := JTF_VARCHAR2_TABLE_100();
94: a10 := JTF_VARCHAR2_TABLE_100();
95: a11 := JTF_VARCHAR2_TABLE_100();
96: a12 := JTF_DATE_TABLE();
97: a13 := JTF_DATE_TABLE();
98: a14 := JTF_NUMBER_TABLE();
99: a15 := JTF_NUMBER_TABLE();
100: a16 := JTF_DATE_TABLE();
101: a17 := JTF_NUMBER_TABLE();
102: a18 := JTF_DATE_TABLE();
95: a11 := JTF_VARCHAR2_TABLE_100();
96: a12 := JTF_DATE_TABLE();
97: a13 := JTF_DATE_TABLE();
98: a14 := JTF_NUMBER_TABLE();
99: a15 := JTF_NUMBER_TABLE();
100: a16 := JTF_DATE_TABLE();
101: a17 := JTF_NUMBER_TABLE();
102: a18 := JTF_DATE_TABLE();
103: a19 := JTF_NUMBER_TABLE();
97: a13 := JTF_DATE_TABLE();
98: a14 := JTF_NUMBER_TABLE();
99: a15 := JTF_NUMBER_TABLE();
100: a16 := JTF_DATE_TABLE();
101: a17 := JTF_NUMBER_TABLE();
102: a18 := JTF_DATE_TABLE();
103: a19 := JTF_NUMBER_TABLE();
104: else
105: a0 := JTF_NUMBER_TABLE();
99: a15 := JTF_NUMBER_TABLE();
100: a16 := JTF_DATE_TABLE();
101: a17 := JTF_NUMBER_TABLE();
102: a18 := JTF_DATE_TABLE();
103: a19 := JTF_NUMBER_TABLE();
104: else
105: a0 := JTF_NUMBER_TABLE();
106: a1 := JTF_NUMBER_TABLE();
107: a2 := JTF_NUMBER_TABLE();
101: a17 := JTF_NUMBER_TABLE();
102: a18 := JTF_DATE_TABLE();
103: a19 := JTF_NUMBER_TABLE();
104: else
105: a0 := JTF_NUMBER_TABLE();
106: a1 := JTF_NUMBER_TABLE();
107: a2 := JTF_NUMBER_TABLE();
108: a3 := JTF_NUMBER_TABLE();
109: a4 := JTF_NUMBER_TABLE();
102: a18 := JTF_DATE_TABLE();
103: a19 := JTF_NUMBER_TABLE();
104: else
105: a0 := JTF_NUMBER_TABLE();
106: a1 := JTF_NUMBER_TABLE();
107: a2 := JTF_NUMBER_TABLE();
108: a3 := JTF_NUMBER_TABLE();
109: a4 := JTF_NUMBER_TABLE();
110: a5 := JTF_NUMBER_TABLE();
103: a19 := JTF_NUMBER_TABLE();
104: else
105: a0 := JTF_NUMBER_TABLE();
106: a1 := JTF_NUMBER_TABLE();
107: a2 := JTF_NUMBER_TABLE();
108: a3 := JTF_NUMBER_TABLE();
109: a4 := JTF_NUMBER_TABLE();
110: a5 := JTF_NUMBER_TABLE();
111: a6 := JTF_NUMBER_TABLE();
104: else
105: a0 := JTF_NUMBER_TABLE();
106: a1 := JTF_NUMBER_TABLE();
107: a2 := JTF_NUMBER_TABLE();
108: a3 := JTF_NUMBER_TABLE();
109: a4 := JTF_NUMBER_TABLE();
110: a5 := JTF_NUMBER_TABLE();
111: a6 := JTF_NUMBER_TABLE();
112: a7 := JTF_NUMBER_TABLE();
105: a0 := JTF_NUMBER_TABLE();
106: a1 := JTF_NUMBER_TABLE();
107: a2 := JTF_NUMBER_TABLE();
108: a3 := JTF_NUMBER_TABLE();
109: a4 := JTF_NUMBER_TABLE();
110: a5 := JTF_NUMBER_TABLE();
111: a6 := JTF_NUMBER_TABLE();
112: a7 := JTF_NUMBER_TABLE();
113: a8 := JTF_VARCHAR2_TABLE_100();
106: a1 := JTF_NUMBER_TABLE();
107: a2 := JTF_NUMBER_TABLE();
108: a3 := JTF_NUMBER_TABLE();
109: a4 := JTF_NUMBER_TABLE();
110: a5 := JTF_NUMBER_TABLE();
111: a6 := JTF_NUMBER_TABLE();
112: a7 := JTF_NUMBER_TABLE();
113: a8 := JTF_VARCHAR2_TABLE_100();
114: a9 := JTF_VARCHAR2_TABLE_100();
107: a2 := JTF_NUMBER_TABLE();
108: a3 := JTF_NUMBER_TABLE();
109: a4 := JTF_NUMBER_TABLE();
110: a5 := JTF_NUMBER_TABLE();
111: a6 := JTF_NUMBER_TABLE();
112: a7 := JTF_NUMBER_TABLE();
113: a8 := JTF_VARCHAR2_TABLE_100();
114: a9 := JTF_VARCHAR2_TABLE_100();
115: a10 := JTF_VARCHAR2_TABLE_100();
108: a3 := JTF_NUMBER_TABLE();
109: a4 := JTF_NUMBER_TABLE();
110: a5 := JTF_NUMBER_TABLE();
111: a6 := JTF_NUMBER_TABLE();
112: a7 := JTF_NUMBER_TABLE();
113: a8 := JTF_VARCHAR2_TABLE_100();
114: a9 := JTF_VARCHAR2_TABLE_100();
115: a10 := JTF_VARCHAR2_TABLE_100();
116: a11 := JTF_VARCHAR2_TABLE_100();
115: a10 := JTF_VARCHAR2_TABLE_100();
116: a11 := JTF_VARCHAR2_TABLE_100();
117: a12 := JTF_DATE_TABLE();
118: a13 := JTF_DATE_TABLE();
119: a14 := JTF_NUMBER_TABLE();
120: a15 := JTF_NUMBER_TABLE();
121: a16 := JTF_DATE_TABLE();
122: a17 := JTF_NUMBER_TABLE();
123: a18 := JTF_DATE_TABLE();
116: a11 := JTF_VARCHAR2_TABLE_100();
117: a12 := JTF_DATE_TABLE();
118: a13 := JTF_DATE_TABLE();
119: a14 := JTF_NUMBER_TABLE();
120: a15 := JTF_NUMBER_TABLE();
121: a16 := JTF_DATE_TABLE();
122: a17 := JTF_NUMBER_TABLE();
123: a18 := JTF_DATE_TABLE();
124: a19 := JTF_NUMBER_TABLE();
118: a13 := JTF_DATE_TABLE();
119: a14 := JTF_NUMBER_TABLE();
120: a15 := JTF_NUMBER_TABLE();
121: a16 := JTF_DATE_TABLE();
122: a17 := JTF_NUMBER_TABLE();
123: a18 := JTF_DATE_TABLE();
124: a19 := JTF_NUMBER_TABLE();
125: if t.count > 0 then
126: a0.extend(t.count);
120: a15 := JTF_NUMBER_TABLE();
121: a16 := JTF_DATE_TABLE();
122: a17 := JTF_NUMBER_TABLE();
123: a18 := JTF_DATE_TABLE();
124: a19 := JTF_NUMBER_TABLE();
125: if t.count > 0 then
126: a0.extend(t.count);
127: a1.extend(t.count);
128: a2.extend(t.count);
175: end if;
176: end if;
177: end rosetta_table_copy_out_p1;
178:
179: procedure rosetta_table_copy_in_p3(t out nocopy okl_irh_pvt.okl_irh_tbl, a0 JTF_NUMBER_TABLE
180: , a1 JTF_NUMBER_TABLE
181: , a2 JTF_NUMBER_TABLE
182: , a3 JTF_NUMBER_TABLE
183: , a4 JTF_NUMBER_TABLE
176: end if;
177: end rosetta_table_copy_out_p1;
178:
179: procedure rosetta_table_copy_in_p3(t out nocopy okl_irh_pvt.okl_irh_tbl, a0 JTF_NUMBER_TABLE
180: , a1 JTF_NUMBER_TABLE
181: , a2 JTF_NUMBER_TABLE
182: , a3 JTF_NUMBER_TABLE
183: , a4 JTF_NUMBER_TABLE
184: , a5 JTF_NUMBER_TABLE
177: end rosetta_table_copy_out_p1;
178:
179: procedure rosetta_table_copy_in_p3(t out nocopy okl_irh_pvt.okl_irh_tbl, a0 JTF_NUMBER_TABLE
180: , a1 JTF_NUMBER_TABLE
181: , a2 JTF_NUMBER_TABLE
182: , a3 JTF_NUMBER_TABLE
183: , a4 JTF_NUMBER_TABLE
184: , a5 JTF_NUMBER_TABLE
185: , a6 JTF_NUMBER_TABLE
178:
179: procedure rosetta_table_copy_in_p3(t out nocopy okl_irh_pvt.okl_irh_tbl, a0 JTF_NUMBER_TABLE
180: , a1 JTF_NUMBER_TABLE
181: , a2 JTF_NUMBER_TABLE
182: , a3 JTF_NUMBER_TABLE
183: , a4 JTF_NUMBER_TABLE
184: , a5 JTF_NUMBER_TABLE
185: , a6 JTF_NUMBER_TABLE
186: , a7 JTF_NUMBER_TABLE
179: procedure rosetta_table_copy_in_p3(t out nocopy okl_irh_pvt.okl_irh_tbl, a0 JTF_NUMBER_TABLE
180: , a1 JTF_NUMBER_TABLE
181: , a2 JTF_NUMBER_TABLE
182: , a3 JTF_NUMBER_TABLE
183: , a4 JTF_NUMBER_TABLE
184: , a5 JTF_NUMBER_TABLE
185: , a6 JTF_NUMBER_TABLE
186: , a7 JTF_NUMBER_TABLE
187: , a8 JTF_VARCHAR2_TABLE_100
180: , a1 JTF_NUMBER_TABLE
181: , a2 JTF_NUMBER_TABLE
182: , a3 JTF_NUMBER_TABLE
183: , a4 JTF_NUMBER_TABLE
184: , a5 JTF_NUMBER_TABLE
185: , a6 JTF_NUMBER_TABLE
186: , a7 JTF_NUMBER_TABLE
187: , a8 JTF_VARCHAR2_TABLE_100
188: , a9 JTF_VARCHAR2_TABLE_100
181: , a2 JTF_NUMBER_TABLE
182: , a3 JTF_NUMBER_TABLE
183: , a4 JTF_NUMBER_TABLE
184: , a5 JTF_NUMBER_TABLE
185: , a6 JTF_NUMBER_TABLE
186: , a7 JTF_NUMBER_TABLE
187: , a8 JTF_VARCHAR2_TABLE_100
188: , a9 JTF_VARCHAR2_TABLE_100
189: , a10 JTF_VARCHAR2_TABLE_100
182: , a3 JTF_NUMBER_TABLE
183: , a4 JTF_NUMBER_TABLE
184: , a5 JTF_NUMBER_TABLE
185: , a6 JTF_NUMBER_TABLE
186: , a7 JTF_NUMBER_TABLE
187: , a8 JTF_VARCHAR2_TABLE_100
188: , a9 JTF_VARCHAR2_TABLE_100
189: , a10 JTF_VARCHAR2_TABLE_100
190: , a11 JTF_VARCHAR2_TABLE_100
189: , a10 JTF_VARCHAR2_TABLE_100
190: , a11 JTF_VARCHAR2_TABLE_100
191: , a12 JTF_DATE_TABLE
192: , a13 JTF_DATE_TABLE
193: , a14 JTF_NUMBER_TABLE
194: , a15 JTF_NUMBER_TABLE
195: , a16 JTF_DATE_TABLE
196: , a17 JTF_NUMBER_TABLE
197: , a18 JTF_DATE_TABLE
190: , a11 JTF_VARCHAR2_TABLE_100
191: , a12 JTF_DATE_TABLE
192: , a13 JTF_DATE_TABLE
193: , a14 JTF_NUMBER_TABLE
194: , a15 JTF_NUMBER_TABLE
195: , a16 JTF_DATE_TABLE
196: , a17 JTF_NUMBER_TABLE
197: , a18 JTF_DATE_TABLE
198: , a19 JTF_NUMBER_TABLE
192: , a13 JTF_DATE_TABLE
193: , a14 JTF_NUMBER_TABLE
194: , a15 JTF_NUMBER_TABLE
195: , a16 JTF_DATE_TABLE
196: , a17 JTF_NUMBER_TABLE
197: , a18 JTF_DATE_TABLE
198: , a19 JTF_NUMBER_TABLE
199: ) as
200: ddindx binary_integer; indx binary_integer;
194: , a15 JTF_NUMBER_TABLE
195: , a16 JTF_DATE_TABLE
196: , a17 JTF_NUMBER_TABLE
197: , a18 JTF_DATE_TABLE
198: , a19 JTF_NUMBER_TABLE
199: ) as
200: ddindx binary_integer; indx binary_integer;
201: begin
202: if a0 is not null and a0.count > 0 then
232: end loop;
233: end if;
234: end if;
235: end rosetta_table_copy_in_p3;
236: procedure rosetta_table_copy_out_p3(t okl_irh_pvt.okl_irh_tbl, a0 out nocopy JTF_NUMBER_TABLE
237: , a1 out nocopy JTF_NUMBER_TABLE
238: , a2 out nocopy JTF_NUMBER_TABLE
239: , a3 out nocopy JTF_NUMBER_TABLE
240: , a4 out nocopy JTF_NUMBER_TABLE
233: end if;
234: end if;
235: end rosetta_table_copy_in_p3;
236: procedure rosetta_table_copy_out_p3(t okl_irh_pvt.okl_irh_tbl, a0 out nocopy JTF_NUMBER_TABLE
237: , a1 out nocopy JTF_NUMBER_TABLE
238: , a2 out nocopy JTF_NUMBER_TABLE
239: , a3 out nocopy JTF_NUMBER_TABLE
240: , a4 out nocopy JTF_NUMBER_TABLE
241: , a5 out nocopy JTF_NUMBER_TABLE
234: end if;
235: end rosetta_table_copy_in_p3;
236: procedure rosetta_table_copy_out_p3(t okl_irh_pvt.okl_irh_tbl, a0 out nocopy JTF_NUMBER_TABLE
237: , a1 out nocopy JTF_NUMBER_TABLE
238: , a2 out nocopy JTF_NUMBER_TABLE
239: , a3 out nocopy JTF_NUMBER_TABLE
240: , a4 out nocopy JTF_NUMBER_TABLE
241: , a5 out nocopy JTF_NUMBER_TABLE
242: , a6 out nocopy JTF_NUMBER_TABLE
235: end rosetta_table_copy_in_p3;
236: procedure rosetta_table_copy_out_p3(t okl_irh_pvt.okl_irh_tbl, a0 out nocopy JTF_NUMBER_TABLE
237: , a1 out nocopy JTF_NUMBER_TABLE
238: , a2 out nocopy JTF_NUMBER_TABLE
239: , a3 out nocopy JTF_NUMBER_TABLE
240: , a4 out nocopy JTF_NUMBER_TABLE
241: , a5 out nocopy JTF_NUMBER_TABLE
242: , a6 out nocopy JTF_NUMBER_TABLE
243: , a7 out nocopy JTF_NUMBER_TABLE
236: procedure rosetta_table_copy_out_p3(t okl_irh_pvt.okl_irh_tbl, a0 out nocopy JTF_NUMBER_TABLE
237: , a1 out nocopy JTF_NUMBER_TABLE
238: , a2 out nocopy JTF_NUMBER_TABLE
239: , a3 out nocopy JTF_NUMBER_TABLE
240: , a4 out nocopy JTF_NUMBER_TABLE
241: , a5 out nocopy JTF_NUMBER_TABLE
242: , a6 out nocopy JTF_NUMBER_TABLE
243: , a7 out nocopy JTF_NUMBER_TABLE
244: , a8 out nocopy JTF_VARCHAR2_TABLE_100
237: , a1 out nocopy JTF_NUMBER_TABLE
238: , a2 out nocopy JTF_NUMBER_TABLE
239: , a3 out nocopy JTF_NUMBER_TABLE
240: , a4 out nocopy JTF_NUMBER_TABLE
241: , a5 out nocopy JTF_NUMBER_TABLE
242: , a6 out nocopy JTF_NUMBER_TABLE
243: , a7 out nocopy JTF_NUMBER_TABLE
244: , a8 out nocopy JTF_VARCHAR2_TABLE_100
245: , a9 out nocopy JTF_VARCHAR2_TABLE_100
238: , a2 out nocopy JTF_NUMBER_TABLE
239: , a3 out nocopy JTF_NUMBER_TABLE
240: , a4 out nocopy JTF_NUMBER_TABLE
241: , a5 out nocopy JTF_NUMBER_TABLE
242: , a6 out nocopy JTF_NUMBER_TABLE
243: , a7 out nocopy JTF_NUMBER_TABLE
244: , a8 out nocopy JTF_VARCHAR2_TABLE_100
245: , a9 out nocopy JTF_VARCHAR2_TABLE_100
246: , a10 out nocopy JTF_VARCHAR2_TABLE_100
239: , a3 out nocopy JTF_NUMBER_TABLE
240: , a4 out nocopy JTF_NUMBER_TABLE
241: , a5 out nocopy JTF_NUMBER_TABLE
242: , a6 out nocopy JTF_NUMBER_TABLE
243: , a7 out nocopy JTF_NUMBER_TABLE
244: , a8 out nocopy JTF_VARCHAR2_TABLE_100
245: , a9 out nocopy JTF_VARCHAR2_TABLE_100
246: , a10 out nocopy JTF_VARCHAR2_TABLE_100
247: , a11 out nocopy JTF_VARCHAR2_TABLE_100
246: , a10 out nocopy JTF_VARCHAR2_TABLE_100
247: , a11 out nocopy JTF_VARCHAR2_TABLE_100
248: , a12 out nocopy JTF_DATE_TABLE
249: , a13 out nocopy JTF_DATE_TABLE
250: , a14 out nocopy JTF_NUMBER_TABLE
251: , a15 out nocopy JTF_NUMBER_TABLE
252: , a16 out nocopy JTF_DATE_TABLE
253: , a17 out nocopy JTF_NUMBER_TABLE
254: , a18 out nocopy JTF_DATE_TABLE
247: , a11 out nocopy JTF_VARCHAR2_TABLE_100
248: , a12 out nocopy JTF_DATE_TABLE
249: , a13 out nocopy JTF_DATE_TABLE
250: , a14 out nocopy JTF_NUMBER_TABLE
251: , a15 out nocopy JTF_NUMBER_TABLE
252: , a16 out nocopy JTF_DATE_TABLE
253: , a17 out nocopy JTF_NUMBER_TABLE
254: , a18 out nocopy JTF_DATE_TABLE
255: , a19 out nocopy JTF_NUMBER_TABLE
249: , a13 out nocopy JTF_DATE_TABLE
250: , a14 out nocopy JTF_NUMBER_TABLE
251: , a15 out nocopy JTF_NUMBER_TABLE
252: , a16 out nocopy JTF_DATE_TABLE
253: , a17 out nocopy JTF_NUMBER_TABLE
254: , a18 out nocopy JTF_DATE_TABLE
255: , a19 out nocopy JTF_NUMBER_TABLE
256: ) as
257: ddindx binary_integer; indx binary_integer;
251: , a15 out nocopy JTF_NUMBER_TABLE
252: , a16 out nocopy JTF_DATE_TABLE
253: , a17 out nocopy JTF_NUMBER_TABLE
254: , a18 out nocopy JTF_DATE_TABLE
255: , a19 out nocopy JTF_NUMBER_TABLE
256: ) as
257: ddindx binary_integer; indx binary_integer;
258: begin
259: if t is null or t.count = 0 then
256: ) as
257: ddindx binary_integer; indx binary_integer;
258: begin
259: if t is null or t.count = 0 then
260: a0 := JTF_NUMBER_TABLE();
261: a1 := JTF_NUMBER_TABLE();
262: a2 := JTF_NUMBER_TABLE();
263: a3 := JTF_NUMBER_TABLE();
264: a4 := JTF_NUMBER_TABLE();
257: ddindx binary_integer; indx binary_integer;
258: begin
259: if t is null or t.count = 0 then
260: a0 := JTF_NUMBER_TABLE();
261: a1 := JTF_NUMBER_TABLE();
262: a2 := JTF_NUMBER_TABLE();
263: a3 := JTF_NUMBER_TABLE();
264: a4 := JTF_NUMBER_TABLE();
265: a5 := JTF_NUMBER_TABLE();
258: begin
259: if t is null or t.count = 0 then
260: a0 := JTF_NUMBER_TABLE();
261: a1 := JTF_NUMBER_TABLE();
262: a2 := JTF_NUMBER_TABLE();
263: a3 := JTF_NUMBER_TABLE();
264: a4 := JTF_NUMBER_TABLE();
265: a5 := JTF_NUMBER_TABLE();
266: a6 := JTF_NUMBER_TABLE();
259: if t is null or t.count = 0 then
260: a0 := JTF_NUMBER_TABLE();
261: a1 := JTF_NUMBER_TABLE();
262: a2 := JTF_NUMBER_TABLE();
263: a3 := JTF_NUMBER_TABLE();
264: a4 := JTF_NUMBER_TABLE();
265: a5 := JTF_NUMBER_TABLE();
266: a6 := JTF_NUMBER_TABLE();
267: a7 := JTF_NUMBER_TABLE();
260: a0 := JTF_NUMBER_TABLE();
261: a1 := JTF_NUMBER_TABLE();
262: a2 := JTF_NUMBER_TABLE();
263: a3 := JTF_NUMBER_TABLE();
264: a4 := JTF_NUMBER_TABLE();
265: a5 := JTF_NUMBER_TABLE();
266: a6 := JTF_NUMBER_TABLE();
267: a7 := JTF_NUMBER_TABLE();
268: a8 := JTF_VARCHAR2_TABLE_100();
261: a1 := JTF_NUMBER_TABLE();
262: a2 := JTF_NUMBER_TABLE();
263: a3 := JTF_NUMBER_TABLE();
264: a4 := JTF_NUMBER_TABLE();
265: a5 := JTF_NUMBER_TABLE();
266: a6 := JTF_NUMBER_TABLE();
267: a7 := JTF_NUMBER_TABLE();
268: a8 := JTF_VARCHAR2_TABLE_100();
269: a9 := JTF_VARCHAR2_TABLE_100();
262: a2 := JTF_NUMBER_TABLE();
263: a3 := JTF_NUMBER_TABLE();
264: a4 := JTF_NUMBER_TABLE();
265: a5 := JTF_NUMBER_TABLE();
266: a6 := JTF_NUMBER_TABLE();
267: a7 := JTF_NUMBER_TABLE();
268: a8 := JTF_VARCHAR2_TABLE_100();
269: a9 := JTF_VARCHAR2_TABLE_100();
270: a10 := JTF_VARCHAR2_TABLE_100();
263: a3 := JTF_NUMBER_TABLE();
264: a4 := JTF_NUMBER_TABLE();
265: a5 := JTF_NUMBER_TABLE();
266: a6 := JTF_NUMBER_TABLE();
267: a7 := JTF_NUMBER_TABLE();
268: a8 := JTF_VARCHAR2_TABLE_100();
269: a9 := JTF_VARCHAR2_TABLE_100();
270: a10 := JTF_VARCHAR2_TABLE_100();
271: a11 := JTF_VARCHAR2_TABLE_100();
270: a10 := JTF_VARCHAR2_TABLE_100();
271: a11 := JTF_VARCHAR2_TABLE_100();
272: a12 := JTF_DATE_TABLE();
273: a13 := JTF_DATE_TABLE();
274: a14 := JTF_NUMBER_TABLE();
275: a15 := JTF_NUMBER_TABLE();
276: a16 := JTF_DATE_TABLE();
277: a17 := JTF_NUMBER_TABLE();
278: a18 := JTF_DATE_TABLE();
271: a11 := JTF_VARCHAR2_TABLE_100();
272: a12 := JTF_DATE_TABLE();
273: a13 := JTF_DATE_TABLE();
274: a14 := JTF_NUMBER_TABLE();
275: a15 := JTF_NUMBER_TABLE();
276: a16 := JTF_DATE_TABLE();
277: a17 := JTF_NUMBER_TABLE();
278: a18 := JTF_DATE_TABLE();
279: a19 := JTF_NUMBER_TABLE();
273: a13 := JTF_DATE_TABLE();
274: a14 := JTF_NUMBER_TABLE();
275: a15 := JTF_NUMBER_TABLE();
276: a16 := JTF_DATE_TABLE();
277: a17 := JTF_NUMBER_TABLE();
278: a18 := JTF_DATE_TABLE();
279: a19 := JTF_NUMBER_TABLE();
280: else
281: a0 := JTF_NUMBER_TABLE();
275: a15 := JTF_NUMBER_TABLE();
276: a16 := JTF_DATE_TABLE();
277: a17 := JTF_NUMBER_TABLE();
278: a18 := JTF_DATE_TABLE();
279: a19 := JTF_NUMBER_TABLE();
280: else
281: a0 := JTF_NUMBER_TABLE();
282: a1 := JTF_NUMBER_TABLE();
283: a2 := JTF_NUMBER_TABLE();
277: a17 := JTF_NUMBER_TABLE();
278: a18 := JTF_DATE_TABLE();
279: a19 := JTF_NUMBER_TABLE();
280: else
281: a0 := JTF_NUMBER_TABLE();
282: a1 := JTF_NUMBER_TABLE();
283: a2 := JTF_NUMBER_TABLE();
284: a3 := JTF_NUMBER_TABLE();
285: a4 := JTF_NUMBER_TABLE();
278: a18 := JTF_DATE_TABLE();
279: a19 := JTF_NUMBER_TABLE();
280: else
281: a0 := JTF_NUMBER_TABLE();
282: a1 := JTF_NUMBER_TABLE();
283: a2 := JTF_NUMBER_TABLE();
284: a3 := JTF_NUMBER_TABLE();
285: a4 := JTF_NUMBER_TABLE();
286: a5 := JTF_NUMBER_TABLE();
279: a19 := JTF_NUMBER_TABLE();
280: else
281: a0 := JTF_NUMBER_TABLE();
282: a1 := JTF_NUMBER_TABLE();
283: a2 := JTF_NUMBER_TABLE();
284: a3 := JTF_NUMBER_TABLE();
285: a4 := JTF_NUMBER_TABLE();
286: a5 := JTF_NUMBER_TABLE();
287: a6 := JTF_NUMBER_TABLE();
280: else
281: a0 := JTF_NUMBER_TABLE();
282: a1 := JTF_NUMBER_TABLE();
283: a2 := JTF_NUMBER_TABLE();
284: a3 := JTF_NUMBER_TABLE();
285: a4 := JTF_NUMBER_TABLE();
286: a5 := JTF_NUMBER_TABLE();
287: a6 := JTF_NUMBER_TABLE();
288: a7 := JTF_NUMBER_TABLE();
281: a0 := JTF_NUMBER_TABLE();
282: a1 := JTF_NUMBER_TABLE();
283: a2 := JTF_NUMBER_TABLE();
284: a3 := JTF_NUMBER_TABLE();
285: a4 := JTF_NUMBER_TABLE();
286: a5 := JTF_NUMBER_TABLE();
287: a6 := JTF_NUMBER_TABLE();
288: a7 := JTF_NUMBER_TABLE();
289: a8 := JTF_VARCHAR2_TABLE_100();
282: a1 := JTF_NUMBER_TABLE();
283: a2 := JTF_NUMBER_TABLE();
284: a3 := JTF_NUMBER_TABLE();
285: a4 := JTF_NUMBER_TABLE();
286: a5 := JTF_NUMBER_TABLE();
287: a6 := JTF_NUMBER_TABLE();
288: a7 := JTF_NUMBER_TABLE();
289: a8 := JTF_VARCHAR2_TABLE_100();
290: a9 := JTF_VARCHAR2_TABLE_100();
283: a2 := JTF_NUMBER_TABLE();
284: a3 := JTF_NUMBER_TABLE();
285: a4 := JTF_NUMBER_TABLE();
286: a5 := JTF_NUMBER_TABLE();
287: a6 := JTF_NUMBER_TABLE();
288: a7 := JTF_NUMBER_TABLE();
289: a8 := JTF_VARCHAR2_TABLE_100();
290: a9 := JTF_VARCHAR2_TABLE_100();
291: a10 := JTF_VARCHAR2_TABLE_100();
284: a3 := JTF_NUMBER_TABLE();
285: a4 := JTF_NUMBER_TABLE();
286: a5 := JTF_NUMBER_TABLE();
287: a6 := JTF_NUMBER_TABLE();
288: a7 := JTF_NUMBER_TABLE();
289: a8 := JTF_VARCHAR2_TABLE_100();
290: a9 := JTF_VARCHAR2_TABLE_100();
291: a10 := JTF_VARCHAR2_TABLE_100();
292: a11 := JTF_VARCHAR2_TABLE_100();
291: a10 := JTF_VARCHAR2_TABLE_100();
292: a11 := JTF_VARCHAR2_TABLE_100();
293: a12 := JTF_DATE_TABLE();
294: a13 := JTF_DATE_TABLE();
295: a14 := JTF_NUMBER_TABLE();
296: a15 := JTF_NUMBER_TABLE();
297: a16 := JTF_DATE_TABLE();
298: a17 := JTF_NUMBER_TABLE();
299: a18 := JTF_DATE_TABLE();
292: a11 := JTF_VARCHAR2_TABLE_100();
293: a12 := JTF_DATE_TABLE();
294: a13 := JTF_DATE_TABLE();
295: a14 := JTF_NUMBER_TABLE();
296: a15 := JTF_NUMBER_TABLE();
297: a16 := JTF_DATE_TABLE();
298: a17 := JTF_NUMBER_TABLE();
299: a18 := JTF_DATE_TABLE();
300: a19 := JTF_NUMBER_TABLE();
294: a13 := JTF_DATE_TABLE();
295: a14 := JTF_NUMBER_TABLE();
296: a15 := JTF_NUMBER_TABLE();
297: a16 := JTF_DATE_TABLE();
298: a17 := JTF_NUMBER_TABLE();
299: a18 := JTF_DATE_TABLE();
300: a19 := JTF_NUMBER_TABLE();
301: if t.count > 0 then
302: a0.extend(t.count);
296: a15 := JTF_NUMBER_TABLE();
297: a16 := JTF_DATE_TABLE();
298: a17 := JTF_NUMBER_TABLE();
299: a18 := JTF_DATE_TABLE();
300: a19 := JTF_NUMBER_TABLE();
301: if t.count > 0 then
302: a0.extend(t.count);
303: a1.extend(t.count);
304: a2.extend(t.count);
475: , p_init_msg_list VARCHAR2
476: , x_return_status out nocopy VARCHAR2
477: , x_msg_count out nocopy NUMBER
478: , x_msg_data out nocopy VARCHAR2
479: , p5_a0 JTF_NUMBER_TABLE
480: , p5_a1 JTF_NUMBER_TABLE
481: , p5_a2 JTF_NUMBER_TABLE
482: , p5_a3 JTF_NUMBER_TABLE
483: , p5_a4 JTF_NUMBER_TABLE
476: , x_return_status out nocopy VARCHAR2
477: , x_msg_count out nocopy NUMBER
478: , x_msg_data out nocopy VARCHAR2
479: , p5_a0 JTF_NUMBER_TABLE
480: , p5_a1 JTF_NUMBER_TABLE
481: , p5_a2 JTF_NUMBER_TABLE
482: , p5_a3 JTF_NUMBER_TABLE
483: , p5_a4 JTF_NUMBER_TABLE
484: , p5_a5 JTF_NUMBER_TABLE
477: , x_msg_count out nocopy NUMBER
478: , x_msg_data out nocopy VARCHAR2
479: , p5_a0 JTF_NUMBER_TABLE
480: , p5_a1 JTF_NUMBER_TABLE
481: , p5_a2 JTF_NUMBER_TABLE
482: , p5_a3 JTF_NUMBER_TABLE
483: , p5_a4 JTF_NUMBER_TABLE
484: , p5_a5 JTF_NUMBER_TABLE
485: , p5_a6 JTF_NUMBER_TABLE
478: , x_msg_data out nocopy VARCHAR2
479: , p5_a0 JTF_NUMBER_TABLE
480: , p5_a1 JTF_NUMBER_TABLE
481: , p5_a2 JTF_NUMBER_TABLE
482: , p5_a3 JTF_NUMBER_TABLE
483: , p5_a4 JTF_NUMBER_TABLE
484: , p5_a5 JTF_NUMBER_TABLE
485: , p5_a6 JTF_NUMBER_TABLE
486: , p5_a7 JTF_NUMBER_TABLE
479: , p5_a0 JTF_NUMBER_TABLE
480: , p5_a1 JTF_NUMBER_TABLE
481: , p5_a2 JTF_NUMBER_TABLE
482: , p5_a3 JTF_NUMBER_TABLE
483: , p5_a4 JTF_NUMBER_TABLE
484: , p5_a5 JTF_NUMBER_TABLE
485: , p5_a6 JTF_NUMBER_TABLE
486: , p5_a7 JTF_NUMBER_TABLE
487: , p5_a8 JTF_VARCHAR2_TABLE_100
480: , p5_a1 JTF_NUMBER_TABLE
481: , p5_a2 JTF_NUMBER_TABLE
482: , p5_a3 JTF_NUMBER_TABLE
483: , p5_a4 JTF_NUMBER_TABLE
484: , p5_a5 JTF_NUMBER_TABLE
485: , p5_a6 JTF_NUMBER_TABLE
486: , p5_a7 JTF_NUMBER_TABLE
487: , p5_a8 JTF_VARCHAR2_TABLE_100
488: , p5_a9 JTF_VARCHAR2_TABLE_100
481: , p5_a2 JTF_NUMBER_TABLE
482: , p5_a3 JTF_NUMBER_TABLE
483: , p5_a4 JTF_NUMBER_TABLE
484: , p5_a5 JTF_NUMBER_TABLE
485: , p5_a6 JTF_NUMBER_TABLE
486: , p5_a7 JTF_NUMBER_TABLE
487: , p5_a8 JTF_VARCHAR2_TABLE_100
488: , p5_a9 JTF_VARCHAR2_TABLE_100
489: , p5_a10 JTF_VARCHAR2_TABLE_100
482: , p5_a3 JTF_NUMBER_TABLE
483: , p5_a4 JTF_NUMBER_TABLE
484: , p5_a5 JTF_NUMBER_TABLE
485: , p5_a6 JTF_NUMBER_TABLE
486: , p5_a7 JTF_NUMBER_TABLE
487: , p5_a8 JTF_VARCHAR2_TABLE_100
488: , p5_a9 JTF_VARCHAR2_TABLE_100
489: , p5_a10 JTF_VARCHAR2_TABLE_100
490: , p5_a11 JTF_VARCHAR2_TABLE_100
489: , p5_a10 JTF_VARCHAR2_TABLE_100
490: , p5_a11 JTF_VARCHAR2_TABLE_100
491: , p5_a12 JTF_DATE_TABLE
492: , p5_a13 JTF_DATE_TABLE
493: , p5_a14 JTF_NUMBER_TABLE
494: , p5_a15 JTF_NUMBER_TABLE
495: , p5_a16 JTF_DATE_TABLE
496: , p5_a17 JTF_NUMBER_TABLE
497: , p5_a18 JTF_DATE_TABLE
490: , p5_a11 JTF_VARCHAR2_TABLE_100
491: , p5_a12 JTF_DATE_TABLE
492: , p5_a13 JTF_DATE_TABLE
493: , p5_a14 JTF_NUMBER_TABLE
494: , p5_a15 JTF_NUMBER_TABLE
495: , p5_a16 JTF_DATE_TABLE
496: , p5_a17 JTF_NUMBER_TABLE
497: , p5_a18 JTF_DATE_TABLE
498: , p5_a19 JTF_NUMBER_TABLE
492: , p5_a13 JTF_DATE_TABLE
493: , p5_a14 JTF_NUMBER_TABLE
494: , p5_a15 JTF_NUMBER_TABLE
495: , p5_a16 JTF_DATE_TABLE
496: , p5_a17 JTF_NUMBER_TABLE
497: , p5_a18 JTF_DATE_TABLE
498: , p5_a19 JTF_NUMBER_TABLE
499: , p6_a0 out nocopy JTF_NUMBER_TABLE
500: , p6_a1 out nocopy JTF_NUMBER_TABLE
494: , p5_a15 JTF_NUMBER_TABLE
495: , p5_a16 JTF_DATE_TABLE
496: , p5_a17 JTF_NUMBER_TABLE
497: , p5_a18 JTF_DATE_TABLE
498: , p5_a19 JTF_NUMBER_TABLE
499: , p6_a0 out nocopy JTF_NUMBER_TABLE
500: , p6_a1 out nocopy JTF_NUMBER_TABLE
501: , p6_a2 out nocopy JTF_NUMBER_TABLE
502: , p6_a3 out nocopy JTF_NUMBER_TABLE
495: , p5_a16 JTF_DATE_TABLE
496: , p5_a17 JTF_NUMBER_TABLE
497: , p5_a18 JTF_DATE_TABLE
498: , p5_a19 JTF_NUMBER_TABLE
499: , p6_a0 out nocopy JTF_NUMBER_TABLE
500: , p6_a1 out nocopy JTF_NUMBER_TABLE
501: , p6_a2 out nocopy JTF_NUMBER_TABLE
502: , p6_a3 out nocopy JTF_NUMBER_TABLE
503: , p6_a4 out nocopy JTF_NUMBER_TABLE
496: , p5_a17 JTF_NUMBER_TABLE
497: , p5_a18 JTF_DATE_TABLE
498: , p5_a19 JTF_NUMBER_TABLE
499: , p6_a0 out nocopy JTF_NUMBER_TABLE
500: , p6_a1 out nocopy JTF_NUMBER_TABLE
501: , p6_a2 out nocopy JTF_NUMBER_TABLE
502: , p6_a3 out nocopy JTF_NUMBER_TABLE
503: , p6_a4 out nocopy JTF_NUMBER_TABLE
504: , p6_a5 out nocopy JTF_NUMBER_TABLE
497: , p5_a18 JTF_DATE_TABLE
498: , p5_a19 JTF_NUMBER_TABLE
499: , p6_a0 out nocopy JTF_NUMBER_TABLE
500: , p6_a1 out nocopy JTF_NUMBER_TABLE
501: , p6_a2 out nocopy JTF_NUMBER_TABLE
502: , p6_a3 out nocopy JTF_NUMBER_TABLE
503: , p6_a4 out nocopy JTF_NUMBER_TABLE
504: , p6_a5 out nocopy JTF_NUMBER_TABLE
505: , p6_a6 out nocopy JTF_NUMBER_TABLE
498: , p5_a19 JTF_NUMBER_TABLE
499: , p6_a0 out nocopy JTF_NUMBER_TABLE
500: , p6_a1 out nocopy JTF_NUMBER_TABLE
501: , p6_a2 out nocopy JTF_NUMBER_TABLE
502: , p6_a3 out nocopy JTF_NUMBER_TABLE
503: , p6_a4 out nocopy JTF_NUMBER_TABLE
504: , p6_a5 out nocopy JTF_NUMBER_TABLE
505: , p6_a6 out nocopy JTF_NUMBER_TABLE
506: , p6_a7 out nocopy JTF_NUMBER_TABLE
499: , p6_a0 out nocopy JTF_NUMBER_TABLE
500: , p6_a1 out nocopy JTF_NUMBER_TABLE
501: , p6_a2 out nocopy JTF_NUMBER_TABLE
502: , p6_a3 out nocopy JTF_NUMBER_TABLE
503: , p6_a4 out nocopy JTF_NUMBER_TABLE
504: , p6_a5 out nocopy JTF_NUMBER_TABLE
505: , p6_a6 out nocopy JTF_NUMBER_TABLE
506: , p6_a7 out nocopy JTF_NUMBER_TABLE
507: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
500: , p6_a1 out nocopy JTF_NUMBER_TABLE
501: , p6_a2 out nocopy JTF_NUMBER_TABLE
502: , p6_a3 out nocopy JTF_NUMBER_TABLE
503: , p6_a4 out nocopy JTF_NUMBER_TABLE
504: , p6_a5 out nocopy JTF_NUMBER_TABLE
505: , p6_a6 out nocopy JTF_NUMBER_TABLE
506: , p6_a7 out nocopy JTF_NUMBER_TABLE
507: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
508: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
501: , p6_a2 out nocopy JTF_NUMBER_TABLE
502: , p6_a3 out nocopy JTF_NUMBER_TABLE
503: , p6_a4 out nocopy JTF_NUMBER_TABLE
504: , p6_a5 out nocopy JTF_NUMBER_TABLE
505: , p6_a6 out nocopy JTF_NUMBER_TABLE
506: , p6_a7 out nocopy JTF_NUMBER_TABLE
507: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
508: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
509: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
502: , p6_a3 out nocopy JTF_NUMBER_TABLE
503: , p6_a4 out nocopy JTF_NUMBER_TABLE
504: , p6_a5 out nocopy JTF_NUMBER_TABLE
505: , p6_a6 out nocopy JTF_NUMBER_TABLE
506: , p6_a7 out nocopy JTF_NUMBER_TABLE
507: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
508: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
509: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
510: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
509: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
510: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
511: , p6_a12 out nocopy JTF_DATE_TABLE
512: , p6_a13 out nocopy JTF_DATE_TABLE
513: , p6_a14 out nocopy JTF_NUMBER_TABLE
514: , p6_a15 out nocopy JTF_NUMBER_TABLE
515: , p6_a16 out nocopy JTF_DATE_TABLE
516: , p6_a17 out nocopy JTF_NUMBER_TABLE
517: , p6_a18 out nocopy JTF_DATE_TABLE
510: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
511: , p6_a12 out nocopy JTF_DATE_TABLE
512: , p6_a13 out nocopy JTF_DATE_TABLE
513: , p6_a14 out nocopy JTF_NUMBER_TABLE
514: , p6_a15 out nocopy JTF_NUMBER_TABLE
515: , p6_a16 out nocopy JTF_DATE_TABLE
516: , p6_a17 out nocopy JTF_NUMBER_TABLE
517: , p6_a18 out nocopy JTF_DATE_TABLE
518: , p6_a19 out nocopy JTF_NUMBER_TABLE
512: , p6_a13 out nocopy JTF_DATE_TABLE
513: , p6_a14 out nocopy JTF_NUMBER_TABLE
514: , p6_a15 out nocopy JTF_NUMBER_TABLE
515: , p6_a16 out nocopy JTF_DATE_TABLE
516: , p6_a17 out nocopy JTF_NUMBER_TABLE
517: , p6_a18 out nocopy JTF_DATE_TABLE
518: , p6_a19 out nocopy JTF_NUMBER_TABLE
519: )
520:
514: , p6_a15 out nocopy JTF_NUMBER_TABLE
515: , p6_a16 out nocopy JTF_DATE_TABLE
516: , p6_a17 out nocopy JTF_NUMBER_TABLE
517: , p6_a18 out nocopy JTF_DATE_TABLE
518: , p6_a19 out nocopy JTF_NUMBER_TABLE
519: )
520:
521: as
522: ddp_irhv_tbl okl_irh_pvt.okl_irhv_tbl;
715: , p_init_msg_list VARCHAR2
716: , x_return_status out nocopy VARCHAR2
717: , x_msg_count out nocopy NUMBER
718: , x_msg_data out nocopy VARCHAR2
719: , p5_a0 JTF_NUMBER_TABLE
720: , p5_a1 JTF_NUMBER_TABLE
721: , p5_a2 JTF_NUMBER_TABLE
722: , p5_a3 JTF_NUMBER_TABLE
723: , p5_a4 JTF_NUMBER_TABLE
716: , x_return_status out nocopy VARCHAR2
717: , x_msg_count out nocopy NUMBER
718: , x_msg_data out nocopy VARCHAR2
719: , p5_a0 JTF_NUMBER_TABLE
720: , p5_a1 JTF_NUMBER_TABLE
721: , p5_a2 JTF_NUMBER_TABLE
722: , p5_a3 JTF_NUMBER_TABLE
723: , p5_a4 JTF_NUMBER_TABLE
724: , p5_a5 JTF_NUMBER_TABLE
717: , x_msg_count out nocopy NUMBER
718: , x_msg_data out nocopy VARCHAR2
719: , p5_a0 JTF_NUMBER_TABLE
720: , p5_a1 JTF_NUMBER_TABLE
721: , p5_a2 JTF_NUMBER_TABLE
722: , p5_a3 JTF_NUMBER_TABLE
723: , p5_a4 JTF_NUMBER_TABLE
724: , p5_a5 JTF_NUMBER_TABLE
725: , p5_a6 JTF_NUMBER_TABLE
718: , x_msg_data out nocopy VARCHAR2
719: , p5_a0 JTF_NUMBER_TABLE
720: , p5_a1 JTF_NUMBER_TABLE
721: , p5_a2 JTF_NUMBER_TABLE
722: , p5_a3 JTF_NUMBER_TABLE
723: , p5_a4 JTF_NUMBER_TABLE
724: , p5_a5 JTF_NUMBER_TABLE
725: , p5_a6 JTF_NUMBER_TABLE
726: , p5_a7 JTF_NUMBER_TABLE
719: , p5_a0 JTF_NUMBER_TABLE
720: , p5_a1 JTF_NUMBER_TABLE
721: , p5_a2 JTF_NUMBER_TABLE
722: , p5_a3 JTF_NUMBER_TABLE
723: , p5_a4 JTF_NUMBER_TABLE
724: , p5_a5 JTF_NUMBER_TABLE
725: , p5_a6 JTF_NUMBER_TABLE
726: , p5_a7 JTF_NUMBER_TABLE
727: , p5_a8 JTF_VARCHAR2_TABLE_100
720: , p5_a1 JTF_NUMBER_TABLE
721: , p5_a2 JTF_NUMBER_TABLE
722: , p5_a3 JTF_NUMBER_TABLE
723: , p5_a4 JTF_NUMBER_TABLE
724: , p5_a5 JTF_NUMBER_TABLE
725: , p5_a6 JTF_NUMBER_TABLE
726: , p5_a7 JTF_NUMBER_TABLE
727: , p5_a8 JTF_VARCHAR2_TABLE_100
728: , p5_a9 JTF_VARCHAR2_TABLE_100
721: , p5_a2 JTF_NUMBER_TABLE
722: , p5_a3 JTF_NUMBER_TABLE
723: , p5_a4 JTF_NUMBER_TABLE
724: , p5_a5 JTF_NUMBER_TABLE
725: , p5_a6 JTF_NUMBER_TABLE
726: , p5_a7 JTF_NUMBER_TABLE
727: , p5_a8 JTF_VARCHAR2_TABLE_100
728: , p5_a9 JTF_VARCHAR2_TABLE_100
729: , p5_a10 JTF_VARCHAR2_TABLE_100
722: , p5_a3 JTF_NUMBER_TABLE
723: , p5_a4 JTF_NUMBER_TABLE
724: , p5_a5 JTF_NUMBER_TABLE
725: , p5_a6 JTF_NUMBER_TABLE
726: , p5_a7 JTF_NUMBER_TABLE
727: , p5_a8 JTF_VARCHAR2_TABLE_100
728: , p5_a9 JTF_VARCHAR2_TABLE_100
729: , p5_a10 JTF_VARCHAR2_TABLE_100
730: , p5_a11 JTF_VARCHAR2_TABLE_100
729: , p5_a10 JTF_VARCHAR2_TABLE_100
730: , p5_a11 JTF_VARCHAR2_TABLE_100
731: , p5_a12 JTF_DATE_TABLE
732: , p5_a13 JTF_DATE_TABLE
733: , p5_a14 JTF_NUMBER_TABLE
734: , p5_a15 JTF_NUMBER_TABLE
735: , p5_a16 JTF_DATE_TABLE
736: , p5_a17 JTF_NUMBER_TABLE
737: , p5_a18 JTF_DATE_TABLE
730: , p5_a11 JTF_VARCHAR2_TABLE_100
731: , p5_a12 JTF_DATE_TABLE
732: , p5_a13 JTF_DATE_TABLE
733: , p5_a14 JTF_NUMBER_TABLE
734: , p5_a15 JTF_NUMBER_TABLE
735: , p5_a16 JTF_DATE_TABLE
736: , p5_a17 JTF_NUMBER_TABLE
737: , p5_a18 JTF_DATE_TABLE
738: , p5_a19 JTF_NUMBER_TABLE
732: , p5_a13 JTF_DATE_TABLE
733: , p5_a14 JTF_NUMBER_TABLE
734: , p5_a15 JTF_NUMBER_TABLE
735: , p5_a16 JTF_DATE_TABLE
736: , p5_a17 JTF_NUMBER_TABLE
737: , p5_a18 JTF_DATE_TABLE
738: , p5_a19 JTF_NUMBER_TABLE
739: , p6_a0 out nocopy JTF_NUMBER_TABLE
740: , p6_a1 out nocopy JTF_NUMBER_TABLE
734: , p5_a15 JTF_NUMBER_TABLE
735: , p5_a16 JTF_DATE_TABLE
736: , p5_a17 JTF_NUMBER_TABLE
737: , p5_a18 JTF_DATE_TABLE
738: , p5_a19 JTF_NUMBER_TABLE
739: , p6_a0 out nocopy JTF_NUMBER_TABLE
740: , p6_a1 out nocopy JTF_NUMBER_TABLE
741: , p6_a2 out nocopy JTF_NUMBER_TABLE
742: , p6_a3 out nocopy JTF_NUMBER_TABLE
735: , p5_a16 JTF_DATE_TABLE
736: , p5_a17 JTF_NUMBER_TABLE
737: , p5_a18 JTF_DATE_TABLE
738: , p5_a19 JTF_NUMBER_TABLE
739: , p6_a0 out nocopy JTF_NUMBER_TABLE
740: , p6_a1 out nocopy JTF_NUMBER_TABLE
741: , p6_a2 out nocopy JTF_NUMBER_TABLE
742: , p6_a3 out nocopy JTF_NUMBER_TABLE
743: , p6_a4 out nocopy JTF_NUMBER_TABLE
736: , p5_a17 JTF_NUMBER_TABLE
737: , p5_a18 JTF_DATE_TABLE
738: , p5_a19 JTF_NUMBER_TABLE
739: , p6_a0 out nocopy JTF_NUMBER_TABLE
740: , p6_a1 out nocopy JTF_NUMBER_TABLE
741: , p6_a2 out nocopy JTF_NUMBER_TABLE
742: , p6_a3 out nocopy JTF_NUMBER_TABLE
743: , p6_a4 out nocopy JTF_NUMBER_TABLE
744: , p6_a5 out nocopy JTF_NUMBER_TABLE
737: , p5_a18 JTF_DATE_TABLE
738: , p5_a19 JTF_NUMBER_TABLE
739: , p6_a0 out nocopy JTF_NUMBER_TABLE
740: , p6_a1 out nocopy JTF_NUMBER_TABLE
741: , p6_a2 out nocopy JTF_NUMBER_TABLE
742: , p6_a3 out nocopy JTF_NUMBER_TABLE
743: , p6_a4 out nocopy JTF_NUMBER_TABLE
744: , p6_a5 out nocopy JTF_NUMBER_TABLE
745: , p6_a6 out nocopy JTF_NUMBER_TABLE
738: , p5_a19 JTF_NUMBER_TABLE
739: , p6_a0 out nocopy JTF_NUMBER_TABLE
740: , p6_a1 out nocopy JTF_NUMBER_TABLE
741: , p6_a2 out nocopy JTF_NUMBER_TABLE
742: , p6_a3 out nocopy JTF_NUMBER_TABLE
743: , p6_a4 out nocopy JTF_NUMBER_TABLE
744: , p6_a5 out nocopy JTF_NUMBER_TABLE
745: , p6_a6 out nocopy JTF_NUMBER_TABLE
746: , p6_a7 out nocopy JTF_NUMBER_TABLE
739: , p6_a0 out nocopy JTF_NUMBER_TABLE
740: , p6_a1 out nocopy JTF_NUMBER_TABLE
741: , p6_a2 out nocopy JTF_NUMBER_TABLE
742: , p6_a3 out nocopy JTF_NUMBER_TABLE
743: , p6_a4 out nocopy JTF_NUMBER_TABLE
744: , p6_a5 out nocopy JTF_NUMBER_TABLE
745: , p6_a6 out nocopy JTF_NUMBER_TABLE
746: , p6_a7 out nocopy JTF_NUMBER_TABLE
747: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
740: , p6_a1 out nocopy JTF_NUMBER_TABLE
741: , p6_a2 out nocopy JTF_NUMBER_TABLE
742: , p6_a3 out nocopy JTF_NUMBER_TABLE
743: , p6_a4 out nocopy JTF_NUMBER_TABLE
744: , p6_a5 out nocopy JTF_NUMBER_TABLE
745: , p6_a6 out nocopy JTF_NUMBER_TABLE
746: , p6_a7 out nocopy JTF_NUMBER_TABLE
747: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
748: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
741: , p6_a2 out nocopy JTF_NUMBER_TABLE
742: , p6_a3 out nocopy JTF_NUMBER_TABLE
743: , p6_a4 out nocopy JTF_NUMBER_TABLE
744: , p6_a5 out nocopy JTF_NUMBER_TABLE
745: , p6_a6 out nocopy JTF_NUMBER_TABLE
746: , p6_a7 out nocopy JTF_NUMBER_TABLE
747: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
748: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
749: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
742: , p6_a3 out nocopy JTF_NUMBER_TABLE
743: , p6_a4 out nocopy JTF_NUMBER_TABLE
744: , p6_a5 out nocopy JTF_NUMBER_TABLE
745: , p6_a6 out nocopy JTF_NUMBER_TABLE
746: , p6_a7 out nocopy JTF_NUMBER_TABLE
747: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
748: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
749: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
750: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
749: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
750: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
751: , p6_a12 out nocopy JTF_DATE_TABLE
752: , p6_a13 out nocopy JTF_DATE_TABLE
753: , p6_a14 out nocopy JTF_NUMBER_TABLE
754: , p6_a15 out nocopy JTF_NUMBER_TABLE
755: , p6_a16 out nocopy JTF_DATE_TABLE
756: , p6_a17 out nocopy JTF_NUMBER_TABLE
757: , p6_a18 out nocopy JTF_DATE_TABLE
750: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
751: , p6_a12 out nocopy JTF_DATE_TABLE
752: , p6_a13 out nocopy JTF_DATE_TABLE
753: , p6_a14 out nocopy JTF_NUMBER_TABLE
754: , p6_a15 out nocopy JTF_NUMBER_TABLE
755: , p6_a16 out nocopy JTF_DATE_TABLE
756: , p6_a17 out nocopy JTF_NUMBER_TABLE
757: , p6_a18 out nocopy JTF_DATE_TABLE
758: , p6_a19 out nocopy JTF_NUMBER_TABLE
752: , p6_a13 out nocopy JTF_DATE_TABLE
753: , p6_a14 out nocopy JTF_NUMBER_TABLE
754: , p6_a15 out nocopy JTF_NUMBER_TABLE
755: , p6_a16 out nocopy JTF_DATE_TABLE
756: , p6_a17 out nocopy JTF_NUMBER_TABLE
757: , p6_a18 out nocopy JTF_DATE_TABLE
758: , p6_a19 out nocopy JTF_NUMBER_TABLE
759: )
760:
754: , p6_a15 out nocopy JTF_NUMBER_TABLE
755: , p6_a16 out nocopy JTF_DATE_TABLE
756: , p6_a17 out nocopy JTF_NUMBER_TABLE
757: , p6_a18 out nocopy JTF_DATE_TABLE
758: , p6_a19 out nocopy JTF_NUMBER_TABLE
759: )
760:
761: as
762: ddp_irhv_tbl okl_irh_pvt.okl_irhv_tbl;
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_VARCHAR2_TABLE_100
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_VARCHAR2_TABLE_100
924: , p5_a9 JTF_VARCHAR2_TABLE_100
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_VARCHAR2_TABLE_100
924: , p5_a9 JTF_VARCHAR2_TABLE_100
925: , p5_a10 JTF_VARCHAR2_TABLE_100
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_VARCHAR2_TABLE_100
924: , p5_a9 JTF_VARCHAR2_TABLE_100
925: , p5_a10 JTF_VARCHAR2_TABLE_100
926: , p5_a11 JTF_VARCHAR2_TABLE_100
925: , p5_a10 JTF_VARCHAR2_TABLE_100
926: , p5_a11 JTF_VARCHAR2_TABLE_100
927: , p5_a12 JTF_DATE_TABLE
928: , p5_a13 JTF_DATE_TABLE
929: , p5_a14 JTF_NUMBER_TABLE
930: , p5_a15 JTF_NUMBER_TABLE
931: , p5_a16 JTF_DATE_TABLE
932: , p5_a17 JTF_NUMBER_TABLE
933: , p5_a18 JTF_DATE_TABLE
926: , p5_a11 JTF_VARCHAR2_TABLE_100
927: , p5_a12 JTF_DATE_TABLE
928: , p5_a13 JTF_DATE_TABLE
929: , p5_a14 JTF_NUMBER_TABLE
930: , p5_a15 JTF_NUMBER_TABLE
931: , p5_a16 JTF_DATE_TABLE
932: , p5_a17 JTF_NUMBER_TABLE
933: , p5_a18 JTF_DATE_TABLE
934: , p5_a19 JTF_NUMBER_TABLE
928: , p5_a13 JTF_DATE_TABLE
929: , p5_a14 JTF_NUMBER_TABLE
930: , p5_a15 JTF_NUMBER_TABLE
931: , p5_a16 JTF_DATE_TABLE
932: , p5_a17 JTF_NUMBER_TABLE
933: , p5_a18 JTF_DATE_TABLE
934: , p5_a19 JTF_NUMBER_TABLE
935: )
936:
930: , p5_a15 JTF_NUMBER_TABLE
931: , p5_a16 JTF_DATE_TABLE
932: , p5_a17 JTF_NUMBER_TABLE
933: , p5_a18 JTF_DATE_TABLE
934: , p5_a19 JTF_NUMBER_TABLE
935: )
936:
937: as
938: ddp_irhv_tbl okl_irh_pvt.okl_irhv_tbl;