5044: --
5045: exception
5046: --
5047: when others then
5048: hr_message.provide_error;
5049: if (l_time_out and hr_message.last_message_name = 'HR_7165_OBJECT_LOCKED') then
5050: --
5051: select to_number(((to_char(sysdate, 'J') - 1 ) * 86400) +
5052: to_char(sysdate, 'SSSSS'))
5045: exception
5046: --
5047: when others then
5048: hr_message.provide_error;
5049: if (l_time_out and hr_message.last_message_name = 'HR_7165_OBJECT_LOCKED') then
5050: --
5051: select to_number(((to_char(sysdate, 'J') - 1 ) * 86400) +
5052: to_char(sysdate, 'SSSSS'))
5053: into l_etime
5237: --
5238: exception
5239: --
5240: when others then
5241: hr_message.provide_error;
5242: if (l_time_out and hr_message.last_message_name = 'HR_7165_OBJECT_LOCKED') then
5243: --
5244: select to_number(((to_char(sysdate, 'J') - 1 ) * 86400) +
5245: to_char(sysdate, 'SSSSS'))
5238: exception
5239: --
5240: when others then
5241: hr_message.provide_error;
5242: if (l_time_out and hr_message.last_message_name = 'HR_7165_OBJECT_LOCKED') then
5243: --
5244: select to_number(((to_char(sysdate, 'J') - 1 ) * 86400) +
5245: to_char(sysdate, 'SSSSS'))
5246: into l_etime