APPS.BEN_PURGE_BCKDT_VOIDED dependencies on FND_DATE

Line 380: l_effective_date := trunc(fnd_date.canonical_to_date(p_effective_date));

376: --
377: l_effective_date := to_date(to_char(trunc(l_effective_date)
378: ,'DD/MM/RRRR'),'DD/MM/RRRR');
379: */
380: l_effective_date := trunc(fnd_date.canonical_to_date(p_effective_date));
381: l_from_ocrd_date:=trunc(fnd_date.canonical_to_date(p_from_ocrd_date));
382: l_to_ocrd_date:=trunc(fnd_date.canonical_to_date(p_to_ocrd_date));
383:
384: -- Put row in fnd_sessions

Line 381: l_from_ocrd_date:=trunc(fnd_date.canonical_to_date(p_from_ocrd_date));

377: l_effective_date := to_date(to_char(trunc(l_effective_date)
378: ,'DD/MM/RRRR'),'DD/MM/RRRR');
379: */
380: l_effective_date := trunc(fnd_date.canonical_to_date(p_effective_date));
381: l_from_ocrd_date:=trunc(fnd_date.canonical_to_date(p_from_ocrd_date));
382: l_to_ocrd_date:=trunc(fnd_date.canonical_to_date(p_to_ocrd_date));
383:
384: -- Put row in fnd_sessions
385: --

Line 382: l_to_ocrd_date:=trunc(fnd_date.canonical_to_date(p_to_ocrd_date));

378: ,'DD/MM/RRRR'),'DD/MM/RRRR');
379: */
380: l_effective_date := trunc(fnd_date.canonical_to_date(p_effective_date));
381: l_from_ocrd_date:=trunc(fnd_date.canonical_to_date(p_from_ocrd_date));
382: l_to_ocrd_date:=trunc(fnd_date.canonical_to_date(p_to_ocrd_date));
383:
384: -- Put row in fnd_sessions
385: --
386: dt_fndate.change_ses_date

Line 876: l_effective_date := trunc(fnd_date.canonical_to_date(p_effective_date));

872: l_effective_date := to_date(p_effective_date,'YYYY/MM/DD HH24:MI:SS');
873: l_effective_date := to_date(to_char(trunc(l_effective_date),'DD/MM/RRRR')
874: ,'DD/MM/RRRR');
875: */
876: l_effective_date := trunc(fnd_date.canonical_to_date(p_effective_date));
877: l_from_ocrd_date :=trunc(fnd_date.canonical_to_date(p_from_ocrd_date));
878: l_to_ocrd_date :=trunc(fnd_date.canonical_to_date(p_to_ocrd_date));
879: --
880: -- Put row in fnd_sessions

Line 877: l_from_ocrd_date :=trunc(fnd_date.canonical_to_date(p_from_ocrd_date));

873: l_effective_date := to_date(to_char(trunc(l_effective_date),'DD/MM/RRRR')
874: ,'DD/MM/RRRR');
875: */
876: l_effective_date := trunc(fnd_date.canonical_to_date(p_effective_date));
877: l_from_ocrd_date :=trunc(fnd_date.canonical_to_date(p_from_ocrd_date));
878: l_to_ocrd_date :=trunc(fnd_date.canonical_to_date(p_to_ocrd_date));
879: --
880: -- Put row in fnd_sessions
881: --

Line 878: l_to_ocrd_date :=trunc(fnd_date.canonical_to_date(p_to_ocrd_date));

874: ,'DD/MM/RRRR');
875: */
876: l_effective_date := trunc(fnd_date.canonical_to_date(p_effective_date));
877: l_from_ocrd_date :=trunc(fnd_date.canonical_to_date(p_from_ocrd_date));
878: l_to_ocrd_date :=trunc(fnd_date.canonical_to_date(p_to_ocrd_date));
879: --
880: -- Put row in fnd_sessions
881: --
882: dt_fndate.change_ses_date

Line 1175: fnd_date.date_to_canonical(process_date) process_date

1171: --
1172: cursor c_parameters
1173: is
1174: select --to_char(process_date, 'YYYY/MM/DD HH24:MI:SS') process_date
1175: fnd_date.date_to_canonical(process_date) process_date
1176: ,business_group_id
1177: ,person_id
1178: ,person_selection_rl
1179: --,life_event_id