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 HR_UTILITY

Line 4: g_debug boolean := hr_utility.debug_enabled;

1: PACKAGE BODY HXC_LOCK_API AS
2: /* $Header: hxclockapi.pkb 120.6 2009/07/08 06:41:24 bbayragi ship $ */
3:
4: g_debug boolean := hr_utility.debug_enabled;
5:
6: -- ----------------------------------------------------------------------------
7: -- |---------------------------< request_lock > ----------------------|
8: -- ----------------------------------------------------------------------------

Line 160: g_debug := hr_utility.debug_enabled;

156:
157:
158: BEGIN
159:
160: g_debug := hr_utility.debug_enabled;
161:
162: -- quick check to denormilize the data and make
163: -- sure the passed data are correct
164:

Line 176: hr_utility.trace('JOEL - ----------------------------------');

172: --IF (p_resource_id = 7976) THEN
173: /*
174:
175: if g_debug then
176: hr_utility.trace('JOEL - ----------------------------------');
177: hr_utility.trace('JOEL - request_lock 1 :'||p_resource_id);
178: hr_utility.trace('JOEL - request_lock 1 :'||p_process_locker_type);
179: hr_utility.trace('JOEL - request_lock 1: '||p_start_time);
180: hr_utility.trace('JOEL - request_lock 1: '||p_stop_time);

Line 177: hr_utility.trace('JOEL - request_lock 1 :'||p_resource_id);

173: /*
174:
175: if g_debug then
176: hr_utility.trace('JOEL - ----------------------------------');
177: hr_utility.trace('JOEL - request_lock 1 :'||p_resource_id);
178: hr_utility.trace('JOEL - request_lock 1 :'||p_process_locker_type);
179: hr_utility.trace('JOEL - request_lock 1: '||p_start_time);
180: hr_utility.trace('JOEL - request_lock 1: '||p_stop_time);
181: hr_utility.trace('JOEL - request_lock 1: '||p_time_building_block_id);

Line 178: hr_utility.trace('JOEL - request_lock 1 :'||p_process_locker_type);

174:
175: if g_debug then
176: hr_utility.trace('JOEL - ----------------------------------');
177: hr_utility.trace('JOEL - request_lock 1 :'||p_resource_id);
178: hr_utility.trace('JOEL - request_lock 1 :'||p_process_locker_type);
179: hr_utility.trace('JOEL - request_lock 1: '||p_start_time);
180: hr_utility.trace('JOEL - request_lock 1: '||p_stop_time);
181: hr_utility.trace('JOEL - request_lock 1: '||p_time_building_block_id);
182: hr_utility.trace('JOEL - request_lock 1: '||p_time_building_block_ovn);

Line 179: hr_utility.trace('JOEL - request_lock 1: '||p_start_time);

175: if g_debug then
176: hr_utility.trace('JOEL - ----------------------------------');
177: hr_utility.trace('JOEL - request_lock 1 :'||p_resource_id);
178: hr_utility.trace('JOEL - request_lock 1 :'||p_process_locker_type);
179: hr_utility.trace('JOEL - request_lock 1: '||p_start_time);
180: hr_utility.trace('JOEL - request_lock 1: '||p_stop_time);
181: hr_utility.trace('JOEL - request_lock 1: '||p_time_building_block_id);
182: hr_utility.trace('JOEL - request_lock 1: '||p_time_building_block_ovn);
183: hr_utility.trace('JOEL - request_lock 1: '||p_expiration_time);

Line 180: hr_utility.trace('JOEL - request_lock 1: '||p_stop_time);

176: hr_utility.trace('JOEL - ----------------------------------');
177: hr_utility.trace('JOEL - request_lock 1 :'||p_resource_id);
178: hr_utility.trace('JOEL - request_lock 1 :'||p_process_locker_type);
179: hr_utility.trace('JOEL - request_lock 1: '||p_start_time);
180: hr_utility.trace('JOEL - request_lock 1: '||p_stop_time);
181: hr_utility.trace('JOEL - request_lock 1: '||p_time_building_block_id);
182: hr_utility.trace('JOEL - request_lock 1: '||p_time_building_block_ovn);
183: hr_utility.trace('JOEL - request_lock 1: '||p_expiration_time);
184: hr_utility.trace('JOEL - request_lock 1: '||p_row_lock_id);

Line 181: hr_utility.trace('JOEL - request_lock 1: '||p_time_building_block_id);

177: hr_utility.trace('JOEL - request_lock 1 :'||p_resource_id);
178: hr_utility.trace('JOEL - request_lock 1 :'||p_process_locker_type);
179: hr_utility.trace('JOEL - request_lock 1: '||p_start_time);
180: hr_utility.trace('JOEL - request_lock 1: '||p_stop_time);
181: hr_utility.trace('JOEL - request_lock 1: '||p_time_building_block_id);
182: hr_utility.trace('JOEL - request_lock 1: '||p_time_building_block_ovn);
183: hr_utility.trace('JOEL - request_lock 1: '||p_expiration_time);
184: hr_utility.trace('JOEL - request_lock 1: '||p_row_lock_id);
185: end if;

Line 182: hr_utility.trace('JOEL - request_lock 1: '||p_time_building_block_ovn);

178: hr_utility.trace('JOEL - request_lock 1 :'||p_process_locker_type);
179: hr_utility.trace('JOEL - request_lock 1: '||p_start_time);
180: hr_utility.trace('JOEL - request_lock 1: '||p_stop_time);
181: hr_utility.trace('JOEL - request_lock 1: '||p_time_building_block_id);
182: hr_utility.trace('JOEL - request_lock 1: '||p_time_building_block_ovn);
183: hr_utility.trace('JOEL - request_lock 1: '||p_expiration_time);
184: hr_utility.trace('JOEL - request_lock 1: '||p_row_lock_id);
185: end if;
186:

Line 183: hr_utility.trace('JOEL - request_lock 1: '||p_expiration_time);

179: hr_utility.trace('JOEL - request_lock 1: '||p_start_time);
180: hr_utility.trace('JOEL - request_lock 1: '||p_stop_time);
181: hr_utility.trace('JOEL - request_lock 1: '||p_time_building_block_id);
182: hr_utility.trace('JOEL - request_lock 1: '||p_time_building_block_ovn);
183: hr_utility.trace('JOEL - request_lock 1: '||p_expiration_time);
184: hr_utility.trace('JOEL - request_lock 1: '||p_row_lock_id);
185: end if;
186:
187: */

Line 184: hr_utility.trace('JOEL - request_lock 1: '||p_row_lock_id);

180: hr_utility.trace('JOEL - request_lock 1: '||p_stop_time);
181: hr_utility.trace('JOEL - request_lock 1: '||p_time_building_block_id);
182: hr_utility.trace('JOEL - request_lock 1: '||p_time_building_block_ovn);
183: hr_utility.trace('JOEL - request_lock 1: '||p_expiration_time);
184: hr_utility.trace('JOEL - request_lock 1: '||p_row_lock_id);
185: end if;
186:
187: */
188:

Line 229: hr_utility.trace('JOEL - request_lock 11: ');

225: -- start_time and stop_time does not match
226: -- then we are releasing the lock and we are
227: -- requesting a new one)
228: if g_debug then
229: hr_utility.trace('JOEL - request_lock 11: ');
230: end if;
231: release_lock (p_row_lock_id => p_row_lock_id);
232: --
233: p_row_lock_id := null;

Line 260: hr_utility.trace('JOEL - request_lock 4');

256:
257:
258:
259: if g_debug then
260: hr_utility.trace('JOEL - request_lock 4');
261: end if;
262:
263:
264: -- check if there is not a check already.

Line 278: hr_utility.trace('JOEL - request_lock 2');

274: ,p_time_building_block_scope => l_tc_scope
275: ,p_process_locker_type_id => l_locker_type_req_id);
276:
277: if g_debug then
278: hr_utility.trace('JOEL - request_lock 2');
279: end if;
280:
281: --if locked then stop the request_lock process
282: IF l_timecard_locked THEN

Line 287: hr_utility.trace('JOEL - request_lock 2-1');

283: RETURN;
284: END IF;
285:
286: if g_debug then
287: hr_utility.trace('JOEL - request_lock 2-1');
288: end if;
289:
290:
291:

Line 302: hr_utility.trace('JOEL - request_lock 3 :'||l_tc_scope);

298: -- we need to insert row in hxc_locks
299: IF l_tbb_id is not null THEN
300:
301: if g_debug then
302: hr_utility.trace('JOEL - request_lock 3 :'||l_tc_scope);
303: hr_utility.trace('JOEL - request_lock 3: '||l_start_time);
304: hr_utility.trace('JOEL - request_lock 3: '||l_stop_time);
305: hr_utility.trace('JOEL - request_lock 3: '||l_resource_id);
306: hr_utility.trace('JOEL - request_lock 3: '||l_expiration_time);

Line 303: hr_utility.trace('JOEL - request_lock 3: '||l_start_time);

299: IF l_tbb_id is not null THEN
300:
301: if g_debug then
302: hr_utility.trace('JOEL - request_lock 3 :'||l_tc_scope);
303: hr_utility.trace('JOEL - request_lock 3: '||l_start_time);
304: hr_utility.trace('JOEL - request_lock 3: '||l_stop_time);
305: hr_utility.trace('JOEL - request_lock 3: '||l_resource_id);
306: hr_utility.trace('JOEL - request_lock 3: '||l_expiration_time);
307:

Line 304: hr_utility.trace('JOEL - request_lock 3: '||l_stop_time);

300:
301: if g_debug then
302: hr_utility.trace('JOEL - request_lock 3 :'||l_tc_scope);
303: hr_utility.trace('JOEL - request_lock 3: '||l_start_time);
304: hr_utility.trace('JOEL - request_lock 3: '||l_stop_time);
305: hr_utility.trace('JOEL - request_lock 3: '||l_resource_id);
306: hr_utility.trace('JOEL - request_lock 3: '||l_expiration_time);
307:
308: end if;

Line 305: hr_utility.trace('JOEL - request_lock 3: '||l_resource_id);

301: if g_debug then
302: hr_utility.trace('JOEL - request_lock 3 :'||l_tc_scope);
303: hr_utility.trace('JOEL - request_lock 3: '||l_start_time);
304: hr_utility.trace('JOEL - request_lock 3: '||l_stop_time);
305: hr_utility.trace('JOEL - request_lock 3: '||l_resource_id);
306: hr_utility.trace('JOEL - request_lock 3: '||l_expiration_time);
307:
308: end if;
309:

Line 306: hr_utility.trace('JOEL - request_lock 3: '||l_expiration_time);

302: hr_utility.trace('JOEL - request_lock 3 :'||l_tc_scope);
303: hr_utility.trace('JOEL - request_lock 3: '||l_start_time);
304: hr_utility.trace('JOEL - request_lock 3: '||l_stop_time);
305: hr_utility.trace('JOEL - request_lock 3: '||l_resource_id);
306: hr_utility.trace('JOEL - request_lock 3: '||l_expiration_time);
307:
308: end if;
309:
310: IF (l_tc_scope is null or l_resource_id is null

Line 322: hr_utility.trace('JOEL - request_lock 3-1: ' || p_time_building_block_id);

318: l_tc_scope = 'TIMECARD_TEMPLATE' or
319: l_tc_scope = 'DETAIL' THEN
320:
321: if g_debug then
322: hr_utility.trace('JOEL - request_lock 3-1: ' || p_time_building_block_id);
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:

Line 323: hr_utility.trace('JOEL - request_lock 3: '||l_start_time);

319: l_tc_scope = 'DETAIL' THEN
320:
321: if g_debug then
322: hr_utility.trace('JOEL - request_lock 3-1: ' || p_time_building_block_id);
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

Line 324: hr_utility.trace('JOEL - request_lock 3: '||l_stop_time);

320:
321: if g_debug then
322: hr_utility.trace('JOEL - request_lock 3-1: ' || p_time_building_block_id);
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

Line 339: hr_utility.trace('JOEL - request_lock 3-1: ' || p_row_lock_id);

335: ,p_expiration_time => l_expiration_time
336: ,p_row_lock_id => p_row_lock_id
337: );
338: if g_debug then
339: hr_utility.trace('JOEL - request_lock 3-1: ' || p_row_lock_id);
340: end if;
341:
342: p_locked_success := TRUE;
343:

Line 347: hr_utility.trace('JOEL - request_lock 4: ' || p_time_building_block_id);

343:
344: ELSIF l_tc_scope = 'APPLICATION_PERIOD' THEN
345:
346: if g_debug then
347: hr_utility.trace('JOEL - request_lock 4: ' || p_time_building_block_id);
348: end if;
349: -- we need to lock all the details for this application period
350: FOR crs_app_period_detail in c_app_period_detail(l_tbb_id)
351: LOOP

Line 353: hr_utility.trace('JOEL - request_lock 3: '||l_start_time);

349: -- we need to lock all the details for this application period
350: FOR crs_app_period_detail in c_app_period_detail(l_tbb_id)
351: LOOP
352: if g_debug then
353: hr_utility.trace('JOEL - request_lock 3: '||l_start_time);
354: hr_utility.trace('JOEL - request_lock 3: '||l_stop_time);
355: hr_utility.trace('JOEL - p_time_building_block_id 3: '||p_time_building_block_id);
356: end if;
357:

Line 354: hr_utility.trace('JOEL - request_lock 3: '||l_stop_time);

350: FOR crs_app_period_detail in c_app_period_detail(l_tbb_id)
351: LOOP
352: if g_debug then
353: hr_utility.trace('JOEL - request_lock 3: '||l_start_time);
354: hr_utility.trace('JOEL - request_lock 3: '||l_stop_time);
355: hr_utility.trace('JOEL - p_time_building_block_id 3: '||p_time_building_block_id);
356: end if;
357:
358: -- if we arrive here that means we did not find a detail

Line 355: hr_utility.trace('JOEL - p_time_building_block_id 3: '||p_time_building_block_id);

351: LOOP
352: if g_debug then
353: hr_utility.trace('JOEL - request_lock 3: '||l_start_time);
354: hr_utility.trace('JOEL - request_lock 3: '||l_stop_time);
355: hr_utility.trace('JOEL - p_time_building_block_id 3: '||p_time_building_block_id);
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

Line 394: hr_utility.trace('JOEL - request_lock 5');

390:
391: ELSE
392:
393: if g_debug then
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

Line 415: hr_utility.trace('messages :');

411:
412: END IF;
413:
414: if g_debug then
415: hr_utility.trace('messages :');
416: end if;
417:
418:
419: --l_dummy := p_messages.first;

Line 425: -- hr_utility.trace('message_name :'||p_messages(l_dummy).message_name);

421: --EXIT WHEN
422: -- (NOT p_messages.exists(l_dummy));
423:
424: --if g_debug then
425: -- hr_utility.trace('message_name :'||p_messages(l_dummy).message_name);
426: -- hr_utility.trace('message_level :'||p_messages(l_dummy).message_level);
427: --end if;
428:
429: --l_dummy := p_messages.next(l_dummy);

Line 426: -- hr_utility.trace('message_level :'||p_messages(l_dummy).message_level);

422: -- (NOT p_messages.exists(l_dummy));
423:
424: --if g_debug then
425: -- hr_utility.trace('message_name :'||p_messages(l_dummy).message_name);
426: -- hr_utility.trace('message_level :'||p_messages(l_dummy).message_level);
427: --end if;
428:
429: --l_dummy := p_messages.next(l_dummy);
430:

Line 553: g_debug := hr_utility.debug_enabled;

549: l_grant VARCHAR2(1);
550:
551: BEGIN
552:
553: g_debug := hr_utility.debug_enabled;
554:
555: p_timecard_locked := FALSE;
556:
557: --l_resource_id := p_resource_id;

Line 591: hr_utility.trace('JOEL - check_lock 3');

587:
588: --dbms_output.put_line('JOEL - check_lock 3');
589:
590: if g_debug then
591: hr_utility.trace('JOEL - check_lock 3');
592: end if;
593:
594: IF p_time_building_block_id is not null THEN
595: -- following the scope we need to do different thing.

Line 739: hr_utility.trace('JOEL - check_lock 10 :');

735: FOR crs_app_period_detail in c_app_period_detail(p_time_building_block_id)
736: LOOP
737:
738: if g_debug then
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

Line 757: hr_utility.trace('JOEL - check_lock 11 :');

753: -- check if we can stop the process
754: IF p_timecard_locked THEN
755: RETURN;
756: if g_debug then
757: hr_utility.trace('JOEL - check_lock 11 :');
758: end if;
759: END IF;
760:
761: -- for each detail we need to check if the parent is locked

Line 771: hr_utility.trace('JOEL - check_lock 12 :');

767: CLOSE c_detail_timecard;
768:
769: --dbms_output.put_line('JOEL - check_lock 11 :');
770: if g_debug then
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

Line 787: hr_utility.trace('JOEL - check_lock 13 :');

783:
784: -- check if we can stop the process
785: IF p_timecard_locked THEN
786: if g_debug then
787: hr_utility.trace('JOEL - check_lock 13 :');
788: end if;
789: RETURN;
790: END IF;
791:

Line 800: hr_utility.trace('JOEL - check_lock 12 :');

796: -- we are in the case of a checking a lock for a period for a resource
797: FOR crs_resource_period_lock in c_resource_period_lock(p_resource_id) LOOP
798:
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

Line 851: g_debug := hr_utility.debug_enabled;

847:
848: IF p_row_lock_id is not null THEN
849: /*
850:
851: g_debug := hr_utility.debug_enabled;
852:
853: if g_debug then
854: hr_utility.trace('J a'||trim(p_row_lock_id)||'b');
855: end if;

Line 854: hr_utility.trace('J a'||trim(p_row_lock_id)||'b');

850:
851: g_debug := hr_utility.debug_enabled;
852:
853: if g_debug then
854: hr_utility.trace('J a'||trim(p_row_lock_id)||'b');
855: end if;
856:
857: */
858: OPEN c_lock;

Line 1070: g_debug := hr_utility.debug_enabled;

1066: l_parent_tbb_ovn NUMBER;
1067:
1068: BEGIN
1069:
1070: g_debug := hr_utility.debug_enabled;
1071:
1072: p_released_success := FALSE;
1073:
1074:

Line 1076: hr_utility.trace('--------------------------------------------');

1072: p_released_success := FALSE;
1073:
1074:
1075: if g_debug then
1076: hr_utility.trace('--------------------------------------------');
1077: hr_utility.trace('JOEL - delete_lock 10 '||p_process_locker_type);
1078: hr_utility.trace('JOEL - delete_lock 10 :'||p_resource_id);
1079: hr_utility.trace('JOEL - delete_lock 10 :'||p_process_locker_type);
1080: hr_utility.trace('JOEL - delete_lock 10: '||p_start_time);

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

1073:
1074:
1075: if g_debug then
1076: hr_utility.trace('--------------------------------------------');
1077: hr_utility.trace('JOEL - delete_lock 10 '||p_process_locker_type);
1078: hr_utility.trace('JOEL - delete_lock 10 :'||p_resource_id);
1079: hr_utility.trace('JOEL - delete_lock 10 :'||p_process_locker_type);
1080: hr_utility.trace('JOEL - delete_lock 10: '||p_start_time);
1081: hr_utility.trace('JOEL - delete_lock 10: '||p_stop_time);

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

1074:
1075: if g_debug then
1076: hr_utility.trace('--------------------------------------------');
1077: hr_utility.trace('JOEL - delete_lock 10 '||p_process_locker_type);
1078: hr_utility.trace('JOEL - delete_lock 10 :'||p_resource_id);
1079: hr_utility.trace('JOEL - delete_lock 10 :'||p_process_locker_type);
1080: hr_utility.trace('JOEL - delete_lock 10: '||p_start_time);
1081: hr_utility.trace('JOEL - delete_lock 10: '||p_stop_time);
1082: hr_utility.trace('JOEL - delete_lock 10: '||p_time_building_block_id);

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

1075: if g_debug then
1076: hr_utility.trace('--------------------------------------------');
1077: hr_utility.trace('JOEL - delete_lock 10 '||p_process_locker_type);
1078: hr_utility.trace('JOEL - delete_lock 10 :'||p_resource_id);
1079: hr_utility.trace('JOEL - delete_lock 10 :'||p_process_locker_type);
1080: hr_utility.trace('JOEL - delete_lock 10: '||p_start_time);
1081: hr_utility.trace('JOEL - delete_lock 10: '||p_stop_time);
1082: hr_utility.trace('JOEL - delete_lock 10: '||p_time_building_block_id);
1083: hr_utility.trace('JOEL - delete_lock 10: '||p_time_building_block_ovn);

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

1076: hr_utility.trace('--------------------------------------------');
1077: hr_utility.trace('JOEL - delete_lock 10 '||p_process_locker_type);
1078: hr_utility.trace('JOEL - delete_lock 10 :'||p_resource_id);
1079: hr_utility.trace('JOEL - delete_lock 10 :'||p_process_locker_type);
1080: hr_utility.trace('JOEL - delete_lock 10: '||p_start_time);
1081: hr_utility.trace('JOEL - delete_lock 10: '||p_stop_time);
1082: hr_utility.trace('JOEL - delete_lock 10: '||p_time_building_block_id);
1083: hr_utility.trace('JOEL - delete_lock 10: '||p_time_building_block_ovn);
1084: hr_utility.trace('JOEL - delete_lock 10: '||p_row_lock_id);

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

1077: hr_utility.trace('JOEL - delete_lock 10 '||p_process_locker_type);
1078: hr_utility.trace('JOEL - delete_lock 10 :'||p_resource_id);
1079: hr_utility.trace('JOEL - delete_lock 10 :'||p_process_locker_type);
1080: hr_utility.trace('JOEL - delete_lock 10: '||p_start_time);
1081: hr_utility.trace('JOEL - delete_lock 10: '||p_stop_time);
1082: hr_utility.trace('JOEL - delete_lock 10: '||p_time_building_block_id);
1083: hr_utility.trace('JOEL - delete_lock 10: '||p_time_building_block_ovn);
1084: hr_utility.trace('JOEL - delete_lock 10: '||p_row_lock_id);
1085:

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

1078: hr_utility.trace('JOEL - delete_lock 10 :'||p_resource_id);
1079: hr_utility.trace('JOEL - delete_lock 10 :'||p_process_locker_type);
1080: hr_utility.trace('JOEL - delete_lock 10: '||p_start_time);
1081: hr_utility.trace('JOEL - delete_lock 10: '||p_stop_time);
1082: hr_utility.trace('JOEL - delete_lock 10: '||p_time_building_block_id);
1083: hr_utility.trace('JOEL - delete_lock 10: '||p_time_building_block_ovn);
1084: hr_utility.trace('JOEL - delete_lock 10: '||p_row_lock_id);
1085:
1086: end if;

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

1079: hr_utility.trace('JOEL - delete_lock 10 :'||p_process_locker_type);
1080: hr_utility.trace('JOEL - delete_lock 10: '||p_start_time);
1081: hr_utility.trace('JOEL - delete_lock 10: '||p_stop_time);
1082: hr_utility.trace('JOEL - delete_lock 10: '||p_time_building_block_id);
1083: hr_utility.trace('JOEL - delete_lock 10: '||p_time_building_block_ovn);
1084: hr_utility.trace('JOEL - delete_lock 10: '||p_row_lock_id);
1085:
1086: end if;
1087:

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

1080: hr_utility.trace('JOEL - delete_lock 10: '||p_start_time);
1081: hr_utility.trace('JOEL - delete_lock 10: '||p_stop_time);
1082: hr_utility.trace('JOEL - delete_lock 10: '||p_time_building_block_id);
1083: hr_utility.trace('JOEL - delete_lock 10: '||p_time_building_block_ovn);
1084: hr_utility.trace('JOEL - delete_lock 10: '||p_row_lock_id);
1085:
1086: end if;
1087:
1088: -- if it is not locked then now

Line 1093: hr_utility.trace('JOEL - delete_lock 10 ');

1089: -- we need to insert row in hxc_locks
1090:
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