[Home] [Help]
PACKAGE BODY: APPS.CN_SRP_PERIODS_PKG
Source
1 PACKAGE BODY CN_SRP_PERIODS_PKG AS
2 /* $Header: cnsrprdb.pls 120.0 2005/06/06 17:53:12 appldev noship $ */
3 --
4 -- Package Name
5 -- CN_SRP_PERIODS_PKG
6 -- Purpose
7 -- Table Handler for CN_SRP_PERIODS
8 -- History
9 -- 26-Jun-99 Angela Chung Created
10 -- 02-Nov-99 Angela Chung remove proc : mark_event, raise_status
11
12 g_unclassified CONSTANT VARCHAR2(30) := 'UNCLASSIFIED';
13 g_classified CONSTANT VARCHAR2(30) := 'CLASSIFIED' ;
14 g_rolled_up CONSTANT VARCHAR2(30) := 'ROLLED_UP' ;
15 g_populated CONSTANT VARCHAR2(30) := 'POPULATED' ;
16 g_calculated CONSTANT VARCHAR2(30) := 'CALCULATED' ;
17
18 -- /*-------------------------------------------------------------------------*
19 -- Procedure Name
20 -- Get_Previous_Balances
21 -- Purpose
22 -- To get the previous record in cn_srp_periods so can inherit the balance
23 -- from previous record
24 -- *-------------------------------------------------------------------------*/
25 PROCEDURE Get_Previous_Balances
26 (p_salesrep_id IN NUMBER,
27 p_org_id IN NUMBER,
28 p_role_id IN NUMBER,
29 p_quota_id IN NUMBER,
30 p_credit_type_id IN NUMBER,
31 p_start_date IN DATE,
32 p_period_id IN NUMBER,
33 x_srp_prd_row OUT NOCOPY cn_srp_periods%rowtype) IS
34
35 l_max_end_date cn_srp_periods.end_date%TYPE;
36 l_pre_period_year cn_period_statuses.period_year%TYPE;
37 l_cur_period_year cn_period_statuses.period_year%TYPE;
38
39
40 BEGIN
41 -- Find closest previous record
42 SELECT MAX(end_date)
43 INTO l_max_end_date
44 FROM cn_srp_periods_all srp
45 WHERE salesrep_id = p_salesrep_id
46 AND org_id = p_org_id
47 AND role_id = p_role_id
48 AND quota_id = p_quota_id
49 AND credit_type_id = p_credit_type_id
50 AND end_date < p_start_date;
51 -- Get all data from previous record
52 SELECT *
53 INTO x_srp_prd_row
54 FROM cn_srp_periods_all
55 WHERE salesrep_id = p_salesrep_id
56 AND org_id = p_org_id
57 AND role_id = p_role_id
58 AND quota_id = p_quota_id
59 AND credit_type_id = p_credit_type_id
60 AND end_date = l_max_end_date;
61
62 -- Get previous record's period_year
63 SELECT period_year INTO l_pre_period_year
64 FROM cn_period_statuses_all
65 WHERE period_id = x_srp_prd_row.period_id
66 AND org_id = p_org_id;
67 -- Get current record's period_year
68 SELECT period_year INTO l_cur_period_year
69 FROM cn_period_statuses_all
70 WHERE period_id = p_period_id
71 AND org_id = p_org_id;
72 -- Check if changing the period_year, if so, reset the value, do not
73 -- carry over
74 IF l_pre_period_year <> l_cur_period_year THEN
75 x_srp_prd_row := NULL;
76 END IF;
77
78 EXCEPTION
79 WHEN NO_DATA_FOUND THEN
80 x_srp_prd_row := NULL;
81
82 END Get_Previous_Balances;
83
84 --/*-------------------------------------------------------------------------*
85 -- Procedure Name
86 -- Insert_row
87 -- Purpose
88 -- Main insert procedure
89 -- Note : Will not inherit previous record's balance for balance account
90 -- 5,8,27,30,32
91 -- *-------------------------------------------------------------------------*/
92
93 PROCEDURE INSERT_ROW
94 (X_SRP_PERIOD_ID IN OUT NOCOPY NUMBER,
95 X_SALESREP_ID IN NUMBER,
96 x_org_id IN NUMBER,
97 X_PERIOD_ID IN NUMBER,
98 X_START_DATE IN DATE,
99 X_END_DATE IN DATE,
100 X_SRP_PLAN_ASSIGN_ID IN NUMBER := NULL,
101 X_CREDIT_TYPE_ID IN NUMBER,
102 X_ROLE_ID IN NUMBER,
103 X_QUOTA_ID IN NUMBER,
104 X_PAY_GROUP_ID IN NUMBER,
105 X_BALANCE1_DTD IN NUMBER := 0,
106 X_BALANCE1_CTD IN NUMBER := 0,
107 X_BALANCE1_BBD IN NUMBER := 0,
108 X_BALANCE1_BBC IN NUMBER := 0,
109 X_BALANCE2_DTD IN NUMBER := 0,
110 X_BALANCE2_CTD IN NUMBER := 0,
111 X_BALANCE2_BBD IN NUMBER := 0,
112 X_BALANCE2_BBC IN NUMBER := 0,
113 X_BALANCE3_DTD IN NUMBER := 0,
114 X_BALANCE3_CTD IN NUMBER := 0,
115 X_BALANCE3_BBD IN NUMBER := 0,
116 X_BALANCE3_BBC IN NUMBER := 0,
117 X_BALANCE4_DTD IN NUMBER := 0,
118 X_BALANCE4_CTD IN NUMBER := 0,
119 X_BALANCE4_BBD IN NUMBER := 0,
120 X_BALANCE4_BBC IN NUMBER := 0,
121 X_BALANCE5_DTD IN NUMBER := 0,
122 X_BALANCE5_CTD IN NUMBER := 0,
123 X_BALANCE5_BBD IN NUMBER := 0,
124 X_BALANCE5_BBC IN NUMBER := 0,
125 X_BALANCE6_DTD IN NUMBER := 0,
126 X_BALANCE6_CTD IN NUMBER := 0,
127 X_BALANCE6_BBD IN NUMBER := 0,
128 X_BALANCE6_BBC IN NUMBER := 0,
129 X_BALANCE7_DTD IN NUMBER := 0,
130 X_BALANCE7_CTD IN NUMBER := 0,
131 X_BALANCE7_BBD IN NUMBER := 0,
132 X_BALANCE7_BBC IN NUMBER := 0,
133 X_BALANCE8_DTD IN NUMBER := 0,
134 X_BALANCE8_CTD IN NUMBER := 0,
135 X_BALANCE8_BBD IN NUMBER := 0,
136 X_BALANCE8_BBC IN NUMBER := 0,
137 X_BALANCE9_DTD IN NUMBER := 0,
138 X_BALANCE9_CTD IN NUMBER := 0,
139 X_BALANCE9_BBD IN NUMBER := 0,
140 X_BALANCE9_BBC IN NUMBER := 0,
141 X_BALANCE10_DTD IN NUMBER := 0,
142 X_BALANCE10_CTD IN NUMBER := 0,
143 X_BALANCE10_BBD IN NUMBER := 0,
144 X_BALANCE10_BBC IN NUMBER := 0,
145 X_BALANCE11_DTD IN NUMBER := 0,
146 X_BALANCE11_CTD IN NUMBER := 0,
147 X_BALANCE11_BBD IN NUMBER := 0,
148 X_BALANCE11_BBC IN NUMBER := 0,
149 X_BALANCE12_DTD IN NUMBER := 0,
150 X_BALANCE12_CTD IN NUMBER := 0,
151 X_BALANCE12_BBD IN NUMBER := 0,
152 X_BALANCE12_BBC IN NUMBER := 0,
153 X_BALANCE13_DTD IN NUMBER := 0,
154 X_BALANCE13_CTD IN NUMBER := 0,
155 X_BALANCE13_BBD IN NUMBER := 0,
156 X_BALANCE13_BBC IN NUMBER := 0,
157 X_BALANCE14_DTD IN NUMBER := 0,
158 X_BALANCE14_CTD IN NUMBER := 0,
159 X_BALANCE14_BBD IN NUMBER := 0,
160 X_BALANCE14_BBC IN NUMBER := 0,
161 X_BALANCE15_DTD IN NUMBER := 0,
162 X_BALANCE15_CTD IN NUMBER := 0,
163 X_BALANCE15_BBD IN NUMBER := 0,
164 X_BALANCE15_BBC IN NUMBER := 0,
165 X_BALANCE16_DTD IN NUMBER := 0,
166 X_BALANCE16_CTD IN NUMBER := 0,
167 X_BALANCE16_BBD IN NUMBER := 0,
168 X_BALANCE16_BBC IN NUMBER := 0,
169 X_BALANCE17_DTD IN NUMBER := 0,
170 X_BALANCE17_CTD IN NUMBER := 0,
171 X_BALANCE17_BBD IN NUMBER := 0,
172 X_BALANCE17_BBC IN NUMBER := 0,
173 X_BALANCE18_DTD IN NUMBER := 0,
174 X_BALANCE18_CTD IN NUMBER := 0,
175 X_BALANCE18_BBD IN NUMBER := 0,
176 X_BALANCE18_BBC IN NUMBER := 0,
177 X_BALANCE19_DTD IN NUMBER := 0,
178 X_BALANCE19_CTD IN NUMBER := 0,
179 X_BALANCE19_BBD IN NUMBER := 0,
180 X_BALANCE19_BBC IN NUMBER := 0,
181 X_BALANCE20_DTD IN NUMBER := 0,
182 X_BALANCE20_CTD IN NUMBER := 0,
183 X_BALANCE20_BBD IN NUMBER := 0,
184 X_BALANCE20_BBC IN NUMBER := 0,
185 X_BALANCE21_DTD IN NUMBER := 0,
186 X_BALANCE21_CTD IN NUMBER := 0,
187 X_BALANCE21_BBD IN NUMBER := 0,
188 X_BALANCE21_BBC IN NUMBER := 0,
189 X_BALANCE22_DTD IN NUMBER := 0,
190 X_BALANCE22_CTD IN NUMBER := 0,
191 X_BALANCE22_BBD IN NUMBER := 0,
192 X_BALANCE22_BBC IN NUMBER := 0,
193 X_BALANCE23_DTD IN NUMBER := 0,
194 X_BALANCE23_CTD IN NUMBER := 0,
195 X_BALANCE23_BBD IN NUMBER := 0,
196 X_BALANCE23_BBC IN NUMBER := 0,
197 X_BALANCE24_DTD IN NUMBER := 0,
198 X_BALANCE24_CTD IN NUMBER := 0,
199 X_BALANCE24_BBD IN NUMBER := 0,
200 X_BALANCE24_BBC IN NUMBER := 0,
201 X_BALANCE25_DTD IN NUMBER := 0,
202 X_BALANCE25_CTD IN NUMBER := 0,
203 X_BALANCE25_BBD IN NUMBER := 0,
204 X_BALANCE25_BBC IN NUMBER := 0,
205 X_BALANCE26_DTD IN NUMBER := 0,
206 X_BALANCE26_CTD IN NUMBER := 0,
207 X_BALANCE26_BBD IN NUMBER := 0,
208 X_BALANCE26_BBC IN NUMBER := 0,
209 X_BALANCE27_DTD IN NUMBER := 0,
210 X_BALANCE27_CTD IN NUMBER := 0,
211 X_BALANCE27_BBD IN NUMBER := 0,
212 X_BALANCE27_BBC IN NUMBER := 0,
213 X_BALANCE28_DTD IN NUMBER := 0,
214 X_BALANCE28_CTD IN NUMBER := 0,
215 X_BALANCE28_BBD IN NUMBER := 0,
216 X_BALANCE28_BBC IN NUMBER := 0,
217 X_BALANCE29_DTD IN NUMBER := 0,
218 X_BALANCE29_CTD IN NUMBER := 0,
219 X_BALANCE29_BBD IN NUMBER := 0,
220 X_BALANCE29_BBC IN NUMBER := 0,
221 X_BALANCE30_DTD IN NUMBER := 0,
222 X_BALANCE30_CTD IN NUMBER := 0,
223 X_BALANCE30_BBD IN NUMBER := 0,
224 X_BALANCE30_BBC IN NUMBER := 0,
225 X_BALANCE31_DTD IN NUMBER := 0,
226 X_BALANCE31_CTD IN NUMBER := 0,
227 X_BALANCE31_BBD IN NUMBER := 0,
228 X_BALANCE31_BBC IN NUMBER := 0,
229 X_BALANCE32_DTD IN NUMBER := 0,
230 X_BALANCE32_CTD IN NUMBER := 0,
231 X_BALANCE32_BBD IN NUMBER := 0,
232 X_BALANCE32_BBC IN NUMBER := 0,
233 X_BALANCE33_DTD IN NUMBER := 0,
234 X_BALANCE33_CTD IN NUMBER := 0,
235 X_BALANCE33_BBD IN NUMBER := 0,
236 X_BALANCE33_BBC IN NUMBER := 0,
237 X_CONSISTENCY_FLAG IN VARCHAR2 := 'Y',
238 X_PAID_FLAG IN VARCHAR2 := 'N',
239 X_CREATION_DATE IN DATE,
240 X_CREATED_BY IN NUMBER,
241 X_LAST_UPDATE_DATE IN DATE,
242 X_LAST_UPDATED_BY IN NUMBER,
243 X_LAST_UPDATE_LOGIN IN NUMBER
244 ) IS
245 l_dummy NUMBER;
246 l_srp_prd_row cn_srp_periods%ROWTYPE := Null;
247
248 BEGIN
249 SELECT cn_srp_periods_s.NEXTVAL
250 INTO X_SRP_PERIOD_ID
251 FROM dual;
252
253 INSERT INTO cn_srp_periods_all
254 (SRP_PERIOD_ID ,
255 SALESREP_ID ,
256 org_id,
257 PERIOD_ID ,
258 START_DATE,
259 END_DATE,
260 SRP_PLAN_ASSIGN_ID ,
261 CREDIT_TYPE_ID ,
262 ROLE_ID ,
263 QUOTA_ID,
264 PAY_GROUP_ID ,
265 BALANCE1_DTD ,
266 BALANCE1_CTD ,
267 BALANCE1_BBD ,
268 BALANCE1_BBC ,
269 BALANCE2_DTD ,
270 BALANCE2_CTD ,
271 BALANCE2_BBD ,
272 BALANCE2_BBC ,
273 BALANCE3_DTD ,
274 BALANCE3_CTD ,
275 BALANCE3_BBD ,
276 BALANCE3_BBC ,
277 BALANCE4_DTD ,
278 BALANCE4_CTD ,
279 BALANCE4_BBD ,
280 BALANCE4_BBC ,
281 BALANCE5_DTD ,
282 BALANCE5_CTD ,
283 BALANCE5_BBD ,
284 BALANCE5_BBC ,
285 BALANCE6_DTD ,
286 BALANCE6_CTD ,
287 BALANCE6_BBD ,
288 BALANCE6_BBC ,
289 BALANCE7_DTD ,
290 BALANCE7_CTD ,
291 BALANCE7_BBD ,
292 BALANCE7_BBC ,
293 BALANCE8_DTD ,
294 BALANCE8_CTD ,
295 BALANCE8_BBD ,
296 BALANCE8_BBC ,
297 BALANCE9_DTD ,
298 BALANCE9_CTD ,
299 BALANCE9_BBD ,
300 BALANCE9_BBC ,
301 BALANCE10_DTD ,
302 BALANCE10_CTD ,
303 BALANCE10_BBD ,
304 BALANCE10_BBC ,
305 BALANCE11_DTD ,
306 BALANCE11_CTD ,
307 BALANCE11_BBD ,
308 BALANCE11_BBC ,
309 BALANCE12_DTD ,
310 BALANCE12_CTD ,
311 BALANCE12_BBD ,
312 BALANCE12_BBC ,
313 BALANCE13_DTD ,
314 BALANCE13_CTD ,
315 BALANCE13_BBD ,
316 BALANCE13_BBC ,
317 BALANCE14_DTD ,
318 BALANCE14_CTD ,
319 BALANCE14_BBD ,
320 BALANCE14_BBC ,
321 BALANCE15_DTD ,
322 BALANCE15_CTD ,
323 BALANCE15_BBD ,
324 BALANCE15_BBC ,
325 BALANCE16_DTD ,
326 BALANCE16_CTD ,
327 BALANCE16_BBD ,
328 BALANCE16_BBC ,
329 BALANCE17_DTD ,
330 BALANCE17_CTD ,
331 BALANCE17_BBD ,
332 BALANCE17_BBC ,
333 BALANCE18_DTD ,
334 BALANCE18_CTD ,
335 BALANCE18_BBD ,
336 BALANCE18_BBC ,
337 BALANCE19_DTD ,
338 BALANCE19_CTD ,
339 BALANCE19_BBD ,
340 BALANCE19_BBC ,
341 BALANCE20_DTD ,
342 BALANCE20_CTD ,
343 BALANCE20_BBD ,
344 BALANCE20_BBC ,
345 BALANCE21_DTD ,
346 BALANCE21_CTD ,
347 BALANCE21_BBD ,
348 BALANCE21_BBC ,
349 BALANCE22_DTD ,
350 BALANCE22_CTD ,
351 BALANCE22_BBD ,
352 BALANCE22_BBC ,
353 BALANCE23_DTD ,
354 BALANCE23_CTD ,
355 BALANCE23_BBD ,
356 BALANCE23_BBC ,
357 BALANCE24_DTD ,
358 BALANCE24_CTD ,
359 BALANCE24_BBD ,
360 BALANCE24_BBC ,
361 BALANCE25_DTD ,
362 BALANCE25_CTD ,
363 BALANCE25_BBD ,
364 BALANCE25_BBC ,
365 BALANCE26_DTD ,
366 BALANCE26_CTD ,
367 BALANCE26_BBD ,
368 BALANCE26_BBC ,
369 BALANCE27_DTD ,
370 BALANCE27_CTD ,
371 BALANCE27_BBD ,
372 BALANCE27_BBC ,
373 BALANCE28_DTD ,
374 BALANCE28_CTD ,
375 BALANCE28_BBD ,
376 BALANCE28_BBC ,
377 BALANCE29_DTD ,
378 BALANCE29_CTD ,
379 BALANCE29_BBD ,
380 BALANCE29_BBC ,
381 BALANCE30_DTD ,
382 BALANCE30_CTD ,
383 BALANCE30_BBD ,
384 BALANCE30_BBC ,
385 BALANCE31_DTD ,
386 BALANCE31_CTD ,
387 BALANCE31_BBD ,
388 BALANCE31_BBC ,
389 BALANCE32_DTD ,
390 BALANCE32_CTD ,
391 BALANCE32_BBD ,
392 BALANCE32_BBC ,
393 BALANCE33_DTD ,
394 BALANCE33_CTD ,
395 BALANCE33_BBD ,
396 BALANCE33_BBC ,
397 CONSISTENCY_FLAG ,
398 PAID_FLAG ,
399 CREATION_DATE ,
400 CREATED_BY ,
401 LAST_UPDATE_DATE ,
402 LAST_UPDATED_BY ,
403 LAST_UPDATE_LOGIN
404 ) VALUES
405 (x_srp_period_id ,
406 x_salesrep_id ,
407 x_org_id,
408 x_period_id ,
409 x_start_date ,
410 x_end_date ,
411 x_srp_plan_assign_id ,
412 x_credit_type_id ,
413 x_role_id ,
414 x_quota_id ,
415 x_pay_group_id ,
416 Nvl(x_balance1_dtd,0) ,
417 Nvl(x_balance1_ctd,0) ,
418 Nvl(x_balance1_bbd,0) ,
419 Nvl(x_balance1_bbc,0) ,
420 Nvl(x_balance2_dtd,0) ,
421 Nvl(x_balance2_ctd,0) ,
422 Nvl(x_balance2_bbd,0) ,
423 Nvl(x_balance2_bbc,0) ,
424 Nvl(x_balance3_dtd,0) ,
425 Nvl(x_balance3_ctd,0) ,
426 Nvl(x_balance3_bbd,0) ,
427 Nvl(x_balance3_bbc,0) ,
428 Nvl(x_balance4_dtd,0) ,
429 Nvl(x_balance4_ctd,0) ,
430 Nvl(x_balance4_bbd,0) ,
431 Nvl(x_balance4_bbc,0) ,
432 Nvl(x_balance5_dtd,0) ,
433 Nvl(x_balance5_ctd,0) ,
434 Nvl(x_balance5_bbd,0) ,
435 Nvl(x_balance5_bbc,0) ,
436
437 Nvl(x_balance6_dtd,0) , -- not used, but leave as is
438 Nvl(x_balance6_ctd,0) ,
439 Nvl(x_balance6_bbd,0) ,
440 Nvl(x_balance6_bbc,0) ,
441 Nvl(x_balance7_dtd,0) ,
442 Nvl(x_balance7_ctd,0) ,
443 Nvl(x_balance7_bbd,0) ,
444 Nvl(x_balance7_bbc,0) ,
445 Nvl(x_balance8_dtd,0) ,
446 Nvl(x_balance8_ctd,0) ,
447 Nvl(x_balance8_bbd,0) ,
448 Nvl(x_balance8_bbc,0) ,
449 Nvl(x_balance9_dtd,0) ,
450 Nvl(x_balance9_ctd,0) ,
451 Nvl(x_balance9_bbd,0) ,
452 Nvl(x_balance9_bbc,0) ,
453 Nvl(x_balance10_dtd,0) ,
454 Nvl(x_balance10_ctd,0) ,
455 Nvl(x_balance10_bbd,0) ,
456 Nvl(x_balance10_bbc,0) ,
457 Nvl(x_balance11_dtd,0) ,
458 Nvl(x_balance11_ctd,0) ,
459 Nvl(x_balance11_bbd,0) ,
460 Nvl(x_balance11_bbc,0) ,
461 Nvl(x_balance12_dtd,0) ,
462 Nvl(x_balance12_ctd,0) ,
466 Nvl(x_balance13_ctd,0) ,
463 Nvl(x_balance12_bbd,0) ,
464 Nvl(x_balance12_bbc,0) ,
465 Nvl(x_balance13_dtd,0) ,
467 Nvl(x_balance13_bbd,0) ,
468 Nvl(x_balance13_bbc,0) ,
469 Nvl(x_balance14_dtd,0) ,
470 Nvl(x_balance14_ctd,0) ,
471 Nvl(x_balance14_bbd,0) ,
472 Nvl(x_balance14_bbc,0) ,
473 Nvl(x_balance15_dtd,0) ,
474 Nvl(x_balance15_ctd,0) ,
475 Nvl(x_balance15_bbd,0) ,
476 Nvl(x_balance15_bbc,0) ,
477 Nvl(x_balance16_dtd,0) ,
478 Nvl(x_balance16_ctd,0) ,
479 Nvl(x_balance16_bbd,0) ,
480 Nvl(x_balance16_bbc,0) ,
481 Nvl(x_balance17_dtd,0) ,
482 Nvl(x_balance17_ctd,0) ,
483 Nvl(x_balance17_bbd,0) ,
484 Nvl(x_balance17_bbc,0) ,
485 Nvl(x_balance18_dtd,0) ,
486 Nvl(x_balance18_ctd,0) ,
487 Nvl(x_balance18_bbd,0) ,
488 Nvl(x_balance18_bbc,0) ,
489 Nvl(x_balance19_dtd,0) ,
490 Nvl(x_balance19_ctd,0) ,
491 Nvl(x_balance19_bbd,0) ,
492 Nvl(x_balance19_bbc,0) ,
493 Nvl(x_balance20_dtd,0) ,
494 Nvl(x_balance20_ctd,0) ,
495 Nvl(x_balance20_bbd,0) ,
496 Nvl(x_balance20_bbc,0) ,
497 Nvl(x_balance21_dtd,0) ,
498 Nvl(x_balance21_ctd,0) ,
499 Nvl(x_balance21_bbd,0) ,
500 Nvl(x_balance21_bbc,0) ,
501 Nvl(x_balance22_dtd,0) ,
502 Nvl(x_balance22_ctd,0) ,
503 Nvl(x_balance22_bbd,0) ,
504 Nvl(x_balance22_bbc,0) ,
505 Nvl(x_balance23_dtd,0) ,
506 Nvl(x_balance23_ctd,0) ,
507 Nvl(x_balance23_bbd,0) ,
508 Nvl(x_balance23_bbc,0) ,
509 Nvl(x_balance24_dtd,0) ,
510 Nvl(x_balance24_ctd,0) ,
511 Nvl(x_balance24_bbd,0) ,
512 Nvl(x_balance24_bbc,0) ,
513 Nvl(x_balance25_dtd,0) ,
514 Nvl(x_balance25_ctd,0) ,
515 Nvl(x_balance25_bbd,0) ,
516 Nvl(x_balance25_bbc,0) ,
517 Nvl(x_balance26_dtd,0) ,
518 Nvl(x_balance26_ctd,0) ,
519 Nvl(x_balance26_bbd,0) ,
520 Nvl(x_balance26_bbc,0) ,
521 Nvl(x_balance27_dtd,0) ,
522 Nvl(x_balance27_ctd,0) ,
523 Nvl(x_balance27_bbd,0) ,
524 Nvl(x_balance27_bbc,0) ,
525 Nvl(x_balance28_dtd,0) ,
526 Nvl(x_balance28_ctd,0) ,
527 Nvl(x_balance28_bbd,0) ,
528 Nvl(x_balance28_bbc,0) ,
529 Nvl(x_balance29_dtd,0) ,
530 Nvl(x_balance29_ctd,0) ,
531 Nvl(x_balance29_bbd,0) ,
532 Nvl(x_balance29_bbc,0) ,
533 Nvl(x_balance30_dtd,0) ,
534 Nvl(x_balance30_ctd,0) ,
535 Nvl(x_balance30_bbd,0) ,
536 Nvl(x_balance30_bbc,0) ,
537 Nvl(x_balance31_dtd,0) ,
538 Nvl(x_balance31_ctd,0) ,
539 Nvl(x_balance31_bbd,0) ,
540 Nvl(x_balance31_bbc,0) ,
541 Nvl(x_balance32_dtd,0) ,
542 Nvl(x_balance32_ctd,0) ,
543 Nvl(x_balance32_bbd,0) ,
544 Nvl(x_balance32_bbc,0) ,
545 Nvl(x_balance33_dtd,0) ,
546 Nvl(x_balance33_ctd,0) ,
547 Nvl(x_balance33_bbd,0) ,
548 Nvl(x_balance33_bbc,0) ,
549 x_consistency_flag ,
550 x_paid_flag ,
551 x_creation_date ,
552 x_created_by ,
553 x_last_update_date ,
554 x_last_updated_by ,
555 x_last_update_login
556 );
557
558 SELECT 1 INTO l_dummy FROM CN_SRP_PERIODS_all
559 WHERE SRP_PERIOD_ID = x_srp_period_id;
560
561 END Insert_Row;
562
563 --/*-------------------------------------------------------------------------*
564 -- Procedure Name
565 -- Delete_row
566 -- Purpose
567 -- Delete the Srp Payment Plan Assign
568 -- *-------------------------------------------------------------------------*/
569 PROCEDURE Delete_row( x_srp_period_id NUMBER ) IS
570
571 BEGIN
572
573 DELETE FROM cn_srp_periods_all
574 WHERE srp_period_id = x_srp_period_id ;
575 IF (SQL%NOTFOUND) THEN
576 RAISE NO_DATA_FOUND;
577 END IF;
578
579 END Delete_row;
580
581 END CN_SRP_PERIODS_PKG;