APPS.HXC_LOCK_API dependencies on HXC_LOCKS

Line 298: -- we need to insert row in hxc_locks

294: (p_process_locker_type => p_process_locker_type
295: ,p_messages => p_messages);
296: END IF;
297: -- if it is not locked then now
298: -- we need to insert row in hxc_locks
299: IF l_tbb_id is not null THEN
300:
301: if g_debug then
302: hr_utility.trace('JOEL - request_lock 3 :'||l_tc_scope);

Line 520: from hxc_locks

516: where application_period_id = p_app_period_id;
517:
518: cursor c_resource_period_lock (p_resource_id number) is
519: select rowid, start_time, stop_time, lock_date, locker_type_id, process_id, attribute2
520: from hxc_locks
521: where resource_id = p_resource_id;
522:
523: -- Bug 8666520
524: -- Added parameters p_start_time and p_stop_time

Line 529: from hxc_locks

525: cursor c_period_lock (p_resource_id number,
526: p_start_time date,
527: p_stop_time date ) is
528: select rowid, start_time, stop_time, lock_date, locker_type_id, process_id, attribute2
529: from hxc_locks
530: where resource_id = p_resource_id
531: and start_time <= p_stop_time
532: and stop_time >= p_start_time
533: and time_building_block_id is null

Line 839: select lock_date from hxc_locks

835: FUNCTION check_lock (p_row_lock_id IN ROWID)
836: RETURN BOOLEAN IS
837:
838: cursor c_lock is
839: select lock_date from hxc_locks
840: where rowid = p_row_lock_id;
841:
842: l_locked BOOLEAN := FALSE;
843: l_lock_date DATE;

Line 887: select lock_date, rowid from hxc_locks

883: ,p_resource_id IN NUMBER)
884: RETURN ROWID IS
885:
886: cursor c_lock (p_locker_type_req_id number) is
887: select lock_date, rowid from hxc_locks
888: where transaction_lock_id = p_transaction_lock_id
889: and resource_id = p_resource_id
890: and locker_type_id = p_locker_type_req_id;
891:

Line 939: from hxc_locks

935: RETURN BOOLEAN IS
936:
937: cursor c_lock is
938: select lock_date
939: from hxc_locks
940: where rowid = p_row_lock_id
941: and resource_id = p_resource_id
942: and start_time = p_start_time
943: and stop_time = p_stop_time;

Line 1089: -- we need to insert row in hxc_locks

1085:
1086: end if;
1087:
1088: -- if it is not locked then now
1089: -- we need to insert row in hxc_locks
1090:
1091: IF p_row_lock_id is not null THEN
1092: if g_debug then
1093: hr_utility.trace('JOEL - delete_lock 10 ');