[Home] [Help]
2777:
2778: /*DELETE FROM pn_var_transactions_all
2779: WHERE var_rent_id = p_var_rent_id;*/
2780:
2781: DELETE FROM pn_var_abat_defaults_all
2782: where var_rent_id = p_var_rent_id;
2783:
2784: DELETE FROM pn_var_abatements_all abat
2785: where abat.var_rent_id=p_var_rent_id;
4074: SELECT 1
4075: INTO l_abat_exist
4076: FROM dual
4077: WHERE EXISTS ( SELECT NULL
4078: FROM pn_var_abat_defaults_all
4079: WHERE var_rent_id = p_var_rent_id
4080: );
4081:
4082: RETURN l_abat_exist;
7850: -- ARGUMENTS : IN : p_var_rent_id, p_new_termn_date
7851: -- REFERENCE : PN_COMMON.debug()
7852: -- HISTORY :
7853: -- 01-JUN-06 piagrawa o Created
7854: -- 20-MAR-07 lbala o Added code to delete from pn_var_abat_defaults_all
7855: -- 03-MAY-10 acprakas o Changed condition to line_start_date > p_new_termn_date
7856: -- in DELETE pn_var_line_defaults_all
7857: -------------------------------------------------------------------------------
7858: PROCEDURE delete_vr_setup ( p_var_rent_id IN NUMBER
7918: DELETE pn_var_constr_defaults_all
7919: WHERE constr_start_date > p_new_termn_date
7920: AND var_rent_id = p_var_rent_id;
7921:
7922: DELETE pn_var_abat_defaults_all
7923: WHERE start_date > p_new_termn_date
7924: AND var_rent_id = p_var_rent_id;
7925:
7926: pnp_debug_pkg.debug ('pn_var_rent_pkg.delete_vr_setup (-)');
8272: -- HISTORY :
8273: -- 01-JUN-06 piagrawa o Created
8274: -- 11-JAN-07 Prabhakar o Added the call delete_report_date_row to delete
8275: -- the report records which fall after new termination date.
8276: -- 20-MAR-07 lbala o Added code to update or delete pn_var_abat_defaults_all
8277: -- BUg # 5933345
8278: -- 21-Nov-11 ppenumar o Bug Bug 9844162 . Fwd port for Bug 9235577 when variable rent span is decreased the
8279: -- periods are not getting deleted.
8280: -- 06-Feb-12 ppenumar o Bug 13711733 As part of CU8.
8499: /* Delete all abatements whose start date is after the new max inv end date
8500: since start and end dates of abatements must correspond to that of
8501: invoice periods */
8502:
8503: DELETE FROM pn_var_abat_defaults_all
8504: WHERE var_rent_id = p_var_rent_id
8505: AND p_new_termn_date BETWEEN start_date AND end_date
8506: AND start_date > l_inv_end_dt;
8507:
8505: AND p_new_termn_date BETWEEN start_date AND end_date
8506: AND start_date > l_inv_end_dt;
8507:
8508: /*Update all abatements so that their end date is the new max inv end date*/
8509: UPDATE pn_var_abat_defaults_all
8510: SET end_date = l_inv_end_dt
8511: WHERE var_rent_id = p_var_rent_id
8512: AND p_new_termn_date BETWEEN start_date AND end_date;
8513:
8849: -- REFERENCE : PN_COMMON.debug()
8850: -- HISTORY :
8851: -- 01-JUN-06 piagrawa o Created
8852: -- 20-MAR-07 lbala o Bug # 5933345, Added code to delete/update from
8853: -- pn_var_abat_defaults_all
8854: -------------------------------------------------------------------------------
8855: PROCEDURE process_vr_early_term ( p_lease_id IN NUMBER
8856: ,p_var_rent_id IN NUMBER
8857: ,p_new_termn_date IN DATE
9016:
9017: /* Delete all abatements whose start date is after the new max inv end date
9018: since start and end dates of abatements must correspond to that of
9019: invoice periods */
9020: DELETE FROM pn_var_abat_defaults_all
9021: WHERE var_rent_id = var_rent_rec.var_rent_id
9022: AND p_new_termn_date BETWEEN start_date AND end_date
9023: AND start_date > l_inv_end_dt;
9024:
9022: AND p_new_termn_date BETWEEN start_date AND end_date
9023: AND start_date > l_inv_end_dt;
9024:
9025: /*Update all abatements so that their end date is the new max inv end date*/
9026: UPDATE pn_var_abat_defaults_all
9027: SET end_date = l_inv_end_dt
9028: WHERE var_rent_id = var_rent_rec.var_rent_id
9029: AND p_new_termn_date BETWEEN start_date AND end_date;
9030: