APPS.WSH_CONSOL_BATCHES_PKG SQL Statements

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

Line: 3

	procedure INSERT_ROW (
	  X_ROWID in out nocopy VARCHAR2,
	  X_BATCH_ID in out nocopy NUMBER,
	  X_FREIGHT_TERMS_CODE in VARCHAR2,
	  X_CARRIER_ID in NUMBER,
	  X_MODE_OF_TRANSPORT in VARCHAR2,
	  X_SERVICE_LEVEL in VARCHAR2,
	  X_LOADING_SEQUENCE in NUMBER,
	  X_INTMED_SHIP_TO_LOCATION_ID in NUMBER,
	  X_ULTI_SHIP_TO_LOCATION_ID in NUMBER,
	  X_ULTI_SHIP_TO_REGION in NUMBER,
	  X_ULTI_SHIP_TO_ZIP_FROM in NUMBER,
	  X_ULTI_SHIP_TO_ZIP_TO in NUMBER,
	  X_ULTI_SHIP_TO_ZONE in NUMBER,
	  X_INCL_STAGED_DEL_FLAG in VARCHAR2,
	  X_INCL_DEL_ASG_TRIPS_FLAG in VARCHAR2,
	  X_CR_TRIP_TO_ULTM_SHIP_TO in VARCHAR2,
	  X_ROUTE_TRIPS_FLAG in VARCHAR2,
	  X_RATE_TRIPS_FLAG in VARCHAR2,
	  X_TRIP_NAME_PREFIX in VARCHAR2,
	  X_ORGANIZATION_ID in NUMBER,
	  X_CONSOL_GROUPING_RULE_ID in NUMBER,
	  X_CONSOL_SHIP_TO_LOCATION_ID in NUMBER,
	  X_DROPOFF_START_DAYS in NUMBER,
	  X_DELIVERY_NAME_TO in VARCHAR2,
	  X_PICKUP_START_DAYS in NUMBER,
	  X_PICKUP_END_DAYS in NUMBER,
	  X_CUSTOMER_ID in NUMBER,
	  X_FOB_CODE in VARCHAR2,
	  X_DELIVERY_NAME_FROM in VARCHAR2,
	  X_SHIP_TO_OVERIDE_FLAG in VARCHAR2,
	  X_DROPOFF_END_DAYS in NUMBER,
	  X_PR_BATCH_ID in NUMBER,
	  X_MAX_TRIP_WEIGHT in NUMBER,
	  X_MAX_TRIP_WEIGHT_UOM in VARCHAR2,
	  X_CREATION_DATE in DATE,
	  X_CREATED_BY in NUMBER,
	  X_LAST_UPDATE_DATE in DATE,
	  X_LAST_UPDATED_BY in NUMBER,
	  X_LAST_UPDATE_LOGIN in NUMBER
	) is
	  user_id  NUMBER;

Line: 47

	   CURSOR C IS SELECT rowid FROM WSH_CONSOL_BATCHES
	         WHERE batch_id = l_batch_id;

Line: 50

	  CURSOR NEXTID IS SELECT wsh_consol_batches_s.nextval FROM sys.dual;

Line: 60

	  insert into WSH_CONSOL_BATCHES (
	    FREIGHT_TERMS_CODE,
	    CARRIER_ID,
	    MODE_OF_TRANSPORT,
	    SERVICE_LEVEL,
	    LOADING_SEQUENCE,
	    INTMED_SHIP_TO_LOCATION_ID,
	    ULTI_SHIP_TO_LOCATION_ID,
	    ULTI_SHIP_TO_REGION,
	    ULTI_SHIP_TO_ZIP_FROM,
	    ULTI_SHIP_TO_ZIP_TO,
	    ULTI_SHIP_TO_ZONE,
	    INCL_STAGED_DEL_FLAG,
	    INCL_DEL_ASG_TRIPS_FLAG,
	    CR_TRIP_TO_ULTM_SHIP_TO,
	    ROUTE_TRIPS_FLAG,
	    RATE_TRIPS_FLAG,
	    TRIP_NAME_PREFIX,
	    CREATION_DATE,
	    CREATED_BY,
	    LAST_UPDATE_DATE,
	    LAST_UPDATED_BY,
	    LAST_UPDATE_LOGIN,
	    BATCH_ID,
	    ORGANIZATION_ID,
	    CONSOL_GROUPING_RULE_ID,
	    CONSOL_SHIP_TO_LOCATION_ID,
	    DROPOFF_START_DAYS,
	    DELIVERY_NAME_TO,
	    PICKUP_START_DAYS,
	    PICKUP_END_DAYS,
	    CUSTOMER_ID,
	    FOB_CODE,
	    DELIVERY_NAME_FROM,
	    SHIP_TO_OVERIDE_FLAG,
	    DROPOFF_END_DAYS,
	    PR_BATCH_ID,
	    MAX_TRIP_WEIGHT,
	    MAX_TRIP_WEIGHT_UOM
	  ) values(
	    X_FREIGHT_TERMS_CODE,
	    X_CARRIER_ID,
	    X_MODE_OF_TRANSPORT,
	    X_SERVICE_LEVEL,
	    X_LOADING_SEQUENCE,
	    X_INTMED_SHIP_TO_LOCATION_ID,
	    X_ULTI_SHIP_TO_LOCATION_ID,
	    X_ULTI_SHIP_TO_REGION,
	    X_ULTI_SHIP_TO_ZIP_FROM,
	    X_ULTI_SHIP_TO_ZIP_TO,
	    X_ULTI_SHIP_TO_ZONE,
	    X_INCL_STAGED_DEL_FLAG,
	    X_INCL_DEL_ASG_TRIPS_FLAG,
	    X_CR_TRIP_TO_ULTM_SHIP_TO,
	    X_ROUTE_TRIPS_FLAG,
	    X_RATE_TRIPS_FLAG,
	    X_TRIP_NAME_PREFIX,
	    SYSDATE,
	    user_id,
	    SYSDATE,
	    user_id,
	    login_id,
	    l_batch_id,
	    X_ORGANIZATION_ID,
	    X_CONSOL_GROUPING_RULE_ID,
	    X_CONSOL_SHIP_TO_LOCATION_ID,
	    X_DROPOFF_START_DAYS,
	    X_DELIVERY_NAME_TO,
	    X_PICKUP_START_DAYS,
	    X_PICKUP_END_DAYS,
	    X_CUSTOMER_ID,
	    X_FOB_CODE,
	    X_DELIVERY_NAME_FROM,
	    X_SHIP_TO_OVERIDE_FLAG,
	    X_DROPOFF_END_DAYS,
	    X_PR_BATCH_ID,
	    X_MAX_TRIP_WEIGHT,
	    X_MAX_TRIP_WEIGHT_UOM);

Line: 148

	end INSERT_ROW;

Line: 185

	  cursor c1 is select
	      FREIGHT_TERMS_CODE,
	      CARRIER_ID,
	      MODE_OF_TRANSPORT,
	      SERVICE_LEVEL,
	      LOADING_SEQUENCE,
	      INTMED_SHIP_TO_LOCATION_ID,
	      ULTI_SHIP_TO_LOCATION_ID,
	      ULTI_SHIP_TO_REGION,
	      ULTI_SHIP_TO_ZIP_FROM,
	      ULTI_SHIP_TO_ZIP_TO,
	      ULTI_SHIP_TO_ZONE,
	      INCL_STAGED_DEL_FLAG,
	      INCL_DEL_ASG_TRIPS_FLAG,
	      CR_TRIP_TO_ULTM_SHIP_TO,
	      ROUTE_TRIPS_FLAG,
	      RATE_TRIPS_FLAG,
	      TRIP_NAME_PREFIX,
	      ORGANIZATION_ID,
	      CONSOL_GROUPING_RULE_ID,
	      CONSOL_SHIP_TO_LOCATION_ID,
	      DROPOFF_START_DAYS,
	      DELIVERY_NAME_TO,
	      PICKUP_START_DAYS,
	      PICKUP_END_DAYS,
	      CUSTOMER_ID,
	      FOB_CODE,
	      DELIVERY_NAME_FROM,
	      SHIP_TO_OVERIDE_FLAG,
	      DROPOFF_END_DAYS,
	      PR_BATCH_ID,
	      BATCH_ID
	    from WSH_CONSOL_BATCHES
	    where BATCH_ID = X_BATCH_ID
	    for update of BATCH_ID nowait;

Line: 228

	    FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');