DBA Data[Home] [Help]

APPS.CN_SFP_GROUP_UTIL_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p1(t out nocopy cn_sfp_group_util_pvt.srprole_tbl_type, a0 JTF_NUMBER_TABLE

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

Line 4: , a1 JTF_NUMBER_TABLE

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

Line 7: procedure rosetta_table_copy_out_p1(t cn_sfp_group_util_pvt.srprole_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

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:

Line 8: , a1 out nocopy 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

Line 19: procedure rosetta_table_copy_in_p4(t out nocopy cn_sfp_group_util_pvt.grpnum_tbl_type, a0 JTF_NUMBER_TABLE);

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

Line 20: procedure rosetta_table_copy_out_p4(t cn_sfp_group_util_pvt.grpnum_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);

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

Line 26: , p_selected_groups JTF_NUMBER_TABLE

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

Line 28: , x_descendant_groups out nocopy JTF_NUMBER_TABLE

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: );

Line 37: , p_selected_groups JTF_NUMBER_TABLE

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

Line 40: , p7_a0 out nocopy JTF_NUMBER_TABLE

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

Line 41: , p7_a1 out nocopy JTF_NUMBER_TABLE

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