1: package pv_pg_memberships_pvt_w as
2: /* $Header: pvxwmems.pls 120.1 2005/10/24 09:37 dgottlie noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy pv_pg_memberships_pvt.memb_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE
1: package pv_pg_memberships_pvt_w as
2: /* $Header: pvxwmems.pls 120.1 2005/10/24 09:37 dgottlie noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy pv_pg_memberships_pvt.memb_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_DATE_TABLE
1: package pv_pg_memberships_pvt_w as
2: /* $Header: pvxwmems.pls 120.1 2005/10/24 09:37 dgottlie noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy pv_pg_memberships_pvt.memb_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_DATE_TABLE
2: /* $Header: pvxwmems.pls 120.1 2005/10/24 09:37 dgottlie noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy pv_pg_memberships_pvt.memb_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_DATE_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_DATE_TABLE
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_DATE_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_DATE_TABLE
17: , a14 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_DATE_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_DATE_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_VARCHAR2_TABLE_300
19: , a16 JTF_VARCHAR2_TABLE_300
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_DATE_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_DATE_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_VARCHAR2_TABLE_300
19: , a16 JTF_VARCHAR2_TABLE_300
20: , a17 JTF_VARCHAR2_TABLE_300
21: , a18 JTF_VARCHAR2_TABLE_300
30: , a27 JTF_VARCHAR2_TABLE_300
31: , a28 JTF_VARCHAR2_TABLE_300
32: , a29 JTF_VARCHAR2_TABLE_300
33: );
34: procedure rosetta_table_copy_out_p2(t pv_pg_memberships_pvt.memb_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
35: , a1 out nocopy JTF_NUMBER_TABLE
36: , a2 out nocopy JTF_NUMBER_TABLE
37: , a3 out nocopy JTF_NUMBER_TABLE
38: , a4 out nocopy JTF_DATE_TABLE
31: , a28 JTF_VARCHAR2_TABLE_300
32: , a29 JTF_VARCHAR2_TABLE_300
33: );
34: procedure rosetta_table_copy_out_p2(t pv_pg_memberships_pvt.memb_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
35: , a1 out nocopy JTF_NUMBER_TABLE
36: , a2 out nocopy JTF_NUMBER_TABLE
37: , a3 out nocopy JTF_NUMBER_TABLE
38: , a4 out nocopy JTF_DATE_TABLE
39: , a5 out nocopy JTF_DATE_TABLE
32: , a29 JTF_VARCHAR2_TABLE_300
33: );
34: procedure rosetta_table_copy_out_p2(t pv_pg_memberships_pvt.memb_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
35: , a1 out nocopy JTF_NUMBER_TABLE
36: , a2 out nocopy JTF_NUMBER_TABLE
37: , a3 out nocopy JTF_NUMBER_TABLE
38: , a4 out nocopy JTF_DATE_TABLE
39: , a5 out nocopy JTF_DATE_TABLE
40: , a6 out nocopy JTF_DATE_TABLE
33: );
34: procedure rosetta_table_copy_out_p2(t pv_pg_memberships_pvt.memb_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
35: , a1 out nocopy JTF_NUMBER_TABLE
36: , a2 out nocopy JTF_NUMBER_TABLE
37: , a3 out nocopy JTF_NUMBER_TABLE
38: , a4 out nocopy JTF_DATE_TABLE
39: , a5 out nocopy JTF_DATE_TABLE
40: , a6 out nocopy JTF_DATE_TABLE
41: , a7 out nocopy JTF_VARCHAR2_TABLE_100
39: , a5 out nocopy JTF_DATE_TABLE
40: , a6 out nocopy JTF_DATE_TABLE
41: , a7 out nocopy JTF_VARCHAR2_TABLE_100
42: , a8 out nocopy JTF_VARCHAR2_TABLE_100
43: , a9 out nocopy JTF_NUMBER_TABLE
44: , a10 out nocopy JTF_NUMBER_TABLE
45: , a11 out nocopy JTF_DATE_TABLE
46: , a12 out nocopy JTF_NUMBER_TABLE
47: , a13 out nocopy JTF_DATE_TABLE
40: , a6 out nocopy JTF_DATE_TABLE
41: , a7 out nocopy JTF_VARCHAR2_TABLE_100
42: , a8 out nocopy JTF_VARCHAR2_TABLE_100
43: , a9 out nocopy JTF_NUMBER_TABLE
44: , a10 out nocopy JTF_NUMBER_TABLE
45: , a11 out nocopy JTF_DATE_TABLE
46: , a12 out nocopy JTF_NUMBER_TABLE
47: , a13 out nocopy JTF_DATE_TABLE
48: , a14 out nocopy JTF_NUMBER_TABLE
42: , a8 out nocopy JTF_VARCHAR2_TABLE_100
43: , a9 out nocopy JTF_NUMBER_TABLE
44: , a10 out nocopy JTF_NUMBER_TABLE
45: , a11 out nocopy JTF_DATE_TABLE
46: , a12 out nocopy JTF_NUMBER_TABLE
47: , a13 out nocopy JTF_DATE_TABLE
48: , a14 out nocopy JTF_NUMBER_TABLE
49: , a15 out nocopy JTF_VARCHAR2_TABLE_300
50: , a16 out nocopy JTF_VARCHAR2_TABLE_300
44: , a10 out nocopy JTF_NUMBER_TABLE
45: , a11 out nocopy JTF_DATE_TABLE
46: , a12 out nocopy JTF_NUMBER_TABLE
47: , a13 out nocopy JTF_DATE_TABLE
48: , a14 out nocopy JTF_NUMBER_TABLE
49: , a15 out nocopy JTF_VARCHAR2_TABLE_300
50: , a16 out nocopy JTF_VARCHAR2_TABLE_300
51: , a17 out nocopy JTF_VARCHAR2_TABLE_300
52: , a18 out nocopy JTF_VARCHAR2_TABLE_300
62: , a28 out nocopy JTF_VARCHAR2_TABLE_300
63: , a29 out nocopy JTF_VARCHAR2_TABLE_300
64: );
65:
66: procedure rosetta_table_copy_in_p4(t out nocopy pv_pg_memberships_pvt.number_table, a0 JTF_NUMBER_TABLE);
67: procedure rosetta_table_copy_out_p4(t pv_pg_memberships_pvt.number_table, a0 out nocopy JTF_NUMBER_TABLE);
68:
69: procedure create_pg_memberships(p_api_version_number NUMBER
70: , p_init_msg_list VARCHAR2
63: , a29 out nocopy JTF_VARCHAR2_TABLE_300
64: );
65:
66: procedure rosetta_table_copy_in_p4(t out nocopy pv_pg_memberships_pvt.number_table, a0 JTF_NUMBER_TABLE);
67: procedure rosetta_table_copy_out_p4(t pv_pg_memberships_pvt.number_table, a0 out nocopy JTF_NUMBER_TABLE);
68:
69: procedure create_pg_memberships(p_api_version_number NUMBER
70: , p_init_msg_list VARCHAR2
71: , p_commit VARCHAR2