[Home] [Help]
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;