APPS.APRX_WT dependencies on FND_DATE

Line 62: fa_rx_util_pkg.debug('canonical date from '||to_char(fnd_date.canonical_to_date(p_date_from)));

58: IS
59: BEGIN
60: fa_rx_util_pkg.debug('aprx_wt.ap_wht_tax_report()+');
61: fa_rx_util_pkg.debug('p_date_from '||p_date_from);
62: fa_rx_util_pkg.debug('canonical date from '||to_char(fnd_date.canonical_to_date(p_date_from)));
63: fa_rx_util_pkg.init_request('aprx_wt.ap_wht_tax_report', request_id);
64:
65: -- Store the paremters in a variable which can be accesed globally accross all procedures
66: parm.p_date_from := p_date_from;

Line 364: fa_rx_util_pkg.Where_clause := fa_rx_util_pkg.Where_clause || ' and aid.accounting_date >= fnd_date.canonical_to_date(:b_date_from)' ;

360:
361: -- Add the WHERE clause which is specific to the AP Witholding Report
362:
363: IF parm.p_date_from IS NOT NULL THEN
364: fa_rx_util_pkg.Where_clause := fa_rx_util_pkg.Where_clause || ' and aid.accounting_date >= fnd_date.canonical_to_date(:b_date_from)' ;
365: END IF;
366:
367: IF parm.p_date_to IS NOT NULL THEN
368: fa_rx_util_pkg.Where_clause := fa_rx_util_pkg.Where_clause || ' and aid.accounting_date <= fnd_date.canonical_to_date(:b_date_to) ';

Line 368: fa_rx_util_pkg.Where_clause := fa_rx_util_pkg.Where_clause || ' and aid.accounting_date <= fnd_date.canonical_to_date(:b_date_to) ';

364: fa_rx_util_pkg.Where_clause := fa_rx_util_pkg.Where_clause || ' and aid.accounting_date >= fnd_date.canonical_to_date(:b_date_from)' ;
365: END IF;
366:
367: IF parm.p_date_to IS NOT NULL THEN
368: fa_rx_util_pkg.Where_clause := fa_rx_util_pkg.Where_clause || ' and aid.accounting_date <= fnd_date.canonical_to_date(:b_date_to) ';
369:
370: END IF;
371:
372: IF parm.p_supplier_from IS NOT NULL THEN