APPS.APRX_WT dependencies on FND_DATE

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

79:
80: BEGIN
81: fa_rx_util_pkg.debug('aprx_wt.ap_wht_tax_report()+');
82: fa_rx_util_pkg.debug('p_date_from '||p_date_from);
83: fa_rx_util_pkg.debug('canonical date from '||to_char(fnd_date.canonical_to_date(p_date_from)));
84: fa_rx_util_pkg.init_request('aprx_wt.ap_wht_tax_report', request_id);
85: debug_info := 'aprx_wt.ap_wht_tax_report()+';
86: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
87: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||DBG_Loc,debug_info);

Line 93: debug_info := 'canonical date from '||to_char(fnd_date.canonical_to_date(p_date_from));

89: debug_info := 'p_date_from '||p_date_from;
90: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
91: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||DBG_Loc,debug_info);
92: END IF;
93: debug_info := 'canonical date from '||to_char(fnd_date.canonical_to_date(p_date_from));
94: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
95: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||DBG_Loc,debug_info);
96: END IF;
97:

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

458:
459: -- Add the WHERE clause which is specific to the AP Witholding Report
460:
461: IF parm.p_date_from IS NOT NULL THEN
462: fa_rx_util_pkg.Where_clause := fa_rx_util_pkg.Where_clause || ' and aid.accounting_date >= fnd_date.canonical_to_date(:b_date_from)' ;
463: END IF;
464:
465: IF parm.p_date_to IS NOT NULL THEN
466: 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 466: fa_rx_util_pkg.Where_clause := fa_rx_util_pkg.Where_clause || ' and aid.accounting_date <= fnd_date.canonical_to_date(:b_date_to) ';

462: fa_rx_util_pkg.Where_clause := fa_rx_util_pkg.Where_clause || ' and aid.accounting_date >= fnd_date.canonical_to_date(:b_date_from)' ;
463: END IF;
464:
465: IF parm.p_date_to IS NOT NULL THEN
466: fa_rx_util_pkg.Where_clause := fa_rx_util_pkg.Where_clause || ' and aid.accounting_date <= fnd_date.canonical_to_date(:b_date_to) ';
467: END IF;
468:
469: IF parm.p_supplier_from IS NOT NULL THEN
470: fa_rx_util_pkg.Where_clause := fa_rx_util_pkg.Where_clause || ' and UPPER(pv2.vendor_name) >= UPPER(:b_supplier_from)';