DBA Data[Home] [Help]

APPS.PER_EMPDIR_SS dependencies on FND_DATE

Line 3670: l_eff_date := nvl(fnd_date.canonical_to_date(p_eff_date), trunc(sysdate));

3666: BEGIN
3667:
3668: g_srcSystem := p_source_system;
3669: g_schema_owner := getTblOwner;
3670: l_eff_date := nvl(fnd_date.canonical_to_date(p_eff_date), trunc(sysdate));
3671:
3672: write_log(1, 'Process began @: '|| to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
3673:
3674: BEGIN

Line 3837: fnd_date_tz.init_timezones_for_fnd_date;

3833:
3834: function get_time (p_to_tz in varchar2) return varchar2 is
3835: l_date date;
3836: begin
3837: fnd_date_tz.init_timezones_for_fnd_date;
3838: l_date := FND_DATE.adjust_datetime(sysdate
3839: ,FND_TIMEZONES.get_server_timezone_code
3840: ,p_to_tz);
3841:

Line 3838: l_date := FND_DATE.adjust_datetime(sysdate

3834: function get_time (p_to_tz in varchar2) return varchar2 is
3835: l_date date;
3836: begin
3837: fnd_date_tz.init_timezones_for_fnd_date;
3838: l_date := FND_DATE.adjust_datetime(sysdate
3839: ,FND_TIMEZONES.get_server_timezone_code
3840: ,p_to_tz);
3841:
3842: RETURN to_char(l_date, fnd_profile.value('ICX_DATE_FORMAT_MASK')||' HH24:MI');