DBA Data[Home] [Help]

APPS.PN_RXI_REP dependencies on PN_SPACE_ASSIGN_LOC_ITF

Line 25: pnp_debug_pkg.put_log_msg('pnp_rxi_rep.purge - deleting PN_SPACE_ASSIGN_LOC_ITF');

21: l_date_to := fnd_date.canonical_to_date(nvl(p_date_to,'4712/12/31 00:00:00'));
22:
23: IF (p_report_name = 'SPALOC') THEN
24:
25: pnp_debug_pkg.put_log_msg('pnp_rxi_rep.purge - deleting PN_SPACE_ASSIGN_LOC_ITF');
26:
27: delete PN_SPACE_ASSIGN_LOC_ITF
28: where creation_date between l_date_from and l_date_to;
29:

Line 27: delete PN_SPACE_ASSIGN_LOC_ITF

23: IF (p_report_name = 'SPALOC') THEN
24:
25: pnp_debug_pkg.put_log_msg('pnp_rxi_rep.purge - deleting PN_SPACE_ASSIGN_LOC_ITF');
26:
27: delete PN_SPACE_ASSIGN_LOC_ITF
28: where creation_date between l_date_from and l_date_to;
29:
30: pnp_debug_pkg.put_log_msg('pnp_rxi_rep.purge - deleted PN_SPACE_ASSIGN_LOC_ITF');
31:

Line 30: pnp_debug_pkg.put_log_msg('pnp_rxi_rep.purge - deleted PN_SPACE_ASSIGN_LOC_ITF');

26:
27: delete PN_SPACE_ASSIGN_LOC_ITF
28: where creation_date between l_date_from and l_date_to;
29:
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');