PACKAGE: APPS.CN_SALES_HIER_PUB_W

Source

1 package cn_sales_hier_pub_w AUTHID CURRENT_USER as
2   /* $Header: cnwhiers.pls 115.6 2002/11/25 23:56:59 fting ship $ */
3   procedure rosetta_table_copy_in_p1(t out nocopy cn_sales_hier_pub.hier_tbl_type, a0 JTF_VARCHAR2_TABLE_300
4     , a1 JTF_VARCHAR2_TABLE_100
5     , a2 JTF_VARCHAR2_TABLE_100
6     , a3 JTF_DATE_TABLE
7     , a4 JTF_DATE_TABLE
8     );
9   procedure rosetta_table_copy_out_p1(t cn_sales_hier_pub.hier_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_300
10     , a1 out nocopy JTF_VARCHAR2_TABLE_100
11     , a2 out nocopy JTF_VARCHAR2_TABLE_100
12     , a3 out nocopy JTF_DATE_TABLE
13     , a4 out nocopy JTF_DATE_TABLE
14     );
15 
16   procedure rosetta_table_copy_in_p3(t out nocopy cn_sales_hier_pub.grp_tbl_type, a0 JTF_VARCHAR2_TABLE_100
17     , a1 JTF_NUMBER_TABLE
18     , a2 JTF_VARCHAR2_TABLE_300
19     , a3 JTF_VARCHAR2_TABLE_100
20     );
21   procedure rosetta_table_copy_out_p3(t cn_sales_hier_pub.grp_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
22     , a1 out nocopy JTF_NUMBER_TABLE
23     , a2 out nocopy JTF_VARCHAR2_TABLE_300
24     , a3 out nocopy JTF_VARCHAR2_TABLE_100
25     );
26 
27   procedure get_sales_hier(p_api_version  NUMBER
28     , p_init_msg_list  VARCHAR2
29     , p_validation_level  VARCHAR2
30     , x_return_status out nocopy  VARCHAR2
31     , x_msg_count out nocopy  NUMBER
32     , x_msg_data out nocopy  VARCHAR2
33     , x_loading_status out nocopy  VARCHAR2
34     , p_salesrep_id  NUMBER
35     , p_comp_group_id  NUMBER
36     , p_date  date
37     , p_start_record  NUMBER
38     , p_increment_count  NUMBER
39     , p_start_record_grp  NUMBER
40     , p_increment_count_grp  NUMBER
41     , p14_a0 out nocopy JTF_VARCHAR2_TABLE_300
42     , p14_a1 out nocopy JTF_VARCHAR2_TABLE_100
43     , p14_a2 out nocopy JTF_VARCHAR2_TABLE_100
44     , p14_a3 out nocopy JTF_DATE_TABLE
45     , p14_a4 out nocopy JTF_DATE_TABLE
46     , x_mgr_count out nocopy  NUMBER
47     , p16_a0 out nocopy JTF_VARCHAR2_TABLE_300
48     , p16_a1 out nocopy JTF_VARCHAR2_TABLE_100
49     , p16_a2 out nocopy JTF_VARCHAR2_TABLE_100
50     , p16_a3 out nocopy JTF_DATE_TABLE
51     , p16_a4 out nocopy JTF_DATE_TABLE
52     , x_srp_count out nocopy  NUMBER
53     , p18_a0 out nocopy JTF_VARCHAR2_TABLE_100
54     , p18_a1 out nocopy JTF_NUMBER_TABLE
55     , p18_a2 out nocopy JTF_VARCHAR2_TABLE_300
56     , p18_a3 out nocopy JTF_VARCHAR2_TABLE_100
57     , x_grp_count out nocopy  NUMBER
58   );
59 end cn_sales_hier_pub_w;