DBA Data[Home] [Help]

APPS.OTA_EVT_BUS dependencies on HR_GENERAL

Line 1967: (nvl (p_course_start_date, hr_general.start_of_time) <>

1963: --
1964: if (OTA_EVT_SHD.api_updating (p_event_id, p_object_version_number)) then
1965: --
1966: l_dates_updated :=
1967: (nvl (p_course_start_date, hr_general.start_of_time) <>
1968: nvl (OTA_EVT_SHD.g_old_rec.course_start_date, hr_general.start_of_time)
1969: or nvl (p_course_end_date, hr_general.end_of_time) <>
1970: nvl (OTA_EVT_SHD.g_old_rec.course_end_date, hr_general.end_of_time)
1971: );

Line 1968: nvl (OTA_EVT_SHD.g_old_rec.course_start_date, hr_general.start_of_time)

1964: if (OTA_EVT_SHD.api_updating (p_event_id, p_object_version_number)) then
1965: --
1966: l_dates_updated :=
1967: (nvl (p_course_start_date, hr_general.start_of_time) <>
1968: nvl (OTA_EVT_SHD.g_old_rec.course_start_date, hr_general.start_of_time)
1969: or nvl (p_course_end_date, hr_general.end_of_time) <>
1970: nvl (OTA_EVT_SHD.g_old_rec.course_end_date, hr_general.end_of_time)
1971: );
1972: --

Line 1969: or nvl (p_course_end_date, hr_general.end_of_time) <>

1965: --
1966: l_dates_updated :=
1967: (nvl (p_course_start_date, hr_general.start_of_time) <>
1968: nvl (OTA_EVT_SHD.g_old_rec.course_start_date, hr_general.start_of_time)
1969: or nvl (p_course_end_date, hr_general.end_of_time) <>
1970: nvl (OTA_EVT_SHD.g_old_rec.course_end_date, hr_general.end_of_time)
1971: );
1972: --
1973: end if;

Line 1970: nvl (OTA_EVT_SHD.g_old_rec.course_end_date, hr_general.end_of_time)

1966: l_dates_updated :=
1967: (nvl (p_course_start_date, hr_general.start_of_time) <>
1968: nvl (OTA_EVT_SHD.g_old_rec.course_start_date, hr_general.start_of_time)
1969: or nvl (p_course_end_date, hr_general.end_of_time) <>
1970: nvl (OTA_EVT_SHD.g_old_rec.course_end_date, hr_general.end_of_time)
1971: );
1972: --
1973: end if;
1974: --