30: pnp_debug_pkg.put_log_msg('pnp_rxi_rep.purge - deleted PN_SPACE_ASSIGN_LOC_ITF');
31:
32: ELSIF (p_report_name = 'SPALEA') THEN
33:
34: pnp_debug_pkg.put_log_msg('pnp_rxi_rep.purge - deleting PN_SPACE_ASSIGN_LEASE_ITF');
35:
36: delete PN_SPACE_ASSIGN_LEASE_ITF
37: where creation_date between l_date_from and l_date_to;
38:
32: ELSIF (p_report_name = 'SPALEA') THEN
33:
34: pnp_debug_pkg.put_log_msg('pnp_rxi_rep.purge - deleting PN_SPACE_ASSIGN_LEASE_ITF');
35:
36: delete PN_SPACE_ASSIGN_LEASE_ITF
37: where creation_date between l_date_from and l_date_to;
38:
39: pnp_debug_pkg.put_log_msg('pnp_rxi_rep.purge - deleted PN_SPACE_ASSIGN_LEASE_ITF');
40:
35:
36: delete PN_SPACE_ASSIGN_LEASE_ITF
37: where creation_date between l_date_from and l_date_to;
38:
39: pnp_debug_pkg.put_log_msg('pnp_rxi_rep.purge - deleted PN_SPACE_ASSIGN_LEASE_ITF');
40:
41: ELSIF (p_report_name = 'SPULOC') THEN
42:
43: pnp_debug_pkg.put_log_msg('pnp_rxi_rep.purge - deleting PN_SPACE_UTIL_LOC_ITF');