2: /* $Header: AHLWSBRB.pls 120.0.12020000.2 2012/12/14 06:28:47 shnatu noship $ */
3: procedure rosetta_table_copy_in_p4(t out nocopy ahl_sb_rules_pvt.sb_rule_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_DATE_TABLE
17: , a14 JTF_DATE_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_VARCHAR2_TABLE_200
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_DATE_TABLE
17: , a14 JTF_DATE_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_VARCHAR2_TABLE_200
21: , a18 JTF_VARCHAR2_TABLE_200
83: end rosetta_table_copy_in_p4;
84: procedure rosetta_table_copy_out_p4(t ahl_sb_rules_pvt.sb_rule_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
85: , a1 out nocopy JTF_VARCHAR2_TABLE_100
86: , a2 out nocopy JTF_NUMBER_TABLE
87: , a3 out nocopy JTF_DATE_TABLE
88: , a4 out nocopy JTF_NUMBER_TABLE
89: , a5 out nocopy JTF_DATE_TABLE
90: , a6 out nocopy JTF_NUMBER_TABLE
91: , a7 out nocopy JTF_NUMBER_TABLE
85: , a1 out nocopy JTF_VARCHAR2_TABLE_100
86: , a2 out nocopy JTF_NUMBER_TABLE
87: , a3 out nocopy JTF_DATE_TABLE
88: , a4 out nocopy JTF_NUMBER_TABLE
89: , a5 out nocopy JTF_DATE_TABLE
90: , a6 out nocopy JTF_NUMBER_TABLE
91: , a7 out nocopy JTF_NUMBER_TABLE
92: , a8 out nocopy JTF_VARCHAR2_TABLE_100
93: , a9 out nocopy JTF_NUMBER_TABLE
93: , a9 out nocopy JTF_NUMBER_TABLE
94: , a10 out nocopy JTF_NUMBER_TABLE
95: , a11 out nocopy JTF_NUMBER_TABLE
96: , a12 out nocopy JTF_NUMBER_TABLE
97: , a13 out nocopy JTF_DATE_TABLE
98: , a14 out nocopy JTF_DATE_TABLE
99: , a15 out nocopy JTF_NUMBER_TABLE
100: , a16 out nocopy JTF_VARCHAR2_TABLE_100
101: , a17 out nocopy JTF_VARCHAR2_TABLE_200
94: , a10 out nocopy JTF_NUMBER_TABLE
95: , a11 out nocopy JTF_NUMBER_TABLE
96: , a12 out nocopy JTF_NUMBER_TABLE
97: , a13 out nocopy JTF_DATE_TABLE
98: , a14 out nocopy JTF_DATE_TABLE
99: , a15 out nocopy JTF_NUMBER_TABLE
100: , a16 out nocopy JTF_VARCHAR2_TABLE_100
101: , a17 out nocopy JTF_VARCHAR2_TABLE_200
102: , a18 out nocopy JTF_VARCHAR2_TABLE_200
119: if t is null or t.count = 0 then
120: a0 := JTF_NUMBER_TABLE();
121: a1 := JTF_VARCHAR2_TABLE_100();
122: a2 := JTF_NUMBER_TABLE();
123: a3 := JTF_DATE_TABLE();
124: a4 := JTF_NUMBER_TABLE();
125: a5 := JTF_DATE_TABLE();
126: a6 := JTF_NUMBER_TABLE();
127: a7 := JTF_NUMBER_TABLE();
121: a1 := JTF_VARCHAR2_TABLE_100();
122: a2 := JTF_NUMBER_TABLE();
123: a3 := JTF_DATE_TABLE();
124: a4 := JTF_NUMBER_TABLE();
125: a5 := JTF_DATE_TABLE();
126: a6 := JTF_NUMBER_TABLE();
127: a7 := JTF_NUMBER_TABLE();
128: a8 := JTF_VARCHAR2_TABLE_100();
129: a9 := JTF_NUMBER_TABLE();
129: a9 := JTF_NUMBER_TABLE();
130: a10 := JTF_NUMBER_TABLE();
131: a11 := JTF_NUMBER_TABLE();
132: a12 := JTF_NUMBER_TABLE();
133: a13 := JTF_DATE_TABLE();
134: a14 := JTF_DATE_TABLE();
135: a15 := JTF_NUMBER_TABLE();
136: a16 := JTF_VARCHAR2_TABLE_100();
137: a17 := JTF_VARCHAR2_TABLE_200();
130: a10 := JTF_NUMBER_TABLE();
131: a11 := JTF_NUMBER_TABLE();
132: a12 := JTF_NUMBER_TABLE();
133: a13 := JTF_DATE_TABLE();
134: a14 := JTF_DATE_TABLE();
135: a15 := JTF_NUMBER_TABLE();
136: a16 := JTF_VARCHAR2_TABLE_100();
137: a17 := JTF_VARCHAR2_TABLE_200();
138: a18 := JTF_VARCHAR2_TABLE_200();
152: else
153: a0 := JTF_NUMBER_TABLE();
154: a1 := JTF_VARCHAR2_TABLE_100();
155: a2 := JTF_NUMBER_TABLE();
156: a3 := JTF_DATE_TABLE();
157: a4 := JTF_NUMBER_TABLE();
158: a5 := JTF_DATE_TABLE();
159: a6 := JTF_NUMBER_TABLE();
160: a7 := JTF_NUMBER_TABLE();
154: a1 := JTF_VARCHAR2_TABLE_100();
155: a2 := JTF_NUMBER_TABLE();
156: a3 := JTF_DATE_TABLE();
157: a4 := JTF_NUMBER_TABLE();
158: a5 := JTF_DATE_TABLE();
159: a6 := JTF_NUMBER_TABLE();
160: a7 := JTF_NUMBER_TABLE();
161: a8 := JTF_VARCHAR2_TABLE_100();
162: a9 := JTF_NUMBER_TABLE();
162: a9 := JTF_NUMBER_TABLE();
163: a10 := JTF_NUMBER_TABLE();
164: a11 := JTF_NUMBER_TABLE();
165: a12 := JTF_NUMBER_TABLE();
166: a13 := JTF_DATE_TABLE();
167: a14 := JTF_DATE_TABLE();
168: a15 := JTF_NUMBER_TABLE();
169: a16 := JTF_VARCHAR2_TABLE_100();
170: a17 := JTF_VARCHAR2_TABLE_200();
163: a10 := JTF_NUMBER_TABLE();
164: a11 := JTF_NUMBER_TABLE();
165: a12 := JTF_NUMBER_TABLE();
166: a13 := JTF_DATE_TABLE();
167: a14 := JTF_DATE_TABLE();
168: a15 := JTF_NUMBER_TABLE();
169: a16 := JTF_VARCHAR2_TABLE_100();
170: a17 := JTF_VARCHAR2_TABLE_200();
171: a18 := JTF_VARCHAR2_TABLE_200();
262:
263: procedure rosetta_table_copy_in_p6(t out nocopy ahl_sb_rules_pvt.sb_rule_items_tbl_type, a0 JTF_NUMBER_TABLE
264: , a1 JTF_VARCHAR2_TABLE_100
265: , a2 JTF_NUMBER_TABLE
266: , a3 JTF_DATE_TABLE
267: , a4 JTF_NUMBER_TABLE
268: , a5 JTF_DATE_TABLE
269: , a6 JTF_NUMBER_TABLE
270: , a7 JTF_NUMBER_TABLE
264: , a1 JTF_VARCHAR2_TABLE_100
265: , a2 JTF_NUMBER_TABLE
266: , a3 JTF_DATE_TABLE
267: , a4 JTF_NUMBER_TABLE
268: , a5 JTF_DATE_TABLE
269: , a6 JTF_NUMBER_TABLE
270: , a7 JTF_NUMBER_TABLE
271: , a8 JTF_NUMBER_TABLE
272: , a9 JTF_NUMBER_TABLE
337: end rosetta_table_copy_in_p6;
338: procedure rosetta_table_copy_out_p6(t ahl_sb_rules_pvt.sb_rule_items_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
339: , a1 out nocopy JTF_VARCHAR2_TABLE_100
340: , a2 out nocopy JTF_NUMBER_TABLE
341: , a3 out nocopy JTF_DATE_TABLE
342: , a4 out nocopy JTF_NUMBER_TABLE
343: , a5 out nocopy JTF_DATE_TABLE
344: , a6 out nocopy JTF_NUMBER_TABLE
345: , a7 out nocopy JTF_NUMBER_TABLE
339: , a1 out nocopy JTF_VARCHAR2_TABLE_100
340: , a2 out nocopy JTF_NUMBER_TABLE
341: , a3 out nocopy JTF_DATE_TABLE
342: , a4 out nocopy JTF_NUMBER_TABLE
343: , a5 out nocopy JTF_DATE_TABLE
344: , a6 out nocopy JTF_NUMBER_TABLE
345: , a7 out nocopy JTF_NUMBER_TABLE
346: , a8 out nocopy JTF_NUMBER_TABLE
347: , a9 out nocopy JTF_NUMBER_TABLE
370: if t is null or t.count = 0 then
371: a0 := JTF_NUMBER_TABLE();
372: a1 := JTF_VARCHAR2_TABLE_100();
373: a2 := JTF_NUMBER_TABLE();
374: a3 := JTF_DATE_TABLE();
375: a4 := JTF_NUMBER_TABLE();
376: a5 := JTF_DATE_TABLE();
377: a6 := JTF_NUMBER_TABLE();
378: a7 := JTF_NUMBER_TABLE();
372: a1 := JTF_VARCHAR2_TABLE_100();
373: a2 := JTF_NUMBER_TABLE();
374: a3 := JTF_DATE_TABLE();
375: a4 := JTF_NUMBER_TABLE();
376: a5 := JTF_DATE_TABLE();
377: a6 := JTF_NUMBER_TABLE();
378: a7 := JTF_NUMBER_TABLE();
379: a8 := JTF_NUMBER_TABLE();
380: a9 := JTF_NUMBER_TABLE();
400: else
401: a0 := JTF_NUMBER_TABLE();
402: a1 := JTF_VARCHAR2_TABLE_100();
403: a2 := JTF_NUMBER_TABLE();
404: a3 := JTF_DATE_TABLE();
405: a4 := JTF_NUMBER_TABLE();
406: a5 := JTF_DATE_TABLE();
407: a6 := JTF_NUMBER_TABLE();
408: a7 := JTF_NUMBER_TABLE();
402: a1 := JTF_VARCHAR2_TABLE_100();
403: a2 := JTF_NUMBER_TABLE();
404: a3 := JTF_DATE_TABLE();
405: a4 := JTF_NUMBER_TABLE();
406: a5 := JTF_DATE_TABLE();
407: a6 := JTF_NUMBER_TABLE();
408: a7 := JTF_NUMBER_TABLE();
409: a8 := JTF_NUMBER_TABLE();
410: a9 := JTF_NUMBER_TABLE();