18: if n=b then return a; end if;
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p1(t out nocopy okl_am_asset_relocation_pvt.falo_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_NUMBER_TABLE
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p1(t out nocopy okl_am_asset_relocation_pvt.falo_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_NUMBER_TABLE
22: procedure rosetta_table_copy_in_p1(t out nocopy okl_am_asset_relocation_pvt.falo_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_NUMBER_TABLE
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_NUMBER_TABLE
33: ) as
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_NUMBER_TABLE
33: ) as
34: ddindx binary_integer; indx binary_integer;
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_NUMBER_TABLE
33: ) as
34: ddindx binary_integer; indx binary_integer;
35: begin
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_NUMBER_TABLE
32: , a10 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
57: end loop;
58: end if;
59: end if;
60: end rosetta_table_copy_in_p1;
61: procedure rosetta_table_copy_out_p1(t okl_am_asset_relocation_pvt.falo_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
62: , a1 out nocopy JTF_NUMBER_TABLE
63: , a2 out nocopy JTF_VARCHAR2_TABLE_100
64: , a3 out nocopy JTF_VARCHAR2_TABLE_100
65: , a4 out nocopy JTF_NUMBER_TABLE
58: end if;
59: end if;
60: end rosetta_table_copy_in_p1;
61: procedure rosetta_table_copy_out_p1(t okl_am_asset_relocation_pvt.falo_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
62: , a1 out nocopy JTF_NUMBER_TABLE
63: , a2 out nocopy JTF_VARCHAR2_TABLE_100
64: , a3 out nocopy JTF_VARCHAR2_TABLE_100
65: , a4 out nocopy JTF_NUMBER_TABLE
66: , a5 out nocopy JTF_NUMBER_TABLE
61: procedure rosetta_table_copy_out_p1(t okl_am_asset_relocation_pvt.falo_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
62: , a1 out nocopy JTF_NUMBER_TABLE
63: , a2 out nocopy JTF_VARCHAR2_TABLE_100
64: , a3 out nocopy JTF_VARCHAR2_TABLE_100
65: , a4 out nocopy JTF_NUMBER_TABLE
66: , a5 out nocopy JTF_NUMBER_TABLE
67: , a6 out nocopy JTF_NUMBER_TABLE
68: , a7 out nocopy JTF_NUMBER_TABLE
69: , a8 out nocopy JTF_NUMBER_TABLE
62: , a1 out nocopy JTF_NUMBER_TABLE
63: , a2 out nocopy JTF_VARCHAR2_TABLE_100
64: , a3 out nocopy JTF_VARCHAR2_TABLE_100
65: , a4 out nocopy JTF_NUMBER_TABLE
66: , a5 out nocopy JTF_NUMBER_TABLE
67: , a6 out nocopy JTF_NUMBER_TABLE
68: , a7 out nocopy JTF_NUMBER_TABLE
69: , a8 out nocopy JTF_NUMBER_TABLE
70: , a9 out nocopy JTF_NUMBER_TABLE
63: , a2 out nocopy JTF_VARCHAR2_TABLE_100
64: , a3 out nocopy JTF_VARCHAR2_TABLE_100
65: , a4 out nocopy JTF_NUMBER_TABLE
66: , a5 out nocopy JTF_NUMBER_TABLE
67: , a6 out nocopy JTF_NUMBER_TABLE
68: , a7 out nocopy JTF_NUMBER_TABLE
69: , a8 out nocopy JTF_NUMBER_TABLE
70: , a9 out nocopy JTF_NUMBER_TABLE
71: , a10 out nocopy JTF_NUMBER_TABLE
64: , a3 out nocopy JTF_VARCHAR2_TABLE_100
65: , a4 out nocopy JTF_NUMBER_TABLE
66: , a5 out nocopy JTF_NUMBER_TABLE
67: , a6 out nocopy JTF_NUMBER_TABLE
68: , a7 out nocopy JTF_NUMBER_TABLE
69: , a8 out nocopy JTF_NUMBER_TABLE
70: , a9 out nocopy JTF_NUMBER_TABLE
71: , a10 out nocopy JTF_NUMBER_TABLE
72: ) as
65: , a4 out nocopy JTF_NUMBER_TABLE
66: , a5 out nocopy JTF_NUMBER_TABLE
67: , a6 out nocopy JTF_NUMBER_TABLE
68: , a7 out nocopy JTF_NUMBER_TABLE
69: , a8 out nocopy JTF_NUMBER_TABLE
70: , a9 out nocopy JTF_NUMBER_TABLE
71: , a10 out nocopy JTF_NUMBER_TABLE
72: ) as
73: ddindx binary_integer; indx binary_integer;
66: , a5 out nocopy JTF_NUMBER_TABLE
67: , a6 out nocopy JTF_NUMBER_TABLE
68: , a7 out nocopy JTF_NUMBER_TABLE
69: , a8 out nocopy JTF_NUMBER_TABLE
70: , a9 out nocopy JTF_NUMBER_TABLE
71: , a10 out nocopy JTF_NUMBER_TABLE
72: ) as
73: ddindx binary_integer; indx binary_integer;
74: begin
67: , a6 out nocopy JTF_NUMBER_TABLE
68: , a7 out nocopy JTF_NUMBER_TABLE
69: , a8 out nocopy JTF_NUMBER_TABLE
70: , a9 out nocopy JTF_NUMBER_TABLE
71: , a10 out nocopy JTF_NUMBER_TABLE
72: ) as
73: ddindx binary_integer; indx binary_integer;
74: begin
75: if t is null or t.count = 0 then
72: ) as
73: ddindx binary_integer; indx binary_integer;
74: begin
75: if t is null or t.count = 0 then
76: a0 := JTF_NUMBER_TABLE();
77: a1 := JTF_NUMBER_TABLE();
78: a2 := JTF_VARCHAR2_TABLE_100();
79: a3 := JTF_VARCHAR2_TABLE_100();
80: a4 := JTF_NUMBER_TABLE();
73: ddindx binary_integer; indx binary_integer;
74: begin
75: if t is null or t.count = 0 then
76: a0 := JTF_NUMBER_TABLE();
77: a1 := JTF_NUMBER_TABLE();
78: a2 := JTF_VARCHAR2_TABLE_100();
79: a3 := JTF_VARCHAR2_TABLE_100();
80: a4 := JTF_NUMBER_TABLE();
81: a5 := JTF_NUMBER_TABLE();
76: a0 := JTF_NUMBER_TABLE();
77: a1 := JTF_NUMBER_TABLE();
78: a2 := JTF_VARCHAR2_TABLE_100();
79: a3 := JTF_VARCHAR2_TABLE_100();
80: a4 := JTF_NUMBER_TABLE();
81: a5 := JTF_NUMBER_TABLE();
82: a6 := JTF_NUMBER_TABLE();
83: a7 := JTF_NUMBER_TABLE();
84: a8 := JTF_NUMBER_TABLE();
77: a1 := JTF_NUMBER_TABLE();
78: a2 := JTF_VARCHAR2_TABLE_100();
79: a3 := JTF_VARCHAR2_TABLE_100();
80: a4 := JTF_NUMBER_TABLE();
81: a5 := JTF_NUMBER_TABLE();
82: a6 := JTF_NUMBER_TABLE();
83: a7 := JTF_NUMBER_TABLE();
84: a8 := JTF_NUMBER_TABLE();
85: a9 := JTF_NUMBER_TABLE();
78: a2 := JTF_VARCHAR2_TABLE_100();
79: a3 := JTF_VARCHAR2_TABLE_100();
80: a4 := JTF_NUMBER_TABLE();
81: a5 := JTF_NUMBER_TABLE();
82: a6 := JTF_NUMBER_TABLE();
83: a7 := JTF_NUMBER_TABLE();
84: a8 := JTF_NUMBER_TABLE();
85: a9 := JTF_NUMBER_TABLE();
86: a10 := JTF_NUMBER_TABLE();
79: a3 := JTF_VARCHAR2_TABLE_100();
80: a4 := JTF_NUMBER_TABLE();
81: a5 := JTF_NUMBER_TABLE();
82: a6 := JTF_NUMBER_TABLE();
83: a7 := JTF_NUMBER_TABLE();
84: a8 := JTF_NUMBER_TABLE();
85: a9 := JTF_NUMBER_TABLE();
86: a10 := JTF_NUMBER_TABLE();
87: else
80: a4 := JTF_NUMBER_TABLE();
81: a5 := JTF_NUMBER_TABLE();
82: a6 := JTF_NUMBER_TABLE();
83: a7 := JTF_NUMBER_TABLE();
84: a8 := JTF_NUMBER_TABLE();
85: a9 := JTF_NUMBER_TABLE();
86: a10 := JTF_NUMBER_TABLE();
87: else
88: a0 := JTF_NUMBER_TABLE();
81: a5 := JTF_NUMBER_TABLE();
82: a6 := JTF_NUMBER_TABLE();
83: a7 := JTF_NUMBER_TABLE();
84: a8 := JTF_NUMBER_TABLE();
85: a9 := JTF_NUMBER_TABLE();
86: a10 := JTF_NUMBER_TABLE();
87: else
88: a0 := JTF_NUMBER_TABLE();
89: a1 := JTF_NUMBER_TABLE();
82: a6 := JTF_NUMBER_TABLE();
83: a7 := JTF_NUMBER_TABLE();
84: a8 := JTF_NUMBER_TABLE();
85: a9 := JTF_NUMBER_TABLE();
86: a10 := JTF_NUMBER_TABLE();
87: else
88: a0 := JTF_NUMBER_TABLE();
89: a1 := JTF_NUMBER_TABLE();
90: a2 := JTF_VARCHAR2_TABLE_100();
84: a8 := JTF_NUMBER_TABLE();
85: a9 := JTF_NUMBER_TABLE();
86: a10 := JTF_NUMBER_TABLE();
87: else
88: a0 := JTF_NUMBER_TABLE();
89: a1 := JTF_NUMBER_TABLE();
90: a2 := JTF_VARCHAR2_TABLE_100();
91: a3 := JTF_VARCHAR2_TABLE_100();
92: a4 := JTF_NUMBER_TABLE();
85: a9 := JTF_NUMBER_TABLE();
86: a10 := JTF_NUMBER_TABLE();
87: else
88: a0 := JTF_NUMBER_TABLE();
89: a1 := JTF_NUMBER_TABLE();
90: a2 := JTF_VARCHAR2_TABLE_100();
91: a3 := JTF_VARCHAR2_TABLE_100();
92: a4 := JTF_NUMBER_TABLE();
93: a5 := JTF_NUMBER_TABLE();
88: a0 := JTF_NUMBER_TABLE();
89: a1 := JTF_NUMBER_TABLE();
90: a2 := JTF_VARCHAR2_TABLE_100();
91: a3 := JTF_VARCHAR2_TABLE_100();
92: a4 := JTF_NUMBER_TABLE();
93: a5 := JTF_NUMBER_TABLE();
94: a6 := JTF_NUMBER_TABLE();
95: a7 := JTF_NUMBER_TABLE();
96: a8 := JTF_NUMBER_TABLE();
89: a1 := JTF_NUMBER_TABLE();
90: a2 := JTF_VARCHAR2_TABLE_100();
91: a3 := JTF_VARCHAR2_TABLE_100();
92: a4 := JTF_NUMBER_TABLE();
93: a5 := JTF_NUMBER_TABLE();
94: a6 := JTF_NUMBER_TABLE();
95: a7 := JTF_NUMBER_TABLE();
96: a8 := JTF_NUMBER_TABLE();
97: a9 := JTF_NUMBER_TABLE();
90: a2 := JTF_VARCHAR2_TABLE_100();
91: a3 := JTF_VARCHAR2_TABLE_100();
92: a4 := JTF_NUMBER_TABLE();
93: a5 := JTF_NUMBER_TABLE();
94: a6 := JTF_NUMBER_TABLE();
95: a7 := JTF_NUMBER_TABLE();
96: a8 := JTF_NUMBER_TABLE();
97: a9 := JTF_NUMBER_TABLE();
98: a10 := JTF_NUMBER_TABLE();
91: a3 := JTF_VARCHAR2_TABLE_100();
92: a4 := JTF_NUMBER_TABLE();
93: a5 := JTF_NUMBER_TABLE();
94: a6 := JTF_NUMBER_TABLE();
95: a7 := JTF_NUMBER_TABLE();
96: a8 := JTF_NUMBER_TABLE();
97: a9 := JTF_NUMBER_TABLE();
98: a10 := JTF_NUMBER_TABLE();
99: if t.count > 0 then
92: a4 := JTF_NUMBER_TABLE();
93: a5 := JTF_NUMBER_TABLE();
94: a6 := JTF_NUMBER_TABLE();
95: a7 := JTF_NUMBER_TABLE();
96: a8 := JTF_NUMBER_TABLE();
97: a9 := JTF_NUMBER_TABLE();
98: a10 := JTF_NUMBER_TABLE();
99: if t.count > 0 then
100: a0.extend(t.count);
93: a5 := JTF_NUMBER_TABLE();
94: a6 := JTF_NUMBER_TABLE();
95: a7 := JTF_NUMBER_TABLE();
96: a8 := JTF_NUMBER_TABLE();
97: a9 := JTF_NUMBER_TABLE();
98: a10 := JTF_NUMBER_TABLE();
99: if t.count > 0 then
100: a0.extend(t.count);
101: a1.extend(t.count);
94: a6 := JTF_NUMBER_TABLE();
95: a7 := JTF_NUMBER_TABLE();
96: a8 := JTF_NUMBER_TABLE();
97: a9 := JTF_NUMBER_TABLE();
98: a10 := JTF_NUMBER_TABLE();
99: if t.count > 0 then
100: a0.extend(t.count);
101: a1.extend(t.count);
102: a2.extend(t.count);
131: end if;
132: end if;
133: end rosetta_table_copy_out_p1;
134:
135: procedure rosetta_table_copy_in_p3(t out nocopy okl_am_asset_relocation_pvt.ialo_tbl_type, a0 JTF_NUMBER_TABLE
136: , a1 JTF_NUMBER_TABLE
137: , a2 JTF_NUMBER_TABLE
138: ) as
139: ddindx binary_integer; indx binary_integer;
132: end if;
133: end rosetta_table_copy_out_p1;
134:
135: procedure rosetta_table_copy_in_p3(t out nocopy okl_am_asset_relocation_pvt.ialo_tbl_type, a0 JTF_NUMBER_TABLE
136: , a1 JTF_NUMBER_TABLE
137: , a2 JTF_NUMBER_TABLE
138: ) as
139: ddindx binary_integer; indx binary_integer;
140: begin
133: end rosetta_table_copy_out_p1;
134:
135: procedure rosetta_table_copy_in_p3(t out nocopy okl_am_asset_relocation_pvt.ialo_tbl_type, a0 JTF_NUMBER_TABLE
136: , a1 JTF_NUMBER_TABLE
137: , a2 JTF_NUMBER_TABLE
138: ) as
139: ddindx binary_integer; indx binary_integer;
140: begin
141: if a0 is not null and a0.count > 0 then
154: end loop;
155: end if;
156: end if;
157: end rosetta_table_copy_in_p3;
158: procedure rosetta_table_copy_out_p3(t okl_am_asset_relocation_pvt.ialo_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
159: , a1 out nocopy JTF_NUMBER_TABLE
160: , a2 out nocopy JTF_NUMBER_TABLE
161: ) as
162: ddindx binary_integer; indx binary_integer;
155: end if;
156: end if;
157: end rosetta_table_copy_in_p3;
158: procedure rosetta_table_copy_out_p3(t okl_am_asset_relocation_pvt.ialo_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
159: , a1 out nocopy JTF_NUMBER_TABLE
160: , a2 out nocopy JTF_NUMBER_TABLE
161: ) as
162: ddindx binary_integer; indx binary_integer;
163: begin
156: end if;
157: end rosetta_table_copy_in_p3;
158: procedure rosetta_table_copy_out_p3(t okl_am_asset_relocation_pvt.ialo_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
159: , a1 out nocopy JTF_NUMBER_TABLE
160: , a2 out nocopy JTF_NUMBER_TABLE
161: ) as
162: ddindx binary_integer; indx binary_integer;
163: begin
164: if t is null or t.count = 0 then
161: ) as
162: ddindx binary_integer; indx binary_integer;
163: begin
164: if t is null or t.count = 0 then
165: a0 := JTF_NUMBER_TABLE();
166: a1 := JTF_NUMBER_TABLE();
167: a2 := JTF_NUMBER_TABLE();
168: else
169: a0 := JTF_NUMBER_TABLE();
162: ddindx binary_integer; indx binary_integer;
163: begin
164: if t is null or t.count = 0 then
165: a0 := JTF_NUMBER_TABLE();
166: a1 := JTF_NUMBER_TABLE();
167: a2 := JTF_NUMBER_TABLE();
168: else
169: a0 := JTF_NUMBER_TABLE();
170: a1 := JTF_NUMBER_TABLE();
163: begin
164: if t is null or t.count = 0 then
165: a0 := JTF_NUMBER_TABLE();
166: a1 := JTF_NUMBER_TABLE();
167: a2 := JTF_NUMBER_TABLE();
168: else
169: a0 := JTF_NUMBER_TABLE();
170: a1 := JTF_NUMBER_TABLE();
171: a2 := JTF_NUMBER_TABLE();
165: a0 := JTF_NUMBER_TABLE();
166: a1 := JTF_NUMBER_TABLE();
167: a2 := JTF_NUMBER_TABLE();
168: else
169: a0 := JTF_NUMBER_TABLE();
170: a1 := JTF_NUMBER_TABLE();
171: a2 := JTF_NUMBER_TABLE();
172: if t.count > 0 then
173: a0.extend(t.count);
166: a1 := JTF_NUMBER_TABLE();
167: a2 := JTF_NUMBER_TABLE();
168: else
169: a0 := JTF_NUMBER_TABLE();
170: a1 := JTF_NUMBER_TABLE();
171: a2 := JTF_NUMBER_TABLE();
172: if t.count > 0 then
173: a0.extend(t.count);
174: a1.extend(t.count);
167: a2 := JTF_NUMBER_TABLE();
168: else
169: a0 := JTF_NUMBER_TABLE();
170: a1 := JTF_NUMBER_TABLE();
171: a2 := JTF_NUMBER_TABLE();
172: if t.count > 0 then
173: a0.extend(t.count);
174: a1.extend(t.count);
175: a2.extend(t.count);
193: , p_init_msg_list VARCHAR2
194: , x_return_status out nocopy VARCHAR2
195: , x_msg_count out nocopy NUMBER
196: , x_msg_data out nocopy VARCHAR2
197: , p5_a0 JTF_NUMBER_TABLE
198: , p5_a1 JTF_NUMBER_TABLE
199: , p5_a2 JTF_NUMBER_TABLE
200: )
201:
194: , x_return_status out nocopy VARCHAR2
195: , x_msg_count out nocopy NUMBER
196: , x_msg_data out nocopy VARCHAR2
197: , p5_a0 JTF_NUMBER_TABLE
198: , p5_a1 JTF_NUMBER_TABLE
199: , p5_a2 JTF_NUMBER_TABLE
200: )
201:
202: as
195: , x_msg_count out nocopy NUMBER
196: , x_msg_data out nocopy VARCHAR2
197: , p5_a0 JTF_NUMBER_TABLE
198: , p5_a1 JTF_NUMBER_TABLE
199: , p5_a2 JTF_NUMBER_TABLE
200: )
201:
202: as
203: ddp_ialo_tbl okl_am_asset_relocation_pvt.ialo_tbl_type;
235: , p_init_msg_list VARCHAR2
236: , x_return_status out nocopy VARCHAR2
237: , x_msg_count out nocopy NUMBER
238: , x_msg_data out nocopy VARCHAR2
239: , p5_a0 JTF_NUMBER_TABLE
240: , p5_a1 JTF_NUMBER_TABLE
241: , p5_a2 JTF_VARCHAR2_TABLE_100
242: , p5_a3 JTF_VARCHAR2_TABLE_100
243: , p5_a4 JTF_NUMBER_TABLE
236: , x_return_status out nocopy VARCHAR2
237: , x_msg_count out nocopy NUMBER
238: , x_msg_data out nocopy VARCHAR2
239: , p5_a0 JTF_NUMBER_TABLE
240: , p5_a1 JTF_NUMBER_TABLE
241: , p5_a2 JTF_VARCHAR2_TABLE_100
242: , p5_a3 JTF_VARCHAR2_TABLE_100
243: , p5_a4 JTF_NUMBER_TABLE
244: , p5_a5 JTF_NUMBER_TABLE
239: , p5_a0 JTF_NUMBER_TABLE
240: , p5_a1 JTF_NUMBER_TABLE
241: , p5_a2 JTF_VARCHAR2_TABLE_100
242: , p5_a3 JTF_VARCHAR2_TABLE_100
243: , p5_a4 JTF_NUMBER_TABLE
244: , p5_a5 JTF_NUMBER_TABLE
245: , p5_a6 JTF_NUMBER_TABLE
246: , p5_a7 JTF_NUMBER_TABLE
247: , p5_a8 JTF_NUMBER_TABLE
240: , p5_a1 JTF_NUMBER_TABLE
241: , p5_a2 JTF_VARCHAR2_TABLE_100
242: , p5_a3 JTF_VARCHAR2_TABLE_100
243: , p5_a4 JTF_NUMBER_TABLE
244: , p5_a5 JTF_NUMBER_TABLE
245: , p5_a6 JTF_NUMBER_TABLE
246: , p5_a7 JTF_NUMBER_TABLE
247: , p5_a8 JTF_NUMBER_TABLE
248: , p5_a9 JTF_NUMBER_TABLE
241: , p5_a2 JTF_VARCHAR2_TABLE_100
242: , p5_a3 JTF_VARCHAR2_TABLE_100
243: , p5_a4 JTF_NUMBER_TABLE
244: , p5_a5 JTF_NUMBER_TABLE
245: , p5_a6 JTF_NUMBER_TABLE
246: , p5_a7 JTF_NUMBER_TABLE
247: , p5_a8 JTF_NUMBER_TABLE
248: , p5_a9 JTF_NUMBER_TABLE
249: , p5_a10 JTF_NUMBER_TABLE
242: , p5_a3 JTF_VARCHAR2_TABLE_100
243: , p5_a4 JTF_NUMBER_TABLE
244: , p5_a5 JTF_NUMBER_TABLE
245: , p5_a6 JTF_NUMBER_TABLE
246: , p5_a7 JTF_NUMBER_TABLE
247: , p5_a8 JTF_NUMBER_TABLE
248: , p5_a9 JTF_NUMBER_TABLE
249: , p5_a10 JTF_NUMBER_TABLE
250: )
243: , p5_a4 JTF_NUMBER_TABLE
244: , p5_a5 JTF_NUMBER_TABLE
245: , p5_a6 JTF_NUMBER_TABLE
246: , p5_a7 JTF_NUMBER_TABLE
247: , p5_a8 JTF_NUMBER_TABLE
248: , p5_a9 JTF_NUMBER_TABLE
249: , p5_a10 JTF_NUMBER_TABLE
250: )
251:
244: , p5_a5 JTF_NUMBER_TABLE
245: , p5_a6 JTF_NUMBER_TABLE
246: , p5_a7 JTF_NUMBER_TABLE
247: , p5_a8 JTF_NUMBER_TABLE
248: , p5_a9 JTF_NUMBER_TABLE
249: , p5_a10 JTF_NUMBER_TABLE
250: )
251:
252: as
245: , p5_a6 JTF_NUMBER_TABLE
246: , p5_a7 JTF_NUMBER_TABLE
247: , p5_a8 JTF_NUMBER_TABLE
248: , p5_a9 JTF_NUMBER_TABLE
249: , p5_a10 JTF_NUMBER_TABLE
250: )
251:
252: as
253: ddp_falo_tbl okl_am_asset_relocation_pvt.falo_tbl_type;
293: , p_init_msg_list VARCHAR2
294: , x_return_status out nocopy VARCHAR2
295: , x_msg_count out nocopy NUMBER
296: , x_msg_data out nocopy VARCHAR2
297: , p5_a0 JTF_NUMBER_TABLE
298: , p5_a1 JTF_NUMBER_TABLE
299: , p5_a2 JTF_VARCHAR2_TABLE_100
300: , p5_a3 JTF_VARCHAR2_TABLE_100
301: , p5_a4 JTF_NUMBER_TABLE
294: , x_return_status out nocopy VARCHAR2
295: , x_msg_count out nocopy NUMBER
296: , x_msg_data out nocopy VARCHAR2
297: , p5_a0 JTF_NUMBER_TABLE
298: , p5_a1 JTF_NUMBER_TABLE
299: , p5_a2 JTF_VARCHAR2_TABLE_100
300: , p5_a3 JTF_VARCHAR2_TABLE_100
301: , p5_a4 JTF_NUMBER_TABLE
302: , p5_a5 JTF_NUMBER_TABLE
297: , p5_a0 JTF_NUMBER_TABLE
298: , p5_a1 JTF_NUMBER_TABLE
299: , p5_a2 JTF_VARCHAR2_TABLE_100
300: , p5_a3 JTF_VARCHAR2_TABLE_100
301: , p5_a4 JTF_NUMBER_TABLE
302: , p5_a5 JTF_NUMBER_TABLE
303: , p5_a6 JTF_NUMBER_TABLE
304: , p5_a7 JTF_NUMBER_TABLE
305: , p5_a8 JTF_NUMBER_TABLE
298: , p5_a1 JTF_NUMBER_TABLE
299: , p5_a2 JTF_VARCHAR2_TABLE_100
300: , p5_a3 JTF_VARCHAR2_TABLE_100
301: , p5_a4 JTF_NUMBER_TABLE
302: , p5_a5 JTF_NUMBER_TABLE
303: , p5_a6 JTF_NUMBER_TABLE
304: , p5_a7 JTF_NUMBER_TABLE
305: , p5_a8 JTF_NUMBER_TABLE
306: , p5_a9 JTF_NUMBER_TABLE
299: , p5_a2 JTF_VARCHAR2_TABLE_100
300: , p5_a3 JTF_VARCHAR2_TABLE_100
301: , p5_a4 JTF_NUMBER_TABLE
302: , p5_a5 JTF_NUMBER_TABLE
303: , p5_a6 JTF_NUMBER_TABLE
304: , p5_a7 JTF_NUMBER_TABLE
305: , p5_a8 JTF_NUMBER_TABLE
306: , p5_a9 JTF_NUMBER_TABLE
307: , p5_a10 JTF_NUMBER_TABLE
300: , p5_a3 JTF_VARCHAR2_TABLE_100
301: , p5_a4 JTF_NUMBER_TABLE
302: , p5_a5 JTF_NUMBER_TABLE
303: , p5_a6 JTF_NUMBER_TABLE
304: , p5_a7 JTF_NUMBER_TABLE
305: , p5_a8 JTF_NUMBER_TABLE
306: , p5_a9 JTF_NUMBER_TABLE
307: , p5_a10 JTF_NUMBER_TABLE
308: )
301: , p5_a4 JTF_NUMBER_TABLE
302: , p5_a5 JTF_NUMBER_TABLE
303: , p5_a6 JTF_NUMBER_TABLE
304: , p5_a7 JTF_NUMBER_TABLE
305: , p5_a8 JTF_NUMBER_TABLE
306: , p5_a9 JTF_NUMBER_TABLE
307: , p5_a10 JTF_NUMBER_TABLE
308: )
309:
302: , p5_a5 JTF_NUMBER_TABLE
303: , p5_a6 JTF_NUMBER_TABLE
304: , p5_a7 JTF_NUMBER_TABLE
305: , p5_a8 JTF_NUMBER_TABLE
306: , p5_a9 JTF_NUMBER_TABLE
307: , p5_a10 JTF_NUMBER_TABLE
308: )
309:
310: as
303: , p5_a6 JTF_NUMBER_TABLE
304: , p5_a7 JTF_NUMBER_TABLE
305: , p5_a8 JTF_NUMBER_TABLE
306: , p5_a9 JTF_NUMBER_TABLE
307: , p5_a10 JTF_NUMBER_TABLE
308: )
309:
310: as
311: ddp_assets_tbl okl_am_asset_relocation_pvt.falo_tbl_type;