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_API SQL Statements

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

Line: 120


select scope, resource_id, stop_time, start_time, parent_building_Block_id,
       parent_building_block_ovn
from hxc_time_building_blocks
where time_building_block_id = p_tbb_id
and   object_version_number  = p_tbb_ovn;

Line: 128


select time_building_block_id, time_building_block_ovn
from   hxc_ap_detail_links
where  application_period_id = p_app_period_id;

Line: 327


      hxc_lock_util.insert_lock
                   (p_locker_type_id      => l_locker_type_req_id
         	   ,p_resource_id         => l_resource_id
                   ,p_start_time          => l_start_time
         	   ,p_stop_time           => l_stop_time
         	   ,p_time_building_block_id  => l_tbb_id
                   ,p_time_building_block_ovn => l_tbb_ovn
                   ,p_transaction_lock_id     => p_transaction_lock_id
                   ,p_expiration_time	      => l_expiration_time
                   ,p_row_lock_id	      => p_row_lock_id
                   );

Line: 360


       hxc_lock_util.insert_lock
                   (p_locker_type_id          => l_locker_type_req_id
         	   ,p_resource_id             => l_resource_id
                   ,p_start_time              => l_start_time
         	   ,p_stop_time               => l_stop_time
         	   ,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
                   ,p_transaction_lock_id     => p_transaction_lock_id
                   ,p_expiration_time	      => l_expiration_time
                   ,p_row_lock_id	      => p_row_lock_id);

Line: 375


     hxc_lock_util.insert_lock
                   (p_locker_type_id          => l_locker_type_req_id
         	   ,p_resource_id             => l_resource_id
                   ,p_start_time              => l_start_time
         	   ,p_stop_time               => l_stop_time
         	   ,p_time_building_block_id  => l_tbb_id
                   ,p_time_building_block_ovn => l_tbb_ovn
                   ,p_transaction_lock_id     => p_transaction_lock_id
                   ,p_expiration_time	      => l_expiration_time
                   ,p_row_lock_id	      => p_row_lock_id);

Line: 398


  hxc_lock_util.insert_lock
                   (p_locker_type_id          => l_locker_type_req_id
         	   ,p_resource_id             => p_resource_id
                   ,p_start_time              => p_start_time
         	   ,p_stop_time               => p_stop_time
         	   ,p_time_building_block_id  => l_dummy
                   ,p_time_building_block_ovn => l_dummy
                   ,p_transaction_lock_id     => p_transaction_lock_id
                   ,p_expiration_time	      => l_expiration_time
                   ,p_row_lock_id	      => p_row_lock_id
                   );

Line: 456


select detail.time_building_block_id, detail.object_version_number
from   hxc_time_building_blocks detail,hxc_time_building_blocks day
where  day.parent_building_block_id  = p_tbb_id
and    day.parent_building_block_ovn = p_tbb_ovn
and    day.scope = 'DAY'
and    day.resource_id = p_resource_id
and    day.time_building_block_id   = detail.parent_building_block_id
and    detail.parent_building_block_ovn =
(select max(day2.object_version_number)
from  hxc_time_building_blocks day2
where day2.time_building_block_id = day.time_building_block_id)
and  detail.scope = 'DETAIL'
and  detail.resource_id = p_resource_id
and  detail.object_version_number =
(select max(detail2.object_version_number)
from  hxc_time_building_blocks detail2
where detail2.time_building_block_id = detail.time_building_block_id)
UNION
select day.time_building_block_id, day.object_version_number
from   hxc_time_building_blocks day
where  day.parent_building_block_id  = p_tbb_id
and    day.parent_building_block_ovn = p_tbb_ovn
and    day.scope = 'DAY'
and    day.resource_id = p_resource_id;

Line: 483


