APPS.QP_JAVA_ENGINE_SUPPORT_PVT dependencies on DBMS_LOCK

Line 23: dbms_lock.allocate_unique(p_lock_name, l_lock_handle);

19:
20: l_lock_handle varchar2(128);
21: l_status number;
22: begin
23: dbms_lock.allocate_unique(p_lock_name, l_lock_handle);
24: l_status := dbms_lock.request(l_lock_handle, p_lock_mode, p_timeout, p_release_on_commit);
25: return l_status;
26: end request_lock;
27:

Line 24: l_status := dbms_lock.request(l_lock_handle, p_lock_mode, p_timeout, p_release_on_commit);

20: l_lock_handle varchar2(128);
21: l_status number;
22: begin
23: dbms_lock.allocate_unique(p_lock_name, l_lock_handle);
24: l_status := dbms_lock.request(l_lock_handle, p_lock_mode, p_timeout, p_release_on_commit);
25: return l_status;
26: end request_lock;
27:
28: function release_lock(p_lock_name in varchar2) return number is

Line 33: dbms_lock.allocate_unique(p_lock_name, l_lock_handle);

29:
30: l_lock_handle varchar2(128);
31: l_status number;
32: begin
33: dbms_lock.allocate_unique(p_lock_name, l_lock_handle);
34: l_status := dbms_lock.release(l_lock_handle);
35: return l_status;
36: end release_lock;
37:

Line 34: l_status := dbms_lock.release(l_lock_handle);

30: l_lock_handle varchar2(128);
31: l_status number;
32: begin
33: dbms_lock.allocate_unique(p_lock_name, l_lock_handle);
34: l_status := dbms_lock.release(l_lock_handle);
35: return l_status;
36: end release_lock;
37:
38: end QP_JAVA_ENGINE_SUPPORT_PVT;