APPS.WSH_CARRIER_VEHICLE_TYPES_PKG SQL Statements

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

Line: 91

    WSH_DEBUG_SV.log(l_module_name,'Inserting into WSH_CARRIER_VEHICLE_TYPES');

Line: 94

  insert into WSH_CARRIER_VEHICLE_TYPES (
    CARRIER_ID,
    VEHICLE_TYPE_ID,
    ASSIGNED_FLAG,
    ATTRIBUTE_CATEGORY,
    ATTRIBUTE1,
    ATTRIBUTE2,
    ATTRIBUTE3,
    ATTRIBUTE4,
    ATTRIBUTE5,
    ATTRIBUTE6,
    ATTRIBUTE7,
    ATTRIBUTE8,
    ATTRIBUTE9,
    ATTRIBUTE10,
    ATTRIBUTE11,
    ATTRIBUTE12,
    ATTRIBUTE13,
    ATTRIBUTE14,
    ATTRIBUTE15,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    P_Carrier_Vehicle_Info.CARRIER_ID,
    P_Carrier_Vehicle_Info.VEHICLE_TYPE_ID,
    P_Carrier_Vehicle_Info.ASSIGNED_FLAG,
    P_Carrier_Vehicle_Info.ATTRIBUTE_CATEGORY,
    P_Carrier_Vehicle_Info.ATTRIBUTE1,
    P_Carrier_Vehicle_Info.ATTRIBUTE2,
    P_Carrier_Vehicle_Info.ATTRIBUTE3,
    P_Carrier_Vehicle_Info.ATTRIBUTE4,
    P_Carrier_Vehicle_Info.ATTRIBUTE5,
    P_Carrier_Vehicle_Info.ATTRIBUTE6,
    P_Carrier_Vehicle_Info.ATTRIBUTE7,
    P_Carrier_Vehicle_Info.ATTRIBUTE8,
    P_Carrier_Vehicle_Info.ATTRIBUTE9,
    P_Carrier_Vehicle_Info.ATTRIBUTE10,
    P_Carrier_Vehicle_Info.ATTRIBUTE11,
    P_Carrier_Vehicle_Info.ATTRIBUTE12,
    P_Carrier_Vehicle_Info.ATTRIBUTE13,
    P_Carrier_Vehicle_Info.ATTRIBUTE14,
    P_Carrier_Vehicle_Info.ATTRIBUTE15,
    P_Carrier_Vehicle_Info.CREATION_DATE,
    P_Carrier_Vehicle_Info.CREATED_BY,
    P_Carrier_Vehicle_Info.LAST_UPDATE_DATE,
    P_Carrier_Vehicle_Info.LAST_UPDATED_BY,
    P_Carrier_Vehicle_Info.LAST_UPDATE_LOGIN
  ) returning rowid into X_ROWID;

Line: 157

     x_procedure := 'Inserting into WSH_CARRIER_VEHICLE_TYPES table';

Line: 172

procedure Update_Carrier_Vehicle_Type (
   P_Carrier_Vehicle_Info          IN  CVTRecType,
   P_ROWID                         IN  VARCHAR2,
   X_RETURN_STATUS                 OUT NOCOPY  VARCHAR2,
   X_EXCEPTION_MSG                 OUT NOCOPY  VARCHAR2,
   X_PROCEDURE                     OUT NOCOPY  VARCHAR2,
   X_POSITION                      OUT NOCOPY  NUMBER,
   X_SQLERR                        OUT NOCOPY  VARCHAR2,
   X_SQL_CODE                      OUT NOCOPY  VARCHAR2
   ) is

   UPDATE_FAILED exception;

Line: 190

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

Line: 257

  update WSH_CARRIER_VEHICLE_TYPES set
    VEHICLE_TYPE_ID     = P_Carrier_Vehicle_Info.VEHICLE_TYPE_ID,
    ASSIGNED_FLAG 	= P_Carrier_Vehicle_Info.ASSIGNED_FLAG,
    ATTRIBUTE_CATEGORY 	= P_Carrier_Vehicle_Info.ATTRIBUTE_CATEGORY,
    ATTRIBUTE1 		= P_Carrier_Vehicle_Info.ATTRIBUTE1,
    ATTRIBUTE2 		= P_Carrier_Vehicle_Info.ATTRIBUTE2,
    ATTRIBUTE3 		= P_Carrier_Vehicle_Info.ATTRIBUTE3,
    ATTRIBUTE4 		= P_Carrier_Vehicle_Info.ATTRIBUTE4,
    ATTRIBUTE5 		= P_Carrier_Vehicle_Info.ATTRIBUTE5,
    ATTRIBUTE6 		= P_Carrier_Vehicle_Info.ATTRIBUTE6,
    ATTRIBUTE7 		= P_Carrier_Vehicle_Info.ATTRIBUTE7,
    ATTRIBUTE8 		= P_Carrier_Vehicle_Info.ATTRIBUTE8,
    ATTRIBUTE9 		= P_Carrier_Vehicle_Info.ATTRIBUTE9,
    ATTRIBUTE10 	= P_Carrier_Vehicle_Info.ATTRIBUTE10,
    ATTRIBUTE11 	= P_Carrier_Vehicle_Info.ATTRIBUTE11,
    ATTRIBUTE12 	= P_Carrier_Vehicle_Info.ATTRIBUTE12,
    ATTRIBUTE13 	= P_Carrier_Vehicle_Info.ATTRIBUTE13,
    ATTRIBUTE14 	= P_Carrier_Vehicle_Info.ATTRIBUTE14,
    ATTRIBUTE15 	= P_Carrier_Vehicle_Info.ATTRIBUTE15,
    LAST_UPDATE_DATE 	= P_Carrier_Vehicle_Info.LAST_UPDATE_DATE,
    LAST_UPDATED_BY 	= P_Carrier_Vehicle_Info.LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN 	= P_Carrier_Vehicle_Info.LAST_UPDATE_LOGIN
  where ROWID = P_ROWID;

Line: 283

    raise UPDATE_FAILED;

Line: 294

   WHEN UPDATE_FAILED THEN
     x_exception_msg := 'Update Failed Exception';

Line: 304

       WSH_DEBUG_SV.logmsg(l_module_name,'UPDATE_FAILED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line: 305

       WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:UPDATE_FAILED');

Line: 323

end Update_Carrier_Vehicle_Type;

Line: 330

  cursor c is select
      VEHICLE_TYPE_ID,
      ASSIGNED_FLAG,
      ATTRIBUTE_CATEGORY,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10,
      ATTRIBUTE11,
      ATTRIBUTE12,
      ATTRIBUTE13,
      ATTRIBUTE14,
      ATTRIBUTE15
    from WSH_CARRIER_VEHICLE_TYPES
    where ROWID = P_ROWID
    for update of CARRIER_ID nowait;

Line: 422

    fnd_message.set_name('FND', 'FORM_RECORD_DELETED');