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 511: from hxc_locks

507: where application_period_id = p_app_period_id;
508:
509: cursor c_resource_period_lock (p_resource_id number) is
510: select rowid, start_time, stop_time, lock_date, locker_type_id, process_id, attribute2
511: from hxc_locks
512: where resource_id = p_resource_id;
513:
514: cursor c_period_lock (p_resource_id number) is
515: select rowid, start_time, stop_time, lock_date, locker_type_id, process_id, attribute2

Line 516: from hxc_locks

512: where resource_id = p_resource_id;
513:
514: cursor c_period_lock (p_resource_id number) is
515: select rowid, start_time, stop_time, lock_date, locker_type_id, process_id, attribute2
516: from hxc_locks
517: where resource_id = p_resource_id
518: and time_building_block_id is null
519: and time_building_block_ovn is null;
520:

Line 820: select lock_date from hxc_locks

816: FUNCTION check_lock (p_row_lock_id IN ROWID)
817: RETURN BOOLEAN IS
818:
819: cursor c_lock is
820: select lock_date from hxc_locks
821: where rowid = p_row_lock_id;
822:
823: l_locked BOOLEAN := FALSE;
824: l_lock_date DATE;

Line 868: select lock_date, rowid from hxc_locks

864: ,p_resource_id IN NUMBER)
865: RETURN ROWID IS
866:
867: cursor c_lock (p_locker_type_req_id number) is
868: select lock_date, rowid from hxc_locks
869: where transaction_lock_id = p_transaction_lock_id
870: and resource_id = p_resource_id
871: and locker_type_id = p_locker_type_req_id;
872:

Line 920: from hxc_locks

916: RETURN BOOLEAN IS
917:
918: cursor c_lock is
919: select lock_date
920: from hxc_locks
921: where rowid = p_row_lock_id
922: and resource_id = p_resource_id
923: and start_time = p_start_time
924: and stop_time = p_stop_time;

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

1066:
1067: end if;
1068:
1069: -- if it is not locked then now
1070: -- we need to insert row in hxc_locks
1071:
1072: IF p_row_lock_id is not null THEN
1073: if g_debug then
1074: hr_utility.trace('JOEL - delete_lock 10 ');