23: end;
24:
25: procedure rosetta_table_copy_in_p31(t out nocopy okl_mass_rebook_pvt.crit_tbl_type, a0 JTF_NUMBER_TABLE
26: , a1 JTF_VARCHAR2_TABLE_100
27: , a2 JTF_VARCHAR2_TABLE_200
28: , a3 JTF_VARCHAR2_TABLE_200
29: , a4 JTF_VARCHAR2_TABLE_200
30: , a5 JTF_VARCHAR2_TABLE_200
31: ) as
24:
25: procedure rosetta_table_copy_in_p31(t out nocopy okl_mass_rebook_pvt.crit_tbl_type, a0 JTF_NUMBER_TABLE
26: , a1 JTF_VARCHAR2_TABLE_100
27: , a2 JTF_VARCHAR2_TABLE_200
28: , a3 JTF_VARCHAR2_TABLE_200
29: , a4 JTF_VARCHAR2_TABLE_200
30: , a5 JTF_VARCHAR2_TABLE_200
31: ) as
32: ddindx binary_integer; indx binary_integer;
25: procedure rosetta_table_copy_in_p31(t out nocopy okl_mass_rebook_pvt.crit_tbl_type, a0 JTF_NUMBER_TABLE
26: , a1 JTF_VARCHAR2_TABLE_100
27: , a2 JTF_VARCHAR2_TABLE_200
28: , a3 JTF_VARCHAR2_TABLE_200
29: , a4 JTF_VARCHAR2_TABLE_200
30: , a5 JTF_VARCHAR2_TABLE_200
31: ) as
32: ddindx binary_integer; indx binary_integer;
33: begin
26: , a1 JTF_VARCHAR2_TABLE_100
27: , a2 JTF_VARCHAR2_TABLE_200
28: , a3 JTF_VARCHAR2_TABLE_200
29: , a4 JTF_VARCHAR2_TABLE_200
30: , a5 JTF_VARCHAR2_TABLE_200
31: ) as
32: ddindx binary_integer; indx binary_integer;
33: begin
34: if a0 is not null and a0.count > 0 then
52: end if;
53: end rosetta_table_copy_in_p31;
54: procedure rosetta_table_copy_out_p31(t okl_mass_rebook_pvt.crit_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
55: , a1 out nocopy JTF_VARCHAR2_TABLE_100
56: , a2 out nocopy JTF_VARCHAR2_TABLE_200
57: , a3 out nocopy JTF_VARCHAR2_TABLE_200
58: , a4 out nocopy JTF_VARCHAR2_TABLE_200
59: , a5 out nocopy JTF_VARCHAR2_TABLE_200
60: ) as
53: end rosetta_table_copy_in_p31;
54: procedure rosetta_table_copy_out_p31(t okl_mass_rebook_pvt.crit_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
55: , a1 out nocopy JTF_VARCHAR2_TABLE_100
56: , a2 out nocopy JTF_VARCHAR2_TABLE_200
57: , a3 out nocopy JTF_VARCHAR2_TABLE_200
58: , a4 out nocopy JTF_VARCHAR2_TABLE_200
59: , a5 out nocopy JTF_VARCHAR2_TABLE_200
60: ) as
61: ddindx binary_integer; indx binary_integer;
54: procedure rosetta_table_copy_out_p31(t okl_mass_rebook_pvt.crit_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
55: , a1 out nocopy JTF_VARCHAR2_TABLE_100
56: , a2 out nocopy JTF_VARCHAR2_TABLE_200
57: , a3 out nocopy JTF_VARCHAR2_TABLE_200
58: , a4 out nocopy JTF_VARCHAR2_TABLE_200
59: , a5 out nocopy JTF_VARCHAR2_TABLE_200
60: ) as
61: ddindx binary_integer; indx binary_integer;
62: begin
55: , a1 out nocopy JTF_VARCHAR2_TABLE_100
56: , a2 out nocopy JTF_VARCHAR2_TABLE_200
57: , a3 out nocopy JTF_VARCHAR2_TABLE_200
58: , a4 out nocopy JTF_VARCHAR2_TABLE_200
59: , a5 out nocopy JTF_VARCHAR2_TABLE_200
60: ) as
61: ddindx binary_integer; indx binary_integer;
62: begin
63: if t is null or t.count = 0 then
62: begin
63: if t is null or t.count = 0 then
64: a0 := JTF_NUMBER_TABLE();
65: a1 := JTF_VARCHAR2_TABLE_100();
66: a2 := JTF_VARCHAR2_TABLE_200();
67: a3 := JTF_VARCHAR2_TABLE_200();
68: a4 := JTF_VARCHAR2_TABLE_200();
69: a5 := JTF_VARCHAR2_TABLE_200();
70: else
63: if t is null or t.count = 0 then
64: a0 := JTF_NUMBER_TABLE();
65: a1 := JTF_VARCHAR2_TABLE_100();
66: a2 := JTF_VARCHAR2_TABLE_200();
67: a3 := JTF_VARCHAR2_TABLE_200();
68: a4 := JTF_VARCHAR2_TABLE_200();
69: a5 := JTF_VARCHAR2_TABLE_200();
70: else
71: a0 := JTF_NUMBER_TABLE();
64: a0 := JTF_NUMBER_TABLE();
65: a1 := JTF_VARCHAR2_TABLE_100();
66: a2 := JTF_VARCHAR2_TABLE_200();
67: a3 := JTF_VARCHAR2_TABLE_200();
68: a4 := JTF_VARCHAR2_TABLE_200();
69: a5 := JTF_VARCHAR2_TABLE_200();
70: else
71: a0 := JTF_NUMBER_TABLE();
72: a1 := JTF_VARCHAR2_TABLE_100();
65: a1 := JTF_VARCHAR2_TABLE_100();
66: a2 := JTF_VARCHAR2_TABLE_200();
67: a3 := JTF_VARCHAR2_TABLE_200();
68: a4 := JTF_VARCHAR2_TABLE_200();
69: a5 := JTF_VARCHAR2_TABLE_200();
70: else
71: a0 := JTF_NUMBER_TABLE();
72: a1 := JTF_VARCHAR2_TABLE_100();
73: a2 := JTF_VARCHAR2_TABLE_200();
69: a5 := JTF_VARCHAR2_TABLE_200();
70: else
71: a0 := JTF_NUMBER_TABLE();
72: a1 := JTF_VARCHAR2_TABLE_100();
73: a2 := JTF_VARCHAR2_TABLE_200();
74: a3 := JTF_VARCHAR2_TABLE_200();
75: a4 := JTF_VARCHAR2_TABLE_200();
76: a5 := JTF_VARCHAR2_TABLE_200();
77: if t.count > 0 then
70: else
71: a0 := JTF_NUMBER_TABLE();
72: a1 := JTF_VARCHAR2_TABLE_100();
73: a2 := JTF_VARCHAR2_TABLE_200();
74: a3 := JTF_VARCHAR2_TABLE_200();
75: a4 := JTF_VARCHAR2_TABLE_200();
76: a5 := JTF_VARCHAR2_TABLE_200();
77: if t.count > 0 then
78: a0.extend(t.count);
71: a0 := JTF_NUMBER_TABLE();
72: a1 := JTF_VARCHAR2_TABLE_100();
73: a2 := JTF_VARCHAR2_TABLE_200();
74: a3 := JTF_VARCHAR2_TABLE_200();
75: a4 := JTF_VARCHAR2_TABLE_200();
76: a5 := JTF_VARCHAR2_TABLE_200();
77: if t.count > 0 then
78: a0.extend(t.count);
79: a1.extend(t.count);
72: a1 := JTF_VARCHAR2_TABLE_100();
73: a2 := JTF_VARCHAR2_TABLE_200();
74: a3 := JTF_VARCHAR2_TABLE_200();
75: a4 := JTF_VARCHAR2_TABLE_200();
76: a5 := JTF_VARCHAR2_TABLE_200();
77: if t.count > 0 then
78: a0.extend(t.count);
79: a1.extend(t.count);
80: a2.extend(t.count);
100: end if;
101: end rosetta_table_copy_out_p31;
102:
103: procedure rosetta_table_copy_in_p33(t out nocopy okl_mass_rebook_pvt.rbk_tbl_type, a0 JTF_NUMBER_TABLE
104: , a1 JTF_VARCHAR2_TABLE_200
105: , a2 JTF_NUMBER_TABLE
106: , a3 JTF_VARCHAR2_TABLE_600
107: ) as
108: ddindx binary_integer; indx binary_integer;
125: end if;
126: end if;
127: end rosetta_table_copy_in_p33;
128: procedure rosetta_table_copy_out_p33(t okl_mass_rebook_pvt.rbk_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
129: , a1 out nocopy JTF_VARCHAR2_TABLE_200
130: , a2 out nocopy JTF_NUMBER_TABLE
131: , a3 out nocopy JTF_VARCHAR2_TABLE_600
132: ) as
133: ddindx binary_integer; indx binary_integer;
133: ddindx binary_integer; indx binary_integer;
134: begin
135: if t is null or t.count = 0 then
136: a0 := JTF_NUMBER_TABLE();
137: a1 := JTF_VARCHAR2_TABLE_200();
138: a2 := JTF_NUMBER_TABLE();
139: a3 := JTF_VARCHAR2_TABLE_600();
140: else
141: a0 := JTF_NUMBER_TABLE();
138: a2 := JTF_NUMBER_TABLE();
139: a3 := JTF_VARCHAR2_TABLE_600();
140: else
141: a0 := JTF_NUMBER_TABLE();
142: a1 := JTF_VARCHAR2_TABLE_200();
143: a2 := JTF_NUMBER_TABLE();
144: a3 := JTF_VARCHAR2_TABLE_600();
145: if t.count > 0 then
146: a0.extend(t.count);
182: , a15 JTF_VARCHAR2_TABLE_500
183: , a16 JTF_VARCHAR2_TABLE_500
184: , a17 JTF_VARCHAR2_TABLE_100
185: , a18 JTF_VARCHAR2_TABLE_100
186: , a19 JTF_VARCHAR2_TABLE_200
187: , a20 JTF_VARCHAR2_TABLE_100
188: , a21 JTF_VARCHAR2_TABLE_200
189: , a22 JTF_VARCHAR2_TABLE_100
190: , a23 JTF_VARCHAR2_TABLE_200
184: , a17 JTF_VARCHAR2_TABLE_100
185: , a18 JTF_VARCHAR2_TABLE_100
186: , a19 JTF_VARCHAR2_TABLE_200
187: , a20 JTF_VARCHAR2_TABLE_100
188: , a21 JTF_VARCHAR2_TABLE_200
189: , a22 JTF_VARCHAR2_TABLE_100
190: , a23 JTF_VARCHAR2_TABLE_200
191: , a24 JTF_VARCHAR2_TABLE_100
192: , a25 JTF_VARCHAR2_TABLE_100
186: , a19 JTF_VARCHAR2_TABLE_200
187: , a20 JTF_VARCHAR2_TABLE_100
188: , a21 JTF_VARCHAR2_TABLE_200
189: , a22 JTF_VARCHAR2_TABLE_100
190: , a23 JTF_VARCHAR2_TABLE_200
191: , a24 JTF_VARCHAR2_TABLE_100
192: , a25 JTF_VARCHAR2_TABLE_100
193: , a26 JTF_VARCHAR2_TABLE_100
194: ) as
253: , a15 out nocopy JTF_VARCHAR2_TABLE_500
254: , a16 out nocopy JTF_VARCHAR2_TABLE_500
255: , a17 out nocopy JTF_VARCHAR2_TABLE_100
256: , a18 out nocopy JTF_VARCHAR2_TABLE_100
257: , a19 out nocopy JTF_VARCHAR2_TABLE_200
258: , a20 out nocopy JTF_VARCHAR2_TABLE_100
259: , a21 out nocopy JTF_VARCHAR2_TABLE_200
260: , a22 out nocopy JTF_VARCHAR2_TABLE_100
261: , a23 out nocopy JTF_VARCHAR2_TABLE_200
255: , a17 out nocopy JTF_VARCHAR2_TABLE_100
256: , a18 out nocopy JTF_VARCHAR2_TABLE_100
257: , a19 out nocopy JTF_VARCHAR2_TABLE_200
258: , a20 out nocopy JTF_VARCHAR2_TABLE_100
259: , a21 out nocopy JTF_VARCHAR2_TABLE_200
260: , a22 out nocopy JTF_VARCHAR2_TABLE_100
261: , a23 out nocopy JTF_VARCHAR2_TABLE_200
262: , a24 out nocopy JTF_VARCHAR2_TABLE_100
263: , a25 out nocopy JTF_VARCHAR2_TABLE_100
257: , a19 out nocopy JTF_VARCHAR2_TABLE_200
258: , a20 out nocopy JTF_VARCHAR2_TABLE_100
259: , a21 out nocopy JTF_VARCHAR2_TABLE_200
260: , a22 out nocopy JTF_VARCHAR2_TABLE_100
261: , a23 out nocopy JTF_VARCHAR2_TABLE_200
262: , a24 out nocopy JTF_VARCHAR2_TABLE_100
263: , a25 out nocopy JTF_VARCHAR2_TABLE_100
264: , a26 out nocopy JTF_VARCHAR2_TABLE_100
265: ) as
284: a15 := JTF_VARCHAR2_TABLE_500();
285: a16 := JTF_VARCHAR2_TABLE_500();
286: a17 := JTF_VARCHAR2_TABLE_100();
287: a18 := JTF_VARCHAR2_TABLE_100();
288: a19 := JTF_VARCHAR2_TABLE_200();
289: a20 := JTF_VARCHAR2_TABLE_100();
290: a21 := JTF_VARCHAR2_TABLE_200();
291: a22 := JTF_VARCHAR2_TABLE_100();
292: a23 := JTF_VARCHAR2_TABLE_200();
286: a17 := JTF_VARCHAR2_TABLE_100();
287: a18 := JTF_VARCHAR2_TABLE_100();
288: a19 := JTF_VARCHAR2_TABLE_200();
289: a20 := JTF_VARCHAR2_TABLE_100();
290: a21 := JTF_VARCHAR2_TABLE_200();
291: a22 := JTF_VARCHAR2_TABLE_100();
292: a23 := JTF_VARCHAR2_TABLE_200();
293: a24 := JTF_VARCHAR2_TABLE_100();
294: a25 := JTF_VARCHAR2_TABLE_100();
288: a19 := JTF_VARCHAR2_TABLE_200();
289: a20 := JTF_VARCHAR2_TABLE_100();
290: a21 := JTF_VARCHAR2_TABLE_200();
291: a22 := JTF_VARCHAR2_TABLE_100();
292: a23 := JTF_VARCHAR2_TABLE_200();
293: a24 := JTF_VARCHAR2_TABLE_100();
294: a25 := JTF_VARCHAR2_TABLE_100();
295: a26 := JTF_VARCHAR2_TABLE_100();
296: else
312: a15 := JTF_VARCHAR2_TABLE_500();
313: a16 := JTF_VARCHAR2_TABLE_500();
314: a17 := JTF_VARCHAR2_TABLE_100();
315: a18 := JTF_VARCHAR2_TABLE_100();
316: a19 := JTF_VARCHAR2_TABLE_200();
317: a20 := JTF_VARCHAR2_TABLE_100();
318: a21 := JTF_VARCHAR2_TABLE_200();
319: a22 := JTF_VARCHAR2_TABLE_100();
320: a23 := JTF_VARCHAR2_TABLE_200();
314: a17 := JTF_VARCHAR2_TABLE_100();
315: a18 := JTF_VARCHAR2_TABLE_100();
316: a19 := JTF_VARCHAR2_TABLE_200();
317: a20 := JTF_VARCHAR2_TABLE_100();
318: a21 := JTF_VARCHAR2_TABLE_200();
319: a22 := JTF_VARCHAR2_TABLE_100();
320: a23 := JTF_VARCHAR2_TABLE_200();
321: a24 := JTF_VARCHAR2_TABLE_100();
322: a25 := JTF_VARCHAR2_TABLE_100();
316: a19 := JTF_VARCHAR2_TABLE_200();
317: a20 := JTF_VARCHAR2_TABLE_100();
318: a21 := JTF_VARCHAR2_TABLE_200();
319: a22 := JTF_VARCHAR2_TABLE_100();
320: a23 := JTF_VARCHAR2_TABLE_200();
321: a24 := JTF_VARCHAR2_TABLE_100();
322: a25 := JTF_VARCHAR2_TABLE_100();
323: a26 := JTF_VARCHAR2_TABLE_100();
324: if t.count > 0 then
496: , p6_a5 JTF_VARCHAR2_TABLE_100
497: , p6_a6 JTF_VARCHAR2_TABLE_600
498: , p6_a7 JTF_VARCHAR2_TABLE_600
499: , p6_a8 JTF_VARCHAR2_TABLE_600
500: , p6_a9 JTF_VARCHAR2_TABLE_2000
501: , p6_a10 JTF_VARCHAR2_TABLE_100
502: , p6_a11 JTF_VARCHAR2_TABLE_100
503: , p6_a12 JTF_VARCHAR2_TABLE_500
504: , p6_a13 JTF_VARCHAR2_TABLE_500
520: , p6_a29 JTF_NUMBER_TABLE
521: , p6_a30 JTF_DATE_TABLE
522: , p6_a31 JTF_NUMBER_TABLE
523: , p7_a0 out nocopy JTF_NUMBER_TABLE
524: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_200
525: , p7_a2 out nocopy JTF_NUMBER_TABLE
526: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_200
527: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_600
528: , p7_a5 out nocopy JTF_NUMBER_TABLE
522: , p6_a31 JTF_NUMBER_TABLE
523: , p7_a0 out nocopy JTF_NUMBER_TABLE
524: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_200
525: , p7_a2 out nocopy JTF_NUMBER_TABLE
526: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_200
527: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_600
528: , p7_a5 out nocopy JTF_NUMBER_TABLE
529: , p7_a6 out nocopy JTF_NUMBER_TABLE
530: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_100
672: , p7_a5 JTF_VARCHAR2_TABLE_100
673: , p7_a6 JTF_VARCHAR2_TABLE_600
674: , p7_a7 JTF_VARCHAR2_TABLE_600
675: , p7_a8 JTF_VARCHAR2_TABLE_600
676: , p7_a9 JTF_VARCHAR2_TABLE_2000
677: , p7_a10 JTF_VARCHAR2_TABLE_100
678: , p7_a11 JTF_VARCHAR2_TABLE_100
679: , p7_a12 JTF_VARCHAR2_TABLE_500
680: , p7_a13 JTF_VARCHAR2_TABLE_500
696: , p7_a29 JTF_NUMBER_TABLE
697: , p7_a30 JTF_DATE_TABLE
698: , p7_a31 JTF_NUMBER_TABLE
699: , p8_a0 out nocopy JTF_NUMBER_TABLE
700: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_200
701: , p8_a2 out nocopy JTF_NUMBER_TABLE
702: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_200
703: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_600
704: , p8_a5 out nocopy JTF_NUMBER_TABLE
698: , p7_a31 JTF_NUMBER_TABLE
699: , p8_a0 out nocopy JTF_NUMBER_TABLE
700: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_200
701: , p8_a2 out nocopy JTF_NUMBER_TABLE
702: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_200
703: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_600
704: , p8_a5 out nocopy JTF_NUMBER_TABLE
705: , p8_a6 out nocopy JTF_NUMBER_TABLE
706: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
843: , x_return_status out nocopy VARCHAR2
844: , x_msg_count out nocopy NUMBER
845: , x_msg_data out nocopy VARCHAR2
846: , p5_a0 JTF_NUMBER_TABLE
847: , p5_a1 JTF_VARCHAR2_TABLE_200
848: , p5_a2 JTF_NUMBER_TABLE
849: , p5_a3 JTF_VARCHAR2_TABLE_600
850: , p_deprn_method_code VARCHAR2
851: , p_in_service_date date
871: , p12_a15 JTF_VARCHAR2_TABLE_500
872: , p12_a16 JTF_VARCHAR2_TABLE_500
873: , p12_a17 JTF_VARCHAR2_TABLE_100
874: , p12_a18 JTF_VARCHAR2_TABLE_100
875: , p12_a19 JTF_VARCHAR2_TABLE_200
876: , p12_a20 JTF_VARCHAR2_TABLE_100
877: , p12_a21 JTF_VARCHAR2_TABLE_200
878: , p12_a22 JTF_VARCHAR2_TABLE_100
879: , p12_a23 JTF_VARCHAR2_TABLE_200
873: , p12_a17 JTF_VARCHAR2_TABLE_100
874: , p12_a18 JTF_VARCHAR2_TABLE_100
875: , p12_a19 JTF_VARCHAR2_TABLE_200
876: , p12_a20 JTF_VARCHAR2_TABLE_100
877: , p12_a21 JTF_VARCHAR2_TABLE_200
878: , p12_a22 JTF_VARCHAR2_TABLE_100
879: , p12_a23 JTF_VARCHAR2_TABLE_200
880: , p12_a24 JTF_VARCHAR2_TABLE_100
881: , p12_a25 JTF_VARCHAR2_TABLE_100
875: , p12_a19 JTF_VARCHAR2_TABLE_200
876: , p12_a20 JTF_VARCHAR2_TABLE_100
877: , p12_a21 JTF_VARCHAR2_TABLE_200
878: , p12_a22 JTF_VARCHAR2_TABLE_100
879: , p12_a23 JTF_VARCHAR2_TABLE_200
880: , p12_a24 JTF_VARCHAR2_TABLE_100
881: , p12_a25 JTF_VARCHAR2_TABLE_100
882: , p12_a26 JTF_VARCHAR2_TABLE_100
883: )
972: , x_return_status out nocopy VARCHAR2
973: , x_msg_count out nocopy NUMBER
974: , x_msg_data out nocopy VARCHAR2
975: , p5_a0 JTF_NUMBER_TABLE
976: , p5_a1 JTF_VARCHAR2_TABLE_200
977: , p5_a2 JTF_NUMBER_TABLE
978: , p5_a3 JTF_VARCHAR2_TABLE_600
979: , p_deprn_method_code VARCHAR2
980: , p_in_service_date date
1000: , p12_a15 JTF_VARCHAR2_TABLE_500
1001: , p12_a16 JTF_VARCHAR2_TABLE_500
1002: , p12_a17 JTF_VARCHAR2_TABLE_100
1003: , p12_a18 JTF_VARCHAR2_TABLE_100
1004: , p12_a19 JTF_VARCHAR2_TABLE_200
1005: , p12_a20 JTF_VARCHAR2_TABLE_100
1006: , p12_a21 JTF_VARCHAR2_TABLE_200
1007: , p12_a22 JTF_VARCHAR2_TABLE_100
1008: , p12_a23 JTF_VARCHAR2_TABLE_200
1002: , p12_a17 JTF_VARCHAR2_TABLE_100
1003: , p12_a18 JTF_VARCHAR2_TABLE_100
1004: , p12_a19 JTF_VARCHAR2_TABLE_200
1005: , p12_a20 JTF_VARCHAR2_TABLE_100
1006: , p12_a21 JTF_VARCHAR2_TABLE_200
1007: , p12_a22 JTF_VARCHAR2_TABLE_100
1008: , p12_a23 JTF_VARCHAR2_TABLE_200
1009: , p12_a24 JTF_VARCHAR2_TABLE_100
1010: , p12_a25 JTF_VARCHAR2_TABLE_100
1004: , p12_a19 JTF_VARCHAR2_TABLE_200
1005: , p12_a20 JTF_VARCHAR2_TABLE_100
1006: , p12_a21 JTF_VARCHAR2_TABLE_200
1007: , p12_a22 JTF_VARCHAR2_TABLE_100
1008: , p12_a23 JTF_VARCHAR2_TABLE_200
1009: , p12_a24 JTF_VARCHAR2_TABLE_100
1010: , p12_a25 JTF_VARCHAR2_TABLE_100
1011: , p12_a26 JTF_VARCHAR2_TABLE_100
1012: , p13_a0 out nocopy JTF_NUMBER_TABLE
1110: , x_return_status out nocopy VARCHAR2
1111: , x_msg_count out nocopy NUMBER
1112: , x_msg_data out nocopy VARCHAR2
1113: , p5_a0 JTF_NUMBER_TABLE
1114: , p5_a1 JTF_VARCHAR2_TABLE_200
1115: , p5_a2 JTF_NUMBER_TABLE
1116: , p5_a3 JTF_VARCHAR2_TABLE_600
1117: , p_deprn_method_code VARCHAR2
1118: , p_in_service_date date
1138: , p12_a15 JTF_VARCHAR2_TABLE_500
1139: , p12_a16 JTF_VARCHAR2_TABLE_500
1140: , p12_a17 JTF_VARCHAR2_TABLE_100
1141: , p12_a18 JTF_VARCHAR2_TABLE_100
1142: , p12_a19 JTF_VARCHAR2_TABLE_200
1143: , p12_a20 JTF_VARCHAR2_TABLE_100
1144: , p12_a21 JTF_VARCHAR2_TABLE_200
1145: , p12_a22 JTF_VARCHAR2_TABLE_100
1146: , p12_a23 JTF_VARCHAR2_TABLE_200
1140: , p12_a17 JTF_VARCHAR2_TABLE_100
1141: , p12_a18 JTF_VARCHAR2_TABLE_100
1142: , p12_a19 JTF_VARCHAR2_TABLE_200
1143: , p12_a20 JTF_VARCHAR2_TABLE_100
1144: , p12_a21 JTF_VARCHAR2_TABLE_200
1145: , p12_a22 JTF_VARCHAR2_TABLE_100
1146: , p12_a23 JTF_VARCHAR2_TABLE_200
1147: , p12_a24 JTF_VARCHAR2_TABLE_100
1148: , p12_a25 JTF_VARCHAR2_TABLE_100
1142: , p12_a19 JTF_VARCHAR2_TABLE_200
1143: , p12_a20 JTF_VARCHAR2_TABLE_100
1144: , p12_a21 JTF_VARCHAR2_TABLE_200
1145: , p12_a22 JTF_VARCHAR2_TABLE_100
1146: , p12_a23 JTF_VARCHAR2_TABLE_200
1147: , p12_a24 JTF_VARCHAR2_TABLE_100
1148: , p12_a25 JTF_VARCHAR2_TABLE_100
1149: , p12_a26 JTF_VARCHAR2_TABLE_100
1150: , p_transaction_date date
1254: , x_return_status out nocopy VARCHAR2
1255: , x_msg_count out nocopy NUMBER
1256: , x_msg_data out nocopy VARCHAR2
1257: , p5_a0 JTF_NUMBER_TABLE
1258: , p5_a1 JTF_VARCHAR2_TABLE_200
1259: , p5_a2 JTF_NUMBER_TABLE
1260: , p5_a3 JTF_VARCHAR2_TABLE_600
1261: , p_deprn_method_code VARCHAR2
1262: , p_in_service_date date
1282: , p12_a15 JTF_VARCHAR2_TABLE_500
1283: , p12_a16 JTF_VARCHAR2_TABLE_500
1284: , p12_a17 JTF_VARCHAR2_TABLE_100
1285: , p12_a18 JTF_VARCHAR2_TABLE_100
1286: , p12_a19 JTF_VARCHAR2_TABLE_200
1287: , p12_a20 JTF_VARCHAR2_TABLE_100
1288: , p12_a21 JTF_VARCHAR2_TABLE_200
1289: , p12_a22 JTF_VARCHAR2_TABLE_100
1290: , p12_a23 JTF_VARCHAR2_TABLE_200
1284: , p12_a17 JTF_VARCHAR2_TABLE_100
1285: , p12_a18 JTF_VARCHAR2_TABLE_100
1286: , p12_a19 JTF_VARCHAR2_TABLE_200
1287: , p12_a20 JTF_VARCHAR2_TABLE_100
1288: , p12_a21 JTF_VARCHAR2_TABLE_200
1289: , p12_a22 JTF_VARCHAR2_TABLE_100
1290: , p12_a23 JTF_VARCHAR2_TABLE_200
1291: , p12_a24 JTF_VARCHAR2_TABLE_100
1292: , p12_a25 JTF_VARCHAR2_TABLE_100
1286: , p12_a19 JTF_VARCHAR2_TABLE_200
1287: , p12_a20 JTF_VARCHAR2_TABLE_100
1288: , p12_a21 JTF_VARCHAR2_TABLE_200
1289: , p12_a22 JTF_VARCHAR2_TABLE_100
1290: , p12_a23 JTF_VARCHAR2_TABLE_200
1291: , p12_a24 JTF_VARCHAR2_TABLE_100
1292: , p12_a25 JTF_VARCHAR2_TABLE_100
1293: , p12_a26 JTF_VARCHAR2_TABLE_100
1294: , p_source_trx_id NUMBER
1395: , x_return_status out nocopy VARCHAR2
1396: , x_msg_count out nocopy NUMBER
1397: , x_msg_data out nocopy VARCHAR2
1398: , p5_a0 JTF_NUMBER_TABLE
1399: , p5_a1 JTF_VARCHAR2_TABLE_200
1400: , p5_a2 JTF_NUMBER_TABLE
1401: , p5_a3 JTF_VARCHAR2_TABLE_600
1402: , p_deprn_method_code VARCHAR2
1403: , p_in_service_date date
1423: , p12_a15 JTF_VARCHAR2_TABLE_500
1424: , p12_a16 JTF_VARCHAR2_TABLE_500
1425: , p12_a17 JTF_VARCHAR2_TABLE_100
1426: , p12_a18 JTF_VARCHAR2_TABLE_100
1427: , p12_a19 JTF_VARCHAR2_TABLE_200
1428: , p12_a20 JTF_VARCHAR2_TABLE_100
1429: , p12_a21 JTF_VARCHAR2_TABLE_200
1430: , p12_a22 JTF_VARCHAR2_TABLE_100
1431: , p12_a23 JTF_VARCHAR2_TABLE_200
1425: , p12_a17 JTF_VARCHAR2_TABLE_100
1426: , p12_a18 JTF_VARCHAR2_TABLE_100
1427: , p12_a19 JTF_VARCHAR2_TABLE_200
1428: , p12_a20 JTF_VARCHAR2_TABLE_100
1429: , p12_a21 JTF_VARCHAR2_TABLE_200
1430: , p12_a22 JTF_VARCHAR2_TABLE_100
1431: , p12_a23 JTF_VARCHAR2_TABLE_200
1432: , p12_a24 JTF_VARCHAR2_TABLE_100
1433: , p12_a25 JTF_VARCHAR2_TABLE_100
1427: , p12_a19 JTF_VARCHAR2_TABLE_200
1428: , p12_a20 JTF_VARCHAR2_TABLE_100
1429: , p12_a21 JTF_VARCHAR2_TABLE_200
1430: , p12_a22 JTF_VARCHAR2_TABLE_100
1431: , p12_a23 JTF_VARCHAR2_TABLE_200
1432: , p12_a24 JTF_VARCHAR2_TABLE_100
1433: , p12_a25 JTF_VARCHAR2_TABLE_100
1434: , p12_a26 JTF_VARCHAR2_TABLE_100
1435: , p_source_trx_id NUMBER
1568: , p13_a15 JTF_VARCHAR2_TABLE_500
1569: , p13_a16 JTF_VARCHAR2_TABLE_500
1570: , p13_a17 JTF_VARCHAR2_TABLE_100
1571: , p13_a18 JTF_VARCHAR2_TABLE_100
1572: , p13_a19 JTF_VARCHAR2_TABLE_200
1573: , p13_a20 JTF_VARCHAR2_TABLE_100
1574: , p13_a21 JTF_VARCHAR2_TABLE_200
1575: , p13_a22 JTF_VARCHAR2_TABLE_100
1576: , p13_a23 JTF_VARCHAR2_TABLE_200
1570: , p13_a17 JTF_VARCHAR2_TABLE_100
1571: , p13_a18 JTF_VARCHAR2_TABLE_100
1572: , p13_a19 JTF_VARCHAR2_TABLE_200
1573: , p13_a20 JTF_VARCHAR2_TABLE_100
1574: , p13_a21 JTF_VARCHAR2_TABLE_200
1575: , p13_a22 JTF_VARCHAR2_TABLE_100
1576: , p13_a23 JTF_VARCHAR2_TABLE_200
1577: , p13_a24 JTF_VARCHAR2_TABLE_100
1578: , p13_a25 JTF_VARCHAR2_TABLE_100
1572: , p13_a19 JTF_VARCHAR2_TABLE_200
1573: , p13_a20 JTF_VARCHAR2_TABLE_100
1574: , p13_a21 JTF_VARCHAR2_TABLE_200
1575: , p13_a22 JTF_VARCHAR2_TABLE_100
1576: , p13_a23 JTF_VARCHAR2_TABLE_200
1577: , p13_a24 JTF_VARCHAR2_TABLE_100
1578: , p13_a25 JTF_VARCHAR2_TABLE_100
1579: , p13_a26 JTF_VARCHAR2_TABLE_100
1580: )
1669: , x_return_status out nocopy VARCHAR2
1670: , x_msg_count out nocopy NUMBER
1671: , x_msg_data out nocopy VARCHAR2
1672: , p5_a0 JTF_NUMBER_TABLE
1673: , p5_a1 JTF_VARCHAR2_TABLE_200
1674: , p5_a2 JTF_NUMBER_TABLE
1675: , p5_a3 JTF_VARCHAR2_TABLE_200
1676: , p5_a4 JTF_VARCHAR2_TABLE_600
1677: , p5_a5 JTF_NUMBER_TABLE
1671: , x_msg_data out nocopy VARCHAR2
1672: , p5_a0 JTF_NUMBER_TABLE
1673: , p5_a1 JTF_VARCHAR2_TABLE_200
1674: , p5_a2 JTF_NUMBER_TABLE
1675: , p5_a3 JTF_VARCHAR2_TABLE_200
1676: , p5_a4 JTF_VARCHAR2_TABLE_600
1677: , p5_a5 JTF_NUMBER_TABLE
1678: , p5_a6 JTF_NUMBER_TABLE
1679: , p5_a7 JTF_VARCHAR2_TABLE_100
1700: , p5_a28 JTF_DATE_TABLE
1701: , p5_a29 JTF_NUMBER_TABLE
1702: , p5_a30 JTF_DATE_TABLE
1703: , p6_a0 out nocopy JTF_NUMBER_TABLE
1704: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
1705: , p6_a2 out nocopy JTF_NUMBER_TABLE
1706: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
1707: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_600
1708: , p6_a5 out nocopy JTF_NUMBER_TABLE
1702: , p5_a30 JTF_DATE_TABLE
1703: , p6_a0 out nocopy JTF_NUMBER_TABLE
1704: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
1705: , p6_a2 out nocopy JTF_NUMBER_TABLE
1706: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
1707: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_600
1708: , p6_a5 out nocopy JTF_NUMBER_TABLE
1709: , p6_a6 out nocopy JTF_NUMBER_TABLE
1710: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
1843: , p6_a5 JTF_VARCHAR2_TABLE_100
1844: , p6_a6 JTF_VARCHAR2_TABLE_600
1845: , p6_a7 JTF_VARCHAR2_TABLE_600
1846: , p6_a8 JTF_VARCHAR2_TABLE_600
1847: , p6_a9 JTF_VARCHAR2_TABLE_2000
1848: , p6_a10 JTF_VARCHAR2_TABLE_100
1849: , p6_a11 JTF_VARCHAR2_TABLE_100
1850: , p6_a12 JTF_VARCHAR2_TABLE_500
1851: , p6_a13 JTF_VARCHAR2_TABLE_500
1875: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
1876: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_600
1877: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_600
1878: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_600
1879: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_2000
1880: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
1881: , p7_a11 out nocopy JTF_VARCHAR2_TABLE_100
1882: , p7_a12 out nocopy JTF_VARCHAR2_TABLE_500
1883: , p7_a13 out nocopy JTF_VARCHAR2_TABLE_500