DBA Data[Home] [Help]

APPS.PN_RXI_REP dependencies on FND_DATE

Line 20: l_date_from := fnd_date.canonical_to_date(nvl(p_date_from,'0001/01/01 00:00:00'));

16: BEGIN
17:
18: pnp_debug_pkg.put_log_msg('pnp_rxi_rep.purge(+)');
19:
20: l_date_from := fnd_date.canonical_to_date(nvl(p_date_from,'0001/01/01 00:00:00'));
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:

Line 21: l_date_to := fnd_date.canonical_to_date(nvl(p_date_to,'4712/12/31 00:00:00'));

17:
18: pnp_debug_pkg.put_log_msg('pnp_rxi_rep.purge(+)');
19:
20: l_date_from := fnd_date.canonical_to_date(nvl(p_date_from,'0001/01/01 00:00:00'));
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');