3887: from hxc_time_building_blocks
3888: where time_building_block_id = p_timecard_id
3889: and date_to = hr_general.end_of_time;
3890:
3891: l_process_locker_type varchar2(80) := hxc_lock_util.c_ss_timecard_action;
3892: l_timecard_ovn hxc_time_building_blocks.object_version_number%type;
3893:
3894: Begin
3895:
3907: (p_timecard_action = 'ApprovalDetail')
3908: OR
3909: (p_timecard_action = 'Detail')
3910: ) then
3911: l_process_locker_type := hxc_lock_util.c_ss_timecard_view;
3912: end if;
3913:
3914: --
3915: -- Try obtaining a lock