APPS.FTE_TP_GRP SQL Statements

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

Line: 12

    SELECT fm.move_id,
           fm.cm_trip_number,
           fm.planned_flag,
           ftm.sequence_number
    FROM   FTE_MOVES      fm,
           FTE_TRIP_MOVES ftm
    WHERE  ftm.trip_id = x_trip_id
    AND    fm.move_id  = ftm.move_id
    AND    fm.move_type_code = 'CONTINUOUS';

Line: 129

    SELECT fm.move_id,
           fm.move_type_code,
           fm.lane_id,
           fm.service_level,
           fm.planned_flag,
           fm.cm_trip_number,
           fm.tp_plan_name,
           fm.creation_date,
           fm.created_by,
           fm.last_update_date,
           fm.last_updated_by,
           fm.last_update_login,
           fm.program_application_id,
           fm.program_id,
           fm.program_update_date,
           fm.request_id,
           fm.attribute_category,
           fm.attribute1,
           fm.attribute2,
           fm.attribute3,
           fm.attribute4,
           fm.attribute5,
           fm.attribute6,
           fm.attribute7,
           fm.attribute8,
           fm.attribute9,
           fm.attribute10,
           fm.attribute11,
           fm.attribute12,
           fm.attribute13,
           fm.attribute14,
           fm.attribute15
    FROM   FTE_MOVES fm
    WHERE  fm.move_id = x_move_id;

Line: 165

    SELECT fm.move_id,
           fm.move_type_code,
           fm.lane_id,
           fm.service_level,
           fm.planned_flag,
           fm.cm_trip_number,
           fm.tp_plan_name,
           fm.creation_date,
           fm.created_by,
           fm.last_update_date,
           fm.last_updated_by,
           fm.last_update_login,
           fm.program_application_id,
           fm.program_id,
           fm.program_update_date,
           fm.request_id,
           fm.attribute_category,
           fm.attribute1,
           fm.attribute2,
           fm.attribute3,
           fm.attribute4,
           fm.attribute5,
           fm.attribute6,
           fm.attribute7,
           fm.attribute8,
           fm.attribute9,
           fm.attribute10,
           fm.attribute11,
           fm.attribute12,
           fm.attribute13,
           fm.attribute14,
           fm.attribute15
    FROM   FTE_MOVES fm
    WHERE  fm.move_id = x_move_id
    FOR UPDATE NOWAIT;

Line: 202

      SELECT ftm.trip_move_id
      FROM   FTE_TRIP_MOVES ftm
      WHERE  ftm.move_id = x_move_id
      FOR UPDATE NOWAIT;

Line: 439

  IF p_action_prms.action_code IN ('PLAN', 'UNPLAN', 'DELETE')  THEN

    i := p_rec_attr_tab.FIRST;

Line: 481

          l_move_rec.last_updated_by  := FND_GLOBAL.user_id;

Line: 482

          l_move_rec.last_update_date := SYSDATE;

Line: 484

          fte_moves_pvt.update_move(
             p_move_info     => l_move_rec,
             x_return_status => l_return_status);

Line: 493

        ELSIF p_action_prms.action_code = 'DELETE' THEN

          lookup_move(
              p_move_id       => l_int_cm_info_rec.move_id,
              p_lock_flag     => 'Y',
              x_move_rec      => l_move_rec,
              x_locked        => l_locked,
              x_return_status => l_return_status);

Line: 507

          fte_moves_pvt.delete_move(
                p_move_id       => l_int_cm_info_rec.move_id,
                p_validate_flag => 'Y',
                x_return_status => l_return_status);

Line: 662

    SELECT DISTINCT fmi.move_interface_id,
           fmi.move_id,
           NVL(fmi.move_type_code, 'CONTINUOUS') move_type_code,
           fmi.lane_id,
           fmi.service_level,
           fmi.planned_flag,
           fmi.tp_plan_name,
           fmi.cm_trip_number
    FROM  fte_moves_interface      fmi,
          fte_trip_moves_interface ftmi,
          wsh_trips_interface      wti
    WHERE wti.group_id = x_group_id
    AND   wti.interface_action_code = G_TP_RELEASE_CODE
    AND   ftmi.trip_interface_id = wti.trip_interface_id
    AND   ftmi.interface_action_code = G_TP_RELEASE_CODE
    AND   fmi.move_interface_id = ftmi.move_interface_id
    AND   fmi.interface_action_code = G_TP_RELEASE_CODE
    ORDER BY fmi.move_interface_id;

