13: return d;
14: end;
15:
16: procedure rosetta_table_copy_in_p1(t out nocopy ahl_uc_tree_pvt.uc_descendant_tbl_type, a0 JTF_VARCHAR2_TABLE_100
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_NUMBER_TABLE
21: , a5 JTF_NUMBER_TABLE
14: end;
15:
16: procedure rosetta_table_copy_in_p1(t out nocopy ahl_uc_tree_pvt.uc_descendant_tbl_type, a0 JTF_VARCHAR2_TABLE_100
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_NUMBER_TABLE
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_VARCHAR2_TABLE_100
16: procedure rosetta_table_copy_in_p1(t out nocopy ahl_uc_tree_pvt.uc_descendant_tbl_type, a0 JTF_VARCHAR2_TABLE_100
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_NUMBER_TABLE
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_VARCHAR2_TABLE_100
23: , a7 JTF_VARCHAR2_TABLE_100
24: , a8 JTF_VARCHAR2_TABLE_100
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_NUMBER_TABLE
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_VARCHAR2_TABLE_100
23: , a7 JTF_VARCHAR2_TABLE_100
24: , a8 JTF_VARCHAR2_TABLE_100
25: , a9 JTF_VARCHAR2_TABLE_100
52: end if;
53: end if;
54: end rosetta_table_copy_in_p1;
55: procedure rosetta_table_copy_out_p1(t ahl_uc_tree_pvt.uc_descendant_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
56: , a1 out nocopy JTF_NUMBER_TABLE
57: , a2 out nocopy JTF_NUMBER_TABLE
58: , a3 out nocopy JTF_VARCHAR2_TABLE_100
59: , a4 out nocopy JTF_NUMBER_TABLE
60: , a5 out nocopy JTF_NUMBER_TABLE
53: end if;
54: end rosetta_table_copy_in_p1;
55: procedure rosetta_table_copy_out_p1(t ahl_uc_tree_pvt.uc_descendant_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
56: , a1 out nocopy JTF_NUMBER_TABLE
57: , a2 out nocopy JTF_NUMBER_TABLE
58: , a3 out nocopy JTF_VARCHAR2_TABLE_100
59: , a4 out nocopy JTF_NUMBER_TABLE
60: , a5 out nocopy JTF_NUMBER_TABLE
61: , a6 out nocopy JTF_VARCHAR2_TABLE_100
55: procedure rosetta_table_copy_out_p1(t ahl_uc_tree_pvt.uc_descendant_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
56: , a1 out nocopy JTF_NUMBER_TABLE
57: , a2 out nocopy JTF_NUMBER_TABLE
58: , a3 out nocopy JTF_VARCHAR2_TABLE_100
59: , a4 out nocopy JTF_NUMBER_TABLE
60: , a5 out nocopy JTF_NUMBER_TABLE
61: , a6 out nocopy JTF_VARCHAR2_TABLE_100
62: , a7 out nocopy JTF_VARCHAR2_TABLE_100
63: , a8 out nocopy JTF_VARCHAR2_TABLE_100
56: , a1 out nocopy JTF_NUMBER_TABLE
57: , a2 out nocopy JTF_NUMBER_TABLE
58: , a3 out nocopy JTF_VARCHAR2_TABLE_100
59: , a4 out nocopy JTF_NUMBER_TABLE
60: , a5 out nocopy JTF_NUMBER_TABLE
61: , a6 out nocopy JTF_VARCHAR2_TABLE_100
62: , a7 out nocopy JTF_VARCHAR2_TABLE_100
63: , a8 out nocopy JTF_VARCHAR2_TABLE_100
64: , a9 out nocopy JTF_VARCHAR2_TABLE_100
67: ddindx binary_integer; indx binary_integer;
68: begin
69: if t is null or t.count = 0 then
70: a0 := JTF_VARCHAR2_TABLE_100();
71: a1 := JTF_NUMBER_TABLE();
72: a2 := JTF_NUMBER_TABLE();
73: a3 := JTF_VARCHAR2_TABLE_100();
74: a4 := JTF_NUMBER_TABLE();
75: a5 := JTF_NUMBER_TABLE();
68: begin
69: if t is null or t.count = 0 then
70: a0 := JTF_VARCHAR2_TABLE_100();
71: a1 := JTF_NUMBER_TABLE();
72: a2 := JTF_NUMBER_TABLE();
73: a3 := JTF_VARCHAR2_TABLE_100();
74: a4 := JTF_NUMBER_TABLE();
75: a5 := JTF_NUMBER_TABLE();
76: a6 := JTF_VARCHAR2_TABLE_100();
70: a0 := JTF_VARCHAR2_TABLE_100();
71: a1 := JTF_NUMBER_TABLE();
72: a2 := JTF_NUMBER_TABLE();
73: a3 := JTF_VARCHAR2_TABLE_100();
74: a4 := JTF_NUMBER_TABLE();
75: a5 := JTF_NUMBER_TABLE();
76: a6 := JTF_VARCHAR2_TABLE_100();
77: a7 := JTF_VARCHAR2_TABLE_100();
78: a8 := JTF_VARCHAR2_TABLE_100();
71: a1 := JTF_NUMBER_TABLE();
72: a2 := JTF_NUMBER_TABLE();
73: a3 := JTF_VARCHAR2_TABLE_100();
74: a4 := JTF_NUMBER_TABLE();
75: a5 := JTF_NUMBER_TABLE();
76: a6 := JTF_VARCHAR2_TABLE_100();
77: a7 := JTF_VARCHAR2_TABLE_100();
78: a8 := JTF_VARCHAR2_TABLE_100();
79: a9 := JTF_VARCHAR2_TABLE_100();
79: a9 := JTF_VARCHAR2_TABLE_100();
80: a10 := JTF_VARCHAR2_TABLE_100();
81: else
82: a0 := JTF_VARCHAR2_TABLE_100();
83: a1 := JTF_NUMBER_TABLE();
84: a2 := JTF_NUMBER_TABLE();
85: a3 := JTF_VARCHAR2_TABLE_100();
86: a4 := JTF_NUMBER_TABLE();
87: a5 := JTF_NUMBER_TABLE();
80: a10 := JTF_VARCHAR2_TABLE_100();
81: else
82: a0 := JTF_VARCHAR2_TABLE_100();
83: a1 := JTF_NUMBER_TABLE();
84: a2 := JTF_NUMBER_TABLE();
85: a3 := JTF_VARCHAR2_TABLE_100();
86: a4 := JTF_NUMBER_TABLE();
87: a5 := JTF_NUMBER_TABLE();
88: a6 := JTF_VARCHAR2_TABLE_100();
82: a0 := JTF_VARCHAR2_TABLE_100();
83: a1 := JTF_NUMBER_TABLE();
84: a2 := JTF_NUMBER_TABLE();
85: a3 := JTF_VARCHAR2_TABLE_100();
86: a4 := JTF_NUMBER_TABLE();
87: a5 := JTF_NUMBER_TABLE();
88: a6 := JTF_VARCHAR2_TABLE_100();
89: a7 := JTF_VARCHAR2_TABLE_100();
90: a8 := JTF_VARCHAR2_TABLE_100();
83: a1 := JTF_NUMBER_TABLE();
84: a2 := JTF_NUMBER_TABLE();
85: a3 := JTF_VARCHAR2_TABLE_100();
86: a4 := JTF_NUMBER_TABLE();
87: a5 := JTF_NUMBER_TABLE();
88: a6 := JTF_VARCHAR2_TABLE_100();
89: a7 := JTF_VARCHAR2_TABLE_100();
90: a8 := JTF_VARCHAR2_TABLE_100();
91: a9 := JTF_VARCHAR2_TABLE_100();
133: , x_msg_count out nocopy NUMBER
134: , x_msg_data out nocopy VARCHAR2
135: , p_uc_header_id NUMBER
136: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100
137: , p7_a1 out nocopy JTF_NUMBER_TABLE
138: , p7_a2 out nocopy JTF_NUMBER_TABLE
139: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
140: , p7_a4 out nocopy JTF_NUMBER_TABLE
141: , p7_a5 out nocopy JTF_NUMBER_TABLE
134: , x_msg_data out nocopy VARCHAR2
135: , p_uc_header_id NUMBER
136: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100
137: , p7_a1 out nocopy JTF_NUMBER_TABLE
138: , p7_a2 out nocopy JTF_NUMBER_TABLE
139: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
140: , p7_a4 out nocopy JTF_NUMBER_TABLE
141: , p7_a5 out nocopy JTF_NUMBER_TABLE
142: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100
136: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100
137: , p7_a1 out nocopy JTF_NUMBER_TABLE
138: , p7_a2 out nocopy JTF_NUMBER_TABLE
139: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
140: , p7_a4 out nocopy JTF_NUMBER_TABLE
141: , p7_a5 out nocopy JTF_NUMBER_TABLE
142: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100
143: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_100
144: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100
137: , p7_a1 out nocopy JTF_NUMBER_TABLE
138: , p7_a2 out nocopy JTF_NUMBER_TABLE
139: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
140: , p7_a4 out nocopy JTF_NUMBER_TABLE
141: , p7_a5 out nocopy JTF_NUMBER_TABLE
142: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100
143: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_100
144: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100
145: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100