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.CST_REVENUECOGSMATCH_PVT dependencies on FND_DATE

Line 243: l_low_date := fnd_date.canonical_to_date(p_low_date);

239:
240: IF ( p_phase = 2 ) THEN
241:
242: -- convert input parameters to dates
243: l_low_date := fnd_date.canonical_to_date(p_low_date);
244: l_high_date := trunc(fnd_date.canonical_to_date(p_high_date))+0.99999;
245: IF (l_low_date IS NULL) THEN
246: l_low_date := sysdate - (365*20); -- go back 20 years
247: END IF;

Line 244: l_high_date := trunc(fnd_date.canonical_to_date(p_high_date))+0.99999;

240: IF ( p_phase = 2 ) THEN
241:
242: -- convert input parameters to dates
243: l_low_date := fnd_date.canonical_to_date(p_low_date);
244: l_high_date := trunc(fnd_date.canonical_to_date(p_high_date))+0.99999;
245: IF (l_low_date IS NULL) THEN
246: l_low_date := sysdate - (365*20); -- go back 20 years
247: END IF;
248: -- prevent the collection of future revenue recognition events

Line 5351: l_sales_order_date_low := trunc(fnd_date.canonical_to_date(p_sales_order_date_low));

5347:
5348: --set the date parameters if the user has not
5349:
5350: if(p_sales_order_date_low is not null) then
5351: l_sales_order_date_low := trunc(fnd_date.canonical_to_date(p_sales_order_date_low));
5352: else
5353: l_sales_order_date_low := sysdate - 7200;
5354: end if;
5355:

Line 5357: l_sales_order_date_high := trunc(fnd_date.canonical_to_date(p_sales_order_date_high));

5353: l_sales_order_date_low := sysdate - 7200;
5354: end if;
5355:
5356: if(p_sales_order_date_high is not null) then
5357: l_sales_order_date_high := trunc(fnd_date.canonical_to_date(p_sales_order_date_high));
5358: else
5359: l_sales_order_date_high := sysdate + 1;
5360: end if;
5361: