APPS.QP_PRICE_REQUEST_CONTEXT dependencies on QP_JAVA_ENGINE_UTIL_PUB

Line 9: DBMS_LOCK.ALLOCATE_UNIQUE(QP_JAVA_ENGINE_UTIL_PUB.G_QP_INT_TABLES_LOCK, lock_handle);

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;

Line 22: IF(QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'N') THEN

18: l_request_id NUMBER;
19: lock_result integer;
20: BEGIN
21:
22: IF(QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'N') THEN
23: -- changed for 5115618/5098611
24: l_request_id := nvl(SYS_CONTEXT('QP_CONTEXT','REQUEST_ID'),0) + 1;
25: ELSE
26: select QP_REQUEST_ID_S.nextval into l_request_id from dual;

Line 47: DBMS_LOCK.ALLOCATE_UNIQUE(QP_JAVA_ENGINE_UTIL_PUB.G_QP_INT_TABLES_LOCK, lock_handle);

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: