DBA Data[Home] [Help]

APPS.CST_REVENUECOGSMATCH_PVT dependencies on FND_DATE

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

300:
301: IF ( p_phase = 2 ) THEN
302:
303: -- convert input parameters to dates
304: l_low_date := fnd_date.canonical_to_date(p_low_date);
305: l_high_date := trunc(fnd_date.canonical_to_date(p_high_date))+EndDateNum;
306: IF (l_low_date IS NULL) THEN
307: l_low_date := sysdate - (365*20); -- go back 20 years
308: END IF;

Line 305: l_high_date := trunc(fnd_date.canonical_to_date(p_high_date))+EndDateNum;

301: IF ( p_phase = 2 ) THEN
302:
303: -- convert input parameters to dates
304: l_low_date := fnd_date.canonical_to_date(p_low_date);
305: l_high_date := trunc(fnd_date.canonical_to_date(p_high_date))+EndDateNum;
306: IF (l_low_date IS NULL) THEN
307: l_low_date := sysdate - (365*20); -- go back 20 years
308: END IF;
309: -- prevent the collection of future revenue recognition events

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

5466:
5467: --set the date parameters if the user has not
5468:
5469: if(p_sales_order_date_low is not null) then
5470: l_sales_order_date_low := trunc(fnd_date.canonical_to_date(p_sales_order_date_low));
5471: else
5472: l_sales_order_date_low := sysdate - 7200;
5473: end if;
5474:

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

5472: l_sales_order_date_low := sysdate - 7200;
5473: end if;
5474:
5475: if(p_sales_order_date_high is not null) then
5476: l_sales_order_date_high := trunc(fnd_date.canonical_to_date(p_sales_order_date_high));
5477: else
5478: l_sales_order_date_high := sysdate + 1;
5479: end if;
5480: