1: package body pv_partner_accesses_pvt_w as
2: /* $Header: pvxwprab.pls 120.1 2005/09/06 00:09 appldev ship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy pv_partner_accesses_pvt.partner_access_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
1: package body pv_partner_accesses_pvt_w as
2: /* $Header: pvxwprab.pls 120.1 2005/09/06 00:09 appldev ship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy pv_partner_accesses_pvt.partner_access_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
1: package body pv_partner_accesses_pvt_w as
2: /* $Header: pvxwprab.pls 120.1 2005/09/06 00:09 appldev ship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy pv_partner_accesses_pvt.partner_access_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_DATE_TABLE
13: , a10 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_DATE_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_DATE_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_DATE_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_DATE_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_DATE_TABLE
12: , a9 JTF_DATE_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_DATE_TABLE
20: , a17 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_DATE_TABLE
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_200
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_DATE_TABLE
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_200
22: , a19 JTF_VARCHAR2_TABLE_200
82: end loop;
83: end if;
84: end if;
85: end rosetta_table_copy_in_p2;
86: procedure rosetta_table_copy_out_p2(t pv_partner_accesses_pvt.partner_access_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
87: , a1 out nocopy JTF_NUMBER_TABLE
88: , a2 out nocopy JTF_NUMBER_TABLE
89: , a3 out nocopy JTF_VARCHAR2_TABLE_100
90: , a4 out nocopy JTF_VARCHAR2_TABLE_100
83: end if;
84: end if;
85: end rosetta_table_copy_in_p2;
86: procedure rosetta_table_copy_out_p2(t pv_partner_accesses_pvt.partner_access_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
87: , a1 out nocopy JTF_NUMBER_TABLE
88: , a2 out nocopy JTF_NUMBER_TABLE
89: , a3 out nocopy JTF_VARCHAR2_TABLE_100
90: , a4 out nocopy JTF_VARCHAR2_TABLE_100
91: , a5 out nocopy JTF_VARCHAR2_TABLE_100
84: end if;
85: end rosetta_table_copy_in_p2;
86: procedure rosetta_table_copy_out_p2(t pv_partner_accesses_pvt.partner_access_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
87: , a1 out nocopy JTF_NUMBER_TABLE
88: , a2 out nocopy JTF_NUMBER_TABLE
89: , a3 out nocopy JTF_VARCHAR2_TABLE_100
90: , a4 out nocopy JTF_VARCHAR2_TABLE_100
91: , a5 out nocopy JTF_VARCHAR2_TABLE_100
92: , a6 out nocopy JTF_NUMBER_TABLE
88: , a2 out nocopy JTF_NUMBER_TABLE
89: , a3 out nocopy JTF_VARCHAR2_TABLE_100
90: , a4 out nocopy JTF_VARCHAR2_TABLE_100
91: , a5 out nocopy JTF_VARCHAR2_TABLE_100
92: , a6 out nocopy JTF_NUMBER_TABLE
93: , a7 out nocopy JTF_DATE_TABLE
94: , a8 out nocopy JTF_NUMBER_TABLE
95: , a9 out nocopy JTF_DATE_TABLE
96: , a10 out nocopy JTF_NUMBER_TABLE
90: , a4 out nocopy JTF_VARCHAR2_TABLE_100
91: , a5 out nocopy JTF_VARCHAR2_TABLE_100
92: , a6 out nocopy JTF_NUMBER_TABLE
93: , a7 out nocopy JTF_DATE_TABLE
94: , a8 out nocopy JTF_NUMBER_TABLE
95: , a9 out nocopy JTF_DATE_TABLE
96: , a10 out nocopy JTF_NUMBER_TABLE
97: , a11 out nocopy JTF_NUMBER_TABLE
98: , a12 out nocopy JTF_NUMBER_TABLE
92: , a6 out nocopy JTF_NUMBER_TABLE
93: , a7 out nocopy JTF_DATE_TABLE
94: , a8 out nocopy JTF_NUMBER_TABLE
95: , a9 out nocopy JTF_DATE_TABLE
96: , a10 out nocopy JTF_NUMBER_TABLE
97: , a11 out nocopy JTF_NUMBER_TABLE
98: , a12 out nocopy JTF_NUMBER_TABLE
99: , a13 out nocopy JTF_NUMBER_TABLE
100: , a14 out nocopy JTF_NUMBER_TABLE
93: , a7 out nocopy JTF_DATE_TABLE
94: , a8 out nocopy JTF_NUMBER_TABLE
95: , a9 out nocopy JTF_DATE_TABLE
96: , a10 out nocopy JTF_NUMBER_TABLE
97: , a11 out nocopy JTF_NUMBER_TABLE
98: , a12 out nocopy JTF_NUMBER_TABLE
99: , a13 out nocopy JTF_NUMBER_TABLE
100: , a14 out nocopy JTF_NUMBER_TABLE
101: , a15 out nocopy JTF_NUMBER_TABLE
94: , a8 out nocopy JTF_NUMBER_TABLE
95: , a9 out nocopy JTF_DATE_TABLE
96: , a10 out nocopy JTF_NUMBER_TABLE
97: , a11 out nocopy JTF_NUMBER_TABLE
98: , a12 out nocopy JTF_NUMBER_TABLE
99: , a13 out nocopy JTF_NUMBER_TABLE
100: , a14 out nocopy JTF_NUMBER_TABLE
101: , a15 out nocopy JTF_NUMBER_TABLE
102: , a16 out nocopy JTF_DATE_TABLE
95: , a9 out nocopy JTF_DATE_TABLE
96: , a10 out nocopy JTF_NUMBER_TABLE
97: , a11 out nocopy JTF_NUMBER_TABLE
98: , a12 out nocopy JTF_NUMBER_TABLE
99: , a13 out nocopy JTF_NUMBER_TABLE
100: , a14 out nocopy JTF_NUMBER_TABLE
101: , a15 out nocopy JTF_NUMBER_TABLE
102: , a16 out nocopy JTF_DATE_TABLE
103: , a17 out nocopy JTF_VARCHAR2_TABLE_100
96: , a10 out nocopy JTF_NUMBER_TABLE
97: , a11 out nocopy JTF_NUMBER_TABLE
98: , a12 out nocopy JTF_NUMBER_TABLE
99: , a13 out nocopy JTF_NUMBER_TABLE
100: , a14 out nocopy JTF_NUMBER_TABLE
101: , a15 out nocopy JTF_NUMBER_TABLE
102: , a16 out nocopy JTF_DATE_TABLE
103: , a17 out nocopy JTF_VARCHAR2_TABLE_100
104: , a18 out nocopy JTF_VARCHAR2_TABLE_200
97: , a11 out nocopy JTF_NUMBER_TABLE
98: , a12 out nocopy JTF_NUMBER_TABLE
99: , a13 out nocopy JTF_NUMBER_TABLE
100: , a14 out nocopy JTF_NUMBER_TABLE
101: , a15 out nocopy JTF_NUMBER_TABLE
102: , a16 out nocopy JTF_DATE_TABLE
103: , a17 out nocopy JTF_VARCHAR2_TABLE_100
104: , a18 out nocopy JTF_VARCHAR2_TABLE_200
105: , a19 out nocopy JTF_VARCHAR2_TABLE_200
119: ) as
120: ddindx binary_integer; indx binary_integer;
121: begin
122: if t is null or t.count = 0 then
123: a0 := JTF_NUMBER_TABLE();
124: a1 := JTF_NUMBER_TABLE();
125: a2 := JTF_NUMBER_TABLE();
126: a3 := JTF_VARCHAR2_TABLE_100();
127: a4 := JTF_VARCHAR2_TABLE_100();
120: ddindx binary_integer; indx binary_integer;
121: begin
122: if t is null or t.count = 0 then
123: a0 := JTF_NUMBER_TABLE();
124: a1 := JTF_NUMBER_TABLE();
125: a2 := JTF_NUMBER_TABLE();
126: a3 := JTF_VARCHAR2_TABLE_100();
127: a4 := JTF_VARCHAR2_TABLE_100();
128: a5 := JTF_VARCHAR2_TABLE_100();
121: begin
122: if t is null or t.count = 0 then
123: a0 := JTF_NUMBER_TABLE();
124: a1 := JTF_NUMBER_TABLE();
125: a2 := JTF_NUMBER_TABLE();
126: a3 := JTF_VARCHAR2_TABLE_100();
127: a4 := JTF_VARCHAR2_TABLE_100();
128: a5 := JTF_VARCHAR2_TABLE_100();
129: a6 := JTF_NUMBER_TABLE();
125: a2 := JTF_NUMBER_TABLE();
126: a3 := JTF_VARCHAR2_TABLE_100();
127: a4 := JTF_VARCHAR2_TABLE_100();
128: a5 := JTF_VARCHAR2_TABLE_100();
129: a6 := JTF_NUMBER_TABLE();
130: a7 := JTF_DATE_TABLE();
131: a8 := JTF_NUMBER_TABLE();
132: a9 := JTF_DATE_TABLE();
133: a10 := JTF_NUMBER_TABLE();
127: a4 := JTF_VARCHAR2_TABLE_100();
128: a5 := JTF_VARCHAR2_TABLE_100();
129: a6 := JTF_NUMBER_TABLE();
130: a7 := JTF_DATE_TABLE();
131: a8 := JTF_NUMBER_TABLE();
132: a9 := JTF_DATE_TABLE();
133: a10 := JTF_NUMBER_TABLE();
134: a11 := JTF_NUMBER_TABLE();
135: a12 := JTF_NUMBER_TABLE();
129: a6 := JTF_NUMBER_TABLE();
130: a7 := JTF_DATE_TABLE();
131: a8 := JTF_NUMBER_TABLE();
132: a9 := JTF_DATE_TABLE();
133: a10 := JTF_NUMBER_TABLE();
134: a11 := JTF_NUMBER_TABLE();
135: a12 := JTF_NUMBER_TABLE();
136: a13 := JTF_NUMBER_TABLE();
137: a14 := JTF_NUMBER_TABLE();
130: a7 := JTF_DATE_TABLE();
131: a8 := JTF_NUMBER_TABLE();
132: a9 := JTF_DATE_TABLE();
133: a10 := JTF_NUMBER_TABLE();
134: a11 := JTF_NUMBER_TABLE();
135: a12 := JTF_NUMBER_TABLE();
136: a13 := JTF_NUMBER_TABLE();
137: a14 := JTF_NUMBER_TABLE();
138: a15 := JTF_NUMBER_TABLE();
131: a8 := JTF_NUMBER_TABLE();
132: a9 := JTF_DATE_TABLE();
133: a10 := JTF_NUMBER_TABLE();
134: a11 := JTF_NUMBER_TABLE();
135: a12 := JTF_NUMBER_TABLE();
136: a13 := JTF_NUMBER_TABLE();
137: a14 := JTF_NUMBER_TABLE();
138: a15 := JTF_NUMBER_TABLE();
139: a16 := JTF_DATE_TABLE();
132: a9 := JTF_DATE_TABLE();
133: a10 := JTF_NUMBER_TABLE();
134: a11 := JTF_NUMBER_TABLE();
135: a12 := JTF_NUMBER_TABLE();
136: a13 := JTF_NUMBER_TABLE();
137: a14 := JTF_NUMBER_TABLE();
138: a15 := JTF_NUMBER_TABLE();
139: a16 := JTF_DATE_TABLE();
140: a17 := JTF_VARCHAR2_TABLE_100();
133: a10 := JTF_NUMBER_TABLE();
134: a11 := JTF_NUMBER_TABLE();
135: a12 := JTF_NUMBER_TABLE();
136: a13 := JTF_NUMBER_TABLE();
137: a14 := JTF_NUMBER_TABLE();
138: a15 := JTF_NUMBER_TABLE();
139: a16 := JTF_DATE_TABLE();
140: a17 := JTF_VARCHAR2_TABLE_100();
141: a18 := JTF_VARCHAR2_TABLE_200();
134: a11 := JTF_NUMBER_TABLE();
135: a12 := JTF_NUMBER_TABLE();
136: a13 := JTF_NUMBER_TABLE();
137: a14 := JTF_NUMBER_TABLE();
138: a15 := JTF_NUMBER_TABLE();
139: a16 := JTF_DATE_TABLE();
140: a17 := JTF_VARCHAR2_TABLE_100();
141: a18 := JTF_VARCHAR2_TABLE_200();
142: a19 := JTF_VARCHAR2_TABLE_200();
153: a30 := JTF_VARCHAR2_TABLE_200();
154: a31 := JTF_VARCHAR2_TABLE_200();
155: a32 := JTF_VARCHAR2_TABLE_200();
156: else
157: a0 := JTF_NUMBER_TABLE();
158: a1 := JTF_NUMBER_TABLE();
159: a2 := JTF_NUMBER_TABLE();
160: a3 := JTF_VARCHAR2_TABLE_100();
161: a4 := JTF_VARCHAR2_TABLE_100();
154: a31 := JTF_VARCHAR2_TABLE_200();
155: a32 := JTF_VARCHAR2_TABLE_200();
156: else
157: a0 := JTF_NUMBER_TABLE();
158: a1 := JTF_NUMBER_TABLE();
159: a2 := JTF_NUMBER_TABLE();
160: a3 := JTF_VARCHAR2_TABLE_100();
161: a4 := JTF_VARCHAR2_TABLE_100();
162: a5 := JTF_VARCHAR2_TABLE_100();
155: a32 := JTF_VARCHAR2_TABLE_200();
156: else
157: a0 := JTF_NUMBER_TABLE();
158: a1 := JTF_NUMBER_TABLE();
159: a2 := JTF_NUMBER_TABLE();
160: a3 := JTF_VARCHAR2_TABLE_100();
161: a4 := JTF_VARCHAR2_TABLE_100();
162: a5 := JTF_VARCHAR2_TABLE_100();
163: a6 := JTF_NUMBER_TABLE();
159: a2 := JTF_NUMBER_TABLE();
160: a3 := JTF_VARCHAR2_TABLE_100();
161: a4 := JTF_VARCHAR2_TABLE_100();
162: a5 := JTF_VARCHAR2_TABLE_100();
163: a6 := JTF_NUMBER_TABLE();
164: a7 := JTF_DATE_TABLE();
165: a8 := JTF_NUMBER_TABLE();
166: a9 := JTF_DATE_TABLE();
167: a10 := JTF_NUMBER_TABLE();
161: a4 := JTF_VARCHAR2_TABLE_100();
162: a5 := JTF_VARCHAR2_TABLE_100();
163: a6 := JTF_NUMBER_TABLE();
164: a7 := JTF_DATE_TABLE();
165: a8 := JTF_NUMBER_TABLE();
166: a9 := JTF_DATE_TABLE();
167: a10 := JTF_NUMBER_TABLE();
168: a11 := JTF_NUMBER_TABLE();
169: a12 := JTF_NUMBER_TABLE();
163: a6 := JTF_NUMBER_TABLE();
164: a7 := JTF_DATE_TABLE();
165: a8 := JTF_NUMBER_TABLE();
166: a9 := JTF_DATE_TABLE();
167: a10 := JTF_NUMBER_TABLE();
168: a11 := JTF_NUMBER_TABLE();
169: a12 := JTF_NUMBER_TABLE();
170: a13 := JTF_NUMBER_TABLE();
171: a14 := JTF_NUMBER_TABLE();
164: a7 := JTF_DATE_TABLE();
165: a8 := JTF_NUMBER_TABLE();
166: a9 := JTF_DATE_TABLE();
167: a10 := JTF_NUMBER_TABLE();
168: a11 := JTF_NUMBER_TABLE();
169: a12 := JTF_NUMBER_TABLE();
170: a13 := JTF_NUMBER_TABLE();
171: a14 := JTF_NUMBER_TABLE();
172: a15 := JTF_NUMBER_TABLE();
165: a8 := JTF_NUMBER_TABLE();
166: a9 := JTF_DATE_TABLE();
167: a10 := JTF_NUMBER_TABLE();
168: a11 := JTF_NUMBER_TABLE();
169: a12 := JTF_NUMBER_TABLE();
170: a13 := JTF_NUMBER_TABLE();
171: a14 := JTF_NUMBER_TABLE();
172: a15 := JTF_NUMBER_TABLE();
173: a16 := JTF_DATE_TABLE();
166: a9 := JTF_DATE_TABLE();
167: a10 := JTF_NUMBER_TABLE();
168: a11 := JTF_NUMBER_TABLE();
169: a12 := JTF_NUMBER_TABLE();
170: a13 := JTF_NUMBER_TABLE();
171: a14 := JTF_NUMBER_TABLE();
172: a15 := JTF_NUMBER_TABLE();
173: a16 := JTF_DATE_TABLE();
174: a17 := JTF_VARCHAR2_TABLE_100();
167: a10 := JTF_NUMBER_TABLE();
168: a11 := JTF_NUMBER_TABLE();
169: a12 := JTF_NUMBER_TABLE();
170: a13 := JTF_NUMBER_TABLE();
171: a14 := JTF_NUMBER_TABLE();
172: a15 := JTF_NUMBER_TABLE();
173: a16 := JTF_DATE_TABLE();
174: a17 := JTF_VARCHAR2_TABLE_100();
175: a18 := JTF_VARCHAR2_TABLE_200();
168: a11 := JTF_NUMBER_TABLE();
169: a12 := JTF_NUMBER_TABLE();
170: a13 := JTF_NUMBER_TABLE();
171: a14 := JTF_NUMBER_TABLE();
172: a15 := JTF_NUMBER_TABLE();
173: a16 := JTF_DATE_TABLE();
174: a17 := JTF_VARCHAR2_TABLE_100();
175: a18 := JTF_VARCHAR2_TABLE_200();
176: a19 := JTF_VARCHAR2_TABLE_200();