DBA Data[Home] [Help]

APPS.PQP_GB_MANAGE_LIFE_EVENTS dependencies on FND_DATE

Line 61: debug(fnd_date.date_to_canonical(p_trace_date));

57: PROCEDURE debug
58: (p_trace_date IN DATE )
59: IS
60: BEGIN
61: debug(fnd_date.date_to_canonical(p_trace_date));
62: END debug;
63: --
64: --
65: --

Line 340: l_effective_date_canonical := fnd_date.date_to_canonical(p_absence_end_date);

336: l_proc_step := 35;
337: debug(l_proc_name,l_proc_step);
338: END IF;
339:
340: l_effective_date_canonical := fnd_date.date_to_canonical(p_absence_end_date);
341:
342: ELSIF p_absence_start_date IS NOT NULL
343: THEN
344:

Line 350: l_effective_date_canonical := fnd_date.date_to_canonical(p_absence_start_date);

346: l_proc_step := 35;
347: debug(l_proc_name,l_proc_step);
348: END IF;
349:
350: l_effective_date_canonical := fnd_date.date_to_canonical(p_absence_start_date);
351:
352: ELSE
353:
354: IF g_debug THEN

Line 364: l_effective_date_canonical := fnd_date.date_to_canonical(p_effective_date);

360: -- a) Absence has been deleted OR
361: -- b) User pressed button on Absence in an empty new record.
362: --
363: -- setting p_effective_date as effective date
364: l_effective_date_canonical := fnd_date.date_to_canonical(p_effective_date);
365:
366: END IF;
367:
368: IF g_debug THEN

Line 374: fnd_date.canonical_to_date(l_effective_date_canonical);

370: debug(l_proc_name,l_proc_step);
371: END IF;
372:
373: l_effective_date :=
374: fnd_date.canonical_to_date(l_effective_date_canonical);
375:
376: get_last_ben_report -- before run
377: (p_person_id => p_person_id
378: ,p_process_date => l_effective_date