APPS.HXC_RDB_PRE_RETRIEVAL dependencies on HXC_LOCKS

Line 1023: hxc_locks loc

1019:
1020: CURSOR pick_lock_rowid
1021: IS SELECT ROWIDTOCHAR(loc.rowid)
1022: FROM hxc_rdb_pre_timecards rdb,
1023: hxc_locks loc
1024: WHERE rdb.resource_id = loc.resource_id
1025: AND rdb.start_time = loc.start_time
1026: AND TRUNC(rdb.stop_time) = TRUNC(loc.stop_time)
1027: AND lock_date <= SYSDATE - (1/48);

Line 1039: DELETE FROM HXC_LOCKS

1035: FETCH pick_lock_rowid BULK COLLECT INTO rowtab LIMIT 500;
1036: EXIT WHEN rowtab.COUNT = 0;
1037:
1038: FORALL i IN rowtab.FIRST..rowtab.LAST
1039: DELETE FROM HXC_LOCKS
1040: WHERE ROWID = CHARTOROWID(rowtab(i));
1041: COMMIT;
1042: END LOOP;
1043:

Line 1388: DELETE FROM hxc_locks

1384:
1385:
1386: BEGIN
1387:
1388: DELETE FROM hxc_locks
1389: WHERE resource_id = TO_NUMBER(p_resource_id)
1390: AND TRUNC(start_time) = TO_DATE(p_start_time,FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK'))
1391: AND TRUNC(stop_time) = TO_DATE(p_stop_time,FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK'));
1392: COMMIT;