52:
53: --
54: -- Building date range where clause
55: --
56: D_DATE_FROM := FND_DATE.CANONICAL_TO_DATE(P_DATE_FROM);
57: D_DATE_TO := FND_DATE.CANONICAL_TO_DATE(P_DATE_TO);
58: D_DATE_FROM_DISP := FND_DATE.DATE_TO_DISPLAYDATE(dateval=>D_DATE_FROM, calendar_aware=>2);
59: D_DATE_TO_DISP := FND_DATE.DATE_TO_DISPLAYDATE(dateval=>D_DATE_TO, calendar_aware=>2);
60:
53: --
54: -- Building date range where clause
55: --
56: D_DATE_FROM := FND_DATE.CANONICAL_TO_DATE(P_DATE_FROM);
57: D_DATE_TO := FND_DATE.CANONICAL_TO_DATE(P_DATE_TO);
58: D_DATE_FROM_DISP := FND_DATE.DATE_TO_DISPLAYDATE(dateval=>D_DATE_FROM, calendar_aware=>2);
59: D_DATE_TO_DISP := FND_DATE.DATE_TO_DISPLAYDATE(dateval=>D_DATE_TO, calendar_aware=>2);
60:
61: IF ( P_DATE_FROM IS NOT NULL ) THEN
54: -- Building date range where clause
55: --
56: D_DATE_FROM := FND_DATE.CANONICAL_TO_DATE(P_DATE_FROM);
57: D_DATE_TO := FND_DATE.CANONICAL_TO_DATE(P_DATE_TO);
58: D_DATE_FROM_DISP := FND_DATE.DATE_TO_DISPLAYDATE(dateval=>D_DATE_FROM, calendar_aware=>2);
59: D_DATE_TO_DISP := FND_DATE.DATE_TO_DISPLAYDATE(dateval=>D_DATE_TO, calendar_aware=>2);
60:
61: IF ( P_DATE_FROM IS NOT NULL ) THEN
62:
55: --
56: D_DATE_FROM := FND_DATE.CANONICAL_TO_DATE(P_DATE_FROM);
57: D_DATE_TO := FND_DATE.CANONICAL_TO_DATE(P_DATE_TO);
58: D_DATE_FROM_DISP := FND_DATE.DATE_TO_DISPLAYDATE(dateval=>D_DATE_FROM, calendar_aware=>2);
59: D_DATE_TO_DISP := FND_DATE.DATE_TO_DISPLAYDATE(dateval=>D_DATE_TO, calendar_aware=>2);
60:
61: IF ( P_DATE_FROM IS NOT NULL ) THEN
62:
63: IF ( P_DATE_TO IS NOT NULL ) THEN