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 dependencies on HXC_LOCK_UTIL

Line 19: ,p_expiration_time IN NUMBER DEFAULT hxc_lock_util.c_ss_expiration_time

15: ,p_stop_time IN DATE DEFAULT NULL
16: ,p_time_building_block_id IN NUMBER
17: ,p_time_building_block_ovn IN NUMBER
18: ,p_transaction_lock_id IN NUMBER DEFAULT NULL
19: ,p_expiration_time IN NUMBER DEFAULT hxc_lock_util.c_ss_expiration_time
20: ,p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE
21: ,p_row_lock_id IN OUT NOCOPY ROWID
22: ,p_locked_success OUT NOCOPY VARCHAR2
23: ) IS

Line 67: ,p_expiration_time IN NUMBER DEFAULT hxc_lock_util.c_ss_expiration_time

63: ,p_stop_time IN DATE DEFAULT NULL
64: ,p_time_building_block_id IN NUMBER
65: ,p_time_building_block_ovn IN NUMBER
66: ,p_transaction_lock_id IN NUMBER DEFAULT NULL
67: ,p_expiration_time IN NUMBER DEFAULT hxc_lock_util.c_ss_expiration_time
68: ,p_messages IN OUT NOCOPY hxc_self_service_time_deposit.message_table
69: ,p_row_lock_id IN OUT NOCOPY ROWID
70: ,p_locked_success OUT NOCOPY BOOLEAN
71: )IS

Line 113: ,p_expiration_time IN NUMBER DEFAULT hxc_lock_util.c_ss_expiration_time

109: ,p_stop_time IN DATE DEFAULT NULL
110: ,p_time_building_block_id IN NUMBER
111: ,p_time_building_block_ovn IN NUMBER
112: ,p_transaction_lock_id IN NUMBER DEFAULT NULL
113: ,p_expiration_time IN NUMBER DEFAULT hxc_lock_util.c_ss_expiration_time
114: ,p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE
115: ,p_row_lock_id IN OUT NOCOPY ROWID
116: ,p_locked_success OUT NOCOPY BOOLEAN
117: ) IS

Line 192: l_expiration_time := hxc_lock_util.c_ss_expiration_time;

188:
189: --END IF;
190:
191: IF l_expiration_time is null THEN
192: l_expiration_time := hxc_lock_util.c_ss_expiration_time;
193: END IF;
194:
195: --dbms_output.put_line('JOEL - request_lock 1');
196:

Line 199: IF p_process_locker_type = hxc_lock_util.c_ss_timecard_action

195: --dbms_output.put_line('JOEL - request_lock 1');
196:
197: -- for ss we need to check first if the lock exist for this row_id
198: -- we return the same rowid if it does.
199: IF p_process_locker_type = hxc_lock_util.c_ss_timecard_action
200: OR
201: p_process_locker_type = hxc_lock_util.c_ss_timecard_view
202: OR
203: p_process_locker_type = hxc_lock_util.c_ss_approval_action

Line 201: p_process_locker_type = hxc_lock_util.c_ss_timecard_view

197: -- for ss we need to check first if the lock exist for this row_id
198: -- we return the same rowid if it does.
199: IF p_process_locker_type = hxc_lock_util.c_ss_timecard_action
200: OR
201: p_process_locker_type = hxc_lock_util.c_ss_timecard_view
202: OR
203: p_process_locker_type = hxc_lock_util.c_ss_approval_action
204: THEN
205:

Line 203: p_process_locker_type = hxc_lock_util.c_ss_approval_action

199: IF p_process_locker_type = hxc_lock_util.c_ss_timecard_action
200: OR
201: p_process_locker_type = hxc_lock_util.c_ss_timecard_view
202: OR
203: p_process_locker_type = hxc_lock_util.c_ss_approval_action
204: THEN
205:
206: --dbms_output.put_line('JOEL - request_lock 2'||p_row_lock_id);
207: IF p_row_lock_id is not null THEN

Line 293: l_locker_type_req_id := hxc_lock_util.get_locker_type_req_id

289:
290:
291:
292: IF l_locker_type_req_id is null THEN
293: l_locker_type_req_id := hxc_lock_util.get_locker_type_req_id
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

Line 327: hxc_lock_util.insert_lock

323: hr_utility.trace('JOEL - request_lock 3: '||l_start_time);
324: hr_utility.trace('JOEL - request_lock 3: '||l_stop_time);
325: end if;
326:
327: hxc_lock_util.insert_lock
328: (p_locker_type_id => l_locker_type_req_id
329: ,p_resource_id => l_resource_id
330: ,p_start_time => l_start_time
331: ,p_stop_time => l_stop_time

Line 360: hxc_lock_util.insert_lock

356: end if;
357:
358: -- if we arrive here that means we did not find a detail
359: -- locked and then we can insert a new lock
360: hxc_lock_util.insert_lock
361: (p_locker_type_id => l_locker_type_req_id
362: ,p_resource_id => l_resource_id
363: ,p_start_time => l_start_time
364: ,p_stop_time => l_stop_time

Line 375: hxc_lock_util.insert_lock

371:
372: END LOOP;
373:
374: -- we lock the application period
375: hxc_lock_util.insert_lock
376: (p_locker_type_id => l_locker_type_req_id
377: ,p_resource_id => l_resource_id
378: ,p_start_time => l_start_time
379: ,p_stop_time => l_stop_time

Line 398: hxc_lock_util.insert_lock

394: hr_utility.trace('JOEL - request_lock 5');
395: end if;
396:
397: -- we need to lock a period
398: hxc_lock_util.insert_lock
399: (p_locker_type_id => l_locker_type_req_id
400: ,p_resource_id => p_resource_id
401: ,p_start_time => p_start_time
402: ,p_stop_time => p_stop_time

Line 549: hxc_lock_util.check_parameters

545:
546: --dbms_output.put_line('JOEL - check_lock 1');
547:
548: -- check the parameteres
549: hxc_lock_util.check_parameters
550: (p_process_locker_type => p_process_locker_type
551: ,p_resource_id => p_resource_id
552: ,p_start_time => p_start_time
553: ,p_stop_time => p_stop_time

Line 568: p_process_locker_type_id := hxc_lock_util.get_locker_type_req_id

564: p_timecard_locked := TRUE;
565: RETURN;
566: END IF;
567:
568: p_process_locker_type_id := hxc_lock_util.get_locker_type_req_id
569: (p_process_locker_type => p_process_locker_type
570: ,p_messages => p_messages);
571:
572:

Line 585: hxc_lock_util.check_row_lock

581: -- but first we need to check if this
582:
583: --dbms_output.put_line('JOEL - check_lock 4');
584:
585: hxc_lock_util.check_row_lock
586: (p_locker_type_requestor_id => p_process_locker_type_id
587: ,p_process_locker_type => p_process_locker_type
588: ,p_resource_id => p_resource_id
589: ,p_time_building_block_id => p_time_building_block_id

Line 602: hxc_lock_util.check_date_lock

598:
599: -- check if there is not a period locked for a resource
600: FOR crs_period_lock in c_period_lock(p_resource_id) LOOP
601:
602: hxc_lock_util.check_date_lock
603: (p_locker_type_requestor_id => p_process_locker_type_id
604: ,p_locker_type_owner_id => crs_period_lock.locker_type_id
605: ,p_process_locker_type => p_process_locker_type
606: ,p_lock_date => crs_period_lock.lock_date

Line 644: hxc_lock_util.check_row_lock

640: LOOP
641:
642: --dbms_output.put_line('JOEL - check_lock 7: '||crs_timecard_detail.time_building_block_id);
643:
644: hxc_lock_util.check_row_lock
645: (p_locker_type_requestor_id => p_process_locker_type_id
646: ,p_process_locker_type => p_process_locker_type
647: ,p_resource_id => p_resource_id
648: ,p_time_building_block_id => crs_timecard_detail.time_building_block_id

Line 682: hxc_lock_util.check_row_lock

678: --dbms_output.put_line('JOEL - check_lock 9 :'||l_timecard_id);
679: --dbms_output.put_line('JOEL - check_lock 9 :'||l_timecard_ovn);
680:
681: -- try to find the lock
682: hxc_lock_util.check_row_lock
683: (p_locker_type_requestor_id => p_process_locker_type_id
684: ,p_process_locker_type => p_process_locker_type
685: ,p_resource_id => p_resource_id
686: ,p_time_building_block_id => l_timecard_id

Line 724: hxc_lock_util.check_row_lock

720: hr_utility.trace('JOEL - check_lock 10 :');
721: end if;
722:
723: -- try to find the lock
724: hxc_lock_util.check_row_lock
725: (p_locker_type_requestor_id => p_process_locker_type_id
726: ,p_process_locker_type => p_process_locker_type
727: ,p_resource_id => p_resource_id
728: ,p_time_building_block_id => crs_app_period_detail.time_building_block_id

Line 756: hxc_lock_util.check_row_lock

752: hr_utility.trace('JOEL - check_lock 12 :');
753: end if;
754:
755: -- try to find the lock
756: hxc_lock_util.check_row_lock
757: (p_locker_type_requestor_id => p_process_locker_type_id
758: ,p_process_locker_type => p_process_locker_type
759: ,p_resource_id => p_resource_id
760: ,p_time_building_block_id => l_timecard_id

Line 784: hxc_lock_util.check_date_lock

780: if g_debug then
781: hr_utility.trace('JOEL - check_lock 12 :');
782: end if;
783:
784: hxc_lock_util.check_date_lock
785: (p_locker_type_requestor_id => p_process_locker_type_id
786: ,p_locker_type_owner_id => crs_resource_period_lock.locker_type_id
787: ,p_process_locker_type => p_process_locker_type
788: ,p_lock_date => crs_resource_period_lock.lock_date

Line 882: := hxc_lock_util.get_locker_type_req_id

878:
879: BEGIN
880:
881: l_locker_type_req_id
882: := hxc_lock_util.get_locker_type_req_id
883: (p_process_locker_type => p_process_locker_type
884: ,p_messages => l_messages);
885:
886:

Line 966: ,p_process_locker_type => hxc_lock_util.c_ss_timecard_action

962:
963:
964: release_lock
965: (p_row_lock_id => p_row_lock_id
966: ,p_process_locker_type => hxc_lock_util.c_ss_timecard_action
967: ,p_messages => l_messages
968: ,p_released_success => l_released_success
969: ) ;
970:

Line 1076: hxc_lock_util.delete_lock

1072: IF p_row_lock_id is not null THEN
1073: if g_debug then
1074: hr_utility.trace('JOEL - delete_lock 10 ');
1075: end if;
1076: hxc_lock_util.delete_lock
1077: (p_rowid => p_row_lock_id
1078: ,p_locker_type_id => null
1079: ,p_process_locker_type => p_process_locker_type
1080: ,p_messages => p_messages);

Line 1088: hxc_lock_util.delete_transaction_lock

1084: END IF;
1085:
1086: IF p_transaction_lock_id is not null THEN
1087:
1088: hxc_lock_util.delete_transaction_lock
1089: (p_transaction_lock_id => p_transaction_lock_id
1090: ,p_process_locker_type => p_process_locker_type
1091: ,p_messages => p_messages);
1092:

Line 1120: hxc_lock_util.check_parameters

1116:
1117: --dbms_output.put_line('JOEL - release_lock 2 :');
1118:
1119: -- check the parameteres
1120: hxc_lock_util.check_parameters
1121: (p_process_locker_type => p_process_locker_type
1122: ,p_resource_id => l_resource_id
1123: ,p_start_time => l_start_time
1124: ,p_stop_time => l_stop_time

Line 1139: := hxc_lock_util.get_locker_type_req_id

1135:
1136: --dbms_output.put_line('JOEL - release_lock 3:');
1137:
1138: l_locker_type_req_id
1139: := hxc_lock_util.get_locker_type_req_id
1140: (p_process_locker_type => p_process_locker_type
1141: ,p_messages => p_messages);
1142:
1143:

Line 1160: hxc_lock_util.delete_tbb_lock

1156: l_tc_scope = 'DETAIL' THEN
1157:
1158: --dbms_output.put_line('JOEL - release_lock 5 :');
1159:
1160: hxc_lock_util.delete_tbb_lock
1161: (p_locker_type_id => l_locker_type_req_id
1162: ,p_time_building_block_id => l_tbb_id
1163: ,p_time_building_block_ovn => l_tbb_ovn);
1164:

Line 1176: hxc_lock_util.delete_tbb_lock

1172: --dbms_output.put_line('JOEL - release_lock 6 :');
1173:
1174: -- if we arrive here that means we did not find a detail
1175: -- locked and then we can insert a new lock
1176: hxc_lock_util.delete_tbb_lock
1177: (p_locker_type_id => l_locker_type_req_id
1178: ,p_time_building_block_id => crs_app_period_detail.time_building_block_id
1179: ,p_time_building_block_ovn => crs_app_period_detail.time_building_block_ovn);
1180: END LOOP;

Line 1183: hxc_lock_util.delete_tbb_lock

1179: ,p_time_building_block_ovn => crs_app_period_detail.time_building_block_ovn);
1180: END LOOP;
1181: END IF;
1182:
1183: hxc_lock_util.delete_tbb_lock
1184: (p_locker_type_id => l_locker_type_req_id
1185: ,p_time_building_block_id => l_tbb_id
1186: ,p_time_building_block_ovn => l_tbb_ovn);
1187:

Line 1195: hxc_lock_util.delete_period_lock

1191:
1192: --dbms_output.put_line('JOEL - release_lock 7 :');
1193:
1194: -- we need to delete a period
1195: hxc_lock_util.delete_period_lock
1196: (p_locker_type_id => l_locker_type_req_id
1197: ,p_resource_id => p_resource_id
1198: ,p_start_time => p_start_time
1199: ,p_stop_time => p_stop_time);