5: PRAGMA AUTONOMOUS_TRANSACTION;
6: lock_handle varchar2(128);
7: lock_result integer;
8: BEGIN
9: DBMS_LOCK.ALLOCATE_UNIQUE(QP_JAVA_ENGINE_UTIL_PUB.G_QP_INT_TABLES_LOCK, lock_handle);
10: lock_result := DBMS_LOCK.REQUEST(lock_handle, DBMS_LOCK.S_MODE, DBMS_LOCK.MAXWAIT, TRUE);
11: commit;
12: return lock_result;
13: END Request_Pricing_Lock;
6: lock_handle varchar2(128);
7: lock_result integer;
8: BEGIN
9: DBMS_LOCK.ALLOCATE_UNIQUE(QP_JAVA_ENGINE_UTIL_PUB.G_QP_INT_TABLES_LOCK, lock_handle);
10: lock_result := DBMS_LOCK.REQUEST(lock_handle, DBMS_LOCK.S_MODE, DBMS_LOCK.MAXWAIT, TRUE);
11: commit;
12: return lock_result;
13: END Request_Pricing_Lock;
14:
43: FUNCTION Release_Pricing_Lock return integer is
44: lock_handle varchar2(128);
45: lock_result integer;
46: BEGIN
47: DBMS_LOCK.ALLOCATE_UNIQUE(QP_JAVA_ENGINE_UTIL_PUB.G_QP_INT_TABLES_LOCK, lock_handle);
48: lock_result := DBMS_LOCK.RELEASE(lock_handle);
49: return lock_result;
50: END Release_Pricing_Lock;
51:
44: lock_handle varchar2(128);
45: lock_result integer;
46: BEGIN
47: DBMS_LOCK.ALLOCATE_UNIQUE(QP_JAVA_ENGINE_UTIL_PUB.G_QP_INT_TABLES_LOCK, lock_handle);
48: lock_result := DBMS_LOCK.RELEASE(lock_handle);
49: return lock_result;
50: END Release_Pricing_Lock;
51:
52: