1 PACKAGE cn_quota_rule_pvt AS
2 /*$Header: cnvqtrls.pls 120.1 2005/07/11 20:01:06 appldev ship $*/
3
4 -- quota rule
5 TYPE quota_rule_rec_type IS RECORD (
6 org_id NUMBER := NULL,
7 quota_rule_id NUMBER := NULL,
8 plan_element_name cn_quotas.NAME%TYPE := NULL,
9 revenue_class_name cn_revenue_classes.NAME%TYPE := NULL,
10 revenue_class_id NUMBER := NULL,
11 quota_id NUMBER := NULL,
12 description cn_quota_rules.description%TYPE := NULL,
13 target cn_quota_rules.target%TYPE := NULL,
14 payment_amount cn_quota_rules.payment_amount%TYPE := NULL,
15 performance_goal cn_quota_rules.performance_goal%TYPE := NULL,
16 object_version_number cn_quota_rules.object_version_number%TYPE := NULL
17 );
18
19 TYPE quota_rule_tbl_type IS TABLE OF quota_rule_rec_type
20 INDEX BY BINARY_INTEGER;
21
22 -- Global variable that represent missing values.
23 g_quota_rule_rec quota_rule_rec_type;
24 g_quota_rule_rec_tb quota_rule_tbl_type;
25
26 -- Start of comments
27 -- API name : validate_quota_rule
28 -- Type : Private.
29 -- Function :
30 -- Pre-reqs : None.
31 -- Parameters :
32 -- IN : p_api_version IN NUMBER Required
33 -- p_init_msg_list IN VARCHAR2 Optional
34 -- Default = FND_API.G_FALSE
35 -- p_commit IN VARCHAR2 Optional
36 -- Default = FND_API.G_FALSE
37 -- p_validation_level IN NUMBER Optional
38 -- Default = FND_API.G_VALID_LEVEL_FULL
39 -- p_quota_rule IN quota_rule_rec_type
40 -- OUT : x_return_status OUT VARCHAR2(1)
41 -- x_msg_count OUT NUMBER
42 -- x_msg_data OUT VARCHAR2(2000)
43 -- Version : Current version 1.0
44 -- Notes : Note text
45 --
46 -- End of comments
47 PROCEDURE validate_quota_rule (
48 p_api_version IN NUMBER,
49 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
50 p_commit IN VARCHAR2 := fnd_api.g_false,
51 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
52 p_action IN VARCHAR2,
53 p_quota_rule IN OUT NOCOPY quota_rule_rec_type,
54 p_old_quota_rule IN quota_rule_rec_type := g_quota_rule_rec,
55 x_return_status OUT NOCOPY VARCHAR2,
56 x_msg_count OUT NOCOPY NUMBER,
57 x_msg_data OUT NOCOPY VARCHAR2
58 );
59
60 -- Start of comments
61 -- API name : Create_Quota_Rule
62 -- Type : Private.
63 -- Function :
64 -- Pre-reqs : None.
65 -- Parameters :
66 -- IN : p_api_version IN NUMBER Required
67 -- p_init_msg_list IN VARCHAR2 Optional
68 -- Default = FND_API.G_FALSE
69 -- p_commit IN VARCHAR2 Optional
70 -- Default = FND_API.G_FALSE
71 -- p_validation_level IN NUMBER Optional
72 -- Default = FND_API.G_VALID_LEVEL_FULL
73 -- p_quota_rule IN quota_rule_rec_type
74 -- OUT : x_return_status OUT VARCHAR2(1)
75 -- x_msg_count OUT NUMBER
76 -- x_msg_data OUT VARCHAR2(2000)
77 -- x_quota_rule_id OUT NUMBER
78 -- Version : Current version 1.0
79 -- Notes : Note text
80 --
81 -- End of comments
82 PROCEDURE create_quota_rule (
83 p_api_version IN NUMBER,
84 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
85 p_commit IN VARCHAR2 := fnd_api.g_false,
86 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
87 p_quota_rule IN OUT NOCOPY quota_rule_rec_type,
88 x_return_status OUT NOCOPY VARCHAR2,
89 x_msg_count OUT NOCOPY NUMBER,
90 x_msg_data OUT NOCOPY VARCHAR2
91 );
92
93 -- Start of comments
94 -- API name : Create_Quota_Rules
95 -- Type : Private.
96 -- Function :
97 -- Pre-reqs : None.
98 -- Parameters :
99 -- IN : p_api_version IN NUMBER Required
100 -- p_init_msg_list IN VARCHAR2 Optional
101 -- Default = FND_API.G_FALSE
102 -- p_commit IN VARCHAR2 Optional
103 -- Default = FND_API.G_FALSE
104 -- p_validation_level IN NUMBER Optional
105 -- Default = FND_API.G_VALID_LEVEL_FULL
106 -- p_revenue_class_rec_tbl IN quota_rule_rec_type
107 -- OUT : x_return_status OUT VARCHAR2(1)
108 -- x_msg_count OUT NUMBER
109 -- x_msg_data OUT VARCHAR2(2000)
110 -- x_quota_rule_id OUT NUMBER
111 -- Version : Current version 1.0
112 -- Notes : Note text
113 --
114 -- End of comments
115
116 PROCEDURE create_quota_rules (
117 p_api_version IN NUMBER,
118 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
119 p_commit IN VARCHAR2 := fnd_api.g_false,
120 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
121 p_quota_name IN VARCHAR2,
122 p_revenue_class_rec_tbl IN cn_plan_element_pub.revenue_class_rec_tbl_type := cn_plan_element_pub.g_miss_revenue_class_rec_tbl,
123 p_rev_uplift_rec_tbl IN cn_plan_element_pub.rev_uplift_rec_tbl_type := cn_plan_element_pub.g_miss_rev_uplift_rec_tbl,
124 p_trx_factor_rec_tbl IN cn_plan_element_pub.trx_factor_rec_tbl_type := cn_plan_element_pub.g_miss_trx_factor_rec_tbl,
125 x_loading_status OUT NOCOPY VARCHAR2,
126 x_return_status OUT NOCOPY VARCHAR2,
127 x_msg_count OUT NOCOPY NUMBER,
128 x_msg_data OUT NOCOPY VARCHAR2
129 ) ;
130
131 -- Start of comments
132 -- API name : Update_Quota_Rule
133 -- Type : Private.
134 -- Function :
135 -- Pre-reqs : None.
136 -- Parameters :
137 -- IN : p_api_version IN NUMBER Required
138 -- p_init_msg_list IN VARCHAR2 Optional
139 -- Default = FND_API.G_FALSE
140 -- p_commit IN VARCHAR2 Optional
141 -- Default = FND_API.G_FALSE
142 -- p_validation_level IN NUMBER Optional
143 -- Default = FND_API.G_VALID_LEVEL_FULL
144 -- p_quota_rule IN quota_rule_rec_type
145 -- OUT : x_return_status OUT VARCHAR2(1)
146 -- x_msg_count OUT NUMBER
147 -- x_msg_data OUT VARCHAR2(2000)
148 -- Version : Current version 1.0
149 -- Notes : Note text
150 --
151 -- End of comments
152 PROCEDURE update_quota_rule (
153 p_api_version IN NUMBER,
154 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
155 p_commit IN VARCHAR2 := fnd_api.g_false,
156 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
157 p_quota_rule IN OUT NOCOPY quota_rule_rec_type,
158 x_return_status OUT NOCOPY VARCHAR2,
159 x_msg_count OUT NOCOPY NUMBER,
160 x_msg_data OUT NOCOPY VARCHAR2
161 );
162
163 -- Start of comments
164 -- API name : Update_Quota_Rules
165 -- Type : Private.
166 -- Function :
167 -- Pre-reqs : None.
168 -- Parameters :
169 -- IN : p_api_version IN NUMBER Required
170 -- p_init_msg_list IN VARCHAR2 Optional
171 -- Default = FND_API.G_FALSE
172 -- p_commit IN VARCHAR2 Optional
173 -- Default = FND_API.G_FALSE
174 -- p_validation_level IN NUMBER Optional
175 -- Default = FND_API.G_VALID_LEVEL_FULL
176 -- p_quota_rule IN quota_rule_rec_type
177 -- OUT : x_return_status OUT VARCHAR2(1)
178 -- x_msg_count OUT NUMBER
179 -- x_msg_data OUT VARCHAR2(2000)
180 -- Version : Current version 1.0
181 -- Notes : Note text
182 --
183 -- End of comments
184 PROCEDURE update_quota_rules (
185 p_api_version IN NUMBER,
186 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
187 p_commit IN VARCHAR2 := fnd_api.g_false,
188 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
189 p_quota_name IN VARCHAR2,
190 p_revenue_class_rec_tbl IN cn_plan_element_pub.revenue_class_rec_tbl_type := cn_plan_element_pub.g_miss_revenue_class_rec_tbl,
191 p_trx_factor_rec_tbl IN cn_plan_element_pub.trx_factor_rec_tbl_type := cn_plan_element_pub.g_miss_trx_factor_rec_tbl,
192 x_loading_status OUT NOCOPY VARCHAR2,
193 x_return_status OUT NOCOPY VARCHAR2,
194 x_msg_count OUT NOCOPY NUMBER,
195 x_msg_data OUT NOCOPY VARCHAR2
196 );
197
198 -- Start of comments
199 -- API name : Delete_Quota_Rule
200 -- Type : Private.
201 -- Function :
202 -- Pre-reqs : None.
203 -- Parameters :
204 -- IN : p_api_version IN NUMBER Required
205 -- p_init_msg_list IN VARCHAR2 Optional
206 -- Default = FND_API.G_FALSE
207 -- p_commit IN VARCHAR2 Optional
208 -- Default = FND_API.G_FALSE
209 -- p_validation_level IN NUMBER Optional
210 -- Default = FND_API.G_VALID_LEVEL_FULL
211 -- p_quota_rule IN quota_rule_rec_type
212 -- OUT : x_return_status OUT VARCHAR2(1)
213 -- x_msg_count OUT NUMBER
214 -- x_msg_data OUT VARCHAR2(2000)
215 -- Version : Current version 1.0
216 -- Notes : Note text
217 --
218 -- End of comments
219 PROCEDURE delete_quota_rule (
220 p_api_version IN NUMBER,
221 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
222 p_commit IN VARCHAR2 := fnd_api.g_false,
223 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
224 p_quota_rule IN OUT NOCOPY quota_rule_rec_type,
225 x_return_status OUT NOCOPY VARCHAR2,
226 x_msg_count OUT NOCOPY NUMBER,
227 x_msg_data OUT NOCOPY VARCHAR2
228 );
229
230 -- Start of comments
231 -- API name : Delete_Quota_Rules
232 -- Type : Private.
233 -- Function :
234 -- Pre-reqs : None.
235 -- Parameters :
236 -- IN : p_api_version IN NUMBER Required
237 -- p_init_msg_list IN VARCHAR2 Optional
238 -- Default = FND_API.G_FALSE
239 -- p_commit IN VARCHAR2 Optional
240 -- Default = FND_API.G_FALSE
241 -- p_validation_level IN NUMBER Optional
242 -- Default = FND_API.G_VALID_LEVEL_FULL
243 -- p_revenue_class_rec_tbl IN cn_plan_element_pub.revenue_class_rec_tbl_type
244 -- OUT : x_return_status OUT VARCHAR2(1)
245 -- x_msg_count OUT NUMBER
246 -- x_msg_data OUT VARCHAR2(2000)
247 -- Version : Current version 1.0
248 -- Notes : Note text
249 --
250 -- End of comments
251 PROCEDURE delete_quota_rules (
252 p_api_version IN NUMBER,
253 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
254 p_commit IN VARCHAR2 := fnd_api.g_false,
255 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
256 p_quota_name IN VARCHAR2,
257 p_revenue_class_rec_tbl IN cn_plan_element_pub.revenue_class_rec_tbl_type,
258 x_return_status OUT NOCOPY VARCHAR2,
259 x_msg_count OUT NOCOPY NUMBER,
260 x_msg_data OUT NOCOPY VARCHAR2,
261 x_loading_status OUT NOCOPY VARCHAR2
262 ) ;
263
264 END cn_quota_rule_pvt;