APPS.HXC_LOCK_UTIL dependencies on HXC_LOCKS

Line 448: insert into hxc_locks

444: if g_debug then
445: hr_utility.trace('JOEL - insert_lock 1 p_start_time '||p_start_time);
446: end if;
447:
448: insert into hxc_locks
449: (LOCKER_TYPE_ID
450: ,RESOURCE_ID
451: ,START_TIME
452: ,STOP_TIME

Line 491: from hxc_locks a ,hxc_time_building_blocks b

487: PRAGMA AUTONOMOUS_TRANSACTION;
488:
489: cursor c_rowid_info is
490: select scope , b.time_building_block_id, a.locker_type_id
491: from hxc_locks a ,hxc_time_building_blocks b
492: where a.rowid = p_rowid
493: and b.time_building_block_id = a.time_building_block_id
494: and b.object_version_number = a.time_building_block_ovn ;
495:

Line 568: delete from hxc_locks

564:
565: END IF;
566:
567:
568: delete from hxc_locks
569: where rowid = p_rowid;
570:
571: COMMIT;
572:

Line 595: delete from hxc_locks

591: (p_process_locker_type => p_process_locker_type
592: ,p_messages => p_messages);
593:
594:
595: delete from hxc_locks
596: where transaction_lock_id = p_transaction_lock_id
597: and locker_type_id = l_locker_type_id;
598:
599: COMMIT;

Line 728: from hxc_locks

724: IS
725:
726: cursor c_lock (p_tbb_id number, p_tbb_ovn number) is
727: select locker_type_id, lock_date, rowid, resource_id, process_id,attribute2
728: from hxc_locks
729: where time_building_block_id = p_tbb_id
730: and time_building_block_ovn = p_tbb_ovn;
731:
732: cursor c_full_name (p_resource_id in number) is

Line 1098: delete from hxc_locks

1094: PRAGMA AUTONOMOUS_TRANSACTION;
1095:
1096: BEGIN
1097:
1098: delete from hxc_locks
1099: where time_building_block_id = p_time_building_block_id
1100: and time_building_block_ovn = p_time_building_block_ovn
1101: and locker_type_id = p_locker_type_id;
1102:

Line 1126: delete from hxc_locks

1122: --dbms_output.put_line('JOEL - delete_period_lock 1 '||p_resource_id);
1123: --dbms_output.put_line('JOEL - delete_period_lock 1 '||p_start_time);
1124: --dbms_output.put_line('JOEL - delete_period_lock 1 '||p_stop_time);
1125:
1126: delete from hxc_locks
1127: where resource_id = p_resource_id
1128: and locker_type_id = p_locker_type_id
1129: and start_time = p_start_time
1130: and stop_time = p_stop_time;