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_REC_CALC_PKG dependencies on FND_DATE

Line 85: trunc(fnd_date.canonical_to_date(p_calc_period_ending));

81: l_start_date pn_rec_calc_periods_all.start_date%TYPE;
82: l_end_date pn_rec_calc_periods_all.end_date%TYPE ;
83: l_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE ;
84: l_calc_period_ending pn_rec_calc_periods_all.end_date%TYPE :=
85: trunc(fnd_date.canonical_to_date(p_calc_period_ending));
86:
87: l_error VARCHAR2(2000) := 'Success';
88: l_error_code NUMBER := 0;
89:

Line 239: l_start_date := TRUNC(fnd_date.canonical_to_date(p_calc_period_startdate));

235:
236: pnp_debug_pkg.log('PN_REC_CALC_PKG.CALCULATE_REC_AMOUNT_BATCH (+) ');
237: l_rec_calc_period_id := p_rec_calc_period_id;
238:
239: l_start_date := TRUNC(fnd_date.canonical_to_date(p_calc_period_startdate));
240: l_end_date := TRUNC(fnd_date.canonical_to_date(p_calc_period_enddate));
241: l_as_of_date := TRUNC(fnd_date.canonical_to_date(p_as_ofdate));
242:
243: fnd_message.set_name ('PN','PN_RECALC_AGR_BATCH_INP_PARAM');

Line 240: l_end_date := TRUNC(fnd_date.canonical_to_date(p_calc_period_enddate));

236: pnp_debug_pkg.log('PN_REC_CALC_PKG.CALCULATE_REC_AMOUNT_BATCH (+) ');
237: l_rec_calc_period_id := p_rec_calc_period_id;
238:
239: l_start_date := TRUNC(fnd_date.canonical_to_date(p_calc_period_startdate));
240: l_end_date := TRUNC(fnd_date.canonical_to_date(p_calc_period_enddate));
241: l_as_of_date := TRUNC(fnd_date.canonical_to_date(p_as_ofdate));
242:
243: fnd_message.set_name ('PN','PN_RECALC_AGR_BATCH_INP_PARAM');
244: fnd_message.set_token ('AGR_ID',p_rec_agreement_id);

Line 241: l_as_of_date := TRUNC(fnd_date.canonical_to_date(p_as_ofdate));

237: l_rec_calc_period_id := p_rec_calc_period_id;
238:
239: l_start_date := TRUNC(fnd_date.canonical_to_date(p_calc_period_startdate));
240: l_end_date := TRUNC(fnd_date.canonical_to_date(p_calc_period_enddate));
241: l_as_of_date := TRUNC(fnd_date.canonical_to_date(p_as_ofdate));
242:
243: fnd_message.set_name ('PN','PN_RECALC_AGR_BATCH_INP_PARAM');
244: fnd_message.set_token ('AGR_ID',p_rec_agreement_id);
245: fnd_message.set_token ('LEASE_ID',l_lease_id);

Line 544: l_start_date pn_rec_calc_periods_all.start_date%TYPE := fnd_date.canonical_to_date(p_calc_period_startdate); --Bug#6438840

540: l_lease_id pn_rec_agreements_all.lease_id%TYPE := NULL;
541: l_location_id pn_rec_agreements_all.location_id%TYPE := NULL;
542: l_customer_id pn_rec_agreements_all.customer_id%TYPE := NULL;
543: l_cust_site_id pn_rec_agreements_all.cust_site_id%TYPE := NULL;
544: l_start_date pn_rec_calc_periods_all.start_date%TYPE := fnd_date.canonical_to_date(p_calc_period_startdate); --Bug#6438840
545: l_end_date pn_rec_calc_periods_all.end_date%TYPE := fnd_date.canonical_to_date(p_calc_period_enddate); --Bug#6438840
546: l_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE := fnd_date.canonical_to_date(p_as_ofdate); --Bug#6438840
547: l_calc_period_ending pn_rec_calc_periods_all.end_date%TYPE :=
548: trunc(fnd_date.canonical_to_date(p_calc_period_ending));

Line 545: l_end_date pn_rec_calc_periods_all.end_date%TYPE := fnd_date.canonical_to_date(p_calc_period_enddate); --Bug#6438840

541: l_location_id pn_rec_agreements_all.location_id%TYPE := NULL;
542: l_customer_id pn_rec_agreements_all.customer_id%TYPE := NULL;
543: l_cust_site_id pn_rec_agreements_all.cust_site_id%TYPE := NULL;
544: l_start_date pn_rec_calc_periods_all.start_date%TYPE := fnd_date.canonical_to_date(p_calc_period_startdate); --Bug#6438840
545: l_end_date pn_rec_calc_periods_all.end_date%TYPE := fnd_date.canonical_to_date(p_calc_period_enddate); --Bug#6438840
546: l_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE := fnd_date.canonical_to_date(p_as_ofdate); --Bug#6438840
547: l_calc_period_ending pn_rec_calc_periods_all.end_date%TYPE :=
548: trunc(fnd_date.canonical_to_date(p_calc_period_ending));
549:

Line 546: l_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE := fnd_date.canonical_to_date(p_as_ofdate); --Bug#6438840

542: l_customer_id pn_rec_agreements_all.customer_id%TYPE := NULL;
543: l_cust_site_id pn_rec_agreements_all.cust_site_id%TYPE := NULL;
544: l_start_date pn_rec_calc_periods_all.start_date%TYPE := fnd_date.canonical_to_date(p_calc_period_startdate); --Bug#6438840
545: l_end_date pn_rec_calc_periods_all.end_date%TYPE := fnd_date.canonical_to_date(p_calc_period_enddate); --Bug#6438840
546: l_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE := fnd_date.canonical_to_date(p_as_ofdate); --Bug#6438840
547: l_calc_period_ending pn_rec_calc_periods_all.end_date%TYPE :=
548: trunc(fnd_date.canonical_to_date(p_calc_period_ending));
549:
550: l_error VARCHAR2(2000) := 'Success';

Line 548: trunc(fnd_date.canonical_to_date(p_calc_period_ending));

544: l_start_date pn_rec_calc_periods_all.start_date%TYPE := fnd_date.canonical_to_date(p_calc_period_startdate); --Bug#6438840
545: l_end_date pn_rec_calc_periods_all.end_date%TYPE := fnd_date.canonical_to_date(p_calc_period_enddate); --Bug#6438840
546: l_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE := fnd_date.canonical_to_date(p_as_ofdate); --Bug#6438840
547: l_calc_period_ending pn_rec_calc_periods_all.end_date%TYPE :=
548: trunc(fnd_date.canonical_to_date(p_calc_period_ending));
549:
550: l_error VARCHAR2(2000) := 'Success';
551: l_error_code NUMBER := 0;
552: