[Home] [Help]
PACKAGE: APPS.CN_SRP_PERIODS_PVT
Source
1 PACKAGE CN_SRP_PERIODS_PVT AS
2 /* $Header: cnvsprds.pls 120.2 2005/08/02 11:09:41 mblum noship $ */
3
4 -- Global variable for the translatable name for all Plan Assign objects.
5 TYPE pay_period_rec_type IS RECORD
6 (period_id cn_period_statuses.period_id%TYPE,
7 org_id cn_period_statuses.org_id%TYPE,
8 start_date cn_period_statuses.start_date%TYPE,
9 end_date cn_period_statuses.end_date%TYPE);
10
11 TYPE pay_period_rec_tbl_type IS TABLE OF pay_period_rec_type
12 INDEX BY BINARY_INTEGER ;
13
14 TYPE delta_srp_period_rec_type IS RECORD
15 (srp_period_id cn_srp_periods.srp_period_id%TYPE,
16 salesrep_id cn_srp_periods.salesrep_id%TYPE := NULL ,
17 org_id cn_srp_periods.org_id%TYPE := NULL ,
18 period_id cn_srp_periods.period_id%TYPE := NULL ,
19 start_date cn_srp_periods.start_date%TYPE := NULL ,
20 end_date cn_srp_periods.end_date%TYPE := NULL ,
21 credit_type_id cn_srp_periods.credit_type_id%TYPE := NULL ,
22 role_id cn_srp_periods.role_id%TYPE := NULL ,
23 quota_id cn_srp_periods.quota_id%TYPE := NULL ,
24 pay_group_id cn_srp_periods.pay_group_id%TYPE := NULL ,
25 del_balance1_bbc cn_srp_periods.balance1_bbc%TYPE := 0,
26 del_balance1_bbd cn_srp_periods.balance1_bbd%TYPE := 0,
27 del_balance1_ctd cn_srp_periods.balance1_ctd%TYPE := 0,
28 del_balance1_dtd cn_srp_periods.balance1_dtd%TYPE := 0,
29 del_balance2_bbc cn_srp_periods.balance2_bbc%TYPE := 0,
30 del_balance2_bbd cn_srp_periods.balance2_bbd%TYPE := 0,
31 del_balance2_ctd cn_srp_periods.balance2_ctd%TYPE := 0,
32 del_balance2_dtd cn_srp_periods.balance2_dtd%TYPE := 0,
33 del_balance3_bbc cn_srp_periods.balance3_bbc%TYPE := 0,
34 del_balance3_bbd cn_srp_periods.balance3_bbd%TYPE := 0,
35 del_balance3_ctd cn_srp_periods.balance3_ctd%TYPE := 0,
36 del_balance3_dtd cn_srp_periods.balance3_dtd%TYPE := 0,
37 del_balance4_bbc cn_srp_periods.balance4_bbc%TYPE := 0,
38 del_balance4_bbd cn_srp_periods.balance4_bbd%TYPE := 0,
39 del_balance4_ctd cn_srp_periods.balance4_ctd%TYPE := 0,
40 del_balance4_dtd cn_srp_periods.balance4_dtd%TYPE := 0,
41 del_balance5_bbc cn_srp_periods.balance5_bbc%TYPE := 0,
42 del_balance5_bbd cn_srp_periods.balance5_bbd%TYPE := 0,
43 del_balance5_ctd cn_srp_periods.balance5_ctd%TYPE := 0,
44 del_balance5_dtd cn_srp_periods.balance5_dtd%TYPE := 0,
45 del_balance6_bbc cn_srp_periods.balance6_bbc%TYPE := 0,
46 del_balance6_bbd cn_srp_periods.balance6_bbd%TYPE := 0,
47 del_balance6_ctd cn_srp_periods.balance6_ctd%TYPE := 0,
48 del_balance6_dtd cn_srp_periods.balance6_dtd%TYPE := 0,
49 del_balance7_bbc cn_srp_periods.balance7_bbc%TYPE := 0,
50 del_balance7_bbd cn_srp_periods.balance7_bbd%TYPE := 0,
51 del_balance7_ctd cn_srp_periods.balance7_ctd%TYPE := 0,
52 del_balance7_dtd cn_srp_periods.balance7_dtd%TYPE := 0,
53 del_balance8_bbc cn_srp_periods.balance8_bbc%TYPE := 0,
54 del_balance8_bbd cn_srp_periods.balance8_bbd%TYPE := 0,
55 del_balance8_ctd cn_srp_periods.balance8_ctd%TYPE := 0,
56 del_balance8_dtd cn_srp_periods.balance8_dtd%TYPE := 0,
57 del_balance9_bbc cn_srp_periods.balance9_bbc%TYPE := 0,
58 del_balance9_bbd cn_srp_periods.balance9_bbd%TYPE := 0,
59 del_balance9_ctd cn_srp_periods.balance9_ctd%TYPE := 0,
60 del_balance9_dtd cn_srp_periods.balance9_dtd%TYPE := 0,
61 del_balance10_bbc cn_srp_periods.balance10_bbc%TYPE := 0,
62 del_balance10_bbd cn_srp_periods.balance10_bbd%TYPE := 0,
63 del_balance10_ctd cn_srp_periods.balance10_ctd%TYPE := 0,
64 del_balance10_dtd cn_srp_periods.balance10_dtd%TYPE := 0,
65 del_balance11_bbc cn_srp_periods.balance11_bbc%TYPE := 0,
66 del_balance11_bbd cn_srp_periods.balance11_bbd%TYPE := 0,
67 del_balance11_ctd cn_srp_periods.balance11_ctd%TYPE := 0,
68 del_balance11_dtd cn_srp_periods.balance11_dtd%TYPE := 0,
69 del_balance12_bbc cn_srp_periods.balance12_bbc%TYPE := 0,
70 del_balance12_bbd cn_srp_periods.balance12_bbd%TYPE := 0,
71 del_balance12_ctd cn_srp_periods.balance12_ctd%TYPE := 0,
72 del_balance12_dtd cn_srp_periods.balance12_dtd%TYPE := 0,
73 del_balance13_bbc cn_srp_periods.balance13_bbc%TYPE := 0,
74 del_balance13_bbd cn_srp_periods.balance13_bbd%TYPE := 0,
75 del_balance13_ctd cn_srp_periods.balance13_ctd%TYPE := 0,
76 del_balance13_dtd cn_srp_periods.balance13_dtd%TYPE := 0,
77 del_balance14_bbc cn_srp_periods.balance14_bbc%TYPE := 0,
78 del_balance14_bbd cn_srp_periods.balance14_bbd%TYPE := 0,
79 del_balance14_ctd cn_srp_periods.balance14_ctd%TYPE := 0,
80 del_balance14_dtd cn_srp_periods.balance14_dtd%TYPE := 0,
81 del_balance15_bbc cn_srp_periods.balance15_bbc%TYPE := 0,
82 del_balance15_bbd cn_srp_periods.balance15_bbd%TYPE := 0,
83 del_balance15_ctd cn_srp_periods.balance15_ctd%TYPE := 0,
84 del_balance15_dtd cn_srp_periods.balance15_dtd%TYPE := 0,
85 del_balance16_bbc cn_srp_periods.balance16_bbc%TYPE := 0,
86 del_balance16_bbd cn_srp_periods.balance16_bbd%TYPE := 0,
87 del_balance16_ctd cn_srp_periods.balance16_ctd%TYPE := 0,
88 del_balance16_dtd cn_srp_periods.balance16_dtd%TYPE := 0,
89 del_balance17_bbc cn_srp_periods.balance17_bbc%TYPE := 0,
90 del_balance17_bbd cn_srp_periods.balance17_bbd%TYPE := 0,
91 del_balance17_ctd cn_srp_periods.balance17_ctd%TYPE := 0,
92 del_balance17_dtd cn_srp_periods.balance17_dtd%TYPE := 0,
93 del_balance18_bbc cn_srp_periods.balance18_bbc%TYPE := 0,
94 del_balance18_bbd cn_srp_periods.balance18_bbd%TYPE := 0,
95 del_balance18_ctd cn_srp_periods.balance18_ctd%TYPE := 0,
96 del_balance18_dtd cn_srp_periods.balance18_dtd%TYPE := 0,
97 del_balance19_bbc cn_srp_periods.balance19_bbc%TYPE := 0,
98 del_balance19_bbd cn_srp_periods.balance19_bbd%TYPE := 0,
99 del_balance19_ctd cn_srp_periods.balance19_ctd%TYPE := 0,
100 del_balance19_dtd cn_srp_periods.balance19_dtd%TYPE := 0,
101 del_balance20_bbc cn_srp_periods.balance20_bbc%TYPE := 0,
102 del_balance20_bbd cn_srp_periods.balance20_bbd%TYPE := 0,
103 del_balance20_ctd cn_srp_periods.balance20_ctd%TYPE := 0,
104 del_balance20_dtd cn_srp_periods.balance20_dtd%TYPE := 0,
105 del_balance21_bbc cn_srp_periods.balance21_bbc%TYPE := 0,
106 del_balance21_bbd cn_srp_periods.balance21_bbd%TYPE := 0,
107 del_balance21_ctd cn_srp_periods.balance21_ctd%TYPE := 0,
108 del_balance21_dtd cn_srp_periods.balance21_dtd%TYPE := 0,
109 del_balance22_bbc cn_srp_periods.balance22_bbc%TYPE := 0,
110 del_balance22_bbd cn_srp_periods.balance22_bbd%TYPE := 0,
111 del_balance22_ctd cn_srp_periods.balance22_ctd%TYPE := 0,
112 del_balance22_dtd cn_srp_periods.balance22_dtd%TYPE := 0,
113 del_balance23_bbc cn_srp_periods.balance23_bbc%TYPE := 0,
114 del_balance23_bbd cn_srp_periods.balance23_bbd%TYPE := 0,
115 del_balance23_ctd cn_srp_periods.balance23_ctd%TYPE := 0,
116 del_balance23_dtd cn_srp_periods.balance23_dtd%TYPE := 0,
117 del_balance24_bbc cn_srp_periods.balance24_bbc%TYPE := 0,
118 del_balance24_bbd cn_srp_periods.balance24_bbd%TYPE := 0,
119 del_balance24_ctd cn_srp_periods.balance24_ctd%TYPE := 0,
120 del_balance24_dtd cn_srp_periods.balance24_dtd%TYPE := 0,
121 del_balance25_bbc cn_srp_periods.balance25_bbc%TYPE := 0,
122 del_balance25_bbd cn_srp_periods.balance25_bbd%TYPE := 0,
123 del_balance25_ctd cn_srp_periods.balance25_ctd%TYPE := 0,
124 del_balance25_dtd cn_srp_periods.balance25_dtd%TYPE := 0,
125 del_balance26_bbc cn_srp_periods.balance26_bbc%TYPE := 0,
126 del_balance26_bbd cn_srp_periods.balance26_bbd%TYPE := 0,
127 del_balance26_ctd cn_srp_periods.balance26_ctd%TYPE := 0,
128 del_balance26_dtd cn_srp_periods.balance26_dtd%TYPE := 0,
129 del_balance27_bbc cn_srp_periods.balance27_bbc%TYPE := 0,
130 del_balance27_bbd cn_srp_periods.balance27_bbd%TYPE := 0,
131 del_balance27_ctd cn_srp_periods.balance27_ctd%TYPE := 0,
132 del_balance27_dtd cn_srp_periods.balance27_dtd%TYPE := 0,
133 del_balance28_bbc cn_srp_periods.balance28_bbc%TYPE := 0,
134 del_balance28_bbd cn_srp_periods.balance28_bbd%TYPE := 0,
135 del_balance28_ctd cn_srp_periods.balance28_ctd%TYPE := 0,
136 del_balance28_dtd cn_srp_periods.balance28_dtd%TYPE := 0,
137 del_balance29_bbc cn_srp_periods.balance29_bbc%TYPE := 0,
138 del_balance29_bbd cn_srp_periods.balance29_bbd%TYPE := 0,
139 del_balance29_ctd cn_srp_periods.balance29_ctd%TYPE := 0,
140 del_balance29_dtd cn_srp_periods.balance29_dtd%TYPE := 0,
141 del_balance30_bbc cn_srp_periods.balance30_bbc%TYPE := 0,
142 del_balance30_bbd cn_srp_periods.balance30_bbd%TYPE := 0,
143 del_balance30_ctd cn_srp_periods.balance30_ctd%TYPE := 0,
144 del_balance30_dtd cn_srp_periods.balance30_dtd%TYPE := 0,
145 del_balance31_bbc cn_srp_periods.balance31_bbc%TYPE := 0,
146 del_balance31_bbd cn_srp_periods.balance31_bbd%TYPE := 0,
147 del_balance31_ctd cn_srp_periods.balance31_ctd%TYPE := 0,
148 del_balance31_dtd cn_srp_periods.balance31_dtd%TYPE := 0,
149 del_balance32_bbc cn_srp_periods.balance32_bbc%TYPE := 0,
150 del_balance32_bbd cn_srp_periods.balance32_bbd%TYPE := 0,
151 del_balance32_ctd cn_srp_periods.balance32_ctd%TYPE := 0,
152 del_balance32_dtd cn_srp_periods.balance32_dtd%TYPE := 0,
153 del_balance33_bbc cn_srp_periods.balance33_bbc%TYPE := 0,
154 del_balance33_bbd cn_srp_periods.balance33_bbd%TYPE := 0,
155 del_balance33_ctd cn_srp_periods.balance33_ctd%TYPE := 0,
156 del_balance33_dtd cn_srp_periods.balance33_dtd%TYPE := 0
157 );
158
159 G_MISS_DELTA_SRP_PERIOD_REC delta_srp_period_rec_type;
160
161 -- Start of comments
162 -- API name : Create_Srp_Periods
163 -- Type : Public.
164 -- Pre-reqs : None.
165 -- Usage : Used to create a new record in cn_srp_periods
166 -- Desc : Procedure to create a new record in cn_srp_periods
167 -- Parameters :
168 -- IN : p_api_version IN NUMBER Require
169 -- p_init_msg_list IN VARCHAR2 Optional
170 -- Default = FND_API.G_FALSE
171 -- p_commit IN VARCHAR2 Optional
172 -- Default = FND_API.G_FALSE
173 -- p_validation_level IN NUMBER Optional
174 -- Default = FND_API.G_VALID_LEVEL_FULL
175 -- OUT : x_return_status OUT VARCHAR2(1)
176 -- x_msg_count OUT NUMBER
177 -- x_msg_data OUT VARCHAR2(2000)
178 -- IN : p_salesrep_id IN NUMBER,
179 -- p_period_id IN NUMBER,
180 -- p_srp_plan_assign_id IN NUMBER,
181 -- p_credit_type_id IN NUMBER,
182 -- p_role_id IN NUMBER
183 -- OUT : x_srp_period_id OUT NUMBER
184 -- Version : Current version 1.0
185 -- Initial version 1.0
186 --
187 -- End of comments
188
189 PROCEDURE Create_Srp_Periods
190 (p_api_version IN NUMBER,
191 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
192 p_commit IN VARCHAR2 := FND_API.G_FALSE,
193 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
194 x_return_status OUT NOCOPY VARCHAR2,
195 x_msg_count OUT NOCOPY NUMBER,
196 x_msg_data OUT NOCOPY VARCHAR2,
197 p_salesrep_id IN NUMBER,
198 p_role_id IN NUMBER,
199 p_comp_plan_id IN NUMBER,
200 p_start_date IN DATE,
201 p_end_date IN DATE,
202 p_sync_flag IN VARCHAR2 := FND_API.G_TRUE,
203 x_loading_status OUT NOCOPY VARCHAR2
204 );
205
206 -- same as Create_Srp_Periods but only for one plan element
207 PROCEDURE Create_Srp_Periods_Per_Quota
208 (p_api_version IN NUMBER,
209 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
210 p_commit IN VARCHAR2 := FND_API.G_FALSE,
211 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
212 x_return_status OUT NOCOPY VARCHAR2,
213 x_msg_count OUT NOCOPY NUMBER,
214 x_msg_data OUT NOCOPY VARCHAR2,
215 p_salesrep_id IN NUMBER,
216 p_role_id IN NUMBER,
217 p_comp_plan_id IN NUMBER,
218 p_quota_id IN NUMBER,
219 p_start_date IN DATE,
220 p_end_date IN DATE,
221 p_sync_flag IN VARCHAR2 := FND_API.G_TRUE,
222 x_loading_status OUT NOCOPY VARCHAR2
223 );
224
225 -- Start of comments
226 -- API name : Update_Delta_Srp_Periods
227 -- Type : Public.
228 -- Pre-reqs : None.
229 -- Usage : Used to create a new record in cn_srp_periods
230 -- Desc : Procedure to create a new record in cn_srp_periods
231 -- Parameters :
232 -- IN : p_api_version IN NUMBER Require
233 -- p_init_msg_list IN VARCHAR2 Optional
234 -- Default = FND_API.G_FALSE
235 -- p_commit IN VARCHAR2 Optional
236 -- Default = FND_API.G_FALSE
237 -- p_validation_level IN NUMBER Optional
238 -- Default = FND_API.G_VALID_LEVEL_FULL
239 -- OUT : x_return_status OUT VARCHAR2(1)
240 -- x_msg_count OUT NUMBER
241 -- x_msg_data OUT VARCHAR2(2000)
242 -- IN :
243 -- p_del_srp_prd_rec IN delta_srp_period_rec_type,
244 -- Version : Current version 1.0
245 -- Initial version 1.0
246 --
247 -- End of comments
248
249 PROCEDURE Update_Delta_Srp_Periods
250 (p_api_version IN NUMBER,
251 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
252 p_commit IN VARCHAR2 := FND_API.G_FALSE,
253 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
254 x_return_status OUT NOCOPY VARCHAR2,
255 x_msg_count OUT NOCOPY NUMBER,
256 x_msg_data OUT NOCOPY VARCHAR2,
257 p_del_srp_prd_rec IN delta_srp_period_rec_type,
258 x_loading_status OUT NOCOPY VARCHAR2
259 );
260
261 -- same as Update_Delta_Srp_Periods but without syncing
262 -- balances after update
263 -- *** CAUTION *** if you use this, make sure you sync the balances
264 -- afterward, so balances do not mismatch.
265 PROCEDURE Update_Delta_Srp_Pds_No_Sync
266 (p_api_version IN NUMBER,
267 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
268 p_commit IN VARCHAR2 := FND_API.G_FALSE,
269 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
270 x_return_status OUT NOCOPY VARCHAR2,
271 x_msg_count OUT NOCOPY NUMBER,
272 x_msg_data OUT NOCOPY VARCHAR2,
273 p_del_srp_prd_rec IN delta_srp_period_rec_type,
274 x_loading_status OUT NOCOPY VARCHAR2
275 );
276
277 -- Start of comments
278 -- API name : Update_Pmt_Delta_Srp_Periods
279 -- Type : Public.
280 -- Pre-reqs : None.
281 -- Usage : Used to create a new record in cn_srp_periods
282 -- Desc : Procedure to create a new record in cn_srp_periods
283 -- Parameters :
284 -- IN : p_api_version IN NUMBER Require
285 -- p_init_msg_list IN VARCHAR2 Optional
286 -- Default = FND_API.G_FALSE
287 -- p_commit IN VARCHAR2 Optional
288 -- Default = FND_API.G_FALSE
289 -- p_validation_level IN NUMBER Optional
290 -- Default = FND_API.G_VALID_LEVEL_FULL
291 -- OUT : x_return_status OUT VARCHAR2(1)
292 -- x_msg_count OUT NUMBER
293 -- x_msg_data OUT VARCHAR2(2000)
294 -- IN :
295 -- p_del_srp_prd_rec IN delta_srp_period_rec_type,
296 -- Version : Current version 1.0
297 -- Initial version 1.0
298 --
299 -- End of comments
300
301 PROCEDURE Update_Pmt_Delta_Srp_Periods
302 (p_api_version IN NUMBER,
303 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
304 p_commit IN VARCHAR2 := FND_API.G_FALSE,
305 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
306 x_return_status OUT NOCOPY VARCHAR2,
307 x_msg_count OUT NOCOPY NUMBER,
308 x_msg_data OUT NOCOPY VARCHAR2,
309 p_del_srp_prd_rec IN delta_srp_period_rec_type,
310 x_loading_status OUT NOCOPY VARCHAR2
311 );
312
313
314 -- sync balances in cn_srp_periods for all periods
315 -- update the begin balance columns and update summary record
316 PROCEDURE Sync_Accum_Balances
317 (p_salesrep_id IN NUMBER,
318 p_org_id IN NUMBER,
319 p_credit_type_id IN NUMBER,
320 p_role_id IN NUMBER);
321
322 -- sync balances for all periods starting with p_start_period_id
323 PROCEDURE Sync_Accum_Balances_Start_Pd
324 (p_salesrep_id IN NUMBER,
325 p_org_id IN NUMBER,
326 p_credit_type_id IN NUMBER,
327 p_role_id IN NUMBER,
328 p_start_period_id IN NUMBER);
329
330 END CN_SRP_PERIODS_PVT ;