DBA Data[Home] [Help]

APPS.QP_PRICE_REQUEST_CONTEXT dependencies on DUAL

Line 26: select QP_REQUEST_ID_S.nextval into l_request_id from dual;

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;
27: --try to wait for S-Lock on Interface Tables before proceeding to request_price
28: lock_result := Request_Pricing_Lock;
29:
30: --clear the interface tables stat info