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.PJI_LAUNCH_UPP_MAIN dependencies on DBMS_LOCK

Line 657: DBMS_LOCK.SLEEP(60); --Bug 7235411 Added sleep to delay conc. request process to avoid deadlock.

653: /* Added above condition for bug 8416116 */
654:
655: l_request_id := -1;
656:
657: DBMS_LOCK.SLEEP(60); --Bug 7235411 Added sleep to delay conc. request process to avoid deadlock.
658:
659: if ( g_launch_type = 'RPPD' ) then -- sridhar_phase_1 ( p_temp_table_size = 666666 ) then -- sridhar_refresh add the call
660:
661: --raise_application_error(-20000,'sri Failing the process RPPD ');

Line 821: DBMS_LOCK.SLEEP(l_time_in_seconds);

817: -- then continue the loop, else here both the exit criteria are met.
818: -- the loop should exit after updating the status
819:
820: IF ( l_no_running_request = 'N' ) THEN
821: DBMS_LOCK.SLEEP(l_time_in_seconds);
822: END IF;
823:
824: -- After Sleeping for the above set time , now re-update the status of the
825: -- current running processes.