APPS.WSH_TRIPS_GRP SQL Statements

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

Line: 500

    SELECT  wdl.delivery_id, wt.name
    FROM    wsh_trip_stops wts,
            wsh_Delivery_legs wdl,
            wsh_new_deliveries wnd,
            wsh_trips wt
    WHERE   wt.trip_id                      = p_trip_id
    AND     wts.trip_id                     = p_trip_id
    AND     wdl.pick_up_stop_id             = wts.stop_id
    AND     wnd.delivery_id                 = wdl.delivery_id
    AND     wnd.initial_pickup_location_id  = wts.stop_location_id;

Line: 514

   SELECT WRS.Report_Set_Id
   FROM   Wsh_Report_Sets Wrs,
          Wsh_Report_Set_Lines Wrsl
   WHERE  Wrsl.Report_Set_Id = Wrs.Report_Set_Id
   AND    Wrs.Name = 'Master Bill of Lading';

Line: 706

              AND p_action_prms.action_code =  'DELETE'
             ) THEN  --BUG 4354579
       WSH_TRIPS_PVT.lock_trip(p_rec_attr_tab => p_rec_attr_tab,
                           p_caller       => p_action_prms.caller,
                           p_valid_index_tab  => l_valid_index_tab,
                           x_valid_ids_tab    => x_trip_out_rec.valid_ids_tab,
                           x_return_status => l_return_status);

Line: 763

         x_trip_out_rec.selection_issue_flag := 'Y';

Line: 850

                   p_action       => 'UPDATE',
                   x_return_status => l_return_status
          );

Line: 1009

          WSH_WV_UTILS.G_RESET_WV := 'Y'; -- set to Y to enable the update

Line: 1031

    ELSIF p_action_prms.action_code = 'DELETE' THEN
        WSH_UTIL_CORE.delete(
                  p_type                => 'TRIP',
                  p_rows                => l_trip_id_tab,
                  x_return_status       => l_return_status
        );

Line: 1044

           FND_MESSAGE.SET_NAME('WSH','WSH_UI_MULTI_SELECTION');

Line: 1047

              wsh_debug_sv.log (l_module_name,'WSH_UI_MULTI_SELECTION');

Line: 1233

    ELSIF p_action_prms.action_code = 'SELECT-CARRIER'  THEN
     IF wsh_util_core.fte_is_installed = 'Y' THEN
       IF p_rec_attr_tab.COUNT > 1 AND p_action_prms.caller = 'WSH_FSTRX' THEN
           FND_MESSAGE.SET_NAME('WSH','WSH_UI_MULTI_SELECTION');

Line: 1241

              wsh_debug_sv.log (l_module_name,'WSH_UI_MULTI_SELECTION');

Line: 1246

       WSH_TRIPS_ACTIONS.PROCESS_CARRIER_SELECTION(
              p_init_msg_list          =>  FND_API.G_FALSE,
              p_trip_id_tab            => l_trip_id_tab,
              p_caller                 => p_action_prms.caller, -- WSH_FSTRX / WSH_PUB /  WSH_GROUP/ FTE
              x_msg_count              => l_msg_count,
              x_msg_data               => l_msg_data,
              x_return_status          => l_return_status );

Line: 1780

  x_pvt_trip_rec.LAST_UPDATE_DATE		 := p_grp_trip_rec.LAST_UPDATE_DATE;

Line: 1781

  x_pvt_trip_rec.LAST_UPDATED_BY		 := p_grp_trip_rec.LAST_UPDATED_BY;

Line: 1782

  x_pvt_trip_rec.LAST_UPDATE_LOGIN		 := p_grp_trip_rec.LAST_UPDATE_LOGIN;

Line: 1785

  x_pvt_trip_rec.PROGRAM_UPDATE_DATE		 := p_grp_trip_rec.PROGRAM_UPDATE_DATE;

Line: 1830

 SELECT consolidation_allowed, vehicle_item_id, vehicle_organization_id, ship_method_code, carrier_id, service_level, mode_of_transport, lane_id
 FROM	wsh_trips
 WHERE	trip_id= p_trip_id;

Line: 1910

    IF p_action_code = 'UPDATE' THEN
	l_action := 'UPDATE';

Line: 2369

PROCEDURE Create_Update_Trip(
        p_api_version_number     IN      NUMBER,
        p_init_msg_list          IN     VARCHAR2,
        p_commit                 IN     VARCHAR2,
        p_trip_info_tab          IN     WSH_TRIPS_PVT.Trip_Attr_Tbl_Type,
        p_In_rec                 IN     tripInRecType,
        x_Out_Tab                OUT    NOCOPY trip_Out_Tab_Type,
        x_return_status          OUT    NOCOPY  VARCHAR2,
        x_msg_count              OUT    NOCOPY NUMBER,
        x_msg_data               OUT    NOCOPY  VARCHAR2) IS

