[Home] [Help]
2779:
2780: DELETE FROM pn_var_abatements_all abat
2781: where abat.var_rent_id=p_var_rent_id;
2782:
2783: DELETE FROM pn_var_bkdt_defaults_all
2784: WHERE var_rent_id = p_var_rent_id;
2785:
2786: DELETE pn_var_bkhd_defaults_all
2787: WHERE var_rent_id = p_var_rent_id;
5505: CURSOR bkpt_dtl_defs_c(p_bkhd_def_id IN NUMBER) IS
5506: SELECT bkdt_start_date
5507: ,bkdt_end_date
5508: ,COUNT(bkdt_default_id) AS bkpt_count
5509: FROM pn_var_bkdt_defaults_all
5510: WHERE bkhd_default_id = p_bkhd_def_id
5511: GROUP BY bkdt_start_date, bkdt_end_date
5512: ORDER BY bkdt_start_date;
5513:
5515: ,p_st_dt IN DATE
5516: ,p_end_dt IN DATE) IS
5517: SELECT period_bkpt_vol_start
5518: ,period_bkpt_vol_end
5519: FROM pn_var_bkdt_defaults_all
5520: WHERE bkhd_default_id = p_bkhd_def_id
5521: AND bkdt_start_date = p_st_dt
5522: AND bkdt_end_date = p_end_dt
5523: ORDER BY period_bkpt_vol_start;
5523: ORDER BY period_bkpt_vol_start;
5524:
5525: CURSOR null_def_vols(p_bkhd_def_id IN NUMBER, p_start_date IN DATE) IS
5526: SELECT count(*)
5527: FROM pn_var_bkdt_defaults_all
5528: WHERE bkhd_default_id = p_bkhd_def_id
5529: AND bkdt_start_date = p_start_date
5530: AND period_bkpt_vol_end IS NULL;
5531:
5630: l_bkdt_counter := 1;
5631:
5632: SELECT count(*)
5633: INTO l_bktd_num
5634: FROM pn_var_bkdt_defaults_all
5635: WHERE bkhd_default_id = bkhd_rec.bkhd_default_id;
5636:
5637: IF l_bktd_num = 0 THEN
5638: l_return_status := 'GAP_FOUND_EXCEPTION';
5734: END IF;
5735: ELSE
5736: SELECT min(bkdt_start_date)
5737: INTO l_dt_min_st_dt
5738: FROM pn_var_bkdt_defaults_all
5739: WHERE bkhd_default_id = bkhd_rec.bkhd_default_id;
5740:
5741: IF l_dt_min_st_dt > bkhd_rec.bkhd_start_date THEN
5742: IF p_check_for = 'GAPS' THEN
7407: CURSOR c_1 IS
7408: SELECT 'z'
7409: FROM DUAL
7410: WHERE EXISTS ( SELECT a.var_rent_id
7411: FROM pn_var_bkdt_defaults_all a,
7412: pn_var_bkhd_defaults_all b
7413: WHERE a.var_rent_id = p_var_rent_id
7414: AND a.bkhd_default_id = b.bkhd_default_id
7415: AND b.line_default_id = p_line_default_id
7461: CURSOR detail_cur (p_header_id NUMBER) IS
7462: SELECT
7463: bkdt_start_date,
7464: bkdt_end_date
7465: FROM pn_var_bkdt_defaults_all
7466: WHERE var_rent_id = p_var_rent_id
7467: AND bkhd_default_id = p_header_id
7468: ORDER BY bkdt_start_date;
7469:
7470: CURSOR exist_next_detail_date (p_header_id NUMBER,p_end_date DATE) IS
7471: SELECT 'x'
7472: FROM dual
7473: WHERE EXISTS ( SELECT var_Rent_id
7474: FROM pn_var_bkdt_defaults_all
7475: WHERE var_rent_id = p_var_rent_id
7476: AND bkhd_default_id = p_header_id
7477: AND bkdt_start_date = p_end_date + 1);
7478:
7825: p_bkdt_end_date IN DATE)
7826: IS
7827: BEGIN
7828:
7829: Update pn_var_bkdt_defaults_all
7830: SET bkdt_start_date = p_bkdt_st_date,
7831: bkdt_end_date = p_bkdt_end_date
7832: where bkhd_default_id = p_bkhd_default_id
7833: and bkdt_start_date = p_bkdt_st_date_old
7896: AND start_date > p_new_termn_date);
7897:
7898: /* Delete data from defaults table */
7899:
7900: DELETE pn_var_bkdt_defaults_all
7901: WHERE var_rent_id = p_var_rent_id
7902: AND bkdt_start_date > p_new_termn_date;
7903:
7904: DELETE pn_var_bkhd_defaults_all
8314:
8315: /* Get the details of breakpoint details default */
8316: CURSOR bkdt_defaults_cur IS
8317: SELECT bkdt_default_id, bkhd_default_id
8318: FROM pn_var_bkdt_defaults_all
8319: WHERE var_rent_id = p_var_rent_id
8320: AND p_new_termn_date BETWEEN bkdt_start_date AND bkdt_end_date;
8321:
8322: /* Get the details of volume history */
8786: WHERE var_rent_id = p_var_rent_id);
8787:
8788: /* Delete data from defaults table */
8789:
8790: DELETE pn_var_bkdt_defaults_all
8791: WHERE var_rent_id = p_var_rent_id;
8792:
8793: DELETE pn_var_bkhd_defaults_all
8794: WHERE var_rent_id = p_var_rent_id;
8897:
8898: /* Get the details of breakpoint details default */
8899: CURSOR bkdt_defaults_cur(p_var_rent_id NUMBER) IS
8900: SELECT bkdt_default_id, bkhd_default_id
8901: FROM pn_var_bkdt_defaults_all
8902: WHERE var_rent_id = p_var_rent_id
8903: AND p_new_termn_date BETWEEN bkdt_start_date AND bkdt_end_date;
8904:
8905: /* Get the max invoice end date corresponding to the new termination date*/
9118:
9119: /* Get the details of breakpoint details default */
9120: CURSOR bkdt_defaults_cur IS
9121: SELECT bkdt_default_id, bkhd_default_id
9122: FROM pn_var_bkdt_defaults_all
9123: WHERE var_rent_id = p_var_rent_id
9124: AND bkdt_end_date = p_old_termn_date
9125: AND bkhd_default_id IN ( SELECT bkhd_default_id
9126: FROM pn_var_bkhd_defaults_all
10590:
10591: DELETE FROM PN_VAR_BKHD_DEFAULTS_ALL
10592: WHERE var_rent_id = l_var_rent_id;
10593:
10594: DELETE FROM PN_VAR_BKDT_DEFAULTS_ALL
10595: WHERE var_rent_id = l_var_rent_id;
10596:
10597: DELETE FROM PN_VAR_CONSTR_DEFAULTS_ALL
10598: WHERE var_rent_id = l_var_rent_id;
11072: bkdt_end_date,
11073: period_bkpt_vol_start,
11074: period_bkpt_vol_end,
11075: bkpt_rate
11076: FROM pn_var_bkdt_defaults_all
11077: WHERE var_rent_id = p_vr_id
11078: AND bkdt_start_date BETWEEN p_start_date AND p_end_date;
11079:
11080: /* Cursor to select Breakpoints whose end date
11087: bkdt_end_date,
11088: period_bkpt_vol_start,
11089: period_bkpt_vol_end,
11090: bkpt_rate
11091: FROM pn_var_bkdt_defaults_all
11092: WHERE var_rent_id = p_vr_id
11093: AND bkdt_end_date BETWEEN p_start_date AND p_end_date;
11094:
11095: BEGIN