109: --
110: l_first_day_of_month:=to_date(p_first_day_of_month,'YYYY/MM/DD HH24:MI:SS');
111: l_first_day_of_month:=to_date(to_char(trunc(l_first_day_of_month),'DD/MM/RRRR'),'DD/MM/RRRR');
112: */
113: l_effective_date := trunc(fnd_date.canonical_to_date(p_effective_date));
114: l_first_day_of_month := trunc(fnd_date.canonical_to_date(p_first_day_of_month));
115: -- Put row in fnd_sessions
116: --
117: dt_fndate.change_ses_date
110: l_first_day_of_month:=to_date(p_first_day_of_month,'YYYY/MM/DD HH24:MI:SS');
111: l_first_day_of_month:=to_date(to_char(trunc(l_first_day_of_month),'DD/MM/RRRR'),'DD/MM/RRRR');
112: */
113: l_effective_date := trunc(fnd_date.canonical_to_date(p_effective_date));
114: l_first_day_of_month := trunc(fnd_date.canonical_to_date(p_first_day_of_month));
115: -- Put row in fnd_sessions
116: --
117: dt_fndate.change_ses_date
118: (p_ses_date => l_effective_date,
367: --
368: l_first_day_of_month:=to_date(p_first_day_of_month,'YYYY/MM/DD HH24:MI:SS');
369: l_first_day_of_month:=to_date(to_char(trunc(l_first_day_of_month),'DD/MM/RRRR'),'DD/MM/RRRR');
370: */
371: l_effective_date := trunc(fnd_date.canonical_to_date(p_effective_date));
372: l_first_day_of_month := trunc(fnd_date.canonical_to_date(p_first_day_of_month));
373: --
374: --
375: --?? l_actn := 'Initialize the ben_batch_utils cache...';
368: l_first_day_of_month:=to_date(p_first_day_of_month,'YYYY/MM/DD HH24:MI:SS');
369: l_first_day_of_month:=to_date(to_char(trunc(l_first_day_of_month),'DD/MM/RRRR'),'DD/MM/RRRR');
370: */
371: l_effective_date := trunc(fnd_date.canonical_to_date(p_effective_date));
372: l_first_day_of_month := trunc(fnd_date.canonical_to_date(p_first_day_of_month));
373: --
374: --
375: --?? l_actn := 'Initialize the ben_batch_utils cache...';
376: --?? ben_batch_utils.ini;