1 PACKAGE cn_sales_hier_pub AUTHID CURRENT_USER AS
2 -- $Header: cnphiers.pls 115.4 2002/11/21 21:04:03 hlchen ship $
3
4 TYPE hier_type IS RECORD
5 (
6 name VARCHAR2(240),
7 number VARCHAR2(30),
8 role VARCHAR2(30),
9 start_date DATE,
10 end_date DATE
11 );
12
13 TYPE hier_tbl_type IS TABLE OF hier_type
14 INDEX BY BINARY_INTEGER;
15
16
17 TYPE grp_type IS RECORD
18 (
19 grp_name VARCHAR2(30),
20 grp_id NUMBER,
21 mgr_name VARCHAR2(240),
22 mgr_number VARCHAR2(30)
23 );
24
25 TYPE grp_tbl_type IS TABLE OF grp_type
26 INDEX BY BINARY_INTEGER;
27
28
29 -- API name : Get_sales_hier
30 -- Type : Public.
31 -- Pre-reqs :
32 -- Usage :
33 --+
34 -- Desc : Get the transaction details
35 --
36 --
37 --+
38 -- Parameters :
39 -- IN : p_salesrep_id Salesrep Id : NUMBER
40 -- IN : p_comp_group_id The compensation group id : NUMBER
41 -- IN : p_date The effective date : DATE,
42 -- IN : p_start_record For page scrolling, the first record : NUMBER
43 -- IN : p_increment_count The number of records per page : NUMBER
44
45 -- OUT : x_sales_hier_tbl The output table : sales_hier_tbl_type
46 -- OUT : x_sales_hier_count Total records in the query : NUMBER
47 -- +
48 -- +
49 -- +
50 --
51 --+
52 -- Version : Current version 1.0
53 -- Initial version 1.0
54 --+
55 -- Notes :
56 --+
57 -- End of comments
58
59 PROCEDURE get_sales_hier
60 (
61 p_api_version IN NUMBER,
62 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
63 p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
64
65 x_return_status OUT NOCOPY VARCHAR2,
66 x_msg_count OUT NOCOPY NUMBER,
67 x_msg_data OUT NOCOPY VARCHAR2,
68 x_loading_status OUT NOCOPY VARCHAR2,
69
70 p_salesrep_id IN NUMBER ,
71 p_comp_group_id IN NUMBER,
72 p_date IN DATE,
73 p_start_record IN NUMBER := 1,
74 p_increment_count IN NUMBER,
75 p_start_record_grp IN NUMBER := 1,
76 p_increment_count_grp IN NUMBER,
77
78 x_mgr_tbl OUT NOCOPY hier_tbl_type,
79 x_mgr_count OUT NOCOPY NUMBER,
80 x_srp_tbl OUT NOCOPY hier_tbl_type,
81 x_srp_count OUT NOCOPY NUMBER,
82 x_grp_tbl OUT NOCOPY grp_tbl_type,
83 x_grp_count OUT NOCOPY NUMBER
84
85 );
86
87 END cn_sales_hier_pub ;
88