1: package ahl_approvals_pvt_w as
2: /* $Header: AHLWAPRS.pls 120.0 2005/05/25 23:47:34 appldev noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy ahl_approvals_pvt.approvers_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
1: package ahl_approvals_pvt_w as
2: /* $Header: AHLWAPRS.pls 120.0 2005/05/25 23:47:34 appldev noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy ahl_approvals_pvt.approvers_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
1: package ahl_approvals_pvt_w as
2: /* $Header: AHLWAPRS.pls 120.0 2005/05/25 23:47:34 appldev noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy ahl_approvals_pvt.approvers_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_VARCHAR2_TABLE_100
3: procedure rosetta_table_copy_in_p2(t out nocopy ahl_approvals_pvt.approvers_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_VARCHAR2_TABLE_100
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_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
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_VARCHAR2_TABLE_100
16: , a13 JTF_VARCHAR2_TABLE_200
17: , a14 JTF_VARCHAR2_TABLE_200
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_VARCHAR2_TABLE_100
16: , a13 JTF_VARCHAR2_TABLE_200
17: , a14 JTF_VARCHAR2_TABLE_200
18: , a15 JTF_VARCHAR2_TABLE_200
29: , a26 JTF_VARCHAR2_TABLE_200
30: , a27 JTF_VARCHAR2_TABLE_200
31: , a28 JTF_VARCHAR2_TABLE_100
32: );
33: procedure rosetta_table_copy_out_p2(t ahl_approvals_pvt.approvers_tbl, a0 out nocopy JTF_NUMBER_TABLE
34: , a1 out nocopy JTF_NUMBER_TABLE
35: , a2 out nocopy JTF_NUMBER_TABLE
36: , a3 out nocopy JTF_VARCHAR2_TABLE_100
37: , a4 out nocopy JTF_NUMBER_TABLE
30: , a27 JTF_VARCHAR2_TABLE_200
31: , a28 JTF_VARCHAR2_TABLE_100
32: );
33: procedure rosetta_table_copy_out_p2(t ahl_approvals_pvt.approvers_tbl, a0 out nocopy JTF_NUMBER_TABLE
34: , a1 out nocopy JTF_NUMBER_TABLE
35: , a2 out nocopy JTF_NUMBER_TABLE
36: , a3 out nocopy JTF_VARCHAR2_TABLE_100
37: , a4 out nocopy JTF_NUMBER_TABLE
38: , a5 out nocopy JTF_NUMBER_TABLE
31: , a28 JTF_VARCHAR2_TABLE_100
32: );
33: procedure rosetta_table_copy_out_p2(t ahl_approvals_pvt.approvers_tbl, a0 out nocopy JTF_NUMBER_TABLE
34: , a1 out nocopy JTF_NUMBER_TABLE
35: , a2 out nocopy JTF_NUMBER_TABLE
36: , a3 out nocopy JTF_VARCHAR2_TABLE_100
37: , a4 out nocopy JTF_NUMBER_TABLE
38: , a5 out nocopy JTF_NUMBER_TABLE
39: , a6 out nocopy JTF_VARCHAR2_TABLE_100
33: procedure rosetta_table_copy_out_p2(t ahl_approvals_pvt.approvers_tbl, a0 out nocopy JTF_NUMBER_TABLE
34: , a1 out nocopy JTF_NUMBER_TABLE
35: , a2 out nocopy JTF_NUMBER_TABLE
36: , a3 out nocopy JTF_VARCHAR2_TABLE_100
37: , a4 out nocopy JTF_NUMBER_TABLE
38: , a5 out nocopy JTF_NUMBER_TABLE
39: , a6 out nocopy JTF_VARCHAR2_TABLE_100
40: , a7 out nocopy JTF_DATE_TABLE
41: , a8 out nocopy JTF_NUMBER_TABLE
34: , a1 out nocopy JTF_NUMBER_TABLE
35: , a2 out nocopy JTF_NUMBER_TABLE
36: , a3 out nocopy JTF_VARCHAR2_TABLE_100
37: , a4 out nocopy JTF_NUMBER_TABLE
38: , a5 out nocopy JTF_NUMBER_TABLE
39: , a6 out nocopy JTF_VARCHAR2_TABLE_100
40: , a7 out nocopy JTF_DATE_TABLE
41: , a8 out nocopy JTF_NUMBER_TABLE
42: , a9 out nocopy JTF_DATE_TABLE
37: , a4 out nocopy JTF_NUMBER_TABLE
38: , a5 out nocopy JTF_NUMBER_TABLE
39: , a6 out nocopy JTF_VARCHAR2_TABLE_100
40: , a7 out nocopy JTF_DATE_TABLE
41: , a8 out nocopy JTF_NUMBER_TABLE
42: , a9 out nocopy JTF_DATE_TABLE
43: , a10 out nocopy JTF_NUMBER_TABLE
44: , a11 out nocopy JTF_NUMBER_TABLE
45: , a12 out nocopy JTF_VARCHAR2_TABLE_100
39: , a6 out nocopy JTF_VARCHAR2_TABLE_100
40: , a7 out nocopy JTF_DATE_TABLE
41: , a8 out nocopy JTF_NUMBER_TABLE
42: , a9 out nocopy JTF_DATE_TABLE
43: , a10 out nocopy JTF_NUMBER_TABLE
44: , a11 out nocopy JTF_NUMBER_TABLE
45: , a12 out nocopy JTF_VARCHAR2_TABLE_100
46: , a13 out nocopy JTF_VARCHAR2_TABLE_200
47: , a14 out nocopy JTF_VARCHAR2_TABLE_200
40: , a7 out nocopy JTF_DATE_TABLE
41: , a8 out nocopy JTF_NUMBER_TABLE
42: , a9 out nocopy JTF_DATE_TABLE
43: , a10 out nocopy JTF_NUMBER_TABLE
44: , a11 out nocopy JTF_NUMBER_TABLE
45: , a12 out nocopy JTF_VARCHAR2_TABLE_100
46: , a13 out nocopy JTF_VARCHAR2_TABLE_200
47: , a14 out nocopy JTF_VARCHAR2_TABLE_200
48: , a15 out nocopy JTF_VARCHAR2_TABLE_200
101: , p4_a33 in out nocopy DATE
102: , p4_a34 in out nocopy NUMBER
103: , p4_a35 in out nocopy NUMBER
104: , p4_a36 in out nocopy VARCHAR2
105: , p5_a0 in out nocopy JTF_NUMBER_TABLE
106: , p5_a1 in out nocopy JTF_NUMBER_TABLE
107: , p5_a2 in out nocopy JTF_NUMBER_TABLE
108: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
109: , p5_a4 in out nocopy JTF_NUMBER_TABLE
102: , p4_a34 in out nocopy NUMBER
103: , p4_a35 in out nocopy NUMBER
104: , p4_a36 in out nocopy VARCHAR2
105: , p5_a0 in out nocopy JTF_NUMBER_TABLE
106: , p5_a1 in out nocopy JTF_NUMBER_TABLE
107: , p5_a2 in out nocopy JTF_NUMBER_TABLE
108: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
109: , p5_a4 in out nocopy JTF_NUMBER_TABLE
110: , p5_a5 in out nocopy JTF_NUMBER_TABLE
103: , p4_a35 in out nocopy NUMBER
104: , p4_a36 in out nocopy VARCHAR2
105: , p5_a0 in out nocopy JTF_NUMBER_TABLE
106: , p5_a1 in out nocopy JTF_NUMBER_TABLE
107: , p5_a2 in out nocopy JTF_NUMBER_TABLE
108: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
109: , p5_a4 in out nocopy JTF_NUMBER_TABLE
110: , p5_a5 in out nocopy JTF_NUMBER_TABLE
111: , p5_a6 in out nocopy JTF_VARCHAR2_TABLE_100
105: , p5_a0 in out nocopy JTF_NUMBER_TABLE
106: , p5_a1 in out nocopy JTF_NUMBER_TABLE
107: , p5_a2 in out nocopy JTF_NUMBER_TABLE
108: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
109: , p5_a4 in out nocopy JTF_NUMBER_TABLE
110: , p5_a5 in out nocopy JTF_NUMBER_TABLE
111: , p5_a6 in out nocopy JTF_VARCHAR2_TABLE_100
112: , p5_a7 in out nocopy JTF_DATE_TABLE
113: , p5_a8 in out nocopy JTF_NUMBER_TABLE
106: , p5_a1 in out nocopy JTF_NUMBER_TABLE
107: , p5_a2 in out nocopy JTF_NUMBER_TABLE
108: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
109: , p5_a4 in out nocopy JTF_NUMBER_TABLE
110: , p5_a5 in out nocopy JTF_NUMBER_TABLE
111: , p5_a6 in out nocopy JTF_VARCHAR2_TABLE_100
112: , p5_a7 in out nocopy JTF_DATE_TABLE
113: , p5_a8 in out nocopy JTF_NUMBER_TABLE
114: , p5_a9 in out nocopy JTF_DATE_TABLE
109: , p5_a4 in out nocopy JTF_NUMBER_TABLE
110: , p5_a5 in out nocopy JTF_NUMBER_TABLE
111: , p5_a6 in out nocopy JTF_VARCHAR2_TABLE_100
112: , p5_a7 in out nocopy JTF_DATE_TABLE
113: , p5_a8 in out nocopy JTF_NUMBER_TABLE
114: , p5_a9 in out nocopy JTF_DATE_TABLE
115: , p5_a10 in out nocopy JTF_NUMBER_TABLE
116: , p5_a11 in out nocopy JTF_NUMBER_TABLE
117: , p5_a12 in out nocopy JTF_VARCHAR2_TABLE_100
111: , p5_a6 in out nocopy JTF_VARCHAR2_TABLE_100
112: , p5_a7 in out nocopy JTF_DATE_TABLE
113: , p5_a8 in out nocopy JTF_NUMBER_TABLE
114: , p5_a9 in out nocopy JTF_DATE_TABLE
115: , p5_a10 in out nocopy JTF_NUMBER_TABLE
116: , p5_a11 in out nocopy JTF_NUMBER_TABLE
117: , p5_a12 in out nocopy JTF_VARCHAR2_TABLE_100
118: , p5_a13 in out nocopy JTF_VARCHAR2_TABLE_200
119: , p5_a14 in out nocopy JTF_VARCHAR2_TABLE_200
112: , p5_a7 in out nocopy JTF_DATE_TABLE
113: , p5_a8 in out nocopy JTF_NUMBER_TABLE
114: , p5_a9 in out nocopy JTF_DATE_TABLE
115: , p5_a10 in out nocopy JTF_NUMBER_TABLE
116: , p5_a11 in out nocopy JTF_NUMBER_TABLE
117: , p5_a12 in out nocopy JTF_VARCHAR2_TABLE_100
118: , p5_a13 in out nocopy JTF_VARCHAR2_TABLE_200
119: , p5_a14 in out nocopy JTF_VARCHAR2_TABLE_200
120: , p5_a15 in out nocopy JTF_VARCHAR2_TABLE_200