[Home] [Help]
PACKAGE: APPS.CN_ROLLUP_PVT
Source
1 PACKAGE CN_ROLLUP_PVT AUTHID CURRENT_USER as
2 /* $Header: cnvrolls.pls 120.2 2005/08/02 17:59:45 ymao ship $ */
3
4 TYPE srp_rec_type IS RECORD
5 ( salesrep_id NUMBER(15),
6 start_date DATE,
7 end_date DATE);
8
9 TYPE srp_group_rec_type IS RECORD
10 ( salesrep_id NUMBER(15),
11 group_id NUMBER(15),
12 level NUMBER(15),
13 start_date DATE,
14 end_date DATE);
15
16 TYPE group_rec_type IS RECORD
17 ( group_id NUMBER(15),
18 level NUMBER(15),
19 start_date DATE,
20 end_date DATE);
21
22 TYPE role_rec_type IS RECORD
23 ( role_id NUMBER(15),
24 manager_flag VARCHAR(1),
25 start_date DATE,
26 end_date DATE);
27
28 TYPE group_mem_rec_type IS RECORD
29 ( salesrep_id NUMBER(15),
30 role_id NUMBER(15),
31 manager_flag VARCHAR(1),
32 start_date DATE,
33 end_date DATE
34 );
35
36 TYPE active_group_rec_type IS RECORD
37 ( group_id NUMBER(15),
38 role_id NUMBER(15),
39 manager_flag VARCHAR(1),
40 start_date DATE,
41 end_date DATE);
42
43 TYPE srp_tbl_type IS
44 TABLE OF srp_rec_type
45 INDEX BY BINARY_INTEGER;
46
47 TYPE srp_group_tbl_type IS
48 TABLE OF srp_group_rec_type
49 INDEX BY BINARY_INTEGER;
50
51 TYPE group_tbl_type IS
52 TABLE OF group_rec_type
53 INDEX BY BINARY_INTEGER;
54
55 TYPE role_tbl_type IS
56 TABLE OF role_rec_type
57 INDEX BY BINARY_INTEGER;
58
59 TYPE group_mem_tbl_type IS
60 TABLE OF group_mem_rec_type
61 INDEX BY BINARY_INTEGER;
62
63 TYPE active_group_tbl_type IS
64 TABLE OF active_group_rec_type
65 INDEX BY BINARY_INTEGER;
66
67
68 -- Start of comments
69 -- API name :
70 -- Type : Private.
71 -- Pre-reqs : None
72 -- Usage :
73 --
74 -- Desc :
75 --
76 --
77 --
78 -- Parameters :
79 -- IN : p_api_version NUMBER Required
80 -- p_init_msg_list VARCHAR2 Optional (FND_API.G_FALSE)
81 -- p_commit VARCHAR2 Optional (FND_API.G_FALSE)
82 -- p_validation_level NUMBER Optional (FND_API.G_VALID_LEVEL_FULL)
83 -- OUT : x_return_status VARCHAR2(1)
84 -- x_msg_count NUMBER
85 -- x_msg_data VARCHAR2(2000)
86 -- IN :
87 --
88 --
89 -- OUT :
90 --
91 --
92 -- Version : Current version 1.0
93 -- Initial version 1.0
94 --
95 -- Notes :
96 --
97 -- End of comments
98
99 PROCEDURE get_active_role
100 ( p_api_version IN NUMBER,
101 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
102 p_commit IN VARCHAR2 := FND_API.G_FALSE,
103 p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
104 x_return_status OUT NOCOPY VARCHAR2,
105 x_msg_count OUT NOCOPY NUMBER,
106 x_msg_data OUT NOCOPY VARCHAR2,
107 p_org_id IN NUMBER,
108 p_srp IN srp_group_rec_type,
109 x_role OUT NOCOPY role_tbl_type);
110
111 PROCEDURE get_active_group_member
112 ( p_api_version IN NUMBER,
113 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
114 p_commit IN VARCHAR2 := FND_API.G_FALSE,
115 p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
116 x_return_status OUT NOCOPY VARCHAR2,
117 x_msg_count OUT NOCOPY NUMBER,
118 x_msg_data OUT NOCOPY VARCHAR2,
119 p_org_id IN NUMBER,
120 p_group IN group_rec_type,
121 x_group_mem OUT NOCOPY group_mem_tbl_type);
122
123 PROCEDURE get_active_group_member
124 ( p_api_version IN NUMBER,
125 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
126 p_commit IN VARCHAR2 := FND_API.G_FALSE,
127 p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
128 x_return_status OUT NOCOPY VARCHAR2,
129 x_msg_count OUT NOCOPY NUMBER,
130 x_msg_data OUT NOCOPY VARCHAR2,
131 p_org_id IN NUMBER,
132 p_group IN group_tbl_type,
133 x_group_mem OUT NOCOPY srp_group_tbl_type);
134
135 PROCEDURE get_active_group
136 ( p_api_version IN NUMBER,
137 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
138 p_commit IN VARCHAR2 := FND_API.G_FALSE,
139 p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
140 x_return_status OUT NOCOPY VARCHAR2,
141 x_msg_count OUT NOCOPY NUMBER,
142 x_msg_data OUT NOCOPY VARCHAR2,
143 p_org_id IN NUMBER,
144 p_srp IN srp_rec_type,
145 x_active_group OUT NOCOPY active_group_tbl_type);
146
147 PROCEDURE get_ancestor_group
148 ( p_api_version IN NUMBER,
149 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
150 p_commit IN VARCHAR2 := FND_API.G_FALSE,
151 p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
152 x_return_status OUT NOCOPY VARCHAR2,
153 x_msg_count OUT NOCOPY NUMBER,
154 x_msg_data OUT NOCOPY VARCHAR2,
155 p_group IN group_rec_type,
156 x_group OUT NOCOPY group_tbl_type);
157
158 PROCEDURE get_descendant_group
159 ( p_api_version IN NUMBER,
160 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
161 p_commit IN VARCHAR2 := FND_API.G_FALSE,
162 p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
163 x_return_status OUT NOCOPY VARCHAR2,
164 x_msg_count OUT NOCOPY NUMBER,
165 x_msg_data OUT NOCOPY VARCHAR2,
166 p_group IN group_rec_type,
167 x_group OUT NOCOPY group_tbl_type);
168
169 PROCEDURE get_ancestor_salesrep
170 ( p_api_version IN NUMBER,
171 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
172 p_commit IN VARCHAR2 := FND_API.G_FALSE,
173 p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
174 x_return_status OUT NOCOPY VARCHAR2,
175 x_msg_count OUT NOCOPY NUMBER,
176 x_msg_data OUT NOCOPY VARCHAR2,
177 p_org_id IN NUMBER,
178 p_srp IN srp_group_rec_type,
179 x_srp OUT NOCOPY srp_group_tbl_type);
180
181 PROCEDURE get_descendant_salesrep
182 ( p_api_version IN NUMBER,
183 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
184 p_commit IN VARCHAR2 := FND_API.G_FALSE,
185 p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
186 x_return_status OUT NOCOPY VARCHAR2,
187 x_msg_count OUT NOCOPY NUMBER,
188 x_msg_data OUT NOCOPY VARCHAR2,
189 p_org_id IN NUMBER,
190 p_srp IN srp_group_rec_type,
191 x_srp OUT NOCOPY srp_group_tbl_type);
192
193 PROCEDURE get_descendant_salesrep
194 ( p_api_version IN NUMBER,
195 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
196 p_commit IN VARCHAR2 := FND_API.G_FALSE,
197 p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
198 x_return_status OUT NOCOPY VARCHAR2,
199 x_msg_count OUT NOCOPY NUMBER,
200 x_msg_data OUT NOCOPY VARCHAR2,
201 p_org_id IN NUMBER,
202 p_srp IN srp_rec_type,
203 x_srp OUT NOCOPY srp_tbl_type);
204
205 END cn_rollup_pvt;