DBA Data[Home] [Help]

APPS.PER_PERIODS_OF_SERVICE_PKG dependencies on HR_API

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

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

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

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

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

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