DBA Data[Home] [Help]

APPS.FV_FACTS_TRX_REGISTER dependencies on FND_DATE

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

264: g_from_period_name := p_from_period_name;
265: g_to_period_name := p_to_period_name ;
266: g_from_gl_posted_date := NULL;
267: IF (p_from_gl_posted_date IS NOT NULL) THEN
268: g_from_gl_posted_date := FND_DATE.CANONICAL_TO_DATE(p_from_gl_posted_date);
269: ELSE
270: g_from_gl_posted_date := TO_DATE('01/01/1900', 'DD/MM/RRRR');
271: END IF;
272: g_to_gl_posted_date := NULL;

Line 274: 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');

270: g_from_gl_posted_date := TO_DATE('01/01/1900', 'DD/MM/RRRR');
271: END IF;
272: g_to_gl_posted_date := NULL;
273: IF (p_to_gl_posted_date IS NOT NULL) THEN
274: 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');
275: ELSE
276: g_to_gl_posted_date := TO_DATE('31/12/9999', 'DD/MM/RRRR');
277: END IF;
278: