DBA Data[Home] [Help]

APPS.HRI_TIME_C dependencies on FND_DATE

Line 362: fnd_date.date_to_displaydate(g_global_start_date));

358: raise G_BIS_PARAMETER_NOT_SETUP;
359: end if;
360: if g_debug_flag = 'Y' then
361: hri_util.put_line('INIT : '||'Global Start Date = ' ||
362: fnd_date.date_to_displaydate(g_global_start_date));
363: hri_util.put_line(' ');
364: end if;
365: end if;
366:

Line 2570: fnd_date.date_to_displaydate(l_from_date) ||

2566: g_load_mode := p_load_mode;
2567:
2568: if g_debug_flag = 'Y' then
2569: HRI_util.put_line('LOAD : '||'Data loads from ' ||
2570: fnd_date.date_to_displaydate(l_from_date) ||
2571: ' to ' ||
2572: fnd_date.date_to_displaydate(l_to_date));
2573: end if;
2574:

Line 2572: fnd_date.date_to_displaydate(l_to_date));

2568: if g_debug_flag = 'Y' then
2569: HRI_util.put_line('LOAD : '||'Data loads from ' ||
2570: fnd_date.date_to_displaydate(l_from_date) ||
2571: ' to ' ||
2572: fnd_date.date_to_displaydate(l_to_date));
2573: end if;
2574:
2575: -----------------------------------------------------
2576: -- Calling BIS API to do common set ups

Line 2705: fnd_date.date_to_displaydate(l_from_date) ||

2701: if g_debug_flag = 'Y' and
2702: l_from_date <> to_date(p_from_date,'YYYY/MM/DD HH24:MI:SS') or
2703: l_to_date <> to_date(p_to_date,'YYYY/MM/DD HH24:MI:SS') then
2704: HRI_util.put_line('LOAD : '||'Resetting data loads as from ' ||
2705: fnd_date.date_to_displaydate(l_from_date) ||
2706: ' to ' ||
2707: fnd_date.date_to_displaydate(l_to_date));
2708: end if;
2709:

Line 2707: fnd_date.date_to_displaydate(l_to_date));

2703: l_to_date <> to_date(p_to_date,'YYYY/MM/DD HH24:MI:SS') then
2704: HRI_util.put_line('LOAD : '||'Resetting data loads as from ' ||
2705: fnd_date.date_to_displaydate(l_from_date) ||
2706: ' to ' ||
2707: fnd_date.date_to_displaydate(l_to_date));
2708: end if;
2709:
2710: end if; --if g_all_level = 'Y'
2711:

Line 3142: , fnd_date.displaydt_to_date

3138: BIS_COLLECTION_UTILITIES.wrapup
3139: ( p_status => TRUE
3140: , p_period_from => l_from_date
3141: , p_period_to => greatest( l_to_date
3142: , fnd_date.displaydt_to_date
3143: ( bis_collection_utilities.get_last_refresh_period
3144: ('HRI_DBI_TIME_M_F')
3145: )
3146: )

Line 3185: fnd_message.set_token('DATE_NOT_DEFINED', fnd_date.date_to_displaydate(g_date_not_defined));

3181: WHEN G_ENT_CALENDAR_NOT_FOUND THEN
3182: rollback;
3183: --Bug 3640141. Setting token as the message text has changed.
3184: fnd_message.set_name('HRI','HRI_ENT_CALENDAR_NOT_FOUND');
3185: fnd_message.set_token('DATE_NOT_DEFINED', fnd_date.date_to_displaydate(g_date_not_defined));
3186: l_mesg := fnd_message.get;
3187: HRI_util.put_line(l_mesg);
3188: retcode := -1;
3189: /* if l_bis_setup = 'Y' then

Line 3198: fnd_message.set_token('START_DATE', fnd_date.date_to_displaydate(l_min_start_date));

3194: --Added for bug 4454026
3195: rollback;
3196: fnd_message.set_name('HRI','HRI_FISCAL_YEAR_NOT_DEFINED');
3197: fnd_message.set_token('YEAR', l_year);
3198: fnd_message.set_token('START_DATE', fnd_date.date_to_displaydate(l_min_start_date));
3199: fnd_message.set_token('END_DATE', fnd_date.date_to_displaydate(l_max_end_date));
3200: l_mesg := fnd_message.get;
3201: HRI_util.put_line(l_mesg);
3202: retcode := -1;

Line 3199: fnd_message.set_token('END_DATE', fnd_date.date_to_displaydate(l_max_end_date));

3195: rollback;
3196: fnd_message.set_name('HRI','HRI_FISCAL_YEAR_NOT_DEFINED');
3197: fnd_message.set_token('YEAR', l_year);
3198: fnd_message.set_token('START_DATE', fnd_date.date_to_displaydate(l_min_start_date));
3199: fnd_message.set_token('END_DATE', fnd_date.date_to_displaydate(l_max_end_date));
3200: l_mesg := fnd_message.get;
3201: HRI_util.put_line(l_mesg);
3202: retcode := -1;
3203: /* if l_bis_setup = 'Y' then

Line 4174: l_return_date := least(fnd_date.displaydt_to_date

4170: begin
4171:
4172: if p_load_mode = 'INCRE' then
4173: if check_validated = 'Y' then
4174: l_return_date := least(fnd_date.displaydt_to_date
4175: ( bis_collection_utilities.get_last_refresh_period
4176: ('HRI_DBI_TIME_M')
4177: ) +1, fnd_date.displaydt_to_date(DEFAULT_LOAD_TO_DATE));
4178: else

Line 4177: ) +1, fnd_date.displaydt_to_date(DEFAULT_LOAD_TO_DATE));

4173: if check_validated = 'Y' then
4174: l_return_date := least(fnd_date.displaydt_to_date
4175: ( bis_collection_utilities.get_last_refresh_period
4176: ('HRI_DBI_TIME_M')
4177: ) +1, fnd_date.displaydt_to_date(DEFAULT_LOAD_TO_DATE));
4178: else
4179: l_return_date := bis_common_parameters.get_global_start_date;
4180: end if;
4181: else

Line 4186: return fnd_date.date_to_displaydt(l_return_date);

4182: select least(nvl(min(start_date),bis_common_parameters.get_global_start_date) , bis_common_parameters.get_global_start_date) into l_return_date
4183: from HRI_time_day;
4184: end if;
4185:
4186: return fnd_date.date_to_displaydt(l_return_date);
4187:
4188: end DEFAULT_LOAD_FROM_DATE;
4189:
4190: ---------------------------------------------------

Line 4212: return fnd_date.date_to_displaydt(l_return_date);

4208: where adjustment_period_flag = 'N'
4209: and period_set_name = l_period_set_name
4210: and period_type = l_period_type;
4211:
4212: return fnd_date.date_to_displaydt(l_return_date);
4213:
4214: end DEFAULT_LOAD_TO_DATE;
4215:
4216: END HRI_TIME_C;