[Home] [Help]
1533:
1534: END IF;
1535:
1536: if(p_template = hxc_timecard.c_no) then
1537: if(hxc_lock_api.check_lock(p_lock_rowid)) then
1538: l_valid_lock := true;
1539: else
1540: --
1541: -- For bug
1545: l_timecard_index := hxc_timecard_block_utils.find_active_timecard_index(p_blocks);
1546:
1547: if(hxc_timecard_block_utils.is_new_block(p_blocks(l_timecard_index))) then
1548:
1549: hxc_lock_api.request_lock
1550: (p_process_locker_type=> hxc_lock_util.c_ss_timecard_action
1551: ,p_resource_id=> p_blocks(l_timecard_index).resource_id
1552: ,p_start_time=> fnd_date.canonical_to_date(p_blocks(l_timecard_index).start_time)
1553: ,p_stop_time=> fnd_date.canonical_to_date(p_blocks(l_timecard_index).start_time)
1560: ,p_locked_success=> l_valid_lock
1561: );
1562: else
1563:
1564: hxc_lock_api.request_lock
1565: (p_process_locker_type=> hxc_lock_util.c_ss_timecard_action
1566: ,p_resource_id=> p_blocks(l_timecard_index).resource_id
1567: ,p_start_time=> fnd_date.canonical_to_date(p_blocks(l_timecard_index).start_time)
1568: ,p_stop_time=> fnd_date.canonical_to_date(p_blocks(l_timecard_index).start_time)
1620: OR
1621: ((p_deposit_mode = hxc_timecard.c_submit) AND (p_validate = hxc_timecard.c_no) AND (p_template = hxc_timecard.c_no))
1622: ) then
1623:
1624: hxc_lock_api.release_lock
1625: (P_ROW_LOCK_ID => p_lock_rowid
1626: ,P_PROCESS_LOCKER_TYPE => l_process_locker_type
1627: ,P_TRANSACTION_LOCK_ID => null
1628: ,P_RESOURCE_ID => null
1639: -- This is important, because we might have saved
1640: -- a timecard as a template, in which case, we should
1641: -- release the lock that we might have
1642: --
1643: hxc_lock_api.release_lock
1644: (p_row_lock_id => p_lock_rowid);
1645:
1646: end if;
1647:
2126:
2127:
2128: end if;
2129:
2130: hxc_lock_api.release_lock
2131: (p_row_lock_id => l_lock_rowid);
2132:
2133: hxc_timecard_message_helper.prepareErrors;
2134: