DBA Data[Home] [Help]

APPS.PO_HEADERS_PKG_S0 dependencies on PO_HEADERS_S

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

Line 554: UPDATE po_headers set segment1=x_segment1

550: );
551:
552: -- bug5176308 END
553:
554: UPDATE po_headers set segment1=x_segment1
555: ,clm_document_number = x_segment1
556: where po_header_id=x_po_header_id;
557:
558: /* bug# 465696 8/5/97. The previous fix to this performance problem introduced

Line 563: Therefore, removed the call below from po_headers_sv1.insert_row and moved

559: a problem with the notifications (the bogus value used temporarily as the
560: document number was being inserted into the fnd_notifications table, since
561: the call below was made before we called the procedure to get the real
562: document number (segment1) .
563: Therefore, removed the call below from po_headers_sv1.insert_row and moved
564: it to here.
565: */
566:
567: if (x_type_lookup_code not in ('RFQ', 'QUOTATION')) then