eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_HEADERS_PKG_S0 dependencies on PO_HEADERS_S

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

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

Line 539: UPDATE po_headers set segment1=x_segment1

535: );
536:
537: -- bug5176308 END
538:
539: UPDATE po_headers set segment1=x_segment1
540: where po_header_id=x_po_header_id;
541:
542: /* bug# 465696 8/5/97. The previous fix to this performance problem introduced
543: a problem with the notifications (the bogus value used temporarily as the

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

543: a problem with the notifications (the bogus value used temporarily as the
544: document number was being inserted into the fnd_notifications table, since
545: the call below was made before we called the procedure to get the real
546: document number (segment1) .
547: Therefore, removed the call below from po_headers_sv1.insert_row and moved
548: it to here.
549: */
550:
551: if (x_type_lookup_code not in ('RFQ', 'QUOTATION')) then