APPS.FND_CONCURRENT dependencies on DBMS_LOCK

Line 430: dbms_lock.sleep(interval);

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

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

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

Line 1595: dbms_lock.sleep(Interval);

1591:
1592: if (time_left <= Interval) then return FALSE; end if;
1593:
1594: /* If we still have time, take a nap before trying again */
1595: dbms_lock.sleep(Interval);
1596: end LOOP;
1597:
1598: end CHILDREN_DONE;
1599:

Line 2304: dbms_lock.sleep(5);

2300: elsif (timesup > 0) then
2301: return SCTL_TIMEOUT_NOT_R;
2302: end if;
2303:
2304: dbms_lock.sleep(5);
2305: END LOOP;
2306:
2307: end Wait_for_SCTL_Done;
2308:

Line 2383: dbms_lock.sleep(5);

2379:
2380: if (done > 0) then return FALSE;
2381: end if;
2382:
2383: dbms_lock.sleep(5);
2384: END LOOP;
2385:
2386: exception
2387: when others then

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

2616: begin
2617:
2618: lk := 'FND$_' || resource_name;
2619:
2620: dbms_lock.allocate_unique( lockname => lk,
2621: lockhandle => hndl );
2622:
2623: result := dbms_lock.request( lockhandle => hndl,
2624: lockmode => 6,

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

2619:
2620: dbms_lock.allocate_unique( lockname => lk,
2621: lockhandle => hndl );
2622:
2623: result := dbms_lock.request( lockhandle => hndl,
2624: lockmode => 6,
2625: timeout => timeout );
2626:
2627: return result;

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

2660: begin
2661:
2662: lk := 'FND$_' || resource_name;
2663:
2664: dbms_lock.allocate_unique( lockname => lk,
2665: lockhandle => hndl );
2666:
2667: result := dbms_lock.release( lockhandle => hndl );
2668:

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

2663:
2664: dbms_lock.allocate_unique( lockname => lk,
2665: lockhandle => hndl );
2666:
2667: result := dbms_lock.release( lockhandle => hndl );
2668:
2669: return result;
2670:
2671: exception

Line 2766: DBMS_LOCK.sleep(5);

2762: exit;
2763: exception
2764: when no_data_found then
2765: if (counter = 1) then
2766: DBMS_LOCK.sleep(5);
2767: elsif (counter > 1 and counter <= 4) then
2768: DBMS_LOCK.sleep(10);
2769: else
2770: -- no row found, most likely ran from the command line.

Line 2768: DBMS_LOCK.sleep(10);

2764: when no_data_found then
2765: if (counter = 1) then
2766: DBMS_LOCK.sleep(5);
2767: elsif (counter > 1 and counter <= 4) then
2768: DBMS_LOCK.sleep(10);
2769: else
2770: -- no row found, most likely ran from the command line.
2771: -- Initialize a default context:
2772: -- USER = ANONYMOUS (-1)