DBA Data[Home] [Help]

APPS.OTA_MANDATORY_ENROLL_UTIL dependencies on DBMS_LOCK

Line 3293: dbms_lock.sleep(5);

3289: End if;
3290: Close c_slaves;
3291: End loop;
3292: If (l_no_slaves) then
3293: dbms_lock.sleep(5);
3294: End if;
3295: End loop;
3296: End if;
3297: hr_utility.set_location ('Leaving '||l_proc,5);

Line 3316: dbms_lock.sleep(5);

3312: mand_enr_req_rec t_mand_rec;
3313: l_proc varchar2(80) := g_package||'.purge_mand_enroll_data';
3314: begin
3315: hr_utility.set_location ('Entering '||l_proc,5);
3316: dbms_lock.sleep(5);
3317: select omr.CONC_PROGRAM_REQUEST_ID, omr.MANDATORY_ENR_REQUEST_ID
3318: bulk collect into mand_enr_req_rec
3319: from OTA_MAND_MULTI_ENR_REQUESTS omr, fnd_concurrent_requests fcr
3320: where fcr.REQUEST_ID (+) = omr.CONC_PROGRAM_REQUEST_ID