APPS.PO_REQUISITION_LINES_PKG1 SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 31

        SELECT *
        FROM   PO_REQUISITION_LINES
        WHERE  rowid = X_Rowid
        FOR UPDATE of Requisition_Line_Id NOWAIT;

Line: 42

      FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');

Line: 102

  PROCEDURE Delete_Row(X_Rowid        VARCHAR2,
           X_transferred_to_oe_flag     OUT NOCOPY VARCHAR2) IS
  x_progress VARCHAR2(3) := NULL;

Line: 111

    SELECT requisition_header_id
    INTO   x_requisition_header_id
    FROM   po_requisition_lines
    WHERE  rowid = X_rowid;

Line: 122

    DELETE FROM PO_REQUISITION_LINES
    WHERE  rowid = X_Rowid;

Line: 133

    po_req_lines_sv.update_transferred_to_oe_flag (X_requisition_header_id,
             X_transferred_to_oe_flag);

Line: 139

      po_message_s.sql_error('DELETE_ROW',x_progress,sqlcode);

Line: 141

  END Delete_Row;