APPS.PO_REQUISITION_HEADERS_PKG dependencies on PO_REQUISITION_HEADERS_S

Line 63: CURSOR S IS SELECT po_requisition_headers_s.nextval FROM sys.dual;

59: CURSOR C IS SELECT rowid FROM PO_REQUISITION_HEADERS
60: WHERE requisition_header_id = X_Requisition_Header_Id;
61:
62:
63: CURSOR S IS SELECT po_requisition_headers_s.nextval FROM sys.dual;
64:
65: /* Ben: bug#465696 Locking the po_unique_identifier_control table at this
66: point of the form commit cycle is causing the performance problem.
67: It may take 5 to 10 seconds to commit a PO with many lines, shipments

Line 297: UPDATE po_requisition_headers set segment1=x_segment1

293: );
294: -- bug5176308 END
295:
296:
297: UPDATE po_requisition_headers set segment1=x_segment1
298: where requisition_header_id=x_requisition_header_id;
299:
300: /* bug# 465696 8/5/97. The previous fix to this performance problem introduced
301: a problem with the notifications (the bogus value used temporarily as the