eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PN_VARIABLE_AMOUNT_PKG dependencies on FND_DATE

Line 2265: -- Added fnd_date.canonical_to_date before

2261: -- process_rent_batch, CURSOR csr_get_per for Mass
2262: -- Calculate Variable Rent.
2263: -- 09-Jan-03 DThota o Changed p_period_date parameter to VARCHAR2 from
2264: -- DATE in process_rent_batch, CURSOR csr_get_per.
2265: -- Added fnd_date.canonical_to_date before
2266: -- p_period_date in the WHERE clause.
2267: -- Fix for bug # 2733870
2268: -- 23-Jan-03 DThota o Removed comparison of pn_periods_all.end_date
2269: -- to p_period_date from the predicate of the

Line 2348: AND start_date <= NVL(fnd_date.canonical_to_date(p_period_date),TO_DATE('12/31/4712','mm/dd/yyyy'))

2344: end_date
2345: FROM pn_var_periods_all
2346: WHERE var_rent_id = ip_var_rent_id
2347: AND period_id = NVL(p_period_id,period_id)
2348: AND start_date <= NVL(fnd_date.canonical_to_date(p_period_date),TO_DATE('12/31/4712','mm/dd/yyyy'))
2349: AND period_num >= NVL(p_period_num_from,period_num)
2350: AND period_num <= NVL(p_period_num_to,period_num);
2351:
2352: /* Get all the invoice dates for a period when doing reconciliation */

Line 2393: g_period_date := NVL(fnd_date.canonical_to_date(p_period_date),TO_DATE('12/31/4712','mm/dd/yyyy'));

2389:
2390:
2391: BEGIN
2392: pnp_debug_pkg.log('pn_variable_amount_pkg.process_rent_batch (+)' );
2393: g_period_date := NVL(fnd_date.canonical_to_date(p_period_date),TO_DATE('12/31/4712','mm/dd/yyyy'));
2394:
2395: fnd_message.set_name ('PN','PN_VRAM_PRM');
2396: fnd_message.set_token ('LSNO_FRM', p_lease_num_from);
2397: fnd_message.set_token ('LSNO_TO', p_lease_num_to);