DBA Data[Home] [Help]

APPS.PER_EMPDIR_SS dependencies on FND_DATE

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

3660: BEGIN
3661:
3662: g_srcSystem := p_source_system;
3663: g_schema_owner := getTblOwner;
3664: l_eff_date := nvl(fnd_date.canonical_to_date(p_eff_date), trunc(sysdate));
3665:
3666: write_log(1, 'Process began @: '|| to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
3667:
3668: BEGIN

Line 3831: fnd_date_tz.init_timezones_for_fnd_date;

3827:
3828: function get_time (p_to_tz in varchar2) return varchar2 is
3829: l_date date;
3830: begin
3831: fnd_date_tz.init_timezones_for_fnd_date;
3832: l_date := FND_DATE.adjust_datetime(sysdate
3833: ,FND_TIMEZONES.get_server_timezone_code
3834: ,p_to_tz);
3835:

Line 3832: l_date := FND_DATE.adjust_datetime(sysdate

3828: function get_time (p_to_tz in varchar2) return varchar2 is
3829: l_date date;
3830: begin
3831: fnd_date_tz.init_timezones_for_fnd_date;
3832: l_date := FND_DATE.adjust_datetime(sysdate
3833: ,FND_TIMEZONES.get_server_timezone_code
3834: ,p_to_tz);
3835:
3836: RETURN to_char(l_date, fnd_profile.value('ICX_DATE_FORMAT_MASK')||' HH24:MI');