l_api_version_number    CONSTANT NUMBER := 1.0;

Line: 2381

l_api_name              CONSTANT VARCHAR2(30) := 'Create_Update_Trip';

Line: 2383

l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'CREATE_UPDATE_TRIP';

Line: 2421

  SELECT wnd.organization_id, wnd.name, wt.ship_method_code, wt.carrier_id
  FROM wsh_new_deliveries wnd, wsh_trip_stops wts, wsh_delivery_legs wdl, wsh_trips wt
  WHERE wnd.delivery_id=wdl.delivery_id
      and wdl.pick_up_stop_id=wts.stop_id
      and wt.trip_id = p_tripid
      and wt.trip_id=wts.trip_id
      and wt.ignore_for_planning<>'Y'
      and rownum=1;

Line: 2450

 SAVEPOINT create_update_trip_grp;

Line: 2452

    wsh_debug_sv.push (l_module_name, 'Create_Update_Trip');

Line: 2482

 IF (p_in_rec.action_code IS NULL OR p_in_rec.action_code NOT IN ('CREATE','UPDATE','FTE_LOAD_TENDER') ) THEN
    FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');

Line: 2682

    ELSIF (p_in_rec.action_code = 'UPDATE' ) THEN

       IF p_in_rec.caller = 'WSH_FSTRX' THEN
          -- fill in the columns not queried into STF or QSUI
         SELECT
            ROUTING_RULE_ID,
            APPEND_FLAG,
            RANK_ID
         INTO
            l_trip_info_tab(x_valid_index_tab(l_index)).ROUTING_RULE_ID,
            l_trip_info_tab(x_valid_index_tab(l_index)).APPEND_FLAG,
            l_trip_info_tab(x_valid_index_tab(l_index)).RANK_ID
         FROM WSH_TRIPS
         WHERE ROWID = l_trip_info_tab(x_valid_index_tab(l_index)).rowid;

Line: 2698

       WSH_TRIPS_PVT.UPDATE_TRIP(
	p_rowid                 =>	l_trip_info_tab(x_valid_index_tab(l_index)).rowid,
	p_trip_info     	=>      l_trip_info_tab(x_valid_index_tab(l_index)),
	x_return_status      	=> 	l_return_status);

Line: 2749

      END IF;--call is for load tender update

Line: 2836

    END IF;--create or update

Line: 2887

     ROLLBACK TO create_update_trip_grp;

Line: 2899

     ROLLBACK TO create_update_trip_grp;

Line: 2911

     ROLLBACK TO create_update_trip_grp;

Line: 2928

     wsh_util_core.default_handler ('WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP');

Line: 2938

     ROLLBACK TO create_update_trip_grp;

Line: 2940

END CREATE_UPDATE_TRIP;

Line: 2959

PROCEDURE Create_Update_Trip_New
  ( p_api_version_number     IN   NUMBER,
    p_init_msg_list          IN   VARCHAR2,
    x_return_status          OUT NOCOPY   VARCHAR2,
    x_msg_count              OUT NOCOPY   NUMBER,
    x_msg_data               OUT NOCOPY   VARCHAR2,
    p_trip_info          IN OUT NOCOPY   Trip_Pub_Rec_Type,
    p_trip_IN_rec            IN  tripInRecType,
    p_trip_OUT_rec           OUT NOCOPY  tripOutRecType) IS

l_api_version_number CONSTANT NUMBER := 1.0;

Line: 2970

l_api_name           CONSTANT VARCHAR2(30):= 'Create_Update_Trip';

Line: 2972

l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'CREATE_UPDATE_TRIP_NEW';

Line: 3035

   WSH_INTERFACE_GRP.Create_Update_Trip(
        p_api_version_number     => p_api_version_number,
        p_init_msg_list          => p_init_msg_list,
        p_commit                 => l_commit,
        x_return_status          => x_return_status,
        x_msg_count              => x_msg_count,
        x_msg_data               => x_msg_data,
        p_trip_info_tab          => l_trip_info_tab,
        p_In_rec                 => p_trip_In_rec,
        x_Out_tab                => l_Out_Tab);

Line: 3047

       wsh_debug_sv.log (l_module_name,'In Wrapper Create_Update_Trip x_return_status',x_return_status);

Line: 3082

     wsh_util_core.default_handler ('WSH_TRIP_STOPS_GRP.CREATE_UPDATE_TRIP_NEW');

Line: 3088

END Create_Update_Trip_New;

Line: 3109

PROCEDURE Create_Update_Trip
  ( p_api_version_number     IN   NUMBER,
    p_init_msg_list          IN   VARCHAR2,
    x_return_status          OUT NOCOPY   VARCHAR2,
    x_msg_count              OUT NOCOPY   NUMBER,
    x_msg_data               OUT NOCOPY   VARCHAR2,
    p_action_code            IN   VARCHAR2,
    p_trip_info              IN OUT NOCOPY  Trip_Pub_Rec_Type,
    p_trip_name              IN   VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
    x_trip_id                OUT NOCOPY   NUMBER,
    x_trip_name              OUT NOCOPY   VARCHAR2) IS

l_api_version_number CONSTANT NUMBER := 1.0;

Line: 3122

l_api_name           CONSTANT VARCHAR2(30):= 'Create_Update_Trip';

Line: 3124

l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'CREATE_UPDATE_TRIP';

Line: 3193

   WSH_INTERFACE_GRP.Create_Update_Trip(
        p_api_version_number     => p_api_version_number,
        p_init_msg_list          => p_init_msg_list,
        p_commit                 => l_commit,
        x_return_status          => x_return_status,
        x_msg_count              => x_msg_count,
        x_msg_data               => x_msg_data,
        p_trip_info_tab          => l_trip_info_tab,
        p_In_rec                 => l_In_rec,
        x_Out_tab                => l_Out_Tab);

Line: 3205

       wsh_debug_sv.log (l_module_name,'In Wrapper Create_Update_Trip x_return_status',x_return_status);

Line: 3240

     wsh_util_core.default_handler ('WSH_TRIP_STOPS_GRP.CREATE_UPDATE_TRIP_NEW');

Line: 3246

END Create_Update_Trip;

Line: 3256

  SELECT TRIP_ID,
	  NAME,
	  ARRIVE_AFTER_TRIP_ID,
	  --FND_API.G_MISS_CHAR,  -- ARRIVE_AFTER_TRIP_NAME
	  VEHICLE_ITEM_ID,
	  --FND_API.G_MISS_CHAR,  -- VEHICLE_ITEM_DESC
	  VEHICLE_ORGANIZATION_ID,
	  --FND_API.G_MISS_CHAR,  -- VEHICLE_ORGANIZATION_CODE
	  VEHICLE_NUMBER,
	  VEHICLE_NUM_PREFIX,
	  CARRIER_ID,
	  SHIP_METHOD_CODE,
	  --FND_API.G_MISS_CHAR,  -- SHIP_METHOD_NAME
	  ROUTE_ID,
	  ROUTING_INSTRUCTIONS,
	  ATTRIBUTE_CATEGORY,
	  ATTRIBUTE1,
	  ATTRIBUTE2,
	  ATTRIBUTE3,
	  ATTRIBUTE4,
	  ATTRIBUTE5,
	  ATTRIBUTE6,
	  ATTRIBUTE7,
	  ATTRIBUTE8,
	  ATTRIBUTE9,
	  ATTRIBUTE10,
	  ATTRIBUTE11,
	  ATTRIBUTE12,
	  ATTRIBUTE13,
	  ATTRIBUTE14,
	  ATTRIBUTE15,
	  SERVICE_LEVEL,
	  MODE_OF_TRANSPORT,
	  CONSOLIDATION_ALLOWED,   --H integration
	  PLANNED_FLAG,
	  STATUS_CODE,
	  FREIGHT_TERMS_CODE,
	  LOAD_TENDER_STATUS,
	  ROUTE_LANE_ID,
	  LANE_ID,
	  SCHEDULE_ID,
	  BOOKING_NUMBER,
	  CREATION_DATE,
	  CREATED_BY,
	  LAST_UPDATE_DATE,
	  LAST_UPDATED_BY,
	  LAST_UPDATE_LOGIN,
	  PROGRAM_APPLICATION_ID,
	  PROGRAM_ID,
	  PROGRAM_UPDATE_DATE,
	  REQUEST_ID,
          nvl(SHIPMENTS_TYPE_FLAG, 'O'),  -- J inbound logistics jckwok
          OPERATOR
	FROM wsh_trips
   WHERE trip_id = v_trip_id;

Line: 3382

		l_stops_trip_rec.LAST_UPDATE_DATE,
		l_stops_trip_rec.LAST_UPDATED_BY,
		l_stops_trip_rec.LAST_UPDATE_LOGIN,
		l_stops_trip_rec.PROGRAM_APPLICATION_ID,
		l_stops_trip_rec.PROGRAM_ID,
		l_stops_trip_rec.PROGRAM_UPDATE_DATE,
		l_stops_trip_rec.REQUEST_ID,
                l_stops_trip_rec.SHIPMENTS_TYPE_FLAG, -- J Inbound Logistics jckwok
                l_stops_trip_rec.OPERATOR;