DBA Data[Home] [Help]

APPS.ZX_ZXARRECV_XMLP_PKG dependencies on FND_DATE

Line 239: L_CANONICAL_DATE := FND_DATE.DATE_TO_CANONICAL(P_GL_DATE_LOW);

235: IF SET_REPORT_TITLE <> TRUE THEN
236: RETURN FALSE;
237: END IF;
238: BEGIN
239: L_CANONICAL_DATE := FND_DATE.DATE_TO_CANONICAL(P_GL_DATE_LOW);
240: P_TW_GL_DATE_LOW := TO_CHAR(TO_NUMBER(SUBSTRB(L_CANONICAL_DATE
241: ,1
242: ,4)) - 1911) || '/' || SUBSTRB(L_CANONICAL_DATE
243: ,6

Line 245: L_CANONICAL_DATE := FND_DATE.DATE_TO_CANONICAL(P_GL_DATE_HIGH);

241: ,1
242: ,4)) - 1911) || '/' || SUBSTRB(L_CANONICAL_DATE
243: ,6
244: ,5);
245: L_CANONICAL_DATE := FND_DATE.DATE_TO_CANONICAL(P_GL_DATE_HIGH);
246: P_TW_GL_DATE_HIGH := TO_CHAR(TO_NUMBER(SUBSTRB(L_CANONICAL_DATE
247: ,1
248: ,4)) - 1911) || '/' || SUBSTRB(L_CANONICAL_DATE
249: ,6

Line 251: L_CANONICAL_DATE := FND_DATE.DATE_TO_CANONICAL(P_TRX_DATE_LOW);

247: ,1
248: ,4)) - 1911) || '/' || SUBSTRB(L_CANONICAL_DATE
249: ,6
250: ,5);
251: L_CANONICAL_DATE := FND_DATE.DATE_TO_CANONICAL(P_TRX_DATE_LOW);
252: P_TW_TRX_DATE_LOW := TO_CHAR(TO_NUMBER(SUBSTRB(L_CANONICAL_DATE
253: ,1
254: ,4)) - 1911) || '/' || SUBSTRB(L_CANONICAL_DATE
255: ,6

Line 257: L_CANONICAL_DATE := FND_DATE.DATE_TO_CANONICAL(P_TRX_DATE_HIGH);

253: ,1
254: ,4)) - 1911) || '/' || SUBSTRB(L_CANONICAL_DATE
255: ,6
256: ,5);
257: L_CANONICAL_DATE := FND_DATE.DATE_TO_CANONICAL(P_TRX_DATE_HIGH);
258: P_TW_TRX_DATE_HIGH := TO_CHAR(TO_NUMBER(SUBSTRB(L_CANONICAL_DATE
259: ,1
260: ,4)) - 1911) || '/' || SUBSTRB(L_CANONICAL_DATE
261: ,6

Line 490: L_CANONICAL_DATE := FND_DATE.DATE_TO_CANONICAL(L_DATE);

486: BEGIN
487: IF P_DATE IS NULL THEN
488: RETURN (NULL);
489: END IF;
490: L_CANONICAL_DATE := FND_DATE.DATE_TO_CANONICAL(L_DATE);
491: L_ROC_YEAR := TO_NUMBER(SUBSTRB(L_CANONICAL_DATE
492: ,1
493: ,4)) - 1911;
494: L_ROC_MMDD := SUBSTRB(L_CANONICAL_DATE