eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HXC_LOCK_UTIL SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 22


select scope, resource_id, stop_time, start_time
from hxc_time_building_blocks
where time_building_block_id = p_time_building_block_id
and   object_version_number  = p_time_building_block_ovn;

Line: 315


select grant_lock
from   hxc_locking_rules
where  locker_type_owner_id = p_locker_type_owner_id
and    locker_type_requestor_id = p_locker_type_requestor_id;

Line: 425


PROCEDURE insert_lock (p_locker_type_id IN NUMBER
         	      ,p_resource_id	IN NUMBER
         	      ,p_start_time	IN DATE
         	      ,p_stop_time	IN DATE
         	      ,p_time_building_block_id  IN NUMBER
         	      ,p_time_building_block_ovn IN NUMBER
         	      ,p_transaction_lock_id	 IN NUMBER
                      ,p_expiration_time	 IN NUMBER
         	      ,p_row_lock_id             IN OUT NOCOPY ROWID) IS

PRAGMA AUTONOMOUS_TRANSACTION;

Line: 445


	hr_utility.trace('JOEL - insert_lock 1 p_start_time '||p_start_time);

Line: 448


  insert into hxc_locks
  (LOCKER_TYPE_ID
  ,RESOURCE_ID
  ,START_TIME
  ,STOP_TIME
  ,TIME_BUILDING_BLOCK_ID
  ,TIME_BUILDING_BLOCK_OVN
  ,LOCK_DATE
  ,PROCESS_ID
  ,ATTRIBUTE1
  ,ATTRIBUTE2
  ,TRANSACTION_LOCK_ID)
  values
  (p_locker_type_id
  ,p_resource_id
  ,p_start_time
  ,p_stop_time
  ,p_time_building_block_id
  ,p_time_building_block_ovn
  ,sysdate + (1/24/60)*p_expiration_time
  ,fnd_global.user_id
  ,to_char(fnd_global.employee_id)
  ,to_char(fnd_global.session_id)
  ,p_transaction_lock_id
  ) RETURNING ROWID into p_row_lock_id;

Line: 477


END insert_lock;

Line: 482


PROCEDURE delete_lock(p_rowid               IN ROWID
                     ,p_locker_type_id      IN NUMBER
                     ,p_process_locker_type IN VARCHAR2
                     ,p_messages            IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE) IS

PRAGMA AUTONOMOUS_TRANSACTION;

Line: 490


select scope , b.time_building_block_id, a.locker_type_id
from   hxc_locks a ,hxc_time_building_blocks b
where  a.rowid = p_rowid
and    b.time_building_block_id  = a.time_building_block_id
and    b.object_version_number = a.time_building_block_ovn ;

Line: 498


select time_building_block_id, time_building_block_ovn
from   hxc_ap_detail_links
where  application_period_id = p_app_period_id;

Line: 517


	hr_utility.trace('JOEL - delete_lock 0 ');

Line: 526


	hr_utility.trace('JOEL - delete_lock 1 '||l_app_period_id);

Line: 527


	hr_utility.trace('JOEL - delete_lock 1 '||l_scope);

Line: 529


	hr_utility.trace('JOEL - delete_lock 1 '||l_app_period_id);

Line: 546


	hr_utility.trace('JOEL - delete_lock 2 '||l_locker_type_id);

Line: 553


	hr_utility.trace('JOEL - delete_lock 3 '||crs_app_period_detail.time_building_block_id);

Line: 554


	hr_utility.trace('JOEL - delete_lock 3 '||crs_app_period_detail.time_building_block_ovn);

Line: 559


       hxc_lock_util.delete_tbb_lock
                   (p_locker_type_id          => l_locker_type_id
         	   ,p_time_building_block_id  => crs_app_period_detail.time_building_block_id
                   ,p_time_building_block_ovn => crs_app_period_detail.time_building_block_ovn);

Line: 568


delete from hxc_locks
where rowid = p_rowid;

Line: 573


END delete_lock;

Line: 578


PROCEDURE delete_transaction_lock
                     (p_transaction_lock_id IN NUMBER
                     ,p_process_locker_type IN VARCHAR2
                     ,p_messages            IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE)
                     IS

PRAGMA AUTONOMOUS_TRANSACTION;

Line: 595


delete from hxc_locks
where transaction_lock_id = p_transaction_lock_id
and   locker_type_id = l_locker_type_id;

Line: 601


END delete_transaction_lock;

Line: 615


select locker_type_id
from   hxc_locker_types
where  locker_type  = p_locker_type
and    process_type = p_process_type;

Line: 727


select locker_type_id, lock_date, rowid, resource_id, process_id,attribute2
from   hxc_locks
where  time_building_block_id  = p_tbb_id
and    time_building_block_ovn = p_tbb_ovn;

Line: 733


select full_name
from  per_all_people_f
where person_id = p_resource_id
and sysdate between effective_start_date and effective_end_date;

Line: 858


	hr_utility.trace('JOEL - delete_lock 1 ');

Line: 861


       hxc_lock_util.delete_lock
                (p_rowid               => csr_lock.rowid
                ,p_locker_type_id      => csr_lock.locker_type_id
                ,p_process_locker_type => null
                ,p_messages	       => p_messages);

Line: 877


	hr_utility.trace('JOEL - delete_lock 2 ');

Line: 879


       hxc_lock_util.delete_lock
                (p_rowid               => csr_lock.rowid
                ,p_locker_type_id      => csr_lock.locker_type_id
                ,p_process_locker_type => null
                ,p_messages	       => p_messages);

Line: 917


select full_name
from  per_all_people_f
where person_id = p_resource_id
and sysdate between effective_start_date and effective_end_date;

Line: 1053


	hr_utility.trace('JOEL - delete_lock 4 ');

Line: 1055


       hxc_lock_util.delete_lock
                (p_rowid               => p_rowid
                ,p_locker_type_id      => p_locker_type_owner_id
                ,p_process_locker_type => null
                ,p_messages	       => p_messages);

Line: 1071


	hr_utility.trace('JOEL - delete_lock 5 ');

Line: 1073


       hxc_lock_util.delete_lock
                (p_rowid               => p_rowid
                ,p_locker_type_id      => p_locker_type_owner_id
                ,p_process_locker_type => null
                ,p_messages	       => p_messages);

Line: 1090


PROCEDURE delete_tbb_lock (p_locker_type_id   IN NUMBER
          	          ,p_time_building_block_id  IN NUMBER
         	          ,p_time_building_block_ovn IN NUMBER) IS

PRAGMA AUTONOMOUS_TRANSACTION;

Line: 1098


delete from hxc_locks
where time_building_block_id = p_time_building_block_id
and   time_building_block_ovn = p_time_building_block_ovn
and   locker_type_id = p_locker_type_id;

Line: 1105


END delete_tbb_lock;

Line: 1111


PROCEDURE delete_period_lock
                      (p_locker_type_id   IN NUMBER
         	      ,p_resource_id	IN NUMBER
         	      ,p_start_time	IN DATE
         	      ,p_stop_time	IN DATE) IS

PRAGMA AUTONOMOUS_TRANSACTION;

Line: 1126


delete from hxc_locks
where resource_id = p_resource_id
and   locker_type_id = p_locker_type_id
and   start_time = p_start_time
and   stop_time  = p_stop_time;

Line: 1134


END delete_period_lock;