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 238: l_start_date := TRUNC(fnd_date.canonical_to_date(p_calc_period_startdate));

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

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

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

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

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

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

515: l_lease_id pn_rec_agreements_all.lease_id%TYPE := NULL;
516: l_location_id pn_rec_agreements_all.location_id%TYPE := NULL;
517: l_customer_id pn_rec_agreements_all.customer_id%TYPE := NULL;
518: l_cust_site_id pn_rec_agreements_all.cust_site_id%TYPE := NULL;
519: l_start_date pn_rec_calc_periods_all.start_date%TYPE := fnd_date.canonical_to_date(p_calc_period_startdate); --Bug#6438840
520: l_end_date pn_rec_calc_periods_all.end_date%TYPE := fnd_date.canonical_to_date(p_calc_period_enddate); --Bug#6438840
521: l_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE := fnd_date.canonical_to_date(p_as_ofdate); --Bug#6438840
522: l_calc_period_ending pn_rec_calc_periods_all.end_date%TYPE :=
523: trunc(fnd_date.canonical_to_date(p_calc_period_ending));

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

516: l_location_id pn_rec_agreements_all.location_id%TYPE := NULL;
517: l_customer_id pn_rec_agreements_all.customer_id%TYPE := NULL;
518: l_cust_site_id pn_rec_agreements_all.cust_site_id%TYPE := NULL;
519: l_start_date pn_rec_calc_periods_all.start_date%TYPE := fnd_date.canonical_to_date(p_calc_period_startdate); --Bug#6438840
520: l_end_date pn_rec_calc_periods_all.end_date%TYPE := fnd_date.canonical_to_date(p_calc_period_enddate); --Bug#6438840
521: l_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE := fnd_date.canonical_to_date(p_as_ofdate); --Bug#6438840
522: l_calc_period_ending pn_rec_calc_periods_all.end_date%TYPE :=
523: trunc(fnd_date.canonical_to_date(p_calc_period_ending));
524:

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

517: l_customer_id pn_rec_agreements_all.customer_id%TYPE := NULL;
518: l_cust_site_id pn_rec_agreements_all.cust_site_id%TYPE := NULL;
519: l_start_date pn_rec_calc_periods_all.start_date%TYPE := fnd_date.canonical_to_date(p_calc_period_startdate); --Bug#6438840
520: l_end_date pn_rec_calc_periods_all.end_date%TYPE := fnd_date.canonical_to_date(p_calc_period_enddate); --Bug#6438840
521: l_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE := fnd_date.canonical_to_date(p_as_ofdate); --Bug#6438840
522: l_calc_period_ending pn_rec_calc_periods_all.end_date%TYPE :=
523: trunc(fnd_date.canonical_to_date(p_calc_period_ending));
524:
525: l_error VARCHAR2(2000) := 'Success';

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

519: l_start_date pn_rec_calc_periods_all.start_date%TYPE := fnd_date.canonical_to_date(p_calc_period_startdate); --Bug#6438840
520: l_end_date pn_rec_calc_periods_all.end_date%TYPE := fnd_date.canonical_to_date(p_calc_period_enddate); --Bug#6438840
521: l_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE := fnd_date.canonical_to_date(p_as_ofdate); --Bug#6438840
522: l_calc_period_ending pn_rec_calc_periods_all.end_date%TYPE :=
523: trunc(fnd_date.canonical_to_date(p_calc_period_ending));
524:
525: l_error VARCHAR2(2000) := 'Success';
526: l_error_code NUMBER := 0;
527: