APPS.AHL_UMP_PROCESSUNIT_PVT dependencies on DBMS_LOCK

Line 884: DBMS_LOCK.SLEEP(30);

880: -- Lock records.
881: FOR i IN 1..4 LOOP
882: Lock_UnitEffectivity_Records(x_ret_code => l_ret_code);
883: EXIT WHEN (l_ret_code <> '-54');
884: DBMS_LOCK.SLEEP(30);
885: END LOOP;
886:
887: IF (l_ret_code = -54) THEN
888: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_ALREADY_RUNNING');

Line 13370: --DBMS_LOCK.SLEEP(60);

13366: AHL_DEBUG_PUB.debug('Start Get_Next_BUE_Row: Parent Conc Request ID:' || p_parent_conc_pgm_id);
13367: AHL_DEBUG_PUB.debug('Child Conc Request ID:' || p_conc_child_req_id);
13368: END IF;
13369:
13370: --DBMS_LOCK.SLEEP(60);
13371:
13372: -- get next unprocessed row.
13373: OPEN ahl_bue_worker_csr(p_parent_conc_pgm_id);
13374: LOOP