DBA Data[Home] [Help]

APPS.XNP_EVENT dependencies on DBMS_LOCK

Line 257: DBMS_LOCK.sleep(5) ;

253:
254: SAVEPOINT after_pop ;
255:
256: IF ( l_error_code = XNP_ERRORS.G_DEQUEUE_TIMEOUT ) THEN
257: DBMS_LOCK.sleep(5) ;
258: RETURN ;
259: END IF ;
260:
261: xnp_message.validate ( l_msg_header,

Line 563: -- DBMS_LOCK.sleep(5) ;

559:
560: SAVEPOINT after_pop ;
561:
562: IF ( l_error_code = XNP_ERRORS.G_DEQUEUE_TIMEOUT ) THEN
563: -- DBMS_LOCK.sleep(5) ;
564: x_queue_timed_out := 'Y';
565: RETURN ;
566: END IF ;
567: