APPS.GMD_ROUT_MIGRATION SQL Statements

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

Line: 4

  PROCEDURE  INSERT_ROUT_STATUS IS
    /*Cursor to get all the routing information */
    CURSOR Cur_routing IS
      SELECT *
      FROM   gmd_routings_b r
      WHERE  EXISTS (Select 1
                     from   gmd_routings_b
                     Where  routing_id = r.routing_id AND
                            routing_status  IS NULL)
      ORDER BY routing_id;

Line: 16

      SELECT formula_Id
      FROM   fm_form_eff_bak
      WHERE  routing_Id = prouting_id;

Line: 49

      IF ((rout_rec.inactive_ind = 1) OR (rout_rec.delete_mark = 1)) THEN
         l_routing_status := '1000';

Line: 53

      UPDATE  gmd_routings_b
         SET  process_loss            = 0,
              effective_start_date    = rout_rec.creation_date ,
              effective_end_date      = NULL,
              owner_id                = rout_rec.created_by,
              project_id              = null,
              routing_status          = l_routing_status,
              owner_orgn_code         = l_orgn_code
       WHERE  routing_id = rout_rec.routing_id ;

Line: 65

          GMD_RECIPE_MIGRATION.insert_message (p_source_table => 'FM_ROUT_HDR'
                                   ,p_target_table => 'GMD_ROUTINGS_B'
                                   ,p_source_id    => rout_rec.routing_id
                                   ,p_target_id    => rout_rec.routing_id
                                   ,p_message      => error_msg
                                   ,p_error_type   => 'U');

Line: 74

  END INSERT_ROUT_STATUS;

Line: 77

  PROCEDURE  INSERT_TRANSFER_PERCENT IS
  /* Procedure to update transfer_percent column to 100% in fm_rout_dep table */
  BEGIN
    UPDATE Fm_Rout_Dep
    SET Transfer_Pct = 100
    WHERE transfer_pct IS NULL;

Line: 84

    update fm_rout_dep
    set max_delay = NULL
    where max_delay = 0;

Line: 87

  END INSERT_TRANSFER_PERCENT;