12:
13: procedure rosetta_table_copy_in_p1(t out nocopy cn_sales_hier_pub.hier_tbl_type, a0 JTF_VARCHAR2_TABLE_300
14: , a1 JTF_VARCHAR2_TABLE_100
15: , a2 JTF_VARCHAR2_TABLE_100
16: , a3 JTF_DATE_TABLE
17: , a4 JTF_DATE_TABLE
18: ) as
19: ddindx binary_integer; indx binary_integer;
20: begin
13: procedure rosetta_table_copy_in_p1(t out nocopy cn_sales_hier_pub.hier_tbl_type, a0 JTF_VARCHAR2_TABLE_300
14: , a1 JTF_VARCHAR2_TABLE_100
15: , a2 JTF_VARCHAR2_TABLE_100
16: , a3 JTF_DATE_TABLE
17: , a4 JTF_DATE_TABLE
18: ) as
19: ddindx binary_integer; indx binary_integer;
20: begin
21: if a0 is not null and a0.count > 0 then
39: end rosetta_table_copy_in_p1;
40: procedure rosetta_table_copy_out_p1(t cn_sales_hier_pub.hier_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_300
41: , a1 out nocopy JTF_VARCHAR2_TABLE_100
42: , a2 out nocopy JTF_VARCHAR2_TABLE_100
43: , a3 out nocopy JTF_DATE_TABLE
44: , a4 out nocopy JTF_DATE_TABLE
45: ) as
46: ddindx binary_integer; indx binary_integer;
47: begin
40: procedure rosetta_table_copy_out_p1(t cn_sales_hier_pub.hier_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_300
41: , a1 out nocopy JTF_VARCHAR2_TABLE_100
42: , a2 out nocopy JTF_VARCHAR2_TABLE_100
43: , a3 out nocopy JTF_DATE_TABLE
44: , a4 out nocopy JTF_DATE_TABLE
45: ) as
46: ddindx binary_integer; indx binary_integer;
47: begin
48: if t is null or t.count = 0 then
48: if t is null or t.count = 0 then
49: a0 := JTF_VARCHAR2_TABLE_300();
50: a1 := JTF_VARCHAR2_TABLE_100();
51: a2 := JTF_VARCHAR2_TABLE_100();
52: a3 := JTF_DATE_TABLE();
53: a4 := JTF_DATE_TABLE();
54: else
55: a0 := JTF_VARCHAR2_TABLE_300();
56: a1 := JTF_VARCHAR2_TABLE_100();
49: a0 := JTF_VARCHAR2_TABLE_300();
50: a1 := JTF_VARCHAR2_TABLE_100();
51: a2 := JTF_VARCHAR2_TABLE_100();
52: a3 := JTF_DATE_TABLE();
53: a4 := JTF_DATE_TABLE();
54: else
55: a0 := JTF_VARCHAR2_TABLE_300();
56: a1 := JTF_VARCHAR2_TABLE_100();
57: a2 := JTF_VARCHAR2_TABLE_100();
54: else
55: a0 := JTF_VARCHAR2_TABLE_300();
56: a1 := JTF_VARCHAR2_TABLE_100();
57: a2 := JTF_VARCHAR2_TABLE_100();
58: a3 := JTF_DATE_TABLE();
59: a4 := JTF_DATE_TABLE();
60: if t.count > 0 then
61: a0.extend(t.count);
62: a1.extend(t.count);
55: a0 := JTF_VARCHAR2_TABLE_300();
56: a1 := JTF_VARCHAR2_TABLE_100();
57: a2 := JTF_VARCHAR2_TABLE_100();
58: a3 := JTF_DATE_TABLE();
59: a4 := JTF_DATE_TABLE();
60: if t.count > 0 then
61: a0.extend(t.count);
62: a1.extend(t.count);
63: a2.extend(t.count);
161: , p_increment_count_grp NUMBER
162: , p14_a0 out nocopy JTF_VARCHAR2_TABLE_300
163: , p14_a1 out nocopy JTF_VARCHAR2_TABLE_100
164: , p14_a2 out nocopy JTF_VARCHAR2_TABLE_100
165: , p14_a3 out nocopy JTF_DATE_TABLE
166: , p14_a4 out nocopy JTF_DATE_TABLE
167: , x_mgr_count out nocopy NUMBER
168: , p16_a0 out nocopy JTF_VARCHAR2_TABLE_300
169: , p16_a1 out nocopy JTF_VARCHAR2_TABLE_100
162: , p14_a0 out nocopy JTF_VARCHAR2_TABLE_300
163: , p14_a1 out nocopy JTF_VARCHAR2_TABLE_100
164: , p14_a2 out nocopy JTF_VARCHAR2_TABLE_100
165: , p14_a3 out nocopy JTF_DATE_TABLE
166: , p14_a4 out nocopy JTF_DATE_TABLE
167: , x_mgr_count out nocopy NUMBER
168: , p16_a0 out nocopy JTF_VARCHAR2_TABLE_300
169: , p16_a1 out nocopy JTF_VARCHAR2_TABLE_100
170: , p16_a2 out nocopy JTF_VARCHAR2_TABLE_100
167: , x_mgr_count out nocopy NUMBER
168: , p16_a0 out nocopy JTF_VARCHAR2_TABLE_300
169: , p16_a1 out nocopy JTF_VARCHAR2_TABLE_100
170: , p16_a2 out nocopy JTF_VARCHAR2_TABLE_100
171: , p16_a3 out nocopy JTF_DATE_TABLE
172: , p16_a4 out nocopy JTF_DATE_TABLE
173: , x_srp_count out nocopy NUMBER
174: , p18_a0 out nocopy JTF_VARCHAR2_TABLE_100
175: , p18_a1 out nocopy JTF_NUMBER_TABLE
168: , p16_a0 out nocopy JTF_VARCHAR2_TABLE_300
169: , p16_a1 out nocopy JTF_VARCHAR2_TABLE_100
170: , p16_a2 out nocopy JTF_VARCHAR2_TABLE_100
171: , p16_a3 out nocopy JTF_DATE_TABLE
172: , p16_a4 out nocopy JTF_DATE_TABLE
173: , x_srp_count out nocopy NUMBER
174: , p18_a0 out nocopy JTF_VARCHAR2_TABLE_100
175: , p18_a1 out nocopy JTF_NUMBER_TABLE
176: , p18_a2 out nocopy JTF_VARCHAR2_TABLE_300