APPS.WSH_CONT_PKG SQL Statements

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

Line: 19

      SELECT           container_id, master_serial_number
      FROM             wsh_packed_containers
      WHERE            parent_container_id IS NULL
      START WITH       container_id        = P_container_id
      CONNECT BY PRIOR parent_container_id = container_id;

Line: 54

      SELECT           container_id
      FROM             wsh_packed_containers
      START WITH       parent_container_id = P_container_id
      CONNECT BY PRIOR container_id        = parent_container_id;

Line: 69

      UPDATE wsh_packed_containers
         SET master_container_id  = X_master_container_id,
             master_serial_number = X_master_serial_number
         WHERE container_id = L_container_id
         AND   delivery_id  = X_delivery_id;

Line: 114

PROCEDURE update_master_serial_number(
   X_master_serial_number IN     VARCHAR2,
   X_container_id         IN     NUMBER,
   X_delivery_id          IN     NUMBER,
   X_status               IN OUT NUMBER)
IS
  CURSOR get_child_cont(
     P_container_id NUMBER)
  IS
     SELECT           container_id
     FROM             wsh_packed_containers
     START WITH       parent_container_id = P_container_id
     CONNECT BY PRIOR container_id        = parent_container_id;

Line: 136

      UPDATE wsh_packed_containers
         SET master_serial_number = X_master_serial_number
         WHERE container_id = L_container_id
         AND   delivery_id  = X_delivery_id;

Line: 149

END update_master_serial_number;

Line: 161

      SELECT master_serial_number
      FROM wsh_packed_containers
      WHERE parent_sequence_number IS NULL
      START WITH sequence_number = p_sequence_number
      AND delivery_id = p_delivery_id
      CONNECT BY PRIOR parent_sequence_number = sequence_number
      AND delivery_id = p_delivery_id;