DBA Data[Home] [Help]

APPS.OTA_EVT_BUS dependencies on HR_GENERAL

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

1944: --
1945: if (OTA_EVT_SHD.api_updating (p_event_id, p_object_version_number)) then
1946: --
1947: l_dates_updated :=
1948: (nvl (p_course_start_date, hr_general.start_of_time) <>
1949: nvl (OTA_EVT_SHD.g_old_rec.course_start_date, hr_general.start_of_time)
1950: or nvl (p_course_end_date, hr_general.end_of_time) <>
1951: nvl (OTA_EVT_SHD.g_old_rec.course_end_date, hr_general.end_of_time)
1952: );

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

1945: if (OTA_EVT_SHD.api_updating (p_event_id, p_object_version_number)) then
1946: --
1947: l_dates_updated :=
1948: (nvl (p_course_start_date, hr_general.start_of_time) <>
1949: nvl (OTA_EVT_SHD.g_old_rec.course_start_date, hr_general.start_of_time)
1950: or nvl (p_course_end_date, hr_general.end_of_time) <>
1951: nvl (OTA_EVT_SHD.g_old_rec.course_end_date, hr_general.end_of_time)
1952: );
1953: --

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

1946: --
1947: l_dates_updated :=
1948: (nvl (p_course_start_date, hr_general.start_of_time) <>
1949: nvl (OTA_EVT_SHD.g_old_rec.course_start_date, hr_general.start_of_time)
1950: or nvl (p_course_end_date, hr_general.end_of_time) <>
1951: nvl (OTA_EVT_SHD.g_old_rec.course_end_date, hr_general.end_of_time)
1952: );
1953: --
1954: end if;

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

1947: l_dates_updated :=
1948: (nvl (p_course_start_date, hr_general.start_of_time) <>
1949: nvl (OTA_EVT_SHD.g_old_rec.course_start_date, hr_general.start_of_time)
1950: or nvl (p_course_end_date, hr_general.end_of_time) <>
1951: nvl (OTA_EVT_SHD.g_old_rec.course_end_date, hr_general.end_of_time)
1952: );
1953: --
1954: end if;
1955: --