21: if n=b then return a; end if;
22: return n;
23: end;
24:
25: procedure rosetta_table_copy_in_p2(t out nocopy eam_construction_unit_pub.cu_activity_tbl, a0 JTF_NUMBER_TABLE
26: , a1 JTF_NUMBER_TABLE
27: , a2 JTF_VARCHAR2_TABLE_100
28: , a3 JTF_NUMBER_TABLE
29: , a4 JTF_NUMBER_TABLE
22: return n;
23: end;
24:
25: procedure rosetta_table_copy_in_p2(t out nocopy eam_construction_unit_pub.cu_activity_tbl, a0 JTF_NUMBER_TABLE
26: , a1 JTF_NUMBER_TABLE
27: , a2 JTF_VARCHAR2_TABLE_100
28: , a3 JTF_NUMBER_TABLE
29: , a4 JTF_NUMBER_TABLE
30: , a5 JTF_DATE_TABLE
24:
25: procedure rosetta_table_copy_in_p2(t out nocopy eam_construction_unit_pub.cu_activity_tbl, a0 JTF_NUMBER_TABLE
26: , a1 JTF_NUMBER_TABLE
27: , a2 JTF_VARCHAR2_TABLE_100
28: , a3 JTF_NUMBER_TABLE
29: , a4 JTF_NUMBER_TABLE
30: , a5 JTF_DATE_TABLE
31: , a6 JTF_DATE_TABLE
32: , a7 JTF_VARCHAR2_TABLE_100
25: procedure rosetta_table_copy_in_p2(t out nocopy eam_construction_unit_pub.cu_activity_tbl, a0 JTF_NUMBER_TABLE
26: , a1 JTF_NUMBER_TABLE
27: , a2 JTF_VARCHAR2_TABLE_100
28: , a3 JTF_NUMBER_TABLE
29: , a4 JTF_NUMBER_TABLE
30: , a5 JTF_DATE_TABLE
31: , a6 JTF_DATE_TABLE
32: , a7 JTF_VARCHAR2_TABLE_100
33: ) as
54: end loop;
55: end if;
56: end if;
57: end rosetta_table_copy_in_p2;
58: procedure rosetta_table_copy_out_p2(t eam_construction_unit_pub.cu_activity_tbl, a0 out nocopy JTF_NUMBER_TABLE
59: , a1 out nocopy JTF_NUMBER_TABLE
60: , a2 out nocopy JTF_VARCHAR2_TABLE_100
61: , a3 out nocopy JTF_NUMBER_TABLE
62: , a4 out nocopy JTF_NUMBER_TABLE
55: end if;
56: end if;
57: end rosetta_table_copy_in_p2;
58: procedure rosetta_table_copy_out_p2(t eam_construction_unit_pub.cu_activity_tbl, a0 out nocopy JTF_NUMBER_TABLE
59: , a1 out nocopy JTF_NUMBER_TABLE
60: , a2 out nocopy JTF_VARCHAR2_TABLE_100
61: , a3 out nocopy JTF_NUMBER_TABLE
62: , a4 out nocopy JTF_NUMBER_TABLE
63: , a5 out nocopy JTF_DATE_TABLE
57: end rosetta_table_copy_in_p2;
58: procedure rosetta_table_copy_out_p2(t eam_construction_unit_pub.cu_activity_tbl, a0 out nocopy JTF_NUMBER_TABLE
59: , a1 out nocopy JTF_NUMBER_TABLE
60: , a2 out nocopy JTF_VARCHAR2_TABLE_100
61: , a3 out nocopy JTF_NUMBER_TABLE
62: , a4 out nocopy JTF_NUMBER_TABLE
63: , a5 out nocopy JTF_DATE_TABLE
64: , a6 out nocopy JTF_DATE_TABLE
65: , a7 out nocopy JTF_VARCHAR2_TABLE_100
58: procedure rosetta_table_copy_out_p2(t eam_construction_unit_pub.cu_activity_tbl, a0 out nocopy JTF_NUMBER_TABLE
59: , a1 out nocopy JTF_NUMBER_TABLE
60: , a2 out nocopy JTF_VARCHAR2_TABLE_100
61: , a3 out nocopy JTF_NUMBER_TABLE
62: , a4 out nocopy JTF_NUMBER_TABLE
63: , a5 out nocopy JTF_DATE_TABLE
64: , a6 out nocopy JTF_DATE_TABLE
65: , a7 out nocopy JTF_VARCHAR2_TABLE_100
66: ) as
66: ) as
67: ddindx binary_integer; indx binary_integer;
68: begin
69: if t is null or t.count = 0 then
70: a0 := JTF_NUMBER_TABLE();
71: a1 := JTF_NUMBER_TABLE();
72: a2 := JTF_VARCHAR2_TABLE_100();
73: a3 := JTF_NUMBER_TABLE();
74: a4 := JTF_NUMBER_TABLE();
67: ddindx binary_integer; indx binary_integer;
68: begin
69: if t is null or t.count = 0 then
70: a0 := JTF_NUMBER_TABLE();
71: a1 := JTF_NUMBER_TABLE();
72: a2 := JTF_VARCHAR2_TABLE_100();
73: a3 := JTF_NUMBER_TABLE();
74: a4 := JTF_NUMBER_TABLE();
75: a5 := JTF_DATE_TABLE();
69: if t is null or t.count = 0 then
70: a0 := JTF_NUMBER_TABLE();
71: a1 := JTF_NUMBER_TABLE();
72: a2 := JTF_VARCHAR2_TABLE_100();
73: a3 := JTF_NUMBER_TABLE();
74: a4 := JTF_NUMBER_TABLE();
75: a5 := JTF_DATE_TABLE();
76: a6 := JTF_DATE_TABLE();
77: a7 := JTF_VARCHAR2_TABLE_100();
70: a0 := JTF_NUMBER_TABLE();
71: a1 := JTF_NUMBER_TABLE();
72: a2 := JTF_VARCHAR2_TABLE_100();
73: a3 := JTF_NUMBER_TABLE();
74: a4 := JTF_NUMBER_TABLE();
75: a5 := JTF_DATE_TABLE();
76: a6 := JTF_DATE_TABLE();
77: a7 := JTF_VARCHAR2_TABLE_100();
78: else
75: a5 := JTF_DATE_TABLE();
76: a6 := JTF_DATE_TABLE();
77: a7 := JTF_VARCHAR2_TABLE_100();
78: else
79: a0 := JTF_NUMBER_TABLE();
80: a1 := JTF_NUMBER_TABLE();
81: a2 := JTF_VARCHAR2_TABLE_100();
82: a3 := JTF_NUMBER_TABLE();
83: a4 := JTF_NUMBER_TABLE();
76: a6 := JTF_DATE_TABLE();
77: a7 := JTF_VARCHAR2_TABLE_100();
78: else
79: a0 := JTF_NUMBER_TABLE();
80: a1 := JTF_NUMBER_TABLE();
81: a2 := JTF_VARCHAR2_TABLE_100();
82: a3 := JTF_NUMBER_TABLE();
83: a4 := JTF_NUMBER_TABLE();
84: a5 := JTF_DATE_TABLE();
78: else
79: a0 := JTF_NUMBER_TABLE();
80: a1 := JTF_NUMBER_TABLE();
81: a2 := JTF_VARCHAR2_TABLE_100();
82: a3 := JTF_NUMBER_TABLE();
83: a4 := JTF_NUMBER_TABLE();
84: a5 := JTF_DATE_TABLE();
85: a6 := JTF_DATE_TABLE();
86: a7 := JTF_VARCHAR2_TABLE_100();
79: a0 := JTF_NUMBER_TABLE();
80: a1 := JTF_NUMBER_TABLE();
81: a2 := JTF_VARCHAR2_TABLE_100();
82: a3 := JTF_NUMBER_TABLE();
83: a4 := JTF_NUMBER_TABLE();
84: a5 := JTF_DATE_TABLE();
85: a6 := JTF_DATE_TABLE();
86: a7 := JTF_VARCHAR2_TABLE_100();
87: if t.count > 0 then
113: end if;
114: end if;
115: end rosetta_table_copy_out_p2;
116:
117: procedure rosetta_table_copy_in_p4(t out nocopy eam_construction_unit_pub.cu_id_tbl, a0 JTF_NUMBER_TABLE
118: ) as
119: ddindx binary_integer; indx binary_integer;
120: begin
121: if a0 is not null and a0.count > 0 then
132: end loop;
133: end if;
134: end if;
135: end rosetta_table_copy_in_p4;
136: procedure rosetta_table_copy_out_p4(t eam_construction_unit_pub.cu_id_tbl, a0 out nocopy JTF_NUMBER_TABLE
137: ) as
138: ddindx binary_integer; indx binary_integer;
139: begin
140: if t is null or t.count = 0 then
137: ) as
138: ddindx binary_integer; indx binary_integer;
139: begin
140: if t is null or t.count = 0 then
141: a0 := JTF_NUMBER_TABLE();
142: else
143: a0 := JTF_NUMBER_TABLE();
144: if t.count > 0 then
145: a0.extend(t.count);
139: begin
140: if t is null or t.count = 0 then
141: a0 := JTF_NUMBER_TABLE();
142: else
143: a0 := JTF_NUMBER_TABLE();
144: if t.count > 0 then
145: a0.extend(t.count);
146: ddindx := t.first;
147: indx := 1;
158: end rosetta_table_copy_out_p4;
159:
160: procedure create_construction_unit(p_api_version NUMBER
161: , p_commit VARCHAR2
162: , p3_a0 JTF_NUMBER_TABLE
163: , p3_a1 JTF_NUMBER_TABLE
164: , p3_a2 JTF_VARCHAR2_TABLE_100
165: , p3_a3 JTF_NUMBER_TABLE
166: , p3_a4 JTF_NUMBER_TABLE
159:
160: procedure create_construction_unit(p_api_version NUMBER
161: , p_commit VARCHAR2
162: , p3_a0 JTF_NUMBER_TABLE
163: , p3_a1 JTF_NUMBER_TABLE
164: , p3_a2 JTF_VARCHAR2_TABLE_100
165: , p3_a3 JTF_NUMBER_TABLE
166: , p3_a4 JTF_NUMBER_TABLE
167: , p3_a5 JTF_DATE_TABLE
161: , p_commit VARCHAR2
162: , p3_a0 JTF_NUMBER_TABLE
163: , p3_a1 JTF_NUMBER_TABLE
164: , p3_a2 JTF_VARCHAR2_TABLE_100
165: , p3_a3 JTF_NUMBER_TABLE
166: , p3_a4 JTF_NUMBER_TABLE
167: , p3_a5 JTF_DATE_TABLE
168: , p3_a6 JTF_DATE_TABLE
169: , p3_a7 JTF_VARCHAR2_TABLE_100
162: , p3_a0 JTF_NUMBER_TABLE
163: , p3_a1 JTF_NUMBER_TABLE
164: , p3_a2 JTF_VARCHAR2_TABLE_100
165: , p3_a3 JTF_NUMBER_TABLE
166: , p3_a4 JTF_NUMBER_TABLE
167: , p3_a5 JTF_DATE_TABLE
168: , p3_a6 JTF_DATE_TABLE
169: , p3_a7 JTF_VARCHAR2_TABLE_100
170: , x_cu_id out nocopy NUMBER
262: end;
263:
264: procedure update_construction_unit(p_api_version NUMBER
265: , p_commit VARCHAR2
266: , p3_a0 JTF_NUMBER_TABLE
267: , p3_a1 JTF_NUMBER_TABLE
268: , p3_a2 JTF_VARCHAR2_TABLE_100
269: , p3_a3 JTF_NUMBER_TABLE
270: , p3_a4 JTF_NUMBER_TABLE
263:
264: procedure update_construction_unit(p_api_version NUMBER
265: , p_commit VARCHAR2
266: , p3_a0 JTF_NUMBER_TABLE
267: , p3_a1 JTF_NUMBER_TABLE
268: , p3_a2 JTF_VARCHAR2_TABLE_100
269: , p3_a3 JTF_NUMBER_TABLE
270: , p3_a4 JTF_NUMBER_TABLE
271: , p3_a5 JTF_DATE_TABLE
265: , p_commit VARCHAR2
266: , p3_a0 JTF_NUMBER_TABLE
267: , p3_a1 JTF_NUMBER_TABLE
268: , p3_a2 JTF_VARCHAR2_TABLE_100
269: , p3_a3 JTF_NUMBER_TABLE
270: , p3_a4 JTF_NUMBER_TABLE
271: , p3_a5 JTF_DATE_TABLE
272: , p3_a6 JTF_DATE_TABLE
273: , p3_a7 JTF_VARCHAR2_TABLE_100
266: , p3_a0 JTF_NUMBER_TABLE
267: , p3_a1 JTF_NUMBER_TABLE
268: , p3_a2 JTF_VARCHAR2_TABLE_100
269: , p3_a3 JTF_NUMBER_TABLE
270: , p3_a4 JTF_NUMBER_TABLE
271: , p3_a5 JTF_DATE_TABLE
272: , p3_a6 JTF_DATE_TABLE
273: , p3_a7 JTF_VARCHAR2_TABLE_100
274: , x_cu_id out nocopy NUMBER
366: end;
367:
368: procedure copy_construction_unit(p_api_version NUMBER
369: , p_commit VARCHAR2
370: , p3_a0 JTF_NUMBER_TABLE
371: , p3_a1 JTF_NUMBER_TABLE
372: , p3_a2 JTF_VARCHAR2_TABLE_100
373: , p3_a3 JTF_NUMBER_TABLE
374: , p3_a4 JTF_NUMBER_TABLE
367:
368: procedure copy_construction_unit(p_api_version NUMBER
369: , p_commit VARCHAR2
370: , p3_a0 JTF_NUMBER_TABLE
371: , p3_a1 JTF_NUMBER_TABLE
372: , p3_a2 JTF_VARCHAR2_TABLE_100
373: , p3_a3 JTF_NUMBER_TABLE
374: , p3_a4 JTF_NUMBER_TABLE
375: , p3_a5 JTF_DATE_TABLE
369: , p_commit VARCHAR2
370: , p3_a0 JTF_NUMBER_TABLE
371: , p3_a1 JTF_NUMBER_TABLE
372: , p3_a2 JTF_VARCHAR2_TABLE_100
373: , p3_a3 JTF_NUMBER_TABLE
374: , p3_a4 JTF_NUMBER_TABLE
375: , p3_a5 JTF_DATE_TABLE
376: , p3_a6 JTF_DATE_TABLE
377: , p3_a7 JTF_VARCHAR2_TABLE_100
370: , p3_a0 JTF_NUMBER_TABLE
371: , p3_a1 JTF_NUMBER_TABLE
372: , p3_a2 JTF_VARCHAR2_TABLE_100
373: , p3_a3 JTF_NUMBER_TABLE
374: , p3_a4 JTF_NUMBER_TABLE
375: , p3_a5 JTF_DATE_TABLE
376: , p3_a6 JTF_DATE_TABLE
377: , p3_a7 JTF_VARCHAR2_TABLE_100
378: , p4_a0 JTF_NUMBER_TABLE
374: , p3_a4 JTF_NUMBER_TABLE
375: , p3_a5 JTF_DATE_TABLE
376: , p3_a6 JTF_DATE_TABLE
377: , p3_a7 JTF_VARCHAR2_TABLE_100
378: , p4_a0 JTF_NUMBER_TABLE
379: , x_cu_id out nocopy NUMBER
380: , x_return_status out nocopy VARCHAR2
381: , x_msg_count out nocopy NUMBER
382: , x_msg_data out nocopy VARCHAR2