APPS.AD_ZD_SEED dependencies on DBMS_LOCK

Line 164: dbms_lock.allocate_unique(lockname => l_lock_name, lockhandle => l_lock_handle);

160: L_LOCK_NAME varchar2(128) := upper(x_lock_name);
161: L_LOCK_HANDLE varchar2(128) := null;
162: L_LOCK_STATUS integer;
163: begin
164: dbms_lock.allocate_unique(lockname => l_lock_name, lockhandle => l_lock_handle);
165: l_lock_status := dbms_lock.request(lockhandle => l_lock_handle,
166: lockmode => dbms_lock.x_mode,
167: timeout => dbms_lock.maxwait,
168: release_on_commit => false);

Line 165: l_lock_status := dbms_lock.request(lockhandle => l_lock_handle,

161: L_LOCK_HANDLE varchar2(128) := null;
162: L_LOCK_STATUS integer;
163: begin
164: dbms_lock.allocate_unique(lockname => l_lock_name, lockhandle => l_lock_handle);
165: l_lock_status := dbms_lock.request(lockhandle => l_lock_handle,
166: lockmode => dbms_lock.x_mode,
167: timeout => dbms_lock.maxwait,
168: release_on_commit => false);
169:

Line 166: lockmode => dbms_lock.x_mode,

162: L_LOCK_STATUS integer;
163: begin
164: dbms_lock.allocate_unique(lockname => l_lock_name, lockhandle => l_lock_handle);
165: l_lock_status := dbms_lock.request(lockhandle => l_lock_handle,
166: lockmode => dbms_lock.x_mode,
167: timeout => dbms_lock.maxwait,
168: release_on_commit => false);
169:
170: if (l_lock_status <> 0) then

Line 167: timeout => dbms_lock.maxwait,

163: begin
164: dbms_lock.allocate_unique(lockname => l_lock_name, lockhandle => l_lock_handle);
165: l_lock_status := dbms_lock.request(lockhandle => l_lock_handle,
166: lockmode => dbms_lock.x_mode,
167: timeout => dbms_lock.maxwait,
168: release_on_commit => false);
169:
170: if (l_lock_status <> 0) then
171: error(c_module, 'Unable to acquire lock: '||x_lock_name||

Line 193: l_lock_status := dbms_lock.release(x_lock_handle);

189: if x_lock_handle is null then
190: return;
191: end if;
192:
193: l_lock_status := dbms_lock.release(x_lock_handle);
194: if l_lock_status <> 0 then
195: error(c_module, 'Unable to release lock: '||x_lock_handle||' lock_status: '||l_lock_status);
196: end if;
197: