APPS.WSH_FTE_INTEGRATION SQL Statements

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

Line: 356

          p_stop_rec - record to be inserted/updated/deleted from wsh_trip_stops
          p_trip_rec - record to be inserted/updated/deleted from wsh_trips
          p_action         - Action called
Values of p_action are
ADD
UPDATE
DELETE
TRIP_SEGMENT_DELETE

*/

PROCEDURE trip_stop_validations
        ( p_stop_rec  IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type,
          p_trip_rec IN WSH_TRIPS_PVT.trip_rec_type,
          p_action              IN VARCHAR2,
          x_return_status OUT NOCOPY VARCHAR2
        ) IS

  l_stop_rec_old WSH_TRIP_STOPS_PVT.trip_stop_rec_type;

Line: 487

  ELSIF (p_action = 'UPDATE'
                 AND (p_stop_rec.stop_location_id <> FND_API.G_MISS_NUM)
                ) THEN

        l_stop_seg_IN.action_type := p_action;

Line: 533

  ELSIF (p_action = 'DELETE'
                 AND (p_stop_rec.stop_location_id <> FND_API.G_MISS_NUM)
                ) THEN

        l_stop_seg_IN.action_type := p_action;

Line: 571

  ELSIF (p_action = 'UPDATE'
                 AND (p_trip_rec.trip_id <> FND_API.G_MISS_NUM)
                ) THEN

        l_trip_seg_IN.action_type := p_action;

Line: 616

  ELSIF (p_action = 'DELETE'
                 AND (p_trip_rec.trip_id <> FND_API.G_MISS_NUM)
                ) THEN
        l_trip_seg_IN.action_type := p_action;

Line: 649

        IF p_action NOT IN ('ADD','UPDATE','DELETE') THEN
           FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CALL_TO_FTE');

Line: 775

SELECT vehicle_type_id
FROM   fte_vehicle_types
WHERE  inventory_item_id = p_vehicle_item_id AND
       organization_id = p_vehicle_org_id;

Line: 911

             UPDATE wsh_delivery_legs
             SET reprice_required='Y',
                 last_update_date = SYSDATE,
                 last_updated_by =  FND_GLOBAL.USER_ID,
                 last_update_login =  FND_GLOBAL.LOGIN_ID
             WHERE NVL(reprice_required, 'N') ='N'
               and pick_up_stop_id IN
                    (select stop_id
                     from wsh_trip_stops wts, wsh_trips wt
                     where wts.trip_id=wt.trip_id
                     and wt.trip_id=l_action_param_rec.trip_id_list(i)
                     and wt.lane_id is not null
                    );

Line: 1140

PROCEDURE CARRIER_SELECTION( p_format_cs_tab		IN  OUT  NOCOPY		WSH_FTE_INTEGRATION.wsh_cs_entity_tab_type,
			     p_messaging_yn		IN			VARCHAR2,
			     p_caller			IN			VARCHAR2,
                             p_entity                   IN                      VARCHAR2,
			     x_cs_output_tab		OUT	NOCOPY		WSH_FTE_INTEGRATION.wsh_cs_result_tab_type,
		             x_cs_output_message_tab	OUT	NOCOPY		WSH_FTE_INTEGRATION.wsh_cs_output_message_tab,
			     x_return_message		OUT	NOCOPY		VARCHAR2,
			     x_return_status		OUT	NOCOPY		VARCHAR2) IS

--
-- Local Variable Declarations
--
l_fte_format_cs_tab		FTE_ACS_PKG.fte_cs_entity_tab_type;

Line: 1174

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

Line: 1324

         WSH_DEBUG_SV.logmsg(l_module_name,  'THE UNEXPECTED ERROR FROM WSH_FTE_INTEGRATION.CARRIER_SELECTION IS ' ||L_ERROR_TEXT  );

Line: 1327

      WSH_UTIL_CORE.default_handler('WSH_FTE_INTEGRATION.CARRIER_SELECTION');

Line: 1337

END CARRIER_SELECTION;

Line: 1489

    SELECT MOVE_ID
    FROM   FTE_TRIP_MOVES
    WHERE  TRIP_ID = c_trip_id;

Line: 1822

                            'Selecting WSH_TRIPS into rank list');

Line: 1826

        SELECT
               p_source         SOURCE,
               1                RANK_SEQUENCE,
               TO_CHAR(NULL)    CALL_RG_FLAG,
               TO_DATE(NULL)    SCHEDULE_FROM,
               TO_DATE(NULL)    SCHEDULE_TO,
               TO_NUMBER(NULL)  ESTIMATED_RATE,
               TO_CHAR(NULL)    CURRENCY_CODE,
               TO_NUMBER(NULL)  ESTIMATED_TRANSIT_TIME,
               TO_CHAR(NULL)    TRANSIT_TIME_UOM,
               wt.TRIP_ID,
               wt.RANK_ID,
               wt.LANE_ID,
               wt.CARRIER_ID,
               wt.SERVICE_LEVEL,
               wt.MODE_OF_TRANSPORT,
               wt.VEHICLE_ORGANIZATION_ID  VEHICLE_ORG_ID,
               wt.VEHICLE_ITEM_ID,
               wt.CONSIGNEE_CARRIER_AC_NO,
               wt.FREIGHT_TERMS_CODE,
               wt.SCHEDULE_ID,
               wt.ATTRIBUTE_CATEGORY,
               wt.ATTRIBUTE1,
               wt.ATTRIBUTE2,
               wt.ATTRIBUTE3,
               wt.ATTRIBUTE4,
               wt.ATTRIBUTE5,
               wt.ATTRIBUTE6,
               wt.ATTRIBUTE7,
               wt.ATTRIBUTE8,
               wt.ATTRIBUTE9,
               wt.ATTRIBUTE10,
               wt.ATTRIBUTE11,
               wt.ATTRIBUTE12,
               wt.ATTRIBUTE13,
               wt.ATTRIBUTE14,
               wt.ATTRIBUTE15
        INTO
               l_ranklist.SOURCE(i),
               l_ranklist.RANK_SEQUENCE(i),
               l_ranklist.CALL_RG_FLAG(i),
               l_ranklist.SCHEDULE_FROM(i),
               l_ranklist.SCHEDULE_TO(i),
               l_ranklist.ESTIMATED_RATE(i),
               l_ranklist.CURRENCY_CODE(i),
               l_ranklist.ESTIMATED_TRANSIT_TIME(i),
               l_ranklist.TRANSIT_TIME_UOM(i),
               l_ranklist.TRIP_ID(i),
               l_ranklist.RANK_ID(i),
               l_ranklist.LANE_ID(i),
               l_ranklist.CARRIER_ID(i),
               l_ranklist.SERVICE_LEVEL(i),
               l_ranklist.MODE_OF_TRANSPORT(i),
               l_ranklist.VEHICLE_ORG_ID(i),
               l_ranklist.VEHICLE_ITEM_ID(i),
               l_ranklist.CONSIGNEE_CARRIER_AC_NO(i),
               l_ranklist.FREIGHT_TERMS_CODE(i),
               l_ranklist.SCHEDULE_ID(i),
               l_ranklist.ATTRIBUTE_CATEGORY(i),
               l_ranklist.ATTRIBUTE1(i),
               l_ranklist.ATTRIBUTE2(i),
               l_ranklist.ATTRIBUTE3(i),
               l_ranklist.ATTRIBUTE4(i),
               l_ranklist.ATTRIBUTE5(i),
               l_ranklist.ATTRIBUTE6(i),
               l_ranklist.ATTRIBUTE7(i),
               l_ranklist.ATTRIBUTE8(i),
               l_ranklist.ATTRIBUTE9(i),
               l_ranklist.ATTRIBUTE10(i),
               l_ranklist.ATTRIBUTE11(i),
               l_ranklist.ATTRIBUTE12(i),
               l_ranklist.ATTRIBUTE13(i),
               l_ranklist.ATTRIBUTE14(i),
               l_ranklist.ATTRIBUTE15(i)
        FROM   wsh_trips wt
        WHERE  trip_id = p_trip_id_tab(i);