[Home] [Help]
PACKAGE: APPS.CN_SFP_GROUP_UTIL_PVT_W
Source
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
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 );
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);
21
22 procedure get_descendant_groups(p_api_version NUMBER
23 , p_init_msg_list VARCHAR2
24 , p_commit VARCHAR2
25 , p_validation_level NUMBER
26 , p_selected_groups JTF_NUMBER_TABLE
27 , p_effective_date date
28 , x_descendant_groups out nocopy JTF_NUMBER_TABLE
29 , x_return_status out nocopy VARCHAR2
30 , x_msg_count out nocopy NUMBER
31 , x_msg_data out nocopy VARCHAR2
32 );
33 procedure get_salesrep_roles(p_api_version NUMBER
34 , p_init_msg_list VARCHAR2
35 , p_commit VARCHAR2
36 , p_validation_level NUMBER
37 , p_selected_groups 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 );
47 procedure get_grp_organization_access(p_api_version NUMBER
48 , p_init_msg_list VARCHAR2
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
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 );
65 end cn_sfp_group_util_pvt_w;