DBA Data[Home] [Help]

APPS.PO_HEADERS_PKG_S0 dependencies on DUAL

Line 139: CURSOR C2 IS SELECT po_headers_s.nextval FROM sys.dual;

135: ) IS
136: CURSOR C IS SELECT rowid FROM PO_HEADERS
137: WHERE po_header_id = X_Po_Header_Id;
138:
139: CURSOR C2 IS SELECT po_headers_s.nextval FROM sys.dual;
140:
141: /* Ben: bug#465696 Locking the po_unique_identifier_control table at this
142: point of the form commit cycle is causing the performance problem.
143: It may take 5 to 10 seconds to commit a PO with many lines, shipments