76: SELECT
77: FND_DATE.DATE_TO_CHARDT(SYSDATE)
78: INTO P_SYSTEM_DATE
79: FROM
80: DUAL;
81: END;
82: BEGIN
83: SELECT
84: FND_DATE.DATE_TO_CHARDATE(TRUNC(FND_DATE.CANONICAL_TO_DATE(P_DATE_FROM)))
83: SELECT
84: FND_DATE.DATE_TO_CHARDATE(TRUNC(FND_DATE.CANONICAL_TO_DATE(P_DATE_FROM)))
85: INTO P_DATE_FROM_FORMATTING
86: FROM
87: DUAL;
88: END;
89: BEGIN
90: SELECT
91: FND_DATE.DATE_TO_CHARDATE(TRUNC(FND_DATE.CANONICAL_TO_DATE(P_DATE_TO)))
90: SELECT
91: FND_DATE.DATE_TO_CHARDATE(TRUNC(FND_DATE.CANONICAL_TO_DATE(P_DATE_TO)))
92: INTO P_DATE_TO_FORMATTING
93: FROM
94: DUAL;
95: END;
96: BEGIN
97: SELECT
98: FC.EXTENDED_PRECISION,