APPS.PN_VAR_RENT_PKG dependencies on PN_VAR_ABAT_DEFAULTS_ALL

Line 2777: DELETE FROM pn_var_abat_defaults_all

2773:
2774: /*DELETE FROM pn_var_transactions_all
2775: WHERE var_rent_id = p_var_rent_id;*/
2776:
2777: DELETE FROM pn_var_abat_defaults_all
2778: where var_rent_id = p_var_rent_id;
2779:
2780: DELETE FROM pn_var_abatements_all abat
2781: where abat.var_rent_id=p_var_rent_id;

Line 4074: FROM pn_var_abat_defaults_all

4070: SELECT 1
4071: INTO l_abat_exist
4072: FROM dual
4073: WHERE EXISTS ( SELECT NULL
4074: FROM pn_var_abat_defaults_all
4075: WHERE var_rent_id = p_var_rent_id
4076: );
4077:
4078: RETURN l_abat_exist;

Line 7850: -- 20-MAR-07 lbala o Added code to delete from pn_var_abat_defaults_all

7846: -- ARGUMENTS : IN : p_var_rent_id, p_new_termn_date
7847: -- REFERENCE : PN_COMMON.debug()
7848: -- HISTORY :
7849: -- 01-JUN-06 piagrawa o Created
7850: -- 20-MAR-07 lbala o Added code to delete from pn_var_abat_defaults_all
7851: -------------------------------------------------------------------------------
7852: PROCEDURE delete_vr_setup ( p_var_rent_id IN NUMBER
7853: ,p_new_termn_date IN DATE)
7854: IS

Line 7916: DELETE pn_var_abat_defaults_all

7912: DELETE pn_var_constr_defaults_all
7913: WHERE constr_start_date > p_new_termn_date
7914: AND var_rent_id = p_var_rent_id;
7915:
7916: DELETE pn_var_abat_defaults_all
7917: WHERE start_date > p_new_termn_date
7918: AND var_rent_id = p_var_rent_id;
7919:
7920: pnp_debug_pkg.debug ('pn_var_rent_pkg.delete_vr_setup (-)');

Line 8270: -- 20-MAR-07 lbala o Added code to update or delete pn_var_abat_defaults_all

8266: -- HISTORY :
8267: -- 01-JUN-06 piagrawa o Created
8268: -- 11-JAN-07 Prabhakar o Added the call delete_report_date_row to delete
8269: -- the report records which fall after new termination date.
8270: -- 20-MAR-07 lbala o Added code to update or delete pn_var_abat_defaults_all
8271: -- BUg # 5933345
8272: -------------------------------------------------------------------------------
8273: PROCEDURE early_terminate_setup ( p_var_rent_id IN NUMBER
8274: , p_period_id IN NUMBER

Line 8486: DELETE FROM pn_var_abat_defaults_all

8482: /* Delete all abatements whose start date is after the new max inv end date
8483: since start and end dates of abatements must correspond to that of
8484: invoice periods */
8485:
8486: DELETE FROM pn_var_abat_defaults_all
8487: WHERE var_rent_id = p_var_rent_id
8488: AND p_new_termn_date BETWEEN start_date AND end_date
8489: AND start_date > l_inv_end_dt;
8490:

Line 8492: UPDATE pn_var_abat_defaults_all

8488: AND p_new_termn_date BETWEEN start_date AND end_date
8489: AND start_date > l_inv_end_dt;
8490:
8491: /*Update all abatements so that their end date is the new max inv end date*/
8492: UPDATE pn_var_abat_defaults_all
8493: SET end_date = l_inv_end_dt
8494: WHERE var_rent_id = p_var_rent_id
8495: AND p_new_termn_date BETWEEN start_date AND end_date;
8496:

Line 8836: -- pn_var_abat_defaults_all

8832: -- REFERENCE : PN_COMMON.debug()
8833: -- HISTORY :
8834: -- 01-JUN-06 piagrawa o Created
8835: -- 20-MAR-07 lbala o Bug # 5933345, Added code to delete/update from
8836: -- pn_var_abat_defaults_all
8837: -------------------------------------------------------------------------------
8838: PROCEDURE process_vr_early_term ( p_lease_id IN NUMBER
8839: ,p_var_rent_id IN NUMBER
8840: ,p_new_termn_date IN DATE

Line 9003: DELETE FROM pn_var_abat_defaults_all

8999:
9000: /* Delete all abatements whose start date is after the new max inv end date
9001: since start and end dates of abatements must correspond to that of
9002: invoice periods */
9003: DELETE FROM pn_var_abat_defaults_all
9004: WHERE var_rent_id = var_rent_rec.var_rent_id
9005: AND p_new_termn_date BETWEEN start_date AND end_date
9006: AND start_date > l_inv_end_dt;
9007:

Line 9009: UPDATE pn_var_abat_defaults_all

9005: AND p_new_termn_date BETWEEN start_date AND end_date
9006: AND start_date > l_inv_end_dt;
9007:
9008: /*Update all abatements so that their end date is the new max inv end date*/
9009: UPDATE pn_var_abat_defaults_all
9010: SET end_date = l_inv_end_dt
9011: WHERE var_rent_id = var_rent_rec.var_rent_id
9012: AND p_new_termn_date BETWEEN start_date AND end_date;
9013: