APPS.AD_CONC_SESSION_LOCKS dependencies on DBMS_LOCK

Line 20: dbms_lock.allocate_unique('ORA_APPS_AD_LOCKMGR', l_lockhandle);

16: l_lockhandle varchar2(128);
17: l_status number := 100;
18: l_exit_loop boolean := FALSE;
19: begin
20: dbms_lock.allocate_unique('ORA_APPS_AD_LOCKMGR', l_lockhandle);
21: --
22: l_exit_loop := FALSE;
23: --
24: loop

Line 27: l_status := dbms_lock.request(l_lockhandle);

23: --
24: loop
25: exit when l_exit_loop;
26: --
27: l_status := dbms_lock.request(l_lockhandle);
28: --
29: if l_status in (0, 4) then
30: -- 0 => success
31: -- 1 => already held. deem as success.

Line 60: dbms_lock.allocate_unique('ORA_APPS_AD_LOCKMGR', l_lockhandle);

56: l_lockhandle varchar2(128);
57: l_status number := 100;
58: l_exit_loop boolean := FALSE;
59: begin
60: dbms_lock.allocate_unique('ORA_APPS_AD_LOCKMGR', l_lockhandle);
61: --
62: l_exit_loop := FALSE;
63: --
64: loop

Line 67: l_status := dbms_lock.request(l_lockhandle, 6, timeout_period, FALSE);

63: --
64: loop
65: exit when l_exit_loop;
66: --
67: l_status := dbms_lock.request(l_lockhandle, 6, timeout_period, FALSE);
68: --
69: if l_status in (0, 1, 4) then
70: -- 0 => success
71: -- 1 => already held. deem as success.

Line 109: dbms_lock.allocate_unique('ORA_APPS_AD_LOCKMGR',l_lockhandle);

105: l_lockhandle varchar2(128);
106: l_status number := 100;
107: l_exit_loop boolean := FALSE;
108: begin
109: dbms_lock.allocate_unique('ORA_APPS_AD_LOCKMGR',l_lockhandle);
110: --
111: l_exit_loop := FALSE;
112: --
113: loop

Line 117: l_status:=dbms_lock.release(l_lockhandle);

113: loop
114: --
115: exit when l_exit_loop;
116: --
117: l_status:=dbms_lock.release(l_lockhandle);
118: --
119: if l_status in (0, 4) then
120: -- 0 => success
121: -- 1 => already held. deem as success.

Line 1166: dbms_lock.sleep(sleep_duration);

1162:
1163: held_lock := 0; /* Lock is not held at present */
1164:
1165: /* Delay or sleep here */
1166: dbms_lock.sleep(sleep_duration);
1167:
1168: /* Get DB admin lock */
1169: get_admin_lock(lock_status);
1170: if (lock_status <> 0) then