DBA Data[Home] [Help]

APPS.FV_FACTS_TRX_REGISTER dependencies on FND_DATE

Line 254: g_from_gl_posted_date := FND_DATE.CANONICAL_TO_DATE(p_from_gl_posted_date);

250: g_from_period_name := p_from_period_name;
251: g_to_period_name := p_to_period_name ;
252: g_from_gl_posted_date := NULL;
253: IF (p_from_gl_posted_date IS NOT NULL) THEN
254: g_from_gl_posted_date := FND_DATE.CANONICAL_TO_DATE(p_from_gl_posted_date);
255: ELSE
256: g_from_gl_posted_date := TO_DATE('01/01/1900', 'DD/MM/RRRR');
257: END IF;
258: g_to_gl_posted_date := NULL;

Line 260: g_to_gl_posted_date := TO_DATE(TO_CHAR(FND_DATE.CANONICAL_TO_DATE(p_to_gl_posted_date), 'DD/MM/RRRR')||' 23:59:59', 'DD/MM/RRRR HH24:MI:SS');

256: g_from_gl_posted_date := TO_DATE('01/01/1900', 'DD/MM/RRRR');
257: END IF;
258: g_to_gl_posted_date := NULL;
259: IF (p_to_gl_posted_date IS NOT NULL) THEN
260: g_to_gl_posted_date := TO_DATE(TO_CHAR(FND_DATE.CANONICAL_TO_DATE(p_to_gl_posted_date), 'DD/MM/RRRR')||' 23:59:59', 'DD/MM/RRRR HH24:MI:SS');
261: ELSE
262: g_to_gl_posted_date := TO_DATE('31/12/9999', 'DD/MM/RRRR');
263: END IF;
264: