APPS.AD_LOCK_UTILS_PKG dependencies on DBMS_LOCK

Line 14: -- This is defined as an autonomous transaction as DBMS_LOCK.Allocate_Unique does an implicit

10: -- Procedure Allocate_Handle
11: --
12: -- Allocates lockhandle for a given lock
13: --
14: -- This is defined as an autonomous transaction as DBMS_LOCK.Allocate_Unique does an implicit
15: -- commit
16: --
17: PROCEDURE Allocate_Handle(
18: p_LockName IN VARCHAR2 ,

Line 24: DBMS_LOCK.ALLOCATE_UNIQUE(

20: IS
21: PRAGMA AUTONOMOUS_TRANSACTION ;
22: l_LockHandle VARCHAR2(128);
23: BEGIN
24: DBMS_LOCK.ALLOCATE_UNIQUE(
25: lockname => p_LockName,
26: lockhandle => l_LockHandle);
27: x_LockHandle := l_LockHandle;
28:

Line 49: l_reqid := dbms_lock.request(lockhandle=>x_LockHandle,

45: g_LockHandle := x_LockHandle;
46: g_LockName := p_LockName;
47: END IF;
48:
49: l_reqid := dbms_lock.request(lockhandle=>x_LockHandle,
50: lockmode=>p_LockMode,
51: timeout=>dbms_lock.maxwait,
52: release_on_commit=>p_Release_On_Commit);
53:

Line 51: timeout=>dbms_lock.maxwait,

47: END IF;
48:
49: l_reqid := dbms_lock.request(lockhandle=>x_LockHandle,
50: lockmode=>p_LockMode,
51: timeout=>dbms_lock.maxwait,
52: release_on_commit=>p_Release_On_Commit);
53:
54: IF (l_reqid <> 0) THEN
55: raise_application_error(-20001,

Line 56: 'dbms_lock.request('|| g_LockHandle ||

52: release_on_commit=>p_Release_On_Commit);
53:
54: IF (l_reqid <> 0) THEN
55: raise_application_error(-20001,
56: 'dbms_lock.request('|| g_LockHandle ||
57: ', ' || p_LockMode ||
58: ', ' || dbms_lock.maxwait ||
59: ') returned : ' || l_reqid);
60: END IF;

Line 58: ', ' || dbms_lock.maxwait ||

54: IF (l_reqid <> 0) THEN
55: raise_application_error(-20001,
56: 'dbms_lock.request('|| g_LockHandle ||
57: ', ' || p_LockMode ||
58: ', ' || dbms_lock.maxwait ||
59: ') returned : ' || l_reqid);
60: END IF;
61: END;
62:

Line 86: l_LockStatus := DBMS_LOCK.RELEASE(

82: IS
83: l_LockStatus number;
84: BEGIN
85:
86: l_LockStatus := DBMS_LOCK.RELEASE(
87: lockhandle => p_LockHandle);
88:
89: IF (l_LockStatus <> 0) THEN
90: raise_application_error(-20001, 'DBMS_LOCK.release() returned '||l_LockStatus);

Line 90: raise_application_error(-20001, 'DBMS_LOCK.release() returned '||l_LockStatus);

86: l_LockStatus := DBMS_LOCK.RELEASE(
87: lockhandle => p_LockHandle);
88:
89: IF (l_LockStatus <> 0) THEN
90: raise_application_error(-20001, 'DBMS_LOCK.release() returned '||l_LockStatus);
91: END IF;
92: END;
93:
94: PROCEDURE Release_Lock(p_LockName IN VARCHAR2)

Line 114: p_LockMode=>DBMS_LOCK.X_MODE,

110: PROCEDURE Acquire_PDML_Lock
111: IS
112: BEGIN
113: Get_Lock(p_LockName=>PDML_LOCK_NAME,
114: p_LockMode=>DBMS_LOCK.X_MODE,
115: p_Release_On_Commit=>FALSE);
116: END;
117:
118: PROCEDURE Release_PDML_Lock