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 564: hxc_lock_util.check_parameters

560:
561: --dbms_output.put_line('JOEL - check_lock 1');
562:
563: -- check the parameteres
564: hxc_lock_util.check_parameters
565: (p_process_locker_type => p_process_locker_type
566: ,p_resource_id => p_resource_id
567: ,p_start_time => p_start_time
568: ,p_stop_time => p_stop_time

Line 583: p_process_locker_type_id := hxc_lock_util.get_locker_type_req_id

579: p_timecard_locked := TRUE;
580: RETURN;
581: END IF;
582:
583: p_process_locker_type_id := hxc_lock_util.get_locker_type_req_id
584: (p_process_locker_type => p_process_locker_type
585: ,p_messages => p_messages);
586:
587:

Line 600: hxc_lock_util.check_row_lock

596: -- but first we need to check if this
597:
598: --dbms_output.put_line('JOEL - check_lock 4');
599:
600: hxc_lock_util.check_row_lock
601: (p_locker_type_requestor_id => p_process_locker_type_id
602: ,p_process_locker_type => p_process_locker_type
603: ,p_resource_id => p_resource_id
604: ,p_time_building_block_id => p_time_building_block_id

Line 621: hxc_lock_util.check_date_lock

617: -- Added parameters p_start_time and p_stop_time
618:
619: FOR crs_period_lock in c_period_lock(p_resource_id,p_start_time,p_stop_time) LOOP
620:
621: hxc_lock_util.check_date_lock
622: (p_locker_type_requestor_id => p_process_locker_type_id
623: ,p_locker_type_owner_id => crs_period_lock.locker_type_id
624: ,p_process_locker_type => p_process_locker_type
625: ,p_lock_date => crs_period_lock.lock_date

Line 663: hxc_lock_util.check_row_lock

659: LOOP
660:
661: --dbms_output.put_line('JOEL - check_lock 7: '||crs_timecard_detail.time_building_block_id);
662:
663: hxc_lock_util.check_row_lock
664: (p_locker_type_requestor_id => p_process_locker_type_id
665: ,p_process_locker_type => p_process_locker_type
666: ,p_resource_id => p_resource_id
667: ,p_time_building_block_id => crs_timecard_detail.time_building_block_id

Line 701: hxc_lock_util.check_row_lock

697: --dbms_output.put_line('JOEL - check_lock 9 :'||l_timecard_id);
698: --dbms_output.put_line('JOEL - check_lock 9 :'||l_timecard_ovn);
699:
700: -- try to find the lock
701: hxc_lock_util.check_row_lock
702: (p_locker_type_requestor_id => p_process_locker_type_id
703: ,p_process_locker_type => p_process_locker_type
704: ,p_resource_id => p_resource_id
705: ,p_time_building_block_id => l_timecard_id

Line 743: hxc_lock_util.check_row_lock

739: hr_utility.trace('JOEL - check_lock 10 :');
740: end if;
741:
742: -- try to find the lock
743: hxc_lock_util.check_row_lock
744: (p_locker_type_requestor_id => p_process_locker_type_id
745: ,p_process_locker_type => p_process_locker_type
746: ,p_resource_id => p_resource_id
747: ,p_time_building_block_id => crs_app_period_detail.time_building_block_id

Line 775: hxc_lock_util.check_row_lock

771: hr_utility.trace('JOEL - check_lock 12 :');
772: end if;
773:
774: -- try to find the lock
775: hxc_lock_util.check_row_lock
776: (p_locker_type_requestor_id => p_process_locker_type_id
777: ,p_process_locker_type => p_process_locker_type
778: ,p_resource_id => p_resource_id
779: ,p_time_building_block_id => l_timecard_id

Line 803: hxc_lock_util.check_date_lock

799: if g_debug then
800: hr_utility.trace('JOEL - check_lock 12 :');
801: end if;
802:
803: hxc_lock_util.check_date_lock
804: (p_locker_type_requestor_id => p_process_locker_type_id
805: ,p_locker_type_owner_id => crs_resource_period_lock.locker_type_id
806: ,p_process_locker_type => p_process_locker_type
807: ,p_lock_date => crs_resource_period_lock.lock_date

Line 901: := hxc_lock_util.get_locker_type_req_id

897:
898: BEGIN
899:
900: l_locker_type_req_id
901: := hxc_lock_util.get_locker_type_req_id
902: (p_process_locker_type => p_process_locker_type
903: ,p_messages => l_messages);
904:
905:

Line 985: ,p_process_locker_type => hxc_lock_util.c_ss_timecard_action

981:
982:
983: release_lock
984: (p_row_lock_id => p_row_lock_id
985: ,p_process_locker_type => hxc_lock_util.c_ss_timecard_action
986: ,p_messages => l_messages
987: ,p_released_success => l_released_success
988: ) ;
989:

Line 1095: hxc_lock_util.delete_lock

1091: IF p_row_lock_id is not null THEN
1092: if g_debug then
1093: hr_utility.trace('JOEL - delete_lock 10 ');
1094: end if;
1095: hxc_lock_util.delete_lock
1096: (p_rowid => p_row_lock_id
1097: ,p_locker_type_id => null
1098: ,p_process_locker_type => p_process_locker_type
1099: ,p_messages => p_messages);

Line 1107: hxc_lock_util.delete_transaction_lock

1103: END IF;
1104:
1105: IF p_transaction_lock_id is not null THEN
1106:
1107: hxc_lock_util.delete_transaction_lock
1108: (p_transaction_lock_id => p_transaction_lock_id
1109: ,p_process_locker_type => p_process_locker_type
1110: ,p_messages => p_messages);
1111:

Line 1139: hxc_lock_util.check_parameters

1135:
1136: --dbms_output.put_line('JOEL - release_lock 2 :');
1137:
1138: -- check the parameteres
1139: hxc_lock_util.check_parameters
1140: (p_process_locker_type => p_process_locker_type
1141: ,p_resource_id => l_resource_id
1142: ,p_start_time => l_start_time
1143: ,p_stop_time => l_stop_time

Line 1158: := hxc_lock_util.get_locker_type_req_id

1154:
1155: --dbms_output.put_line('JOEL - release_lock 3:');
1156:
1157: l_locker_type_req_id
1158: := hxc_lock_util.get_locker_type_req_id
1159: (p_process_locker_type => p_process_locker_type
1160: ,p_messages => p_messages);
1161:
1162:

Line 1179: hxc_lock_util.delete_tbb_lock

1175: l_tc_scope = 'DETAIL' THEN
1176:
1177: --dbms_output.put_line('JOEL - release_lock 5 :');
1178:
1179: hxc_lock_util.delete_tbb_lock
1180: (p_locker_type_id => l_locker_type_req_id
1181: ,p_time_building_block_id => l_tbb_id
1182: ,p_time_building_block_ovn => l_tbb_ovn);
1183:

Line 1195: hxc_lock_util.delete_tbb_lock

1191: --dbms_output.put_line('JOEL - release_lock 6 :');
1192:
1193: -- if we arrive here that means we did not find a detail
1194: -- locked and then we can insert a new lock
1195: hxc_lock_util.delete_tbb_lock
1196: (p_locker_type_id => l_locker_type_req_id
1197: ,p_time_building_block_id => crs_app_period_detail.time_building_block_id
1198: ,p_time_building_block_ovn => crs_app_period_detail.time_building_block_ovn);
1199: END LOOP;

Line 1202: hxc_lock_util.delete_tbb_lock

1198: ,p_time_building_block_ovn => crs_app_period_detail.time_building_block_ovn);
1199: END LOOP;
1200: END IF;
1201:
1202: hxc_lock_util.delete_tbb_lock
1203: (p_locker_type_id => l_locker_type_req_id
1204: ,p_time_building_block_id => l_tbb_id
1205: ,p_time_building_block_ovn => l_tbb_ovn);
1206:

Line 1214: hxc_lock_util.delete_period_lock

1210:
1211: --dbms_output.put_line('JOEL - release_lock 7 :');
1212:
1213: -- we need to delete a period
1214: hxc_lock_util.delete_period_lock
1215: (p_locker_type_id => l_locker_type_req_id
1216: ,p_resource_id => p_resource_id
1217: ,p_start_time => p_start_time
1218: ,p_stop_time => p_stop_time);