select day.parent_building_block_id, day.parent_building_block_ovn
from   hxc_time_building_blocks detail, hxc_time_building_blocks day
where  detail.time_building_block_id  = p_tbb_id
and    detail.object_version_number = p_tbb_ovn
and    detail.scope = 'DETAIL'
and    detail.resource_id = p_resource_id
--and    detail.date_to = hr_general.end_of_time
and    day.scope = 'DAY'
--and    day.date_to = hr_general.end_of_time
and    day.resource_id = p_resource_id
and    day.time_building_block_id   = detail.parent_building_block_id
and    day.object_version_number = detail.parent_building_block_ovn
UNION
select detail.parent_building_block_id, detail.parent_building_block_ovn
from   hxc_time_building_blocks detail
where  detail.time_building_block_id  = p_tbb_id
and    detail.object_version_number = p_tbb_ovn
and    detail.scope = 'DETAIL'
and    detail.resource_id = p_resource_id;

Line: 505


select time_building_block_id, time_building_block_ovn
from   hxc_ap_detail_links
where  application_period_id = p_app_period_id;

Line: 510


select rowid, start_time, stop_time, lock_date, locker_type_id, process_id, attribute2
from   hxc_locks
where  resource_id = p_resource_id;

Line: 515


select rowid, start_time, stop_time, lock_date, locker_type_id, process_id, attribute2
from   hxc_locks
where  resource_id = p_resource_id
and    time_building_block_id is null
and    time_building_block_ovn is null;

Line: 820


select lock_date from hxc_locks
where rowid = p_row_lock_id;

Line: 868


select lock_date, rowid from hxc_locks
where transaction_lock_id = p_transaction_lock_id
and   resource_id  = p_resource_id
and   locker_type_id = p_locker_type_req_id;

Line: 919


select lock_date
from hxc_locks
where rowid = p_row_lock_id
and resource_id = p_resource_id
and start_time = p_start_time
and stop_time = p_stop_time;

Line: 1016


select scope, resource_id, stop_time, start_time, parent_building_Block_id,
       parent_building_block_ovn
from hxc_time_building_blocks
where time_building_block_id = p_tbb_id
and   object_version_number  = p_tbb_ovn;

Line: 1024


select time_building_block_id, time_building_block_ovn
from   hxc_ap_detail_links
where  application_period_id = p_app_period_id;

Line: 1058


	hr_utility.trace('JOEL - delete_lock 10 '||p_process_locker_type);

Line: 1059


	hr_utility.trace('JOEL - delete_lock 10 :'||p_resource_id);

Line: 1060


	hr_utility.trace('JOEL - delete_lock 10 :'||p_process_locker_type);

Line: 1061


	hr_utility.trace('JOEL - delete_lock 10: '||p_start_time);

Line: 1062


	hr_utility.trace('JOEL - delete_lock 10: '||p_stop_time);

Line: 1063


	hr_utility.trace('JOEL - delete_lock 10: '||p_time_building_block_id);

Line: 1064


	hr_utility.trace('JOEL - delete_lock 10: '||p_time_building_block_ovn);

Line: 1065


	hr_utility.trace('JOEL - delete_lock 10: '||p_row_lock_id);

Line: 1074


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

Line: 1076


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

Line: 1088


   hxc_lock_util.delete_transaction_lock
           (p_transaction_lock_id => p_transaction_lock_id
           ,p_process_locker_type => p_process_locker_type
           ,p_messages => p_messages);

Line: 1160


      hxc_lock_util.delete_tbb_lock
                   (p_locker_type_id          => l_locker_type_req_id
         	   ,p_time_building_block_id  => l_tbb_id
                   ,p_time_building_block_ovn => l_tbb_ovn);

Line: 1176


       hxc_lock_util.delete_tbb_lock
                   (p_locker_type_id          => l_locker_type_req_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: 1183


   hxc_lock_util.delete_tbb_lock
                   (p_locker_type_id          => l_locker_type_req_id
         	   ,p_time_building_block_id  => l_tbb_id
                   ,p_time_building_block_ovn => l_tbb_ovn);

Line: 1195


  hxc_lock_util.delete_period_lock
                   (p_locker_type_id          => l_locker_type_req_id
         	   ,p_resource_id             => p_resource_id
                   ,p_start_time              => p_start_time
         	   ,p_stop_time               => p_stop_time);