DBA Data[Home] [Help]

APPS.OKL_RCS_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p1(t out nocopy okl_rcs_pvt.okl_rcsv_tbl, a0 JTF_NUMBER_TABLE

1: package body okl_rcs_pvt_w as
2: /* $Header: OKLIRCSB.pls 120.2 2005/09/14 06:42:42 smadhava noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_rcs_pvt.okl_rcsv_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100

Line 4: , a1 JTF_NUMBER_TABLE

1: package body okl_rcs_pvt_w as
2: /* $Header: OKLIRCSB.pls 120.2 2005/09/14 06:42:42 smadhava noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_rcs_pvt.okl_rcsv_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100

Line 5: , a2 JTF_NUMBER_TABLE

1: package body okl_rcs_pvt_w as
2: /* $Header: OKLIRCSB.pls 120.2 2005/09/14 06:42:42 smadhava noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_rcs_pvt.okl_rcsv_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_300

Line 6: , a3 JTF_NUMBER_TABLE

2: /* $Header: OKLIRCSB.pls 120.2 2005/09/14 06:42:42 smadhava noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_rcs_pvt.okl_rcsv_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_300
10: , a7 JTF_VARCHAR2_TABLE_2000

Line 12: , a9 JTF_NUMBER_TABLE

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

Line 14: , a11 JTF_NUMBER_TABLE

10: , a7 JTF_VARCHAR2_TABLE_2000
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_DATE_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_DATE_TABLE
16: , a13 JTF_NUMBER_TABLE
17: ) as
18: ddindx binary_integer; indx binary_integer;

Line 16: , a13 JTF_NUMBER_TABLE

12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_DATE_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_DATE_TABLE
16: , a13 JTF_NUMBER_TABLE
17: ) as
18: ddindx binary_integer; indx binary_integer;
19: begin
20: if a0 is not null and a0.count > 0 then

Line 48: procedure rosetta_table_copy_out_p1(t okl_rcs_pvt.okl_rcsv_tbl, a0 out nocopy JTF_NUMBER_TABLE

44: end loop;
45: end if;
46: end if;
47: end rosetta_table_copy_in_p1;
48: procedure rosetta_table_copy_out_p1(t okl_rcs_pvt.okl_rcsv_tbl, a0 out nocopy JTF_NUMBER_TABLE
49: , a1 out nocopy JTF_NUMBER_TABLE
50: , a2 out nocopy JTF_NUMBER_TABLE
51: , a3 out nocopy JTF_NUMBER_TABLE
52: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 49: , a1 out nocopy JTF_NUMBER_TABLE

45: end if;
46: end if;
47: end rosetta_table_copy_in_p1;
48: procedure rosetta_table_copy_out_p1(t okl_rcs_pvt.okl_rcsv_tbl, a0 out nocopy JTF_NUMBER_TABLE
49: , a1 out nocopy JTF_NUMBER_TABLE
50: , a2 out nocopy JTF_NUMBER_TABLE
51: , a3 out nocopy JTF_NUMBER_TABLE
52: , a4 out nocopy JTF_VARCHAR2_TABLE_100
53: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 50: , a2 out nocopy JTF_NUMBER_TABLE

46: end if;
47: end rosetta_table_copy_in_p1;
48: procedure rosetta_table_copy_out_p1(t okl_rcs_pvt.okl_rcsv_tbl, a0 out nocopy JTF_NUMBER_TABLE
49: , a1 out nocopy JTF_NUMBER_TABLE
50: , a2 out nocopy JTF_NUMBER_TABLE
51: , a3 out nocopy JTF_NUMBER_TABLE
52: , a4 out nocopy JTF_VARCHAR2_TABLE_100
53: , a5 out nocopy JTF_VARCHAR2_TABLE_100
54: , a6 out nocopy JTF_VARCHAR2_TABLE_300

Line 51: , a3 out nocopy JTF_NUMBER_TABLE

47: end rosetta_table_copy_in_p1;
48: procedure rosetta_table_copy_out_p1(t okl_rcs_pvt.okl_rcsv_tbl, a0 out nocopy JTF_NUMBER_TABLE
49: , a1 out nocopy JTF_NUMBER_TABLE
50: , a2 out nocopy JTF_NUMBER_TABLE
51: , a3 out nocopy JTF_NUMBER_TABLE
52: , a4 out nocopy JTF_VARCHAR2_TABLE_100
53: , a5 out nocopy JTF_VARCHAR2_TABLE_100
54: , a6 out nocopy JTF_VARCHAR2_TABLE_300
55: , a7 out nocopy JTF_VARCHAR2_TABLE_2000

Line 57: , a9 out nocopy JTF_NUMBER_TABLE

53: , a5 out nocopy JTF_VARCHAR2_TABLE_100
54: , a6 out nocopy JTF_VARCHAR2_TABLE_300
55: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
56: , a8 out nocopy JTF_VARCHAR2_TABLE_100
57: , a9 out nocopy JTF_NUMBER_TABLE
58: , a10 out nocopy JTF_DATE_TABLE
59: , a11 out nocopy JTF_NUMBER_TABLE
60: , a12 out nocopy JTF_DATE_TABLE
61: , a13 out nocopy JTF_NUMBER_TABLE

Line 59: , a11 out nocopy JTF_NUMBER_TABLE

55: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
56: , a8 out nocopy JTF_VARCHAR2_TABLE_100
57: , a9 out nocopy JTF_NUMBER_TABLE
58: , a10 out nocopy JTF_DATE_TABLE
59: , a11 out nocopy JTF_NUMBER_TABLE
60: , a12 out nocopy JTF_DATE_TABLE
61: , a13 out nocopy JTF_NUMBER_TABLE
62: ) as
63: ddindx binary_integer; indx binary_integer;

Line 61: , a13 out nocopy JTF_NUMBER_TABLE

57: , a9 out nocopy JTF_NUMBER_TABLE
58: , a10 out nocopy JTF_DATE_TABLE
59: , a11 out nocopy JTF_NUMBER_TABLE
60: , a12 out nocopy JTF_DATE_TABLE
61: , a13 out nocopy JTF_NUMBER_TABLE
62: ) as
63: ddindx binary_integer; indx binary_integer;
64: begin
65: if t is null or t.count = 0 then

Line 66: a0 := JTF_NUMBER_TABLE();

62: ) as
63: ddindx binary_integer; indx binary_integer;
64: begin
65: if t is null or t.count = 0 then
66: a0 := JTF_NUMBER_TABLE();
67: a1 := JTF_NUMBER_TABLE();
68: a2 := JTF_NUMBER_TABLE();
69: a3 := JTF_NUMBER_TABLE();
70: a4 := JTF_VARCHAR2_TABLE_100();

Line 67: a1 := JTF_NUMBER_TABLE();

63: ddindx binary_integer; indx binary_integer;
64: begin
65: if t is null or t.count = 0 then
66: a0 := JTF_NUMBER_TABLE();
67: a1 := JTF_NUMBER_TABLE();
68: a2 := JTF_NUMBER_TABLE();
69: a3 := JTF_NUMBER_TABLE();
70: a4 := JTF_VARCHAR2_TABLE_100();
71: a5 := JTF_VARCHAR2_TABLE_100();

Line 68: a2 := JTF_NUMBER_TABLE();

64: begin
65: if t is null or t.count = 0 then
66: a0 := JTF_NUMBER_TABLE();
67: a1 := JTF_NUMBER_TABLE();
68: a2 := JTF_NUMBER_TABLE();
69: a3 := JTF_NUMBER_TABLE();
70: a4 := JTF_VARCHAR2_TABLE_100();
71: a5 := JTF_VARCHAR2_TABLE_100();
72: a6 := JTF_VARCHAR2_TABLE_300();

Line 69: a3 := JTF_NUMBER_TABLE();

65: if t is null or t.count = 0 then
66: a0 := JTF_NUMBER_TABLE();
67: a1 := JTF_NUMBER_TABLE();
68: a2 := JTF_NUMBER_TABLE();
69: a3 := JTF_NUMBER_TABLE();
70: a4 := JTF_VARCHAR2_TABLE_100();
71: a5 := JTF_VARCHAR2_TABLE_100();
72: a6 := JTF_VARCHAR2_TABLE_300();
73: a7 := JTF_VARCHAR2_TABLE_2000();

Line 75: a9 := JTF_NUMBER_TABLE();

71: a5 := JTF_VARCHAR2_TABLE_100();
72: a6 := JTF_VARCHAR2_TABLE_300();
73: a7 := JTF_VARCHAR2_TABLE_2000();
74: a8 := JTF_VARCHAR2_TABLE_100();
75: a9 := JTF_NUMBER_TABLE();
76: a10 := JTF_DATE_TABLE();
77: a11 := JTF_NUMBER_TABLE();
78: a12 := JTF_DATE_TABLE();
79: a13 := JTF_NUMBER_TABLE();

Line 77: a11 := JTF_NUMBER_TABLE();

73: a7 := JTF_VARCHAR2_TABLE_2000();
74: a8 := JTF_VARCHAR2_TABLE_100();
75: a9 := JTF_NUMBER_TABLE();
76: a10 := JTF_DATE_TABLE();
77: a11 := JTF_NUMBER_TABLE();
78: a12 := JTF_DATE_TABLE();
79: a13 := JTF_NUMBER_TABLE();
80: else
81: a0 := JTF_NUMBER_TABLE();

Line 79: a13 := JTF_NUMBER_TABLE();

75: a9 := JTF_NUMBER_TABLE();
76: a10 := JTF_DATE_TABLE();
77: a11 := JTF_NUMBER_TABLE();
78: a12 := JTF_DATE_TABLE();
79: a13 := JTF_NUMBER_TABLE();
80: else
81: a0 := JTF_NUMBER_TABLE();
82: a1 := JTF_NUMBER_TABLE();
83: a2 := JTF_NUMBER_TABLE();

Line 81: a0 := JTF_NUMBER_TABLE();

77: a11 := JTF_NUMBER_TABLE();
78: a12 := JTF_DATE_TABLE();
79: a13 := JTF_NUMBER_TABLE();
80: else
81: a0 := JTF_NUMBER_TABLE();
82: a1 := JTF_NUMBER_TABLE();
83: a2 := JTF_NUMBER_TABLE();
84: a3 := JTF_NUMBER_TABLE();
85: a4 := JTF_VARCHAR2_TABLE_100();

Line 82: a1 := JTF_NUMBER_TABLE();

78: a12 := JTF_DATE_TABLE();
79: a13 := JTF_NUMBER_TABLE();
80: else
81: a0 := JTF_NUMBER_TABLE();
82: a1 := JTF_NUMBER_TABLE();
83: a2 := JTF_NUMBER_TABLE();
84: a3 := JTF_NUMBER_TABLE();
85: a4 := JTF_VARCHAR2_TABLE_100();
86: a5 := JTF_VARCHAR2_TABLE_100();

Line 83: a2 := JTF_NUMBER_TABLE();

79: a13 := JTF_NUMBER_TABLE();
80: else
81: a0 := JTF_NUMBER_TABLE();
82: a1 := JTF_NUMBER_TABLE();
83: a2 := JTF_NUMBER_TABLE();
84: a3 := JTF_NUMBER_TABLE();
85: a4 := JTF_VARCHAR2_TABLE_100();
86: a5 := JTF_VARCHAR2_TABLE_100();
87: a6 := JTF_VARCHAR2_TABLE_300();

Line 84: a3 := JTF_NUMBER_TABLE();

80: else
81: a0 := JTF_NUMBER_TABLE();
82: a1 := JTF_NUMBER_TABLE();
83: a2 := JTF_NUMBER_TABLE();
84: a3 := JTF_NUMBER_TABLE();
85: a4 := JTF_VARCHAR2_TABLE_100();
86: a5 := JTF_VARCHAR2_TABLE_100();
87: a6 := JTF_VARCHAR2_TABLE_300();
88: a7 := JTF_VARCHAR2_TABLE_2000();

Line 90: a9 := JTF_NUMBER_TABLE();

86: a5 := JTF_VARCHAR2_TABLE_100();
87: a6 := JTF_VARCHAR2_TABLE_300();
88: a7 := JTF_VARCHAR2_TABLE_2000();
89: a8 := JTF_VARCHAR2_TABLE_100();
90: a9 := JTF_NUMBER_TABLE();
91: a10 := JTF_DATE_TABLE();
92: a11 := JTF_NUMBER_TABLE();
93: a12 := JTF_DATE_TABLE();
94: a13 := JTF_NUMBER_TABLE();

Line 92: a11 := JTF_NUMBER_TABLE();

88: a7 := JTF_VARCHAR2_TABLE_2000();
89: a8 := JTF_VARCHAR2_TABLE_100();
90: a9 := JTF_NUMBER_TABLE();
91: a10 := JTF_DATE_TABLE();
92: a11 := JTF_NUMBER_TABLE();
93: a12 := JTF_DATE_TABLE();
94: a13 := JTF_NUMBER_TABLE();
95: if t.count > 0 then
96: a0.extend(t.count);

Line 94: a13 := JTF_NUMBER_TABLE();

90: a9 := JTF_NUMBER_TABLE();
91: a10 := JTF_DATE_TABLE();
92: a11 := JTF_NUMBER_TABLE();
93: a12 := JTF_DATE_TABLE();
94: a13 := JTF_NUMBER_TABLE();
95: if t.count > 0 then
96: a0.extend(t.count);
97: a1.extend(t.count);
98: a2.extend(t.count);

Line 137: procedure rosetta_table_copy_in_p3(t out nocopy okl_rcs_pvt.okl_rcsb_tbl, a0 JTF_NUMBER_TABLE

133: end if;
134: end if;
135: end rosetta_table_copy_out_p1;
136:
137: procedure rosetta_table_copy_in_p3(t out nocopy okl_rcs_pvt.okl_rcsb_tbl, a0 JTF_NUMBER_TABLE
138: , a1 JTF_VARCHAR2_TABLE_300
139: , a2 JTF_NUMBER_TABLE
140: , a3 JTF_NUMBER_TABLE
141: , a4 JTF_NUMBER_TABLE

Line 139: , a2 JTF_NUMBER_TABLE

135: end rosetta_table_copy_out_p1;
136:
137: procedure rosetta_table_copy_in_p3(t out nocopy okl_rcs_pvt.okl_rcsb_tbl, a0 JTF_NUMBER_TABLE
138: , a1 JTF_VARCHAR2_TABLE_300
139: , a2 JTF_NUMBER_TABLE
140: , a3 JTF_NUMBER_TABLE
141: , a4 JTF_NUMBER_TABLE
142: , a5 JTF_VARCHAR2_TABLE_100
143: , a6 JTF_VARCHAR2_TABLE_100

Line 140: , a3 JTF_NUMBER_TABLE

136:
137: procedure rosetta_table_copy_in_p3(t out nocopy okl_rcs_pvt.okl_rcsb_tbl, a0 JTF_NUMBER_TABLE
138: , a1 JTF_VARCHAR2_TABLE_300
139: , a2 JTF_NUMBER_TABLE
140: , a3 JTF_NUMBER_TABLE
141: , a4 JTF_NUMBER_TABLE
142: , a5 JTF_VARCHAR2_TABLE_100
143: , a6 JTF_VARCHAR2_TABLE_100
144: , a7 JTF_NUMBER_TABLE

Line 141: , a4 JTF_NUMBER_TABLE

137: procedure rosetta_table_copy_in_p3(t out nocopy okl_rcs_pvt.okl_rcsb_tbl, a0 JTF_NUMBER_TABLE
138: , a1 JTF_VARCHAR2_TABLE_300
139: , a2 JTF_NUMBER_TABLE
140: , a3 JTF_NUMBER_TABLE
141: , a4 JTF_NUMBER_TABLE
142: , a5 JTF_VARCHAR2_TABLE_100
143: , a6 JTF_VARCHAR2_TABLE_100
144: , a7 JTF_NUMBER_TABLE
145: , a8 JTF_DATE_TABLE

Line 144: , a7 JTF_NUMBER_TABLE

140: , a3 JTF_NUMBER_TABLE
141: , a4 JTF_NUMBER_TABLE
142: , a5 JTF_VARCHAR2_TABLE_100
143: , a6 JTF_VARCHAR2_TABLE_100
144: , a7 JTF_NUMBER_TABLE
145: , a8 JTF_DATE_TABLE
146: , a9 JTF_NUMBER_TABLE
147: , a10 JTF_DATE_TABLE
148: , a11 JTF_NUMBER_TABLE

Line 146: , a9 JTF_NUMBER_TABLE

142: , a5 JTF_VARCHAR2_TABLE_100
143: , a6 JTF_VARCHAR2_TABLE_100
144: , a7 JTF_NUMBER_TABLE
145: , a8 JTF_DATE_TABLE
146: , a9 JTF_NUMBER_TABLE
147: , a10 JTF_DATE_TABLE
148: , a11 JTF_NUMBER_TABLE
149: ) as
150: ddindx binary_integer; indx binary_integer;

Line 148: , a11 JTF_NUMBER_TABLE

144: , a7 JTF_NUMBER_TABLE
145: , a8 JTF_DATE_TABLE
146: , a9 JTF_NUMBER_TABLE
147: , a10 JTF_DATE_TABLE
148: , a11 JTF_NUMBER_TABLE
149: ) as
150: ddindx binary_integer; indx binary_integer;
151: begin
152: if a0 is not null and a0.count > 0 then

Line 178: procedure rosetta_table_copy_out_p3(t okl_rcs_pvt.okl_rcsb_tbl, a0 out nocopy JTF_NUMBER_TABLE

174: end loop;
175: end if;
176: end if;
177: end rosetta_table_copy_in_p3;
178: procedure rosetta_table_copy_out_p3(t okl_rcs_pvt.okl_rcsb_tbl, a0 out nocopy JTF_NUMBER_TABLE
179: , a1 out nocopy JTF_VARCHAR2_TABLE_300
180: , a2 out nocopy JTF_NUMBER_TABLE
181: , a3 out nocopy JTF_NUMBER_TABLE
182: , a4 out nocopy JTF_NUMBER_TABLE

Line 180: , a2 out nocopy JTF_NUMBER_TABLE

176: end if;
177: end rosetta_table_copy_in_p3;
178: procedure rosetta_table_copy_out_p3(t okl_rcs_pvt.okl_rcsb_tbl, a0 out nocopy JTF_NUMBER_TABLE
179: , a1 out nocopy JTF_VARCHAR2_TABLE_300
180: , a2 out nocopy JTF_NUMBER_TABLE
181: , a3 out nocopy JTF_NUMBER_TABLE
182: , a4 out nocopy JTF_NUMBER_TABLE
183: , a5 out nocopy JTF_VARCHAR2_TABLE_100
184: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 181: , a3 out nocopy JTF_NUMBER_TABLE

177: end rosetta_table_copy_in_p3;
178: procedure rosetta_table_copy_out_p3(t okl_rcs_pvt.okl_rcsb_tbl, a0 out nocopy JTF_NUMBER_TABLE
179: , a1 out nocopy JTF_VARCHAR2_TABLE_300
180: , a2 out nocopy JTF_NUMBER_TABLE
181: , a3 out nocopy JTF_NUMBER_TABLE
182: , a4 out nocopy JTF_NUMBER_TABLE
183: , a5 out nocopy JTF_VARCHAR2_TABLE_100
184: , a6 out nocopy JTF_VARCHAR2_TABLE_100
185: , a7 out nocopy JTF_NUMBER_TABLE

Line 182: , a4 out nocopy JTF_NUMBER_TABLE

178: procedure rosetta_table_copy_out_p3(t okl_rcs_pvt.okl_rcsb_tbl, a0 out nocopy JTF_NUMBER_TABLE
179: , a1 out nocopy JTF_VARCHAR2_TABLE_300
180: , a2 out nocopy JTF_NUMBER_TABLE
181: , a3 out nocopy JTF_NUMBER_TABLE
182: , a4 out nocopy JTF_NUMBER_TABLE
183: , a5 out nocopy JTF_VARCHAR2_TABLE_100
184: , a6 out nocopy JTF_VARCHAR2_TABLE_100
185: , a7 out nocopy JTF_NUMBER_TABLE
186: , a8 out nocopy JTF_DATE_TABLE

Line 185: , a7 out nocopy JTF_NUMBER_TABLE

181: , a3 out nocopy JTF_NUMBER_TABLE
182: , a4 out nocopy JTF_NUMBER_TABLE
183: , a5 out nocopy JTF_VARCHAR2_TABLE_100
184: , a6 out nocopy JTF_VARCHAR2_TABLE_100
185: , a7 out nocopy JTF_NUMBER_TABLE
186: , a8 out nocopy JTF_DATE_TABLE
187: , a9 out nocopy JTF_NUMBER_TABLE
188: , a10 out nocopy JTF_DATE_TABLE
189: , a11 out nocopy JTF_NUMBER_TABLE

Line 187: , a9 out nocopy JTF_NUMBER_TABLE

183: , a5 out nocopy JTF_VARCHAR2_TABLE_100
184: , a6 out nocopy JTF_VARCHAR2_TABLE_100
185: , a7 out nocopy JTF_NUMBER_TABLE
186: , a8 out nocopy JTF_DATE_TABLE
187: , a9 out nocopy JTF_NUMBER_TABLE
188: , a10 out nocopy JTF_DATE_TABLE
189: , a11 out nocopy JTF_NUMBER_TABLE
190: ) as
191: ddindx binary_integer; indx binary_integer;

Line 189: , a11 out nocopy JTF_NUMBER_TABLE

185: , a7 out nocopy JTF_NUMBER_TABLE
186: , a8 out nocopy JTF_DATE_TABLE
187: , a9 out nocopy JTF_NUMBER_TABLE
188: , a10 out nocopy JTF_DATE_TABLE
189: , a11 out nocopy JTF_NUMBER_TABLE
190: ) as
191: ddindx binary_integer; indx binary_integer;
192: begin
193: if t is null or t.count = 0 then

Line 194: a0 := JTF_NUMBER_TABLE();

190: ) as
191: ddindx binary_integer; indx binary_integer;
192: begin
193: if t is null or t.count = 0 then
194: a0 := JTF_NUMBER_TABLE();
195: a1 := JTF_VARCHAR2_TABLE_300();
196: a2 := JTF_NUMBER_TABLE();
197: a3 := JTF_NUMBER_TABLE();
198: a4 := JTF_NUMBER_TABLE();

Line 196: a2 := JTF_NUMBER_TABLE();

192: begin
193: if t is null or t.count = 0 then
194: a0 := JTF_NUMBER_TABLE();
195: a1 := JTF_VARCHAR2_TABLE_300();
196: a2 := JTF_NUMBER_TABLE();
197: a3 := JTF_NUMBER_TABLE();
198: a4 := JTF_NUMBER_TABLE();
199: a5 := JTF_VARCHAR2_TABLE_100();
200: a6 := JTF_VARCHAR2_TABLE_100();

Line 197: a3 := JTF_NUMBER_TABLE();

193: if t is null or t.count = 0 then
194: a0 := JTF_NUMBER_TABLE();
195: a1 := JTF_VARCHAR2_TABLE_300();
196: a2 := JTF_NUMBER_TABLE();
197: a3 := JTF_NUMBER_TABLE();
198: a4 := JTF_NUMBER_TABLE();
199: a5 := JTF_VARCHAR2_TABLE_100();
200: a6 := JTF_VARCHAR2_TABLE_100();
201: a7 := JTF_NUMBER_TABLE();

Line 198: a4 := JTF_NUMBER_TABLE();

194: a0 := JTF_NUMBER_TABLE();
195: a1 := JTF_VARCHAR2_TABLE_300();
196: a2 := JTF_NUMBER_TABLE();
197: a3 := JTF_NUMBER_TABLE();
198: a4 := JTF_NUMBER_TABLE();
199: a5 := JTF_VARCHAR2_TABLE_100();
200: a6 := JTF_VARCHAR2_TABLE_100();
201: a7 := JTF_NUMBER_TABLE();
202: a8 := JTF_DATE_TABLE();

Line 201: a7 := JTF_NUMBER_TABLE();

197: a3 := JTF_NUMBER_TABLE();
198: a4 := JTF_NUMBER_TABLE();
199: a5 := JTF_VARCHAR2_TABLE_100();
200: a6 := JTF_VARCHAR2_TABLE_100();
201: a7 := JTF_NUMBER_TABLE();
202: a8 := JTF_DATE_TABLE();
203: a9 := JTF_NUMBER_TABLE();
204: a10 := JTF_DATE_TABLE();
205: a11 := JTF_NUMBER_TABLE();

Line 203: a9 := JTF_NUMBER_TABLE();

199: a5 := JTF_VARCHAR2_TABLE_100();
200: a6 := JTF_VARCHAR2_TABLE_100();
201: a7 := JTF_NUMBER_TABLE();
202: a8 := JTF_DATE_TABLE();
203: a9 := JTF_NUMBER_TABLE();
204: a10 := JTF_DATE_TABLE();
205: a11 := JTF_NUMBER_TABLE();
206: else
207: a0 := JTF_NUMBER_TABLE();

Line 205: a11 := JTF_NUMBER_TABLE();

201: a7 := JTF_NUMBER_TABLE();
202: a8 := JTF_DATE_TABLE();
203: a9 := JTF_NUMBER_TABLE();
204: a10 := JTF_DATE_TABLE();
205: a11 := JTF_NUMBER_TABLE();
206: else
207: a0 := JTF_NUMBER_TABLE();
208: a1 := JTF_VARCHAR2_TABLE_300();
209: a2 := JTF_NUMBER_TABLE();

Line 207: a0 := JTF_NUMBER_TABLE();

203: a9 := JTF_NUMBER_TABLE();
204: a10 := JTF_DATE_TABLE();
205: a11 := JTF_NUMBER_TABLE();
206: else
207: a0 := JTF_NUMBER_TABLE();
208: a1 := JTF_VARCHAR2_TABLE_300();
209: a2 := JTF_NUMBER_TABLE();
210: a3 := JTF_NUMBER_TABLE();
211: a4 := JTF_NUMBER_TABLE();

Line 209: a2 := JTF_NUMBER_TABLE();

205: a11 := JTF_NUMBER_TABLE();
206: else
207: a0 := JTF_NUMBER_TABLE();
208: a1 := JTF_VARCHAR2_TABLE_300();
209: a2 := JTF_NUMBER_TABLE();
210: a3 := JTF_NUMBER_TABLE();
211: a4 := JTF_NUMBER_TABLE();
212: a5 := JTF_VARCHAR2_TABLE_100();
213: a6 := JTF_VARCHAR2_TABLE_100();

Line 210: a3 := JTF_NUMBER_TABLE();

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

Line 211: a4 := JTF_NUMBER_TABLE();

207: a0 := JTF_NUMBER_TABLE();
208: a1 := JTF_VARCHAR2_TABLE_300();
209: a2 := JTF_NUMBER_TABLE();
210: a3 := JTF_NUMBER_TABLE();
211: a4 := JTF_NUMBER_TABLE();
212: a5 := JTF_VARCHAR2_TABLE_100();
213: a6 := JTF_VARCHAR2_TABLE_100();
214: a7 := JTF_NUMBER_TABLE();
215: a8 := JTF_DATE_TABLE();

Line 214: a7 := JTF_NUMBER_TABLE();

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

Line 216: a9 := JTF_NUMBER_TABLE();

212: a5 := JTF_VARCHAR2_TABLE_100();
213: a6 := JTF_VARCHAR2_TABLE_100();
214: a7 := JTF_NUMBER_TABLE();
215: a8 := JTF_DATE_TABLE();
216: a9 := JTF_NUMBER_TABLE();
217: a10 := JTF_DATE_TABLE();
218: a11 := JTF_NUMBER_TABLE();
219: if t.count > 0 then
220: a0.extend(t.count);

Line 218: a11 := JTF_NUMBER_TABLE();

214: a7 := JTF_NUMBER_TABLE();
215: a8 := JTF_DATE_TABLE();
216: a9 := JTF_NUMBER_TABLE();
217: a10 := JTF_DATE_TABLE();
218: a11 := JTF_NUMBER_TABLE();
219: if t.count > 0 then
220: a0.extend(t.count);
221: a1.extend(t.count);
222: a2.extend(t.count);

Line 257: procedure rosetta_table_copy_in_p5(t out nocopy okl_rcs_pvt.okl_rcstl_tbl, a0 JTF_NUMBER_TABLE

253: end if;
254: end if;
255: end rosetta_table_copy_out_p3;
256:
257: procedure rosetta_table_copy_in_p5(t out nocopy okl_rcs_pvt.okl_rcstl_tbl, a0 JTF_NUMBER_TABLE
258: , a1 JTF_VARCHAR2_TABLE_100
259: , a2 JTF_VARCHAR2_TABLE_100
260: , a3 JTF_VARCHAR2_TABLE_100
261: , a4 JTF_NUMBER_TABLE

Line 261: , a4 JTF_NUMBER_TABLE

257: procedure rosetta_table_copy_in_p5(t out nocopy okl_rcs_pvt.okl_rcstl_tbl, a0 JTF_NUMBER_TABLE
258: , a1 JTF_VARCHAR2_TABLE_100
259: , a2 JTF_VARCHAR2_TABLE_100
260: , a3 JTF_VARCHAR2_TABLE_100
261: , a4 JTF_NUMBER_TABLE
262: , a5 JTF_DATE_TABLE
263: , a6 JTF_NUMBER_TABLE
264: , a7 JTF_DATE_TABLE
265: , a8 JTF_NUMBER_TABLE

Line 263: , a6 JTF_NUMBER_TABLE

259: , a2 JTF_VARCHAR2_TABLE_100
260: , a3 JTF_VARCHAR2_TABLE_100
261: , a4 JTF_NUMBER_TABLE
262: , a5 JTF_DATE_TABLE
263: , a6 JTF_NUMBER_TABLE
264: , a7 JTF_DATE_TABLE
265: , a8 JTF_NUMBER_TABLE
266: , a9 JTF_VARCHAR2_TABLE_2000
267: ) as

Line 265: , a8 JTF_NUMBER_TABLE

261: , a4 JTF_NUMBER_TABLE
262: , a5 JTF_DATE_TABLE
263: , a6 JTF_NUMBER_TABLE
264: , a7 JTF_DATE_TABLE
265: , a8 JTF_NUMBER_TABLE
266: , a9 JTF_VARCHAR2_TABLE_2000
267: ) as
268: ddindx binary_integer; indx binary_integer;
269: begin

Line 294: procedure rosetta_table_copy_out_p5(t okl_rcs_pvt.okl_rcstl_tbl, a0 out nocopy JTF_NUMBER_TABLE

290: end loop;
291: end if;
292: end if;
293: end rosetta_table_copy_in_p5;
294: procedure rosetta_table_copy_out_p5(t okl_rcs_pvt.okl_rcstl_tbl, a0 out nocopy JTF_NUMBER_TABLE
295: , a1 out nocopy JTF_VARCHAR2_TABLE_100
296: , a2 out nocopy JTF_VARCHAR2_TABLE_100
297: , a3 out nocopy JTF_VARCHAR2_TABLE_100
298: , a4 out nocopy JTF_NUMBER_TABLE

Line 298: , a4 out nocopy JTF_NUMBER_TABLE

294: procedure rosetta_table_copy_out_p5(t okl_rcs_pvt.okl_rcstl_tbl, a0 out nocopy JTF_NUMBER_TABLE
295: , a1 out nocopy JTF_VARCHAR2_TABLE_100
296: , a2 out nocopy JTF_VARCHAR2_TABLE_100
297: , a3 out nocopy JTF_VARCHAR2_TABLE_100
298: , a4 out nocopy JTF_NUMBER_TABLE
299: , a5 out nocopy JTF_DATE_TABLE
300: , a6 out nocopy JTF_NUMBER_TABLE
301: , a7 out nocopy JTF_DATE_TABLE
302: , a8 out nocopy JTF_NUMBER_TABLE

Line 300: , a6 out nocopy JTF_NUMBER_TABLE

296: , a2 out nocopy JTF_VARCHAR2_TABLE_100
297: , a3 out nocopy JTF_VARCHAR2_TABLE_100
298: , a4 out nocopy JTF_NUMBER_TABLE
299: , a5 out nocopy JTF_DATE_TABLE
300: , a6 out nocopy JTF_NUMBER_TABLE
301: , a7 out nocopy JTF_DATE_TABLE
302: , a8 out nocopy JTF_NUMBER_TABLE
303: , a9 out nocopy JTF_VARCHAR2_TABLE_2000
304: ) as

Line 302: , a8 out nocopy JTF_NUMBER_TABLE

298: , a4 out nocopy JTF_NUMBER_TABLE
299: , a5 out nocopy JTF_DATE_TABLE
300: , a6 out nocopy JTF_NUMBER_TABLE
301: , a7 out nocopy JTF_DATE_TABLE
302: , a8 out nocopy JTF_NUMBER_TABLE
303: , a9 out nocopy JTF_VARCHAR2_TABLE_2000
304: ) as
305: ddindx binary_integer; indx binary_integer;
306: begin

Line 308: a0 := JTF_NUMBER_TABLE();

304: ) as
305: ddindx binary_integer; indx binary_integer;
306: begin
307: if t is null or t.count = 0 then
308: a0 := JTF_NUMBER_TABLE();
309: a1 := JTF_VARCHAR2_TABLE_100();
310: a2 := JTF_VARCHAR2_TABLE_100();
311: a3 := JTF_VARCHAR2_TABLE_100();
312: a4 := JTF_NUMBER_TABLE();

Line 312: a4 := JTF_NUMBER_TABLE();

308: a0 := JTF_NUMBER_TABLE();
309: a1 := JTF_VARCHAR2_TABLE_100();
310: a2 := JTF_VARCHAR2_TABLE_100();
311: a3 := JTF_VARCHAR2_TABLE_100();
312: a4 := JTF_NUMBER_TABLE();
313: a5 := JTF_DATE_TABLE();
314: a6 := JTF_NUMBER_TABLE();
315: a7 := JTF_DATE_TABLE();
316: a8 := JTF_NUMBER_TABLE();

Line 314: a6 := JTF_NUMBER_TABLE();

310: a2 := JTF_VARCHAR2_TABLE_100();
311: a3 := JTF_VARCHAR2_TABLE_100();
312: a4 := JTF_NUMBER_TABLE();
313: a5 := JTF_DATE_TABLE();
314: a6 := JTF_NUMBER_TABLE();
315: a7 := JTF_DATE_TABLE();
316: a8 := JTF_NUMBER_TABLE();
317: a9 := JTF_VARCHAR2_TABLE_2000();
318: else

Line 316: a8 := JTF_NUMBER_TABLE();

312: a4 := JTF_NUMBER_TABLE();
313: a5 := JTF_DATE_TABLE();
314: a6 := JTF_NUMBER_TABLE();
315: a7 := JTF_DATE_TABLE();
316: a8 := JTF_NUMBER_TABLE();
317: a9 := JTF_VARCHAR2_TABLE_2000();
318: else
319: a0 := JTF_NUMBER_TABLE();
320: a1 := JTF_VARCHAR2_TABLE_100();

Line 319: a0 := JTF_NUMBER_TABLE();

315: a7 := JTF_DATE_TABLE();
316: a8 := JTF_NUMBER_TABLE();
317: a9 := JTF_VARCHAR2_TABLE_2000();
318: else
319: a0 := JTF_NUMBER_TABLE();
320: a1 := JTF_VARCHAR2_TABLE_100();
321: a2 := JTF_VARCHAR2_TABLE_100();
322: a3 := JTF_VARCHAR2_TABLE_100();
323: a4 := JTF_NUMBER_TABLE();

Line 323: a4 := JTF_NUMBER_TABLE();

319: a0 := JTF_NUMBER_TABLE();
320: a1 := JTF_VARCHAR2_TABLE_100();
321: a2 := JTF_VARCHAR2_TABLE_100();
322: a3 := JTF_VARCHAR2_TABLE_100();
323: a4 := JTF_NUMBER_TABLE();
324: a5 := JTF_DATE_TABLE();
325: a6 := JTF_NUMBER_TABLE();
326: a7 := JTF_DATE_TABLE();
327: a8 := JTF_NUMBER_TABLE();

Line 325: a6 := JTF_NUMBER_TABLE();

321: a2 := JTF_VARCHAR2_TABLE_100();
322: a3 := JTF_VARCHAR2_TABLE_100();
323: a4 := JTF_NUMBER_TABLE();
324: a5 := JTF_DATE_TABLE();
325: a6 := JTF_NUMBER_TABLE();
326: a7 := JTF_DATE_TABLE();
327: a8 := JTF_NUMBER_TABLE();
328: a9 := JTF_VARCHAR2_TABLE_2000();
329: if t.count > 0 then

Line 327: a8 := JTF_NUMBER_TABLE();

323: a4 := JTF_NUMBER_TABLE();
324: a5 := JTF_DATE_TABLE();
325: a6 := JTF_NUMBER_TABLE();
326: a7 := JTF_DATE_TABLE();
327: a8 := JTF_NUMBER_TABLE();
328: a9 := JTF_VARCHAR2_TABLE_2000();
329: if t.count > 0 then
330: a0.extend(t.count);
331: a1.extend(t.count);

Line 463: , p5_a0 JTF_NUMBER_TABLE

459: , p_init_msg_list VARCHAR2
460: , x_return_status out nocopy VARCHAR2
461: , x_msg_count out nocopy NUMBER
462: , x_msg_data out nocopy VARCHAR2
463: , p5_a0 JTF_NUMBER_TABLE
464: , p5_a1 JTF_NUMBER_TABLE
465: , p5_a2 JTF_NUMBER_TABLE
466: , p5_a3 JTF_NUMBER_TABLE
467: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 464: , p5_a1 JTF_NUMBER_TABLE

460: , x_return_status out nocopy VARCHAR2
461: , x_msg_count out nocopy NUMBER
462: , x_msg_data out nocopy VARCHAR2
463: , p5_a0 JTF_NUMBER_TABLE
464: , p5_a1 JTF_NUMBER_TABLE
465: , p5_a2 JTF_NUMBER_TABLE
466: , p5_a3 JTF_NUMBER_TABLE
467: , p5_a4 JTF_VARCHAR2_TABLE_100
468: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 465: , p5_a2 JTF_NUMBER_TABLE

461: , x_msg_count out nocopy NUMBER
462: , x_msg_data out nocopy VARCHAR2
463: , p5_a0 JTF_NUMBER_TABLE
464: , p5_a1 JTF_NUMBER_TABLE
465: , p5_a2 JTF_NUMBER_TABLE
466: , p5_a3 JTF_NUMBER_TABLE
467: , p5_a4 JTF_VARCHAR2_TABLE_100
468: , p5_a5 JTF_VARCHAR2_TABLE_100
469: , p5_a6 JTF_VARCHAR2_TABLE_300

Line 466: , p5_a3 JTF_NUMBER_TABLE

462: , x_msg_data out nocopy VARCHAR2
463: , p5_a0 JTF_NUMBER_TABLE
464: , p5_a1 JTF_NUMBER_TABLE
465: , p5_a2 JTF_NUMBER_TABLE
466: , p5_a3 JTF_NUMBER_TABLE
467: , p5_a4 JTF_VARCHAR2_TABLE_100
468: , p5_a5 JTF_VARCHAR2_TABLE_100
469: , p5_a6 JTF_VARCHAR2_TABLE_300
470: , p5_a7 JTF_VARCHAR2_TABLE_2000

Line 472: , p5_a9 JTF_NUMBER_TABLE

468: , p5_a5 JTF_VARCHAR2_TABLE_100
469: , p5_a6 JTF_VARCHAR2_TABLE_300
470: , p5_a7 JTF_VARCHAR2_TABLE_2000
471: , p5_a8 JTF_VARCHAR2_TABLE_100
472: , p5_a9 JTF_NUMBER_TABLE
473: , p5_a10 JTF_DATE_TABLE
474: , p5_a11 JTF_NUMBER_TABLE
475: , p5_a12 JTF_DATE_TABLE
476: , p5_a13 JTF_NUMBER_TABLE

Line 474: , p5_a11 JTF_NUMBER_TABLE

470: , p5_a7 JTF_VARCHAR2_TABLE_2000
471: , p5_a8 JTF_VARCHAR2_TABLE_100
472: , p5_a9 JTF_NUMBER_TABLE
473: , p5_a10 JTF_DATE_TABLE
474: , p5_a11 JTF_NUMBER_TABLE
475: , p5_a12 JTF_DATE_TABLE
476: , p5_a13 JTF_NUMBER_TABLE
477: , p6_a0 out nocopy JTF_NUMBER_TABLE
478: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 476: , p5_a13 JTF_NUMBER_TABLE

472: , p5_a9 JTF_NUMBER_TABLE
473: , p5_a10 JTF_DATE_TABLE
474: , p5_a11 JTF_NUMBER_TABLE
475: , p5_a12 JTF_DATE_TABLE
476: , p5_a13 JTF_NUMBER_TABLE
477: , p6_a0 out nocopy JTF_NUMBER_TABLE
478: , p6_a1 out nocopy JTF_NUMBER_TABLE
479: , p6_a2 out nocopy JTF_NUMBER_TABLE
480: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 477: , p6_a0 out nocopy JTF_NUMBER_TABLE

473: , p5_a10 JTF_DATE_TABLE
474: , p5_a11 JTF_NUMBER_TABLE
475: , p5_a12 JTF_DATE_TABLE
476: , p5_a13 JTF_NUMBER_TABLE
477: , p6_a0 out nocopy JTF_NUMBER_TABLE
478: , p6_a1 out nocopy JTF_NUMBER_TABLE
479: , p6_a2 out nocopy JTF_NUMBER_TABLE
480: , p6_a3 out nocopy JTF_NUMBER_TABLE
481: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 478: , p6_a1 out nocopy JTF_NUMBER_TABLE

474: , p5_a11 JTF_NUMBER_TABLE
475: , p5_a12 JTF_DATE_TABLE
476: , p5_a13 JTF_NUMBER_TABLE
477: , p6_a0 out nocopy JTF_NUMBER_TABLE
478: , p6_a1 out nocopy JTF_NUMBER_TABLE
479: , p6_a2 out nocopy JTF_NUMBER_TABLE
480: , p6_a3 out nocopy JTF_NUMBER_TABLE
481: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
482: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 479: , p6_a2 out nocopy JTF_NUMBER_TABLE

475: , p5_a12 JTF_DATE_TABLE
476: , p5_a13 JTF_NUMBER_TABLE
477: , p6_a0 out nocopy JTF_NUMBER_TABLE
478: , p6_a1 out nocopy JTF_NUMBER_TABLE
479: , p6_a2 out nocopy JTF_NUMBER_TABLE
480: , p6_a3 out nocopy JTF_NUMBER_TABLE
481: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
482: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
483: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300

Line 480: , p6_a3 out nocopy JTF_NUMBER_TABLE

476: , p5_a13 JTF_NUMBER_TABLE
477: , p6_a0 out nocopy JTF_NUMBER_TABLE
478: , p6_a1 out nocopy JTF_NUMBER_TABLE
479: , p6_a2 out nocopy JTF_NUMBER_TABLE
480: , p6_a3 out nocopy JTF_NUMBER_TABLE
481: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
482: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
483: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
484: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000

Line 486: , p6_a9 out nocopy JTF_NUMBER_TABLE

482: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
483: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
484: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000
485: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
486: , p6_a9 out nocopy JTF_NUMBER_TABLE
487: , p6_a10 out nocopy JTF_DATE_TABLE
488: , p6_a11 out nocopy JTF_NUMBER_TABLE
489: , p6_a12 out nocopy JTF_DATE_TABLE
490: , p6_a13 out nocopy JTF_NUMBER_TABLE

Line 488: , p6_a11 out nocopy JTF_NUMBER_TABLE

484: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000
485: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
486: , p6_a9 out nocopy JTF_NUMBER_TABLE
487: , p6_a10 out nocopy JTF_DATE_TABLE
488: , p6_a11 out nocopy JTF_NUMBER_TABLE
489: , p6_a12 out nocopy JTF_DATE_TABLE
490: , p6_a13 out nocopy JTF_NUMBER_TABLE
491: )
492:

Line 490: , p6_a13 out nocopy JTF_NUMBER_TABLE

486: , p6_a9 out nocopy JTF_NUMBER_TABLE
487: , p6_a10 out nocopy JTF_DATE_TABLE
488: , p6_a11 out nocopy JTF_NUMBER_TABLE
489: , p6_a12 out nocopy JTF_DATE_TABLE
490: , p6_a13 out nocopy JTF_NUMBER_TABLE
491: )
492:
493: as
494: ddp_rcsv_tbl okl_rcs_pvt.okl_rcsv_tbl;

Line 655: , p5_a0 JTF_NUMBER_TABLE

651: , p_init_msg_list VARCHAR2
652: , x_return_status out nocopy VARCHAR2
653: , x_msg_count out nocopy NUMBER
654: , x_msg_data out nocopy VARCHAR2
655: , p5_a0 JTF_NUMBER_TABLE
656: , p5_a1 JTF_NUMBER_TABLE
657: , p5_a2 JTF_NUMBER_TABLE
658: , p5_a3 JTF_NUMBER_TABLE
659: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 656: , p5_a1 JTF_NUMBER_TABLE

652: , x_return_status out nocopy VARCHAR2
653: , x_msg_count out nocopy NUMBER
654: , x_msg_data out nocopy VARCHAR2
655: , p5_a0 JTF_NUMBER_TABLE
656: , p5_a1 JTF_NUMBER_TABLE
657: , p5_a2 JTF_NUMBER_TABLE
658: , p5_a3 JTF_NUMBER_TABLE
659: , p5_a4 JTF_VARCHAR2_TABLE_100
660: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 657: , p5_a2 JTF_NUMBER_TABLE

653: , x_msg_count out nocopy NUMBER
654: , x_msg_data out nocopy VARCHAR2
655: , p5_a0 JTF_NUMBER_TABLE
656: , p5_a1 JTF_NUMBER_TABLE
657: , p5_a2 JTF_NUMBER_TABLE
658: , p5_a3 JTF_NUMBER_TABLE
659: , p5_a4 JTF_VARCHAR2_TABLE_100
660: , p5_a5 JTF_VARCHAR2_TABLE_100
661: , p5_a6 JTF_VARCHAR2_TABLE_300

Line 658: , p5_a3 JTF_NUMBER_TABLE

654: , x_msg_data out nocopy VARCHAR2
655: , p5_a0 JTF_NUMBER_TABLE
656: , p5_a1 JTF_NUMBER_TABLE
657: , p5_a2 JTF_NUMBER_TABLE
658: , p5_a3 JTF_NUMBER_TABLE
659: , p5_a4 JTF_VARCHAR2_TABLE_100
660: , p5_a5 JTF_VARCHAR2_TABLE_100
661: , p5_a6 JTF_VARCHAR2_TABLE_300
662: , p5_a7 JTF_VARCHAR2_TABLE_2000

Line 664: , p5_a9 JTF_NUMBER_TABLE

660: , p5_a5 JTF_VARCHAR2_TABLE_100
661: , p5_a6 JTF_VARCHAR2_TABLE_300
662: , p5_a7 JTF_VARCHAR2_TABLE_2000
663: , p5_a8 JTF_VARCHAR2_TABLE_100
664: , p5_a9 JTF_NUMBER_TABLE
665: , p5_a10 JTF_DATE_TABLE
666: , p5_a11 JTF_NUMBER_TABLE
667: , p5_a12 JTF_DATE_TABLE
668: , p5_a13 JTF_NUMBER_TABLE

Line 666: , p5_a11 JTF_NUMBER_TABLE

662: , p5_a7 JTF_VARCHAR2_TABLE_2000
663: , p5_a8 JTF_VARCHAR2_TABLE_100
664: , p5_a9 JTF_NUMBER_TABLE
665: , p5_a10 JTF_DATE_TABLE
666: , p5_a11 JTF_NUMBER_TABLE
667: , p5_a12 JTF_DATE_TABLE
668: , p5_a13 JTF_NUMBER_TABLE
669: , p6_a0 out nocopy JTF_NUMBER_TABLE
670: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 668: , p5_a13 JTF_NUMBER_TABLE

664: , p5_a9 JTF_NUMBER_TABLE
665: , p5_a10 JTF_DATE_TABLE
666: , p5_a11 JTF_NUMBER_TABLE
667: , p5_a12 JTF_DATE_TABLE
668: , p5_a13 JTF_NUMBER_TABLE
669: , p6_a0 out nocopy JTF_NUMBER_TABLE
670: , p6_a1 out nocopy JTF_NUMBER_TABLE
671: , p6_a2 out nocopy JTF_NUMBER_TABLE
672: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 669: , p6_a0 out nocopy JTF_NUMBER_TABLE

665: , p5_a10 JTF_DATE_TABLE
666: , p5_a11 JTF_NUMBER_TABLE
667: , p5_a12 JTF_DATE_TABLE
668: , p5_a13 JTF_NUMBER_TABLE
669: , p6_a0 out nocopy JTF_NUMBER_TABLE
670: , p6_a1 out nocopy JTF_NUMBER_TABLE
671: , p6_a2 out nocopy JTF_NUMBER_TABLE
672: , p6_a3 out nocopy JTF_NUMBER_TABLE
673: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 670: , p6_a1 out nocopy JTF_NUMBER_TABLE

666: , p5_a11 JTF_NUMBER_TABLE
667: , p5_a12 JTF_DATE_TABLE
668: , p5_a13 JTF_NUMBER_TABLE
669: , p6_a0 out nocopy JTF_NUMBER_TABLE
670: , p6_a1 out nocopy JTF_NUMBER_TABLE
671: , p6_a2 out nocopy JTF_NUMBER_TABLE
672: , p6_a3 out nocopy JTF_NUMBER_TABLE
673: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
674: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 671: , p6_a2 out nocopy JTF_NUMBER_TABLE

667: , p5_a12 JTF_DATE_TABLE
668: , p5_a13 JTF_NUMBER_TABLE
669: , p6_a0 out nocopy JTF_NUMBER_TABLE
670: , p6_a1 out nocopy JTF_NUMBER_TABLE
671: , p6_a2 out nocopy JTF_NUMBER_TABLE
672: , p6_a3 out nocopy JTF_NUMBER_TABLE
673: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
674: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
675: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300

Line 672: , p6_a3 out nocopy JTF_NUMBER_TABLE

668: , p5_a13 JTF_NUMBER_TABLE
669: , p6_a0 out nocopy JTF_NUMBER_TABLE
670: , p6_a1 out nocopy JTF_NUMBER_TABLE
671: , p6_a2 out nocopy JTF_NUMBER_TABLE
672: , p6_a3 out nocopy JTF_NUMBER_TABLE
673: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
674: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
675: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
676: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000

Line 678: , p6_a9 out nocopy JTF_NUMBER_TABLE

674: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
675: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
676: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000
677: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
678: , p6_a9 out nocopy JTF_NUMBER_TABLE
679: , p6_a10 out nocopy JTF_DATE_TABLE
680: , p6_a11 out nocopy JTF_NUMBER_TABLE
681: , p6_a12 out nocopy JTF_DATE_TABLE
682: , p6_a13 out nocopy JTF_NUMBER_TABLE

Line 680: , p6_a11 out nocopy JTF_NUMBER_TABLE

676: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000
677: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
678: , p6_a9 out nocopy JTF_NUMBER_TABLE
679: , p6_a10 out nocopy JTF_DATE_TABLE
680: , p6_a11 out nocopy JTF_NUMBER_TABLE
681: , p6_a12 out nocopy JTF_DATE_TABLE
682: , p6_a13 out nocopy JTF_NUMBER_TABLE
683: )
684:

Line 682: , p6_a13 out nocopy JTF_NUMBER_TABLE

678: , p6_a9 out nocopy JTF_NUMBER_TABLE
679: , p6_a10 out nocopy JTF_DATE_TABLE
680: , p6_a11 out nocopy JTF_NUMBER_TABLE
681: , p6_a12 out nocopy JTF_DATE_TABLE
682: , p6_a13 out nocopy JTF_NUMBER_TABLE
683: )
684:
685: as
686: ddp_rcsv_tbl okl_rcs_pvt.okl_rcsv_tbl;

Line 815: , p5_a0 JTF_NUMBER_TABLE

811: , p_init_msg_list VARCHAR2
812: , x_return_status out nocopy VARCHAR2
813: , x_msg_count out nocopy NUMBER
814: , x_msg_data out nocopy VARCHAR2
815: , p5_a0 JTF_NUMBER_TABLE
816: , p5_a1 JTF_NUMBER_TABLE
817: , p5_a2 JTF_NUMBER_TABLE
818: , p5_a3 JTF_NUMBER_TABLE
819: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 816: , p5_a1 JTF_NUMBER_TABLE

812: , x_return_status out nocopy VARCHAR2
813: , x_msg_count out nocopy NUMBER
814: , x_msg_data out nocopy VARCHAR2
815: , p5_a0 JTF_NUMBER_TABLE
816: , p5_a1 JTF_NUMBER_TABLE
817: , p5_a2 JTF_NUMBER_TABLE
818: , p5_a3 JTF_NUMBER_TABLE
819: , p5_a4 JTF_VARCHAR2_TABLE_100
820: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 817: , p5_a2 JTF_NUMBER_TABLE

813: , x_msg_count out nocopy NUMBER
814: , x_msg_data out nocopy VARCHAR2
815: , p5_a0 JTF_NUMBER_TABLE
816: , p5_a1 JTF_NUMBER_TABLE
817: , p5_a2 JTF_NUMBER_TABLE
818: , p5_a3 JTF_NUMBER_TABLE
819: , p5_a4 JTF_VARCHAR2_TABLE_100
820: , p5_a5 JTF_VARCHAR2_TABLE_100
821: , p5_a6 JTF_VARCHAR2_TABLE_300

Line 818: , p5_a3 JTF_NUMBER_TABLE

814: , x_msg_data out nocopy VARCHAR2
815: , p5_a0 JTF_NUMBER_TABLE
816: , p5_a1 JTF_NUMBER_TABLE
817: , p5_a2 JTF_NUMBER_TABLE
818: , p5_a3 JTF_NUMBER_TABLE
819: , p5_a4 JTF_VARCHAR2_TABLE_100
820: , p5_a5 JTF_VARCHAR2_TABLE_100
821: , p5_a6 JTF_VARCHAR2_TABLE_300
822: , p5_a7 JTF_VARCHAR2_TABLE_2000

Line 824: , p5_a9 JTF_NUMBER_TABLE

820: , p5_a5 JTF_VARCHAR2_TABLE_100
821: , p5_a6 JTF_VARCHAR2_TABLE_300
822: , p5_a7 JTF_VARCHAR2_TABLE_2000
823: , p5_a8 JTF_VARCHAR2_TABLE_100
824: , p5_a9 JTF_NUMBER_TABLE
825: , p5_a10 JTF_DATE_TABLE
826: , p5_a11 JTF_NUMBER_TABLE
827: , p5_a12 JTF_DATE_TABLE
828: , p5_a13 JTF_NUMBER_TABLE

Line 826: , p5_a11 JTF_NUMBER_TABLE

822: , p5_a7 JTF_VARCHAR2_TABLE_2000
823: , p5_a8 JTF_VARCHAR2_TABLE_100
824: , p5_a9 JTF_NUMBER_TABLE
825: , p5_a10 JTF_DATE_TABLE
826: , p5_a11 JTF_NUMBER_TABLE
827: , p5_a12 JTF_DATE_TABLE
828: , p5_a13 JTF_NUMBER_TABLE
829: )
830:

Line 828: , p5_a13 JTF_NUMBER_TABLE

824: , p5_a9 JTF_NUMBER_TABLE
825: , p5_a10 JTF_DATE_TABLE
826: , p5_a11 JTF_NUMBER_TABLE
827: , p5_a12 JTF_DATE_TABLE
828: , p5_a13 JTF_NUMBER_TABLE
829: )
830:
831: as
832: ddp_rcsv_tbl okl_rcs_pvt.okl_rcsv_tbl;