18: if n=b then return a; end if;
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p4(t out nocopy amv_content_type_pvt.amv_content_type_obj_varray, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_VARCHAR2_TABLE_2000
26: , a4 JTF_VARCHAR2_TABLE_100
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p4(t out nocopy amv_content_type_pvt.amv_content_type_obj_varray, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_VARCHAR2_TABLE_2000
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_VARCHAR2_TABLE_2000
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_DATE_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_DATE_TABLE
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_NUMBER_TABLE
33: ) as
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_DATE_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_DATE_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_DATE_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_DATE_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
61: end loop;
62: end if;
63: end if;
64: end rosetta_table_copy_in_p4;
65: procedure rosetta_table_copy_out_p4(t amv_content_type_pvt.amv_content_type_obj_varray, a0 out nocopy JTF_NUMBER_TABLE
66: , a1 out nocopy JTF_NUMBER_TABLE
67: , a2 out nocopy JTF_VARCHAR2_TABLE_100
68: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
69: , a4 out nocopy JTF_VARCHAR2_TABLE_100
62: end if;
63: end if;
64: end rosetta_table_copy_in_p4;
65: procedure rosetta_table_copy_out_p4(t amv_content_type_pvt.amv_content_type_obj_varray, a0 out nocopy JTF_NUMBER_TABLE
66: , a1 out nocopy JTF_NUMBER_TABLE
67: , a2 out nocopy JTF_VARCHAR2_TABLE_100
68: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
69: , a4 out nocopy JTF_VARCHAR2_TABLE_100
70: , a5 out nocopy JTF_VARCHAR2_TABLE_100
68: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
69: , a4 out nocopy JTF_VARCHAR2_TABLE_100
70: , a5 out nocopy JTF_VARCHAR2_TABLE_100
71: , a6 out nocopy JTF_DATE_TABLE
72: , a7 out nocopy JTF_NUMBER_TABLE
73: , a8 out nocopy JTF_DATE_TABLE
74: , a9 out nocopy JTF_NUMBER_TABLE
75: , a10 out nocopy JTF_NUMBER_TABLE
76: ) as
70: , a5 out nocopy JTF_VARCHAR2_TABLE_100
71: , a6 out nocopy JTF_DATE_TABLE
72: , a7 out nocopy JTF_NUMBER_TABLE
73: , a8 out nocopy JTF_DATE_TABLE
74: , a9 out nocopy JTF_NUMBER_TABLE
75: , a10 out nocopy JTF_NUMBER_TABLE
76: ) as
77: ddindx binary_integer; indx binary_integer;
78: begin
71: , a6 out nocopy JTF_DATE_TABLE
72: , a7 out nocopy JTF_NUMBER_TABLE
73: , a8 out nocopy JTF_DATE_TABLE
74: , a9 out nocopy JTF_NUMBER_TABLE
75: , a10 out nocopy JTF_NUMBER_TABLE
76: ) as
77: ddindx binary_integer; indx binary_integer;
78: begin
79: if t is null then
88: a8 := null;
89: a9 := null;
90: a10 := null;
91: elsif t.count = 0 then
92: a0 := JTF_NUMBER_TABLE();
93: a1 := JTF_NUMBER_TABLE();
94: a2 := JTF_VARCHAR2_TABLE_100();
95: a3 := JTF_VARCHAR2_TABLE_2000();
96: a4 := JTF_VARCHAR2_TABLE_100();
89: a9 := null;
90: a10 := null;
91: elsif t.count = 0 then
92: a0 := JTF_NUMBER_TABLE();
93: a1 := JTF_NUMBER_TABLE();
94: a2 := JTF_VARCHAR2_TABLE_100();
95: a3 := JTF_VARCHAR2_TABLE_2000();
96: a4 := JTF_VARCHAR2_TABLE_100();
97: a5 := JTF_VARCHAR2_TABLE_100();
95: a3 := JTF_VARCHAR2_TABLE_2000();
96: a4 := JTF_VARCHAR2_TABLE_100();
97: a5 := JTF_VARCHAR2_TABLE_100();
98: a6 := JTF_DATE_TABLE();
99: a7 := JTF_NUMBER_TABLE();
100: a8 := JTF_DATE_TABLE();
101: a9 := JTF_NUMBER_TABLE();
102: a10 := JTF_NUMBER_TABLE();
103: else
97: a5 := JTF_VARCHAR2_TABLE_100();
98: a6 := JTF_DATE_TABLE();
99: a7 := JTF_NUMBER_TABLE();
100: a8 := JTF_DATE_TABLE();
101: a9 := JTF_NUMBER_TABLE();
102: a10 := JTF_NUMBER_TABLE();
103: else
104: a0 := JTF_NUMBER_TABLE();
105: a1 := JTF_NUMBER_TABLE();
98: a6 := JTF_DATE_TABLE();
99: a7 := JTF_NUMBER_TABLE();
100: a8 := JTF_DATE_TABLE();
101: a9 := JTF_NUMBER_TABLE();
102: a10 := JTF_NUMBER_TABLE();
103: else
104: a0 := JTF_NUMBER_TABLE();
105: a1 := JTF_NUMBER_TABLE();
106: a2 := JTF_VARCHAR2_TABLE_100();
100: a8 := JTF_DATE_TABLE();
101: a9 := JTF_NUMBER_TABLE();
102: a10 := JTF_NUMBER_TABLE();
103: else
104: a0 := JTF_NUMBER_TABLE();
105: a1 := JTF_NUMBER_TABLE();
106: a2 := JTF_VARCHAR2_TABLE_100();
107: a3 := JTF_VARCHAR2_TABLE_2000();
108: a4 := JTF_VARCHAR2_TABLE_100();
101: a9 := JTF_NUMBER_TABLE();
102: a10 := JTF_NUMBER_TABLE();
103: else
104: a0 := JTF_NUMBER_TABLE();
105: a1 := JTF_NUMBER_TABLE();
106: a2 := JTF_VARCHAR2_TABLE_100();
107: a3 := JTF_VARCHAR2_TABLE_2000();
108: a4 := JTF_VARCHAR2_TABLE_100();
109: a5 := JTF_VARCHAR2_TABLE_100();
107: a3 := JTF_VARCHAR2_TABLE_2000();
108: a4 := JTF_VARCHAR2_TABLE_100();
109: a5 := JTF_VARCHAR2_TABLE_100();
110: a6 := JTF_DATE_TABLE();
111: a7 := JTF_NUMBER_TABLE();
112: a8 := JTF_DATE_TABLE();
113: a9 := JTF_NUMBER_TABLE();
114: a10 := JTF_NUMBER_TABLE();
115: if t.count > 0 then
109: a5 := JTF_VARCHAR2_TABLE_100();
110: a6 := JTF_DATE_TABLE();
111: a7 := JTF_NUMBER_TABLE();
112: a8 := JTF_DATE_TABLE();
113: a9 := JTF_NUMBER_TABLE();
114: a10 := JTF_NUMBER_TABLE();
115: if t.count > 0 then
116: a0.extend(t.count);
117: a1.extend(t.count);
110: a6 := JTF_DATE_TABLE();
111: a7 := JTF_NUMBER_TABLE();
112: a8 := JTF_DATE_TABLE();
113: a9 := JTF_NUMBER_TABLE();
114: a10 := JTF_NUMBER_TABLE();
115: if t.count > 0 then
116: a0.extend(t.count);
117: a1.extend(t.count);
118: a2.extend(t.count);
232: , p_cnt_type_description VARCHAR2
233: , p10_a0 out nocopy NUMBER
234: , p10_a1 out nocopy NUMBER
235: , p10_a2 out nocopy NUMBER
236: , p11_a0 out nocopy JTF_NUMBER_TABLE
237: , p11_a1 out nocopy JTF_NUMBER_TABLE
238: , p11_a2 out nocopy JTF_VARCHAR2_TABLE_100
239: , p11_a3 out nocopy JTF_VARCHAR2_TABLE_2000
240: , p11_a4 out nocopy JTF_VARCHAR2_TABLE_100
233: , p10_a0 out nocopy NUMBER
234: , p10_a1 out nocopy NUMBER
235: , p10_a2 out nocopy NUMBER
236: , p11_a0 out nocopy JTF_NUMBER_TABLE
237: , p11_a1 out nocopy JTF_NUMBER_TABLE
238: , p11_a2 out nocopy JTF_VARCHAR2_TABLE_100
239: , p11_a3 out nocopy JTF_VARCHAR2_TABLE_2000
240: , p11_a4 out nocopy JTF_VARCHAR2_TABLE_100
241: , p11_a5 out nocopy JTF_VARCHAR2_TABLE_100
239: , p11_a3 out nocopy JTF_VARCHAR2_TABLE_2000
240: , p11_a4 out nocopy JTF_VARCHAR2_TABLE_100
241: , p11_a5 out nocopy JTF_VARCHAR2_TABLE_100
242: , p11_a6 out nocopy JTF_DATE_TABLE
243: , p11_a7 out nocopy JTF_NUMBER_TABLE
244: , p11_a8 out nocopy JTF_DATE_TABLE
245: , p11_a9 out nocopy JTF_NUMBER_TABLE
246: , p11_a10 out nocopy JTF_NUMBER_TABLE
247: , p9_a0 NUMBER := 0-1962.0724
241: , p11_a5 out nocopy JTF_VARCHAR2_TABLE_100
242: , p11_a6 out nocopy JTF_DATE_TABLE
243: , p11_a7 out nocopy JTF_NUMBER_TABLE
244: , p11_a8 out nocopy JTF_DATE_TABLE
245: , p11_a9 out nocopy JTF_NUMBER_TABLE
246: , p11_a10 out nocopy JTF_NUMBER_TABLE
247: , p9_a0 NUMBER := 0-1962.0724
248: , p9_a1 NUMBER := 0-1962.0724
249: , p9_a2 VARCHAR2 := fnd_api.g_miss_char
242: , p11_a6 out nocopy JTF_DATE_TABLE
243: , p11_a7 out nocopy JTF_NUMBER_TABLE
244: , p11_a8 out nocopy JTF_DATE_TABLE
245: , p11_a9 out nocopy JTF_NUMBER_TABLE
246: , p11_a10 out nocopy JTF_NUMBER_TABLE
247: , p9_a0 NUMBER := 0-1962.0724
248: , p9_a1 NUMBER := 0-1962.0724
249: , p9_a2 VARCHAR2 := fnd_api.g_miss_char
250: )