1: package cn_sfp_group_util_pvt_w AUTHID CURRENT_USER as
2: /* $Header: cnwsfgrs.pls 115.0 2003/08/19 20:47:36 sbadami noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy cn_sfp_group_util_pvt.srprole_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: );
7: procedure rosetta_table_copy_out_p1(t cn_sfp_group_util_pvt.srprole_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
8: , a1 out nocopy JTF_NUMBER_TABLE
9: , a2 out nocopy JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: );
7: procedure rosetta_table_copy_out_p1(t cn_sfp_group_util_pvt.srprole_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
8: , a1 out nocopy JTF_NUMBER_TABLE
9: , a2 out nocopy JTF_VARCHAR2_TABLE_100
10: );
11:
12: procedure rosetta_table_copy_in_p3(t out nocopy cn_sfp_group_util_pvt.grporg_tbl_type, a0 JTF_VARCHAR2_TABLE_100
13: , a1 JTF_VARCHAR2_TABLE_100
8: , a1 out nocopy JTF_NUMBER_TABLE
9: , a2 out nocopy JTF_VARCHAR2_TABLE_100
10: );
11:
12: procedure rosetta_table_copy_in_p3(t out nocopy cn_sfp_group_util_pvt.grporg_tbl_type, a0 JTF_VARCHAR2_TABLE_100
13: , a1 JTF_VARCHAR2_TABLE_100
14: );
15: procedure rosetta_table_copy_out_p3(t cn_sfp_group_util_pvt.grporg_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
16: , a1 out nocopy JTF_VARCHAR2_TABLE_100
9: , a2 out nocopy JTF_VARCHAR2_TABLE_100
10: );
11:
12: procedure rosetta_table_copy_in_p3(t out nocopy cn_sfp_group_util_pvt.grporg_tbl_type, a0 JTF_VARCHAR2_TABLE_100
13: , a1 JTF_VARCHAR2_TABLE_100
14: );
15: procedure rosetta_table_copy_out_p3(t cn_sfp_group_util_pvt.grporg_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
16: , a1 out nocopy JTF_VARCHAR2_TABLE_100
17: );
11:
12: procedure rosetta_table_copy_in_p3(t out nocopy cn_sfp_group_util_pvt.grporg_tbl_type, a0 JTF_VARCHAR2_TABLE_100
13: , a1 JTF_VARCHAR2_TABLE_100
14: );
15: procedure rosetta_table_copy_out_p3(t cn_sfp_group_util_pvt.grporg_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
16: , a1 out nocopy JTF_VARCHAR2_TABLE_100
17: );
18:
19: procedure rosetta_table_copy_in_p4(t out nocopy cn_sfp_group_util_pvt.grpnum_tbl_type, a0 JTF_NUMBER_TABLE);
12: procedure rosetta_table_copy_in_p3(t out nocopy cn_sfp_group_util_pvt.grporg_tbl_type, a0 JTF_VARCHAR2_TABLE_100
13: , a1 JTF_VARCHAR2_TABLE_100
14: );
15: procedure rosetta_table_copy_out_p3(t cn_sfp_group_util_pvt.grporg_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
16: , a1 out nocopy JTF_VARCHAR2_TABLE_100
17: );
18:
19: procedure rosetta_table_copy_in_p4(t out nocopy cn_sfp_group_util_pvt.grpnum_tbl_type, a0 JTF_NUMBER_TABLE);
20: procedure rosetta_table_copy_out_p4(t cn_sfp_group_util_pvt.grpnum_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);
38: , p_status VARCHAR2
39: , p_effective_date date
40: , p7_a0 out nocopy JTF_NUMBER_TABLE
41: , p7_a1 out nocopy JTF_NUMBER_TABLE
42: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
43: , x_return_status out nocopy VARCHAR2
44: , x_msg_count out nocopy NUMBER
45: , x_msg_data out nocopy VARCHAR2
46: );
49: , p_commit VARCHAR2
50: , p_validation_level NUMBER
51: , p_comp_group_id NUMBER
52: , p_effective_date date
53: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
54: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
55: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100
56: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
57: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100
50: , p_validation_level NUMBER
51: , p_comp_group_id NUMBER
52: , p_effective_date date
53: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
54: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
55: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100
56: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
57: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100
58: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
51: , p_comp_group_id NUMBER
52: , p_effective_date date
53: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
54: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
55: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100
56: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
57: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100
58: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
59: , p9_a0 out nocopy JTF_VARCHAR2_TABLE_100
52: , p_effective_date date
53: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
54: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
55: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100
56: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
57: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100
58: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
59: , p9_a0 out nocopy JTF_VARCHAR2_TABLE_100
60: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
53: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
54: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
55: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100
56: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
57: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100
58: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
59: , p9_a0 out nocopy JTF_VARCHAR2_TABLE_100
60: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
61: , x_return_status out nocopy VARCHAR2
54: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
55: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100
56: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
57: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100
58: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
59: , p9_a0 out nocopy JTF_VARCHAR2_TABLE_100
60: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
61: , x_return_status out nocopy VARCHAR2
62: , x_msg_count out nocopy NUMBER
55: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100
56: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
57: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100
58: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
59: , p9_a0 out nocopy JTF_VARCHAR2_TABLE_100
60: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
61: , x_return_status out nocopy VARCHAR2
62: , x_msg_count out nocopy NUMBER
63: , x_msg_data out nocopy VARCHAR2
56: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
57: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100
58: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
59: , p9_a0 out nocopy JTF_VARCHAR2_TABLE_100
60: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
61: , x_return_status out nocopy VARCHAR2
62: , x_msg_count out nocopy NUMBER
63: , x_msg_data out nocopy VARCHAR2
64: );