DBA Data[Home] [Help]

APPS.PER_PERIODS_OF_SERVICE_PKG dependencies on HR_API

Line 1019: if (nvl(p_leaving_reason , hr_api.g_varchar2) = nvl(l_old_leaving_reason,hr_api.g_varchar2))

1015:
1016: -- Checking to see if we need to only update pds
1017: -- i.e. no termination/rev term/ leav_reas needs to be done
1018:
1019: if (nvl(p_leaving_reason , hr_api.g_varchar2) = nvl(l_old_leaving_reason,hr_api.g_varchar2))
1020: and (nvl(p_actual_termination_date,hr_api.g_date) = nvl(l_old_actual_termination_date,hr_api.g_date))
1021: and (nvl(p_final_process_date,hr_api.g_date) = nvl(l_old_final_process_date,hr_api.g_date))
1022: and nvl(p_initiate_cancellation,'N') <> 'Y' then
1023: hr_utility.set_location('Localization Action - True',99);

Line 1020: and (nvl(p_actual_termination_date,hr_api.g_date) = nvl(l_old_actual_termination_date,hr_api.g_date))

1016: -- Checking to see if we need to only update pds
1017: -- i.e. no termination/rev term/ leav_reas needs to be done
1018:
1019: if (nvl(p_leaving_reason , hr_api.g_varchar2) = nvl(l_old_leaving_reason,hr_api.g_varchar2))
1020: and (nvl(p_actual_termination_date,hr_api.g_date) = nvl(l_old_actual_termination_date,hr_api.g_date))
1021: and (nvl(p_final_process_date,hr_api.g_date) = nvl(l_old_final_process_date,hr_api.g_date))
1022: and nvl(p_initiate_cancellation,'N') <> 'Y' then
1023: hr_utility.set_location('Localization Action - True',99);
1024: l_localization_action := TRUE;

Line 1021: and (nvl(p_final_process_date,hr_api.g_date) = nvl(l_old_final_process_date,hr_api.g_date))

1017: -- i.e. no termination/rev term/ leav_reas needs to be done
1018:
1019: if (nvl(p_leaving_reason , hr_api.g_varchar2) = nvl(l_old_leaving_reason,hr_api.g_varchar2))
1020: and (nvl(p_actual_termination_date,hr_api.g_date) = nvl(l_old_actual_termination_date,hr_api.g_date))
1021: and (nvl(p_final_process_date,hr_api.g_date) = nvl(l_old_final_process_date,hr_api.g_date))
1022: and nvl(p_initiate_cancellation,'N') <> 'Y' then
1023: hr_utility.set_location('Localization Action - True',99);
1024: l_localization_action := TRUE;
1025: