DBA Data[Home] [Help]

APPS.MSC_E1APS_DEMCL dependencies on FND_DATE

Line 210: p_start_date := fnd_date.date_to_canonical(ADD_MONTHS(SYSDATE, - p_start_date));

206: p_start_date := fnd_profile.value('MSC_E1APS_DEM_START_DATE_IN_MONTHS');
207: p_end_date := fnd_profile.value('MSC_E1APS_DEM_END_DATE_IN_MONTHS');
208:
209: IF total_rows <>0 THEN
210: p_start_date := fnd_date.date_to_canonical(ADD_MONTHS(SYSDATE, - p_start_date));
211: p_end_date := fnd_date.date_to_canonical(ADD_MONTHS(SYSDATE, + p_end_date));
212: p_include_all := 1;
213: p_include_prl_list := NULL;
214: p_exclude_prl_list := NULL;

Line 211: p_end_date := fnd_date.date_to_canonical(ADD_MONTHS(SYSDATE, + p_end_date));

207: p_end_date := fnd_profile.value('MSC_E1APS_DEM_END_DATE_IN_MONTHS');
208:
209: IF total_rows <>0 THEN
210: p_start_date := fnd_date.date_to_canonical(ADD_MONTHS(SYSDATE, - p_start_date));
211: p_end_date := fnd_date.date_to_canonical(ADD_MONTHS(SYSDATE, + p_end_date));
212: p_include_all := 1;
213: p_include_prl_list := NULL;
214: p_exclude_prl_list := NULL;
215: