APPS.FND_CONCURRENT dependencies on DBMS_LOCK

Line 428: dbms_lock.sleep(interval);

424: dev_phase := req_phase;
425: return (call_status);
426: end if;
427: end if;
428: dbms_lock.sleep(interval);
429: END LOOP;
430:
431: exception
432: when others then

Line 467: result number; -- result code from DBMS_LOCK.Request_Lock

463: activep OUT NOCOPY number,
464: pmon_method OUT NOCOPY varchar2,
465: callstat OUT NOCOPY number) is
466: lkh FND_CONCURRENT_PROCESSES.Lk_Handle%TYPE;
467: result number; -- result code from DBMS_LOCK.Request_Lock
468: alive number; -- is process alive? 1=TRUE 0=FALSE
469: i number := 0;
470: errflag boolean := FALSE;
471: gothandle boolean;

Line 1486: dbms_lock.sleep(Interval);

1482:
1483: if (time_left <= Interval) then return FALSE; end if;
1484:
1485: /* If we still have time, take a nap before trying again */
1486: dbms_lock.sleep(Interval);
1487: end LOOP;
1488:
1489: end CHILDREN_DONE;
1490:

Line 2195: dbms_lock.sleep(5);

2191: elsif (timesup > 0) then
2192: return SCTL_TIMEOUT_NOT_R;
2193: end if;
2194:
2195: dbms_lock.sleep(5);
2196: END LOOP;
2197:
2198: end Wait_for_SCTL_Done;
2199:

Line 2274: dbms_lock.sleep(5);

2270:
2271: if (done > 0) then return FALSE;
2272: end if;
2273:
2274: dbms_lock.sleep(5);
2275: END LOOP;
2276:
2277: exception
2278: when others then

Line 2511: dbms_lock.allocate_unique( lockname => lk,

2507: begin
2508:
2509: lk := 'FND$_' || resource_name;
2510:
2511: dbms_lock.allocate_unique( lockname => lk,
2512: lockhandle => hndl );
2513:
2514: result := dbms_lock.request( lockhandle => hndl,
2515: lockmode => 6,

Line 2514: result := dbms_lock.request( lockhandle => hndl,

2510:
2511: dbms_lock.allocate_unique( lockname => lk,
2512: lockhandle => hndl );
2513:
2514: result := dbms_lock.request( lockhandle => hndl,
2515: lockmode => 6,
2516: timeout => timeout );
2517:
2518: return result;

Line 2555: dbms_lock.allocate_unique( lockname => lk,

2551: begin
2552:
2553: lk := 'FND$_' || resource_name;
2554:
2555: dbms_lock.allocate_unique( lockname => lk,
2556: lockhandle => hndl );
2557:
2558: result := dbms_lock.release( lockhandle => hndl );
2559:

Line 2558: result := dbms_lock.release( lockhandle => hndl );

2554:
2555: dbms_lock.allocate_unique( lockname => lk,
2556: lockhandle => hndl );
2557:
2558: result := dbms_lock.release( lockhandle => hndl );
2559:
2560: return result;
2561:
2562: exception

Line 2657: DBMS_LOCK.sleep(5);

2653: exit;
2654: exception
2655: when no_data_found then
2656: if (counter = 1) then
2657: DBMS_LOCK.sleep(5);
2658: elsif (counter > 1 and counter <= 4) then
2659: DBMS_LOCK.sleep(10);
2660: else
2661: -- no row found, most likely ran from the command line.

Line 2659: DBMS_LOCK.sleep(10);

2655: when no_data_found then
2656: if (counter = 1) then
2657: DBMS_LOCK.sleep(5);
2658: elsif (counter > 1 and counter <= 4) then
2659: DBMS_LOCK.sleep(10);
2660: else
2661: -- no row found, most likely ran from the command line.
2662: -- Initialize a default context:
2663: -- USER = ANONYMOUS (-1)