APPS.ZX_ZXAPJAJL_XMLP_PKG dependencies on FND_DATE

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

89: AND L2.LOOKUP_CODE = 'VOID'
90: AND L3.LOOKUP_TYPE = 'NLS REPORT PARAMETER'
91: AND L3.LOOKUP_CODE = 'NA';
92: BEGIN
93: L_CANONICAL_DATE := FND_DATE.DATE_TO_CANONICAL(P_GL_DATE_LOW);
94: P_TW_GL_DATE_LOW := TO_CHAR(TO_NUMBER(SUBSTRB(L_CANONICAL_DATE
95: ,1
96: ,4)) - 1911) || '/' || SUBSTRB(L_CANONICAL_DATE
97: ,6

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

95: ,1
96: ,4)) - 1911) || '/' || SUBSTRB(L_CANONICAL_DATE
97: ,6
98: ,5);
99: L_CANONICAL_DATE := FND_DATE.DATE_TO_CANONICAL(P_GL_DATE_HIGH);
100: P_TW_GL_DATE_HIGH := TO_CHAR(TO_NUMBER(SUBSTRB(L_CANONICAL_DATE
101: ,1
102: ,4)) - 1911) || '/' || SUBSTRB(L_CANONICAL_DATE
103: ,6

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

101: ,1
102: ,4)) - 1911) || '/' || SUBSTRB(L_CANONICAL_DATE
103: ,6
104: ,5);
105: L_CANONICAL_DATE := FND_DATE.DATE_TO_CANONICAL(P_TRX_DATE_LOW);
106: P_TW_TRX_DATE_LOW := TO_CHAR(TO_NUMBER(SUBSTRB(L_CANONICAL_DATE
107: ,1
108: ,4)) - 1911) || '/' || SUBSTRB(L_CANONICAL_DATE
109: ,6

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

107: ,1
108: ,4)) - 1911) || '/' || SUBSTRB(L_CANONICAL_DATE
109: ,6
110: ,5);
111: L_CANONICAL_DATE := FND_DATE.DATE_TO_CANONICAL(P_TRX_DATE_HIGH);
112: P_TW_TRX_DATE_HIGH := TO_CHAR(TO_NUMBER(SUBSTRB(L_CANONICAL_DATE
113: ,1
114: ,4)) - 1911) || '/' || SUBSTRB(L_CANONICAL_DATE
115: ,6

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

345: BEGIN
346: IF P_DATE IS NULL THEN
347: RETURN (NULL);
348: END IF;
349: L_CANONICAL_DATE := FND_DATE.DATE_TO_CANONICAL(L_DATE);
350: L_ROC_YEAR := TO_NUMBER(SUBSTRB(L_CANONICAL_DATE
351: ,1
352: ,4)) - 1911;
353: L_ROC_MMDD := SUBSTRB(L_CANONICAL_DATE