Line: 682

    SELECT ftmi.trip_move_interface_id,
           ftmi.trip_move_id,
           ftmi.move_interface_id,
           ftmi.move_id,
           ftmi.trip_interface_id,
           ftmi.trip_id,
           ftmi.sequence_number
    FROM   fte_trip_moves_interface ftmi
    WHERE  ftmi.move_interface_id = x_move_interface_id
    AND    ftmi.interface_action_code = G_TP_RELEASE_CODE
    ORDER BY ftmi.sequence_number;

Line: 695

    SELECT ftm.move_id,
           ftm.trip_move_id,
           ftm.trip_id,
           ftm.sequence_number
    FROM   fte_trip_moves ftm
    WHERE  ftm.move_id = x_move_id
    ORDER BY ftm.sequence_number;

Line: 706

    SELECT trip_id
    FROM   fte_trip_moves
    WHERE  move_id = x_move_id;

Line: 763

    l_unmapped_trip_moves.DELETE;

Line: 921

               l_unmapped_trip_moves.DELETE(l_map_index);

Line: 1233

        fte_moves_pvt.delete_move(
              p_move_id       => x_obsoleted_trip_moves(l_tm_index).move_id,
              p_validate_flag => 'Y',
              x_return_status => l_return_status);

Line: 1245

                      p_message_name        => 'WSH_TP_F_DELETE_OBS_MOVE',
                      p_token_1_name        => 'MOVE_ID',
                      p_token_1_value       => x_obsoleted_trip_moves(l_tm_index).move_id,
                      x_errors_tab          => x_errors_tab,
                      x_return_status       => l_return_status);

Line: 1259

        fte_trip_moves_pvt.delete_trip_moves(
              p_trip_move_id       => x_obsoleted_trip_moves(l_tm_index).trip_move_id,
              x_return_status      => l_return_status);

Line: 1270

                      p_message_name        => 'WSH_TP_F_DELETE_OBS_MOVE',
                      p_token_1_name        => 'MOVE_ID',
                      p_token_1_value       => x_obsoleted_trip_moves(l_tm_index).move_id,
                      x_errors_tab          => x_errors_tab,
                      x_return_status       => l_return_status);

Line: 1324

        fte_moves_pvt.update_move(
               p_move_info     => l_move_rec,
               x_return_status => l_return_status);

Line: 1333

                      p_message_name        => 'WSH_TP_F_UPDATE_MOVE',
                      p_token_1_name        => 'MOVE_ID',
                      p_token_1_value       => x_plan_moves(l_m_index).move_id,
                      x_errors_tab          => x_errors_tab,
                      x_return_status       => l_return_status);

Line: 1374

          fte_trip_moves_pvt.update_trip_moves(
                 p_trip_moves_info => l_trip_move_rec,
                 x_return_status   => l_return_status);

Line: 1383

                        p_message_name        => 'WSH_TP_F_UPDATE_TRIP_MOVE',
                        x_errors_tab          => x_errors_tab,
                        x_return_status       => l_return_status);

Line: 1496

        fte_moves_pvt.update_move(
               p_move_info     => l_move_rec,
               x_return_status => l_return_status);

Line: 1590

    delete from fte_moves_interface fmi
    where fmi.move_interface_id in (
      select distinct ftmi.move_interface_id
      from   fte_trip_moves_interface ftmi,
             wsh_trips_interface      wti
      where wti.group_id = p_group_ids(i)
      and   wti.interface_action_code = G_TP_RELEASE_CODE
      and   ftmi.trip_interface_id = wti.trip_interface_id
      and   ftmi.interface_action_code = G_TP_RELEASE_CODE)
    and fmi.interface_action_code = G_TP_RELEASE_CODE;

Line: 1603

    delete from fte_trip_moves_interface ftmi
    where ftmi.trip_move_interface_id in (
      select ftmi2.trip_move_interface_id
      from   fte_trip_moves_interface ftmi2,
             wsh_trips_interface      wti
      where wti.group_id = p_group_ids(i)
      and   wti.interface_action_code = G_TP_RELEASE_CODE
      and   ftmi2.trip_interface_id = wti.trip_interface_id
      and   ftmi2.interface_action_code = G_TP_RELEASE_CODE)
    and ftmi.interface_action_code = G_TP_RELEASE_CODE;