DBA Data[Home] [Help]

APPS.BEN_PREMIUM_PLAN_CONCURRENT dependencies on FND_DATE

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

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

Line 114: l_first_day_of_month := trunc(fnd_date.canonical_to_date(p_first_day_of_month));

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,

Line 371: l_effective_date := trunc(fnd_date.canonical_to_date(p_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...';

Line 372: l_first_day_of_month := trunc(fnd_date.canonical_to_date(p_first_day_of_month));

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;